001 SET echo OFF;
002 set linesize 132;
003 drop table GENV_data2tag cascade constraints;
004 drop table GENV_data cascade constraints;
005 create table GENV_data (
006 GENV_data_id number(10),
007 PI float(63),
008 EPS float(63),
009 PIS180 float(63),
010 SI5 float(63),
011 CO5 float(63),
012 TA15 float(63),
013 TA20 float(63),
014 SI225 float(63),
015 CO225 float(63),
016 TA225 float(63),
017 TA375 float(63),
018 SI45 float(63),
019 CO45 float(63),
020 TA45 float(63),
021 SI525 float(63),
022 CO525 float(63),
023 TA55 float(63),
024 SI675 float(63),
025 CO675 float(63),
026 TA675 float(63),
027 TA77 float(63)
028 ) ;
029
030 alter table GENV_data add constraint GENV_data_pk
031 primary key (GENV_data_id);
032
033 create table GENV_data2tag (
034 GENV_vers varchar2(255),
035 GENV_data_id number(10)
036 ) ;
037
038 alter table GENV_data2tag add constraint GENV_data2tag_pk
039 primary key (GENV_vers, GENV_data_id);
040 alter table GENV_data2tag add constraint GENV_data2tag_vers_fk
041 foreign key (GENV_vers) references hvs_nodevers (vers_name);
042 alter table GENV_data2tag add constraint GENV_data2tag_data_fk
043 foreign key (GENV_data_id) references GENV_data (GENV_data_id);
044
045 delete from hvs_relation where CHILD_NODENAME = 'GENV';
046 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
047 delete from hvs_nodevers where NODE_NAME = 'GENV';
048 delete from hvs_node where NODE_NAME = 'GENV';
049
050 insert into hvs_node values ('GENV','MuonSpectrometer', '');
051 insert into hvs_nodevers values ('GENV', 'GENV-01', '');
052 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
053 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','GENV','GENV-01');
054 insert into GENV_data (
055 GENV_data_id,
056 PI,
057 EPS,
058 PIS180,
059 SI5,
060 CO5,
061 TA15,
062 TA20,
063 SI225,
064 CO225,
065 TA225,
066 TA375,
067 SI45,
068 CO45,
069 TA45,
070 SI525,
071 CO525,
072 TA55,
073 SI675,
074 CO675,
075 TA675,
076 TA77
077 ) values ( 1,
078 3.1416, 0.1000, 0.0175, 0.0872, 0.9962, 0.2679,
079 0.3640, 0.3827, 0.9239, 0.4142, 0.7673, 0.7071,
080 0.7071, 1.0000, 0.7934, 0.6088, 1.4281, 0.9239,
081 0.3827, 2.4142, 4.3315
082 );
083 insert into GENV_data2tag values ('GENV-01', 1);
084
085 comment on column GENV_data.GENV_data_id is 'Unique identifier';
086 comment on column GENV_data.PI is 'PI ';
087 comment on column GENV_data.EPS is 'EPS ';
088 comment on column GENV_data.PIS180 is 'PIS180 ';
089 comment on column GENV_data.SI5 is 'SI5 ';
090 comment on column GENV_data.CO5 is 'CO5 ';
091 comment on column GENV_data.TA15 is 'TA15 ';
092 comment on column GENV_data.TA20 is 'TA20 ';
093 comment on column GENV_data.SI225 is 'SI225 ';
094 comment on column GENV_data.CO225 is 'CO225 ';
095 comment on column GENV_data.TA225 is 'TA225 ';
096 comment on column GENV_data.TA375 is 'TA375 ';
097 comment on column GENV_data.SI45 is 'SI45 ';
098 comment on column GENV_data.CO45 is 'CO45 ';
099 comment on column GENV_data.TA45 is 'TA45 ';
100 comment on column GENV_data.SI525 is 'SI525 ';
101 comment on column GENV_data.CO525 is 'CO525 ';
102 comment on column GENV_data.TA55 is 'TA55 ';
103 comment on column GENV_data.SI675 is 'SI675 ';
104 comment on column GENV_data.CO675 is 'CO675 ';
105 comment on column GENV_data.TA675 is 'TA675 ';
106 comment on column GENV_data.TA77 is 'TA77 ';
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems |
This page was automatically generated by the
LXR engine.
|
|