/[PAMELA software]/chewbacca/YodaProfiler/docs/oldsql.sql
ViewVC logotype

Contents of /chewbacca/YodaProfiler/docs/oldsql.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (show annotations) (download)
Tue Sep 23 07:20:32 2008 UTC (16 years, 2 months ago) by mocchiut
Branch: MAIN
Branch point for: v0r00
Initial revision

1 #insert into ROOT_TABLE values(" 1 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","159"," 2008-06-05 14:39:54");
2 #insert into ROOT_TABLE values(" 6 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","159"," 2008-06-05 14:39:54");
3 #insert into ROOT_TABLE values(" 5 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","164"," 2008-06-05 14:39:54");
4 #insert into ROOT_TABLE values(" 4 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","159"," 2008-06-05 14:39:54");
5 #insert into ROOT_TABLE values(" 3 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","159"," 2008-06-05 14:39:54");
6 #insert into ROOT_TABLE values(" 2 ","/gpfs/wizard/flight/src/nergal/","yoda_10747_001_002_1.root"," 5874020 "," 5980117 "," 1024336235 "," 1029028365 "," 1024160 "," 4853977 "," 1196731353 "," 1196736045 "," 1191877200 "," 0 "," 29 "," 0 "," 106098 "," /gpfs/wizard/flight/src/nergal/10747001.pam ","1"," 2008-06-05 14:39:54");
7 #insert into ROOT_TABLE_MERGING values("665","1","5874020","5980117","1024336235","1029028365","1","100","23",0);
8
9 #insert into ROOT_TABLE_MERGING values("877","1","5874020","5874735","1024336031","1024366461","1","100","23",0);
10 #insert into ROOT_TABLE_MERGING values("874","1","5874024","5874032","1024336531","1024336731","1","100","23",0);
11 #insert into ROOT_TABLE_MERGING values("876","1","5874025","5874032","1024336531","1024336731","1","100","23",0);
12 #insert into ROOT_TABLE_MERGING values("873","1","5874020","5874021","1024336031","1024336731","1","100","23",0);
13 #insert into ROOT_TABLE_MERGING values("875","1","5874020","5874032","1024336031","1024336731","1","100","23",0);
14 #insert into ROOT_TABLE_MERGING values("878","1","5874023","5874032","1024336531","1024336731","1","100","23",0);
15 #insert into ROOT_TABLE_MERGING values("879","1","5874023","5874120","1024336531","1024336731","1","100","23",0);
16
17 #insert into ROOT_TABLE_MERGING values("880","1","5874020","5874120","1024336031","1024336731","1","100","23",0);
18 #insert into ROOT_TABLE_MERGING values("881","1","5874121","5874220","1024336732","1024336831","1","100","23",0);
19 #insert into ROOT_TABLE_MERGING values("882","1","5874221","5874420","1024336832","1024336931","1","100","23",0);
20 #insert into ROOT_TABLE_MERGING values("883","1","5874421","5874620","1024336932","1024337031","1","100","23",0);
21 #insert into ROOT_TABLE_MERGING values("884","1","5874621","5874720","1024337032","1024357461","1","100","23",0);
22
23
24 #insert into ROOT_TABLE_MERGING values("666","1","5874020","5980117","1020944556","1029328365","1","100","23",0);
25
26 #insert into ROOT_TABLE_MERGING values("111","2","5874020","5980117","1028944556","1029028365","1","100","23",0);
27 #insert into ROOT_TABLE_MERGING values("66","1","5874020","5875020","1028944556","1029028365","1","100","23",0);
28 #insert into ROOT_TABLE_MERGING values("6","1","5874020","5980017","1028944556","1029028365","1","100","23",0);
29 #insert into ROOT_TABLE_MERGING values("999","1","5874120","5980117","1028944556","1029028365","1","100","23",0);
30
31
32
33
34 ##INSERT INTO `GL_RUN_FRAGMENTS` VALUES (1,0,1,0,1196731353,1196731356,1024336475,1024339199,5874021,5874120,159,0,97,98,0,0,1116314777,3,3,18,21,67108863,9087,0,1,1,15,4853977,1024160,0,'2008-06-10 08:54:25'),(2,0,1,0,1196731356,1196731359,1024339210,1024342043,5874121,5874220,159,98,197,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2008-06-10 08:54:31'),(3,0,1,0,1196731359,1196731364,1024342060,1024347724,5874221,5874420,159,198,397,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2008-06-10 08:54:35'),(4,0,1,0,1196731364,1196731370,1024347740,1024353786,5874421,5874620,159,398,597,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2008-06-10 08:54:40'),(5,0,1,0,1196731370,1196731373,1024353831,1024356507,5874621,5874720,159,598,695,98,696,22620116,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2008-06-10 08:54:45');
35
36 INSERT INTO `ROOT_TABLE_MERGING` VALUES
37 (1,1,13660585,13672612,2919605170,2920252694,1194872039,1194
38 872686,3,'2008-06-10
39 14:31:11'),(2,2,13680254,13680255,2920697396,2920697396,1194873131,1194873131,0
40 ,'2008-06-10
41 14:31:58'),(3,3,13690599,13690600,2921452284,2921452284,1194873886,1194873886,1,'2008-0
42 6-10
43 14:32:49'),(4,4,13700263,13956849,2922220129,2933443235,1194874654,1194885877,60,'2008-06-10 14
44 :50:56'),(5,5,13634467,13650677,2917976006,2919108107,1194870410,1194871542,3,'2008-06-10
45 14:54:22')
46 ,(6,5,13650616,13650677,2919104954,2147483647,1194871538,1194871542,3,'2008-06-10
47 14:54:59'),(7,6,13
48 650616,13650616,2919104954,2919104954,1194871538,1194871538,0,'2008-06-10 14:54:59');
49
50 INSERT INTO `ROOT_TABLE` VALUES
51 (1,'/gpfs/wizard/flight/src/nergal/','yoda_07909_005_002_0.root',136
52 60585,13672612,2919605170,2920252694,2910943,2986177,1194872039,1194872686,1191877200,0,3,0,9929,'/g
53 pfs/wizard/flight/production/preRawreader/07909005.pam',0,'2008-06-10
54 14:31:11'),(2,'/gpfs/wizard/fl
55 ight/src/nergal/','yoda_07909_005_002_1.root',13680254,13680255,2920697396,2920697396,2910943,298617
56 7,1194873131,1194873131,1191877200,0,0,0,2,'/gpfs/wizard/flight/production/preRawreader/07909005.pam
57 ',0,'2008-06-10
58 14:31:58'),(3,'/gpfs/wizard/flight/src/nergal/','yoda_07909_005_002_2.root',13690599
59 ,13690600,2921452284,2921452284,2910943,2986177,1194873886,1194873886,1191877200,0,1,0,2,'/gpfs/wiza
60 rd/flight/production/preRawreader/07909005.pam',0,'2008-06-10
61 14:32:49'),(4,'/gpfs/wizard/flight/src
62 /nergal/','yoda_07909_005_002_3.root',13700263,13956849,2922220129,2933443235,2910943,2986177,119487
63 4654,1194885877,1191877200,0,60,0,256586,'/gpfs/wizard/flight/production/preRawreader/07909005.pam',
64 0,'2008-06-10
65 14:50:56'),(5,'/gpfs/wizard/flight/src/nergal/','yoda_07909_005_002_4.root',13634467,1
66 3650677,2917976006,2919108107,2910943,2986177,1194870410,1194871542,1191877200,0,3,0,16211,'/gpfs/wi
67 zard/flight/production/preRawreader/07909005.pam',0,'2008-06-10
68 14:54:22'),(6,'/gpfs/wizard/flight/s
69 rc/nergal/','yoda_07909_005_002_5.root',13650616,13650616,2919104954,2919104954,2910943,2986177,1194
70 871538,1194871538,1191877200,0,0,0,1,'/gpfs/wizard/flight/production/preRawreader/07909005.pam',0,'2
71 008-06-10 14:54:59');
72

  ViewVC Help
Powered by ViewVC 1.1.23