001 SET echo OFF;
002 set linesize 132;
003 drop table WCSC_data2tag cascade constraints;
004 drop table WCSC_data cascade constraints;
005 create table WCSC_data (
006 WCSC_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 LAYCSC number(10),
010 TTOTAL float(63),
011 TNOMEX float(63),
012 TLAG10 float(63),
013 WISPA float(63),
014 DANCAT float(63),
015 PCATRE float(63),
016 AZCAT float(63),
017 GSTRIP float(63),
018 WRESTR float(63),
019 WFLSTR float(63),
020 TRRWAS float(63),
021 WROXA float(63),
022 GROXWI float(63),
023 WGASBA float(63),
024 TGASBA float(63),
025 WGASCU float(63),
026 TGASCU float(63),
027 WFIXWI float(63),
028 TFIXWI float(63),
029 PBA1WI float(63),
030 PBA2WI float(63),
031 PBA3WI float(63),
032 PSNDCO float(63)
033 ) ;
034
035 alter table WCSC_data add constraint WCSC_data_pk
036 primary key (WCSC_data_id);
037
038 create table WCSC_data2tag (
039 WCSC_vers varchar2(255),
040 WCSC_data_id number(10)
041 ) ;
042
043 alter table WCSC_data2tag add constraint WCSC_data2tag_pk
044 primary key (WCSC_vers, WCSC_data_id);
045 alter table WCSC_data2tag add constraint WCSC_data2tag_vers_fk
046 foreign key (WCSC_vers) references hvs_nodevers (vers_name);
047 alter table WCSC_data2tag add constraint WCSC_data2tag_data_fk
048 foreign key (WCSC_data_id) references WCSC_data (WCSC_data_id);
049
050 delete from hvs_relation where CHILD_NODENAME = 'WCSC';
051 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
052 delete from hvs_nodevers where NODE_NAME = 'WCSC';
053 delete from hvs_node where NODE_NAME = 'WCSC';
054
055 insert into hvs_node values ('WCSC','MuonSpectrometer', '');
056 insert into hvs_nodevers values ('WCSC', 'WCSC-07', '');
057 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
058 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WCSC','WCSC-07');
059 insert into WCSC_data (
060 WCSC_data_id,
061 VERS,
062 JSTA,
063 LAYCSC,
064 TTOTAL,
065 TNOMEX,
066 TLAG10,
067 WISPA,
068 DANCAT,
069 PCATRE,
070 AZCAT,
071 GSTRIP,
072 WRESTR,
073 WFLSTR,
074 TRRWAS,
075 WROXA,
076 GROXWI,
077 WGASBA,
078 TGASBA,
079 WGASCU,
080 TGASCU,
081 WFIXWI,
082 TFIXWI,
083 PBA1WI,
084 PBA2WI,
085 PBA3WI,
086 PSNDCO
087 ) values ( 0,
088 7, 1, 4, 12.3500, 1.9050, 0.0820, 0.2500,
089 0.2500, 0.5560, 1.2920, 0.0250, 0.1600, 1.2520,
090 0.0017, 0.4800, 0.1500, 0.5000, 2.0300, 0.7620,
091 0.1500, 2.2860, 0.2500, 3.2100, 2.0300, 1.1800,
092 0.0000
093 );
094 insert into WCSC_data2tag values ('WCSC-07', 0);
095 insert into WCSC_data (
096 WCSC_data_id,
097 VERS,
098 JSTA,
099 LAYCSC,
100 TTOTAL,
101 TNOMEX,
102 TLAG10,
103 WISPA,
104 DANCAT,
105 PCATRE,
106 AZCAT,
107 GSTRIP,
108 WRESTR,
109 WFLSTR,
110 TRRWAS,
111 WROXA,
112 GROXWI,
113 WGASBA,
114 TGASBA,
115 WGASCU,
116 TGASCU,
117 WFIXWI,
118 TFIXWI,
119 PBA1WI,
120 PBA2WI,
121 PBA3WI,
122 PSNDCO
123 ) values ( 1,
124 7, 2, 4, 12.3500, 1.9050, 0.0820, 0.2500,
125 0.2500, 0.5310, 2.1000, 0.0250, 0.1520, 2.0600,
126 0.0017, 0.4800, 0.1500, 0.5000, 2.0300, 0.7620,
127 0.1500, 2.2860, 0.2500, 3.2100, 2.0300, 1.1800,
128 0.0000
129 );
130 insert into WCSC_data2tag values ('WCSC-07', 1);
131
132 comment on column WCSC_data.WCSC_data_id is 'Unique identifier';
133 comment on column WCSC_data.VERS is 'VERSION ';
134 comment on column WCSC_data.JSTA is 'JSTA TYPE NUMBER ';
135 comment on column WCSC_data.LAYCSC is 'NBER OF CSCS LAYERS ';
136 comment on column WCSC_data.TTOTAL is 'TOTAL THICKNESS ';
137 comment on column WCSC_data.TNOMEX is 'NOMEX HONEYCOMB THICKNESS ';
138 comment on column WCSC_data.TLAG10 is 'G10 LAMINATES THICKNESS ';
139 comment on column WCSC_data.WISPA is 'WIRE SPACING ';
140 comment on column WCSC_data.DANCAT is 'ANODE-CATHODE DISTANCE ';
141 comment on column WCSC_data.PCATRE is 'CATHODE READOUT PITCH ';
142 comment on column WCSC_data.AZCAT is 'CATHODE READOUT PITCH, AZIMUTAL ';
143 comment on column WCSC_data.GSTRIP is 'GAP BETWEEN CATHODE STRIPS ';
144 comment on column WCSC_data.WRESTR is 'WIDTH OF READOUT STRIPS ';
145 comment on column WCSC_data.WFLSTR is 'WIDTH OF FLOATING STRIPS ';
146 comment on column WCSC_data.TRRWAS is 'RIGIT RECTANGULAR WASHER THICKNES ';
147 comment on column WCSC_data.WROXA is 'ROXACELL WIDTH ';
148 comment on column WCSC_data.GROXWI is 'ROXACELL AND WIRE BAR GAP ';
149 comment on column WCSC_data.WGASBA is 'FULL GAS GAP BAR WIDTH ';
150 comment on column WCSC_data.TGASBA is 'FULL GAS GAP BAR THICK. ';
151 comment on column WCSC_data.WGASCU is 'CUTS GAS GAP BAR WIDTH ';
152 comment on column WCSC_data.TGASCU is 'CUTS GAS GAP BAR THICK. ';
153 comment on column WCSC_data.WFIXWI is 'FULL WIRE FIX. BAR WID. ';
154 comment on column WCSC_data.TFIXWI is 'FULL WIRE FIX. BAR THICK. ';
155 comment on column WCSC_data.PBA1WI is 'WIRE BAR POSITION ';
156 comment on column WCSC_data.PBA2WI is 'WIRE BAR POSITION ';
157 comment on column WCSC_data.PBA3WI is 'WIRE BAR POSITION ';
158 comment on column WCSC_data.PSNDCO is '2ND COORDINATE PITCH ';
| 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.
|
|