001 SET echo OFF;
002 set linesize 132;
003 drop table DBAM_data2tag cascade constraints;
004 drop table DBAM_data cascade constraints;
005 create table DBAM_data (
006 DBAM_data_id number(10),
007 VERS number(10),
008 NVRS number(10),
009 AMDB varchar2(4),
010 TEST varchar2(4),
011 MTYP number(10),
012 NAME_0 varchar2(4),
013 NAME_1 varchar2(4),
014 NAME_2 varchar2(4),
015 NAME_3 varchar2(4),
016 NAME_4 varchar2(4),
017 NAME_5 varchar2(4),
018 NAME_6 varchar2(4),
019 NAME_7 varchar2(4),
020 NAME_8 varchar2(4),
021 NAME_9 varchar2(4),
022 NAME_10 varchar2(4),
023 NAME_11 varchar2(4),
024 NAME_12 varchar2(4),
025 NAME_13 varchar2(4),
026 NAME_14 varchar2(4),
027 NAME_15 varchar2(4),
028 NAME_16 varchar2(4),
029 NAME_17 varchar2(4),
030 NAME_18 varchar2(4),
031 NAME_19 varchar2(4),
032 NAME_20 varchar2(4),
033 NAME_21 varchar2(4),
034 NAME_22 varchar2(4),
035 NAME_23 varchar2(4),
036 NAME_24 varchar2(4),
037 NAME_25 varchar2(4),
038 NAME_26 varchar2(4),
039 NAME_27 varchar2(4),
040 NAME_28 varchar2(4),
041 NAME_29 varchar2(4),
042 NAME_30 varchar2(4),
043 NAME_31 varchar2(4),
044 NAME_32 varchar2(4),
045 NAME_33 varchar2(4),
046 NAME_34 varchar2(4),
047 NAME_35 varchar2(4),
048 NAME_36 varchar2(4),
049 NAME_37 varchar2(4),
050 NAME_38 varchar2(4),
051 NAME_39 varchar2(4),
052 NAME_40 varchar2(4),
053 NAME_41 varchar2(4),
054 NAME_42 varchar2(4),
055 NAME_43 varchar2(4),
056 NAME_44 varchar2(4),
057 NAME_45 varchar2(4),
058 NAME_46 varchar2(4),
059 NAME_47 varchar2(4),
060 NAME_48 varchar2(4),
061 NAME_49 varchar2(4),
062 NAME_50 varchar2(4),
063 NAME_51 varchar2(4),
064 NAME_52 varchar2(4),
065 NUMBOX number(10)
066 ) tablespace data02;
067
068 alter table DBAM_data add constraint DBAM_data_pk
069 primary key (DBAM_data_id)
070 using index tablespace indx02;
071
072 create table DBAM_data2tag (
073 DBAM_vers varchar2(255),
074 DBAM_data_id number(10)
075 ) tablespace data02;
076
077 alter table DBAM_data2tag add constraint DBAM_data2tag_pk
078 primary key (DBAM_vers, DBAM_data_id)
079 using index tablespace indx02;
080 alter table DBAM_data2tag add constraint DBAM_data2tag_vers_fk
081 foreign key (DBAM_vers) references hvs_nodevers (vers_name);
082 alter table DBAM_data2tag add constraint DBAM_data2tag_data_fk
083 foreign key (DBAM_data_id) references DBAM_data (DBAM_data_id);
084
085 delete from hvs_relation where CHILD_NODENAME = 'DBAM';
086 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
087 delete from hvs_nodevers where NODE_NAME = 'DBAM';
088 delete from hvs_node where NODE_NAME = 'DBAM';
089
090 insert into hvs_node values ('DBAM','MuonSpectrometer', '');
091 insert into hvs_nodevers values ('DBAM', 'DBAM-07', '');
092 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
093 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','DBAM','DBAM-07');
094 insert into DBAM_data (
095 DBAM_data_id,
096 VERS,
097 NVRS,
098 AMDB,
099 TEST,
100 MTYP,
101 NAME_0,NAME_1,NAME_2,NAME_3,NAME_4,NAME_5,NAME_6,NAME_7,NAME_8,NAME_9,NAME_10,
102 NAME_11,NAME_12,NAME_13,NAME_14,NAME_15,NAME_16,NAME_17,NAME_18,NAME_19,NAME_20,
103 NAME_21,NAME_22,NAME_23,NAME_24,NAME_25,NAME_26,NAME_27,NAME_28,NAME_29,NAME_30,
104 NAME_31,NAME_32,NAME_33,NAME_34,NAME_35,NAME_36,NAME_37,NAME_38,NAME_39,NAME_40,
105 NAME_41,NAME_42,NAME_43,NAME_44,NAME_45,NAME_46,NAME_47,NAME_48,NAME_49,NAME_50,
106 NAME_51,NAME_52,
107 NUMBOX
108 ) values ( 0,
109 7, 7,'R.01','Cosmics_Barrel_sector13.v01',53,
110 'BIL','BIS','BML','BMS','BOL','BOS','BEE',
111 'BIR','BMF','BOF','BOG','BOH','EIC','EIL','EEL','EES','EMC','EML','EMS','EOC',
112 'EOL','EOS','T1C','T1L','T1S','T2C','T2L','T2S','T3C','T3L','T3S','CI1','CI2',
113 'CI3','CI4','FIL','FIS','FML','FMS','FOL','FOS','T1F','T1E','T2F','T2E','T3F',
114 'T3E','T4F','T4E','EIS','CSS','CSL','BIM', 63000
115 );
116 insert into DBAM_data2tag values ('DBAM-07', 0);
117
118 comment on column DBAM_data.DBAM_data_id is 'Unique identifier';
119 comment on column DBAM_data.VERS is 'VERSION ';
120 comment on column DBAM_data.NVRS is 'VERSION OF READING ';
121 comment on column DBAM_data.AMDB is 'AMDB NAME ';
122 comment on column DBAM_data.TEST is 'TEST NAME ';
123 comment on column DBAM_data.MTYP is 'MAXIMUM STATION NUMBER ';
124 comment on column DBAM_data.NAME is 'STATION NAME ';
125 comment on column DBAM_data.NUMBOX is 'FILE INDEX ';
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.
|
|