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