diff options
Diffstat (limited to 'components/test/data/history/thumbnail_wild/Favicons.v6.init.sql')
-rw-r--r-- | components/test/data/history/thumbnail_wild/Favicons.v6.init.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/components/test/data/history/thumbnail_wild/Favicons.v6.init.sql b/components/test/data/history/thumbnail_wild/Favicons.v6.init.sql new file mode 100644 index 0000000..3014c37 --- /dev/null +++ b/components/test/data/history/thumbnail_wild/Favicons.v6.init.sql @@ -0,0 +1,36 @@ +-- unit_tests --gtest_filter=ThumbnailDatabaseTest.WildSchema +-- +-- Based on version 6 schema found in the wild by error diagnostics. +-- The schema failed migrations because of unexpected +-- [temp_favicons] table (see http://crbug.com/272519 ). +-- +-- Init() has been modified to drop these tables. +-- TODO(shess): Should this case contain data? +BEGIN TRANSACTION; + +-- [meta] is expected. +CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR); +INSERT INTO "meta" VALUES('version','6'); +INSERT INTO "meta" VALUES('last_compatible_version','6'); + +-- This version of [favicons] is consistent with v6. +CREATE TABLE "favicons"(id INTEGER PRIMARY KEY,url LONGVARCHAR NOT NULL,icon_type INTEGER DEFAULT 1,sizes LONGVARCHAR); +CREATE INDEX favicons_url ON favicons(url); + +-- [icon_mapping] consistent with v6. +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); + +-- [favicon_bitmaps] consistent with v6. +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); +CREATE INDEX favicon_bitmaps_icon_id ON favicon_bitmaps(icon_id); + +-- Presence of these tables is consistent with an aborted attempt to +-- clear history. Prior to r217993, that code was not contained in a +-- transaction (or possibly there was a non-atomic update). +CREATE TABLE temp_favicons(id INTEGER PRIMARY KEY,url LONGVARCHAR NOT NULL,icon_type INTEGER DEFAULT 1,sizes LONGVARCHAR); +CREATE TABLE temp_icon_mapping(id INTEGER PRIMARY KEY,page_url LONGVARCHAR NOT NULL,icon_id INTEGER); +CREATE TABLE temp_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); + +COMMIT; |