001 SET echo OFF;
002 set linesize 132;
003 drop table ALIN_data2tag cascade constraints;
004 drop table ALIN_data cascade constraints;
005 create table ALIN_data (
006 ALIN_data_id number(10),
007 VERS number(10),
008 DX float(63),
009 DY float(63),
010 I number(10),
011 WIDTH_XS float(63),
012 WIDTH_XL float(63),
013 LENGTH_Y float(63),
014 EXCENT float(63),
015 DEAD1 float(63),
016 JTYP number(10),
017 INDX number(10),
018 ICUT number(10)
019 ) ;
020
021 alter table ALIN_data add constraint ALIN_data_pk
022 primary key (ALIN_data_id);
023
024 create table ALIN_data2tag (
025 ALIN_vers varchar2(255),
026 ALIN_data_id number(10)
027 ) ;
028
029 alter table ALIN_data2tag add constraint ALIN_data2tag_pk
030 primary key (ALIN_vers, ALIN_data_id);
031 alter table ALIN_data2tag add constraint ALIN_data2tag_vers_fk
032 foreign key (ALIN_vers) references hvs_nodevers (vers_name);
033 alter table ALIN_data2tag add constraint ALIN_data2tag_data_fk
034 foreign key (ALIN_data_id) references ALIN_data (ALIN_data_id);
035
036 delete from hvs_relation where CHILD_NODENAME = 'ALIN';
037 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
038 delete from hvs_nodevers where NODE_NAME = 'ALIN';
039 delete from hvs_node where NODE_NAME = 'ALIN';
040
041 insert into hvs_node values ('ALIN','MuonSpectrometer', '');
042 insert into hvs_nodevers values ('ALIN', 'ALIN-07', '');
043 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
044 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','ALIN','ALIN-07');
045 insert into ALIN_data (
046 ALIN_data_id,
047 VERS,
048 DX,
049 DY,
050 I,
051 WIDTH_XS,
052 WIDTH_XL,
053 LENGTH_Y,
054 EXCENT,
055 DEAD1,
056 JTYP,
057 INDX,
058 ICUT
059 ) values ( 0,
060 7, 88.0000, 95.5000, 3, 28.0000, 28.0000, 12.1580,
061 0.0000, 48.8500, 4, 2, 1
062 );
063 insert into ALIN_data2tag values ('ALIN-07', 0);
064 insert into ALIN_data (
065 ALIN_data_id,
066 VERS,
067 DX,
068 DY,
069 I,
070 WIDTH_XS,
071 WIDTH_XL,
072 LENGTH_Y,
073 EXCENT,
074 DEAD1,
075 JTYP,
076 INDX,
077 ICUT
078 ) values ( 1,
079 7, 88.0000, 100.5000, 6, 28.0000, 28.0000, 12.1580,
080 0.0000, 48.8500, 4, 2, 1
081 );
082 insert into ALIN_data2tag values ('ALIN-07', 1);
083 insert into ALIN_data (
084 ALIN_data_id,
085 VERS,
086 DX,
087 DY,
088 I,
089 WIDTH_XS,
090 WIDTH_XL,
091 LENGTH_Y,
092 EXCENT,
093 DEAD1,
094 JTYP,
095 INDX,
096 ICUT
097 ) values ( 2,
098 7, -93.0000, 95.5000, 3, 8.0000, 8.0000, 12.1580,
099 0.0000, 48.8500, 4, 2, 1
100 );
101 insert into ALIN_data2tag values ('ALIN-07', 2);
102 insert into ALIN_data (
103 ALIN_data_id,
104 VERS,
105 DX,
106 DY,
107 I,
108 WIDTH_XS,
109 WIDTH_XL,
110 LENGTH_Y,
111 EXCENT,
112 DEAD1,
113 JTYP,
114 INDX,
115 ICUT
116 ) values ( 3,
117 7, -93.0000, 100.5000, 6, 8.0000, 8.0000, 12.1580,
118 0.0000, 48.8500, 4, 2, 1
119 );
120 insert into ALIN_data2tag values ('ALIN-07', 3);
121 insert into ALIN_data (
122 ALIN_data_id,
123 VERS,
124 DX,
125 DY,
126 I,
127 WIDTH_XS,
128 WIDTH_XL,
129 LENGTH_Y,
130 EXCENT,
131 DEAD1,
132 JTYP,
133 INDX,
134 ICUT
135 ) values ( 4,
136 7, 143.5000, 0.0000, 2, 35.0000, 35.0000, 48.0000,
137 0.0000, 0.0000, 4, 3, 1
138 );
139 insert into ALIN_data2tag values ('ALIN-07', 4);
140 insert into ALIN_data (
141 ALIN_data_id,
142 VERS,
143 DX,
144 DY,
145 I,
146 WIDTH_XS,
147 WIDTH_XL,
148 LENGTH_Y,
149 EXCENT,
150 DEAD1,
151 JTYP,
152 INDX,
153 ICUT
154 ) values ( 5,
155 7, 143.5000, 0.0000, 5, 35.0000, 35.0000, 48.0000,
156 0.0000, 0.0000, 4, 3, 1
157 );
158 insert into ALIN_data2tag values ('ALIN-07', 5);
159 insert into ALIN_data (
160 ALIN_data_id,
161 VERS,
162 DX,
163 DY,
164 I,
165 WIDTH_XS,
166 WIDTH_XL,
167 LENGTH_Y,
168 EXCENT,
169 DEAD1,
170 JTYP,
171 INDX,
172 ICUT
173 ) values ( 6,
174 7, 143.5000, 0.0000, 8, 35.0000, 35.0000, 48.0000,
175 0.0000, 0.0000, 4, 3, 1
176 );
177 insert into ALIN_data2tag values ('ALIN-07', 6);
178 insert into ALIN_data (
179 ALIN_data_id,
180 VERS,
181 DX,
182 DY,
183 I,
184 WIDTH_XS,
185 WIDTH_XL,
186 LENGTH_Y,
187 EXCENT,
188 DEAD1,
189 JTYP,
190 INDX,
191 ICUT
192 ) values ( 7,
193 7, 143.5000, 0.0000, 14, 35.0000, 35.0000, 48.0000,
194 0.0000, 0.0000, 4, 3, 1
195 );
196 insert into ALIN_data2tag values ('ALIN-07', 7);
197 insert into ALIN_data (
198 ALIN_data_id,
199 VERS,
200 DX,
201 DY,
202 I,
203 WIDTH_XS,
204 WIDTH_XL,
205 LENGTH_Y,
206 EXCENT,
207 DEAD1,
208 JTYP,
209 INDX,
210 ICUT
211 ) values ( 8,
212 7, 143.5000, 0.0000, 16, 35.0000, 35.0000, 48.0000,
213 0.0000, 0.0000, 4, 3, 1
214 );
215 insert into ALIN_data2tag values ('ALIN-07', 8);
216 insert into ALIN_data (
217 ALIN_data_id,
218 VERS,
219 DX,
220 DY,
221 I,
222 WIDTH_XS,
223 WIDTH_XL,
224 LENGTH_Y,
225 EXCENT,
226 DEAD1,
227 JTYP,
228 INDX,
229 ICUT
230 ) values ( 9,
231 7, 143.5000, 0.0000, 19, 35.0000, 35.0000, 48.0000,
232 0.0000, 0.0000, 4, 3, 1
233 );
234 insert into ALIN_data2tag values ('ALIN-07', 9);
235 insert into ALIN_data (
236 ALIN_data_id,
237 VERS,
238 DX,
239 DY,
240 I,
241 WIDTH_XS,
242 WIDTH_XL,
243 LENGTH_Y,
244 EXCENT,
245 DEAD1,
246 JTYP,
247 INDX,
248 ICUT
249 ) values ( 10,
250 7, 119.3200, -11.0830, 14, 68.5000, 68.5000, 8.6970,
251 0.0000, 0.0000, 4, 4, 1
252 );
253 insert into ALIN_data2tag values ('ALIN-07', 10);
254 insert into ALIN_data (
255 ALIN_data_id,
256 VERS,
257 DX,
258 DY,
259 I,
260 WIDTH_XS,
261 WIDTH_XL,
262 LENGTH_Y,
263 EXCENT,
264 DEAD1,
265 JTYP,
266 INDX,
267 ICUT
268 ) values ( 11,
269 7, -119.3200, -11.0830, 14, 68.5000, 68.5000, 8.6970,
270 0.0000, 0.0000, 4, 4, 1
271 );
272 insert into ALIN_data2tag values ('ALIN-07', 11);
273 insert into ALIN_data (
274 ALIN_data_id,
275 VERS,
276 DX,
277 DY,
278 I,
279 WIDTH_XS,
280 WIDTH_XL,
281 LENGTH_Y,
282 EXCENT,
283 DEAD1,
284 JTYP,
285 INDX,
286 ICUT
287 ) values ( 12,
288 7, -95.0000, 148.5500, 23, 10.0000, 10.0000, 10.0000,
289 0.0000, 0.0000, 4, 5, 1
290 );
291 insert into ALIN_data2tag values ('ALIN-07', 12);
292 insert into ALIN_data (
293 ALIN_data_id,
294 VERS,
295 DX,
296 DY,
297 I,
298 WIDTH_XS,
299 WIDTH_XL,
300 LENGTH_Y,
301 EXCENT,
302 DEAD1,
303 JTYP,
304 INDX,
305 ICUT
306 ) values ( 13,
307 7, -95.0000, 148.5500, 24, 10.0000, 10.0000, 10.0000,
308 0.0000, 0.0000, 4, 5, 1
309 );
310 insert into ALIN_data2tag values ('ALIN-07', 13);
311 insert into ALIN_data (
312 ALIN_data_id,
313 VERS,
314 DX,
315 DY,
316 I,
317 WIDTH_XS,
318 WIDTH_XL,
319 LENGTH_Y,
320 EXCENT,
321 DEAD1,
322 JTYP,
323 INDX,
324 ICUT
325 ) values ( 14,
326 7, 95.0000, 148.5500, 27, 10.0000, 10.0000, 10.0000,
327 0.0000, 0.0000, 4, 5, 1
328 );
329 insert into ALIN_data2tag values ('ALIN-07', 14);
330 insert into ALIN_data (
331 ALIN_data_id,
332 VERS,
333 DX,
334 DY,
335 I,
336 WIDTH_XS,
337 WIDTH_XL,
338 LENGTH_Y,
339 EXCENT,
340 DEAD1,
341 JTYP,
342 INDX,
343 ICUT
344 ) values ( 15,
345 7, 95.0000, 148.5500, 28, 10.0000, 10.0000, 10.0000,
346 0.0000, 0.0000, 4, 5, 1
347 );
348 insert into ALIN_data2tag values ('ALIN-07', 15);
349 insert into ALIN_data (
350 ALIN_data_id,
351 VERS,
352 DX,
353 DY,
354 I,
355 WIDTH_XS,
356 WIDTH_XL,
357 LENGTH_Y,
358 EXCENT,
359 DEAD1,
360 JTYP,
361 INDX,
362 ICUT
363 ) values ( 16,
364 7, -98.5000, 167.0000, 31, 10.0000, 10.0000, 18.1210,
365 0.0000, 0.0000, 4, 5, 1
366 );
367 insert into ALIN_data2tag values ('ALIN-07', 16);
368 insert into ALIN_data (
369 ALIN_data_id,
370 VERS,
371 DX,
372 DY,
373 I,
374 WIDTH_XS,
375 WIDTH_XL,
376 LENGTH_Y,
377 EXCENT,
378 DEAD1,
379 JTYP,
380 INDX,
381 ICUT
382 ) values ( 17,
383 7, -98.5000, 167.0000, 32, 10.0000, 10.0000, 18.1210,
384 0.0000, 0.0000, 4, 5, 1
385 );
386 insert into ALIN_data2tag values ('ALIN-07', 17);
387 insert into ALIN_data (
388 ALIN_data_id,
389 VERS,
390 DX,
391 DY,
392 I,
393 WIDTH_XS,
394 WIDTH_XL,
395 LENGTH_Y,
396 EXCENT,
397 DEAD1,
398 JTYP,
399 INDX,
400 ICUT
401 ) values ( 18,
402 7, 98.5000, 167.0000, 35, 10.0000, 10.0000, 18.1210,
403 0.0000, 0.0000, 4, 5, 1
404 );
405 insert into ALIN_data2tag values ('ALIN-07', 18);
406 insert into ALIN_data (
407 ALIN_data_id,
408 VERS,
409 DX,
410 DY,
411 I,
412 WIDTH_XS,
413 WIDTH_XL,
414 LENGTH_Y,
415 EXCENT,
416 DEAD1,
417 JTYP,
418 INDX,
419 ICUT
420 ) values ( 19,
421 7, 98.5000, 167.0000, 36, 10.0000, 10.0000, 18.1210,
422 0.0000, 0.0000, 4, 5, 1
423 );
424 insert into ALIN_data2tag values ('ALIN-07', 19);
425 insert into ALIN_data (
426 ALIN_data_id,
427 VERS,
428 DX,
429 DY,
430 I,
431 WIDTH_XS,
432 WIDTH_XL,
433 LENGTH_Y,
434 EXCENT,
435 DEAD1,
436 JTYP,
437 INDX,
438 ICUT
439 ) values ( 20,
440 7, -95.0000, 105.0000, 20, 10.0000, 10.0000, 18.0000,
441 0.0000, 39.2000, 4, 6, 1
442 );
443 insert into ALIN_data2tag values ('ALIN-07', 20);
444 insert into ALIN_data (
445 ALIN_data_id,
446 VERS,
447 DX,
448 DY,
449 I,
450 WIDTH_XS,
451 WIDTH_XL,
452 LENGTH_Y,
453 EXCENT,
454 DEAD1,
455 JTYP,
456 INDX,
457 ICUT
458 ) values ( 21,
459 7, -95.0000, 105.0000, 21, 10.0000, 10.0000, 21.8000,
460 0.0000, 39.2000, 4, 6, 1
461 );
462 insert into ALIN_data2tag values ('ALIN-07', 21);
463 insert into ALIN_data (
464 ALIN_data_id,
465 VERS,
466 DX,
467 DY,
468 I,
469 WIDTH_XS,
470 WIDTH_XL,
471 LENGTH_Y,
472 EXCENT,
473 DEAD1,
474 JTYP,
475 INDX,
476 ICUT
477 ) values ( 22,
478 7, 95.0000, 105.0000, 24, 10.0000, 10.0000, 18.0000,
479 0.0000, 39.2000, 4, 6, 1
480 );
481 insert into ALIN_data2tag values ('ALIN-07', 22);
482 insert into ALIN_data (
483 ALIN_data_id,
484 VERS,
485 DX,
486 DY,
487 I,
488 WIDTH_XS,
489 WIDTH_XL,
490 LENGTH_Y,
491 EXCENT,
492 DEAD1,
493 JTYP,
494 INDX,
495 ICUT
496 ) values ( 23,
497 7, 95.0000, 105.0000, 25, 10.0000, 10.0000, 21.8000,
498 0.0000, 39.2000, 4, 6, 1
499 );
500 insert into ALIN_data2tag values ('ALIN-07', 23);
501 insert into ALIN_data (
502 ALIN_data_id,
503 VERS,
504 DX,
505 DY,
506 I,
507 WIDTH_XS,
508 WIDTH_XL,
509 LENGTH_Y,
510 EXCENT,
511 DEAD1,
512 JTYP,
513 INDX,
514 ICUT
515 ) values ( 24,
516 7, -99.0000, 153.5000, 28, 10.0000, 10.0000, 18.0000,
517 0.0000, 39.2000, 4, 6, 1
518 );
519 insert into ALIN_data2tag values ('ALIN-07', 24);
520 insert into ALIN_data (
521 ALIN_data_id,
522 VERS,
523 DX,
524 DY,
525 I,
526 WIDTH_XS,
527 WIDTH_XL,
528 LENGTH_Y,
529 EXCENT,
530 DEAD1,
531 JTYP,
532 INDX,
533 ICUT
534 ) values ( 25,
535 7, -99.0000, 160.7000, 29, 10.0000, 10.0000, 18.0000,
536 0.0000, 39.2000, 4, 6, 1
537 );
538 insert into ALIN_data2tag values ('ALIN-07', 25);
539 insert into ALIN_data (
540 ALIN_data_id,
541 VERS,
542 DX,
543 DY,
544 I,
545 WIDTH_XS,
546 WIDTH_XL,
547 LENGTH_Y,
548 EXCENT,
549 DEAD1,
550 JTYP,
551 INDX,
552 ICUT
553 ) values ( 26,
554 7, 99.0000, 153.5000, 32, 10.0000, 10.0000, 18.0000,
555 0.0000, 39.2000, 4, 6, 1
556 );
557 insert into ALIN_data2tag values ('ALIN-07', 26);
558 insert into ALIN_data (
559 ALIN_data_id,
560 VERS,
561 DX,
562 DY,
563 I,
564 WIDTH_XS,
565 WIDTH_XL,
566 LENGTH_Y,
567 EXCENT,
568 DEAD1,
569 JTYP,
570 INDX,
571 ICUT
572 ) values ( 27,
573 7, 99.0000, 160.7000, 33, 10.0000, 10.0000, 18.0000,
574 0.0000, 39.2000, 4, 6, 1
575 );
576 insert into ALIN_data2tag values ('ALIN-07', 27);
577 insert into ALIN_data (
578 ALIN_data_id,
579 VERS,
580 DX,
581 DY,
582 I,
583 WIDTH_XS,
584 WIDTH_XL,
585 LENGTH_Y,
586 EXCENT,
587 DEAD1,
588 JTYP,
589 INDX,
590 ICUT
591 ) values ( 28,
592 7, 104.5000, 63.0000, 2, 14.0000, 14.0000, 20.0000,
593 0.0000, 49.7000, 6, 1, 1
594 );
595 insert into ALIN_data2tag values ('ALIN-07', 28);
596 insert into ALIN_data (
597 ALIN_data_id,
598 VERS,
599 DX,
600 DY,
601 I,
602 WIDTH_XS,
603 WIDTH_XL,
604 LENGTH_Y,
605 EXCENT,
606 DEAD1,
607 JTYP,
608 INDX,
609 ICUT
610 ) values ( 29,
611 7, 104.5000, 68.4200, 5, 14.0000, 14.0000, 20.0000,
612 0.0000, 49.7000, 6, 1, 1
613 );
614 insert into ALIN_data2tag values ('ALIN-07', 29);
615 insert into ALIN_data (
616 ALIN_data_id,
617 VERS,
618 DX,
619 DY,
620 I,
621 WIDTH_XS,
622 WIDTH_XL,
623 LENGTH_Y,
624 EXCENT,
625 DEAD1,
626 JTYP,
627 INDX,
628 ICUT
629 ) values ( 30,
630 7, 145.1700, 82.4300, 8, 87.0000, 87.0000, 12.3750,
631 0.0000, 49.7000, 6, 1, 1
632 );
633 insert into ALIN_data2tag values ('ALIN-07', 30);
634 insert into ALIN_data (
635 ALIN_data_id,
636 VERS,
637 DX,
638 DY,
639 I,
640 WIDTH_XS,
641 WIDTH_XL,
642 LENGTH_Y,
643 EXCENT,
644 DEAD1,
645 JTYP,
646 INDX,
647 ICUT
648 ) values ( 31,
649 7, 145.1700, 129.5300, 14, 87.0000, 87.0000, 12.3750,
650 0.0000, 49.7000, 6, 1, 1
651 );
652 insert into ALIN_data2tag values ('ALIN-07', 31);
653 insert into ALIN_data (
654 ALIN_data_id,
655 VERS,
656 DX,
657 DY,
658 I,
659 WIDTH_XS,
660 WIDTH_XL,
661 LENGTH_Y,
662 EXCENT,
663 DEAD1,
664 JTYP,
665 INDX,
666 ICUT
667 ) values ( 32,
668 7, 60.0700, 102.1200, 5, 257.0000, 257.0000, 18.0200,
669 0.0000, 0.0000, 11, 1, 1
670 );
671 insert into ALIN_data2tag values ('ALIN-07', 32);
672 insert into ALIN_data (
673 ALIN_data_id,
674 VERS,
675 DX,
676 DY,
677 I,
678 WIDTH_XS,
679 WIDTH_XL,
680 LENGTH_Y,
681 EXCENT,
682 DEAD1,
683 JTYP,
684 INDX,
685 ICUT
686 ) values ( 33,
687 7, 60.0700, 102.1200, 11, 257.0000, 257.0000, 18.0200,
688 0.0000, 0.0000, 11, 1, 1
689 );
690 insert into ALIN_data2tag values ('ALIN-07', 33);
691 insert into ALIN_data (
692 ALIN_data_id,
693 VERS,
694 DX,
695 DY,
696 I,
697 WIDTH_XS,
698 WIDTH_XL,
699 LENGTH_Y,
700 EXCENT,
701 DEAD1,
702 JTYP,
703 INDX,
704 ICUT
705 ) values ( 34,
706 7, 60.0700, 0.0000, 5, 257.0000, 257.0000, 18.0200,
707 0.0000, 0.0000, 11, 1, 1
708 );
709 insert into ALIN_data2tag values ('ALIN-07', 34);
710 insert into ALIN_data (
711 ALIN_data_id,
712 VERS,
713 DX,
714 DY,
715 I,
716 WIDTH_XS,
717 WIDTH_XL,
718 LENGTH_Y,
719 EXCENT,
720 DEAD1,
721 JTYP,
722 INDX,
723 ICUT
724 ) values ( 35,
725 7, 60.0700, 0.0000, 11, 257.0000, 257.0000, 18.0200,
726 0.0000, 0.0000, 11, 1, 1
727 );
728 insert into ALIN_data2tag values ('ALIN-07', 35);
729 insert into ALIN_data (
730 ALIN_data_id,
731 VERS,
732 DX,
733 DY,
734 I,
735 WIDTH_XS,
736 WIDTH_XL,
737 LENGTH_Y,
738 EXCENT,
739 DEAD1,
740 JTYP,
741 INDX,
742 ICUT
743 ) values ( 36,
744 7, 60.0700, 102.1200, 5, 257.0000, 257.0000, 18.0200,
745 0.0000, 0.0000, 11, 2, 1
746 );
747 insert into ALIN_data2tag values ('ALIN-07', 36);
748 insert into ALIN_data (
749 ALIN_data_id,
750 VERS,
751 DX,
752 DY,
753 I,
754 WIDTH_XS,
755 WIDTH_XL,
756 LENGTH_Y,
757 EXCENT,
758 DEAD1,
759 JTYP,
760 INDX,
761 ICUT
762 ) values ( 37,
763 7, 60.0700, 102.1200, 11, 257.0000, 257.0000, 18.0200,
764 0.0000, 0.0000, 11, 2, 1
765 );
766 insert into ALIN_data2tag values ('ALIN-07', 37);
767 insert into ALIN_data (
768 ALIN_data_id,
769 VERS,
770 DX,
771 DY,
772 I,
773 WIDTH_XS,
774 WIDTH_XL,
775 LENGTH_Y,
776 EXCENT,
777 DEAD1,
778 JTYP,
779 INDX,
780 ICUT
781 ) values ( 38,
782 7, 60.0700, 0.0000, 5, 257.0000, 257.0000, 18.0200,
783 0.0000, 0.0000, 11, 2, 1
784 );
785 insert into ALIN_data2tag values ('ALIN-07', 38);
786 insert into ALIN_data (
787 ALIN_data_id,
788 VERS,
789 DX,
790 DY,
791 I,
792 WIDTH_XS,
793 WIDTH_XL,
794 LENGTH_Y,
795 EXCENT,
796 DEAD1,
797 JTYP,
798 INDX,
799 ICUT
800 ) values ( 39,
801 7, 60.0700, 0.0000, 11, 257.0000, 257.0000, 18.0200,
802 0.0000, 0.0000, 11, 2, 1
803 );
804 insert into ALIN_data2tag values ('ALIN-07', 39);
805 insert into ALIN_data (
806 ALIN_data_id,
807 VERS,
808 DX,
809 DY,
810 I,
811 WIDTH_XS,
812 WIDTH_XL,
813 LENGTH_Y,
814 EXCENT,
815 DEAD1,
816 JTYP,
817 INDX,
818 ICUT
819 ) values ( 40,
820 7, -60.0700, 102.1200, 5, 257.0000, 257.0000, 18.0200,
821 0.0000, 0.0000, 11, 4, 1
822 );
823 insert into ALIN_data2tag values ('ALIN-07', 40);
824 insert into ALIN_data (
825 ALIN_data_id,
826 VERS,
827 DX,
828 DY,
829 I,
830 WIDTH_XS,
831 WIDTH_XL,
832 LENGTH_Y,
833 EXCENT,
834 DEAD1,
835 JTYP,
836 INDX,
837 ICUT
838 ) values ( 41,
839 7, -60.0700, 102.1200, 11, 257.0000, 257.0000, 18.0200,
840 0.0000, 0.0000, 11, 4, 1
841 );
842 insert into ALIN_data2tag values ('ALIN-07', 41);
843 insert into ALIN_data (
844 ALIN_data_id,
845 VERS,
846 DX,
847 DY,
848 I,
849 WIDTH_XS,
850 WIDTH_XL,
851 LENGTH_Y,
852 EXCENT,
853 DEAD1,
854 JTYP,
855 INDX,
856 ICUT
857 ) values ( 42,
858 7, -60.0700, 0.0000, 5, 257.0000, 257.0000, 18.0200,
859 0.0000, 0.0000, 11, 4, 1
860 );
861 insert into ALIN_data2tag values ('ALIN-07', 42);
862 insert into ALIN_data (
863 ALIN_data_id,
864 VERS,
865 DX,
866 DY,
867 I,
868 WIDTH_XS,
869 WIDTH_XL,
870 LENGTH_Y,
871 EXCENT,
872 DEAD1,
873 JTYP,
874 INDX,
875 ICUT
876 ) values ( 43,
877 7, -60.0700, 0.0000, 11, 257.0000, 257.0000, 18.0200,
878 0.0000, 0.0000, 11, 4, 1
879 );
880 insert into ALIN_data2tag values ('ALIN-07', 43);
881 insert into ALIN_data (
882 ALIN_data_id,
883 VERS,
884 DX,
885 DY,
886 I,
887 WIDTH_XS,
888 WIDTH_XL,
889 LENGTH_Y,
890 EXCENT,
891 DEAD1,
892 JTYP,
893 INDX,
894 ICUT
895 ) values ( 44,
896 7, -60.0700, 102.1200, 5, 257.0000, 257.0000, 18.0200,
897 0.0000, 0.0000, 11, 5, 1
898 );
899 insert into ALIN_data2tag values ('ALIN-07', 44);
900 insert into ALIN_data (
901 ALIN_data_id,
902 VERS,
903 DX,
904 DY,
905 I,
906 WIDTH_XS,
907 WIDTH_XL,
908 LENGTH_Y,
909 EXCENT,
910 DEAD1,
911 JTYP,
912 INDX,
913 ICUT
914 ) values ( 45,
915 7, -60.0700, 102.1200, 11, 257.0000, 257.0000, 18.0200,
916 0.0000, 0.0000, 11, 5, 1
917 );
918 insert into ALIN_data2tag values ('ALIN-07', 45);
919 insert into ALIN_data (
920 ALIN_data_id,
921 VERS,
922 DX,
923 DY,
924 I,
925 WIDTH_XS,
926 WIDTH_XL,
927 LENGTH_Y,
928 EXCENT,
929 DEAD1,
930 JTYP,
931 INDX,
932 ICUT
933 ) values ( 46,
934 7, -60.0700, 0.0000, 5, 257.0000, 257.0000, 18.0200,
935 0.0000, 0.0000, 11, 5, 1
936 );
937 insert into ALIN_data2tag values ('ALIN-07', 46);
938 insert into ALIN_data (
939 ALIN_data_id,
940 VERS,
941 DX,
942 DY,
943 I,
944 WIDTH_XS,
945 WIDTH_XL,
946 LENGTH_Y,
947 EXCENT,
948 DEAD1,
949 JTYP,
950 INDX,
951 ICUT
952 ) values ( 47,
953 7, -60.0700, 0.0000, 11, 257.0000, 257.0000, 18.0200,
954 0.0000, 0.0000, 11, 5, 1
955 );
956 insert into ALIN_data2tag values ('ALIN-07', 47);
957 insert into ALIN_data (
958 ALIN_data_id,
959 VERS,
960 DX,
961 DY,
962 I,
963 WIDTH_XS,
964 WIDTH_XL,
965 LENGTH_Y,
966 EXCENT,
967 DEAD1,
968 JTYP,
969 INDX,
970 ICUT
971 ) values ( 48,
972 7, -36.6300, 127.0000, 1, 58.3000, 58.3000, 11.0000,
973 0.0000, 0.0000, 19, 1, 1
974 );
975 insert into ALIN_data2tag values ('ALIN-07', 48);
976 insert into ALIN_data (
977 ALIN_data_id,
978 VERS,
979 DX,
980 DY,
981 I,
982 WIDTH_XS,
983 WIDTH_XL,
984 LENGTH_Y,
985 EXCENT,
986 DEAD1,
987 JTYP,
988 INDX,
989 ICUT
990 ) values ( 49,
991 7, -36.6300, 127.0000, 7, 58.3000, 58.3000, 11.0000,
992 0.0000, 0.0000, 19, 1, 1
993 );
994 insert into ALIN_data2tag values ('ALIN-07', 49);
995 insert into ALIN_data (
996 ALIN_data_id,
997 VERS,
998 DX,
999 DY,
1000 I,
1001 WIDTH_XS,
1002 WIDTH_XL,
1003 LENGTH_Y,
1004 EXCENT,
1005 DEAD1,
1006 JTYP,
1007 INDX,
1008 ICUT
1009 ) values ( 50,
1010 7, -94.7300, 106.5000, 1, 58.1000, 58.1000, 11.5000,
1011 0.0000, 21.7200, 19, 3, 1
1012 );
1013 insert into ALIN_data2tag values ('ALIN-07', 50);
1014 insert into ALIN_data (
1015 ALIN_data_id,
1016 VERS,
1017 DX,
1018 DY,
1019 I,
1020 WIDTH_XS,
1021 WIDTH_XL,
1022 LENGTH_Y,
1023 EXCENT,
1024 DEAD1,
1025 JTYP,
1026 INDX,
1027 ICUT
1028 ) values ( 51,
1029 7, -97.2800, 117.1360, 7, 60.2000, 60.2000, 11.5000,
1030 0.0000, 21.7200, 19, 3, 1
1031 );
1032 insert into ALIN_data2tag values ('ALIN-07', 51);
1033 insert into ALIN_data (
1034 ALIN_data_id,
1035 VERS,
1036 DX,
1037 DY,
1038 I,
1039 WIDTH_XS,
1040 WIDTH_XL,
1041 LENGTH_Y,
1042 EXCENT,
1043 DEAD1,
1044 JTYP,
1045 INDX,
1046 ICUT
1047 ) values ( 52,
1048 7, -19.5400, 302.8000, 1, 15.0000, 15.0000, 15.0000,
1049 0.0000, 0.0000, 42, 1, 1
1050 );
1051 insert into ALIN_data2tag values ('ALIN-07', 52);
1052 insert into ALIN_data (
1053 ALIN_data_id,
1054 VERS,
1055 DX,
1056 DY,
1057 I,
1058 WIDTH_XS,
1059 WIDTH_XL,
1060 LENGTH_Y,
1061 EXCENT,
1062 DEAD1,
1063 JTYP,
1064 INDX,
1065 ICUT
1066 ) values ( 53,
1067 7, -34.9700, 676.7500, 2, 16.0000, 16.0000, 20.5000,
1068 0.0000, 21.0000, 43, 1, 1
1069 );
1070 insert into ALIN_data2tag values ('ALIN-07', 53);
1071 insert into ALIN_data (
1072 ALIN_data_id,
1073 VERS,
1074 DX,
1075 DY,
1076 I,
1077 WIDTH_XS,
1078 WIDTH_XL,
1079 LENGTH_Y,
1080 EXCENT,
1081 DEAD1,
1082 JTYP,
1083 INDX,
1084 ICUT
1085 ) values ( 54,
1086 7, -19.5400, 302.8000, 1, 15.0000, 15.0000, 15.0000,
1087 0.0000, 0.0000, 44, 1, 1
1088 );
1089 insert into ALIN_data2tag values ('ALIN-07', 54);
1090 insert into ALIN_data (
1091 ALIN_data_id,
1092 VERS,
1093 DX,
1094 DY,
1095 I,
1096 WIDTH_XS,
1097 WIDTH_XL,
1098 LENGTH_Y,
1099 EXCENT,
1100 DEAD1,
1101 JTYP,
1102 INDX,
1103 ICUT
1104 ) values ( 55,
1105 7, -34.9800, 729.9900, 2, 16.0000, 16.0000, 20.5000,
1106 0.0000, 21.0000, 45, 1, 1
1107 );
1108 insert into ALIN_data2tag values ('ALIN-07', 55);
1109 insert into ALIN_data (
1110 ALIN_data_id,
1111 VERS,
1112 DX,
1113 DY,
1114 I,
1115 WIDTH_XS,
1116 WIDTH_XL,
1117 LENGTH_Y,
1118 EXCENT,
1119 DEAD1,
1120 JTYP,
1121 INDX,
1122 ICUT
1123 ) values ( 56,
1124 7, -19.5400, 302.8000, 1, 15.0000, 15.0000, 15.0000,
1125 0.0000, 0.0000, 46, 1, 1
1126 );
1127 insert into ALIN_data2tag values ('ALIN-07', 56);
1128 insert into ALIN_data (
1129 ALIN_data_id,
1130 VERS,
1131 DX,
1132 DY,
1133 I,
1134 WIDTH_XS,
1135 WIDTH_XL,
1136 LENGTH_Y,
1137 EXCENT,
1138 DEAD1,
1139 JTYP,
1140 INDX,
1141 ICUT
1142 ) values ( 57,
1143 7, -34.9800, 746.8200, 2, 16.0000, 15.0000, 20.5000,
1144 0.0000, 21.0000, 47, 1, 1
1145 );
1146 insert into ALIN_data2tag values ('ALIN-07', 57);
1147 insert into ALIN_data (
1148 ALIN_data_id,
1149 VERS,
1150 DX,
1151 DY,
1152 I,
1153 WIDTH_XS,
1154 WIDTH_XL,
1155 LENGTH_Y,
1156 EXCENT,
1157 DEAD1,
1158 JTYP,
1159 INDX,
1160 ICUT
1161 ) values ( 58,
1162 7, 0.0000, 114.6900, 1, 120.0000, 120.0000, 20.0000,
1163 0.0000, 0.0000, 52, 1, 1
1164 );
1165 insert into ALIN_data2tag values ('ALIN-07', 58);
1166 insert into ALIN_data (
1167 ALIN_data_id,
1168 VERS,
1169 DX,
1170 DY,
1171 I,
1172 WIDTH_XS,
1173 WIDTH_XL,
1174 LENGTH_Y,
1175 EXCENT,
1176 DEAD1,
1177 JTYP,
1178 INDX,
1179 ICUT
1180 ) values ( 59,
1181 7, 0.0000, 112.9200, 2, 120.0000, 120.0000, 20.0000,
1182 0.0000, 0.0000, 52, 1, 1
1183 );
1184 insert into ALIN_data2tag values ('ALIN-07', 59);
1185
1186 comment on column ALIN_data.ALIN_data_id is 'Unique identifier';
1187 comment on column ALIN_data.VERS is 'VERSION ';
1188 comment on column ALIN_data.DX is 'X RELATIVE POSITION OF THE SUB-CUT ';
1189 comment on column ALIN_data.DY is 'Y RELATIVE POSITION OF THE SUB-CUT ';
1190 comment on column ALIN_data.I is 'SERIAL NB. OF THE OBJECT IN WHICH THE SU ';
1191 comment on column ALIN_data.WIDTH_XS is 'S DIMENSIONS OF THE SUB-CUT ';
1192 comment on column ALIN_data.WIDTH_XL is 'L DIMENSIONS OF THE SUB-CUT ';
1193 comment on column ALIN_data.LENGTH_Y is 'Y DIMENSIONS OF THE SUB-CUT ';
1194 comment on column ALIN_data.EXCENT is 'EXC DIMENSIONS OF THE SUB-CUT ';
1195 comment on column ALIN_data.DEAD1 is 'D1 DIMENSIONS OF THE SUB-CUT ';
1196 comment on column ALIN_data.JTYP is 'STATION TYPE ';
1197 comment on column ALIN_data.INDX is 'INDEX ';
1198 comment on column ALIN_data.ICUT is 'CUT-OUT INDEX ';
| 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.
|
|