-- components_unittests --gtest_filter=SharedStorageDatabaseTest.Version1_LoadFromFile
--
-- .dump of a version 1 Shared Storage database.
BEGIN TRANSACTION;
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
INSERT INTO "meta" VALUES('version','1');
INSERT INTO "meta" VALUES('last_compatible_version','1');
CREATE TABLE values_mapping(context_origin TEXT NOT NULL,key TEXT NOT NULL,value TEXT,PRIMARY KEY(context_origin,key)) WITHOUT ROWID;
INSERT INTO "values_mapping" VALUES ('http://google.com','key1','value1');
INSERT INTO "values_mapping" VALUES ('http://google.com','key2','value2');
INSERT INTO "values_mapping" VALUES ('http://youtube.com','visited','1111111');
INSERT INTO "values_mapping" VALUES ('http://chromium.org','a','');
INSERT INTO "values_mapping" VALUES ('http://chromium.org','b','hello');
INSERT INTO "values_mapping" VALUES ('http://chromium.org','c','goodbye');
INSERT INTO "values_mapping" VALUES ('http://gv.com','cookie','13268941793856733');
INSERT INTO "values_mapping" VALUES ('http://abc.xyz','seed','387562094');
INSERT INTO "values_mapping" VALUES ('http://abc.xyz','bucket','1276');
INSERT INTO "values_mapping" VALUES ('http://withgoogle.com','count','389');
INSERT INTO "values_mapping" VALUES ('http://waymo.com','key','value');
INSERT INTO "values_mapping" VALUES ('http://google.org','1','ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff');
INSERT INTO "values_mapping" VALUES ('http://google.org','2',';');
INSERT INTO "values_mapping" VALUES ('http://google.org','#','[]');
INSERT INTO "values_mapping" VALUES ('http://google.org','ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff','k');
INSERT INTO "values_mapping" VALUES ('http://growwithgoogle.com','_','down');
INSERT INTO "values_mapping" VALUES ('http://growwithgoogle.com','<','left');
INSERT INTO "values_mapping" VALUES ('http://growwithgoogle.com','>','right');
CREATE TABLE per_origin_mapping(context_origin TEXT NOT NULL PRIMARY KEY,last_used_time INTEGER NOT NULL,length INTEGER NOT NULL) WITHOUT ROWID;
INSERT INTO "per_origin_mapping" VALUES ('http://google.com',13266954476192362,2);
INSERT INTO "per_origin_mapping" VALUES ('http://youtube.com',13266954593856733,1);
INSERT INTO "per_origin_mapping" VALUES ('http://chromium.org',13268941676192362,3);
INSERT INTO "per_origin_mapping" VALUES ('http://gv.com',13268941793856733,1);
INSERT INTO "per_origin_mapping" VALUES ('http://abc.xyz',13269481776356965,2);
INSERT INTO "per_origin_mapping" VALUES ('http://withgoogle.com',13269545986263676,1);
INSERT INTO "per_origin_mapping" VALUES ('http://waymo.com',13269546064355176,1);
INSERT INTO "per_origin_mapping" VALUES ('http://google.org',13269546476192362,4);
INSERT INTO "per_origin_mapping" VALUES ('http://growwithgoogle.com',13269546593856733,3);
CREATE INDEX IF NOT EXISTS per_origin_mapping_last_used_time_idx ON per_origin_mapping(last_used_time);
COMMIT;
Codebase Browser
chromium