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); |
198 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP-dws2000.dat",1,1,101,"Calorimeter ADC to MIP from flight data dw serie 2000",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP-dws2000.dat",1,1,101,"Calorimeter ADC to MIP from flight data dw serie 2000",NULL); |
199 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL); |
200 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL); |
201 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special0.dat",1,1172976488,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
202 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
203 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL); |
204 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL); |
205 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL); |
206 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightINCp.dat",2,4294967295,102,"Calorimeter alignement with flight data, protons, Z alignment changed",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightINCp.dat",2,4294967295,102,"Calorimeter alignement with flight data, protons, Z alignment changed",NULL); |
207 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask.dat",0,0,103,"Calorimeter bad strip offline mask",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask.dat",1,1,103,"Calorimeter bad strip offline mask",NULL); |
208 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask18Xgood.dat",2,4294967295,103,"Calorimeter bad strip offline mask",NULL); |
209 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloDefaultCalib.root",0,0,104,"Calorimeter default calibration",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloDefaultCalib.root",0,0,104,"Calorimeter default calibration",NULL); |
210 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadPulsePre0.dat",1,1169000000,105," <0701 Calorimeter bad pre-amplifiers when pulsing offline mask",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadPulsePre0.dat",1,1169000000,105," <0701 Calorimeter bad pre-amplifiers when pulsing offline mask",NULL); |
211 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadPulsePre1.dat",1169000001,4294967295,105," >0701 Calorimeter bad pre-amplifiers when pulsing offline mask",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadPulsePre1.dat",1169000001,4294967295,105," >0701 Calorimeter bad pre-amplifiers when pulsing offline mask",NULL); |
212 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_pre_neighbour.dat",1,4294967295,106," Calorimeter pre-amply neighbour correction table",NULL); |
213 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_pre_IIneighbour.dat",1,4294967295,107," Calorimeter pre-amply second neighbour correction table",NULL); |
214 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_si0.dat",1,1167619688,108,"Calorimeter cross-talk silicon effect",NULL); |
215 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_si1.dat",1167619689,4294967295,108,"Calorimeter cross-talk silicon effect",NULL); |
216 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_maxrms_plane0.dat",1,4294967295,109,"Calorimeter 4*rms threshold for each plane (default 26)",NULL); |
217 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_emin_strip0.dat",1,1167619688,111,"Calorimeter Emin threshold for each strip (default 0.7)",NULL); |
218 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_emin_strip1.dat",1167619689,4294967295,111,"Calorimeter Emin threshold for each strip (default 0.7)",NULL); |
219 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_1.rz",1,1153660000,201," 0 - 07-23 - A A standard",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_1.rz",1,1153660000,201," 0 - 07-23 - A A standard",NULL); |
220 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31 HV_D problems B B july Parameters_jul24-31.txt",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31 HV_D problems B B july Parameters_jul24-31.txt",NULL); |
221 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17 - C C standard",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17 - C C standard",NULL); |
246 |
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_28.rz",1196280001,1206100000,201," 11-29 - 03-21 28 28 standard",NULL); |
247 |
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/","tofcalib_29.rz",1206100001,4294967295,201," > 03-21 HV_C problems 29 29 standard",NULL); |
248 |
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/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL); |
249 |
|
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); |
250 |
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/","igrf05.dat",0,0,301,"igrf 2005",NULL); |
251 |
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL); |
252 |
|
|
544 |
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); |
545 |
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); |
546 |
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); |
547 |
|
|
548 |
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); |
549 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL); |
550 |
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); |
551 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL); |
552 |
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); |
553 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL); |
554 |
|
|
555 |
|
|
556 |
drop table if exists dbname.ROOT_TABLE_MERGING ; |
drop table if exists dbname.ROOT_TABLE_MERGING ; |
565 |
`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)', |
566 |
`BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number', |
`BOOT_NUMBER` int unsigned default '0' COMMENT 'The Boot Number', |
567 |
`BAD_PKT_PERCENTAGE` double default '0' COMMENT 'The percentage of bad packets', |
`BAD_PKT_PERCENTAGE` double default '0' COMMENT 'The percentage of bad packets', |
568 |
|
`GOOD` tinyint(1) unsigned NOT NULL default '1' COMMENT 'The entry must be used if and only if GOOD=1', |
569 |
|
`INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', |
570 |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
571 |
PRIMARY KEY (`ID_N`) |
PRIMARY KEY (`ID_N`) |
572 |
) |
) |
573 |
; |
; |
574 |
|
|