001 SET echo OFF;
002 set linesize 132;
003 drop table AWLN_data2tag cascade constraints;
004 drop table AWLN_data cascade constraints;
005 create table AWLN_data (
006 AWLN_data_id number(10),
007 VERS number(10),
008 JSTA number(10),
009 SPITCH float(63),
010 ZPITCH float(63),
011 DEDSTR float(63),
012 NSREST number(10),
013 NZREST number(10),
014 SFIRST float(63),
015 ZFIRST float(63),
016 DEDSEP float(63),
017 NSROST number(10),
018 NZROST number(10)
019 ) tablespace data02;
020
021 alter table AWLN_data add constraint AWLN_data_pk
022 primary key (AWLN_data_id)
023 using index tablespace indx02;
024
025 create table AWLN_data2tag (
026 AWLN_vers varchar2(255),
027 AWLN_data_id number(10)
028 ) tablespace data02;
029
030 alter table AWLN_data2tag add constraint AWLN_data2tag_pk
031 primary key (AWLN_vers, AWLN_data_id)
032 using index tablespace indx02;
033 alter table AWLN_data2tag add constraint AWLN_data2tag_vers_fk
034 foreign key (AWLN_vers) references hvs_nodevers (vers_name);
035 alter table AWLN_data2tag add constraint AWLN_data2tag_data_fk
036 foreign key (AWLN_data_id) references AWLN_data (AWLN_data_id);
037
038 delete from hvs_relation where CHILD_NODENAME = 'AWLN';
039 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
040 delete from hvs_nodevers where NODE_NAME = 'AWLN';
041 delete from hvs_node where NODE_NAME = 'AWLN';
042
043 insert into hvs_node values ('AWLN','MuonSpectrometer', '');
044 insert into hvs_nodevers values ('AWLN', 'AWLN-07', '');
045 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
046 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','AWLN','AWLN-07');
047 insert into AWLN_data (
048 AWLN_data_id,
049 VERS,
050 JSTA,
051 SPITCH,
052 ZPITCH,
053 DEDSTR,
054 NSREST,
055 NZREST,
056 SFIRST,
057 ZFIRST,
058 DEDSEP,
059 NSROST,
060 NZROST
061 ) values ( 0,
062 7, 1, 3.0500, 2.7200, 0.2000, 2, 1, 8.0000,
063 8.0000, 1.0000, 48, 40
064 );
065 insert into AWLN_data2tag values ('AWLN-07', 0);
066 insert into AWLN_data (
067 AWLN_data_id,
068 VERS,
069 JSTA,
070 SPITCH,
071 ZPITCH,
072 DEDSTR,
073 NSREST,
074 NZREST,
075 SFIRST,
076 ZFIRST,
077 DEDSEP,
078 NSROST,
079 NZROST
080 ) values ( 1,
081 7, 2, 3.0500, 2.6400, 0.2000, 2, 1, 8.0000,
082 9.0000, 1.0000, 48, 40
083 );
084 insert into AWLN_data2tag values ('AWLN-07', 1);
085 insert into AWLN_data (
086 AWLN_data_id,
087 VERS,
088 JSTA,
089 SPITCH,
090 ZPITCH,
091 DEDSTR,
092 NSREST,
093 NZREST,
094 SFIRST,
095 ZFIRST,
096 DEDSEP,
097 NSROST,
098 NZROST
099 ) values ( 2,
100 7, 3, 3.0500, 3.0200, 0.2000, 2, 1, 8.0000,
101 8.8000, 1.0000, 48, 32
102 );
103 insert into AWLN_data2tag values ('AWLN-07', 2);
104 insert into AWLN_data (
105 AWLN_data_id,
106 VERS,
107 JSTA,
108 SPITCH,
109 ZPITCH,
110 DEDSTR,
111 NSREST,
112 NZREST,
113 SFIRST,
114 ZFIRST,
115 DEDSEP,
116 NSROST,
117 NZROST
118 ) values ( 3,
119 7, 4, 3.0500, 2.9300, 0.2000, 2, 1, 8.0000,
120 8.2000, 1.0000, 48, 32
121 );
122 insert into AWLN_data2tag values ('AWLN-07', 3);
123 insert into AWLN_data (
124 AWLN_data_id,
125 VERS,
126 JSTA,
127 SPITCH,
128 ZPITCH,
129 DEDSTR,
130 NSREST,
131 NZREST,
132 SFIRST,
133 ZFIRST,
134 DEDSEP,
135 NSROST,
136 NZROST
137 ) values ( 4,
138 7, 5, 3.0500, 2.6500, 0.2000, 2, 1, 8.0000,
139 8.0000, 1.0000, 48, 32
140 );
141 insert into AWLN_data2tag values ('AWLN-07', 4);
142 insert into AWLN_data (
143 AWLN_data_id,
144 VERS,
145 JSTA,
146 SPITCH,
147 ZPITCH,
148 DEDSTR,
149 NSREST,
150 NZREST,
151 SFIRST,
152 ZFIRST,
153 DEDSEP,
154 NSROST,
155 NZROST
156 ) values ( 5,
157 7, 6, 3.0500, 3.0300, 0.2000, 2, 1, 8.0000,
158 8.4000, 1.0000, 48, 24
159 );
160 insert into AWLN_data2tag values ('AWLN-07', 5);
161 insert into AWLN_data (
162 AWLN_data_id,
163 VERS,
164 JSTA,
165 SPITCH,
166 ZPITCH,
167 DEDSTR,
168 NSREST,
169 NZREST,
170 SFIRST,
171 ZFIRST,
172 DEDSEP,
173 NSROST,
174 NZROST
175 ) values ( 6,
176 7, 7, 3.2600, 3.7000, 0.2000, 1, 1, 8.0000,
177 8.0000, 1.0000, 32, 8
178 );
179 insert into AWLN_data2tag values ('AWLN-07', 6);
180 insert into AWLN_data (
181 AWLN_data_id,
182 VERS,
183 JSTA,
184 SPITCH,
185 ZPITCH,
186 DEDSTR,
187 NSREST,
188 NZREST,
189 SFIRST,
190 ZFIRST,
191 DEDSEP,
192 NSROST,
193 NZROST
194 ) values ( 7,
195 7, 8, 3.2600, 2.6500, 0.2000, 1, 1, 8.0000,
196 8.0000, 1.0000, 32, 24
197 );
198 insert into AWLN_data2tag values ('AWLN-07', 7);
199 insert into AWLN_data (
200 AWLN_data_id,
201 VERS,
202 JSTA,
203 SPITCH,
204 ZPITCH,
205 DEDSTR,
206 NSREST,
207 NZREST,
208 SFIRST,
209 ZFIRST,
210 DEDSEP,
211 NSROST,
212 NZROST
213 ) values ( 8,
214 7, 9, 2.6600, 2.9400, 0.2000, 2, 2, 8.8000,
215 9.0000, 1.0000, 64, 40
216 );
217 insert into AWLN_data2tag values ('AWLN-07', 8);
218 insert into AWLN_data (
219 AWLN_data_id,
220 VERS,
221 JSTA,
222 SPITCH,
223 ZPITCH,
224 DEDSTR,
225 NSREST,
226 NZREST,
227 SFIRST,
228 ZFIRST,
229 DEDSEP,
230 NSROST,
231 NZROST
232 ) values ( 9,
233 7, 10, 2.6600, 2.6500, 0.2000, 2, 2, 8.8000,
234 8.0000, 1.0000, 64, 32
235 );
236 insert into AWLN_data2tag values ('AWLN-07', 9);
237 insert into AWLN_data (
238 AWLN_data_id,
239 VERS,
240 JSTA,
241 SPITCH,
242 ZPITCH,
243 DEDSTR,
244 NSREST,
245 NZREST,
246 SFIRST,
247 ZFIRST,
248 DEDSEP,
249 NSROST,
250 NZROST
251 ) values ( 10,
252 7, 11, 2.6600, 3.0300, 0.2000, 2, 2, 8.8000,
253 8.4000, 1.0000, 64, 24
254 );
255 insert into AWLN_data2tag values ('AWLN-07', 10);
256 insert into AWLN_data (
257 AWLN_data_id,
258 VERS,
259 JSTA,
260 SPITCH,
261 ZPITCH,
262 DEDSTR,
263 NSREST,
264 NZREST,
265 SFIRST,
266 ZFIRST,
267 DEDSEP,
268 NSROST,
269 NZROST
270 ) values ( 11,
271 7, 12, 2.6800, 2.8500, 0.2000, 2, 2, 9.6000,
272 9.0000, 1.0000, 56, 16
273 );
274 insert into AWLN_data2tag values ('AWLN-07', 11);
275 insert into AWLN_data (
276 AWLN_data_id,
277 VERS,
278 JSTA,
279 SPITCH,
280 ZPITCH,
281 DEDSTR,
282 NSREST,
283 NZREST,
284 SFIRST,
285 ZFIRST,
286 DEDSEP,
287 NSROST,
288 NZROST
289 ) values ( 12,
290 7, 13, 2.8300, 3.4000, 0.2000, 2, 2, 9.4000,
291 8.0000, 1.0000, 64, 32
292 );
293 insert into AWLN_data2tag values ('AWLN-07', 12);
294 insert into AWLN_data (
295 AWLN_data_id,
296 VERS,
297 JSTA,
298 SPITCH,
299 ZPITCH,
300 DEDSTR,
301 NSREST,
302 NZREST,
303 SFIRST,
304 ZFIRST,
305 DEDSEP,
306 NSROST,
307 NZROST
308 ) values ( 13,
309 7, 14, 2.8300, 3.0200, 0.2000, 2, 2, 9.4000,
310 8.8000, 1.0000, 64, 32
311 );
312 insert into AWLN_data2tag values ('AWLN-07', 13);
313 insert into AWLN_data (
314 AWLN_data_id,
315 VERS,
316 JSTA,
317 SPITCH,
318 ZPITCH,
319 DEDSTR,
320 NSREST,
321 NZREST,
322 SFIRST,
323 ZFIRST,
324 DEDSEP,
325 NSROST,
326 NZROST
327 ) values ( 14,
328 7, 15, 2.8300, 2.6500, 0.2000, 2, 2, 9.4000,
329 8.0000, 1.0000, 64, 32
330 );
331 insert into AWLN_data2tag values ('AWLN-07', 14);
332 insert into AWLN_data (
333 AWLN_data_id,
334 VERS,
335 JSTA,
336 SPITCH,
337 ZPITCH,
338 DEDSTR,
339 NSREST,
340 NZREST,
341 SFIRST,
342 ZFIRST,
343 DEDSEP,
344 NSROST,
345 NZROST
346 ) values ( 15,
347 7, 16, 2.8300, 3.0300, 0.2000, 2, 2, 9.4000,
348 8.4000, 1.0000, 64, 24
349 );
350 insert into AWLN_data2tag values ('AWLN-07', 15);
351 insert into AWLN_data (
352 AWLN_data_id,
353 VERS,
354 JSTA,
355 SPITCH,
356 ZPITCH,
357 DEDSTR,
358 NSREST,
359 NZREST,
360 SFIRST,
361 ZFIRST,
362 DEDSEP,
363 NSROST,
364 NZROST
365 ) values ( 16,
366 7, 17, 2.8300, 2.6500, 0.2000, 2, 2, 9.4000,
367 8.0000, 1.0000, 64, 32
368 );
369 insert into AWLN_data2tag values ('AWLN-07', 16);
370 insert into AWLN_data (
371 AWLN_data_id,
372 VERS,
373 JSTA,
374 SPITCH,
375 ZPITCH,
376 DEDSTR,
377 NSREST,
378 NZREST,
379 SFIRST,
380 ZFIRST,
381 DEDSEP,
382 NSROST,
383 NZROST
384 ) values ( 17,
385 7, 18, 3.0100, 3.4000, 0.2000, 2, 2, 8.5000,
386 8.0000, 1.0000, 80, 32
387 );
388 insert into AWLN_data2tag values ('AWLN-07', 17);
389 insert into AWLN_data (
390 AWLN_data_id,
391 VERS,
392 JSTA,
393 SPITCH,
394 ZPITCH,
395 DEDSTR,
396 NSREST,
397 NZREST,
398 SFIRST,
399 ZFIRST,
400 DEDSEP,
401 NSROST,
402 NZROST
403 ) values ( 18,
404 7, 19, 3.0100, 3.5300, 0.2000, 2, 2, 8.5000,
405 8.4000, 1.0000, 80, 24
406 );
407 insert into AWLN_data2tag values ('AWLN-07', 18);
408 insert into AWLN_data (
409 AWLN_data_id,
410 VERS,
411 JSTA,
412 SPITCH,
413 ZPITCH,
414 DEDSTR,
415 NSREST,
416 NZREST,
417 SFIRST,
418 ZFIRST,
419 DEDSEP,
420 NSROST,
421 NZROST
422 ) values ( 19,
423 7, 20, 3.0100, 3.0300, 0.2000, 2, 2, 8.5000,
424 8.4000, 1.0000, 80, 24
425 );
426 insert into AWLN_data2tag values ('AWLN-07', 19);
427 insert into AWLN_data (
428 AWLN_data_id,
429 VERS,
430 JSTA,
431 SPITCH,
432 ZPITCH,
433 DEDSTR,
434 NSREST,
435 NZREST,
436 SFIRST,
437 ZFIRST,
438 DEDSEP,
439 NSROST,
440 NZROST
441 ) values ( 20,
442 7, 21, 3.0500, 2.9400, 0.2000, 2, 2, 8.0000,
443 9.0000, 1.0000, 48, 40
444 );
445 insert into AWLN_data2tag values ('AWLN-07', 20);
446 insert into AWLN_data (
447 AWLN_data_id,
448 VERS,
449 JSTA,
450 SPITCH,
451 ZPITCH,
452 DEDSTR,
453 NSREST,
454 NZREST,
455 SFIRST,
456 ZFIRST,
457 DEDSEP,
458 NSROST,
459 NZROST
460 ) values ( 21,
461 7, 22, 2.8300, 2.9400, 0.2000, 2, 2, 9.4000,
462 9.0000, 1.0000, 64, 40
463 );
464 insert into AWLN_data2tag values ('AWLN-07', 21);
465
466 comment on column AWLN_data.AWLN_data_id is 'Unique identifier';
467 comment on column AWLN_data.VERS is 'VERSION ';
468 comment on column AWLN_data.JSTA is 'JSTA TYPE NUMBER ';
469 comment on column AWLN_data.SPITCH is 'S-STRIPS PITCH ';
470 comment on column AWLN_data.ZPITCH is 'Z-STRIPS PITCH ';
471 comment on column AWLN_data.DEDSTR is 'DEAD REAGION BETWEEN STRIP ';
472 comment on column AWLN_data.NSREST is 'NBER OF S STRIPS READOUTS ';
473 comment on column AWLN_data.NZREST is 'NBER OF S GAS GAPS ';
474 comment on column AWLN_data.SFIRST is 'S-PHI STRIP OFFSET ';
475 comment on column AWLN_data.ZFIRST is 'Z-ETA STRIP OFFSET ';
476 comment on column AWLN_data.DEDSEP is 'DEAD SEPARATION ';
477 comment on column AWLN_data.NSROST is 'NUMBER OF S-PHI READOUT STRIPS ';
478 comment on column AWLN_data.NZROST is 'NUMBER OF Z-ETA READOUT STRIPS ';
| 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.
|
|