/[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.4 by mocchiut, Thu Sep 25 15:30:09 2008 UTC revision 1.7 by mocchiut, Fri Nov 7 08:56:08 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 102  insert into GL_PARAM values(0,"$PAM_CALI Line 103  insert into GL_PARAM values(0,"$PAM_CALI
103  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/","mip_param-0/",0,0,2,"trk mip",NULL);
104  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/","charge_param-1/",0,0,3,"trk charge",NULL);
105  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/","eta_param-2/",0,0,4,"trk pfa",NULL);
106  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);
107  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-id0/",1,1152684877,6,"trk mask",NULL);
108  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-id1/",1152684877,1153111322,6,"trk mask",NULL);
109  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-id2/",1153111322,1153324544,6,"trk mask",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/trk-param/","mask_param-id2/",1153111322,1153324544,6,"trk mask",NULL);
# Line 542  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 543  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
543  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','08591_003_001','2007-10-08 21:00:00',NULL);
544  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_001','2007-10-08 21:00:00',NULL);
545  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','08592_004_003','2007-10-08 21:00:00',NULL);
546    
547  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_001','2008-03-20 21:00:00',NULL);
548    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
549  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_001','2008-03-20 21:00:00',NULL);
550    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
551  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_002','2008-03-20 21:00:00',NULL);
552    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL);
553    
554    
555  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
# Line 559  CREATE TABLE `dbname`.`ROOT_TABLE_MERGIN Line 564  CREATE TABLE `dbname`.`ROOT_TABLE_MERGIN
564    `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)',
565    `BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number',        `BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number',    
566    `BAD_PKT_PERCENTAGE` double  default '0' COMMENT 'The percentage of bad packets',    `BAD_PKT_PERCENTAGE` double  default '0' COMMENT 'The percentage of bad packets',
567      `GOOD` tinyint(1) unsigned NOT NULL default '1' COMMENT 'The entry must be used if and only if GOOD=1',
568      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
569    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
570    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
571  )  )

Legend:
Removed from v.1.4  
changed lines
  Added in v.1.7

  ViewVC Help
Powered by ViewVC 1.1.23