001 SET echo OFF;
002 set linesize 132;
003 drop table ABRT_data2tag cascade constraints;
004 drop table ABRT_data cascade constraints;
005 create table ABRT_data (
006 ABRT_data_id number(10),
007 CRYORMIN float(63),
008 CRYORMAX float(63),
009 CRYOZMAX float(63),
010 CRYORCUR float(63),
011 CRYORADI float(63),
012 CRYORADT float(63),
013 CRYATTD0 float(63),
014 CRYATTD1 float(63),
015 CRYATTAL float(63),
016 CRYATTXH float(63),
017 CRYATTTH float(63),
018 CRYATTRX float(63),
019 CRYATWIY float(63),
020 CRYATWXP float(63),
021 CRYATWXN float(63),
022 CRYATWBO float(63),
023 CRYATWTH float(63),
024 CRYATWZE float(63),
025 CRYATWRA float(63),
026 CRYATWYC float(63),
027 CRYRIBYW float(63),
028 CRYRIBZL float(63),
029 CRYRIBTH float(63),
030 CRYRIWYP float(63),
031 CRYRIWYN float(63),
032 CRYRIWXP float(63),
033 CRYRIWXN float(63),
034 CRYRIWTH float(63),
035 CRYRNGRM float(63),
036 CRYRNGZM float(63),
037 CRYRNGRA float(63),
038 STRTRMAX float(63),
039 STRTRMIN float(63),
040 STRTYLEN float(63),
041 STRTZWID float(63),
042 STRTRTHI float(63),
043 STRTZTHI float(63),
044 STRWRMAX float(63),
045 STRWYMAX float(63),
046 STRWRMIN float(63),
047 STRWYMIN float(63),
048 STRWZTHI float(63),
049 STRWYTHI float(63),
050 STRWZLEN float(63),
051 ZVOUSS_0 float(63),
052 ZVOUSS_1 float(63),
053 ZVOUSS_2 float(63),
054 ZVOUSS_3 float(63),
055 ZVOUSS_4 float(63),
056 ZVOUSS_5 float(63),
057 ZVOUSS_6 float(63),
058 ZVOUSS_7 float(63),
059 ZRIB_0 float(63),
060 ZRIB_1 float(63),
061 ZRIB_2 float(63),
062 ZRIB_3 float(63),
063 ZRIB_4 float(63),
064 ZRIB_5 float(63),
065 ZRIB_6 float(63),
066 CRYRIXHI float(63),
067 STRTRMOY float(63),
068 STRTYLNP float(63),
069 CRYATTXS float(63),
070 COMARMIN float(63),
071 COMARMAX float(63),
072 COMAZMAX float(63),
073 COMARCUI float(63),
074 COMARTHI float(63),
075 COMAYTHI float(63),
076 COMARIBY float(63),
077 COMARIBZ float(63),
078 COMABOSS float(63),
079 COMARIBX float(63),
080 BIELYHEI float(63),
081 BIELYSO1 float(63),
082 BIELYSO2 float(63),
083 BIELXSOL float(63),
084 BIELXTH1 float(63),
085 BIELXTH2 float(63),
086 BIELZTH1 float(63),
087 BIELRHOL float(63),
088 BIELYCHO float(63),
089 BIELATL1 float(63),
090 BIELATL2 float(63),
091 BIELATTH float(63),
092 BIELATHE float(63),
093 VOUSBLXH float(63),
094 VOUSPLIX float(63),
095 VOUSPLOX float(63),
096 VOUSBLYW float(63),
097 VOUBLYWS float(63),
098 VOURCYWI float(63),
099 VOURPYWI float(63),
100 VOUBLZLE float(63),
101 VOUBLZLS float(63),
102 VOUBZWTH float(63),
103 VOUCUTZE float(63),
104 VOURCUTR float(63),
105 VOURECSL float(63),
106 CNBCOYEX float(63),
107 CNBCOXEX float(63),
108 CNBCOXSU float(63),
109 CNBCOXIN float(63),
110 CNBEAHEI float(63),
111 CNBEACXI float(63),
112 CNBEACTL float(63),
113 CNBEACTU float(63),
114 CNBEACZW float(63),
115 CNBEACZE float(63),
116 CNBEACPL float(63),
117 CNBCADMA float(63),
118 CNBCADMI float(63),
119 CNBCAZEX float(63),
120 CNBOXZEX float(63),
121 VOUSMBRA float(63),
122 CNBXMBRA float(63),
123 VOUCRCYR float(63),
124 VOUSRCXW float(63),
125 VOUSCXOF float(63),
126 VOUSCYPO float(63),
127 VOUSCZPO float(63),
128 CNBEAXTP float(63),
129 CNBEAYTP float(63),
130 CNBEAXBT float(63),
131 CNBEAYBT float(63),
132 CNBECXOL float(63),
133 CNBECYOL float(63),
134 CNBECYIL float(63),
135 CNBECOHE float(63),
136 CNBECXOU float(63),
137 CNBECYOU float(63),
138 CNBECYIU float(63),
139 CNBECZPO float(63),
140 CNBIECZP float(63),
141 CNBCAZIN float(63),
142 VOUSSRAD float(63),
143 CNBOXRAD float(63)
144 ) ;
145
146 alter table ABRT_data add constraint ABRT_data_pk
147 primary key (ABRT_data_id);
148
149 create table ABRT_data2tag (
150 ABRT_vers varchar2(255),
151 ABRT_data_id number(10)
152 ) ;
153
154 alter table ABRT_data2tag add constraint ABRT_data2tag_pk
155 primary key (ABRT_vers, ABRT_data_id);
156 alter table ABRT_data2tag add constraint ABRT_data2tag_vers_fk
157 foreign key (ABRT_vers) references hvs_nodevers (vers_name);
158 alter table ABRT_data2tag add constraint ABRT_data2tag_data_fk
159 foreign key (ABRT_data_id) references ABRT_data (ABRT_data_id);
160
161 delete from hvs_relation where CHILD_NODENAME = 'ABRT';
162 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
163 delete from hvs_nodevers where NODE_NAME = 'ABRT';
164 delete from hvs_node where NODE_NAME = 'ABRT';
165
166 insert into hvs_node values ('ABRT','MuonSpectrometer', '');
167 insert into hvs_nodevers values ('ABRT', 'ABRT-01', '');
168 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
169 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','ABRT','ABRT-01');
170 insert into ABRT_data (
171 ABRT_data_id,
172 CRYORMIN,
173 CRYORMAX,
174 CRYOZMAX,
175 CRYORCUR,
176 CRYORADI,
177 CRYORADT,
178 CRYATTD0,
179 CRYATTD1,
180 CRYATTAL,
181 CRYATTXH,
182 CRYATTTH,
183 CRYATTRX,
184 CRYATWIY,
185 CRYATWXP,
186 CRYATWXN,
187 CRYATWBO,
188 CRYATWTH,
189 CRYATWZE,
190 CRYATWRA,
191 CRYATWYC,
192 CRYRIBYW,
193 CRYRIBZL,
194 CRYRIBTH,
195 CRYRIWYP,
196 CRYRIWYN,
197 CRYRIWXP,
198 CRYRIWXN,
199 CRYRIWTH,
200 CRYRNGRM,
201 CRYRNGZM,
202 CRYRNGRA,
203 STRTRMAX,
204 STRTRMIN,
205 STRTYLEN,
206 STRTZWID,
207 STRTRTHI,
208 STRTZTHI,
209 STRWRMAX,
210 STRWYMAX,
211 STRWRMIN,
212 STRWYMIN,
213 STRWZTHI,
214 STRWYTHI,
215 STRWZLEN,
216 ZVOUSS_0,ZVOUSS_1,ZVOUSS_2,ZVOUSS_3,ZVOUSS_4,ZVOUSS_5,ZVOUSS_6,ZVOUSS_7,
217 ZRIB_0,ZRIB_1,ZRIB_2,ZRIB_3,ZRIB_4,ZRIB_5,ZRIB_6,
218 CRYRIXHI,
219 STRTRMOY,
220 STRTYLNP,
221 CRYATTXS,
222 COMARMIN,
223 COMARMAX,
224 COMAZMAX,
225 COMARCUI,
226 COMARTHI,
227 COMAYTHI,
228 COMARIBY,
229 COMARIBZ,
230 COMABOSS,
231 COMARIBX,
232 BIELYHEI,
233 BIELYSO1,
234 BIELYSO2,
235 BIELXSOL,
236 BIELXTH1,
237 BIELXTH2,
238 BIELZTH1,
239 BIELRHOL,
240 BIELYCHO,
241 BIELATL1,
242 BIELATL2,
243 BIELATTH,
244 BIELATHE,
245 VOUSBLXH,
246 VOUSPLIX,
247 VOUSPLOX,
248 VOUSBLYW,
249 VOUBLYWS,
250 VOURCYWI,
251 VOURPYWI,
252 VOUBLZLE,
253 VOUBLZLS,
254 VOUBZWTH,
255 VOUCUTZE,
256 VOURCUTR,
257 VOURECSL,
258 CNBCOYEX,
259 CNBCOXEX,
260 CNBCOXSU,
261 CNBCOXIN,
262 CNBEAHEI,
263 CNBEACXI,
264 CNBEACTL,
265 CNBEACTU,
266 CNBEACZW,
267 CNBEACZE,
268 CNBEACPL,
269 CNBCADMA,
270 CNBCADMI,
271 CNBCAZEX,
272 CNBOXZEX,
273 VOUSMBRA,
274 CNBXMBRA,
275 VOUCRCYR,
276 VOUSRCXW,
277 VOUSCXOF,
278 VOUSCYPO,
279 VOUSCZPO,
280 CNBEAXTP,
281 CNBEAYTP,
282 CNBEAXBT,
283 CNBEAYBT,
284 CNBECXOL,
285 CNBECYOL,
286 CNBECYIL,
287 CNBECOHE,
288 CNBECXOU,
289 CNBECYOU,
290 CNBECYIU,
291 CNBECZPO,
292 CNBIECZP,
293 CNBCAZIN,
294 VOUSSRAD,
295 CNBOXRAD
296 ) values ( 1,
297 4720.0000, 10030.0000, 12650.0000, 1000.0000, 550.0000, 15.0000,
298 603.0000, 550.0000, 8.0000, 630.0000, 15.0000, 6061.0000,
299 600.0000, 590.0000, -41.0000, 40.0000, 25.0000, 680.0000,
300 578.0000, 150.0000, 540.0000, 290.0000, 20.0000, 350.0000,
301 1090.0000, 550.0000, -180.0000, 30.0000, 8760.0000, -800.0000,
302 340.0000, 9100.0000, 8460.0000, 5650.0000, 360.0000, 50.0000,
303 40.0000, 10050.0000, 440.0000, 8760.0000, 280.0000, 50.0000,
304 70.0000, 400.0000,-10845.0000, -8245.0000, -5137.5000, -1712.5000,
305 1712.5000, 5137.5000, 8245.0000, 10845.0000, -9540.0000, -6760.0000,
306 -3490.0000, 0.0000, 3490.0000, 6760.0000, 9540.0000, 2105.0000,
307 8780.0000, 5685.0000, 188.5573, 4870.0000, 9880.0000, 12500.0000,
308 800.0000, 800.0000, 320.0000, 300.0000, 120.0000, 937.2583,
309 2385.7144, 1110.0000, 50.0000, 60.0000, 120.0000, 20.0000,
310 40.0000, 230.0000, 60.0000, 115.0000, 1000.0000, 150.0000,
311 280.0000, 140.0000, 850.0000, 120.0000, 80.0000, 2850.0000,
312 120.0000, 815.0000, 50.0000, 500.0000, 50.0000, 50.0000,
313 500.0000, 300.0000, 30.0000, 880.0000, 2367.0000, 834.0000,
314 634.0000, 850.0000, 350.0000, 120.0000, 80.0000, 50.0000,
315 135.0000, 80.0000, 518.0000, 468.0000, 780.0000, 550.0000,
316 5723.0000, 6942.0000, 440.0000, 650.0000, 20.0000, 897.5000,
317 275.0000, 1183.5000, 562.5053, 858.2191, -222.7923, 793.2756,
318 -66.0047, 117.6060, 650.0000, 1042.0198, 534.5170, 821.1609,
319 415.0000, 300.0000, 177.8842, 6148.0000, 6062.0000
320 );
321 insert into ABRT_data2tag values ('ABRT-01', 1);
322
323 comment on column ABRT_data.ABRT_data_id is 'Unique identifier';
324 comment on column ABRT_data.CRYORMIN is 'CRYORMIN ';
325 comment on column ABRT_data.CRYORMAX is 'CRYORMAX ';
326 comment on column ABRT_data.CRYOZMAX is 'CRYOZMAX ';
327 comment on column ABRT_data.CRYORCUR is 'CRYORCUR ';
328 comment on column ABRT_data.CRYORADI is 'RADIUS ';
329 comment on column ABRT_data.CRYORADT is 'RADTHICK ';
330 comment on column ABRT_data.CRYATTD0 is 'CRYOATTDIAM0 ';
331 comment on column ABRT_data.CRYATTD1 is 'CRYOATTDIAM1 ';
332 comment on column ABRT_data.CRYATTAL is 'CRYOATTALFA ';
333 comment on column ABRT_data.CRYATTXH is 'CRYOATTXHIGH ';
334 comment on column ABRT_data.CRYATTTH is 'CRYOATTTHICK ';
335 comment on column ABRT_data.CRYATTRX is 'CRYOATTRMAX ';
336 comment on column ABRT_data.CRYATWIY is 'CRYOATTWINGY ';
337 comment on column ABRT_data.CRYATWXP is 'CRYOATTWINGXP ';
338 comment on column ABRT_data.CRYATWXN is 'CRYOATTWINGXN ';
339 comment on column ABRT_data.CRYATWBO is 'CRYOATTWINGBOSS ';
340 comment on column ABRT_data.CRYATWTH is 'CRYOATTWINGTHICK ';
341 comment on column ABRT_data.CRYATWZE is 'CRYOATTWINGZESP ';
342 comment on column ABRT_data.CRYATWRA is 'CRYOATTWINGRAD ';
343 comment on column ABRT_data.CRYATWYC is 'CRYOATTWINGYCUT ';
344 comment on column ABRT_data.CRYRIBYW is 'CRYORIBYWID ';
345 comment on column ABRT_data.CRYRIBZL is 'CRYORIBZLEN ';
346 comment on column ABRT_data.CRYRIBTH is 'CRYORIBTHICK ';
347 comment on column ABRT_data.CRYRIWYP is 'CRYORIBWINGYP ';
348 comment on column ABRT_data.CRYRIWYN is 'CRYORIBWINGYN ';
349 comment on column ABRT_data.CRYRIWXP is 'CRYORIBWINGXP ';
350 comment on column ABRT_data.CRYRIWXN is 'CRYORIBWINGXN ';
351 comment on column ABRT_data.CRYRIWTH is 'CRYORIBWINGTHICK ';
352 comment on column ABRT_data.CRYRNGRM is 'CRYORINGRMED ';
353 comment on column ABRT_data.CRYRNGZM is 'CRYORINGZMED ';
354 comment on column ABRT_data.CRYRNGRA is 'CRYORINGRADIUS ';
355 comment on column ABRT_data.STRTRMAX is 'STRTRMAX ';
356 comment on column ABRT_data.STRTRMIN is 'STRTRMIN ';
357 comment on column ABRT_data.STRTYLEN is 'STRTYLEN ';
358 comment on column ABRT_data.STRTZWID is 'STRUTZWIDTH ';
359 comment on column ABRT_data.STRTRTHI is 'STRUTRTHICK ';
360 comment on column ABRT_data.STRTZTHI is 'STRUTZTHICK ';
361 comment on column ABRT_data.STRWRMAX is 'STRUTWINGRMAX ';
362 comment on column ABRT_data.STRWYMAX is 'STRUTWINGYMAX ';
363 comment on column ABRT_data.STRWRMIN is 'STRUTWINGRMIN ';
364 comment on column ABRT_data.STRWYMIN is 'STRUTWINGYMIN ';
365 comment on column ABRT_data.STRWZTHI is 'STRUTWINGZTHICK ';
366 comment on column ABRT_data.STRWYTHI is 'STRUTWINGYTHICK ';
367 comment on column ABRT_data.STRWZLEN is 'STRUTWINGZLEN ';
368 comment on column ABRT_data.ZVOUSS_0 is 'ARRAY ';
369 comment on column ABRT_data.ZRIB_0 is 'ARRAY ';
370 comment on column ABRT_data.CRYRIXHI is 'CRYORIBXHIGH ';
371 comment on column ABRT_data.STRTRMOY is 'STRTRMOY ';
372 comment on column ABRT_data.STRTYLNP is 'STRUTYLENP ';
373 comment on column ABRT_data.CRYATTXS is 'CRYOATTXSEC ';
374 comment on column ABRT_data.COMARMIN is 'COLDMASSRMIN ';
375 comment on column ABRT_data.COMARMAX is 'COLDMASSRMAX ';
376 comment on column ABRT_data.COMAZMAX is 'COLDMASSZMAX ';
377 comment on column ABRT_data.COMARCUI is 'COLDMASSRCURVI ';
378 comment on column ABRT_data.COMARTHI is 'COLDMASSRTHICK ';
379 comment on column ABRT_data.COMAYTHI is 'COLDMASSYTHICK ';
380 comment on column ABRT_data.COMARIBY is 'COLDMASSRIBY ';
381 comment on column ABRT_data.COMARIBZ is 'COLDMASSRIBZ ';
382 comment on column ABRT_data.COMABOSS is 'COLDMASSBOSS ';
383 comment on column ABRT_data.COMARIBX is 'COLDMASSRIBX ';
384 comment on column ABRT_data.BIELYHEI is 'BIELLYHEIGHT ';
385 comment on column ABRT_data.BIELYSO1 is 'BIELLYSOLE1 ';
386 comment on column ABRT_data.BIELYSO2 is 'BIELLYSOLE2 ';
387 comment on column ABRT_data.BIELXSOL is 'BIELLXSOLE ';
388 comment on column ABRT_data.BIELXTH1 is 'BIELLXTHICK1 ';
389 comment on column ABRT_data.BIELXTH2 is 'BIELLXTHICK2 ';
390 comment on column ABRT_data.BIELZTH1 is 'BIELLZTHICK1 ';
391 comment on column ABRT_data.BIELRHOL is 'BIELLRADHOLE ';
392 comment on column ABRT_data.BIELYCHO is 'BIELLYCENHOLE ';
393 comment on column ABRT_data.BIELATL1 is 'BIELLATTLENG1 ';
394 comment on column ABRT_data.BIELATL2 is 'BIELLATTLENG2 ';
395 comment on column ABRT_data.BIELATTH is 'BIELLATTTHICK ';
396 comment on column ABRT_data.BIELATHE is 'BIELLATTHEIGHT ';
397 comment on column ABRT_data.VOUSBLXH is 'VOUSSBLOCKXHEIGHT ';
398 comment on column ABRT_data.VOUSPLIX is 'VOUSSPLATEINNERXWID ';
399 comment on column ABRT_data.VOUSPLOX is 'VOUSSPLATEOUTERXWID ';
400 comment on column ABRT_data.VOUSBLYW is 'VOUSSBLOCKYWID ';
401 comment on column ABRT_data.VOUBLYWS is 'VOUSSBLOCKYWIDSUB ';
402 comment on column ABRT_data.VOURCYWI is 'VOUSSRECTCUTYWID ';
403 comment on column ABRT_data.VOURPYWI is 'VOUSSREINFORCEPLATYWID ';
404 comment on column ABRT_data.VOUBLZLE is 'VOUSSBLOCKZLEN ';
405 comment on column ABRT_data.VOUBLZLS is 'VOUSSBLOCKZLENSUB ';
406 comment on column ABRT_data.VOUBZWTH is 'VOUSSBLOCKZWALLTH ';
407 comment on column ABRT_data.VOUCUTZE is 'VOUSSCUTZEXT ';
408 comment on column ABRT_data.VOURCUTR is 'VOUSSROUNDCUTRAD ';
409 comment on column ABRT_data.VOURECSL is 'VOUSSRECTCUTXYSLANT ';
410 comment on column ABRT_data.CNBCOYEX is 'CONBOXCOREYEXTENSION ';
411 comment on column ABRT_data.CNBCOXEX is 'CONBOXCOREXEXTENSION ';
412 comment on column ABRT_data.CNBCOXSU is 'CONBOXCOREXSUP ';
413 comment on column ABRT_data.CNBCOXIN is 'CONBOXCOREXINF ';
414 comment on column ABRT_data.CNBEAHEI is 'CONBOXEARHEIGHT ';
415 comment on column ABRT_data.CNBEACXI is 'CONBOXEARCUTXIN ';
416 comment on column ABRT_data.CNBEACTL is 'CONBOXEARCUTPLATETHICKLOWOUT ';
417 comment on column ABRT_data.CNBEACTU is 'CONBOXEARCUTPLATETHICKUP ';
418 comment on column ABRT_data.CNBEACZW is 'CONBOXEARCUTZWALL ';
419 comment on column ABRT_data.CNBEACZE is 'CONBOXEARCUTZEXTR ';
420 comment on column ABRT_data.CNBEACPL is 'CONBOXINNEREARCUTPLATE ';
421 comment on column ABRT_data.CNBCADMA is 'CONBOXCAVITYDMAX ';
422 comment on column ABRT_data.CNBCADMI is 'CONBOXCAVITYDMIN ';
423 comment on column ABRT_data.CNBCAZEX is 'CONBOXCAVITYZEXT ';
424 comment on column ABRT_data.CNBOXZEX is 'CONBOXZEXTENSION ';
425 comment on column ABRT_data.VOUSMBRA is 'VOUSSOIRMAINBLOCKRADIUS ';
426 comment on column ABRT_data.CNBXMBRA is 'CONBOXMAINBLOCKRADIUS ';
427 comment on column ABRT_data.VOUCRCYR is 'VOUSSCENTRRECTCUTYREACH ';
428 comment on column ABRT_data.VOUSRCXW is 'VOUSSRECTCUTXWID ';
429 comment on column ABRT_data.VOUSCXOF is 'VOUSSCUTXOFFSET ';
430 comment on column ABRT_data.VOUSCYPO is 'VOUSSOIRCUTYPOS ';
431 comment on column ABRT_data.VOUSCZPO is 'VOUSSOIRCUTZPOS ';
432 comment on column ABRT_data.CNBEAXTP is 'CONBOXEARXTOP ';
433 comment on column ABRT_data.CNBEAYTP is 'CONBOXEARYTOP ';
434 comment on column ABRT_data.CNBEAXBT is 'CONBOXEARXBOT ';
435 comment on column ABRT_data.CNBEAYBT is 'CONBOXEARYBOT ';
436 comment on column ABRT_data.CNBECXOL is 'CONBOXEARCUTXOUTLOW ';
437 comment on column ABRT_data.CNBECYOL is 'CONBOXEARCUTYOUTLOW ';
438 comment on column ABRT_data.CNBECYIL is 'CONBOXEARCUTYINLOW ';
439 comment on column ABRT_data.CNBECOHE is 'CONBOXEARCUTOUTHEIGHT ';
440 comment on column ABRT_data.CNBECXOU is 'CONBOXEARCUTXOUTUP ';
441 comment on column ABRT_data.CNBECYOU is 'CONBOXEARCUTYOUTUP ';
442 comment on column ABRT_data.CNBECYIU is 'CONBOXEARCUTYINUP ';
443 comment on column ABRT_data.CNBECZPO is 'CONBOXEARCUTZPOS ';
444 comment on column ABRT_data.CNBIECZP is 'CONBOXINNEREARCUTZPOS ';
445 comment on column ABRT_data.CNBCAZIN is 'CONBOXCAVITYZINTER ';
446 comment on column ABRT_data.VOUSSRAD is 'VOUSSOIRRADIUS ';
447 comment on column ABRT_data.CNBOXRAD is 'CONBOXRADIUS ';
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.
|
|