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 |
|
|
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); |
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 ; |
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 |
) |
) |