/[PAMELA software]/chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql
ViewVC logotype

Diff of /chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.33 by mocchiut, Tue Jan 18 14:52:59 2011 UTC revision 1.46 by mocchiut, Tue Nov 5 11:27:28 2013 UTC
# Line 100  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 100  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
100  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001_cln1.pam','2009-12-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001_cln1.pam','2009-12-08 21:00:00',NULL);
101  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002_cln1.pam','2009-12-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002_cln1.pam','2009-12-08 21:00:00',NULL);
102  INSERT INTO GL_RESURS_OFFSET VALUES(0,'20820','','2010-03-03 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'20820','','2010-03-03 21:00:00',NULL);
103    INSERT INTO GL_RESURS_OFFSET VALUES(0,'22400','','2010-05-30 21:00:00',NULL);
104  INSERT INTO GL_RESURS_OFFSET VALUES(0,'23600','','2010-08-28 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'23600','','2010-08-28 21:00:00',NULL);
105  INSERT INTO GL_RESURS_OFFSET VALUES(0,'24760','','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'24760','','2010-11-15 21:00:00',NULL);
106    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001_cln1.pam','2010-11-15 21:00:00',NULL);
107    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001_cln1.pam','2010-11-15 21:00:00',NULL);
108    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001_cln1.pam','2010-11-15 21:00:00',NULL);
109    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001_cln1.pam','2010-11-15 21:00:00',NULL);
110    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001_cln1.pam','2010-11-15 21:00:00',NULL);
111    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001_cln1.pam','2010-11-15 21:00:00',NULL);
112    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001_cln1.pam','2010-11-15 21:00:00',NULL);
113    INSERT INTO GL_RESURS_OFFSET VALUES(0,'26080','','2011-02-13 21:00:00',NULL);
114    INSERT INTO GL_RESURS_OFFSET VALUES(0,'27410','','2011-05-12 21:00:00',NULL);
115    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001_cln1.pam','2011-02-13 21:00:00',NULL);
116    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001_cln1.pam','2011-02-13 21:00:00',NULL);
117    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001_cln1.pam','2011-02-13 21:00:00',NULL);
118    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001_cln1.pam','2011-02-13 21:00:00',NULL);
119    INSERT INTO GL_RESURS_OFFSET VALUES(0,'28990','','2011-08-24 21:00:00',NULL);
120    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
121    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
122    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001_cln1.pam','2011-11-22 21:00:00',NULL);
123    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001_cln1.pam','2011-11-22 21:00:00',NULL);
124    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001_cln1.pam','2011-11-22 21:00:00',NULL);
125    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001_cln1.pam','2011-11-22 21:00:00',NULL);
126    INSERT INTO GL_RESURS_OFFSET VALUES(0,'30330','','2011-11-22 21:00:00',NULL);
127    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001_cln1.pam','2012-02-19 21:00:00',NULL);
128    INSERT INTO GL_RESURS_OFFSET VALUES(0,'31660','','2012-02-19 21:00:00',NULL);
129    INSERT INTO GL_RESURS_OFFSET VALUES(0,'32950','','2012-05-15 21:00:00',NULL);
130    INSERT INTO GL_RESURS_OFFSET VALUES(0,'34330','','2012-08-13 21:00:00',NULL);
131    INSERT INTO GL_RESURS_OFFSET VALUES(0,'35600','','2012-11-07 21:00:00',NULL);
132    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001_cln1.pam','2012-08-13 21:00:00',NULL);
133    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001_cln1.pam','2012-08-13 21:00:00',NULL);
134    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001_cln1.pam','2012-08-13 21:00:00',NULL);
135    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001_cln1.pam','2012-08-13 21:00:00',NULL);
136    INSERT INTO GL_RESURS_OFFSET VALUES(0,'36920','','2013-02-05 21:00:00',NULL);
137    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_001_cln1.pam','2012-11-07 21:00:00',NULL);
138    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001_cln1.pam','2012-11-07 21:00:00',NULL);
139    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001_cln1.pam','2012-11-07 21:00:00',NULL);
140    -- 10RED END
141    -- FOLLOWING LINES TO BE CHECKED AFTER RUNNING CHEWBACCA ON DB TESTING ENV
142    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002_cln1.pam','2013-02-05 21:00:00',NULL);
143    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003_cln1.pam','2013-02-05 21:00:00',NULL);
144    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004_cln1.pam','2013-02-05 21:00:00',NULL);
145    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001_cln1.pam','2013-02-05 21:00:00',NULL);
146    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001_cln1.pam','2013-02-05 21:00:00',NULL);
147    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001_cln1.pam','2013-02-05 21:00:00',NULL);
148    INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','2013-08-01 21:00:00',NULL);
149    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001_cln1.pam','2013-08-01 21:00:00',NULL);
150    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001_cln1.pam','2013-08-01 21:00:00',NULL);
151    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001_cln1.pam','2013-08-01 21:00:00',NULL);
152    --
153    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
154    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001_cln1.pam','2013-08-01 21:00:00',NULL);
155    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001_cln1.pam','2013-08-01 21:00:00',NULL);
156    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
157    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
158    INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);
159    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
160    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
161    
162    
163    -- CHEWBACCA SPECIAL FILES
164    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL);
165    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL);
166    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL);
167    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);
168    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);
169    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL);
170    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL);
171    
172    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL);
173    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL);
174    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL);
175    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL);
176    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL);
177    
178    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL);
179    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL);
180    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);
181    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
182    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);
183    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
184    
185    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL);
186    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL);
187    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL);
188    
189    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL);
190    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_002','2008-12-15 21:00:00',NULL);
191    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL);
192    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL);
193    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL);
194    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_002','2008-12-15 21:00:00',NULL);
195    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL);
196    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_002','2008-12-15 21:00:00',NULL);
197    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL);
198    
199    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL);
200    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_002','2009-03-16 21:00:00',NULL);
201    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_003','2009-03-16 21:00:00',NULL);
202    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_004','2009-03-16 21:00:00',NULL);
203    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_005','2009-03-16 21:00:00',NULL);
204    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_006','2009-03-16 21:00:00',NULL);
205    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_007','2009-03-16 21:00:00',NULL);
206    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_008','2009-03-16 21:00:00',NULL);
207    
208    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL);
209    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL);
210    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL);
211    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL);
212    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL);
213    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL);
214    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL);
215    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL);
216    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL);
217    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL);
218    
219    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL);
220    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL);
221    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);
222    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);
223    
224    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL);
225    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_002','2009-12-08 21:00:00',NULL);
226    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001','2009-12-08 21:00:00',NULL);
227    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_002','2009-12-08 21:00:00',NULL);
228    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_002','2009-12-08 21:00:00',NULL);
229    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL);
230    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_001','2010-11-15 21:00:00',NULL);
231    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_002','2010-11-15 21:00:00',NULL);
232    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_003','2010-11-15 21:00:00',NULL);
233    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_004','2010-11-15 21:00:00',NULL);
234    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_005','2010-11-15 21:00:00',NULL);
235    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_006','2010-11-15 21:00:00',NULL);
236    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_007','2010-11-15 21:00:00',NULL);
237    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_008','2010-11-15 21:00:00',NULL);
238    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_009','2010-11-15 21:00:00',NULL);
239    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_010','2010-11-15 21:00:00',NULL);
240    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_011','2010-11-15 21:00:00',NULL);
241    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_012','2010-11-15 21:00:00',NULL);
242    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_013','2010-11-15 21:00:00',NULL);
243    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL);
244    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_002','2010-11-15 21:00:00',NULL);
245    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_003','2010-11-15 21:00:00',NULL);
246    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_004','2010-11-15 21:00:00',NULL);
247    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_005','2010-11-15 21:00:00',NULL);
248    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_006','2010-11-15 21:00:00',NULL);
249    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_007','2010-11-15 21:00:00',NULL);
250    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL);
251    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_002','2010-11-15 21:00:00',NULL);
252    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL);
253    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_002','2010-11-15 21:00:00',NULL);
254    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_002','2010-11-15 21:00:00',NULL);
255    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);
256    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_002','2010-11-15 21:00:00',NULL);
257    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);
258    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);
259    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_002','2010-11-15 21:00:00',NULL);
260    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL);
261    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_002','2011-02-13 21:00:00',NULL);
262    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);
263    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-05-12 21:00:00',NULL);
264    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL);
265    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_002','2011-11-22 21:00:00',NULL);
266    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL);
267    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_002','2011-11-22 21:00:00',NULL);
268    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL);
269    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_002','2011-11-22 21:00:00',NULL);
270    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL);
271    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_002','2011-11-22 21:00:00',NULL);
272    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL);
273    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_002','2011-11-22 21:00:00',NULL);
274    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL);
275    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001','2012-02-19 21:00:00',NULL);
276    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001','2012-08-13 21:00:00',NULL);
277    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_002','2012-08-13 21:00:00',NULL);
278    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001','2012-08-13 21:00:00',NULL);
279    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_002','2012-08-13 21:00:00',NULL);
280    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001','2012-08-13 21:00:00',NULL);
281    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_002','2012-08-13 21:00:00',NULL);
282    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001','2012-08-13 21:00:00',NULL);
283    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_002','2012-08-13 21:00:00',NULL);
284    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_001','2012-11-07 21:00:00',NULL);
285    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_002','2012-11-07 21:00:00',NULL);
286    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001','2012-11-07 21:00:00',NULL);
287    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_002','2012-11-07 21:00:00',NULL);
288    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001','2012-11-07 21:00:00',NULL);
289    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','2012-11-07 21:00:00',NULL);
290    -- 10RED END
291    -- following to be checked
292    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002','2013-02-05 21:00:00',NULL);
293    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003','2013-02-05 21:00:00',NULL);
294    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004','2013-02-05 21:00:00',NULL);
295    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001','2013-02-05 21:00:00',NULL);
296    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-02-05 21:00:00',NULL);
297    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001','2013-02-05 21:00:00',NULL);
298    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001','2013-08-01 21:00:00',NULL);
299    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001','2013-08-01 21:00:00',NULL);
300    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001','2013-08-01 21:00:00',NULL);
301    --
302    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001','2013-08-01 21:00:00',NULL);
303    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001','2013-08-01 21:00:00',NULL);
304    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001','2013-08-01 21:00:00',NULL);
305    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001','2013-08-01 21:00:00',NULL);
306    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001','2013-08-01 21:00:00',NULL);
307    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001','2013-10-29 21:00:00',NULL);
308    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001','2013-10-29 21:00:00',NULL);
309    
310  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
311    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
# Line 507  insert into GL_PARAM values(0,"$PAM_CALI Line 708  insert into GL_PARAM values(0,"$PAM_CALI
708  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.100k.cut.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.100k.cut.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);
709  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.C.5d.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.C.5d.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);
710  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He",NULL);
711  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.9th.all.dat",1,4294967295,203," ToF dE/dx II order correction parameters based on He 9th data reduction",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.9th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He 9th data reduction",NULL);
712    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","calibfile_tofdedx_x10thred.txt",1,4294967295,203," ToF dE/dx II order correction parameters - Rita",NULL);
713  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_1.dat",1,1150848001,204," ToF attenuation parameter file period 1 ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_1.dat",1,1150848001,204," ToF attenuation parameter file period 1 ",NULL);
714  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_2.dat",1150848000,1154995201,204," ToF attenuation parameter file period 2 ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_2.dat",1150848000,1154995201,204," ToF attenuation parameter file period 2 ",NULL);
715  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_3.dat",1154995200,1158019201,204," ToF attenuation parameter file period 3 ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_3.dat",1154995200,1158019201,204," ToF attenuation parameter file period 3 ",NULL);
# Line 555  insert into GL_PARAM values(0,"","",1184 Line 757  insert into GL_PARAM values(0,"","",1184
757  insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL);  insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL);
758  insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);  insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);
759  insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);  insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);
760  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",0,0,301,"igrf 2005",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL);
761  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL);
762    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL);
763    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,946684800,302,"igrf 2000 for interpolations",NULL);
764    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",946684801,1104537600,302,"igrf 2005 for interpolations",NULL);
765    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1104537601,1264400000,302,"igrf 2010 for interpolations",NULL);
766    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10s.dat",1264400001,4294967295,302,"igrf 2015 estimated",NULL);
767  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL);
768    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","IGRF.tab",0,0,304,"11th Generation International Geomagnetic Reference Field Schmidt semi-normalised spherical harmonic coefficients",NULL);
769    
770  CREATE TABLE `GL_TLE` (  CREATE TABLE `GL_TLE` (
771    `ID` int(10) NOT NULL auto_increment,    `ID` int(10) NOT NULL auto_increment,
# Line 850  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` ( Line 1058  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` (
1058  )  )
1059  ;  ;
1060    
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_002','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_002','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_002','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_002','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_003','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_004','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_005','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_006','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_007','2009-03-16 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_008','2009-03-16 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);  
   
1061  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
1062  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (
1063    `ID_N` int unsigned NOT NULL auto_increment COMMENT 'It is the internal table ID',    `ID_N` int unsigned NOT NULL auto_increment COMMENT 'It is the internal table ID',
Legend:
Removed from v.1.33  
changed lines
  Added in v.1.46
  ViewVC Help
Powered by ViewVC 1.1.23