001 SET echo OFF;
002 set linesize 132;
003 drop table WRPC_data2tag cascade constraints;
004 drop table WRPC_data cascade constraints;
005 create table WRPC_data (
006 WRPC_data_id number(10),
007 VERS number(10),
008 NVRS number(10),
009 LAYRPC number(10),
010 TCKRLA float(63),
011 TOTTCK float(63),
012 TCKFSP float(63),
013 ACKFSP float(63),
014 TLOHCB float(63),
015 ALOHCB float(63),
016 TCKBAK float(63),
017 TCKGAS float(63),
018 TCKSSU float(63),
019 TCKSTR float(63),
020 SDEDMI float(63),
021 ZDEDMI float(63),
022 SPDIAM float(63),
023 SPPITC float(63),
024 STROFF_0 float(63),
025 STROFF_1 float(63),
026 STROFF_2 float(63)
027 ) ;
028
029 alter table WRPC_data add constraint WRPC_data_pk
030 primary key (WRPC_data_id);
031
032 create table WRPC_data2tag (
033 WRPC_vers varchar2(255),
034 WRPC_data_id number(10)
035 ) ;
036
037 alter table WRPC_data2tag add constraint WRPC_data2tag_pk
038 primary key (WRPC_vers, WRPC_data_id);
039 alter table WRPC_data2tag add constraint WRPC_data2tag_vers_fk
040 foreign key (WRPC_vers) references hvs_nodevers (vers_name);
041 alter table WRPC_data2tag add constraint WRPC_data2tag_data_fk
042 foreign key (WRPC_data_id) references WRPC_data (WRPC_data_id);
043
044 delete from hvs_relation where CHILD_NODENAME = 'WRPC';
045 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
046 delete from hvs_nodevers where NODE_NAME = 'WRPC';
047 delete from hvs_node where NODE_NAME = 'WRPC';
048
049 insert into hvs_node values ('WRPC','MuonSpectrometer', '');
050 insert into hvs_nodevers values ('WRPC', 'WRPC-07', '');
051 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
052 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WRPC','WRPC-07');
053 insert into WRPC_data (
054 WRPC_data_id,
055 VERS,
056 NVRS,
057 LAYRPC,
058 TCKRLA,
059 TOTTCK,
060 TCKFSP,
061 ACKFSP,
062 TLOHCB,
063 ALOHCB,
064 TCKBAK,
065 TCKGAS,
066 TCKSSU,
067 TCKSTR,
068 SDEDMI,
069 ZDEDMI,
070 SPDIAM,
071 SPPITC,
072 STROFF_0,STROFF_1,STROFF_2
073 ) values ( 0,
074 7, 2, 2, 1.3700, 4.6000, 0.8600, 0.0100,
075 1.0000, 0.0300, 0.2000, 0.2000, 0.3000, 0.0040,
076 1.8000, 0.0000, 1.2000, 10.0000, 0.5000, 0.5000,
077 0.0000
078 );
079 insert into WRPC_data2tag values ('WRPC-07', 0);
080
081 comment on column WRPC_data.WRPC_data_id is 'Unique identifier';
082 comment on column WRPC_data.VERS is 'VERSION ';
083 comment on column WRPC_data.NVRS is 'VERSION OF RPC TECHNOLOGY ';
084 comment on column WRPC_data.LAYRPC is 'LAYERS NUMBER ';
085 comment on column WRPC_data.TCKRLA is 'THICK. OF AN RPC LAYER ';
086 comment on column WRPC_data.TOTTCK is 'TOTAL THICKNESS ';
087 comment on column WRPC_data.TCKFSP is 'THICK. OF FOAM SPACER ';
088 comment on column WRPC_data.ACKFSP is 'THICK. OF AL PLATE OF FOAM SPACER ';
089 comment on column WRPC_data.TLOHCB is 'THICK. OF LOWER HONEYCOMB ';
090 comment on column WRPC_data.ALOHCB is 'THICK. OF AL PLATE OF LOWER HONEYCOMB ';
091 comment on column WRPC_data.TCKBAK is 'THICK. OF BAKELITE ';
092 comment on column WRPC_data.TCKGAS is 'THICK. OF GAS GAP ';
093 comment on column WRPC_data.TCKSSU is 'THICK. OF STRIPS SUPPORT ';
094 comment on column WRPC_data.TCKSTR is 'THICK. OF STRIPS ';
095 comment on column WRPC_data.SDEDMI is 'S INTERNAL MID-CHBER DEAD REGION ';
096 comment on column WRPC_data.ZDEDMI is 'Z INTERNAL MID-CHBER DEAD REGION ';
097 comment on column WRPC_data.SPDIAM is 'SPACER DIAMETER ';
098 comment on column WRPC_data.SPPITC is 'SPACER PITCH ';
099 comment on column WRPC_data.STROFF_0 is 'STRIP OFFSET S, FIRST Z, SECOND Z ';
| 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.
|
|