/[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.13 by mocchiut, Mon Dec 22 10:38:14 2008 UTC revision 1.37 by mocchiut, Fri Nov 25 10:00:17 2011 UTC
# Line 39  CREATE TABLE `GL_ROOT` ( Line 39  CREATE TABLE `GL_ROOT` (
39    
40  CREATE TABLE `GL_RESURS_OFFSET` (  CREATE TABLE `GL_RESURS_OFFSET` (
41    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
42    `FROM_ORBIT` int(10) unsigned NOT NULL default '0',    `FROM_ORBIT` int(10) unsigned NOT NULL default '0' COMMENT 'if dwlimit = dworbit the file takes the OLD resurs 0 -- SELECT YEAR(OFFSET_DATE),MONTH(OFFSET_DATE),DAY(OFFSET_DATE),HOUR(OFFSET_DATE),MINUTE(OFFSET_DATE),SECOND(OFFSET_DATE),ID FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< "  << dworbit << " AND SPECIAL_FILE="" order by FROM_ORBIT desc limit 1;',
43    `SPECIAL_FILE` varchar(255) NOT NULL default '',    `SPECIAL_FILE` varchar(255) NOT NULL default '',
44    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',
45    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
# Line 72  INSERT INTO GL_RESURS_OFFSET VALUES(0,'1 Line 72  INSERT INTO GL_RESURS_OFFSET VALUES(0,'1
72  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001_cln1.pam','2008-12-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001_cln1.pam','2008-12-15 21:00:00',NULL);
73  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001_cln1.pam','2008-12-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001_cln1.pam','2008-12-15 21:00:00',NULL);
74  INSERT INTO GL_RESURS_OFFSET VALUES(0,'14044','','2008-12-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'14044','','2008-12-15 21:00:00',NULL);
75    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
76    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001_cln1.pam','2008-12-15 21:00:00',NULL);
77    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
78    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001_cln1.pam','2008-12-15 21:00:00',NULL);
79    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001_cln1.pam','2008-12-15 21:00:00',NULL);
80    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
81    INSERT INTO GL_RESURS_OFFSET VALUES(0,'15430','','2009-03-16 21:00:00',NULL);
82    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001_cln1.pam','2009-03-16 21:00:00',NULL);
83    INSERT INTO GL_RESURS_OFFSET VALUES(0,'16740','','2009-06-10 21:00:00',NULL);
84    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001_cln1.pam','2009-06-10 21:00:00',NULL);
85    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001_cln1.pam','2009-06-10 21:00:00',NULL);
86    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001_cln1.pam','2009-06-10 21:00:00',NULL);
87    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001_cln1.pam','2009-06-10 21:00:00',NULL);
88    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001_cln1.pam','2009-06-10 21:00:00',NULL);
89    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001_cln1.pam','2009-06-10 21:00:00',NULL);
90    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001_cln1.pam','2009-06-10 21:00:00',NULL);
91    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001_cln1.pam','2009-06-10 21:00:00',NULL);
92    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL);
93    INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL);
94    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001_cln1.pam','2009-09-09 21:00:00',NULL);
95    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001_cln1.pam','2009-09-09 21:00:00',NULL);
96    INSERT INTO GL_RESURS_OFFSET VALUES(0,'19525','','2009-12-08 21:00:00',NULL);
97    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001_cln1.pam','2009-12-08 21:00:00',NULL);
98    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001_cln1.pam','2009-12-08 21:00:00',NULL);
99    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_001_cln1.pam','2009-12-08 21:00:00',NULL);
100    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);
102    INSERT INTO GL_RESURS_OFFSET VALUES(0,'20820','','2010-03-03 21:00:00',NULL);
103    INSERT INTO GL_RESURS_OFFSET VALUES(0,'23600','','2010-08-28 21:00:00',NULL);
104    INSERT INTO GL_RESURS_OFFSET VALUES(0,'24760','','2010-11-15 21:00:00',NULL);
105    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001_cln1.pam','2010-11-15 21:00:00',NULL);
106    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001_cln1.pam','2010-11-15 21:00:00',NULL);
107    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001_cln1.pam','2010-11-15 21:00:00',NULL);
108    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001_cln1.pam','2010-11-15 21:00:00',NULL);
109    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001_cln1.pam','2010-11-15 21:00:00',NULL);
110    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001_cln1.pam','2010-11-15 21:00:00',NULL);
111    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001_cln1.pam','2010-11-15 21:00:00',NULL);
112    INSERT INTO GL_RESURS_OFFSET VALUES(0,'26080','','2011-02-13 21:00:00',NULL);
113    INSERT INTO GL_RESURS_OFFSET VALUES(0,'27410','','2011-05-12 21:00:00',NULL);
114    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001_cln1.pam','2011-02-13 21:00:00',NULL);
115    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001_cln1.pam','2011-02-13 21:00:00',NULL);
116    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001_cln1.pam','2011-02-13 21:00:00',NULL);
117    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001_cln1.pam','2011-02-13 21:00:00',NULL);
118    INSERT INTO GL_RESURS_OFFSET VALUES(0,'28990','','2011-08-24 21:00:00',NULL);
119    
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    
128    
129    
130    
131    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL);
132    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL);
133    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL);
134    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);
135    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);
136    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL);
137    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL);
138    
139    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL);
140    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL);
141    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL);
142    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL);
143    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL);
144    
145    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL);
146    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL);
147    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);
148    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
149    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);
150    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
151    
152    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL);
153    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL);
154    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL);
155    
156    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL);
157    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_002','2008-12-15 21:00:00',NULL);
158    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL);
159    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL);
160    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL);
161    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_002','2008-12-15 21:00:00',NULL);
162    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL);
163    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_002','2008-12-15 21:00:00',NULL);
164    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL);
165    
166    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL);
167    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_002','2009-03-16 21:00:00',NULL);
168    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_003','2009-03-16 21:00:00',NULL);
169    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_004','2009-03-16 21:00:00',NULL);
170    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_005','2009-03-16 21:00:00',NULL);
171    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_006','2009-03-16 21:00:00',NULL);
172    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_007','2009-03-16 21:00:00',NULL);
173    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_008','2009-03-16 21:00:00',NULL);
174    
175    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL);
176    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL);
177    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL);
178    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL);
179    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL);
180    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL);
181    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL);
182    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL);
183    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL);
184    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL);
185    
186    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL);
187    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL);
188    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);
189    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);
190    
191    
192    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL);
193    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001','2009-12-08 21:00:00',NULL);
194    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_001','2009-12-08 21:00:00',NULL);
195    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL);
196    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002','2009-12-08 21:00:00',NULL);
197    
198    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001','2010-11-15 21:00:00',NULL);
199    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);
200    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);
201    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);
202    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL);
203    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL);
204    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL);
205    
206    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-02-13 21:00:00',NULL);
207    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);
208    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001','2011-02-13 21:00:00',NULL);
209    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL);
210    
211    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL);
212    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL);
213    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL);
214    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL);
215    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL);
216    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL);
217    
218    
219  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
# Line 400  insert into GL_PARAM values(0,"$PAM_CALI Line 542  insert into GL_PARAM values(0,"$PAM_CALI
542  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL);
543  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL);
544  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special0.dat",1,1172976488,110,"Calorimeter ADC to MIP from flight, special cases",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special0.dat",1,1172976488,110,"Calorimeter ADC to MIP from flight, special cases",NULL);
545  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,1190000000,110,"Calorimeter ADC to MIP from flight, special cases",NULL);
546    insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special2.dat",1190000000,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL);
547  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL);
548  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL);
549  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL);
# Line 421  insert into GL_PARAM values(0,"$PAM_CALI Line 564  insert into GL_PARAM values(0,"$PAM_CALI
564  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31   HV_D problems           B       B       july            Parameters_jul24-31.txt",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31   HV_D problems           B       B       july            Parameters_jul24-31.txt",NULL);
565  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17   -                       C       C       standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17   -                       C       C       standard",NULL);
566  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_4.rz",1155850001,1156280000,201," 08-17 - 08-22   HV_H&HV_N problems      D       D       august          Parameters_aug18-22.txt",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_4.rz",1155850001,1156280000,201," 08-17 - 08-22   HV_H&HV_N problems      D       D       august          Parameters_aug18-22.txt",NULL);
567  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5.rz",1156280001,1165400000,201," 08-22 - 12-06                           E       E       standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5.rz",1156280001,1158700000,201," 08-22 - 09-18  S115B failure            E       E       standard",NULL);
568    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5B.rz",1158700001,1165400000,201," 09-18 - 12-06                           5B       5B       standard",NULL);
569  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_6.rz",1165400001,1168490000,201," 12-06 - 01-11   December Tracker off/on F       F       standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_6.rz",1165400001,1168490000,201," 12-06 - 01-11   December Tracker off/on F       F       standard",NULL);
570  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_7.rz",1168490001,1168940000,201," 01-11 - 01-16   HV_D problems           G       G       january         calper02.txt",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_7.rz",1168490001,1168940000,201," 01-11 - 01-16   HV_D problems           G       G       january         calper02.txt",NULL);
571  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_8.rz",1168940001,1169580000,201," 01-16 - 01-23   HV_F & HV_M problems    G       G       january         calper03.txt",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_8.rz",1168940001,1169580000,201," 01-16 - 01-23   HV_F & HV_M problems    G       G       january         calper03.txt",NULL);
# Line 445  insert into GL_PARAM values(0,"$PAM_CALI Line 589  insert into GL_PARAM values(0,"$PAM_CALI
589  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_26.rz",1195200001,1196230000,201," 11-16 - 11-28   Timing changes         26      26      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_26.rz",1195200001,1196230000,201," 11-16 - 11-28   Timing changes         26      26      standard",NULL);
590  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_27.rz",1196230001,1196280000,201," 11-28 - 11-28   HV_D problems          27      27      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_27.rz",1196230001,1196280000,201," 11-28 - 11-28   HV_D problems          27      27      standard",NULL);
591  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_28.rz",1196280001,1206100000,201," 11-29 - 03-21                          28      28      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_28.rz",1196280001,1206100000,201," 11-29 - 03-21                          28      28      standard",NULL);
592  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_29.rz",1206100001,4294967295,201," > 03-21         HV_C problems          29      29      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_29.rz",1206100001,1206375600,201," 03-21 - 03-24   HV_C problems          29      29 ",NULL);
593    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_30.rz",1206375601,1217989200,201," 03-24 - 08-06   good                    30      30      calper_30 ",NULL);
594    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_31.rz",1217989201,1218550000,201," 08-06 - 08-12   HV_E problems ?         31      31      calper_31",NULL);
595    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_32.rz",1218550001,1225789200,201," 08-12 - 11-04   good                    32      32      calper_32",NULL);
596    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_33.rz",1225789201,1226566800,201," 11-04 - 11-13   HV_E problems ?         33      33      calper_33 ",NULL);
597    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_34.rz",1226566801,1229400000,201," 11-13 - 12-16   good                    34      34      calper_34",NULL);
598    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_35.rz",1229400001,1229470000,201," 12-16 - 12-17   HV_F probl. + HV_E (?)  35      35      calper_35",NULL);
599    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_36.rz",1229470001,1229730000,201," 12-17 - 12-19   HV_E problems (?)       36      36      calper_36",NULL);
600    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_37.rz",1229730001,1230318000,201," 12-19 - 12-26   good                    37      37      calper_37",NULL);
601    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_38.rz",1230318001,1230410000,201," 12-26 - 12-27   HV_H problems           38      38      calper_38",NULL);
602    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_39.rz",1230410001,1230768000,201," 12-27 - 12-31   good                    39      39      calper_39",NULL);
603    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_41.rz",1230768001,1232496000,201," 09-01-01 09-01-20         good",NULL);
604    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_42.rz",1232496001,1235347200,201," 09-01-21 09-02-22         good",NULL);
605    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_43.rz",1235347201,1238544000,201," 09-02-23 09-03-31         good",NULL);
606    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_44.rz",1238544001,1241136000,201," 09-04-01 09-04-30         good",NULL);
607    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_45.rz",1241136001,1243814400,201," 09-05-01 09-05-31         good",NULL);
608    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_46.rz",1243814401,1246406400,201," 09-06-01 09-06-30         good",NULL);
609    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_47.rz",1246406401,1249084800,201," 09-07-01 09-07-31         good",NULL);
610    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_48.rz",1249084801,1251763200,201," 09-08-01 09-08-31         good",NULL);
611    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_49.rz",1251763201,1254355200,201," 09-09-01 09-09-30         good",NULL);
612    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_50.rz",1254355201,1257033600,201," 09-10-01 09-10-31         good",NULL);
613    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_51.rz",1257033601,1259625600,201," 09-11-01 09-11-30         good",NULL);
614    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_52.rz",1259625601,1262304000,201," 09-12-01 09-12-31         good",NULL);
615    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_53.rz",1262304001,4294967295,201," >10-01-01        good",NULL);
616  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL);
617  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.7th.100k.cut.dat",1,4294967295,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);
618  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/tof-param/","dedxmonitor.C.5d.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);
619  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/tof-param/","dedxmonitor.He.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He",NULL);
620    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);
621    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_1.dat",1,1150848001,204," ToF attenuation parameter file period 1 ",NULL);
622    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_2.dat",1150848000,1154995201,204," ToF attenuation parameter file period 2 ",NULL);
623    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_3.dat",1154995200,1158019201,204," ToF attenuation parameter file period 3 ",NULL);
624    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_4.dat",1158019200,1161216001,204," ToF attenuation parameter file period 4 ",NULL);
625    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_5.dat",1161216000,1164499201,204," ToF attenuation parameter file period 5 ",NULL);
626    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_6.dat",1164499200,1167955201,204," ToF attenuation parameter file period 6 ",NULL);
627    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_7.dat",1167955200,1171670401,204," ToF attenuation parameter file period 7 ",NULL);
628    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_8.dat",1171670400,1175472001,204," ToF attenuation parameter file period 8 ",NULL);
629    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_9.dat",1175472000,1179446401,204," ToF attenuation parameter file period 9 ",NULL);
630    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_10.dat",1179446400,1184284801,204," ToF attenuation parameter file period 10 ",NULL);
631    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_11.dat",1184284800,1188691201,204," ToF attenuation parameter file period 11 ",NULL);
632    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_12.dat",1188691200,1193356801,204," ToF attenuation parameter file period 12 ",NULL);
633    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_13.dat",1193356800,1198195201,204," ToF attenuation parameter file period 13 ",NULL);
634    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_14.dat",1198195200,1203292801,204," ToF attenuation parameter file period 14 ",NULL);
635    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_15.dat",1203292800,1208822401,204," ToF attenuation parameter file period 15 ",NULL);
636    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_16.dat",1208822400,1214524801,204," ToF attenuation parameter file period 16 ",NULL);
637    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_17.dat",1214524800,1220659201,204," ToF attenuation parameter file period 17 ",NULL);
638    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_18.dat",1220659200,1228953601,204," ToF attenuation parameter file period 18 ",NULL);
639    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_19.dat",1228953600,1237593601,204," ToF attenuation parameter file period 19 ",NULL);
640    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_20.dat",1237593600,1244592001,204," ToF attenuation parameter file period 20 ",NULL);
641    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_21.dat",1244592000,1252108801,204," ToF attenuation parameter file period 21 ",NULL);
642    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_22.dat",1252108800,4294967295,204," ToF attenuation parameter file period 22 ",NULL);
643    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,1,204," ToF attenuation parameter file ",NULL);
644    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL);
645    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch.txt",1,4294967295,206," ToF BetheBloch parameter file ",NULL);
646    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch_betagt1.txt",1,4294967295,207," ToF Bethe-Bloch parameter file for beta gt1 ",NULL);
647    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_beta.txt",1,4294967295,208," ToF desaturation on beta parameter file ",NULL);
648    insert into GL_PARAM values(0,"","",1182100001,1183030000,210," A connector ",NULL);
649    insert into GL_PARAM values(0,"","",1174665001,1175000000,211," B connector ",NULL);
650    insert into GL_PARAM values(0,"","",1206100001,1206375600,212," C connector ",NULL);
651    insert into GL_PARAM values(0,"","",1153660001,1154375000,213," D connector ",NULL);
652    insert into GL_PARAM values(0,"","",1168490001,1168940000,213," D connector ",NULL);
653    insert into GL_PARAM values(0,"","",1185090001,1185212000,213," D connector ",NULL);
654    insert into GL_PARAM values(0,"","",1191100001,1191940000,213," D connector ",NULL);
655    insert into GL_PARAM values(0,"","",1176800001,1178330000,214," E connector ",NULL);
656    insert into GL_PARAM values(0,"","",1217989201,1218547800,214," E connector ",NULL);
657    insert into GL_PARAM values(0,"","",1225789201,1226566800,214," E connector ",NULL);
658    insert into GL_PARAM values(0,"","",1229400901,1229700000,214," E connector ",NULL);
659    insert into GL_PARAM values(0,"","",1230318001,1230415200,214," E connector ",NULL);
660    insert into GL_PARAM values(0,"","",1168940001,1169580000,215," F connector ",NULL);
661    insert into GL_PARAM values(0,"","",1155850001,1156280000,217," H connector ",NULL);
662    insert into GL_PARAM values(0,"","",1176120001,1176800000,217," H connector ",NULL);
663    insert into GL_PARAM values(0,"","",1178330001,1181322000,217," H connector ",NULL);
664    insert into GL_PARAM values(0,"","",1184000001,1184570000,217," H connector ",NULL);
665    insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL);
666    insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);
667    insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);
668    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL);
669    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL);
670    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL);
671    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,946684800,302,"igrf 2000 for interpolations",NULL);
672    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",946684801,1104537600,302,"igrf 2005 for interpolations",NULL);
673    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1104537601,1264400000,302,"igrf 2010 for interpolations",NULL);
674    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10s.dat",1264400001,4294967295,302,"igrf 2015 estimated",NULL);
675    insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL);
676    
677  CREATE TABLE `GL_TLE` (  CREATE TABLE `GL_TLE` (
678    `ID` int(10) NOT NULL auto_increment,    `ID` int(10) NOT NULL auto_increment,
# Line 708  CREATE TABLE `dbname`.`ROOT_TABLE` ( Line 931  CREATE TABLE `dbname`.`ROOT_TABLE` (
931    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
932    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
933    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
934      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
935      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
936   PRIMARY KEY  (`ID_N`)   PRIMARY KEY  (`ID_N`)
937  )  )
938  ;  ;
# Line 734  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` ( Line 959  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` (
959    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
960    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
961    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
962      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
963      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
964    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
965  )  )
966  ;  ;
967    
   
 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_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_005','2007-10-08 21:00:00',NULL);  
   
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11309_001_002','2008-03-20 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','12874_002_001','2008-06-19 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_003_001','2008-06-19 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_003','2008-06-19 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_004','2008-06-19 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','14044_001_002','2008-12-15 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_003','2008-09-18 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_004','2008-09-18 21:00:00',NULL);  
   
   
   
968  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
969  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (
970    `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.13  
changed lines
  Added in v.1.37
  ViewVC Help
Powered by ViewVC 1.1.23