001 SET echo OFF;
002 set linesize 132;
003 drop table WSPA_data2tag cascade constraints;
004 drop table WSPA_data cascade constraints;
005 create table WSPA_data (
006 WSPA_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NB number(10),
010 X0 float(63),
011 TCKSPA float(63)
012 ) ;
013
014 alter table WSPA_data add constraint WSPA_data_pk
015 primary key (WSPA_data_id);
016
017 create table WSPA_data2tag (
018 WSPA_vers varchar2(255),
019 WSPA_data_id number(10)
020 ) ;
021
022 alter table WSPA_data2tag add constraint WSPA_data2tag_pk
023 primary key (WSPA_vers, WSPA_data_id);
024 alter table WSPA_data2tag add constraint WSPA_data2tag_vers_fk
025 foreign key (WSPA_vers) references hvs_nodevers (vers_name);
026 alter table WSPA_data2tag add constraint WSPA_data2tag_data_fk
027 foreign key (WSPA_data_id) references WSPA_data (WSPA_data_id);
028
029 delete from hvs_relation where CHILD_NODENAME = 'WSPA';
030 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
031 delete from hvs_nodevers where NODE_NAME = 'WSPA';
032 delete from hvs_node where NODE_NAME = 'WSPA';
033
034 insert into hvs_node values ('WSPA','MuonSpectrometer', '');
035 insert into hvs_nodevers values ('WSPA', 'WSPA-07', '');
036 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
037 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WSPA','WSPA-07');
038 insert into WSPA_data (
039 WSPA_data_id,
040 VERS,
041 JSTA,
042 NB,
043 X0,
044 TCKSPA
045 ) values ( 0,
046 7, 1, 1, 0.0010, 0.6500
047 );
048 insert into WSPA_data2tag values ('WSPA-07', 0);
049 insert into WSPA_data (
050 WSPA_data_id,
051 VERS,
052 JSTA,
053 NB,
054 X0,
055 TCKSPA
056 ) values ( 1,
057 7, 2, 1, 0.0010, 17.0000
058 );
059 insert into WSPA_data2tag values ('WSPA-07', 1);
060 insert into WSPA_data (
061 WSPA_data_id,
062 VERS,
063 JSTA,
064 NB,
065 X0,
066 TCKSPA
067 ) values ( 2,
068 7, 3, 1, 0.0010, 22.0000
069 );
070 insert into WSPA_data2tag values ('WSPA-07', 2);
071 insert into WSPA_data (
072 WSPA_data_id,
073 VERS,
074 JSTA,
075 NB,
076 X0,
077 TCKSPA
078 ) values ( 3,
079 7, 4, 1, 0.0010, 31.7000
080 );
081 insert into WSPA_data2tag values ('WSPA-07', 3);
082 insert into WSPA_data (
083 WSPA_data_id,
084 VERS,
085 JSTA,
086 NB,
087 X0,
088 TCKSPA
089 ) values ( 4,
090 7, 5, 1, 0.0010, 12.1000
091 );
092 insert into WSPA_data2tag values ('WSPA-07', 4);
093 insert into WSPA_data (
094 WSPA_data_id,
095 VERS,
096 JSTA,
097 NB,
098 X0,
099 TCKSPA
100 ) values ( 5,
101 7, 6, 1, 0.0010, 3.9100
102 );
103 insert into WSPA_data2tag values ('WSPA-07', 5);
104
105 comment on column WSPA_data.WSPA_data_id is 'Unique identifier';
106 comment on column WSPA_data.VERS is 'VERSION ';
107 comment on column WSPA_data.JSTA is 'JSTA INDEX ';
108 comment on column WSPA_data.NB is 'NUMBER OF DETAILS ';
109 comment on column WSPA_data.X0 is 'X0 ';
110 comment on column WSPA_data.TCKSPA is 'THICKNESS OF SPACER ';
| 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.
|
|