001 SET echo OFF;
002 set linesize 132;
003 drop table WTGC_data2tag cascade constraints;
004 drop table WTGC_data cascade constraints;
005 create table WTGC_data (
006 WTGC_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 NBEVOL number(10),
010 X0 float(63),
011 WIDCHB float(63),
012 FWIRCH float(63),
013 FWIXCH float(63),
014 ALLNAME_0 varchar2(4),
015 ALLNAME_1 varchar2(4),
016 ALLNAME_2 varchar2(4),
017 ALLNAME_3 varchar2(4),
018 ALLNAME_4 varchar2(4),
019 ALLNAME_5 varchar2(4),
020 ALLNAME_6 varchar2(4),
021 ALLNAME_7 varchar2(4),
022 ALLNAME_8 varchar2(4)
023 ) ;
024
025 alter table WTGC_data add constraint WTGC_data_pk
026 primary key (WTGC_data_id);
027
028 create table WTGC_data2tag (
029 WTGC_vers varchar2(255),
030 WTGC_data_id number(10)
031 ) ;
032
033 alter table WTGC_data2tag add constraint WTGC_data2tag_pk
034 primary key (WTGC_vers, WTGC_data_id);
035 alter table WTGC_data2tag add constraint WTGC_data2tag_vers_fk
036 foreign key (WTGC_vers) references hvs_nodevers (vers_name);
037 alter table WTGC_data2tag add constraint WTGC_data2tag_data_fk
038 foreign key (WTGC_data_id) references WTGC_data (WTGC_data_id);
039
040 delete from hvs_relation where CHILD_NODENAME = 'WTGC';
041 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
042 delete from hvs_nodevers where NODE_NAME = 'WTGC';
043 delete from hvs_node where NODE_NAME = 'WTGC';
044
045 insert into hvs_node values ('WTGC','MuonSpectrometer', '');
046 insert into hvs_nodevers values ('WTGC', 'WTGC-07', '');
047 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
048 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WTGC','WTGC-07');
049 insert into WTGC_data (
050 WTGC_data_id,
051 VERS,
052 JSTA,
053 NBEVOL,
054 X0,
055 WIDCHB,
056 FWIRCH,
057 FWIXCH,
058 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
059 ALLNAME_8
060 ) values ( 0,
061 7, 1, 15, 0.1300, 7.0000, 2.0000, 2.4000,
062 'Gas','G10','Hone','Copp','Carb','','','',''
063 );
064 insert into WTGC_data2tag values ('WTGC-07', 0);
065 insert into WTGC_data (
066 WTGC_data_id,
067 VERS,
068 JSTA,
069 NBEVOL,
070 X0,
071 WIDCHB,
072 FWIRCH,
073 FWIXCH,
074 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
075 ALLNAME_8
076 ) values ( 1,
077 7, 2, 15, 0.1300, 7.0000, 2.0000, 2.4000,
078 'Gas','G10','Hone','Copp','Carb','','','',''
079 );
080 insert into WTGC_data2tag values ('WTGC-07', 1);
081 insert into WTGC_data (
082 WTGC_data_id,
083 VERS,
084 JSTA,
085 NBEVOL,
086 X0,
087 WIDCHB,
088 FWIRCH,
089 FWIXCH,
090 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
091 ALLNAME_8
092 ) values ( 2,
093 7, 3, 15, 0.1300, 7.0000, 2.0000, 2.4000,
094 'Gas','G10','Hone','Copp','Carb','','','',''
095 );
096 insert into WTGC_data2tag values ('WTGC-07', 2);
097 insert into WTGC_data (
098 WTGC_data_id,
099 VERS,
100 JSTA,
101 NBEVOL,
102 X0,
103 WIDCHB,
104 FWIRCH,
105 FWIXCH,
106 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
107 ALLNAME_8
108 ) values ( 3,
109 7, 4, 15, 0.1300, 7.0000, 1.7000, 2.0000,
110 'Gas','G10','Hone','Copp','Carb','','','',''
111 );
112 insert into WTGC_data2tag values ('WTGC-07', 3);
113 insert into WTGC_data (
114 WTGC_data_id,
115 VERS,
116 JSTA,
117 NBEVOL,
118 X0,
119 WIDCHB,
120 FWIRCH,
121 FWIXCH,
122 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
123 ALLNAME_8
124 ) values ( 4,
125 7, 5, 15, 0.1300, 7.0000, 1.7000, 2.0000,
126 'Gas','G10','Hone','Copp','Carb','','','',''
127 );
128 insert into WTGC_data2tag values ('WTGC-07', 4);
129 insert into WTGC_data (
130 WTGC_data_id,
131 VERS,
132 JSTA,
133 NBEVOL,
134 X0,
135 WIDCHB,
136 FWIRCH,
137 FWIXCH,
138 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
139 ALLNAME_8
140 ) values ( 5,
141 7, 6, 11, 0.1300, 4.3700, 2.0000, 2.4000,
142 'Gas','G10','Hone','Copp','Carb','','','',''
143 );
144 insert into WTGC_data2tag values ('WTGC-07', 5);
145 insert into WTGC_data (
146 WTGC_data_id,
147 VERS,
148 JSTA,
149 NBEVOL,
150 X0,
151 WIDCHB,
152 FWIRCH,
153 FWIXCH,
154 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
155 ALLNAME_8
156 ) values ( 6,
157 7, 7, 11, 0.1300, 4.3700, 2.0000, 2.4000,
158 'Gas','G10','Hone','Copp','Carb','','','',''
159 );
160 insert into WTGC_data2tag values ('WTGC-07', 6);
161 insert into WTGC_data (
162 WTGC_data_id,
163 VERS,
164 JSTA,
165 NBEVOL,
166 X0,
167 WIDCHB,
168 FWIRCH,
169 FWIXCH,
170 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
171 ALLNAME_8
172 ) values ( 7,
173 7, 8, 11, 0.1300, 4.3700, 2.0000, 2.4000,
174 'Gas','G10','Hone','Copp','Carb','','','',''
175 );
176 insert into WTGC_data2tag values ('WTGC-07', 7);
177 insert into WTGC_data (
178 WTGC_data_id,
179 VERS,
180 JSTA,
181 NBEVOL,
182 X0,
183 WIDCHB,
184 FWIRCH,
185 FWIXCH,
186 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
187 ALLNAME_8
188 ) values ( 8,
189 7, 9, 11, 0.1300, 4.3700, 1.7000, 2.0000,
190 'Gas','G10','Hone','Copp','Carb','','','',''
191 );
192 insert into WTGC_data2tag values ('WTGC-07', 8);
193 insert into WTGC_data (
194 WTGC_data_id,
195 VERS,
196 JSTA,
197 NBEVOL,
198 X0,
199 WIDCHB,
200 FWIRCH,
201 FWIXCH,
202 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
203 ALLNAME_8
204 ) values ( 9,
205 7, 10, 11, 0.1300, 4.3700, 1.7000, 2.0000,
206 'Gas','G10','Hone','Copp','Carb','','','',''
207 );
208 insert into WTGC_data2tag values ('WTGC-07', 9);
209 insert into WTGC_data (
210 WTGC_data_id,
211 VERS,
212 JSTA,
213 NBEVOL,
214 X0,
215 WIDCHB,
216 FWIRCH,
217 FWIXCH,
218 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
219 ALLNAME_8
220 ) values ( 10,
221 7, 11, 11, 0.1300, 4.3700, 2.0000, 2.4000,
222 'Gas','G10','Hone','Copp','Carb','','','',''
223 );
224 insert into WTGC_data2tag values ('WTGC-07', 10);
225 insert into WTGC_data (
226 WTGC_data_id,
227 VERS,
228 JSTA,
229 NBEVOL,
230 X0,
231 WIDCHB,
232 FWIRCH,
233 FWIXCH,
234 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
235 ALLNAME_8
236 ) values ( 11,
237 7, 12, 11, 0.1300, 4.3700, 2.0000, 2.4000,
238 'Gas','G10','Hone','Copp','Carb','','','',''
239 );
240 insert into WTGC_data2tag values ('WTGC-07', 11);
241 insert into WTGC_data (
242 WTGC_data_id,
243 VERS,
244 JSTA,
245 NBEVOL,
246 X0,
247 WIDCHB,
248 FWIRCH,
249 FWIXCH,
250 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
251 ALLNAME_8
252 ) values ( 12,
253 7, 13, 11, 0.1300, 4.3700, 2.0000, 2.4000,
254 'Gas','G10','Hone','Copp','Carb','','','',''
255 );
256 insert into WTGC_data2tag values ('WTGC-07', 12);
257 insert into WTGC_data (
258 WTGC_data_id,
259 VERS,
260 JSTA,
261 NBEVOL,
262 X0,
263 WIDCHB,
264 FWIRCH,
265 FWIXCH,
266 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
267 ALLNAME_8
268 ) values ( 13,
269 7, 14, 11, 0.1300, 4.3700, 2.0000, 2.4000,
270 'Gas','G10','Hone','Copp','Carb','','','',''
271 );
272 insert into WTGC_data2tag values ('WTGC-07', 13);
273 insert into WTGC_data (
274 WTGC_data_id,
275 VERS,
276 JSTA,
277 NBEVOL,
278 X0,
279 WIDCHB,
280 FWIRCH,
281 FWIXCH,
282 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
283 ALLNAME_8
284 ) values ( 14,
285 7, 15, 11, 0.1300, 4.3700, 1.7000, 2.0000,
286 'Gas','G10','Hone','Copp','Carb','','','',''
287 );
288 insert into WTGC_data2tag values ('WTGC-07', 14);
289 insert into WTGC_data (
290 WTGC_data_id,
291 VERS,
292 JSTA,
293 NBEVOL,
294 X0,
295 WIDCHB,
296 FWIRCH,
297 FWIXCH,
298 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
299 ALLNAME_8
300 ) values ( 15,
301 7, 16, 11, 0.1300, 4.3700, 1.7000, 2.0000,
302 'Gas','G10','Hone','Copp','Carb','','','',''
303 );
304 insert into WTGC_data2tag values ('WTGC-07', 15);
305 insert into WTGC_data (
306 WTGC_data_id,
307 VERS,
308 JSTA,
309 NBEVOL,
310 X0,
311 WIDCHB,
312 FWIRCH,
313 FWIXCH,
314 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
315 ALLNAME_8
316 ) values ( 16,
317 7, 17, 11, 0.1300, 4.3700, 2.0000, 2.4000,
318 'Gas','G10','Hone','Copp','Carb','','','',''
319 );
320 insert into WTGC_data2tag values ('WTGC-07', 16);
321 insert into WTGC_data (
322 WTGC_data_id,
323 VERS,
324 JSTA,
325 NBEVOL,
326 X0,
327 WIDCHB,
328 FWIRCH,
329 FWIXCH,
330 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
331 ALLNAME_8
332 ) values ( 17,
333 7, 18, 11, 0.1300, 4.3700, 2.0000, 2.4000,
334 'Gas','G10','Hone','Copp','Carb','','','',''
335 );
336 insert into WTGC_data2tag values ('WTGC-07', 17);
337 insert into WTGC_data (
338 WTGC_data_id,
339 VERS,
340 JSTA,
341 NBEVOL,
342 X0,
343 WIDCHB,
344 FWIRCH,
345 FWIXCH,
346 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
347 ALLNAME_8
348 ) values ( 18,
349 7, 19, 11, 0.1300, 4.3700, 2.0000, 2.4000,
350 'Gas','G10','Hone','Copp','Carb','','','',''
351 );
352 insert into WTGC_data2tag values ('WTGC-07', 18);
353 insert into WTGC_data (
354 WTGC_data_id,
355 VERS,
356 JSTA,
357 NBEVOL,
358 X0,
359 WIDCHB,
360 FWIRCH,
361 FWIXCH,
362 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
363 ALLNAME_8
364 ) values ( 19,
365 7, 20, 11, 0.1300, 4.3700, 2.0000, 2.4000,
366 'Gas','G10','Hone','Copp','Carb','','','',''
367 );
368 insert into WTGC_data2tag values ('WTGC-07', 19);
369 insert into WTGC_data (
370 WTGC_data_id,
371 VERS,
372 JSTA,
373 NBEVOL,
374 X0,
375 WIDCHB,
376 FWIRCH,
377 FWIXCH,
378 ALLNAME_0,ALLNAME_1,ALLNAME_2,ALLNAME_3,ALLNAME_4,ALLNAME_5,ALLNAME_6,ALLNAME_7,
379 ALLNAME_8
380 ) values ( 20,
381 7, 21, 11, 0.1300, 4.3700, 2.0000, 2.4000,
382 'Gas','G10','Hone','Copp','Carb','','','',''
383 );
384 insert into WTGC_data2tag values ('WTGC-07', 20);
385
386 comment on column WTGC_data.WTGC_data_id is 'Unique identifier';
387 comment on column WTGC_data.VERS is 'VERSION ';
388 comment on column WTGC_data.JSTA is 'JSTA INDEX ';
389 comment on column WTGC_data.NBEVOL is 'NUMBER OF DETAILS ';
390 comment on column WTGC_data.X0 is 'X0 ';
391 comment on column WTGC_data.WIDCHB is 'WIDTH OF THE CHBER ALONG Z ';
392 comment on column WTGC_data.FWIRCH is 'FRAME WIDTH IN R ';
393 comment on column WTGC_data.FWIXCH is 'FRAME WIDTH IN X ';
394 comment on column WTGC_data.ALLNAME_0 is 'MATERIAL ';
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.
|
|