diff options
Diffstat (limited to 'components/test/data/history/thumbnail_wild/Favicons.v5.sizes.sql')
-rw-r--r-- | components/test/data/history/thumbnail_wild/Favicons.v5.sizes.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/components/test/data/history/thumbnail_wild/Favicons.v5.sizes.sql b/components/test/data/history/thumbnail_wild/Favicons.v5.sizes.sql new file mode 100644 index 0000000..6dfa9e9 --- /dev/null +++ b/components/test/data/history/thumbnail_wild/Favicons.v5.sizes.sql @@ -0,0 +1,24 @@ +-- unit_tests --gtest_filter=ThumbnailDatabaseTest.WildSchema +-- +-- Based on version 5 schema found in the wild by error diagnostics. +-- The schema failed to open because the v3 [favicons] table is +-- missing [sizes]. +-- +-- Init() should clean up with RazeAndClose(). +BEGIN TRANSACTION; + +-- [meta] is expected. +CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR); +INSERT INTO "meta" VALUES('version','5'); +INSERT INTO "meta" VALUES('last_compatible_version','5'); + +-- v4 [favicons] (missing [sizes]), but v5 database. +CREATE TABLE "favicons"(id INTEGER PRIMARY KEY,url LONGVARCHAR NOT NULL,last_updated INTEGER DEFAULT 0,image_data BLOB,icon_type INTEGER DEFAULT 1); +CREATE INDEX favicons_url ON favicons(url); + +-- [icon_mapping] consistent with v5. +CREATE TABLE icon_mapping(id INTEGER PRIMARY KEY,page_url LONGVARCHAR NOT NULL,icon_id INTEGER); +CREATE INDEX icon_mapping_icon_id_idx ON icon_mapping(icon_id); +CREATE INDEX icon_mapping_page_url_idx ON icon_mapping(page_url); + +COMMIT; |