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