--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/12/10 13:18:08 1.20 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/12/15 11:07:06 1.21 @@ -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', + `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;', `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, @@ -91,6 +91,9 @@ INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001_cln1.pam','2009-06-10 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL); INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001_cln1.pam','2009-09-09 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001_cln1.pam','2009-09-09 21:00:00',NULL); +INSERT INTO GL_RESURS_OFFSET VALUES(0,'19525','','2009-12-08 21:00:00',NULL); @@ -853,6 +856,9 @@ 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); + drop table if exists dbname.ROOT_TABLE_MERGING ;