001 SET echo OFF;
002 set linesize 132;
003 drop table MSYS_data2tag cascade constraints;
004 drop table MSYS_data cascade constraints;
005 create table MSYS_data (
006 MSYS_data_id number(10),
007 VERS number(10),
008 AMDB varchar2(4),
009 TEST varchar2(4),
010 BAINNRAD float(63),
011 BAINTRAD float(63),
012 BALENGTH float(63),
013 LENGTH float(63),
014 INRADIUS float(63),
015 OURADIUS float(63),
016 ENFRFACE float(63)
017 ) ;
018
019 alter table MSYS_data add constraint MSYS_data_pk
020 primary key (MSYS_data_id);
021
022 create table MSYS_data2tag (
023 MSYS_vers varchar2(255),
024 MSYS_data_id number(10)
025 ) ;
026
027 alter table MSYS_data2tag add constraint MSYS_data2tag_pk
028 primary key (MSYS_vers, MSYS_data_id);
029 alter table MSYS_data2tag add constraint MSYS_data2tag_vers_fk
030 foreign key (MSYS_vers) references hvs_nodevers (vers_name);
031 alter table MSYS_data2tag add constraint MSYS_data2tag_data_fk
032 foreign key (MSYS_data_id) references MSYS_data (MSYS_data_id);
033
034 delete from hvs_relation where CHILD_NODENAME = 'MSYS';
035 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
036 delete from hvs_nodevers where NODE_NAME = 'MSYS';
037 delete from hvs_node where NODE_NAME = 'MSYS';
038
039 insert into hvs_node values ('MSYS','MuonSpectrometer', '');
040 insert into hvs_nodevers values ('MSYS', 'MSYS-07', '');
041 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
042 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','MSYS','MSYS-07');
043 insert into MSYS_data (
044 MSYS_data_id,
045 VERS,
046 AMDB,
047 TEST,
048 BAINNRAD,
049 BAINTRAD,
050 BALENGTH,
051 LENGTH,
052 INRADIUS,
053 OURADIUS,
054 ENFRFACE
055 ) values ( 0,
056 7,'R.01','01', 430.0000, 383.0000, 653.0000, 2180.0000,
057 7.0000, 1300.0000, 674.0000
058 );
059 insert into MSYS_data2tag values ('MSYS-07', 0);
060
061 comment on column MSYS_data.MSYS_data_id is 'Unique identifier';
062 comment on column MSYS_data.VERS is 'VERSION ';
063 comment on column MSYS_data.AMDB is 'AMDB NAME ';
064 comment on column MSYS_data.TEST is 'EXTENSION NAME ';
065 comment on column MSYS_data.BAINNRAD is 'BARREL INNER RADIUS ';
066 comment on column MSYS_data.BAINTRAD is 'BARREL INTERNAL RADIUS ';
067 comment on column MSYS_data.BALENGTH is 'BARREL LENGTH ';
068 comment on column MSYS_data.LENGTH is 'LENGTH ';
069 comment on column MSYS_data.INRADIUS is 'INNER RADIUS ';
070 comment on column MSYS_data.OURADIUS is 'OUTER RADIUS ';
071 comment on column MSYS_data.ENFRFACE is 'ENDCAP FRONT FACE ';
| 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.
|
|