001 SET echo OFF;
002 set linesize 132;
003 drop table ATYP_data2tag cascade constraints;
004 drop table ATYP_data cascade constraints;
005 create table ATYP_data (
006 ATYP_data_id number(10),
007 VERS number(10),
008 JTYP number(10),
009 TYP varchar2(4),
010 NSTA number(10)
011 ) tablespace data02;
012
013 alter table ATYP_data add constraint ATYP_data_pk
014 primary key (ATYP_data_id)
015 using index tablespace indx02;
016
017 create table ATYP_data2tag (
018 ATYP_vers varchar2(255),
019 ATYP_data_id number(10)
020 ) tablespace data02;
021
022 alter table ATYP_data2tag add constraint ATYP_data2tag_pk
023 primary key (ATYP_vers, ATYP_data_id)
024 using index tablespace indx02;
025 alter table ATYP_data2tag add constraint ATYP_data2tag_vers_fk
026 foreign key (ATYP_vers) references hvs_nodevers (vers_name);
027 alter table ATYP_data2tag add constraint ATYP_data2tag_data_fk
028 foreign key (ATYP_data_id) references ATYP_data (ATYP_data_id);
029
030 delete from hvs_relation where CHILD_NODENAME = 'ATYP';
031 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
032 delete from hvs_nodevers where NODE_NAME = 'ATYP';
033 delete from hvs_node where NODE_NAME = 'ATYP';
034
035 insert into hvs_node values ('ATYP','MuonSpectrometer', '');
036 insert into hvs_nodevers values ('ATYP', 'ATYP-07', '');
037 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
038 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','ATYP','ATYP-07');
039 insert into ATYP_data (
040 ATYP_data_id,
041 VERS,
042 JTYP,
043 TYP,
044 NSTA
045 ) values ( 0,
046 7, 1,'BIL', 3
047 );
048 insert into ATYP_data2tag values ('ATYP-07', 0);
049 insert into ATYP_data (
050 ATYP_data_id,
051 VERS,
052 JTYP,
053 TYP,
054 NSTA
055 ) values ( 1,
056 7, 2,'BIS', 6
057 );
058 insert into ATYP_data2tag values ('ATYP-07', 1);
059 insert into ATYP_data (
060 ATYP_data_id,
061 VERS,
062 JTYP,
063 TYP,
064 NSTA
065 ) values ( 2,
066 7, 3,'BML', 9
067 );
068 insert into ATYP_data2tag values ('ATYP-07', 2);
069 insert into ATYP_data (
070 ATYP_data_id,
071 VERS,
072 JTYP,
073 TYP,
074 NSTA
075 ) values ( 3,
076 7, 4,'BMS', 6
077 );
078 insert into ATYP_data2tag values ('ATYP-07', 3);
079 insert into ATYP_data (
080 ATYP_data_id,
081 VERS,
082 JTYP,
083 TYP,
084 NSTA
085 ) values ( 4,
086 7, 5,'BOL', 7
087 );
088 insert into ATYP_data2tag values ('ATYP-07', 4);
089 insert into ATYP_data (
090 ATYP_data_id,
091 VERS,
092 JTYP,
093 TYP,
094 NSTA
095 ) values ( 5,
096 7, 6,'BOS', 3
097 );
098 insert into ATYP_data2tag values ('ATYP-07', 5);
099 insert into ATYP_data (
100 ATYP_data_id,
101 VERS,
102 JTYP,
103 TYP,
104 NSTA
105 ) values ( 6,
106 7, 7,'BEE', 1
107 );
108 insert into ATYP_data2tag values ('ATYP-07', 6);
109 insert into ATYP_data (
110 ATYP_data_id,
111 VERS,
112 JTYP,
113 TYP,
114 NSTA
115 ) values ( 7,
116 7, 8,'BIR', 6
117 );
118 insert into ATYP_data2tag values ('ATYP-07', 7);
119 insert into ATYP_data (
120 ATYP_data_id,
121 VERS,
122 JTYP,
123 TYP,
124 NSTA
125 ) values ( 8,
126 7, 9,'BMF', 3
127 );
128 insert into ATYP_data2tag values ('ATYP-07', 8);
129 insert into ATYP_data (
130 ATYP_data_id,
131 VERS,
132 JTYP,
133 TYP,
134 NSTA
135 ) values ( 9,
136 7, 10,'BOF', 8
137 );
138 insert into ATYP_data2tag values ('ATYP-07', 9);
139 insert into ATYP_data (
140 ATYP_data_id,
141 VERS,
142 JTYP,
143 TYP,
144 NSTA
145 ) values ( 10,
146 7, 11,'BOG', 6
147 );
148 insert into ATYP_data2tag values ('ATYP-07', 10);
149 insert into ATYP_data (
150 ATYP_data_id,
151 VERS,
152 JTYP,
153 TYP,
154 NSTA
155 ) values ( 11,
156 7, 14,'EIL', 9
157 );
158 insert into ATYP_data2tag values ('ATYP-07', 11);
159 insert into ATYP_data (
160 ATYP_data_id,
161 VERS,
162 JTYP,
163 TYP,
164 NSTA
165 ) values ( 12,
166 7, 15,'EEL', 3
167 );
168 insert into ATYP_data2tag values ('ATYP-07', 12);
169 insert into ATYP_data (
170 ATYP_data_id,
171 VERS,
172 JTYP,
173 TYP,
174 NSTA
175 ) values ( 13,
176 7, 16,'EES', 2
177 );
178 insert into ATYP_data2tag values ('ATYP-07', 13);
179 insert into ATYP_data (
180 ATYP_data_id,
181 VERS,
182 JTYP,
183 TYP,
184 NSTA
185 ) values ( 14,
186 7, 18,'EML', 5
187 );
188 insert into ATYP_data2tag values ('ATYP-07', 14);
189 insert into ATYP_data (
190 ATYP_data_id,
191 VERS,
192 JTYP,
193 TYP,
194 NSTA
195 ) values ( 15,
196 7, 19,'EMS', 5
197 );
198 insert into ATYP_data2tag values ('ATYP-07', 15);
199 insert into ATYP_data (
200 ATYP_data_id,
201 VERS,
202 JTYP,
203 TYP,
204 NSTA
205 ) values ( 16,
206 7, 21,'EOL', 6
207 );
208 insert into ATYP_data2tag values ('ATYP-07', 16);
209 insert into ATYP_data (
210 ATYP_data_id,
211 VERS,
212 JTYP,
213 TYP,
214 NSTA
215 ) values ( 17,
216 7, 22,'EOS', 6
217 );
218 insert into ATYP_data2tag values ('ATYP-07', 17);
219 insert into ATYP_data (
220 ATYP_data_id,
221 VERS,
222 JTYP,
223 TYP,
224 NSTA
225 ) values ( 18,
226 7, 42,'T1F', 1
227 );
228 insert into ATYP_data2tag values ('ATYP-07', 18);
229 insert into ATYP_data (
230 ATYP_data_id,
231 VERS,
232 JTYP,
233 TYP,
234 NSTA
235 ) values ( 19,
236 7, 43,'T1E', 1
237 );
238 insert into ATYP_data2tag values ('ATYP-07', 19);
239 insert into ATYP_data (
240 ATYP_data_id,
241 VERS,
242 JTYP,
243 TYP,
244 NSTA
245 ) values ( 20,
246 7, 44,'T2F', 1
247 );
248 insert into ATYP_data2tag values ('ATYP-07', 20);
249 insert into ATYP_data (
250 ATYP_data_id,
251 VERS,
252 JTYP,
253 TYP,
254 NSTA
255 ) values ( 21,
256 7, 45,'T2E', 1
257 );
258 insert into ATYP_data2tag values ('ATYP-07', 21);
259 insert into ATYP_data (
260 ATYP_data_id,
261 VERS,
262 JTYP,
263 TYP,
264 NSTA
265 ) values ( 22,
266 7, 46,'T3F', 1
267 );
268 insert into ATYP_data2tag values ('ATYP-07', 22);
269 insert into ATYP_data (
270 ATYP_data_id,
271 VERS,
272 JTYP,
273 TYP,
274 NSTA
275 ) values ( 23,
276 7, 47,'T3E', 1
277 );
278 insert into ATYP_data2tag values ('ATYP-07', 23);
279 insert into ATYP_data (
280 ATYP_data_id,
281 VERS,
282 JTYP,
283 TYP,
284 NSTA
285 ) values ( 24,
286 7, 48,'T4F', 2
287 );
288 insert into ATYP_data2tag values ('ATYP-07', 24);
289 insert into ATYP_data (
290 ATYP_data_id,
291 VERS,
292 JTYP,
293 TYP,
294 NSTA
295 ) values ( 25,
296 7, 49,'T4E', 2
297 );
298 insert into ATYP_data2tag values ('ATYP-07', 25);
299 insert into ATYP_data (
300 ATYP_data_id,
301 VERS,
302 JTYP,
303 TYP,
304 NSTA
305 ) values ( 26,
306 7, 50,'EIS', 2
307 );
308 insert into ATYP_data2tag values ('ATYP-07', 26);
309 insert into ATYP_data (
310 ATYP_data_id,
311 VERS,
312 JTYP,
313 TYP,
314 NSTA
315 ) values ( 27,
316 7, 51,'CSS', 1
317 );
318 insert into ATYP_data2tag values ('ATYP-07', 27);
319 insert into ATYP_data (
320 ATYP_data_id,
321 VERS,
322 JTYP,
323 TYP,
324 NSTA
325 ) values ( 28,
326 7, 52,'CSL', 1
327 );
328 insert into ATYP_data2tag values ('ATYP-07', 28);
329 insert into ATYP_data (
330 ATYP_data_id,
331 VERS,
332 JTYP,
333 TYP,
334 NSTA
335 ) values ( 29,
336 7, 53,'BIM', 1
337 );
338 insert into ATYP_data2tag values ('ATYP-07', 29);
339
340 comment on column ATYP_data.ATYP_data_id is 'Unique identifier';
341 comment on column ATYP_data.VERS is 'VERSION ';
342 comment on column ATYP_data.JTYP is 'AMDB STATION TYPE ';
343 comment on column ATYP_data.TYP is 'AMDB STATION NAME ';
344 comment on column ATYP_data.NSTA is 'NUMBER OF STATIONS OF THIS TYPE ';
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.
|
|