--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2014/08/27 09:13:30 1.54 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2014/10/23 09:06:58 1.61 @@ -50,9 +50,6 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'1619','','2006-09-28 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'2797','','2006-12-12 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'3221','','2007-01-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001_cln1.pam','2007-01-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_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); 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,'4576','','2007-04-08 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'5960','','2007-07-08 21:00:00',NULL); @@ -137,28 +134,17 @@ 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); +-- WARNING! STARTING FROM HERE RAWREADER SPECIAL FILES DISCONTINUED (NOT UPDATED ANYMORE) +-- 10 RED BUG +INSERT INTO GL_RESURS_OFFSET VALUES(0,'38265','','2013-05-05 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,'39594','','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); - +INSERT INTO GL_RESURS_OFFSET VALUES(0,'42260','','2014-01-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'43610','','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'44980','','2014-07-26 21:00:00',NULL); +-- +-- 10RED END -- CHEWBACCA SPECIAL FILES INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL); @@ -287,25 +273,82 @@ 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','38270_003_001','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_004_001','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','38271_005_001','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); +-- +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_005','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_002','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-05-05 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_002','2013-05-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','39592_051_002','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','39593_071_002','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_004','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_006','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_008','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_009','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_010','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_011','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_012','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_001','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_006','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_007','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_008','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_009','2013-08-01 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_072_010','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','40932_077_002','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','40947_078_002','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); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_002','2013-10-29 21:00:00',NULL); +-- +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42268_002_001','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42268_002_002','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42281_076_002','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42281_076_003','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_071_002','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_071_003','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_072_001','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_072_002','2013-10-29 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42295_005_001','2013-10-29 21:00:00',NULL); +-- +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_002','2014-01-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_072_002','2014-01-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_072_003','2014-01-27 21:00:00',NULL); +-- +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_002','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_072_001','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_072_002','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44984_078_001','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44984_078_002','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_007_001','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_007_002','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_076_001','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_076_002','2014-04-27 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44974_001_001','2014-07-26 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44974_001_002','2014-07-26 21:00:00',NULL); +-- +-- 10RED END + CREATE TABLE `GL_TIMESYNC` ( `ID` int(10) unsigned NOT NULL auto_increment, @@ -735,7 +778,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID343NDS/",1215388800,1215475200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID344NDS/",1215475200,1215561600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID345NDS/",1215561600,1215648000,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID345NDS/",1215648000,1215734400,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID345NDS/",1215648000,1215820800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID346NDS/",1215820800,1215907200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID347NDS/",1215907200,1215993600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID348NDS/",1215993600,1216080000,6,"trk mask",NULL); @@ -759,7 +802,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID359NDS/",1217548800,1217635200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID358NDS/",1217635200,1217721600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID358NDS/",1217721600,1217808000,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID358NDS/",1217808000,1217894400,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID358NDS/",1217808000,1217980800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID360NDS/",1217980800,1218067200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID361NDS/",1218067200,1218153600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID362NDS/",1218153600,1218240000,6,"trk mask",NULL); @@ -796,7 +839,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID391NDS/",1220832000,1220918400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID391NDS/",1220918400,1221004800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID391NDS/",1221004800,1221091200,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID390NDS/",1221091200,1221177600,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID390NDS/",1221091200,1222819200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID392NDS/",1222819200,1222905600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID393NDS/",1222905600,1222992000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID394NDS/",1222992000,1223078400,6,"trk mask",NULL); @@ -836,7 +879,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID419NDS/",1225929600,1226016000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID417NDS/",1226016000,1226102400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID420NDS/",1226102400,1226188800,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID421NDS/",1226188800,1226275200,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID421NDS/",1226188800,1226620800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID421NDS/",1226620800,1226707200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID422NDS/",1226707200,1226793600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID423NDS/",1226793600,1226880000,6,"trk mask",NULL); @@ -851,7 +894,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID430NDS/",1227571200,1227657600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID429NDS/",1227657600,1227744000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID431NDS/",1227744000,1227830400,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID432NDS/",1227830400,1227916800,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID432NDS/",1227830400,1228003200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID433NDS/",1228003200,1228089600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID433NDS/",1228089600,1228176000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID434NDS/",1228176000,1228262400,6,"trk mask",NULL); @@ -876,13 +919,13 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID449NDS/",1229817600,1229904000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID450NDS/",1229904000,1229990400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID451NDS/",1229990400,1230076800,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID452NDS/",1230076800,1230163200,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID452NDS/",1230076800,1230249600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID453NDS/",1230249600,1230336000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID454NDS/",1230336000,1230422400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID455NDS/",1230422400,1230508800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID456NDS/",1230508800,1230595200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID457NDS/",1230595200,1230681600,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID458NDS/",1230681600,1230768000,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID458NDS/",1230681600,1230940800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID459NDS/",1230940800,1231027200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID460NDS/",1231027200,1231113600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID460NDS/",1231113600,1231200000,6,"trk mask",NULL); @@ -914,13 +957,13 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID478NDS/",1233360000,1233446400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID478NDS/",1233446400,1233532800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID480NDS/",1233532800,1233619200,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID478NDS/",1233619200,1233705600,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID478NDS/",1233619200,1233792000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID481NDS/",1233792000,1233878400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID482NDS/",1233878400,1233964800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID483NDS/",1233964800,1234051200,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID484NDS/",1234051200,1234137600,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID484NDS/",1234051200,1235174400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID485NDS/",1235174400,1235260800,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID486NDS/",1235260800,1235347200,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID486NDS/",1235260800,1235952000,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID487NDS/",1235952000,1236038400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID488NDS/",1236038400,1236124800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID489NDS/",1236124800,1236211200,6,"trk mask",NULL); @@ -1080,7 +1123,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID605NDS/",1249430400,1249516800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID605NDS/",1249516800,1249603200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID606NDS/",1249603200,1249689600,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID606NDS/",1249689600,1249776000,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID606NDS/",1249689600,1249948800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID607NDS/",1249948800,1250035200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID608NDS/",1250035200,1250121600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID608NDS/",1250121600,1250208000,6,"trk mask",NULL); @@ -1174,12 +1217,12 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID660NDS/",1257724800,1257811200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID660NDS/",1257811200,1257897600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID660NDS/",1257897600,1257984000,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID660NDS/",1257984000,1258070400,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID660NDS/",1257984000,1258156800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID661NDS/",1258156800,1258243200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID662NDS/",1258243200,1258329600,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID663NDS/",1258329600,1258416000,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID663NDS/",1258329600,1258588800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID664NDS/",1258588800,1258675200,6,"trk mask",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID665NDS/",1258675200,1258761600,6,"trk mask",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID665NDS/",1258675200,1258934400,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID666NDS/",1258934400,1259020800,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID667NDS/",1259020800,1259107200,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID668NDS/",1259107200,1259193600,6,"trk mask",NULL); @@ -2486,8 +2529,8 @@ 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/",1396483200,1396569600,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID744MM/",1396569600,1396656000,6,"trk mask",NULL); --- mask_param-1 == no masking -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-1/", 1396656000,4294967295,6,"trk mask",NULL); +-- mask_param-1 == no masking // UPDATE: use conservative mask calculated by Emiliano looking at quicklook plots. +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-ID0E/", 1396656000,4294967295,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","default_calib/",0,0,7,"default calibration",NULL); @@ -2613,7 +2656,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_20.dat",1237593600,1244592001,204," ToF attenuation parameter file period 20 ",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_21.dat",1244592000,1252108801,204," ToF attenuation parameter file period 21 ",NULL); -- Rita param: ---insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_22.dat",1252108800,4294967295,204," ToF attenuation parameter file period 22 ",NULL); +-- insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_22.dat",1252108800,4294967295,204," ToF attenuation parameter file period 22 ",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_21r.dat",1252108800,1260230401,204," ToF attenuation parameter file period 21 Rita ",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_22r.dat",1260230400,1268352001,204," ToF attenuation parameter file period 22 Rita ",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_23r.dat",1268352000,1291161601,204," ToF attenuation parameter file period 23 Rita ",NULL); @@ -2622,7 +2665,11 @@ 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_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_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_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); +-- EM param: +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); +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); +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); -- 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/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL); @@ -2653,6 +2700,8 @@ insert into GL_PARAM values(0,"","",1309910401,1310083200,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); +-- WM new: +insert into GL_PARAM values(0,"","",1384700001,1387400000,217," H connector ",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL);