Index: chrome/test/data/web_database/version_47.sql |
diff --git a/chrome/test/data/web_database/version_46_backup_corrupt.sql b/chrome/test/data/web_database/version_47.sql |
similarity index 66% |
rename from chrome/test/data/web_database/version_46_backup_corrupt.sql |
rename to chrome/test/data/web_database/version_47.sql |
index 8dcf7cb25ef771f4138ee46f5f3805aa05cff6ef..aae06e8e9b7ca63f185a7032352bbc21e410e6ed 100644 |
--- a/chrome/test/data/web_database/version_46_backup_corrupt.sql |
+++ b/chrome/test/data/web_database/version_47.sql |
@@ -1,12 +1,33 @@ |
PRAGMA foreign_keys=OFF; |
BEGIN TRANSACTION; |
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR); |
-INSERT INTO "meta" VALUES('Default Search Provider ID','0'); |
-INSERT INTO "meta" VALUES('version','46'); |
-INSERT INTO "meta" VALUES('last_compatible_version','46'); |
-INSERT INTO "meta" VALUES('Default Search Provider ID Backup','0'); |
+INSERT INTO "meta" VALUES('version','47'); |
+INSERT INTO "meta" VALUES('last_compatible_version','47'); |
+INSERT INTO "meta" VALUES('Builtin Keyword Version','46'); |
+INSERT INTO "meta" VALUES('Default Search Provider ID','2'); |
+INSERT INTO "meta" VALUES('Default Search Provider ID Backup','2'); |
INSERT INTO "meta" VALUES('Default Search Provider ID Backup Signature',''); |
-INSERT INTO "meta" VALUES('Builtin Keyword Version','39'); |
+CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keyword VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_created INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,show_in_default_list INTEGER,suggest_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_url VARCHAR,last_modified INTEGER DEFAULT 0,sync_guid VARCHAR,alternate_urls VARCHAR); |
+CREATE TABLE keywords_backup( |
+ id INT, |
+ short_name TEXT, |
+ keyword TEXT, |
+ favicon_url TEXT, |
+ url TEXT, |
+ safe_for_autoreplace INT, |
+ originating_url TEXT, |
+ date_created INT, |
+ usage_count INT, |
+ input_encodings TEXT, |
+ show_in_default_list INT, |
+ suggest_url TEXT, |
+ prepopulate_id INT, |
+ created_by_policy INT, |
+ instant_url TEXT, |
+ last_modified INT, |
+ sync_guid TEXT, |
+ alternate_urls TEXT |
+); |
CREATE TABLE autofill (name VARCHAR, value VARCHAR, value_lower VARCHAR, pair_id INTEGER PRIMARY KEY, count INTEGER DEFAULT 1); |
CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expiration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_modified INTEGER NOT NULL DEFAULT 0); |
CREATE TABLE autofill_dates ( pair_id INTEGER DEFAULT 0, date_created INTEGER DEFAULT 0); |
@@ -18,10 +39,8 @@ CREATE TABLE autofill_profiles_trash ( guid VARCHAR); |
CREATE TABLE web_app_icons (url LONGVARCHAR,width int,height int,image BLOB, UNIQUE (url, width, height)); |
CREATE TABLE web_apps (url LONGVARCHAR UNIQUE,has_all_images INTEGER NOT NULL); |
CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token BLOB); |
-CREATE TABLE web_intents (service_url LONGVARCHAR,action VARCHAR,type VARCHAR,title LONGVARCHAR,disposition VARCHAR,scheme VARCHAR,UNIQUE (service_url, action, type)); |
-CREATE TABLE web_intents_defaults (action VARCHAR,type VARCHAR,url_pattern LONGVARCHAR,user_date INTEGER,suppression INTEGER,service_url LONGVARCHAR,scheme VARCHAR,UNIQUE (action, type, url_pattern)); |
-CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keyword VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_created INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,show_in_default_list INTEGER,suggest_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_url VARCHAR,last_modified INTEGER DEFAULT 0,sync_guid VARCHAR); |
-CREATE TABLE keywords_backup(id INT,short_name TEXT,keyword TEXT,favicon_url TEXT,url TEXT,safe_for_autoreplace INT,originating_url TEXT,date_created INT,usage_count INT,input_encodings TEXT,show_in_default_list INT,suggest_url TEXT,prepopulate_id INT,created_by_policy INT,instant_url TEXT,last_modified INT,sync_guid TEXT); |
+CREATE TABLE web_intents ( service_url LONGVARCHAR, action VARCHAR, type VARCHAR, title LONGVARCHAR, disposition VARCHAR, scheme VARCHAR, UNIQUE (service_url, action, scheme, type)); |
+CREATE TABLE web_intents_defaults ( action VARCHAR, type VARCHAR, url_pattern LONGVARCHAR, user_date INTEGER, suppression INTEGER, service_url LONGVARCHAR, scheme VARCHAR, UNIQUE (action, scheme, type, url_pattern)); |
CREATE INDEX autofill_name ON autofill (name); |
CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); |
CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); |