001 SET echo OFF;
002 set linesize 132;
003 drop table WDED_data2tag cascade constraints;
004 drop table WDED_data cascade constraints;
005 create table WDED_data (
006 WDED_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NB number(10),
010 X0 float(63),
011 AUPHCB float(63),
012 TCKDED float(63)
013 ) ;
014
015 alter table WDED_data add constraint WDED_data_pk
016 primary key (WDED_data_id);
017
018 create table WDED_data2tag (
019 WDED_vers varchar2(255),
020 WDED_data_id number(10)
021 ) ;
022
023 alter table WDED_data2tag add constraint WDED_data2tag_pk
024 primary key (WDED_vers, WDED_data_id);
025 alter table WDED_data2tag add constraint WDED_data2tag_vers_fk
026 foreign key (WDED_vers) references hvs_nodevers (vers_name);
027 alter table WDED_data2tag add constraint WDED_data2tag_data_fk
028 foreign key (WDED_data_id) references WDED_data (WDED_data_id);
029
030 delete from hvs_relation where CHILD_NODENAME = 'WDED';
031 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
032 delete from hvs_nodevers where NODE_NAME = 'WDED';
033 delete from hvs_node where NODE_NAME = 'WDED';
034
035 insert into hvs_node values ('WDED','MuonSpectrometer', '');
036 insert into hvs_nodevers values ('WDED', 'WDED-07', '');
037 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
038 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WDED','WDED-07');
039 insert into WDED_data (
040 WDED_data_id,
041 VERS,
042 JSTA,
043 NB,
044 X0,
045 AUPHCB,
046 TCKDED
047 ) values ( 0,
048 7, 1, 1, 0.0010, 5.0000, 0.0300
049 );
050 insert into WDED_data2tag values ('WDED-07', 0);
051 insert into WDED_data (
052 WDED_data_id,
053 VERS,
054 JSTA,
055 NB,
056 X0,
057 AUPHCB,
058 TCKDED
059 ) values ( 1,
060 7, 2, 1, 0.0010, 6.0000, 0.0300
061 );
062 insert into WDED_data2tag values ('WDED-07', 1);
063
064 comment on column WDED_data.WDED_data_id is 'Unique identifier';
065 comment on column WDED_data.VERS is 'VERSION ';
066 comment on column WDED_data.JSTA is 'INDEX ';
067 comment on column WDED_data.NB is 'NUMBER OF DETAILS ';
068 comment on column WDED_data.X0 is 'X0 ';
069 comment on column WDED_data.AUPHCB is 'HONEYCOMB THICKNESS ';
070 comment on column WDED_data.TCKDED is 'ALUMINIUM THICKNESS ';
| 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.
|
|