001 SET echo OFF;
002 set linesize 132;
003 drop table ACUT_data2tag cascade constraints;
004 drop table ACUT_data cascade constraints;
005 create table ACUT_data (
006 ACUT_data_id number(10),
007 VERS number(10),
008 I number(10),
009 ICUT number(10),
010 N number(10)
011 ) ;
012
013 alter table ACUT_data add constraint ACUT_data_pk
014 primary key (ACUT_data_id);
015
016 create table ACUT_data2tag (
017 ACUT_vers varchar2(255),
018 ACUT_data_id number(10)
019 ) ;
020
021 alter table ACUT_data2tag add constraint ACUT_data2tag_pk
022 primary key (ACUT_vers, ACUT_data_id);
023 alter table ACUT_data2tag add constraint ACUT_data2tag_vers_fk
024 foreign key (ACUT_vers) references hvs_nodevers (vers_name);
025 alter table ACUT_data2tag add constraint ACUT_data2tag_data_fk
026 foreign key (ACUT_data_id) references ACUT_data (ACUT_data_id);
027
028 delete from hvs_relation where CHILD_NODENAME = 'ACUT';
029 delete from hvs_nodevers where VERS_NAME = 'MuonSpectrometer-07';
030 delete from hvs_nodevers where NODE_NAME = 'ACUT';
031 delete from hvs_node where NODE_NAME = 'ACUT';
032
033 insert into hvs_node values ('ACUT','MuonSpectrometer', '');
034 insert into hvs_nodevers values ('ACUT', 'ACUT-07', '');
035 insert into hvs_nodevers values ('MuonSpectrometer','MuonSpectrometer-07','');
036 insert into hvs_relation values ('MuonSpectrometer','MuonSpectrometer-07','ACUT','ACUT-07');
037 insert into ACUT_data (
038 ACUT_data_id,
039 VERS,
040 I,
041 ICUT,
042 N
043 ) values ( 0,
044 7, 2, 1, 4
045 );
046 insert into ACUT_data2tag values ('ACUT-07', 0);
047 insert into ACUT_data (
048 ACUT_data_id,
049 VERS,
050 I,
051 ICUT,
052 N
053 ) values ( 1,
054 7, 3, 1, 6
055 );
056 insert into ACUT_data2tag values ('ACUT-07', 1);
057 insert into ACUT_data (
058 ACUT_data_id,
059 VERS,
060 I,
061 ICUT,
062 N
063 ) values ( 2,
064 7, 4, 1, 2
065 );
066 insert into ACUT_data2tag values ('ACUT-07', 2);
067 insert into ACUT_data (
068 ACUT_data_id,
069 VERS,
070 I,
071 ICUT,
072 N
073 ) values ( 3,
074 7, 5, 1, 8
075 );
076 insert into ACUT_data2tag values ('ACUT-07', 3);
077 insert into ACUT_data (
078 ACUT_data_id,
079 VERS,
080 I,
081 ICUT,
082 N
083 ) values ( 4,
084 7, 6, 1, 8
085 );
086 insert into ACUT_data2tag values ('ACUT-07', 4);
087 insert into ACUT_data (
088 ACUT_data_id,
089 VERS,
090 I,
091 ICUT,
092 N
093 ) values ( 5,
094 7, 1, 1, 4
095 );
096 insert into ACUT_data2tag values ('ACUT-07', 5);
097 insert into ACUT_data (
098 ACUT_data_id,
099 VERS,
100 I,
101 ICUT,
102 N
103 ) values ( 6,
104 7, 1, 1, 4
105 );
106 insert into ACUT_data2tag values ('ACUT-07', 6);
107 insert into ACUT_data (
108 ACUT_data_id,
109 VERS,
110 I,
111 ICUT,
112 N
113 ) values ( 7,
114 7, 2, 1, 4
115 );
116 insert into ACUT_data2tag values ('ACUT-07', 7);
117 insert into ACUT_data (
118 ACUT_data_id,
119 VERS,
120 I,
121 ICUT,
122 N
123 ) values ( 8,
124 7, 4, 1, 4
125 );
126 insert into ACUT_data2tag values ('ACUT-07', 8);
127 insert into ACUT_data (
128 ACUT_data_id,
129 VERS,
130 I,
131 ICUT,
132 N
133 ) values ( 9,
134 7, 5, 1, 4
135 );
136 insert into ACUT_data2tag values ('ACUT-07', 9);
137 insert into ACUT_data (
138 ACUT_data_id,
139 VERS,
140 I,
141 ICUT,
142 N
143 ) values ( 10,
144 7, 1, 1, 2
145 );
146 insert into ACUT_data2tag values ('ACUT-07', 10);
147 insert into ACUT_data (
148 ACUT_data_id,
149 VERS,
150 I,
151 ICUT,
152 N
153 ) values ( 11,
154 7, 3, 1, 2
155 );
156 insert into ACUT_data2tag values ('ACUT-07', 11);
157 insert into ACUT_data (
158 ACUT_data_id,
159 VERS,
160 I,
161 ICUT,
162 N
163 ) values ( 12,
164 7, 1, 1, 1
165 );
166 insert into ACUT_data2tag values ('ACUT-07', 12);
167 insert into ACUT_data (
168 ACUT_data_id,
169 VERS,
170 I,
171 ICUT,
172 N
173 ) values ( 13,
174 7, 1, 1, 1
175 );
176 insert into ACUT_data2tag values ('ACUT-07', 13);
177 insert into ACUT_data (
178 ACUT_data_id,
179 VERS,
180 I,
181 ICUT,
182 N
183 ) values ( 14,
184 7, 1, 1, 1
185 );
186 insert into ACUT_data2tag values ('ACUT-07', 14);
187 insert into ACUT_data (
188 ACUT_data_id,
189 VERS,
190 I,
191 ICUT,
192 N
193 ) values ( 15,
194 7, 1, 1, 1
195 );
196 insert into ACUT_data2tag values ('ACUT-07', 15);
197 insert into ACUT_data (
198 ACUT_data_id,
199 VERS,
200 I,
201 ICUT,
202 N
203 ) values ( 16,
204 7, 1, 1, 1
205 );
206 insert into ACUT_data2tag values ('ACUT-07', 16);
207 insert into ACUT_data (
208 ACUT_data_id,
209 VERS,
210 I,
211 ICUT,
212 N
213 ) values ( 17,
214 7, 1, 1, 1
215 );
216 insert into ACUT_data2tag values ('ACUT-07', 17);
217 insert into ACUT_data (
218 ACUT_data_id,
219 VERS,
220 I,
221 ICUT,
222 N
223 ) values ( 18,
224 7, 1, 1, 2
225 );
226 insert into ACUT_data2tag values ('ACUT-07', 18);
227
228 comment on column ACUT_data.ACUT_data_id is 'Unique identifier';
229 comment on column ACUT_data.VERS is 'VERSION ';
230 comment on column ACUT_data.I is 'INDEX ';
231 comment on column ACUT_data.ICUT is 'CUT-OUT INDEX ';
232 comment on column ACUT_data.N is 'NUMBER OF SUB-CUTS IN THE STATION ';
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.
|
|