001 SET echo OFF;
002 set linesize 132;
003 drop table WLBI_data2tag cascade constraints;
004 drop table WLBI_data cascade constraints;
005 create table WLBI_data (
006 WLBI_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NUM number(10),
010 HEIGHT float(63),
011 THICKNESS float(63)
012 ) ;
013
014 alter table WLBI_data add constraint WLBI_data_pk
015 primary key (WLBI_data_id);
016
017 create table WLBI_data2tag (
018 WLBI_vers varchar2(255),
019 WLBI_data_id number(10)
020 ) ;
021
022 alter table WLBI_data2tag add constraint WLBI_data2tag_pk
023 primary key (WLBI_vers, WLBI_data_id);
024 alter table WLBI_data2tag add constraint WLBI_data2tag_vers_fk
025 foreign key (WLBI_vers) references hvs_nodevers (vers_name);
026 alter table WLBI_data2tag add constraint WLBI_data2tag_data_fk
027 foreign key (WLBI_data_id) references WLBI_data (WLBI_data_id);
028
029 delete from hvs_relation where CHILD_NODENAME = 'WLBI';
030 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
031 delete from hvs_nodevers where NODE_NAME = 'WLBI';
032 delete from hvs_node where NODE_NAME = 'WLBI';
033
034 insert into hvs_node values ('WLBI','MuonSpectrometer', '');
035 insert into hvs_nodevers values ('WLBI', 'WLBI-07', '');
036 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
037 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WLBI','WLBI-07');
038 insert into WLBI_data (
039 WLBI_data_id,
040 VERS,
041 JSTA,
042 NUM,
043 HEIGHT,
044 THICKNESS
045 ) values ( 0,
046 7, 1, 1, 7.5000, 0.4000
047 );
048 insert into WLBI_data2tag values ('WLBI-07', 0);
049 insert into WLBI_data (
050 WLBI_data_id,
051 VERS,
052 JSTA,
053 NUM,
054 HEIGHT,
055 THICKNESS
056 ) values ( 1,
057 7, 2, 1, 15.0000, 0.4000
058 );
059 insert into WLBI_data2tag values ('WLBI-07', 1);
060 insert into WLBI_data (
061 WLBI_data_id,
062 VERS,
063 JSTA,
064 NUM,
065 HEIGHT,
066 THICKNESS
067 ) values ( 2,
068 7, 3, 1, 12.9400, 0.3000
069 );
070 insert into WLBI_data2tag values ('WLBI-07', 2);
071 insert into WLBI_data (
072 WLBI_data_id,
073 VERS,
074 JSTA,
075 NUM,
076 HEIGHT,
077 THICKNESS
078 ) values ( 3,
079 7, 4, 1, 8.0400, 0.3000
080 );
081 insert into WLBI_data2tag values ('WLBI-07', 3);
082
083 comment on column WLBI_data.WLBI_data_id is 'Unique identifier';
084 comment on column WLBI_data.VERS is 'VERSION ';
085 comment on column WLBI_data.JSTA is 'INDEX ';
086 comment on column WLBI_data.NUM is 'NUMBER OF OBJECTS ';
087 comment on column WLBI_data.HEIGHT is 'HEIGHT ';
088 comment on column WLBI_data.THICKNESS is 'WALL 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.
|
|