/[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.10 by pam-fi, Thu Dec 4 15:27:33 2008 UTC revision 1.12 by mocchiut, Thu Dec 18 14:47:08 2008 UTC
# Line 69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002_cln1.pam','2008-03-20 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002_cln1.pam','2008-03-20 21:00:00',NULL);
70  INSERT INTO GL_RESURS_OFFSET VALUES(0,'11300','','2008-06-19 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'11300','','2008-06-19 21:00:00',NULL);
71  INSERT INTO GL_RESURS_OFFSET VALUES(0,'12634','','2008-09-18 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'12634','','2008-09-18 21:00:00',NULL);
72    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001_cln1.pam','2008-12-15 21:00:00',NULL);
73    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001_cln1.pam','2008-12-15 21:00:00',NULL);
74    INSERT INTO GL_RESURS_OFFSET VALUES(0,'14044','','2008-12-15 21:00:00',NULL);
75    
76    
77  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
# Line 703  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 728  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  )  )
Legend:
Removed from v.1.10  
changed lines
  Added in v.1.12
  ViewVC Help
Powered by ViewVC 1.1.23