-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbase_dump_2011_jets.txt
60 lines (60 loc) · 9.39 KB
/
base_dump_2011_jets.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "TAGINVENTORY_TABLE" ( "tagname" TEXT NOT NULL,"objectname" TEXT NOT NULL,"recordname" TEXT NOT NULL,"tagid" ULONGLONG ,"pfn" TEXT NOT NULL,"labelname" TEXT , PRIMARY KEY("tagid") );
INSERT INTO "TAGINVENTORY_TABLE" VALUES('CastorSaturationCorrs_v1.00_offline','CastorSaturationCorrs','CastorSaturationCorrsRcd',1,'sqlite_file:./FT_53_LV5_AN1/CastorSaturationCorrs_v1.00_offline.db','');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('EcalSampleMask_offline','EcalSampleMask','EcalSampleMaskRcd',2,'sqlite_file:./FT_53_LV5_AN1/EcalSampleMask_offline.db','');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_IC5Calo','JetCorrectorParametersCollection','JetCorrectionsRecord',3,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_IC5Calo.db','IC5Calo');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_KT6PF','JetCorrectorParametersCollection','JetCorrectionsRecord',4,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_KT6PF.db','KT6PF');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_KT6Calo','JetCorrectorParametersCollection','JetCorrectionsRecord',5,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_KT6Calo.db','KT6Calo');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_AK5TRK','JetCorrectorParametersCollection','JetCorrectionsRecord',6,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_AK5TRK.db','AK5TRK');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_KT4Calo','JetCorrectorParametersCollection','JetCorrectionsRecord',7,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_KT4Calo.db','KT4Calo');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_KT4PF','JetCorrectorParametersCollection','JetCorrectionsRecord',8,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_KT4PF.db','KT4PF');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Jec11_V12_IC5PF','JetCorrectorParametersCollection','JetCorrectionsRecord',9,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Jec11_V12_IC5PF.db','IC5PF');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK5PFTowers_hiGoodTightTracks_v0_offline','JetCorrectorParametersCollection','JetCorrectionsRecord',10,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK5PFTowers_hiGoodTightTracks_v0_offline.db','AK5PFTowers_hiGoodTightTracks');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK5Calo_v1_hlt','JetCorrectorParametersCollection','JetCorrectionsRecord',11,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK5Calo_v1_hlt.db','AK5CaloHLT');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK5PFchs_v1_hlt','JetCorrectorParametersCollection','JetCorrectionsRecord',12,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK5PFchs_v1_hlt.db','AK5PFchsHLT');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK4PFTowers_hiGoodTightTracks_v0_offline','JetCorrectorParametersCollection','JetCorrectionsRecord',13,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK4PFTowers_hiGoodTightTracks_v0_offline.db','AK4PFTowers_hiGoodTightTracks');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK5PF_v1_hlt','JetCorrectorParametersCollection','JetCorrectionsRecord',14,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK5PF_v1_hlt.db','AK5PFHLT');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_AK3PFTowers_hiGoodTightTracks_v0_offline','JetCorrectorParametersCollection','JetCorrectionsRecord',15,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_AK3PFTowers_hiGoodTightTracks_v0_offline.db','AK3PFTowers_hiGoodTightTracks');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7JPT','JetCorrectorParametersCollection','JetCorrectionsRecord',16,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7JPT.db','AK7JPT');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7Calo','JetCorrectorParametersCollection','JetCorrectionsRecord',17,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7Calo.db','AK7Calo');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_IC5Calo_2760GeV_v0_offline','JetCorrectorParametersCollection','JetCorrectionsRecord',18,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_IC5Calo_2760GeV_v0_offline.db','IC5Calo_2760GeV');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7PFchs','JetCorrectorParametersCollection','JetCorrectionsRecord',19,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7PFchs.db','AK7PFchs');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7PF','JetCorrectorParametersCollection','JetCorrectionsRecord',20,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK7PF.db','AK7PF');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5PFchs','JetCorrectorParametersCollection','JetCorrectionsRecord',21,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5PFchs.db','AK5PFchs');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5PF','JetCorrectorParametersCollection','JetCorrectionsRecord',22,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5PF.db','AK5PF');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5JPT','JetCorrectorParametersCollection','JetCorrectionsRecord',23,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5JPT.db','AK5JPT');
INSERT INTO "TAGINVENTORY_TABLE" VALUES('JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5Calo','JetCorrectorParametersCollection','JetCorrectionsRecord',24,'sqlite_file:./FT_53_LV5_AN1/JetCorrectorParametersCollection_Legacy11_V1_DATA_AK5Calo.db','AK5Calo');
CREATE TABLE coral_sqlite_fk(id TEXT NOT NULL, name TEXT, tablename TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "TAGINVENTORY_IDS" ( "nextID" ULONGLONG );
INSERT INTO TAGINVENTORY_IDS VALUES(22);
CREATE TABLE IF NOT EXISTS "TAGTREE_TABLE_replacethis" ( "lft" ULONGLONG NOT NULL,"globaltill" ULONGLONG ,"rgt" ULONGLONG NOT NULL,"nodelabel" TEXT NOT NULL,"tagid" ULONGLONG ,"parentid" ULONGLONG NOT NULL,"nodeid" ULONGLONG ,"globalsince" ULONGLONG , PRIMARY KEY("nodeid"), UNIQUE ( "nodelabel" ) );
INSERT INTO TAGTREE_TABLE_replacethis VALUES(1,4294967295,50,'All',0,0,1,0);
INSERT INTO TAGTREE_TABLE_replacethis VALUES(2,0,49,'Calibration',0,1,2,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(3,0,4,'CastorSaturationCorrs',1,2,3,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(5,0,6,'EcalSampleMask',2,2,4,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(7,0,8,'JetCorrectionsRecordIC5Calo',3,2,5,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(9,0,10,'JetCorrectionsRecordKT6PF',4,2,6,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(11,0,12,'JetCorrectionsRecordKT6Calo',5,2,7,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(13,0,14,'JetCorrectionsRecordAK5TRK',6,2,8,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(15,0,16,'JetCorrectionsRecordKT4Calo',7,2,9,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(17,0,18,'JetCorrectionsRecordKT4PF',8,2,10,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(19,0,20,'JetCorrectionsRecordIC5PF',9,2,11,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(21,0,22,'JetCorrectionsRecordAK5PFTowers_hiGoodTightTracks',10,2,12,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(23,0,24,'JetCorrectionsRecordAK5CaloHLT',11,2,13,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(25,0,26,'JetCorrectionsRecordAK5PFchsHLT',12,2,14,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(27,0,28,'JetCorrectionsRecordAK4PFTowers_hiGoodTightTracks',13,2,15,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(29,0,30,'JetCorrectionsRecordAK5PFHLT',14,2,16,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(31,0,32,'JetCorrectionsRecordAK3PFTowers_hiGoodTightTracks',15,2,17,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(33,0,34,'JetCorrectionsRecordAK7JPT',16,2,18,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(35,0,36,'JetCorrectionsRecordAK7Calo',17,2,19,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(37,0,38,'JetCorrectionsRecordIC5Calo_2760GeV',18,2,20,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(39,0,40,'JetCorrectionsRecordAK7PFchs',19,2,21,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(41,0,42,'JetCorrectionsRecordAK7PF',20,2,22,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(43,0,44,'JetCorrectionsRecordAK5PFchs',21,2,23,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(45,0,46,'JetCorrectionsRecordAK5PF',22,2,24,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(47,0,48,'JetCorrectionsRecordAK5JPT',23,2,25,0);
INSERT INTO "TAGTREE_TABLE_FT_53_LV5_AN1" VALUES(49,0,50,'JetCorrectionsRecordAK5Calo',24,2,26,0);
CREATE TABLE IF NOT EXISTS "TAGTREE_replacethis_IDS" ( "nextID" ULONGLONG );
INSERT INTO TAGTREE_replacethis_IDS VALUES(24);
COMMIT;