--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql	2011/11/25 10:00:17	1.37
+++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql	2013/11/05 11:27:28	1.46
@@ -100,6 +100,7 @@
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001_cln1.pam','2009-12-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002_cln1.pam','2009-12-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'20820','','2010-03-03 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'22400','','2010-05-30 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'23600','','2010-08-28 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'24760','','2010-11-15 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001_cln1.pam','2010-11-15 21:00:00',NULL);
@@ -116,7 +117,6 @@
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001_cln1.pam','2011-02-13 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001_cln1.pam','2011-02-13 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'28990','','2011-08-24 21:00:00',NULL);
-
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001_cln1.pam','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001_cln1.pam','2011-11-22 21:00:00',NULL);
@@ -124,10 +124,43 @@
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001_cln1.pam','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001_cln1.pam','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'30330','','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001_cln1.pam','2012-02-19 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'31660','','2012-02-19 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'32950','','2012-05-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'34330','','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'35600','','2012-11-07 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001_cln1.pam','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001_cln1.pam','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001_cln1.pam','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001_cln1.pam','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'36920','','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_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);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001_cln1.pam','2012-11-07 21:00:00',NULL);
+-- 10RED END
+-- FOLLOWING LINES TO BE CHECKED AFTER RUNNING CHEWBACCA ON DB TESTING ENV
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001_cln1.pam','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001_cln1.pam','2013-08-01 21:00:00',NULL);
+--
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
 
 
-
-
+-- CHEWBACCA SPECIAL FILES
 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_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);
@@ -188,33 +221,91 @@
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);
 
-
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_002','2009-12-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001','2009-12-08 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_001','2009-12-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_002','2009-12-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_002','2009-12-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002','2009-12-08 21:00:00',NULL);
-
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001','2010-11-15 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_002','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_003','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_004','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_005','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_006','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_007','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_008','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_009','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_010','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_011','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_012','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_013','2010-11-15 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_002','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_003','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_004','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_005','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_006','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_007','2010-11-15 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_002','2010-11-15 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL);
-
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-02-13 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001','2011-02-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_002','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_002','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_002','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_002','2010-11-15 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL);
-
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_002','2011-02-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-05-12 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_002','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_002','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_002','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_002','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_002','2011-11-22 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL);
-
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001','2012-02-19 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_002','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_002','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_002','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_002','2012-08-13 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_001','2012-11-07 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_002','2012-11-07 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001','2012-11-07 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_002','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);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','2012-11-07 21:00:00',NULL);
+-- 10RED END
+-- following to be checked
+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','39611_072_003','2013-02-05 21:00:00',NULL);
+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','39611_073_001','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-02-05 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001','2013-02-05 21:00:00',NULL);
+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','39593_071_001','2013-08-01 21:00:00',NULL);
+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','40932_077_001','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001','2013-08-01 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001','2013-10-29 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001','2013-10-29 21:00:00',NULL);
 
 CREATE TABLE `GL_TIMESYNC` (
   `ID` int(10) unsigned NOT NULL auto_increment,
@@ -617,7 +708,8 @@
 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,1,203," ToF dE/dx II order correction parameters ",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He",NULL);
-insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.9th.all.dat",1,4294967295,203," ToF dE/dx II order correction parameters based on He 9th data reduction",NULL);
+insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.9th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He 9th data reduction",NULL);
+insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","calibfile_tofdedx_x10thred.txt",1,4294967295,203," ToF dE/dx II order correction parameters - Rita",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_1.dat",1,1150848001,204," ToF attenuation parameter file period 1 ",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_2.dat",1150848000,1154995201,204," ToF attenuation parameter file period 2 ",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_3.dat",1154995200,1158019201,204," ToF attenuation parameter file period 3 ",NULL);
@@ -673,6 +765,7 @@
 insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1104537601,1264400000,302,"igrf 2010 for interpolations",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10s.dat",1264400001,4294967295,302,"igrf 2015 estimated",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL);
+insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","IGRF.tab",0,0,304,"11th Generation International Geomagnetic Reference Field Schmidt semi-normalised spherical harmonic coefficients",NULL);
 
 CREATE TABLE `GL_TLE` (
   `ID` int(10) NOT NULL auto_increment,
