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 ) ;
067
068 alter table DBAM_data add constraint DBAM_data_pk
069 primary key (DBAM_data_id);
070
071 create table DBAM_data2tag (
072 DBAM_vers varchar2(255),
073 DBAM_data_id number(10)
074 ) ;
075
076 alter table DBAM_data2tag add constraint DBAM_data2tag_pk
077 primary key (DBAM_vers, DBAM_data_id);
078 alter table DBAM_data2tag add constraint DBAM_data2tag_vers_fk
079 foreign key (DBAM_vers) references hvs_nodevers (vers_name);
080 alter table DBAM_data2tag add constraint DBAM_data2tag_data_fk
081 foreign key (DBAM_data_id) references DBAM_data (DBAM_data_id);
082
083 delete from hvs_relation where CHILD_NODENAME = 'DBAM';
084 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
085 delete from hvs_nodevers where NODE_NAME = 'DBAM';
086 delete from hvs_node where NODE_NAME = 'DBAM';
087
088 insert into hvs_node values ('DBAM','MuonSpectrometer', '');
089 insert into hvs_nodevers values ('DBAM', 'DBAM-07', '');
090 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
091 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','DBAM','DBAM-07');
092 insert into DBAM_data (
093 DBAM_data_id,
094 VERS,
095 NVRS,
096 AMDB,
097 TEST,
098 MTYP,
099 NAME_0,NAME_1,NAME_2,NAME_3,NAME_4,NAME_5,NAME_6,NAME_7,NAME_8,NAME_9,NAME_10,
100 NAME_11,NAME_12,NAME_13,NAME_14,NAME_15,NAME_16,NAME_17,NAME_18,NAME_19,NAME_20,
101 NAME_21,NAME_22,NAME_23,NAME_24,NAME_25,NAME_26,NAME_27,NAME_28,NAME_29,NAME_30,
102 NAME_31,NAME_32,NAME_33,NAME_34,NAME_35,NAME_36,NAME_37,NAME_38,NAME_39,NAME_40,
103 NAME_41,NAME_42,NAME_43,NAME_44,NAME_45,NAME_46,NAME_47,NAME_48,NAME_49,NAME_50,
104 NAME_51,NAME_52,
105 NUMBOX
106 ) values ( 0,
107 7, 7,'R.01','01', 53,'BIL','BIS','BML','BMS','BOL','BOS','BEE',
108 'BIR','BMF','BOF','BOG','BOH','EIC','EIL','EEL','EES','EMC','EML','EMS','EOC',
109 'EOL','EOS','T1C','T1L','T1S','T2C','T2L','T2S','T3C','T3L','T3S','CI1','CI2',
110 'CI3','CI4','FIL','FIS','FML','FMS','FOL','FOS','T1F','T1E','T2F','T2E','T3F',
111 'T3E','T4F','T4E','EIS','CSS','CSL','BIM', 63000
112 );
113 insert into DBAM_data2tag values ('DBAM-07', 0);
114
115 comment on column DBAM_data.DBAM_data_id is 'Unique identifier';
116 comment on column DBAM_data.VERS is 'VERSION ';
117 comment on column DBAM_data.NVRS is 'VERSION OF READING ';
118 comment on column DBAM_data.AMDB is 'AMDB NAME ';
119 comment on column DBAM_data.TEST is 'TEST NAME ';
120 comment on column DBAM_data.MTYP is 'MAXIMUM STATION NUMBER ';
121 comment on column DBAM_data.NAME_0 is 'STATION NAME ';
122 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.
|
|