001 SET echo OFF;
002 set linesize 132;
003 drop table WMDT_data2tag cascade constraints;
004 drop table WMDT_data cascade constraints;
005 create table WMDT_data (
006 WMDT_data_id number(10),
007 VERS number(10),
008 TYP varchar2(4),
009 IW number(10),
010 X0 float(63),
011 LAYMDT number(10),
012 TUBPIT float(63),
013 TUBRAD float(63),
014 TUBSTA float(63),
015 TUBDEA float(63),
016 TUBXCO_0 float(63),
017 TUBXCO_1 float(63),
018 TUBXCO_2 float(63),
019 TUBXCO_3 float(63),
020 TUBYCO_0 float(63),
021 TUBYCO_1 float(63),
022 TUBYCO_2 float(63),
023 TUBYCO_3 float(63),
024 TUBWAL float(63)
025 ) ;
026
027 alter table WMDT_data add constraint WMDT_data_pk
028 primary key (WMDT_data_id);
029
030 create table WMDT_data2tag (
031 WMDT_vers varchar2(255),
032 WMDT_data_id number(10)
033 ) ;
034
035 alter table WMDT_data2tag add constraint WMDT_data2tag_pk
036 primary key (WMDT_vers, WMDT_data_id);
037 alter table WMDT_data2tag add constraint WMDT_data2tag_vers_fk
038 foreign key (WMDT_vers) references hvs_nodevers (vers_name);
039 alter table WMDT_data2tag add constraint WMDT_data2tag_data_fk
040 foreign key (WMDT_data_id) references WMDT_data (WMDT_data_id);
041
042 delete from hvs_relation where CHILD_NODENAME = 'WMDT';
043 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
044 delete from hvs_nodevers where NODE_NAME = 'WMDT';
045 delete from hvs_node where NODE_NAME = 'WMDT';
046
047 insert into hvs_node values ('WMDT','MuonSpectrometer', '');
048 insert into hvs_nodevers values ('WMDT', 'WMDT-07', '');
049 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
050 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','WMDT','WMDT-07');
051 insert into WMDT_data (
052 WMDT_data_id,
053 VERS,
054 TYP,
055 IW,
056 X0,
057 LAYMDT,
058 TUBPIT,
059 TUBRAD,
060 TUBSTA,
061 TUBDEA,
062 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
063 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
064 TUBWAL
065 ) values ( 0,
066 7,'MDT', 1, 0.0900, 4, 3.0035, 1.4600, 12.3068,
067 2.7000, 3.0035, 1.5017, 3.0035, 1.5017, 3.0017,
068 5.6029, 8.2040, 10.8051, 0.0400
069 );
070 insert into WMDT_data2tag values ('WMDT-07', 0);
071 insert into WMDT_data (
072 WMDT_data_id,
073 VERS,
074 TYP,
075 IW,
076 X0,
077 LAYMDT,
078 TUBPIT,
079 TUBRAD,
080 TUBSTA,
081 TUBDEA,
082 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
083 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
084 TUBWAL
085 ) values ( 1,
086 7,'MDT', 2, 0.0900, 4, 3.0035, 1.4600, 12.3068,
087 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 1.5017,
088 4.1029, 6.7040, 9.3051, 0.0400
089 );
090 insert into WMDT_data2tag values ('WMDT-07', 1);
091 insert into WMDT_data (
092 WMDT_data_id,
093 VERS,
094 TYP,
095 IW,
096 X0,
097 LAYMDT,
098 TUBPIT,
099 TUBRAD,
100 TUBSTA,
101 TUBDEA,
102 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
103 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
104 TUBWAL
105 ) values ( 2,
106 7,'MDT', 3, 0.0800, 3, 3.0035, 1.4600, 9.7057,
107 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 3.0017,
108 5.6029, 8.2040, 9.3051, 0.0400
109 );
110 insert into WMDT_data2tag values ('WMDT-07', 2);
111 insert into WMDT_data (
112 WMDT_data_id,
113 VERS,
114 TYP,
115 IW,
116 X0,
117 LAYMDT,
118 TUBPIT,
119 TUBRAD,
120 TUBSTA,
121 TUBDEA,
122 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
123 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
124 TUBWAL
125 ) values ( 3,
126 7,'MDT', 4, 0.0800, 3, 3.0035, 1.4600, 9.7057,
127 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 1.5017,
128 4.1029, 6.7040, 9.3051, 0.0400
129 );
130 insert into WMDT_data2tag values ('WMDT-07', 3);
131 insert into WMDT_data (
132 WMDT_data_id,
133 VERS,
134 TYP,
135 IW,
136 X0,
137 LAYMDT,
138 TUBPIT,
139 TUBRAD,
140 TUBSTA,
141 TUBDEA,
142 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
143 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
144 TUBWAL
145 ) values ( 4,
146 7,'MDT', 5, 0.0900, 4, 3.0035, 1.4600, 13.8818,
147 2.7000, 3.0035, 1.5017, 3.0035, 1.5017, 4.5768,
148 7.1779, 9.7790, 12.3801, 0.0400
149 );
150 insert into WMDT_data2tag values ('WMDT-07', 4);
151 insert into WMDT_data (
152 WMDT_data_id,
153 VERS,
154 TYP,
155 IW,
156 X0,
157 LAYMDT,
158 TUBPIT,
159 TUBRAD,
160 TUBSTA,
161 TUBDEA,
162 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
163 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
164 TUBWAL
165 ) values ( 5,
166 7,'MDT', 6, 0.0900, 4, 3.0035, 1.4600, 13.8818,
167 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 1.5017,
168 4.1029, 6.7040, 9.3051, 0.0400
169 );
170 insert into WMDT_data2tag values ('WMDT-07', 5);
171 insert into WMDT_data (
172 WMDT_data_id,
173 VERS,
174 TYP,
175 IW,
176 X0,
177 LAYMDT,
178 TUBPIT,
179 TUBRAD,
180 TUBSTA,
181 TUBDEA,
182 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
183 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
184 TUBWAL
185 ) values ( 6,
186 7,'MDT', 7, 0.0800, 3, 3.0035, 1.4600, 11.2807,
187 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 4.5768,
188 7.1779, 9.7790, 9.3051, 0.0400
189 );
190 insert into WMDT_data2tag values ('WMDT-07', 6);
191 insert into WMDT_data (
192 WMDT_data_id,
193 VERS,
194 TYP,
195 IW,
196 X0,
197 LAYMDT,
198 TUBPIT,
199 TUBRAD,
200 TUBSTA,
201 TUBDEA,
202 TUBXCO_0,TUBXCO_1,TUBXCO_2,TUBXCO_3,
203 TUBYCO_0,TUBYCO_1,TUBYCO_2,TUBYCO_3,
204 TUBWAL
205 ) values ( 7,
206 7,'MDT', 8, 0.0900, 4, 3.0035, 1.4600, 13.8068,
207 2.7000, 1.5017, 3.0035, 1.5017, 3.0035, 4.5018,
208 7.1029, 9.7040, 12.3051, 0.0400
209 );
210 insert into WMDT_data2tag values ('WMDT-07', 7);
211
212 comment on column WMDT_data.WMDT_data_id is 'Unique identifier';
213 comment on column WMDT_data.VERS is 'VERSION ';
214 comment on column WMDT_data.TYP is 'NAME ';
215 comment on column WMDT_data.IW is 'INDEX ';
216 comment on column WMDT_data.X0 is 'X0 ';
217 comment on column WMDT_data.LAYMDT is 'MAXIMUM LAYER NUMBER ';
218 comment on column WMDT_data.TUBPIT is 'PITCH BETWEEN TUBE ';
219 comment on column WMDT_data.TUBRAD is 'RADIUS OF TUBE ';
220 comment on column WMDT_data.TUBSTA is 'THICKNESS OF TUBE ';
221 comment on column WMDT_data.TUBDEA is 'DEAD LENGTH IN TUBES ';
222 comment on column WMDT_data.TUBXCO_0 is 'Y TUBE POSITION ';
223 comment on column WMDT_data.TUBYCO_0 is 'X TUBE POSITION ';
224 comment on column WMDT_data.TUBWAL is 'TUBE WALL THICKNESS ';
This page was automatically generated by the
LXR engine.
|
|