| OLD | NEW |
| 1 PRAGMA foreign_keys=OFF; | 1 PRAGMA foreign_keys=OFF; |
| 2 BEGIN TRANSACTION; | 2 BEGIN TRANSACTION; |
| 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); | 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); |
| 4 INSERT INTO "meta" VALUES('Default Search Provider ID','2'); | 4 INSERT INTO "meta" VALUES('Default Search Provider ID','2'); |
| 5 INSERT INTO "meta" VALUES('version','45'); | 5 INSERT INTO "meta" VALUES('version','45'); |
| 6 INSERT INTO "meta" VALUES('last_compatible_version','45'); | 6 INSERT INTO "meta" VALUES('last_compatible_version','45'); |
| 7 INSERT INTO "meta" VALUES('Default Search Provider ID Backup','2'); | 7 INSERT INTO "meta" VALUES('Default Search Provider ID Backup','2'); |
| 8 INSERT INTO "meta" VALUES('Default Search Provider ID Backup Signature',''); | 8 INSERT INTO "meta" VALUES('Default Search Provider ID Backup Signature',''); |
| 9 INSERT INTO "meta" VALUES('Builtin Keyword Version','39'); | 9 INSERT INTO "meta" VALUES('Builtin Keyword Version','39'); |
| 10 CREATE TABLE autofill (name VARCHAR, value VARCHAR, value_lower VARCHAR, pair_id
INTEGER PRIMARY KEY, count INTEGER DEFAULT 1); | 10 CREATE TABLE autofill (name VARCHAR, value VARCHAR, value_lower VARCHAR, pair_id
INTEGER PRIMARY KEY, count INTEGER DEFAULT 1); |
| (...skipping 30 matching lines...) Expand all Loading... |
| 41 sync_guid TEXT | 41 sync_guid TEXT |
| 42 ); | 42 ); |
| 43 CREATE INDEX autofill_name ON autofill (name); | 43 CREATE INDEX autofill_name ON autofill (name); |
| 44 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); | 44 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); |
| 45 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); | 45 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); |
| 46 CREATE INDEX web_apps_url_index ON web_apps (url); | 46 CREATE INDEX web_apps_url_index ON web_apps (url); |
| 47 -- following statements are required for testing migration to version 46 | 47 -- following statements are required for testing migration to version 46 |
| 48 INSERT INTO web_intents VALUES (11); | 48 INSERT INTO web_intents VALUES (11); |
| 49 INSERT INTO web_intents_defaults VALUES ('fuzz'); | 49 INSERT INTO web_intents_defaults VALUES ('fuzz'); |
| 50 COMMIT; | 50 COMMIT; |
| OLD | NEW |