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 |