/[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.38 by mocchiut, Fri Feb 24 00:19:43 2012 UTC revision 1.39 by mocchiut, Tue May 15 14:04:38 2012 UTC
# Line 116  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 116  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
116  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001_cln1.pam','2011-02-13 21:00:00',NULL);  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);  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);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'28990','','2011-08-24 21:00:00',NULL);
   
119  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
120  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
121  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001_cln1.pam','2011-11-22 21:00:00',NULL);
# Line 124  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 123  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
123  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001_cln1.pam','2011-11-22 21:00:00',NULL);
124  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001_cln1.pam','2011-11-22 21:00:00',NULL);
125  INSERT INTO GL_RESURS_OFFSET VALUES(0,'30330','','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'30330','','2011-11-22 21:00:00',NULL);
   
126  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001_cln1.pam','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
127  INSERT INTO GL_RESURS_OFFSET VALUES(0,'31660','','2012-02-19 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'31660','','2012-02-19 21:00:00',NULL);
128    
129    
130    
   
131  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_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);  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);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL);
# Line 191  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 188  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
188  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_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);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);
190    
   
191  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL);
192    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_002','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);  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);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_002','2009-12-08 21:00:00',NULL);
195    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_002','2009-12-08 21:00:00',NULL);
196  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL);
197  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002','2009-12-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_001','2010-11-15 21:00:00',NULL);
198    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_002','2010-11-15 21:00:00',NULL);
199  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_003','2010-11-15 21:00:00',NULL);
200  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_004','2010-11-15 21:00:00',NULL);
201  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_005','2010-11-15 21:00:00',NULL);
202  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_006','2010-11-15 21:00:00',NULL);
203    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_007','2010-11-15 21:00:00',NULL);
204    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_008','2010-11-15 21:00:00',NULL);
205    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_009','2010-11-15 21:00:00',NULL);
206    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_010','2010-11-15 21:00:00',NULL);
207    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_011','2010-11-15 21:00:00',NULL);
208    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_012','2010-11-15 21:00:00',NULL);
209    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_013','2010-11-15 21:00:00',NULL);
210  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL);
211    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_002','2010-11-15 21:00:00',NULL);
212    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_003','2010-11-15 21:00:00',NULL);
213    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_004','2010-11-15 21:00:00',NULL);
214    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_005','2010-11-15 21:00:00',NULL);
215    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_006','2010-11-15 21:00:00',NULL);
216    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_007','2010-11-15 21:00:00',NULL);
217  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL);
218    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_002','2010-11-15 21:00:00',NULL);
219  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL);
220    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_002','2010-11-15 21:00:00',NULL);
221  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-02-13 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_002','2010-11-15 21:00:00',NULL);
222  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);
223  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001','2011-02-13 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_002','2010-11-15 21:00:00',NULL);
224    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);
225    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);
226    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_002','2010-11-15 21:00:00',NULL);
227  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL);
228    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_002','2011-02-13 21:00:00',NULL);
229    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);
230    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-05-12 21:00:00',NULL);
231  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL);
232    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_002','2011-11-22 21:00:00',NULL);
233  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL);
234    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_002','2011-11-22 21:00:00',NULL);
235  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL);
236    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_002','2011-11-22 21:00:00',NULL);
237  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL);
238    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_002','2011-11-22 21:00:00',NULL);
239  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL);
240    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_002','2011-11-22 21:00:00',NULL);
241  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL);
   
242  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001','2011-11-22 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001','2011-11-22 21:00:00',NULL);
243    
244  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
# Line 621  insert into GL_PARAM values(0,"$PAM_CALI Line 642  insert into GL_PARAM values(0,"$PAM_CALI
642  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);
643  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);
644  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);
645  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);
646    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);
647  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);
648  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);
649  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);
Legend:
Removed from v.1.38  
changed lines
  Added in v.1.39
  ViewVC Help
Powered by ViewVC 1.1.23