/[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.10 by pam-fi, Thu Dec 4 15:27:33 2008 UTC revision 1.28 by mocchiut, Fri Jan 29 17:15:59 2010 UTC
# Line 39  CREATE TABLE `GL_ROOT` ( Line 39  CREATE TABLE `GL_ROOT` (
39    
40  CREATE TABLE `GL_RESURS_OFFSET` (  CREATE TABLE `GL_RESURS_OFFSET` (
41    `ID` int(10) unsigned NOT NULL auto_increment,    `ID` int(10) unsigned NOT NULL auto_increment,
42    `FROM_ORBIT` int(10) unsigned NOT NULL default '0',    `FROM_ORBIT` int(10) unsigned NOT NULL default '0' COMMENT 'if dwlimit = dworbit the file takes the OLD resurs 0 -- SELECT YEAR(OFFSET_DATE),MONTH(OFFSET_DATE),DAY(OFFSET_DATE),HOUR(OFFSET_DATE),MINUTE(OFFSET_DATE),SECOND(OFFSET_DATE),ID FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< "  << dworbit << " AND SPECIAL_FILE="" order by FROM_ORBIT desc limit 1;',
43    `SPECIAL_FILE` varchar(255) NOT NULL default '',    `SPECIAL_FILE` varchar(255) NOT NULL default '',
44    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',    `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',
45    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
# Line 69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0 Line 69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0
69  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002_cln1.pam','2008-03-20 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002_cln1.pam','2008-03-20 21:00:00',NULL);
70  INSERT INTO GL_RESURS_OFFSET VALUES(0,'11300','','2008-06-19 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'11300','','2008-06-19 21:00:00',NULL);
71  INSERT INTO GL_RESURS_OFFSET VALUES(0,'12634','','2008-09-18 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'12634','','2008-09-18 21:00:00',NULL);
72    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001_cln1.pam','2008-12-15 21:00:00',NULL);
73    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001_cln1.pam','2008-12-15 21:00:00',NULL);
74    INSERT INTO GL_RESURS_OFFSET VALUES(0,'14044','','2008-12-15 21:00:00',NULL);
75    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
76    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001_cln1.pam','2008-12-15 21:00:00',NULL);
77    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
78    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001_cln1.pam','2008-12-15 21:00:00',NULL);
79    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001_cln1.pam','2008-12-15 21:00:00',NULL);
80    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001_cln1.pam','2008-12-15 21:00:00',NULL);
81    INSERT INTO GL_RESURS_OFFSET VALUES(0,'15430','','2009-03-16 21:00:00',NULL);
82    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001_cln1.pam','2009-03-16 21:00:00',NULL);
83    INSERT INTO GL_RESURS_OFFSET VALUES(0,'16740','','2009-06-10 21:00:00',NULL);
84    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001_cln1.pam','2009-06-10 21:00:00',NULL);
85    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001_cln1.pam','2009-06-10 21:00:00',NULL);
86    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001_cln1.pam','2009-06-10 21:00:00',NULL);
87    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001_cln1.pam','2009-06-10 21:00:00',NULL);
88    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001_cln1.pam','2009-06-10 21:00:00',NULL);
89    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001_cln1.pam','2009-06-10 21:00:00',NULL);
90    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001_cln1.pam','2009-06-10 21:00:00',NULL);
91    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001_cln1.pam','2009-06-10 21:00:00',NULL);
92    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL);
93    INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL);
94    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001_cln1.pam','2009-09-09 21:00:00',NULL);
95    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001_cln1.pam','2009-09-09 21:00:00',NULL);
96    INSERT INTO GL_RESURS_OFFSET VALUES(0,'19525','','2009-12-08 21:00:00',NULL);
97    
98    
99    
100    
101  CREATE TABLE `GL_TIMESYNC` (  CREATE TABLE `GL_TIMESYNC` (
# Line 397  insert into GL_PARAM values(0,"$PAM_CALI Line 424  insert into GL_PARAM values(0,"$PAM_CALI
424  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);
425  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);
426  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);  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);
427  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);  insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,1190000000,110,"Calorimeter ADC to MIP from flight, special cases",NULL);
428    insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special2.dat",1190000000,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL);
429  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);
430  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);
431  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);
# Line 442  insert into GL_PARAM values(0,"$PAM_CALI Line 470  insert into GL_PARAM values(0,"$PAM_CALI
470  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_26.rz",1195200001,1196230000,201," 11-16 - 11-28   Timing changes         26      26      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_26.rz",1195200001,1196230000,201," 11-16 - 11-28   Timing changes         26      26      standard",NULL);
471  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_27.rz",1196230001,1196280000,201," 11-28 - 11-28   HV_D problems          27      27      standard",NULL);  insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_27.rz",1196230001,1196280000,201," 11-28 - 11-28   HV_D problems          27      27      standard",NULL);
472  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);
473  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,1206375600,201," 03-21 - 03-24   HV_C problems          29      29 ",NULL);
474    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_30.rz",1206375601,1217989200,201," 03-24 - 08-06   good                    30      30      calper_30 ",NULL);
475    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_31.rz",1217989201,1218550000,201," 08-06 - 08-12   HV_E problems ?         31      31      calper_31",NULL);
476    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_32.rz",1218550001,1225789200,201," 08-12 - 11-04   good                    32      32      calper_32",NULL);
477    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_33.rz",1225789201,1226566800,201," 11-04 - 11-13   HV_E problems ?         33      33      calper_33 ",NULL);
478    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_34.rz",1226566801,1229400000,201," 11-13 - 12-16   good                    34      34      calper_34",NULL);
479    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_35.rz",1229400001,1229470000,201," 12-16 - 12-17   HV_F probl. + HV_E (?)  35      35      calper_35",NULL);
480    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_36.rz",1229470001,1229730000,201," 12-17 - 12-19   HV_E problems (?)       36      36      calper_36",NULL);
481    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_37.rz",1229730001,1230318000,201," 12-19 - 12-26   good                    37      37      calper_37",NULL);
482    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_38.rz",1230318001,1230410000,201," 12-26 - 12-27   HV_H problems           38      38      calper_38",NULL);
483    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_39.rz",1230410001,4294967295,201," > 12-27         good                    39      39      calper_39",NULL);
484  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);
485  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/tof-param/","adcmonitor.100k.cut.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);
486    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.C.5d.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL);
487    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.8th.all.dat",1,4294967295,203," ToF dE/dx II order correction parameters based on He",NULL);
488    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,4294967295,204," ToF attenuation parameter file ",NULL);
489    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL);
490    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch.txt",1,4294967295,206," ToF BetheBloch parameter file ",NULL);
491    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch_betagt1.txt",1,4294967295,207," ToF Bethe-Bloch parameter file for beta gt1 ",NULL);
492    insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_beta.txt",1,4294967295,208," ToF desaturation on beta parameter file ",NULL);
493    insert into GL_PARAM values(0,"","",1182100001,1183030000,210," A connector ",NULL);
494    insert into GL_PARAM values(0,"","",1174665001,1175000000,211," B connector ",NULL);
495    insert into GL_PARAM values(0,"","",1206100001,1206375600,212," C connector ",NULL);
496    insert into GL_PARAM values(0,"","",1153660001,1154375000,213," D connector ",NULL);
497    insert into GL_PARAM values(0,"","",1168490001,1168940000,213," D connector ",NULL);
498    insert into GL_PARAM values(0,"","",1185090001,1185212000,213," D connector ",NULL);
499    insert into GL_PARAM values(0,"","",1191100001,1191940000,213," D connector ",NULL);
500    insert into GL_PARAM values(0,"","",1176800001,1178330000,214," E connector ",NULL);
501    insert into GL_PARAM values(0,"","",1217989201,1218547800,214," E connector ",NULL);
502    insert into GL_PARAM values(0,"","",1225789201,1226566800,214," E connector ",NULL);
503    insert into GL_PARAM values(0,"","",1229400901,1229700000,214," E connector ",NULL);
504    insert into GL_PARAM values(0,"","",1230318001,1230415200,214," E connector ",NULL);
505    insert into GL_PARAM values(0,"","",1168940001,1169580000,215," F connector ",NULL);
506    insert into GL_PARAM values(0,"","",1155850001,1156280000,217," H connector ",NULL);
507    insert into GL_PARAM values(0,"","",1176120001,1176800000,217," H connector ",NULL);
508    insert into GL_PARAM values(0,"","",1178330001,1181322000,217," H connector ",NULL);
509    insert into GL_PARAM values(0,"","",1184000001,1184570000,217," H connector ",NULL);
510    insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL);
511    insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL);
512    insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL);
513  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);
514  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);
515    
# Line 703  CREATE TABLE `dbname`.`ROOT_TABLE` ( Line 768  CREATE TABLE `dbname`.`ROOT_TABLE` (
768    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',
769    `NUM_PKT_SAVED` int  default '0' COMMENT 'The total number of packet saved in the ROOT file',    `NUM_PKT_SAVED` int  default '0' COMMENT 'The total number of packet saved in the ROOT file',
770    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
771      `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
772    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
773      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
774      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
775   PRIMARY KEY  (`ID_N`)   PRIMARY KEY  (`ID_N`)
776  )  )
777  ;  ;
# Line 728  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` ( Line 796  CREATE TABLE `dbname`.`ROOT_TABLE_BAD` (
796    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',    `BAD_PKT_CALREAD` int  default '0' COMMENT 'The number of Calibration packet that could have problems.',
797    `NUM_PKT_SAVED` int  default '0' COMMENT 'The number of packet saved in the ROOT file',    `NUM_PKT_SAVED` int  default '0' COMMENT 'The number of packet saved in the ROOT file',
798    `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',      `INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file',  
799      `TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download',
800    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp default CURRENT_TIMESTAMP,
801      `INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file',
802      `ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)',
803    PRIMARY KEY  (`ID_N`)    PRIMARY KEY  (`ID_N`)
804  )  )
805  ;  ;
806    
807    
808  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL);  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL);
 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);  
809  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_002_002','2007-01-08 21:00:00',NULL);
810  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','04584_003_002','2007-01-08 21:00:00',NULL);
811    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL);
812    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL);
813  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','04586_002_002','2007-01-08 21:00:00',NULL);
814  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','04586_003_001','2007-01-08 21:00:00',NULL);
815  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','07408_003_002','2007-07-08 21:00:00',NULL);  
816  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_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);  
817  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','08591_003_002','2007-10-08 21:00:00',NULL);
818  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','08591_003_001','2007-10-08 21:00:00',NULL);
819  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','08592_004_002','2007-10-08 21:00:00',NULL);
820  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','08592_004_003','2007-10-08 21:00:00',NULL);
821  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);  
822  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);
823  INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','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);
824    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL);
825    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL);
826    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL);
827    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL);
828    
829    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL);
830    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL);
831    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL);
832    
833    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL);
834    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_002','2008-12-15 21:00:00',NULL);
835    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL);
836    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL);
837    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL);
838    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_002','2008-12-15 21:00:00',NULL);
839    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL);
840    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_002','2008-12-15 21:00:00',NULL);
841    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL);
842    
843    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL);
844    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_002','2009-03-16 21:00:00',NULL);
845    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_003','2009-03-16 21:00:00',NULL);
846    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_004','2009-03-16 21:00:00',NULL);
847    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_005','2009-03-16 21:00:00',NULL);
848    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_006','2009-03-16 21:00:00',NULL);
849    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_007','2009-03-16 21:00:00',NULL);
850    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_008','2009-03-16 21:00:00',NULL);
851    
852    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL);
853    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL);
854    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL);
855    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL);
856    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL);
857    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL);
858    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL);
859    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL);
860    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL);
861    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL);
862    
863    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL);
864    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL);
865    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL);
866    INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL);
867    
868  drop table if exists dbname.ROOT_TABLE_MERGING ;  drop table if exists dbname.ROOT_TABLE_MERGING ;
869  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (  CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` (
Legend:
Removed from v.1.10  
changed lines
  Added in v.1.28
  ViewVC Help
Powered by ViewVC 1.1.23