/[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.54 by mocchiut, Wed Aug 27 09:13:30 2014 UTC revision 1.55 by mocchiut, Fri Aug 29 10:00:08 2014 UTC
# Line 50  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 50  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
50  INSERT INTO GL_RESURS_OFFSET VALUES(0,'1619','','2006-09-28 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'1619','','2006-09-28 21:00:00',NULL);
51  INSERT INTO GL_RESURS_OFFSET VALUES(0,'2797','','2006-12-12 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'2797','','2006-12-12 21:00:00',NULL);
52  INSERT INTO GL_RESURS_OFFSET VALUES(0,'3221','','2007-01-08 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);  
53  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,'0','04586_003_001_cln1.pam','2007-01-08 21:00:00',NULL);
54  INSERT INTO GL_RESURS_OFFSET VALUES(0,'4576','','2007-04-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'4576','','2007-04-08 21:00:00',NULL);
55  INSERT INTO GL_RESURS_OFFSET VALUES(0,'5960','','2007-07-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'5960','','2007-07-08 21:00:00',NULL);
# Line 137  INSERT INTO GL_RESURS_OFFSET VALUES(0,'3 Line 134  INSERT INTO GL_RESURS_OFFSET VALUES(0,'3
134  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);
135  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);
136  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);
137  -- 10RED END  -- WARNING! STARTING FROM HERE RAWREADER SPECIAL FILES DISCONTINUED (NOT UPDATED ANYMORE)
 -- 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);  
138  INSERT INTO GL_RESURS_OFFSET VALUES(0,'39594','','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,'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);  
139  INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'40931','','2013-10-29 21:00:00',NULL);
140  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,'42260','','2014-01-27 21:00:00',NULL);
141  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,'43610','','2014-04-27 21:00:00',NULL);
142    -- to be checked with vitaly (NB: special files!!!)
143    INSERT INTO GL_RESURS_OFFSET VALUES(0,'44980','','2014-07-26 21:00:00',NULL);
144    --
145    -- 10RED END
146    
147  -- CHEWBACCA SPECIAL FILES  -- CHEWBACCA SPECIAL FILES
148  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);
# Line 287  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 271  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
271  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);
272  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);
273  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);
274  -- 10RED END  --
 -- following to be checked  
275  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_002','2013-02-05 21:00:00',NULL);
276  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_003','2013-02-05 21:00:00',NULL);
277  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_072_004','2013-02-05 21:00:00',NULL);
278    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_072_005','2013-02-05 21:00:00',NULL);
279  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_073_001','2013-02-05 21:00:00',NULL);
280    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39611_073_002','2013-02-05 21:00:00',NULL);
281  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','39611_074_001','2013-02-05 21:00:00',NULL);
282  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','39611_074_002','2013-02-05 21:00:00',NULL);
283  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_001','2013-08-01 21:00:00',NULL);
284    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_051_002','2013-08-01 21:00:00',NULL);
285  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','39593_071_001','2013-08-01 21:00:00',NULL);
286  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','39592_072_001','2013-08-01 21:00:00',NULL);
287    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_006','2013-08-01 21:00:00',NULL);
288    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_007','2013-08-01 21:00:00',NULL);
289    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_008','2013-08-01 21:00:00',NULL);
290    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_009','2013-08-01 21:00:00',NULL);
291    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','39592_072_010','2013-08-01 21:00:00',NULL);
292  --  --
293  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','40932_077_001','2013-08-01 21:00:00',NULL);
294  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);
295  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_001','2013-08-01 21:00:00',NULL);
296    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40947_078_002','2013-08-01 21:00:00',NULL);
297  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','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);  
298  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','40917_071_001','2013-10-29 21:00:00',NULL);
299  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_001','2013-10-29 21:00:00',NULL);
300    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','40930_071_002','2013-10-29 21:00:00',NULL);
301    --
302    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42268_002_001','2013-10-29 21:00:00',NULL);
303    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42268_002_002','2013-10-29 21:00:00',NULL);
304    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42281_076_002','2013-10-29 21:00:00',NULL);
305    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42281_076_003','2013-10-29 21:00:00',NULL);
306    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_071_002','2013-10-29 21:00:00',NULL);
307    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_071_003','2013-10-29 21:00:00',NULL);
308    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_072_001','2013-10-29 21:00:00',NULL);
309    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42283_072_002','2013-10-29 21:00:00',NULL);
310    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','42295_005_001','2013-10-29 21:00:00',NULL);
311    --
312    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_001','2014-01-27 21:00:00',NULL);
313    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','43623_003_002','2014-01-27 21:00:00',NULL);
314    --
315    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_001','2014-04-27 21:00:00',NULL);
316    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_003_002','2014-04-27 21:00:00',NULL);
317    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_072_001','2014-04-27 21:00:00',NULL);
318    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44983_072_002','2014-04-27 21:00:00',NULL);
319    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44984_078_001','2014-04-27 21:00:00',NULL);
320    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44984_078_002','2014-04-27 21:00:00',NULL);
321    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_007_001','2014-04-27 21:00:00',NULL);
322    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_007_002','2014-04-27 21:00:00',NULL);
323    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_076_001','2014-04-27 21:00:00',NULL);
324    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44999_076_002','2014-04-27 21:00:00',NULL);
325    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44974_001_001','2014-07-26 21:00:00',NULL);
326    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','44974_001_002','2014-07-26 21:00:00',NULL);
327    --
328    -- 10RED END
329    
330    
331  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
332    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
Legend:
Removed from v.1.54  
changed lines
  Added in v.1.55
  ViewVC Help
Powered by ViewVC 1.1.23