diff options
Diffstat (limited to 'components/test/data/history/Favicons.v7.sql')
-rw-r--r-- | components/test/data/history/Favicons.v7.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/components/test/data/history/Favicons.v7.sql b/components/test/data/history/Favicons.v7.sql new file mode 100644 index 0000000..8b0fd2c --- /dev/null +++ b/components/test/data/history/Favicons.v7.sql @@ -0,0 +1,26 @@ +-- unit_tests --gtest_filter=ThumbnailDatabaseTest.Version7 +-- +-- .dump of a version 7 Favicons database. +BEGIN TRANSACTION; +CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR); +INSERT INTO "meta" VALUES('version','7'); +INSERT INTO "meta" VALUES('last_compatible_version','7'); +CREATE TABLE favicons(id INTEGER PRIMARY KEY,url LONGVARCHAR NOT NULL,icon_type INTEGER DEFAULT 1); +INSERT INTO "favicons" VALUES(1,'http://www.google.com/favicon.ico',1); +INSERT INTO "favicons" VALUES(2,'http://www.google.com/touch.ico',2); +INSERT INTO "favicons" VALUES(3,'http://www.yahoo.com/favicon.ico',1); +CREATE TABLE favicon_bitmaps(id INTEGER PRIMARY KEY,icon_id INTEGER NOT NULL,last_updated INTEGER DEFAULT 0,image_data BLOB,width INTEGER DEFAULT 0,height INTEGER DEFAULT 0); +INSERT INTO "favicon_bitmaps" VALUES(1,1,1287424416,X'313233343631303233353631323033393437353136333435313635393133343837313034373831323336343931363534313932333435313932333435313233343931333400',32,32); +INSERT INTO "favicon_bitmaps" VALUES(2,2,1287424428,X'676F6977756567727172636F6D697A71797A6B6A616C697462616878666A7974727176707165726F6963786D6E6C6B686C7A756E616378616E65766961777274786379776867656600',32,32); +INSERT INTO "favicon_bitmaps" VALUES(3,3,1287424428,X'676F6977756567727172636F6D697A71797A6B6A616C697462616878666A7974727176707165726F6963786D6E6C6B686C7A756E616378616E65766961777274786379776867656600',32,32); +CREATE TABLE icon_mapping(id INTEGER PRIMARY KEY,page_url LONGVARCHAR NOT NULL,icon_id INTEGER); +INSERT INTO "icon_mapping" VALUES(1,'http://google.com/',1); +INSERT INTO "icon_mapping" VALUES(2,'http://www.google.com/',1); +INSERT INTO "icon_mapping" VALUES(3,'http://www.google.com/',2); +INSERT INTO "icon_mapping" VALUES(4,'http://yahoo.com/',3); +INSERT INTO "icon_mapping" VALUES(5,'http://www.yahoo.com/',3); +CREATE INDEX favicons_url ON favicons(url); +CREATE INDEX favicon_bitmaps_icon_id ON favicon_bitmaps(icon_id); +CREATE INDEX icon_mapping_page_url_idx ON icon_mapping(page_url); +CREATE INDEX icon_mapping_icon_id_idx ON icon_mapping(icon_id); +COMMIT; |