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