/[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.3 by mocchiut, Thu Sep 25 12:13:49 2008 UTC revision 1.5 by mocchiut, Tue Nov 4 09:44:39 2008 UTC
# Line 8  SET time_zone='+0:00'; Line 8  SET time_zone='+0:00';
8    
9  CREATE TABLE `_RUNID_GEN` (  CREATE TABLE `_RUNID_GEN` (
10    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
11      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
12    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
13  );  );
14    
# Line 559  CREATE TABLE `dbname`.`ROOT_TABLE_MERGIN Line 560  CREATE TABLE `dbname`.`ROOT_TABLE_MERGIN
560    `REAL_TIME_LAST` int unsigned NOT NULL  default '0' COMMENT 'The Absolute real time when I want to stop using this ROOT file (s)',    `REAL_TIME_LAST` int unsigned NOT NULL  default '0' COMMENT 'The Absolute real time when I want to stop using this ROOT file (s)',
561    `BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number',        `BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number',    
562    `BAD_PKT_PERCENTAGE` double  default '0' COMMENT 'The percentage of bad packets',    `BAD_PKT_PERCENTAGE` double  default '0' COMMENT 'The percentage of bad packets',
563      `GOOD` tinyint(1) unsigned NOT NULL default '1' COMMENT 'The entry must be used if and only if GOOD=1',
564      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
565    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
566    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
567  )  )
568  ;  ;
569    
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.5
  ViewVC Help
Powered by ViewVC 1.1.23