/[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.20 by pizzolot, Thu Dec 10 13:18:08 2009 UTC revision 1.22 by mocchiut, Thu Dec 24 10:31:16 2009 UTC
# Line 39  CREATE TABLE `GL_ROOT` ( Line 39  CREATE TABLE `GL_ROOT` (
39    
40  CREATE TABLE `GL_RESURS_OFFSET` (  CREATE TABLE `GL_RESURS_OFFSET` (
41    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
42    `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;',
43    `SPECIAL_FILE` varchar(255) NOT NULL default '',    `SPECIAL_FILE` varchar(255) NOT NULL default '',
44    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',
45    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
# Line 91  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 91  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
91  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_152_001_cln1.pam','2009-06-10 21:00:00',NULL);
92  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,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL);
93  INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL);
94    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001_cln1.pam','2009-09-09 21:00:00',NULL);
95    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001_cln1.pam','2009-09-09 21:00:00',NULL);
96    INSERT INTO GL_RESURS_OFFSET VALUES(0,'19525','','2009-12-08 21:00:00',NULL);
97    
98    
99    
# Line 766  CREATE TABLE `dbname`.`ROOT_TABLE` ( Line 769  CREATE TABLE `dbname`.`ROOT_TABLE` (
769    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
770    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
771    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
772      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
773      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
774   PRIMARY KEY  (`ID_N`)   PRIMARY KEY  (`ID_N`)
775  )  )
776  ;  ;
# Line 792  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` ( Line 797  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` (
797    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
798    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',    `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
799    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
800      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
801      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
802    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
803  )  )
804  ;  ;
# Line 853  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 860  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
860  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_152_001','2009-06-10 21:00:00',NULL);
861  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','18160_153_001','2009-06-10 21:00:00',NULL);
862    
863    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL);
864    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);
865    
866    
867    
868  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
Legend:
Removed from v.1.20  
changed lines
  Added in v.1.22
  ViewVC Help
Powered by ViewVC 1.1.23