/[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.45 by mocchiut, Mon Apr 22 08:08:09 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,
Legend:
Removed from v.1.45  
changed lines
  Added in v.1.46
  ViewVC Help
Powered by ViewVC 1.1.23