--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2008/12/04 15:27:33 1.10 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/03/19 11:01:33 1.16 @@ -69,6 +69,16 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002_cln1.pam','2008-03-20 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'11300','','2008-06-19 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'12634','','2008-09-18 21:00:00',NULL); +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','14034_001_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'14044','','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001_cln1.pam','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'15430','','2009-03-16 21:00:00',NULL); CREATE TABLE `GL_TIMESYNC` ( @@ -442,9 +452,19 @@ 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_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_28.rz",1196280001,1206100000,201," 11-29 - 03-21 28 28 standard",NULL); -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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_39.rz",1230410001,4294967295,201," > 12-27 good 39 39 calper_39",NULL); 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/","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,4294967295,203," ToF dE/dx II order correction parameters ",NULL); 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/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL); @@ -703,6 +723,7 @@ `BAD_PKT_CALREAD` int default '0' COMMENT 'The number of Calibration packet that could have problems.', `NUM_PKT_SAVED` int default '0' COMMENT 'The total number of packet saved in the ROOT file', `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', + `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', `INSERT_TIME` timestamp default CURRENT_TIMESTAMP, PRIMARY KEY (`ID_N`) ) @@ -728,32 +749,51 @@ `BAD_PKT_CALREAD` int default '0' COMMENT 'The number of Calibration packet that could have problems.', `NUM_PKT_SAVED` int default '0' COMMENT 'The number of packet saved in the ROOT file', `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', + `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', `INSERT_TIME` timestamp default CURRENT_TIMESTAMP, PRIMARY KEY (`ID_N`) ) ; + 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_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_003_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','07408_003_001','2007-07-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_002','2007-07-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_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_003','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','08592_004_002','2007-10-08 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','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','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','14034_001_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 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); + drop table if exists dbname.ROOT_TABLE_MERGING ;