/[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.1 by mocchiut, Tue Sep 23 07:20:29 2008 UTC revision 1.3 by mocchiut, Thu Sep 25 12:13:49 2008 UTC
# Line 197  insert into GL_PARAM values(0,"$PAM_CALI Line 197  insert into GL_PARAM values(0,"$PAM_CALI
197  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);
198  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);
199  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);
200    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);
201    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);
202  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);
203  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);
204  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);
205  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);
206  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);
207    insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloBadMask18Xgood.dat",2,4294967295,103,"Calorimeter bad strip offline mask",NULL);
208  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);
209  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);
210  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);
211    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);
212    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);
213    insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_si0.dat",1,1167619688,108,"Calorimeter cross-talk silicon effect",NULL);
214    insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_crosstalk_param_si1.dat",1167619689,4294967295,108,"Calorimeter cross-talk silicon effect",NULL);
215    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);
216    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);
217    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);
218  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);
219  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);
220  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);
# Line 278  CREATE TABLE `GL_RUN` ( Line 288  CREATE TABLE `GL_RUN` (
288    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
289    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
290    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
291      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
292      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
293    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
294    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
295    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
# Line 331  CREATE TABLE `GL_RUN_FRAGMENTS` ( Line 343  CREATE TABLE `GL_RUN_FRAGMENTS` (
343    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
344    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
345    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
346      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
347      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
348    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
349    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
350    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
# Line 372  CREATE TABLE `GL_RUN_TRASH` ( Line 386  CREATE TABLE `GL_RUN_TRASH` (
386    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
387    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
388    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
389      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
390      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
391    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
392    `FILENAMEL0` varchar(255) NOT NULL default '',    `FILENAMEL0` varchar(255) NOT NULL default '',
393    `FILENAMEL2` varchar(255) NOT NULL default '',    `FILENAMEL2` varchar(255) NOT NULL default '',
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.23