001 SET echo OFF;
002 set linesize 132;
003 drop table APTP_data2tag cascade constraints;
004 drop table APTP_data cascade constraints;
005 create table APTP_data (
006 APTP_data_id number(10),
007 VERS number(10),
008 LINE number(10),
009 TYP varchar2(4),
010 I number(10),
011 ICUT number(10),
012 IPHI_0 number(10),
013 IPHI_1 number(10),
014 IPHI_2 number(10),
015 IPHI_3 number(10),
016 IPHI_4 number(10),
017 IPHI_5 number(10),
018 IPHI_6 number(10),
019 IPHI_7 number(10),
020 IZ number(10),
021 DPHI float(63),
022 Z float(63),
023 R float(63),
024 S float(63),
025 ALFA float(63),
026 BETA float(63),
027 GAMMA float(63)
028 ) tablespace data02;
029
030 alter table APTP_data add constraint APTP_data_pk
031 primary key (APTP_data_id)
032 using index tablespace indx02;
033
034 create table APTP_data2tag (
035 APTP_vers varchar2(255),
036 APTP_data_id number(10)
037 ) tablespace data02;
038
039 alter table APTP_data2tag add constraint APTP_data2tag_pk
040 primary key (APTP_vers, APTP_data_id)
041 using index tablespace indx02;
042 alter table APTP_data2tag add constraint APTP_data2tag_vers_fk
043 foreign key (APTP_vers) references hvs_nodevers (vers_name);
044 alter table APTP_data2tag add constraint APTP_data2tag_data_fk
045 foreign key (APTP_data_id) references APTP_data (APTP_data_id);
046
047 delete from hvs_relation where CHILD_NODENAME = 'APTP';
048 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
049 delete from hvs_nodevers where NODE_NAME = 'APTP';
050 delete from hvs_node where NODE_NAME = 'APTP';
051
052 insert into hvs_node values ('APTP','MuonSpectrometer', '');
053 insert into hvs_nodevers values ('APTP', 'APTP-07', '');
054 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
055 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','APTP','APTP-07');
056 insert into APTP_data (
057 APTP_data_id,
058 VERS,
059 LINE,
060 TYP,
061 I,
062 ICUT,
063 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
064 IZ,
065 DPHI,
066 Z,
067 R,
068 S,
069 ALFA,
070 BETA,
071 GAMMA
072 ) values ( 0,
073 7, 1,'BML', 1, 0, 0, 0, 0, 0, 0, 0,
074 1, 0, 1, 0.0000, 39.0000, 674.3940, 0.0000,
075 0.0000, 0.0000, 0.0000
076 );
077 insert into APTP_data2tag values ('APTP-07', 0);
078 insert into APTP_data (
079 APTP_data_id,
080 VERS,
081 LINE,
082 TYP,
083 I,
084 ICUT,
085 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
086 IZ,
087 DPHI,
088 Z,
089 R,
090 S,
091 ALFA,
092 BETA,
093 GAMMA
094 ) values ( 1,
095 7, 1,'BML', 2, 0, 0, 0, 0, 0, 0, 0,
096 1, 0, 2, 0.0000, 185.0000, 674.3940, 0.0000,
097 0.0000, 0.0000, 0.0000
098 );
099 insert into APTP_data2tag values ('APTP-07', 1);
100 insert into APTP_data (
101 APTP_data_id,
102 VERS,
103 LINE,
104 TYP,
105 I,
106 ICUT,
107 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
108 IZ,
109 DPHI,
110 Z,
111 R,
112 S,
113 ALFA,
114 BETA,
115 GAMMA
116 ) values ( 2,
117 7, 2,'BML', 2, 0, 0, 0, 0, 0, 0, 0,
118 1, 0, 3, 0.0000, 355.0000, 674.3940, 0.0000,
119 0.0000, 0.0000, 0.0000
120 );
121 insert into APTP_data2tag values ('APTP-07', 2);
122 insert into APTP_data (
123 APTP_data_id,
124 VERS,
125 LINE,
126 TYP,
127 I,
128 ICUT,
129 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
130 IZ,
131 DPHI,
132 Z,
133 R,
134 S,
135 ALFA,
136 BETA,
137 GAMMA
138 ) values ( 3,
139 7, 1,'BML', 9, 0, 0, 0, 0, 0, 0, 0,
140 1, 0, -1, 0.0000, -183.1961, 674.3940, 0.0000,
141 0.0000, 0.0000, 0.0000
142 );
143 insert into APTP_data2tag values ('APTP-07', 3);
144 insert into APTP_data (
145 APTP_data_id,
146 VERS,
147 LINE,
148 TYP,
149 I,
150 ICUT,
151 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
152 IZ,
153 DPHI,
154 Z,
155 R,
156 S,
157 ALFA,
158 BETA,
159 GAMMA
160 ) values ( 4,
161 7, 1,'BOL', 2, 0, 0, 0, 0, 0, 0, 0,
162 1, 0, 1, 0.0000, 63.0000, 924.4440, 0.0000,
163 0.0000, 0.0000, 0.0000
164 );
165 insert into APTP_data2tag values ('APTP-07', 4);
166 insert into APTP_data (
167 APTP_data_id,
168 VERS,
169 LINE,
170 TYP,
171 I,
172 ICUT,
173 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
174 IZ,
175 DPHI,
176 Z,
177 R,
178 S,
179 ALFA,
180 BETA,
181 GAMMA
182 ) values ( 5,
183 7, 1,'BOL', 5, 0, 0, 0, 0, 0, 0, 0,
184 1, 0, 2, 0.0000, 233.0000, 924.4440, 0.0000,
185 0.0000, 0.0000, 0.0000
186 );
187 insert into APTP_data2tag values ('APTP-07', 5);
188 insert into APTP_data (
189 APTP_data_id,
190 VERS,
191 LINE,
192 TYP,
193 I,
194 ICUT,
195 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
196 IZ,
197 DPHI,
198 Z,
199 R,
200 S,
201 ALFA,
202 BETA,
203 GAMMA
204 ) values ( 6,
205 7, 2,'BOL', 5, 0, 0, 0, 0, 0, 0, 0,
206 1, 0, 3, 0.0000, 379.0000, 924.4440, 0.0000,
207 0.0000, 0.0000, 0.0000
208 );
209 insert into APTP_data2tag values ('APTP-07', 6);
210 insert into APTP_data (
211 APTP_data_id,
212 VERS,
213 LINE,
214 TYP,
215 I,
216 ICUT,
217 IPHI_0,IPHI_1,IPHI_2,IPHI_3,IPHI_4,IPHI_5,IPHI_6,IPHI_7,
218 IZ,
219 DPHI,
220 Z,
221 R,
222 S,
223 ALFA,
224 BETA,
225 GAMMA
226 ) values ( 7,
227 7, 1,'BOL', 7, 0, 0, 0, 0, 0, 0, 0,
228 1, 0, -1, 0.0000, -231.2521, 924.4440, 0.0000,
229 0.0000, 0.0000, 0.0000
230 );
231 insert into APTP_data2tag values ('APTP-07', 7);
232
233 comment on column APTP_data.APTP_data_id is 'Unique identifier';
234 comment on column APTP_data.VERS is 'VERSION ';
235 comment on column APTP_data.LINE is 'LINE NUMBER ';
236 comment on column APTP_data.TYP is 'STATION TYPE ';
237 comment on column APTP_data.I is 'STATION AMDB INDEX ';
238 comment on column APTP_data.ICUT is 'CUT-OUT INDEX,ZERO IF MISSING ';
239 comment on column APTP_data.IPHI is 'PHI INDICATES OF OCTANTS ';
240 comment on column APTP_data.IZ is 'Z (FOR BARREL) OR R (FOR END-CAPS) POS. ';
241 comment on column APTP_data.DPHI is 'RELATIVE PHI POSITION OF THE STATION IN ';
242 comment on column APTP_data.Z is 'Z POSITION OF THE LOWEST Z EDGE OF THE S ';
243 comment on column APTP_data.R is 'RADIAL POSITION OF ITS INNERMOST EDGE ';
244 comment on column APTP_data.S is 'ORTHO-RADIAL POSITION OF THE CENTER OF T ';
245 comment on column APTP_data.ALFA is 'ALFA ANGLE DEFINING THE DEVIATION [GRAD] ';
246 comment on column APTP_data.BETA is 'BETA ANGLE DEFINING THE DEVIATION ';
247 comment on column APTP_data.GAMMA is 'GAMMA ANGLE DEFINING THE DEVIATION ';
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.
|
|