001 SET echo OFF;
002 set linesize 132;
003 drop table IPP2_data2tag cascade constraints;
004 drop table IPP2_data cascade constraints;
005 create table IPP2_data (
006 IPP2_data_id number(10),
007 PIXPOBHE float(63),
008 PIXPOBDZ float(63),
009 PIXPOBDX float(63),
010 PIXPOC2E float(63),
011 PIXPOC3E float(63),
012 PIXNTBHE float(63),
013 PIXNTBDZ float(63),
014 PIXNTBDX float(63),
015 PIXNTC2E float(63),
016 PIXNTC3E float(63),
017 PIXENBHE float(63),
018 PIXENBDZ float(63),
019 PIXENBDX float(63),
020 PIXENC2E float(63),
021 PIXENC3E float(63),
022 PIXENBXP float(63),
023 PIXENBZP float(63),
024 IDRMABHE float(63),
025 IDRMABDZ float(63),
026 IDRMABDX float(63),
027 IDRMAC2E float(63),
028 IDRMAC3E float(63),
029 IDRMABXP float(63),
030 IDRMABZP float(63),
031 TRTPSBHE float(63),
032 TRTPSBDZ float(63),
033 TRTPSBDX float(63),
034 TRTPSC2E float(63),
035 TRTPSC3E float(63),
036 TRTPSBXP float(63),
037 TRTPSBZ1 float(63),
038 TRTPSBY1 float(63),
039 TRTPSBZ2 float(63),
040 TRTPSBZ3 float(63),
041 TRTPSBZ4 float(63),
042 TRTPSBZ5 float(63),
043 TRTPSBZ6 float(63),
044 TRTPSBY6 float(63),
045 TRTPSBZ7 float(63),
046 TRTPSBZ8 float(63),
047 TRTPSYGA float(63),
048 PLATFLTH float(63),
049 PLATFLDZ float(63),
050 PLATFLDX float(63),
051 PLATFLXP float(63),
052 PLATFLZP float(63),
053 PLATBFTH float(63),
054 PLATBFDZ float(63),
055 PLATBFDX float(63),
056 PLATBFZA float(63),
057 PLATBFZB float(63),
058 PLATBFZC float(63),
059 PLATRARO float(63),
060 PLATRARI float(63),
061 PLATRAHE float(63),
062 PLATRAZE float(63),
063 PLATRADH float(63),
064 XPOS float(63),
065 YPOS float(63),
066 ZPOS float(63),
067 PIXPOC2P float(63),
068 PIXPOC3P float(63),
069 PIXPOBY1 float(63),
070 PIXPOBY2 float(63),
071 PIXPOBY3 float(63),
072 PIXNTC2P float(63),
073 PIXNTC3P float(63),
074 PIXNTBY1 float(63),
075 PIXNTBY2 float(63),
076 PIXNTBY3 float(63),
077 PIXNTBXO float(63),
078 PIXENC2P float(63),
079 PIXENC3P float(63),
080 PIXENBYP float(63),
081 IDRMAC2X float(63),
082 IDRMAC3X float(63),
083 IDRMABYP float(63),
084 TRTPSC2X float(63),
085 TRTPSC3X float(63),
086 TRTPSBY2 float(63),
087 TRTPSBY3 float(63),
088 TRTPSBY4 float(63),
089 TRTPSBY5 float(63),
090 TRTPSBY7 float(63),
091 TRTPSBY8 float(63),
092 PLATFLYP float(63),
093 PLATBFXP float(63),
094 PLATBFYP float(63),
095 PLATBFZ1 float(63),
096 PLATBFZ2 float(63),
097 PLATBFZ3 float(63),
098 PLATRAZ1 float(63),
099 PLATRAY1 float(63),
100 PLATRAZ2 float(63),
101 PLATRAY2 float(63),
102 PLATRAZ3 float(63),
103 PLATRAY3 float(63),
104 PLATRAZ4 float(63),
105 PLATRAY4 float(63),
106 PLATRAZ5 float(63),
107 PLATRAY5 float(63),
108 PLATRAZ6 float(63),
109 PLATRAY6 float(63),
110 PLATRVZ1 float(63),
111 PLATRVY1 float(63),
112 PLATRVZ2 float(63),
113 PLATRVY2 float(63),
114 PLATRHZ1 float(63),
115 PLATRHY1 float(63),
116 PLATRHZ2 float(63),
117 PLATRHY2 float(63),
118 PLATRHZE float(63),
119 PLATRVZE float(63),
120 PLATRHZP float(63),
121 PLATRHYP float(63),
122 PLATRAXA float(63),
123 PLATRAXB float(63)
124 ) ;
125
126 alter table IPP2_data add constraint IPP2_data_pk
127 primary key (IPP2_data_id);
128
129 create table IPP2_data2tag (
130 IPP2_vers varchar2(255),
131 IPP2_data_id number(10)
132 );
133
134 alter table IPP2_data2tag add constraint IPP2_data2tag_pk
135 primary key (IPP2_vers, IPP2_data_id);
136
137 alter table IPP2_data2tag add constraint IPP2_data2tag_vers_fk
138 foreign key (IPP2_vers) references hvs_nodevers (vers_name);
139 alter table IPP2_data2tag add constraint IPP2_data2tag_data_fk
140 foreign key (IPP2_data_id) references IPP2_data (IPP2_data_id);
141
142 delete from hvs_relation where CHILD_NODENAME = 'IPP2';
143 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
144 delete from hvs_nodevers where NODE_NAME = 'IPP2';
145 delete from hvs_node where NODE_NAME = 'IPP2';
146
147 insert into hvs_node values ('IPP2','MuonSpectrometer', '');
148 insert into hvs_nodevers values ('IPP2', 'IPP2-01', '');
149 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
150 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','IPP2','IPP2-01');
151 insert into IPP2_data (
152 IPP2_data_id,
153 PIXPOBHE,
154 PIXPOBDZ,
155 PIXPOBDX,
156 PIXPOC2E,
157 PIXPOC3E,
158 PIXNTBHE,
159 PIXNTBDZ,
160 PIXNTBDX,
161 PIXNTC2E,
162 PIXNTC3E,
163 PIXENBHE,
164 PIXENBDZ,
165 PIXENBDX,
166 PIXENC2E,
167 PIXENC3E,
168 PIXENBXP,
169 PIXENBZP,
170 IDRMABHE,
171 IDRMABDZ,
172 IDRMABDX,
173 IDRMAC2E,
174 IDRMAC3E,
175 IDRMABXP,
176 IDRMABZP,
177 TRTPSBHE,
178 TRTPSBDZ,
179 TRTPSBDX,
180 TRTPSC2E,
181 TRTPSC3E,
182 TRTPSBXP,
183 TRTPSBZ1,
184 TRTPSBY1,
185 TRTPSBZ2,
186 TRTPSBZ3,
187 TRTPSBZ4,
188 TRTPSBZ5,
189 TRTPSBZ6,
190 TRTPSBY6,
191 TRTPSBZ7,
192 TRTPSBZ8,
193 TRTPSYGA,
194 PLATFLTH,
195 PLATFLDZ,
196 PLATFLDX,
197 PLATFLXP,
198 PLATFLZP,
199 PLATBFTH,
200 PLATBFDZ,
201 PLATBFDX,
202 PLATBFZA,
203 PLATBFZB,
204 PLATBFZC,
205 PLATRARO,
206 PLATRARI,
207 PLATRAHE,
208 PLATRAZE,
209 PLATRADH,
210 XPOS,
211 YPOS,
212 ZPOS,
213 PIXPOC2P,
214 PIXPOC3P,
215 PIXPOBY1,
216 PIXPOBY2,
217 PIXPOBY3,
218 PIXNTC2P,
219 PIXNTC3P,
220 PIXNTBY1,
221 PIXNTBY2,
222 PIXNTBY3,
223 PIXNTBXO,
224 PIXENC2P,
225 PIXENC3P,
226 PIXENBYP,
227 IDRMAC2X,
228 IDRMAC3X,
229 IDRMABYP,
230 TRTPSC2X,
231 TRTPSC3X,
232 TRTPSBY2,
233 TRTPSBY3,
234 TRTPSBY4,
235 TRTPSBY5,
236 TRTPSBY7,
237 TRTPSBY8,
238 PLATFLYP,
239 PLATBFXP,
240 PLATBFYP,
241 PLATBFZ1,
242 PLATBFZ2,
243 PLATBFZ3,
244 PLATRAZ1,
245 PLATRAY1,
246 PLATRAZ2,
247 PLATRAY2,
248 PLATRAZ3,
249 PLATRAY3,
250 PLATRAZ4,
251 PLATRAY4,
252 PLATRAZ5,
253 PLATRAY5,
254 PLATRAZ6,
255 PLATRAY6,
256 PLATRVZ1,
257 PLATRVY1,
258 PLATRVZ2,
259 PLATRVY2,
260 PLATRHZ1,
261 PLATRHY1,
262 PLATRHZ2,
263 PLATRHY2,
264 PLATRHZE,
265 PLATRVZE,
266 PLATRHZP,
267 PLATRHYP,
268 PLATRAXA,
269 PLATRAXB
270 ) values ( 1,
271 236.0000, 400.0000, 380.0000, 320.0000, 400.0000, 112.0000,
272 355.0000, 255.0000, 300.0000, 300.0000, 112.0000, 115.0000,
273 115.0000, 200.0000, 200.0000, 50.0000, 100.0000, 100.0000,
274 150.0000, 340.0000, 80.0000, 80.0000, 150.0000, -70.0000,
275 420.0000, 290.0000, 205.0000, 80.0000, 233.0000, 150.0000,
276 -350.0000, 0.0000, -650.0000, -950.0000, -650.0000, -950.0000,
277 -350.0000, 430.0000, -650.0000, -950.0000, 10.0000, 28.0000,
278 2400.0000, 1000.0000, 50.0000, -300.0000, 34.0000, 40.0000,
279 1080.0000, -1150.0000, 0.0000, 1150.0000, 17.0000, 12.0000,
280 1000.0000, 2300.0000, 80.0000, 6000.0000, -200.0000, 3500.0000,
281 350.0000, 400.0000, 118.0000, 354.0000, 590.0000, 277.5000,
282 327.5000, -56.0000, -168.0000, -280.0000, -62.5000, 157.5000,
283 157.5000, 764.0000, -210.0000, 210.0000, 758.0000, 142.5000,
284 -219.0000, -126.0000, -126.0000, 304.0000, 304.0000, 734.0000,
285 734.0000, -350.0000, 50.0000, -381.0000, -1450.0000, -300.0000,
286 850.0000, -1450.0000, -364.0000, -1450.0000, 556.0000, -1370.0000,
287 636.0000, 770.0000, 636.0000, 850.0000, 556.0000, 850.0000,
288 -364.0000, -300.0000, -364.0000, -300.0000, 636.0000, -1450.0000,
289 136.0000, 850.0000, 136.0000, 2300.0000, 1000.0000, -300.0000,
290 136.0000, -467.0000, 567.0000
291 );
292 insert into IPP2_data2tag values ('IPP2-01', 1);
293
294 comment on column IPP2_data.IPP2_data_id is 'Unique identifier';
295 comment on column IPP2_data.PIXPOBHE is '1236 PIXPOBHE ';
296 comment on column IPP2_data.PIXPOBDZ is '1237 PIXPOBDZ ';
297 comment on column IPP2_data.PIXPOBDX is '1238 PIXPOBDX ';
298 comment on column IPP2_data.PIXPOC2E is '1239 PIXPOC2E ';
299 comment on column IPP2_data.PIXPOC3E is '1240 PIXPOC3E ';
300 comment on column IPP2_data.PIXNTBHE is '1241 PIXNTBHE ';
301 comment on column IPP2_data.PIXNTBDZ is '1242 PIXNTBDZ ';
302 comment on column IPP2_data.PIXNTBDX is '1243 PIXNTBDX ';
303 comment on column IPP2_data.PIXNTC2E is '1244 PIXNTC2E ';
304 comment on column IPP2_data.PIXNTC3E is '1245 PIXNTC3E ';
305 comment on column IPP2_data.PIXENBHE is '1246 PIXENBHE ';
306 comment on column IPP2_data.PIXENBDZ is '1247 PIXENBDZ ';
307 comment on column IPP2_data.PIXENBDX is '1248 PIXENBDX ';
308 comment on column IPP2_data.PIXENC2E is '1249 PIXENC2E ';
309 comment on column IPP2_data.PIXENC3E is '1250 PIXENC3E ';
310 comment on column IPP2_data.PIXENBXP is '1251 PIXENBXP ';
311 comment on column IPP2_data.PIXENBZP is '1252 PIXENBZP ';
312 comment on column IPP2_data.IDRMABHE is '1253 IDRMABHE ';
313 comment on column IPP2_data.IDRMABDZ is '1254 IDRMABDZ ';
314 comment on column IPP2_data.IDRMABDX is '1255 IDRMABDX ';
315 comment on column IPP2_data.IDRMAC2E is '1256 IDRMAC2E ';
316 comment on column IPP2_data.IDRMAC3E is '1257 IDRMAC3E ';
317 comment on column IPP2_data.IDRMABXP is '1258 IDRMABXP ';
318 comment on column IPP2_data.IDRMABZP is '1259 IDRMABZP ';
319 comment on column IPP2_data.TRTPSBHE is '1260 TRTPSBHE ';
320 comment on column IPP2_data.TRTPSBDZ is '1261 TRTPSBDZ ';
321 comment on column IPP2_data.TRTPSBDX is '1262 TRTPSBDX ';
322 comment on column IPP2_data.TRTPSC2E is '1263 TRTPSC2E ';
323 comment on column IPP2_data.TRTPSC3E is '1264 TRTPSC3E ';
324 comment on column IPP2_data.TRTPSBXP is '1265 TRTPSBXP ';
325 comment on column IPP2_data.TRTPSBZ1 is '1266 TRTPSBZ1 ';
326 comment on column IPP2_data.TRTPSBY1 is '1267 TRTPSBY1 ';
327 comment on column IPP2_data.TRTPSBZ2 is '1268 TRTPSBZ2 ';
328 comment on column IPP2_data.TRTPSBZ3 is '1269 TRTPSBZ3 ';
329 comment on column IPP2_data.TRTPSBZ4 is '1270 TRTPSBZ4 ';
330 comment on column IPP2_data.TRTPSBZ5 is '1271 TRTPSBZ5 ';
331 comment on column IPP2_data.TRTPSBZ6 is '1272 TRTPSBZ6 ';
332 comment on column IPP2_data.TRTPSBY6 is '1273 TRTPSBY6 ';
333 comment on column IPP2_data.TRTPSBZ7 is '1274 TRTPSBZ7 ';
334 comment on column IPP2_data.TRTPSBZ8 is '1275 TRTPSBZ8 ';
335 comment on column IPP2_data.TRTPSYGA is '1276 TRTPSYGA ';
336 comment on column IPP2_data.PLATFLTH is '1277 PLATFLTH ';
337 comment on column IPP2_data.PLATFLDZ is '1278 PLATFLDZ ';
338 comment on column IPP2_data.PLATFLDX is '1279 PLATFLDX ';
339 comment on column IPP2_data.PLATFLXP is '1280 PLATFLXP ';
340 comment on column IPP2_data.PLATFLZP is '1281 PLATFLZP ';
341 comment on column IPP2_data.PLATBFTH is '1282 PLATBFTH ';
342 comment on column IPP2_data.PLATBFDZ is '1283 PLATBFDZ ';
343 comment on column IPP2_data.PLATBFDX is '1284 PLATBFDX ';
344 comment on column IPP2_data.PLATBFZA is '1285 PLATBFZA ';
345 comment on column IPP2_data.PLATBFZB is '1286 PLATBFZB ';
346 comment on column IPP2_data.PLATBFZC is '1287 PLATBFZC ';
347 comment on column IPP2_data.PLATRARO is '1288 PLATRARO ';
348 comment on column IPP2_data.PLATRARI is '1289 PLATRARI ';
349 comment on column IPP2_data.PLATRAHE is '1290 PLATRAHE ';
350 comment on column IPP2_data.PLATRAZE is '1291 PLATRAZE ';
351 comment on column IPP2_data.PLATRADH is '1292 PLATRADH ';
352 comment on column IPP2_data.XPOS is '1293 XPOS ';
353 comment on column IPP2_data.YPOS is '1294 YPOS ';
354 comment on column IPP2_data.ZPOS is '1295 ZPOS ';
355 comment on column IPP2_data.PIXPOC2P is '1296 PIXPOC2P ';
356 comment on column IPP2_data.PIXPOC3P is '1297 PIXPOC3P ';
357 comment on column IPP2_data.PIXPOBY1 is '1298 PIXPOBY1 ';
358 comment on column IPP2_data.PIXPOBY2 is '1299 PIXPOBY2 ';
359 comment on column IPP2_data.PIXPOBY3 is '1300 PIXPOBY3 ';
360 comment on column IPP2_data.PIXNTC2P is '1301 PIXNTC2P ';
361 comment on column IPP2_data.PIXNTC3P is '1302 PIXNTC3P ';
362 comment on column IPP2_data.PIXNTBY1 is '1303 PIXNTBY1 ';
363 comment on column IPP2_data.PIXNTBY2 is '1304 PIXNTBY2 ';
364 comment on column IPP2_data.PIXNTBY3 is '1305 PIXNTBY3 ';
365 comment on column IPP2_data.PIXNTBXO is '1306 PIXNTBXO ';
366 comment on column IPP2_data.PIXENC2P is '1307 PIXENC2P ';
367 comment on column IPP2_data.PIXENC3P is '1308 PIXENC3P ';
368 comment on column IPP2_data.PIXENBYP is '1309 PIXENBYP ';
369 comment on column IPP2_data.IDRMAC2X is '1310 IDRMAC2X ';
370 comment on column IPP2_data.IDRMAC3X is '1311 IDRMAC3X ';
371 comment on column IPP2_data.IDRMABYP is '1312 IDRMABYP ';
372 comment on column IPP2_data.TRTPSC2X is '1313 TRTPSC2X ';
373 comment on column IPP2_data.TRTPSC3X is '1314 TRTPSC3X ';
374 comment on column IPP2_data.TRTPSBY2 is '1315 TRTPSBY2 ';
375 comment on column IPP2_data.TRTPSBY3 is '1316 TRTPSBY3 ';
376 comment on column IPP2_data.TRTPSBY4 is '1317 TRTPSBY4 ';
377 comment on column IPP2_data.TRTPSBY5 is '1318 TRTPSBY5 ';
378 comment on column IPP2_data.TRTPSBY7 is '1319 TRTPSBY7 ';
379 comment on column IPP2_data.TRTPSBY8 is '1320 TRTPSBY8 ';
380 comment on column IPP2_data.PLATFLYP is '1321 PLATFLYP ';
381 comment on column IPP2_data.PLATBFXP is '1322 PLATBFXP ';
382 comment on column IPP2_data.PLATBFYP is '1323 PLATBFYP ';
383 comment on column IPP2_data.PLATBFZ1 is '1324 PLATBFZ1 ';
384 comment on column IPP2_data.PLATBFZ2 is '1325 PLATBFZ2 ';
385 comment on column IPP2_data.PLATBFZ3 is '1326 PLATBFZ3 ';
386 comment on column IPP2_data.PLATRAZ1 is '1327 PLATRAZ1 ';
387 comment on column IPP2_data.PLATRAY1 is '1328 PLATRAY1 ';
388 comment on column IPP2_data.PLATRAZ2 is '1329 PLATRAZ2 ';
389 comment on column IPP2_data.PLATRAY2 is '1330 PLATRAY2 ';
390 comment on column IPP2_data.PLATRAZ3 is '1331 PLATRAZ3 ';
391 comment on column IPP2_data.PLATRAY3 is '1332 PLATRAY3 ';
392 comment on column IPP2_data.PLATRAZ4 is '1333 PLATRAZ4 ';
393 comment on column IPP2_data.PLATRAY4 is '1334 PLATRAY4 ';
394 comment on column IPP2_data.PLATRAZ5 is '1335 PLATRAZ5 ';
395 comment on column IPP2_data.PLATRAY5 is '1336 PLATRAY5 ';
396 comment on column IPP2_data.PLATRAZ6 is '1337 PLATRAZ6 ';
397 comment on column IPP2_data.PLATRAY6 is '1338 PLATRAY6 ';
398 comment on column IPP2_data.PLATRVZ1 is '1339 PLATRVZ1 ';
399 comment on column IPP2_data.PLATRVY1 is '1340 PLATRVY1 ';
400 comment on column IPP2_data.PLATRVZ2 is '1341 PLATRVZ2 ';
401 comment on column IPP2_data.PLATRVY2 is '1342 PLATRVY2 ';
402 comment on column IPP2_data.PLATRHZ1 is '1343 PLATRHZ1 ';
403 comment on column IPP2_data.PLATRHY1 is '1344 PLATRHY1 ';
404 comment on column IPP2_data.PLATRHZ2 is '1345 PLATRHZ2 ';
405 comment on column IPP2_data.PLATRHY2 is '1346 PLATRHY2 ';
406 comment on column IPP2_data.PLATRHZE is '1347 PLATRHZE ';
407 comment on column IPP2_data.PLATRVZE is '1348 PLATRVZE ';
408 comment on column IPP2_data.PLATRHZP is '1349 PLATRHZP ';
409 comment on column IPP2_data.PLATRHYP is '1350 PLATRHYP ';
410 comment on column IPP2_data.PLATRAXA is '1351 PLATRAXA ';
411 comment on column IPP2_data.PLATRAXB is '1352 PLATRAXB ';
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.
|
|