001 SET echo OFF;
002 set linesize 132;
003 drop table RAIL_data2tag cascade constraints;
004 drop table RAIL_data cascade constraints;
005 create table RAIL_data (
006 RAIL_data_id number(10),
007 CERZLENG float(63),
008 EXRZLENG float(63),
009 CERWIDT1 float(63),
010 CERWIDT2 float(63),
011 CERWID3O float(63),
012 CERWID3I float(63),
013 CERTHIC1 float(63),
014 CERTHIC2 float(63),
015 CERRPSZL float(63),
016 CERRPEZL float(63),
017 CERRPIX1 float(63),
018 CERRPOX1 float(63),
019 CERRPSZP_0 float(63),
020 CERRPSZP_1 float(63),
021 CERRPSZP_2 float(63),
022 CERRPSZP_3 float(63),
023 CERRPSZP_4 float(63),
024 CERRPSZP_5 float(63),
025 CERRPSZP_6 float(63),
026 CERRPSZP_7 float(63),
027 CERRPSZP_8 float(63),
028 CERRPSZP_9 float(63),
029 CERRPSZP_10 float(63),
030 EXRRPSZP_0 float(63),
031 EXRRPSZP_1 float(63),
032 EXRRPSZP_2 float(63),
033 EXRRPSZP_3 float(63),
034 EXRRPSZP_4 float(63),
035 EXRRPSZP_5 float(63),
036 EXRRPSZP_6 float(63),
037 EXRRPSZP_7 float(63),
038 EXRRPSZP_8 float(63),
039 EXRRPSZP_9 float(63),
040 EXRRPSZP_10 float(63),
041 EXRRPSZP_11 float(63),
042 EXRRPSZP_12 float(63),
043 EXRRPSZP_13 float(63),
044 EXRRPSZP_14 float(63),
045 EXRRPSZP_15 float(63),
046 EXRRPSZP_16 float(63),
047 XPOS float(63),
048 TOTHEIGH float(63),
049 CERY float(63),
050 CERXB float(63),
051 CERYB float(63),
052 CERXC float(63),
053 CERYC float(63),
054 CERXD float(63),
055 CERYD float(63),
056 CERXE float(63),
057 CERYE float(63),
058 CERXF float(63),
059 CERYF float(63),
060 CERXG float(63),
061 CERYG float(63),
062 CERXH float(63),
063 CERYH float(63),
064 CERXI float(63),
065 CERYI float(63),
066 CERXJ float(63),
067 CERYJ float(63),
068 CERXK float(63),
069 CERYK float(63),
070 CERXL float(63),
071 CERYL float(63),
072 CERXM float(63),
073 CERYM float(63),
074 CERRPIY2 float(63),
075 CERRPIXA float(63),
076 CERRPIYA float(63),
077 CERRPIXB float(63),
078 CERRPIYB float(63),
079 CERRPIXC float(63),
080 CERRPIYC float(63),
081 CERRPIXD float(63),
082 CERRPIYD float(63),
083 CERRPIXE float(63),
084 CERRPIYE float(63),
085 CERRPOXA float(63),
086 CERRPOYA float(63),
087 CERRPOXB float(63),
088 CERRPOYB float(63),
089 CERRPOXC float(63),
090 CERRPOYC float(63),
091 CERRPOXD float(63),
092 CERRPOYD float(63),
093 CERRPOXE float(63),
094 CERRPOYE float(63),
095 CERRPE1Z float(63),
096 CERRPE2Z float(63),
097 EXRRPE1Z float(63),
098 EXRRPE2Z float(63),
099 YPOS float(63),
100 EXTRZPOS float(63)
101 ) ;
102
103 alter table RAIL_data add constraint RAIL_data_pk
104 primary key (RAIL_data_id);
105
106 create table RAIL_data2tag (
107 RAIL_vers varchar2(255),
108 RAIL_data_id number(10)
109 ) ;
110
111 alter table RAIL_data2tag add constraint RAIL_data2tag_pk
112 primary key (RAIL_vers, RAIL_data_id);
113 alter table RAIL_data2tag add constraint RAIL_data2tag_vers_fk
114 foreign key (RAIL_vers) references hvs_nodevers (vers_name);
115 alter table RAIL_data2tag add constraint RAIL_data2tag_data_fk
116 foreign key (RAIL_data_id) references RAIL_data (RAIL_data_id);
117
118 delete from hvs_relation where CHILD_NODENAME = 'RAIL';
119 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-01';
120 delete from hvs_nodevers where NODE_NAME = 'RAIL';
121 delete from hvs_node where NODE_NAME = 'RAIL';
122
123 insert into hvs_node values ('RAIL','MuonSpectrometer', '');
124 insert into hvs_nodevers values ('RAIL', 'RAIL-01', '');
125 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-01','');
126 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-01','RAIL','RAIL-01');
127 insert into RAIL_data (
128 RAIL_data_id,
129 CERZLENG,
130 EXRZLENG,
131 CERWIDT1,
132 CERWIDT2,
133 CERWID3O,
134 CERWID3I,
135 CERTHIC1,
136 CERTHIC2,
137 CERRPSZL,
138 CERRPEZL,
139 CERRPIX1,
140 CERRPOX1,
141 CERRPSZP_0,CERRPSZP_1,CERRPSZP_2,CERRPSZP_3,CERRPSZP_4,CERRPSZP_5,CERRPSZP_6,
142 CERRPSZP_7,CERRPSZP_8,CERRPSZP_9,CERRPSZP_10,
143 EXRRPSZP_0,EXRRPSZP_1,EXRRPSZP_2,EXRRPSZP_3,EXRRPSZP_4,EXRRPSZP_5,EXRRPSZP_6,
144 EXRRPSZP_7,EXRRPSZP_8,EXRRPSZP_9,EXRRPSZP_10,EXRRPSZP_11,EXRRPSZP_12,
145 EXRRPSZP_13,EXRRPSZP_14,EXRRPSZP_15,EXRRPSZP_16,
146 XPOS,
147 TOTHEIGH,
148 CERY,
149 CERXB,
150 CERYB,
151 CERXC,
152 CERYC,
153 CERXD,
154 CERYD,
155 CERXE,
156 CERYE,
157 CERXF,
158 CERYF,
159 CERXG,
160 CERYG,
161 CERXH,
162 CERYH,
163 CERXI,
164 CERYI,
165 CERXJ,
166 CERYJ,
167 CERXK,
168 CERYK,
169 CERXL,
170 CERYL,
171 CERXM,
172 CERYM,
173 CERRPIY2,
174 CERRPIXA,
175 CERRPIYA,
176 CERRPIXB,
177 CERRPIYB,
178 CERRPIXC,
179 CERRPIYC,
180 CERRPIXD,
181 CERRPIYD,
182 CERRPIXE,
183 CERRPIYE,
184 CERRPOXA,
185 CERRPOYA,
186 CERRPOXB,
187 CERRPOYB,
188 CERRPOXC,
189 CERRPOYC,
190 CERRPOXD,
191 CERRPOYD,
192 CERRPOXE,
193 CERRPOYE,
194 CERRPE1Z,
195 CERRPE2Z,
196 EXRRPE1Z,
197 EXRRPE2Z,
198 YPOS,
199 EXTRZPOS
200 ) values ( 1,
201 6850.0000, 9784.0000, 450.0000, 120.0000, 380.0000, 350.0000,
202 100.0000, 200.0000, 50.0000, 40.0000, 260.0000, 290.0000,
203 490.0000, 1090.0000, 1687.5000, 2285.0000, 2885.0000, 3400.0000,
204 3915.0000, 4515.0000, 5112.5000, 5710.0000, 6310.0000, 540.0000,
205 1085.0000, 1627.5000, 2170.0000, 2715.0000, 3230.0000, 3745.0000,
206 4315.0000, 4895.0000, 5465.0000, 5980.0000, 6495.0000, 7017.5000,
207 7540.0000, 8062.5000, 8720.0000, 9375.0000, 2985.0000, 400.0000,
208 0.0000, 225.0000, 0.0000, 225.0000, 100.0000, 60.0000,
209 100.0000, 60.0000, 300.0000, 350.0000, 300.0000, 350.0000,
210 400.0000, -380.0000, 400.0000, -380.0000, 300.0000, -60.0000,
211 300.0000, -60.0000, 100.0000, -225.0000, 100.0000, -225.0000,
212 0.0000, 135.6741, 60.0000, 100.0000, 225.0000, 100.0000,
213 320.0000, 235.6741, 320.0000, 300.0000, 60.0000, 300.0000,
214 -60.0000, 100.0000, -225.0000, 100.0000, -350.0000, 235.6741,
215 -350.0000, 300.0000, -60.0000, 300.0000, -3405.0000, 3405.0000,
216 -4872.0000, 4872.0000, -4790.0000, 8317.0000
217 );
218 insert into RAIL_data2tag values ('RAIL-01', 1);
219
220 comment on column RAIL_data.RAIL_data_id is 'Unique identifier';
221 comment on column RAIL_data.CERZLENG is 'CENTRALRAIL_ZLENGTH ';
222 comment on column RAIL_data.EXRZLENG is 'EXTREMITYRAIL_ZLENGTH ';
223 comment on column RAIL_data.CERWIDT1 is 'CENTRALRAIL_WIDTH1 ';
224 comment on column RAIL_data.CERWIDT2 is 'CENTRALRAIL_WIDTH2 ';
225 comment on column RAIL_data.CERWID3O is 'CENTRALRAIL_WIDTH3OUTER ';
226 comment on column RAIL_data.CERWID3I is 'CENTRALRAIL_WIDTH3INNER ';
227 comment on column RAIL_data.CERTHIC1 is 'CENTRALRAIL_THICK1 ';
228 comment on column RAIL_data.CERTHIC2 is 'CENTRALRAIL_THICK2 ';
229 comment on column RAIL_data.CERRPSZL is 'CENTRALRAILREINFORCEMENTPLATE_STD_ZLENGT ';
230 comment on column RAIL_data.CERRPEZL is 'CENTRALRAILREINFORCEMENTPLATE_EXTREMITY_ ';
231 comment on column RAIL_data.CERRPIX1 is 'CENTRALRAILREINFORCEMENTPLATEINNER_XDIST ';
232 comment on column RAIL_data.CERRPOX1 is 'CENTRALRAILREINFORCEMENTPLATEOUTER_XDIST ';
233 comment on column RAIL_data.CERRPSZP_0 is 'ARRAY ';
234 comment on column RAIL_data.EXRRPSZP_0 is 'ARRAY ';
235 comment on column RAIL_data.XPOS is 'XPOS ';
236 comment on column RAIL_data.TOTHEIGH is 'TOTHEIGHT ';
237 comment on column RAIL_data.CERY is 'CERY ';
238 comment on column RAIL_data.CERXB is 'CERXB ';
239 comment on column RAIL_data.CERYB is 'CERYB ';
240 comment on column RAIL_data.CERXC is 'CERXC ';
241 comment on column RAIL_data.CERYC is 'CERYC ';
242 comment on column RAIL_data.CERXD is 'CERXD ';
243 comment on column RAIL_data.CERYD is 'CERYD ';
244 comment on column RAIL_data.CERXE is 'CERXE ';
245 comment on column RAIL_data.CERYE is 'CERYE ';
246 comment on column RAIL_data.CERXF is 'CERXF ';
247 comment on column RAIL_data.CERYF is 'CERYF ';
248 comment on column RAIL_data.CERXG is 'CERXG ';
249 comment on column RAIL_data.CERYG is 'CERYG ';
250 comment on column RAIL_data.CERXH is 'CERXH ';
251 comment on column RAIL_data.CERYH is 'CERYH ';
252 comment on column RAIL_data.CERXI is 'CERXI ';
253 comment on column RAIL_data.CERYI is 'CERYI ';
254 comment on column RAIL_data.CERXJ is 'CERXJ ';
255 comment on column RAIL_data.CERYJ is 'CERYJ ';
256 comment on column RAIL_data.CERXK is 'CERXK ';
257 comment on column RAIL_data.CERYK is 'CERYK ';
258 comment on column RAIL_data.CERXL is 'CERXL ';
259 comment on column RAIL_data.CERYL is 'CERYL ';
260 comment on column RAIL_data.CERXM is 'CERXM ';
261 comment on column RAIL_data.CERYM is 'CERYM ';
262 comment on column RAIL_data.CERRPIY2 is 'CENTRALRAILREINFORCEMENTPLATEINNER_YDIST ';
263 comment on column RAIL_data.CERRPIXA is 'CERRPIXA ';
264 comment on column RAIL_data.CERRPIYA is 'CERRPIYA ';
265 comment on column RAIL_data.CERRPIXB is 'CERRPIXB ';
266 comment on column RAIL_data.CERRPIYB is 'CERRPIYB ';
267 comment on column RAIL_data.CERRPIXC is 'CERRPIXC ';
268 comment on column RAIL_data.CERRPIYC is 'CERRPIYC ';
269 comment on column RAIL_data.CERRPIXD is 'CERRPIXD ';
270 comment on column RAIL_data.CERRPIYD is 'CERRPIYD ';
271 comment on column RAIL_data.CERRPIXE is 'CERRPIXE ';
272 comment on column RAIL_data.CERRPIYE is 'CERRPIYE ';
273 comment on column RAIL_data.CERRPOXA is 'CERRPOXA ';
274 comment on column RAIL_data.CERRPOYA is 'CERRPOYA ';
275 comment on column RAIL_data.CERRPOXB is 'CERRPOXB ';
276 comment on column RAIL_data.CERRPOYB is 'CERRPOYB ';
277 comment on column RAIL_data.CERRPOXC is 'CERRPOXC ';
278 comment on column RAIL_data.CERRPOYC is 'CERRPOYC ';
279 comment on column RAIL_data.CERRPOXD is 'CERRPOXD ';
280 comment on column RAIL_data.CERRPOYD is 'CERRPOYD ';
281 comment on column RAIL_data.CERRPOXE is 'CERRPOXE ';
282 comment on column RAIL_data.CERRPOYE is 'CERRPOYE ';
283 comment on column RAIL_data.CERRPE1Z is 'CENTRALRAILREINFORCEMENTPLATE_EXTREMITY1 ';
284 comment on column RAIL_data.CERRPE2Z is 'CENTRALRAILREINFORCEMENTPLATE_EXTREMITY2 ';
285 comment on column RAIL_data.EXRRPE1Z is 'EXTREMITYRAILREINFORCEMENTPLATE_EXTREMIT ';
286 comment on column RAIL_data.EXRRPE2Z is 'EXTREMITYRAILREINFORCEMENTPLATE_EXTREMIT ';
287 comment on column RAIL_data.YPOS is 'YPOS ';
288 comment on column RAIL_data.EXTRZPOS is 'EXTRZPOS ';
This page was automatically generated by the
LXR engine.
|
|