--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/03/19 11:01:33 1.16 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/11/20 14:30:24 1.19 @@ -79,6 +79,20 @@ 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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001_cln1.pam','2009-03-16 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'16740','','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL); + + CREATE TABLE `GL_TIMESYNC` ( @@ -464,7 +478,33 @@ 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.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,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,4294967295,203," ToF dE/dx II order correction parameters ",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,4294967295,204," ToF attenuation 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); +insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch.txt",1,4294967295,206," ToF BetheBloch parameter file ",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch_betagt1.txt",1,4294967295,207," ToF Bethe-Bloch parameter file for beta gt1 ",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_beta.txt",1,4294967295,208," ToF desaturation on beta parameter file ",NULL); +insert into GL_PARAM values(0,"","",1182100001,1183030000,210," A connector ",NULL); +insert into GL_PARAM values(0,"","",1174665001,1175000000,211," B connector ",NULL); +insert into GL_PARAM values(0,"","",1206100001,1206375600,212," C connector ",NULL); +insert into GL_PARAM values(0,"","",1153660001,1154375000,213," D connector ",NULL); +insert into GL_PARAM values(0,"","",1168490001,1168940000,213," D connector ",NULL); +insert into GL_PARAM values(0,"","",1185090001,1185212000,213," D connector ",NULL); +insert into GL_PARAM values(0,"","",1191100001,1191940000,213," D connector ",NULL); +insert into GL_PARAM values(0,"","",1176800001,1178330000,214," E connector ",NULL); +insert into GL_PARAM values(0,"","",1217989201,1218547800,214," E connector ",NULL); +insert into GL_PARAM values(0,"","",1225789201,1226566800,214," E connector ",NULL); +insert into GL_PARAM values(0,"","",1229400901,1229700000,214," E connector ",NULL); +insert into GL_PARAM values(0,"","",1230318001,1230415200,214," E connector ",NULL); +insert into GL_PARAM values(0,"","",1168940001,1169580000,215," F connector ",NULL); +insert into GL_PARAM values(0,"","",1155850001,1156280000,217," H connector ",NULL); +insert into GL_PARAM values(0,"","",1176120001,1176800000,217," H connector ",NULL); +insert into GL_PARAM values(0,"","",1178330001,1181322000,217," H connector ",NULL); +insert into GL_PARAM values(0,"","",1184000001,1184570000,217," H connector ",NULL); +insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL); +insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL); +insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",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); @@ -795,6 +835,24 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_004','2008-09-18 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001','2009-06-10 21:00:00',NULL); + + drop table if exists dbname.ROOT_TABLE_MERGING ; CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (