--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2008/09/25 15:30:09 1.4 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2008/11/04 09:44:39 1.5 @@ -8,6 +8,7 @@ CREATE TABLE `_RUNID_GEN` ( `ID` int(10) unsigned NOT NULL auto_increment, + `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', PRIMARY KEY (`ID`) ); @@ -559,6 +560,8 @@ `REAL_TIME_LAST` int unsigned NOT NULL default '0' COMMENT 'The Absolute real time when I want to stop using this ROOT file (s)', `BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number', `BAD_PKT_PERCENTAGE` double default '0' COMMENT 'The percentage of bad packets', + `GOOD` tinyint(1) unsigned NOT NULL default '1' COMMENT 'The entry must be used if and only if GOOD=1', + `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', `INSERT_TIME` timestamp default CURRENT_TIMESTAMP, PRIMARY KEY (`ID_N`) )