/[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.57 by mocchiut, Tue Sep 2 13:38:20 2014 UTC revision 1.60 by mocchiut, Thu Oct 23 09:01:31 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 2506  insert into GL_PARAM values(0,"$PAM_CALI Line 2529  insert into GL_PARAM values(0,"$PAM_CALI
2529  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396396800,1396483200,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396396800,1396483200,6,"trk mask",NULL);
2530  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396483200,1396569600,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396483200,1396569600,6,"trk mask",NULL);
2531  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396569600,1396656000,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396569600,1396656000,6,"trk mask",NULL);
2532  -- mask_param-1 == no masking  -- mask_param-1 == no masking // UPDATE: use conservative mask calculated by Emiliano looking at quicklook plots.
2533  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-1/",      1396656000,4294967295,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID0E/",   1396656000,4294967295,6,"trk mask",NULL);
2534    
2535    
2536  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","default_calib/",0,0,7,"default calibration",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","default_calib/",0,0,7,"default calibration",NULL);
# Line 2642  insert into GL_PARAM values(0,"$PAM_CALI Line 2665  insert into GL_PARAM values(0,"$PAM_CALI
2665  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);
2666  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);
2667  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);
2668  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);
2669    -- EM param:
2670    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);
2671    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);
2672    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);
2673  --  --
2674  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);
2675  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);
Legend:
Removed from v.1.57  
changed lines
  Added in v.1.60
  ViewVC Help
Powered by ViewVC 1.1.23