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

Diff of /YodaProfiler/docs/PAMELAProductionDB.sql

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

revision 1.16 by mocchiut, Mon Apr 30 15:57:06 2007 UTC revision 1.19 by pam-fi, Fri Aug 31 16:54:03 2007 UTC
# Line 55  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 55  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
55  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001_cln1.pam','2007-01-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001_cln1.pam','2007-01-08 21:00:00',NULL);
56  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001_cln1.pam','2007-01-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001_cln1.pam','2007-01-08 21:00:00',NULL);
57  INSERT INTO GL_RESURS_OFFSET VALUES(0,'4576','','2007-04-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'4576','','2007-04-08 21:00:00',NULL);
58    INSERT INTO GL_RESURS_OFFSET VALUES(0,'5960','','2007-07-08 21:00:00',NULL);
59    
60  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
61    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
# Line 87  CREATE TABLE `GL_PARAM` ( Line 88  CREATE TABLE `GL_PARAM` (
88  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","field_param-0/",0,0,1,"field",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","field_param-0/",0,0,1,"field",NULL);
89  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mip_param-0/",0,0,2,"trk mip",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mip_param-0/",0,0,2,"trk mip",NULL);
90  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","charge_param-1/",0,0,3,"trk charge",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","charge_param-1/",0,0,3,"trk charge",NULL);
91  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","eta_param-0/",0,0,4,"trk pfa",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","eta_param-2/",0,0,4,"trk pfa",NULL);
92  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","align_param-0/",0,0,5,"trk alignment",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","align_param-Q.A/",0,0,5,"trk alignment",NULL);
93  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-1/",0,0,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-1/",0,0,6,"trk mask",NULL);
94  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);
95  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP-dws2000.dat",1,1,101,"Calorimeter ADC to MIP from flight data dw serie 2000",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP-dws2000.dat",1,1,101,"Calorimeter ADC to MIP from flight data dw serie 2000",NULL);
# Line 100  insert into GL_PARAM values(0,"$PAM_CALI Line 101  insert into GL_PARAM values(0,"$PAM_CALI
101  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask.dat",0,0,103,"Calorimeter bad strip offline mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask.dat",0,0,103,"Calorimeter bad strip offline mask",NULL);
102  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloDefaultCalib.root",0,0,104,"Calorimeter default calibration",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloDefaultCalib.root",0,0,104,"Calorimeter default calibration",NULL);
103  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1,1153659999,201," Default tof param from flight data",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1,1153659999,201," Default tof param from flight data",NULL);
104  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_july_24-31.rz",1153660000,1154375000,201," tof param from flight data 24th-31th July 2006",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_jul_24-31.rz",1153660000,1154375000,201," tof param from flight data 24th-31th July 2006",NULL);
105  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1154375001,1155849999,201," Default tof param from flight data",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1154375001,1155849999,201," Default tof param from flight data",NULL);
106  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_aug_18-22.rz",1155850000,1156280000,201," tof param from flight data 18th-22nd August 2006",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_aug_18-22.rz",1155850000,1156280000,201," tof param from flight data 18th-22nd August 2006",NULL);
107  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1156280001,1168498999,201," Default tof param from flight data",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_standard.rz",1156280001,1168498999,201," Default tof param from flight data",NULL);
Legend:
Removed from v.1.16  
changed lines
  Added in v.1.19
  ViewVC Help
Powered by ViewVC 1.1.23