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