001 SET echo OFF;
002 set linesize 132;
003 drop table WSUP_data2tag cascade constraints;
004 drop table WSUP_data cascade constraints;
005 create table WSUP_data (
006 WSUP_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NXXSUP number(10),
010 NZZSUP number(10),
011 X0 float(63),
012 THICKN float(63),
013 XXSUP_0 float(63),
014 XXSUP_1 float(63),
015 XXSUP_2 float(63),
016 XXSUP_3 float(63),
017 ZZSUP_0 float(63),
018 ZZSUP_1 float(63),
019 ZZSUP_2 float(63),
020 ZZSUP_3 float(63)
021 ) ;
022
023 alter table WSUP_data add constraint WSUP_data_pk
024 primary key (WSUP_data_id);
025
026 create table WSUP_data2tag (
027 WSUP_vers varchar2(255),
028 WSUP_data_id number(10)
029 ) ;
030
031 alter table WSUP_data2tag add constraint WSUP_data2tag_pk
032 primary key (WSUP_vers, WSUP_data_id);
033 alter table WSUP_data2tag add constraint WSUP_data2tag_vers_fk
034 foreign key (WSUP_vers) references hvs_nodevers (vers_name);
035 alter table WSUP_data2tag add constraint WSUP_data2tag_data_fk
036 foreign key (WSUP_data_id) references WSUP_data (WSUP_data_id);
037
038 delete from hvs_relation where CHILD_NODENAME = 'WSUP';
039 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
040 delete from hvs_nodevers where NODE_NAME = 'WSUP';
041 delete from hvs_node where NODE_NAME = 'WSUP';
042
043 insert into hvs_node values ('WSUP','MuonSpectrometer', '');
044 insert into hvs_nodevers values ('WSUP', 'WSUP-07', '');
045 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
046 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WSUP','WSUP-07');
047 insert into WSUP_data (
048 WSUP_data_id,
049 VERS,
050 JSTA,
051 NXXSUP,
052 NZZSUP,
053 X0,
054 THICKN,
055 XXSUP_0,XXSUP_1,XXSUP_2,XXSUP_3,
056 ZZSUP_0,ZZSUP_1,ZZSUP_2,ZZSUP_3
057 ) values ( 0,
058 7, 1, 2, 1, 0.0000, 0.4000, 0.2000, 9.6000,
059 0.0000, 0.0000, 5.0000, 0.0000, 0.0000, 0.0000
060 );
061 insert into WSUP_data2tag values ('WSUP-07', 0);
062 insert into WSUP_data (
063 WSUP_data_id,
064 VERS,
065 JSTA,
066 NXXSUP,
067 NZZSUP,
068 X0,
069 THICKN,
070 XXSUP_0,XXSUP_1,XXSUP_2,XXSUP_3,
071 ZZSUP_0,ZZSUP_1,ZZSUP_2,ZZSUP_3
072 ) values ( 1,
073 7, 2, 2, 1, 0.0000, 0.4000, 0.2000, 9.6000,
074 0.0000, 0.0000, -5.0000, 0.0000, 0.0000, 0.0000
075 );
076 insert into WSUP_data2tag values ('WSUP-07', 1);
077 insert into WSUP_data (
078 WSUP_data_id,
079 VERS,
080 JSTA,
081 NXXSUP,
082 NZZSUP,
083 X0,
084 THICKN,
085 XXSUP_0,XXSUP_1,XXSUP_2,XXSUP_3,
086 ZZSUP_0,ZZSUP_1,ZZSUP_2,ZZSUP_3
087 ) values ( 2,
088 7, 3, 4, 4, 0.0000, 0.4000, 0.2000, 0.8000,
089 4.6000, 5.0000, 0.2000, 5.0000, 6.4000, 0.4000
090 );
091 insert into WSUP_data2tag values ('WSUP-07', 2);
092
093 comment on column WSUP_data.WSUP_data_id is 'Unique identifier';
094 comment on column WSUP_data.VERS is 'VERSION ';
095 comment on column WSUP_data.JSTA is 'INDEX ';
096 comment on column WSUP_data.NXXSUP is 'MAX NB. FOR X FRAGMENTS ';
097 comment on column WSUP_data.NZZSUP is 'MAX NB. FOR Z FRAGMENTS ';
098 comment on column WSUP_data.X0 is 'X0 ';
099 comment on column WSUP_data.THICKN is 'THICKNESS ';
100 comment on column WSUP_data.XXSUP_0 is 'X DIMENSION ';
101 comment on column WSUP_data.ZZSUP_0 is 'Z DIMENSION ';
| 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.
|
|