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