/[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.58 by mocchiut, Fri Sep 5 12:22:58 2014 UTC revision 1.63 by mocchiut, Thu Oct 23 09:26:16 2014 UTC
# Line 135  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 135  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
135  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001_cln1.pam','2012-11-07 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001_cln1.pam','2012-11-07 21:00:00',NULL);
136  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001_cln1.pam','2012-11-07 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001_cln1.pam','2012-11-07 21:00:00',NULL);
137  -- WARNING! STARTING FROM HERE RAWREADER SPECIAL FILES DISCONTINUED (NOT UPDATED ANYMORE)  -- WARNING! STARTING FROM HERE RAWREADER SPECIAL FILES DISCONTINUED (NOT UPDATED ANYMORE)
138    -- 10 RED BUG
139    INSERT INTO GL_RESURS_OFFSET VALUES(0,'38265','','2013-05-05 21:00:00',NULL);
140    --
141  INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','2013-08-01 21:00:00',NULL);
142  INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);
143  INSERT INTO GL_RESURS_OFFSET VALUES(0,'42260','','2014-01-27 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'42260','','2014-01-27 21:00:00',NULL);
# Line 271  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 274  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
274  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001','2012-11-07 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001','2012-11-07 21:00:00',NULL);
275  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','2012-11-07 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','2012-11-07 21:00:00',NULL);
276  --  --
277  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38270_003_001','2013-02-05 21:00:00',NULL);
278  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38270_003_002','2013-02-05 21:00:00',NULL);
279  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_004_001','2013-02-05 21:00:00',NULL);
280  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_005','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_004_002','2013-02-05 21:00:00',NULL);
281  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_005_001','2013-02-05 21:00:00',NULL);
282  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_002','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_005_002','2013-02-05 21:00:00',NULL);
283  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-02-05 21:00:00',NULL);  --
284  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_002','2013-02-05 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002','2013-05-05 21:00:00',NULL);
285    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003','2013-05-05 21:00:00',NULL);
286    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004','2013-05-05 21:00:00',NULL);
287    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_005','2013-05-05 21:00:00',NULL);
288    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001','2013-05-05 21:00:00',NULL);
289    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_002','2013-05-05 21:00:00',NULL);
290    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-05-05 21:00:00',NULL);
291    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_002','2013-05-05 21:00:00',NULL);
292  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001','2013-08-01 21:00:00',NULL);
293  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_002','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_002','2013-08-01 21:00:00',NULL);
294  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001','2013-08-01 21:00:00',NULL);
295  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_002','2013-08-01 21:00:00',NULL);
296  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_006','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_003','2013-08-01 21:00:00',NULL);
297  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_007','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_004','2013-08-01 21:00:00',NULL);
298  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_008','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_005','2013-08-01 21:00:00',NULL);
299  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_009','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_006','2013-08-01 21:00:00',NULL);
300  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_010','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_007','2013-08-01 21:00:00',NULL);
301    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_008','2013-08-01 21:00:00',NULL);
302    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_009','2013-08-01 21:00:00',NULL);
303    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_010','2013-08-01 21:00:00',NULL);
304    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_011','2013-08-01 21:00:00',NULL);
305    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_012','2013-08-01 21:00:00',NULL);
306    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_001','2013-08-01 21:00:00',NULL);
307    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_006','2013-08-01 21:00:00',NULL);
308    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_007','2013-08-01 21:00:00',NULL);
309    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_008','2013-08-01 21:00:00',NULL);
310    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_009','2013-08-01 21:00:00',NULL);
311    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_010','2013-08-01 21:00:00',NULL);
312  --  --
313  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001','2013-08-01 21:00:00',NULL);
314  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_002','2013-08-01 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_002','2013-08-01 21:00:00',NULL);
# Line 310  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 331  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
331  --  --
332  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_001','2014-01-27 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_001','2014-01-27 21:00:00',NULL);
333  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_002','2014-01-27 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_002','2014-01-27 21:00:00',NULL);
334    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_072_002','2014-01-27 21:00:00',NULL);
335    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_072_003','2014-01-27 21:00:00',NULL);
336  --  --
337  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_001','2014-04-27 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_001','2014-04-27 21:00:00',NULL);
338  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_002','2014-04-27 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_002','2014-04-27 21:00:00',NULL);
# Line 2601  insert into GL_PARAM values(0,"$PAM_CALI Line 2624  insert into GL_PARAM values(0,"$PAM_CALI
2624  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_61.rz",1325372401,1335823200,201," 12-01-01 12-04-30         good",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_61.rz",1325372401,1335823200,201," 12-01-01 12-04-30         good",NULL);
2625  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_62.rz",1335823201,1346450400,201," 12-05-01 12-08-31         good",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_62.rz",1335823201,1346450400,201," 12-05-01 12-08-31         good",NULL);
2626  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_63.rz",1346450401,1356994800,201," 12-08-31 12-12-31         good",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_63.rz",1346450401,1356994800,201," 12-08-31 12-12-31         good",NULL);
2627  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_64.rz",1356994801,4294967295,201," >13-01-01                 good",NULL);  --insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_64.rz",1356994801,4294967295,201," >13-01-01                 good",NULL);
2628    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_64.rz",1356994801,1372629600,201," 13-01-01 13-06-30         good",NULL);
2629    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_65.rz",1372629601,1384700000,201," 13-06-30 13-11-17         good",NULL);
2630    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_66.rz",1384700001,1387400000,201," 13-11-17 13-12-08 HV_H problems",NULL);
2631    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_67.rz",1387400001,1388530800,201," 13-12-08 13-12-31         good",NULL);
2632    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_68.rz",1388530801,1404172800,201," 13-12-31 14-06-30         good",NULL);
2633    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_69.rz",1404172801,4294967295,201," >14-06-30                 good",NULL);
2634  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);
2635  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);
2636  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);
# Line 2642  insert into GL_PARAM values(0,"$PAM_CALI Line 2671  insert into GL_PARAM values(0,"$PAM_CALI
2671  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_26r.dat",1309737600,1324771201,204," ToF attenuation parameter file period 26 Rita ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_26r.dat",1309737600,1324771201,204," ToF attenuation parameter file period 26 Rita ",NULL);
2672  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_27r.dat",1324771200,1337731201,204," ToF attenuation parameter file period 27 Rita ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_27r.dat",1324771200,1337731201,204," ToF attenuation parameter file period 27 Rita ",NULL);
2673  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_28r.dat",1337731200,1350691201,204," ToF attenuation parameter file period 28 Rita ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_28r.dat",1337731200,1350691201,204," ToF attenuation parameter file period 28 Rita ",NULL);
2674  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_29r.dat",1350691200,4294967295,204," ToF attenuation parameter file period 29 Rita ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_29r.dat",1350691200,1364774401,204," ToF attenuation parameter file period 29 Rita ",NULL);
2675    -- EM param:
2676    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_30e.dat",1364774400,1383177601,204," ToF attenuation parameter file period 30 EM ",NULL);
2677    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_31e.dat",1383177600,1398816001,204," ToF attenuation parameter file period 31 EM ",NULL);
2678    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_32e.dat",1398816000,4294967295,204," ToF attenuation parameter file period 32 EM ",NULL);
2679  --  --
2680  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,1,204," ToF attenuation parameter file ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,1,204," ToF attenuation parameter file ",NULL);
2681  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL);
# Line 2673  insert into GL_PARAM values(0,"","",1196 Line 2706  insert into GL_PARAM values(0,"","",1196
2706  insert into GL_PARAM values(0,"","",1309910401,1310083200,217," H connector ",NULL);  insert into GL_PARAM values(0,"","",1309910401,1310083200,217," H connector ",NULL);
2707  insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);  insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);
2708  insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);  insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);
2709    -- WM new:
2710    insert into GL_PARAM values(0,"","",1384700001,1387400000,217," H connector ",NULL);
2711  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL);
2712  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL);
2713  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL);
Legend:
Removed from v.1.58  
changed lines
  Added in v.1.63
  ViewVC Help
Powered by ViewVC 1.1.23