001 SET echo OFF;
002 set linesize 132;
003 drop table AECT_data2tag cascade constraints;
004 drop table AECT_data cascade constraints;
005 create table AECT_data (
006 AECT_data_id number(10),
007 CRYOT1 float(63),
008 CRYOT2 float(63),
009 CRYOS1 float(63),
010 CRYOS2 float(63),
011 CRYOEDGE float(63),
012 CRYOFLTY float(63),
013 CRYOR0 float(63),
014 CRYOZMIN float(63),
015 CRYOZEXT float(63),
016 CRYOTHI1 float(63),
017 CRYOTHI2 float(63),
018 CRYOTHI3 float(63),
019 CRYOTTU0 float(63),
020 CRYORTU0 float(63),
021 CRYORTU1 float(63),
022 CRYODPHT float(63),
023 CRYOSTL0 float(63),
024 CRYOSTL1 float(63),
025 CRYOSTH0 float(63),
026 CRYOSTW0 float(63),
027 CRYOSTW1 float(63),
028 CRYOSTTH float(63),
029 CRYOSTH1 float(63),
030 CRYOSTH2 float(63),
031 CRYOSTPZ float(63),
032 CRYOSUPL float(63),
033 CRYOSUPH float(63),
034 CRYOSUPW float(63),
035 CRYOSUPX float(63),
036 CNBXZMOF float(63),
037 CNBXZEXT float(63),
038 CNBXTMIN float(63),
039 CNBXTMAX float(63),
040 CNBXTHIC float(63),
041 CNBXEDGE float(63),
042 SUPPLZOF float(63),
043 SUPPLZEX float(63),
044 SUPPLTMI float(63),
045 SUPPLTMA float(63),
046 SUPPLTHZ float(63),
047 SUPPLTHT float(63),
048 SUPPLRHO float(63),
049 SRVTU1DZ float(63),
050 SRVTU1HE float(63),
051 SRVTU1OW float(63),
052 SRVTU1IW float(63),
053 SRVTU1ED float(63),
054 SRVTU2DZ float(63),
055 SRVTU2HE float(63),
056 SRVTU2OR float(63),
057 SRVTU2IR float(63),
058 SRVTU3DZ float(63),
059 SRVTU3HE float(63),
060 SIFITU float(63),
061 COFITU float(63),
062 CRYOZMAX float(63),
063 CNBXZMIN float(63),
064 CNBXZMAX float(63),
065 SUPPLZMI float(63),
066 SUPPLZMA float(63),
067 CRYOZMOY float(63),
068 CRYOALFA float(63),
069 CRYOBETA float(63),
070 CRYOT1P float(63),
071 CRYOT2P float(63),
072 CRYOS1P float(63),
073 CRYOS2P float(63),
074 CRYOFLYP float(63),
075 SUPPLZME float(63),
076 XTEMP_0 float(63),
077 XTEMP_1 float(63),
078 XTEMP_2 float(63),
079 YTEMP_0 float(63),
080 YTEMP_1 float(63),
081 YTEMP_2 float(63),
082 DTEMP01 float(63),
083 XTIMP_0 float(63),
084 XTIMP_1 float(63),
085 XTIMP_2 float(63),
086 YTIMP_0 float(63),
087 YTIMP_1 float(63),
088 YTIMP_2 float(63),
089 DTIMP01 float(63),
090 UTEMP61 float(63),
091 UTEMP62 float(63),
092 UTIMP61 float(63),
093 UTIMP62 float(63),
094 DTEMP float(63),
095 SUPPLATY_0 float(63),
096 SUPPLATY_1 float(63),
097 SUPPLATY_2 float(63),
098 SUPPLATY_3 float(63),
099 SUPPLATX_0 float(63),
100 SUPPLATX_1 float(63),
101 SUPPLATX_2 float(63),
102 SUPPLATX_3 float(63),
103 X1TEMP float(63),
104 X0TEMP float(63)
105 ) ;
106
107 alter table AECT_data add constraint AECT_data_pk
108 primary key (AECT_data_id);
109
110 create table AECT_data2tag (
111 AECT_vers varchar2(255),
112 AECT_data_id number(10)
113 ) ;
114
115 alter table AECT_data2tag add constraint AECT_data2tag_pk
116 primary key (AECT_vers, AECT_data_id);
117 alter table AECT_data2tag add constraint AECT_data2tag_vers_fk
118 foreign key (AECT_vers) references hvs_nodevers (vers_name);
119 alter table AECT_data2tag add constraint AECT_data2tag_data_fk
120 foreign key (AECT_data_id) references AECT_data (AECT_data_id);
121
122 delete from hvs_relation where CHILD_NODENAME = 'AECT';
123 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
124 delete from hvs_nodevers where NODE_NAME = 'AECT';
125 delete from hvs_node where NODE_NAME = 'AECT';
126
127 insert into hvs_node values ('AECT','MuonSpectrometer', '');
128 insert into hvs_nodevers values ('AECT', 'AECT-01', '');
129 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
130 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','AECT','AECT-01');
131 insert into AECT_data (
132 AECT_data_id,
133 CRYOT1,
134 CRYOT2,
135 CRYOS1,
136 CRYOS2,
137 CRYOEDGE,
138 CRYOFLTY,
139 CRYOR0,
140 CRYOZMIN,
141 CRYOZEXT,
142 CRYOTHI1,
143 CRYOTHI2,
144 CRYOTHI3,
145 CRYOTTU0,
146 CRYORTU0,
147 CRYORTU1,
148 CRYODPHT,
149 CRYOSTL0,
150 CRYOSTL1,
151 CRYOSTH0,
152 CRYOSTW0,
153 CRYOSTW1,
154 CRYOSTTH,
155 CRYOSTH1,
156 CRYOSTH2,
157 CRYOSTPZ,
158 CRYOSUPL,
159 CRYOSUPH,
160 CRYOSUPW,
161 CRYOSUPX,
162 CNBXZMOF,
163 CNBXZEXT,
164 CNBXTMIN,
165 CNBXTMAX,
166 CNBXTHIC,
167 CNBXEDGE,
168 SUPPLZOF,
169 SUPPLZEX,
170 SUPPLTMI,
171 SUPPLTMA,
172 SUPPLTHZ,
173 SUPPLTHT,
174 SUPPLRHO,
175 SRVTU1DZ,
176 SRVTU1HE,
177 SRVTU1OW,
178 SRVTU1IW,
179 SRVTU1ED,
180 SRVTU2DZ,
181 SRVTU2HE,
182 SRVTU2OR,
183 SRVTU2IR,
184 SRVTU3DZ,
185 SRVTU3HE,
186 SIFITU,
187 COFITU,
188 CRYOZMAX,
189 CNBXZMIN,
190 CNBXZMAX,
191 SUPPLZMI,
192 SUPPLZMA,
193 CRYOZMOY,
194 CRYOALFA,
195 CRYOBETA,
196 CRYOT1P,
197 CRYOT2P,
198 CRYOS1P,
199 CRYOS2P,
200 CRYOFLYP,
201 SUPPLZME,
202 XTEMP_0,XTEMP_1,XTEMP_2,
203 YTEMP_0,YTEMP_1,YTEMP_2,
204 DTEMP01,
205 XTIMP_0,XTIMP_1,XTIMP_2,
206 YTIMP_0,YTIMP_1,YTIMP_2,
207 DTIMP01,
208 UTEMP61,
209 UTEMP62,
210 UTIMP61,
211 UTIMP62,
212 DTEMP,
213 SUPPLATY_0,SUPPLATY_1,SUPPLATY_2,SUPPLATY_3,
214 SUPPLATX_0,SUPPLATX_1,SUPPLATX_2,SUPPLATX_3,
215 X1TEMP,
216 X0TEMP
217 ) values ( 1,
218 5350.0000, 4325.0000, 1245.0000, 1135.0000, 80.0000, 4000.0000,
219 905.0000, 7894.0000, 5000.0000, 80.0000, 100.0000, 70.0000,
220 3100.0000, 80.0000, 150.0000, -3.6000, 550.0000, 400.0000,
221 200.0000, 1000.0000, 650.0000, 40.0000, 40.0000, 20.0000,
222 140.0000, 4500.0000, 200.0000, 500.0000, 3100.0000, 30.0000,
223 4740.0000, 1110.0000, 5110.0000, 280.0000, 600.0000, 800.0000,
224 3400.0000, 1420.0000, 4150.0000, 70.0000, 80.0000, 600.0000,
225 830.0000, 2000.0000, 1100.0000, 1000.0000, 120.0000, 900.0000,
226 1000.0000, 150.0000, 140.0000, 260.0000, 4000.0000, 0.3239,
227 0.9461, 12894.0000, 7924.0000, 12664.0000, 8694.0000, 12094.0000,
228 10394.0000, 1.1504, 0.7577, 5280.0000, 4255.0000, 1154.2330,
229 1190.7319, 3930.0000, 10394.0000, 567.5000, 1472.2413, 2047.3563,
230 4325.0000, 5180.9761, 4942.7554, 1245.4926, 595.3660, 1487.3823,
231 2020.5685, 4255.0000, 5098.9370, 4878.0840, 1227.9751, 0.4980,
232 0.5071, 0.5172, 0.5185, 5331.5850, 1420.0000, 1500.0000,
233 4070.0000, 4150.0000, 873.2967, 939.5709, 3068.6287, 3134.9028,
234 1385.9293, 1259.9357
235 );
236 insert into AECT_data2tag values ('AECT-01', 1);
237
238 comment on column AECT_data.AECT_data_id is 'Unique identifier';
239 comment on column AECT_data.CRYOT1 is 'CRYOT1 ';
240 comment on column AECT_data.CRYOT2 is 'CRYOT2 ';
241 comment on column AECT_data.CRYOS1 is 'CRYOS1 ';
242 comment on column AECT_data.CRYOS2 is 'CRYOS2 ';
243 comment on column AECT_data.CRYOEDGE is 'CRYOEDGE ';
244 comment on column AECT_data.CRYOFLTY is 'FLATY ';
245 comment on column AECT_data.CRYOR0 is 'CRYOR0 ';
246 comment on column AECT_data.CRYOZMIN is 'CRYOZMIN ';
247 comment on column AECT_data.CRYOZEXT is 'CRYOZEXT ';
248 comment on column AECT_data.CRYOTHI1 is 'THICK1 ';
249 comment on column AECT_data.CRYOTHI2 is 'THICK2 ';
250 comment on column AECT_data.CRYOTHI3 is 'THICK3 ';
251 comment on column AECT_data.CRYOTTU0 is 'CRYOTTU0 ';
252 comment on column AECT_data.CRYORTU0 is 'CRYORTU0 ';
253 comment on column AECT_data.CRYORTU1 is 'CRYORTU1 ';
254 comment on column AECT_data.CRYODPHT is 'DPHITU ';
255 comment on column AECT_data.CRYOSTL0 is 'CRYOSTOPLENGTH0 ';
256 comment on column AECT_data.CRYOSTL1 is 'CRYOSTOPLENGTH1 ';
257 comment on column AECT_data.CRYOSTH0 is 'CRYOSTOPHEIGHT0 ';
258 comment on column AECT_data.CRYOSTW0 is 'CRYOSTOPWIDTH0 ';
259 comment on column AECT_data.CRYOSTW1 is 'CRYOSTOPWIDTH1 ';
260 comment on column AECT_data.CRYOSTTH is 'CRYOSTOPTHICKNESS ';
261 comment on column AECT_data.CRYOSTH1 is 'CRYOSTOPHEIGHT1 ';
262 comment on column AECT_data.CRYOSTH2 is 'CRYOSTOPHEIGHT2 ';
263 comment on column AECT_data.CRYOSTPZ is 'CRYOSTOPPOSIZ ';
264 comment on column AECT_data.CRYOSUPL is 'CRYOSUPL ';
265 comment on column AECT_data.CRYOSUPH is 'CRYOSUPH ';
266 comment on column AECT_data.CRYOSUPW is 'CRYOSUPW ';
267 comment on column AECT_data.CRYOSUPX is 'CRYOSUPX ';
268 comment on column AECT_data.CNBXZMOF is 'CONDBOXZMINOFFSET ';
269 comment on column AECT_data.CNBXZEXT is 'CONDBOXZEXT ';
270 comment on column AECT_data.CNBXTMIN is 'CONDBOXTMIN ';
271 comment on column AECT_data.CNBXTMAX is 'CONDBOXTMAX ';
272 comment on column AECT_data.CNBXTHIC is 'CONDBOXTHICK ';
273 comment on column AECT_data.CNBXEDGE is 'CONDBOXEDGE ';
274 comment on column AECT_data.SUPPLZOF is 'SUPPLATZOFFSET ';
275 comment on column AECT_data.SUPPLZEX is 'SUPPLATZEXT ';
276 comment on column AECT_data.SUPPLTMI is 'SUPPLATTMIN ';
277 comment on column AECT_data.SUPPLTMA is 'SUPPLATTMAX ';
278 comment on column AECT_data.SUPPLTHZ is 'SUPPLATTHICKZ ';
279 comment on column AECT_data.SUPPLTHT is 'SUPPLATTHICKT ';
280 comment on column AECT_data.SUPPLRHO is 'SUPPLATRHOLE ';
281 comment on column AECT_data.SRVTU1DZ is 'SERVTUR1DZ ';
282 comment on column AECT_data.SRVTU1HE is 'SERVTUR1HEIGHT ';
283 comment on column AECT_data.SRVTU1OW is 'SERVTUR1OUTWIDTH ';
284 comment on column AECT_data.SRVTU1IW is 'SERVTUR1INNWIDTH ';
285 comment on column AECT_data.SRVTU1ED is 'SERVTUR1EDGE ';
286 comment on column AECT_data.SRVTU2DZ is 'SERVTUR2DZ ';
287 comment on column AECT_data.SRVTU2HE is 'SERVTUR2HEIGHT ';
288 comment on column AECT_data.SRVTU2OR is 'SERVTUR2OUTRAD ';
289 comment on column AECT_data.SRVTU2IR is 'SERVTUR2INNRAD ';
290 comment on column AECT_data.SRVTU3DZ is 'SERVTUR3DZ ';
291 comment on column AECT_data.SRVTU3HE is 'SERVTUR3HEIGHT ';
292 comment on column AECT_data.SIFITU is 'SIFITU ';
293 comment on column AECT_data.COFITU is 'COFITU ';
294 comment on column AECT_data.CRYOZMAX is 'CRYOZMAX ';
295 comment on column AECT_data.CNBXZMIN is 'CONDBOXZMIN ';
296 comment on column AECT_data.CNBXZMAX is 'CONDBOXZMAX ';
297 comment on column AECT_data.SUPPLZMI is 'SUPPLATZMIN ';
298 comment on column AECT_data.SUPPLZMA is 'SUPPLATZMAX ';
299 comment on column AECT_data.CRYOZMOY is 'CRYOZMOY ';
300 comment on column AECT_data.CRYOALFA is 'CRYOALFA ';
301 comment on column AECT_data.CRYOBETA is 'CRYOBETA ';
302 comment on column AECT_data.CRYOT1P is 'CRYOT1P ';
303 comment on column AECT_data.CRYOT2P is 'CRYOT2P ';
304 comment on column AECT_data.CRYOS1P is 'CRYOS1P ';
305 comment on column AECT_data.CRYOS2P is 'CRYOS2P ';
306 comment on column AECT_data.CRYOFLYP is 'FLATYP ';
307 comment on column AECT_data.SUPPLZME is 'SUPPLATZMOY ';
308 comment on column AECT_data.XTEMP_0 is 'ARRAY ';
309 comment on column AECT_data.YTEMP_0 is 'ARRAY ';
310 comment on column AECT_data.DTEMP01 is 'DTEMP01 ';
311 comment on column AECT_data.XTIMP_0 is 'ARRAY ';
312 comment on column AECT_data.YTIMP_0 is 'ARRAY ';
313 comment on column AECT_data.DTIMP01 is 'DTIMP01 ';
314 comment on column AECT_data.UTEMP61 is 'UTEMP61 ';
315 comment on column AECT_data.UTEMP62 is 'UTEMP62 ';
316 comment on column AECT_data.UTIMP61 is 'UTIMP61 ';
317 comment on column AECT_data.UTIMP62 is 'UTIMP62 ';
318 comment on column AECT_data.DTEMP is 'DTEMP ';
319 comment on column AECT_data.SUPPLATY_0 is 'ARRAY ';
320 comment on column AECT_data.SUPPLATX_0 is 'ARRAY ';
321 comment on column AECT_data.X1TEMP is 'X1TEMP ';
322 comment on column AECT_data.X0TEMP is 'X0TEMP ';
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.
|
|