001 SET echo OFF;
002 set linesize 132;
003 drop table WCRO_data2tag cascade constraints;
004 drop table WCRO_data cascade constraints;
005 create table WCRO_data (
006 WCRO_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NUM number(10),
010 HEIGHTNESS float(63),
011 LARGENESS float(63),
012 THICKNESS float(63)
013 ) tablespace data02;
014
015 alter table WCRO_data add constraint WCRO_data_pk
016 primary key (WCRO_data_id)
017 using index tablespace indx02;
018
019 create table WCRO_data2tag (
020 WCRO_vers varchar2(255),
021 WCRO_data_id number(10)
022 ) tablespace data02;
023
024 alter table WCRO_data2tag add constraint WCRO_data2tag_pk
025 primary key (WCRO_vers, WCRO_data_id)
026 using index tablespace indx02;
027 alter table WCRO_data2tag add constraint WCRO_data2tag_vers_fk
028 foreign key (WCRO_vers) references hvs_nodevers (vers_name);
029 alter table WCRO_data2tag add constraint WCRO_data2tag_data_fk
030 foreign key (WCRO_data_id) references WCRO_data (WCRO_data_id);
031
032 delete from hvs_relation where CHILD_NODENAME = 'WCRO';
033 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
034 delete from hvs_nodevers where NODE_NAME = 'WCRO';
035 delete from hvs_node where NODE_NAME = 'WCRO';
036
037 insert into hvs_node values ('WCRO','MuonSpectrometer', '');
038 insert into hvs_nodevers values ('WCRO', 'WCRO-07', '');
039 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
040 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WCRO','WCRO-07');
041 insert into WCRO_data (
042 WCRO_data_id,
043 VERS,
044 JSTA,
045 NUM,
046 HEIGHTNESS,
047 LARGENESS,
048 THICKNESS
049 ) values ( 0,
050 7, 1, 1, 17.0000, 6.0000, 0.6000
051 );
052 insert into WCRO_data2tag values ('WCRO-07', 0);
053 insert into WCRO_data (
054 WCRO_data_id,
055 VERS,
056 JSTA,
057 NUM,
058 HEIGHTNESS,
059 LARGENESS,
060 THICKNESS
061 ) values ( 1,
062 7, 2, 1, 31.7000, 6.0000, 0.6000
063 );
064 insert into WCRO_data2tag values ('WCRO-07', 1);
065 insert into WCRO_data (
066 WCRO_data_id,
067 VERS,
068 JSTA,
069 NUM,
070 HEIGHTNESS,
071 LARGENESS,
072 THICKNESS
073 ) values ( 2,
074 7, 3, 1, 5.5000, 0.0000, 0.0000
075 );
076 insert into WCRO_data2tag values ('WCRO-07', 2);
077 insert into WCRO_data (
078 WCRO_data_id,
079 VERS,
080 JSTA,
081 NUM,
082 HEIGHTNESS,
083 LARGENESS,
084 THICKNESS
085 ) values ( 3,
086 7, 4, 1, 12.1000, 6.0000, 0.6000
087 );
088 insert into WCRO_data2tag values ('WCRO-07', 3);
089
090 comment on column WCRO_data.WCRO_data_id is 'Unique identifier';
091 comment on column WCRO_data.VERS is 'VERSION ';
092 comment on column WCRO_data.JSTA is 'INDEX ';
093 comment on column WCRO_data.NUM is 'NUMBER OF OBJECTS ';
094 comment on column WCRO_data.HEIGHTNESS is 'HEIGHT ';
095 comment on column WCRO_data.LARGENESS is 'T-SHAPE LARGENESS ';
096 comment on column WCRO_data.THICKNESS is 'T-SHAPE 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.
|
|