--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2008/09/25 12:13:49 1.3 +++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql 2008/11/04 15:01:13 1.6 @@ -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`) ); @@ -102,7 +103,7 @@ insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mip_param-0/",0,0,2,"trk mip",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","charge_param-1/",0,0,3,"trk charge",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","eta_param-2/",0,0,4,"trk pfa",NULL); -insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","align_param-FinalQ/",0,0,5,"trk alignment",NULL); +insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","align_param-080805-GL1from7/",0,0,5,"trk alignment",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-id0/",1,1152684877,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-id1/",1152684877,1153111322,6,"trk mask",NULL); insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-id2/",1153111322,1153324544,6,"trk mask",NULL); @@ -559,8 +560,10 @@ `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`) ) -; +;