/[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.11 by mocchiut, Thu Dec 18 12:58:38 2008 UTC revision 1.13 by mocchiut, Mon Dec 22 10:38:14 2008 UTC
# Line 706  CREATE TABLE `dbname`.`ROOT_TABLE` ( Line 706  CREATE TABLE `dbname`.`ROOT_TABLE` (
706    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',
707    `NUM_PKT_SAVED` int  default '0' COMMENT 'The total number of packet saved in the ROOT file',    `NUM_PKT_SAVED` int  default '0' COMMENT 'The total number of packet saved in the ROOT file',
708    `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',  
709      `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',
710    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
711   PRIMARY KEY  (`ID_N`)   PRIMARY KEY  (`ID_N`)
712  )  )
# Line 731  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` ( Line 732  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` (
732    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',
733    `NUM_PKT_SAVED` int  default '0' COMMENT 'The number of packet saved in the ROOT file',    `NUM_PKT_SAVED` int  default '0' COMMENT 'The number of packet saved in the ROOT file',
734    `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',  
735      `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',
736    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
737    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
738  )  )
739  ;  ;
740    
741    
742  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);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);  
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','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);  
743  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);
744  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);
745    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);
746    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);
747  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_002_002','2007-01-08 21:00:00',NULL);
748  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_001','2007-07-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL);
749  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_002','2007-07-08 21:00:00',NULL);  
750    
751  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_002_001','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_003','2007-10-08 21:00:00',NULL);  
752  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_002','2007-10-08 21:00:00',NULL);
753  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','08591_003_001','2007-10-08 21:00:00',NULL);
754  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','08592_004_001','2007-10-08 21:00:00',NULL);
755  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','08592_004_002','2007-10-08 21:00:00',NULL);
756  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_005','2007-10-08 21:00:00',NULL);
757  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);  
758    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11309_001_002','2008-03-20 21:00:00',NULL);
759  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_002','2008-03-20 21:00:00',NULL);
760  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_001_003','2008-03-20 21:00:00',NULL);
761    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);
762    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
763    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);
764    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
765    
766    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12874_002_001','2008-06-19 21:00:00',NULL);
767    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_003_001','2008-06-19 21:00:00',NULL);
768    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_003','2008-06-19 21:00:00',NULL);
769    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_004','2008-06-19 21:00:00',NULL);
770    
771    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL);
772    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_002','2008-12-15 21:00:00',NULL);
773    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_003','2008-09-18 21:00:00',NULL);
774    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_004','2008-09-18 21:00:00',NULL);
775    
776    
777    
778  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
Legend:
Removed from v.1.11  
changed lines
  Added in v.1.13
  ViewVC Help
Powered by ViewVC 1.1.23