001 SET echo OFF;
002 set linesize 132;
003 drop table ECST_data2tag cascade constraints;
004 drop table ECST_data cascade constraints;
005 create table ECST_data (
006 ECST_data_id number(10),
007 STOTHIC1 float(63),
008 STOTHIC2 float(63),
009 STOTHIC3 float(63),
010 STOTHIC4 float(63),
011 STOLENGT float(63),
012 STOLENGA float(63),
013 STOXPREF float(63),
014 STOYPREF float(63),
015 STOHEIGH float(63),
016 STOHEIG1 float(63),
017 STOHEIG2 float(63),
018 STOHEIG3 float(63),
019 STOHEIG4 float(63),
020 STODZBOT float(63),
021 STODZIN1 float(63),
022 STODZIN2 float(63),
023 STODZIN3 float(63),
024 STODZIN4 float(63),
025 STODZIN5 float(63),
026 STODZTOP float(63),
027 STOANGLE float(63),
028 STOYPOS float(63),
029 STOGECXZ float(63),
030 STOGECHE float(63),
031 STOCLCZP float(63),
032 STOANGD2 float(63),
033 STOANGD4 float(63),
034 STOLENG1 float(63),
035 STOFXPOS float(63),
036 STOZPOS float(63),
037 STOUEYP float(63),
038 STOTEYP float(63),
039 STOTEZP float(63),
040 STOFLXA float(63),
041 STOFLYA float(63),
042 STOFLXB float(63),
043 STOFLYB float(63),
044 STOFLXC float(63),
045 STOFLYC float(63),
046 STOFLXD float(63),
047 STOFLYD float(63),
048 STOFLXE float(63),
049 STOFLYE float(63),
050 STOFLXF float(63),
051 STOFLYF float(63),
052 STOFLXG float(63),
053 STOFLYG float(63),
054 STOFLXH float(63),
055 STOFLYH float(63),
056 STOFLXI float(63),
057 STOFLYI float(63),
058 STOCOXA float(63),
059 STOCOYA float(63),
060 STOCOXA1 float(63),
061 STOCOYA1 float(63),
062 STOCOXB float(63),
063 STOCOYB float(63),
064 STOCOXB1 float(63),
065 STOCOYB1 float(63),
066 STOCOXC float(63),
067 STOCOYC float(63),
068 STOCOXC1 float(63),
069 STOCOYC1 float(63),
070 STOCOXD float(63),
071 STOCOYD float(63),
072 STOCOXD1 float(63),
073 STOCOYD1 float(63),
074 STOCOXE float(63),
075 STOCOYE float(63),
076 STOCOXE1 float(63),
077 STOCOYE1 float(63),
078 STOCOXF float(63),
079 STOCOYF float(63),
080 STOCOXF1 float(63),
081 STOCOYF1 float(63),
082 STOCOXG float(63),
083 STOCOYG float(63),
084 STOCOXG1 float(63),
085 STOCOYG1 float(63),
086 STOCOXH float(63),
087 STOCOYH float(63),
088 STOCOXH1 float(63),
089 STOCOYH1 float(63),
090 STOCOXI float(63),
091 STOCOYI float(63),
092 STOCOXI1 float(63),
093 STOCOYI1 float(63),
094 STOCO3DX float(63),
095 STOCO3DY float(63),
096 STOCO3DZ float(63),
097 STOCO3ZP float(63),
098 STOCO3YP float(63),
099 STOUEXA float(63),
100 STOUEYA float(63),
101 STOUEXB float(63),
102 STOUEYB float(63),
103 STOUEXC float(63),
104 STOUEYC float(63),
105 STOUECXA float(63),
106 STOUECYA float(63),
107 STOUECXB float(63),
108 STOUECYB float(63),
109 STOUECZP float(63),
110 STOUECYP float(63)
111 ) ;
112
113 alter table ECST_data add constraint ECST_data_pk
114 primary key (ECST_data_id);
115
116 create table ECST_data2tag (
117 ECST_vers varchar2(255),
118 ECST_data_id number(10)
119 ) ;
120
121 alter table ECST_data2tag add constraint ECST_data2tag_pk
122 primary key (ECST_vers, ECST_data_id);
123 alter table ECST_data2tag add constraint ECST_data2tag_vers_fk
124 foreign key (ECST_vers) references hvs_nodevers (vers_name);
125 alter table ECST_data2tag add constraint ECST_data2tag_data_fk
126 foreign key (ECST_data_id) references ECST_data (ECST_data_id);
127
128 delete from hvs_relation where CHILD_NODENAME = 'ECST';
129 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
130 delete from hvs_nodevers where NODE_NAME = 'ECST';
131 delete from hvs_node where NODE_NAME = 'ECST';
132
133 insert into hvs_node values ('ECST','MuonSpectrometer', '');
134 insert into hvs_nodevers values ('ECST', 'ECST-01', '');
135 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
136 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','ECST','ECST-01');
137 insert into ECST_data (
138 ECST_data_id,
139 STOTHIC1,
140 STOTHIC2,
141 STOTHIC3,
142 STOTHIC4,
143 STOLENGT,
144 STOLENGA,
145 STOXPREF,
146 STOYPREF,
147 STOHEIGH,
148 STOHEIG1,
149 STOHEIG2,
150 STOHEIG3,
151 STOHEIG4,
152 STODZBOT,
153 STODZIN1,
154 STODZIN2,
155 STODZIN3,
156 STODZIN4,
157 STODZIN5,
158 STODZTOP,
159 STOANGLE,
160 STOYPOS,
161 STOGECXZ,
162 STOGECHE,
163 STOCLCZP,
164 STOANGD2,
165 STOANGD4,
166 STOLENG1,
167 STOFXPOS,
168 STOZPOS,
169 STOUEYP,
170 STOTEYP,
171 STOTEZP,
172 STOFLXA,
173 STOFLYA,
174 STOFLXB,
175 STOFLYB,
176 STOFLXC,
177 STOFLYC,
178 STOFLXD,
179 STOFLYD,
180 STOFLXE,
181 STOFLYE,
182 STOFLXF,
183 STOFLYF,
184 STOFLXG,
185 STOFLYG,
186 STOFLXH,
187 STOFLYH,
188 STOFLXI,
189 STOFLYI,
190 STOCOXA,
191 STOCOYA,
192 STOCOXA1,
193 STOCOYA1,
194 STOCOXB,
195 STOCOYB,
196 STOCOXB1,
197 STOCOYB1,
198 STOCOXC,
199 STOCOYC,
200 STOCOXC1,
201 STOCOYC1,
202 STOCOXD,
203 STOCOYD,
204 STOCOXD1,
205 STOCOYD1,
206 STOCOXE,
207 STOCOYE,
208 STOCOXE1,
209 STOCOYE1,
210 STOCOXF,
211 STOCOYF,
212 STOCOXF1,
213 STOCOYF1,
214 STOCOXG,
215 STOCOYG,
216 STOCOXG1,
217 STOCOYG1,
218 STOCOXH,
219 STOCOYH,
220 STOCOXH1,
221 STOCOYH1,
222 STOCOXI,
223 STOCOYI,
224 STOCOXI1,
225 STOCOYI1,
226 STOCO3DX,
227 STOCO3DY,
228 STOCO3DZ,
229 STOCO3ZP,
230 STOCO3YP,
231 STOUEXA,
232 STOUEYA,
233 STOUEXB,
234 STOUEYB,
235 STOUEXC,
236 STOUEYC,
237 STOUECXA,
238 STOUECYA,
239 STOUECXB,
240 STOUECYB,
241 STOUECZP,
242 STOUECYP
243 ) values ( 1,
244 50.0000, 50.0000, 50.0000, 50.0000, 2770.0000, 2084.0000,
245 0.0000, 0.0000, 6930.0000, 940.0000, 3204.0000, 1135.0000,
246 815.0000, 1650.0000, 2168.0000, 741.0000, 527.0000, 944.0000,
247 666.0000, 1915.0000, 60.0000, 5800.0000, 310.0000, 1300.0000,
248 260.0000, 30.0000, 15.0000, 2670.0000, 1360.0000, 2500.0000,
249 5547.5000, 6522.5000, 957.5000, 0.0000, 0.0000, 0.0000,
250 4980.0000, 527.0000, 4980.0000, 527.0000, 3204.0000, 1268.0000,
251 3204.0000, 2168.0000, 1645.1543, 2168.0000, 940.0000, 1650.0000,
252 940.0000, 1650.0000, 0.0000, 0.0000, 0.0000, 50.0000,
253 0.0000, 0.0000, 4980.0000, 50.0000, 4980.0000, 527.0000,
254 4980.0000, 477.0000, 4980.0000, 527.0000, 3204.0000, 477.0000,
255 3154.0000, 1268.0000, 3204.0000, 1239.1324, 3154.0000, 2168.0000,
256 1645.1543, 2118.0000, 1631.7568, 2168.0000, 940.0000, 2118.0000,
257 990.0000, 1650.0000, 940.0000, 1600.0000, 990.0000, 1650.0000,
258 0.0000, 1600.0000, 0.0000, 1550.0000, 50.0000, 2670.0000,
259 825.0000, 25.0000, 1385.0000, 0.0000, 1385.0000, 666.0000,
260 1042.0000, 944.0000, 1335.0000, 50.0000, 1335.0000, 477.0000,
261 -430.5000, -975.0000
262 );
263 insert into ECST_data2tag values ('ECST-01', 1);
264
265 comment on column ECST_data.ECST_data_id is 'Unique identifier';
266 comment on column ECST_data.STOTHIC1 is 'STOTHIC1 ';
267 comment on column ECST_data.STOTHIC2 is 'STOTHIC2 ';
268 comment on column ECST_data.STOTHIC3 is 'STOTHIC3 ';
269 comment on column ECST_data.STOTHIC4 is 'STOTHIC4 ';
270 comment on column ECST_data.STOLENGT is 'STOLENGT ';
271 comment on column ECST_data.STOLENGA is 'STOLENGA ';
272 comment on column ECST_data.STOXPREF is 'STOXPREF ';
273 comment on column ECST_data.STOYPREF is 'STOYPREF ';
274 comment on column ECST_data.STOHEIGH is 'STOHEIGH ';
275 comment on column ECST_data.STOHEIG1 is 'STOHEIG1 ';
276 comment on column ECST_data.STOHEIG2 is 'STOHEIG2 ';
277 comment on column ECST_data.STOHEIG3 is 'STOHEIG3 ';
278 comment on column ECST_data.STOHEIG4 is 'STOHEIG4 ';
279 comment on column ECST_data.STODZBOT is 'STODZBOT ';
280 comment on column ECST_data.STODZIN1 is 'STODZIN1 ';
281 comment on column ECST_data.STODZIN2 is 'STODZIN2 ';
282 comment on column ECST_data.STODZIN3 is 'STODZIN3 ';
283 comment on column ECST_data.STODZIN4 is 'STODZIN4 ';
284 comment on column ECST_data.STODZIN5 is 'STODZIN5 ';
285 comment on column ECST_data.STODZTOP is 'STODZTOP ';
286 comment on column ECST_data.STOANGLE is 'STOANGLE ';
287 comment on column ECST_data.STOYPOS is 'STOYPOS ';
288 comment on column ECST_data.STOGECXZ is 'STOGECXZ ';
289 comment on column ECST_data.STOGECHE is 'STOGECHE ';
290 comment on column ECST_data.STOCLCZP is 'STOCLCZP ';
291 comment on column ECST_data.STOANGD2 is 'STOANGD2 ';
292 comment on column ECST_data.STOANGD4 is 'STOANGD4 ';
293 comment on column ECST_data.STOLENG1 is 'STOLENG1 ';
294 comment on column ECST_data.STOFXPOS is 'STOFXPOS ';
295 comment on column ECST_data.STOZPOS is 'STOZPOS ';
296 comment on column ECST_data.STOUEYP is 'STOUEYP ';
297 comment on column ECST_data.STOTEYP is 'STOTEYP ';
298 comment on column ECST_data.STOTEZP is 'STOTEZP ';
299 comment on column ECST_data.STOFLXA is 'STOFLXA ';
300 comment on column ECST_data.STOFLYA is 'STOFLYA ';
301 comment on column ECST_data.STOFLXB is 'STOFLXB ';
302 comment on column ECST_data.STOFLYB is 'STOFLYB ';
303 comment on column ECST_data.STOFLXC is 'STOFLXC ';
304 comment on column ECST_data.STOFLYC is 'STOFLYC ';
305 comment on column ECST_data.STOFLXD is 'STOFLXD ';
306 comment on column ECST_data.STOFLYD is 'STOFLYD ';
307 comment on column ECST_data.STOFLXE is 'STOFLXE ';
308 comment on column ECST_data.STOFLYE is 'STOFLYE ';
309 comment on column ECST_data.STOFLXF is 'STOFLXF ';
310 comment on column ECST_data.STOFLYF is 'STOFLYF ';
311 comment on column ECST_data.STOFLXG is 'STOFLXG ';
312 comment on column ECST_data.STOFLYG is 'STOFLYG ';
313 comment on column ECST_data.STOFLXH is 'STOFLXH ';
314 comment on column ECST_data.STOFLYH is 'STOFLYH ';
315 comment on column ECST_data.STOFLXI is 'STOFLXI ';
316 comment on column ECST_data.STOFLYI is 'STOFLYI ';
317 comment on column ECST_data.STOCOXA is 'STOCOXA ';
318 comment on column ECST_data.STOCOYA is 'STOCOYA ';
319 comment on column ECST_data.STOCOXA1 is 'STOCOXA1 ';
320 comment on column ECST_data.STOCOYA1 is 'STOCOYA1 ';
321 comment on column ECST_data.STOCOXB is 'STOCOXB ';
322 comment on column ECST_data.STOCOYB is 'STOCOYB ';
323 comment on column ECST_data.STOCOXB1 is 'STOCOXB1 ';
324 comment on column ECST_data.STOCOYB1 is 'STOCOYB1 ';
325 comment on column ECST_data.STOCOXC is 'STOCOXC ';
326 comment on column ECST_data.STOCOYC is 'STOCOYC ';
327 comment on column ECST_data.STOCOXC1 is 'STOCOXC1 ';
328 comment on column ECST_data.STOCOYC1 is 'STOCOYC1 ';
329 comment on column ECST_data.STOCOXD is 'STOCOXD ';
330 comment on column ECST_data.STOCOYD is 'STOCOYD ';
331 comment on column ECST_data.STOCOXD1 is 'STOCOXD1 ';
332 comment on column ECST_data.STOCOYD1 is 'STOCOYD1 ';
333 comment on column ECST_data.STOCOXE is 'STOCOXE ';
334 comment on column ECST_data.STOCOYE is 'STOCOYE ';
335 comment on column ECST_data.STOCOXE1 is 'STOCOXE1 ';
336 comment on column ECST_data.STOCOYE1 is 'STOCOYE1 ';
337 comment on column ECST_data.STOCOXF is 'STOCOXF ';
338 comment on column ECST_data.STOCOYF is 'STOCOYF ';
339 comment on column ECST_data.STOCOXF1 is 'STOCOXF1 ';
340 comment on column ECST_data.STOCOYF1 is 'STOCOYF1 ';
341 comment on column ECST_data.STOCOXG is 'STOCOXG ';
342 comment on column ECST_data.STOCOYG is 'STOCOYG ';
343 comment on column ECST_data.STOCOXG1 is 'STOCOXG1 ';
344 comment on column ECST_data.STOCOYG1 is 'STOCOYG1 ';
345 comment on column ECST_data.STOCOXH is 'STOCOXH ';
346 comment on column ECST_data.STOCOYH is 'STOCOYH ';
347 comment on column ECST_data.STOCOXH1 is 'STOCOXH1 ';
348 comment on column ECST_data.STOCOYH1 is 'STOCOYH1 ';
349 comment on column ECST_data.STOCOXI is 'STOCOXI ';
350 comment on column ECST_data.STOCOYI is 'STOCOYI ';
351 comment on column ECST_data.STOCOXI1 is 'STOCOXI1 ';
352 comment on column ECST_data.STOCOYI1 is 'STOCOYI1 ';
353 comment on column ECST_data.STOCO3DX is 'STOCO3DX ';
354 comment on column ECST_data.STOCO3DY is 'STOCO3DY ';
355 comment on column ECST_data.STOCO3DZ is 'STOCO3DZ ';
356 comment on column ECST_data.STOCO3ZP is 'STOCO3ZP ';
357 comment on column ECST_data.STOCO3YP is 'STOCO3YP ';
358 comment on column ECST_data.STOUEXA is 'STOUEXA ';
359 comment on column ECST_data.STOUEYA is 'STOUEYA ';
360 comment on column ECST_data.STOUEXB is 'STOUEXB ';
361 comment on column ECST_data.STOUEYB is 'STOUEYB ';
362 comment on column ECST_data.STOUEXC is 'STOUEXC ';
363 comment on column ECST_data.STOUEYC is 'STOUEYC ';
364 comment on column ECST_data.STOUECXA is 'STOUECXA ';
365 comment on column ECST_data.STOUECYA is 'STOUECYA ';
366 comment on column ECST_data.STOUECXB is 'STOUECXB ';
367 comment on column ECST_data.STOUECYB is 'STOUECYB ';
368 comment on column ECST_data.STOUECZP is 'STOUECZP ';
369 comment on column ECST_data.STOUECYP is 'STOUECYP ';
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.
|
|