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