--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/12/15 11:07:06 1.21 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2009/12/24 10:31:16 1.22 @@ -769,6 +769,8 @@ `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', `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', `INSERT_TIME` timestamp default CURRENT_TIMESTAMP, + `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', + `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)', PRIMARY KEY (`ID_N`) ) ; @@ -795,6 +797,8 @@ `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', `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', `INSERT_TIME` timestamp default CURRENT_TIMESTAMP, + `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', + `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)', PRIMARY KEY (`ID_N`) ) ;