--- chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql	2008/09/25 12:13:49	1.3
+++ chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql	2008/12/03 19:57:49	1.9
@@ -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);
@@ -245,6 +246,7 @@
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_28.rz",1196280001,1206100000,201," 11-29 - 03-21                          28      28      standard",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_29.rz",1206100001,4294967295,201," > 03-21         HV_C problems          29      29      standard",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL);
+insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.7th.100k.cut.dat",1,4294967295,203," ToF dE/dx II order correction parameters ",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",0,0,301,"igrf 2005",NULL);
 insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL);
 
@@ -537,14 +539,23 @@
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_001','2007-07-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_002','2007-07-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_001','2007-10-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL);
 
 
 drop table if exists dbname.ROOT_TABLE_MERGING ;
@@ -559,8 +570,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`)
 ) 
-;
+;