--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/12/24 10:31:16 1.22 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2010/01/15 14:02:31 1.24 @@ -39,7 +39,7 @@ CREATE TABLE `GL_RESURS_OFFSET` ( `ID` int(10) unsigned NOT NULL auto_increment, - `FROM_ORBIT` int(10) unsigned NOT NULL default '0' COMMENT 'SELECT YEAR(OFFSET_DATE),MONTH(OFFSET_DATE),DAY(OFFSET_DATE),HOUR(OFFSET_DATE),MINUTE(OFFSET_DATE),SECOND(OFFSET_DATE),ID FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< " << dworbit << " AND SPECIAL_FILE="" order by FROM_ORBIT desc limit 1;', + `FROM_ORBIT` int(10) unsigned NOT NULL default '0' COMMENT 'if dwlimit = dworbit the file takes the OLD resurs 0 -- SELECT YEAR(OFFSET_DATE),MONTH(OFFSET_DATE),DAY(OFFSET_DATE),HOUR(OFFSET_DATE),MINUTE(OFFSET_DATE),SECOND(OFFSET_DATE),ID FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< " << dworbit << " AND SPECIAL_FILE="" order by FROM_ORBIT desc limit 1;', `SPECIAL_FILE` varchar(255) NOT NULL default '', `OFFSET_DATE` timestamp default '0000-00-00 00:00:00', `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP, @@ -812,15 +812,12 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL); - INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_001','2007-10-08 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_005','2007-10-08 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11309_001_002','2008-03-20 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL); @@ -828,19 +825,27 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12874_002_001','2008-06-19 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_003_001','2008-06-19 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_003','2008-06-19 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_004','2008-06-19 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL) +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL); + +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL); +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','14034_001_001','2008-12-15 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_002','2008-12-15 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_003','2008-09-18 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_004','2008-09-18 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL); @@ -850,18 +855,8 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001','2009-06-10 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL); -INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL); +