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

Diff of /chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql

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

revision 1.44 by mocchiut, Wed Mar 6 10:12:35 2013 UTC revision 1.46 by mocchiut, Tue Nov 5 11:27:28 2013 UTC
# Line 137  INSERT INTO GL_RESURS_OFFSET VALUES(0,'3 Line 137  INSERT INTO GL_RESURS_OFFSET VALUES(0,'3
137  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_005_001_cln1.pam','2012-11-07 21:00:00',NULL);
138  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_006_001_cln1.pam','2012-11-07 21:00:00',NULL);
139  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_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);
140    -- 10RED END
141    -- FOLLOWING LINES TO BE CHECKED AFTER RUNNING CHEWBACCA ON DB TESTING ENV
142    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002_cln1.pam','2013-02-05 21:00:00',NULL);
143    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003_cln1.pam','2013-02-05 21:00:00',NULL);
144    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004_cln1.pam','2013-02-05 21:00:00',NULL);
145    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001_cln1.pam','2013-02-05 21:00:00',NULL);
146    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001_cln1.pam','2013-02-05 21:00:00',NULL);
147    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001_cln1.pam','2013-02-05 21:00:00',NULL);
148    INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','2013-08-01 21:00:00',NULL);
149    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001_cln1.pam','2013-08-01 21:00:00',NULL);
150    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001_cln1.pam','2013-08-01 21:00:00',NULL);
151    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001_cln1.pam','2013-08-01 21:00:00',NULL);
152    --
153    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
154    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001_cln1.pam','2013-08-01 21:00:00',NULL);
155    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001_cln1.pam','2013-08-01 21:00:00',NULL);
156    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
157    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001_cln1.pam','2013-08-01 21:00:00',NULL);
158    INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);
159    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
160    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001_cln1.pam','2013-10-29 21:00:00',NULL);
161    
162    
163    -- CHEWBACCA SPECIAL FILES
164  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_001','2007-01-08 21:00:00',NULL);
165  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_002_002','2007-01-08 21:00:00',NULL);
166  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_002','2007-01-08 21:00:00',NULL);
# Line 266  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 287  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
287  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_006_002','2012-11-07 21:00:00',NULL);
288  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_001','2012-11-07 21:00:00',NULL);
289  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','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);
290    -- 10RED END
291    -- following to be checked
292    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_002','2013-02-05 21:00:00',NULL);
293    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_003','2013-02-05 21:00:00',NULL);
294    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_004','2013-02-05 21:00:00',NULL);
295    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_001','2013-02-05 21:00:00',NULL);
296    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_074_001','2013-02-05 21:00:00',NULL);
297    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39641_075_001','2013-02-05 21:00:00',NULL);
298    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_001','2013-08-01 21:00:00',NULL);
299    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39593_071_001','2013-08-01 21:00:00',NULL);
300    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_001','2013-08-01 21:00:00',NULL);
301    --
302    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40932_077_001','2013-08-01 21:00:00',NULL);
303    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_075_001','2013-08-01 21:00:00',NULL);
304    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_001','2013-08-01 21:00:00',NULL);
305    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40962_077_001','2013-08-01 21:00:00',NULL);
306    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40978_077_001','2013-08-01 21:00:00',NULL);
307    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40917_071_001','2013-10-29 21:00:00',NULL);
308    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_001','2013-10-29 21:00:00',NULL);
309    
310  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
311    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
# Line 726  insert into GL_PARAM values(0,"$PAM_CALI Line 765  insert into GL_PARAM values(0,"$PAM_CALI
765  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/","igrf10.dat",1104537601,1264400000,302,"igrf 2010 for interpolations",NULL);
766  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/","igrf10s.dat",1264400001,4294967295,302,"igrf 2015 estimated",NULL);
767  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/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL);
768    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);
769    
770  CREATE TABLE `GL_TLE` (  CREATE TABLE `GL_TLE` (
771    `ID` int(10) NOT NULL auto_increment,    `ID` int(10) NOT NULL auto_increment,
Legend:
Removed from v.1.44  
changed lines
  Added in v.1.46
  ViewVC Help
Powered by ViewVC 1.1.23