chrome/test/data/web_database/version_45_compatible.sql - Issue 10696127: Force WebDatabase version to max(version, compatible version) before migration.

Side by Side Diff: chrome/test/data/web_database/version_45_compatible.sql

Issue 10696127: Force WebDatabase version to max(version, compatible version) before migration. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src

Patch Set: Style fix Created 8 years, 5 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View unified diff | Download patch | Annotate | Revision Log

« chrome/browser/webdata/web_database.cc ('K') | « chrome/browser/webdata/web_database_migration_unittest.cc ('k') | no next file » | no next file with comments »

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','40');

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);

11 CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expi ration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_ modified INTEGER NOT NULL DEFAULT 0);	11 CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expi ration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_ modified INTEGER NOT NULL DEFAULT 0);

12 CREATE TABLE autofill_dates ( pair_id INTEGER DEFAULT 0, date_created INTEGER DE FAULT 0);	12 CREATE TABLE autofill_dates ( pair_id INTEGER DEFAULT 0, date_created INTEGER DE FAULT 0);

13 CREATE TABLE autofill_profiles ( guid VARCHAR PRIMARY KEY, company_name VARCHAR, address_line_1 VARCHAR, address_line_2 VARCHAR, city VARCHAR, state VARCHAR, zi pcode VARCHAR, country VARCHAR, country_code VARCHAR, date_modified INTEGER NOT NULL DEFAULT 0);	13 CREATE TABLE autofill_profiles ( guid VARCHAR PRIMARY KEY, company_name VARCHAR, address_line_1 VARCHAR, address_line_2 VARCHAR, city VARCHAR, state VARCHAR, zi pcode VARCHAR, country VARCHAR, country_code VARCHAR, date_modified INTEGER NOT NULL DEFAULT 0);

14 CREATE TABLE autofill_profile_names ( guid VARCHAR, first_name VARCHAR, middle_n ame VARCHAR, last_name VARCHAR);	14 CREATE TABLE autofill_profile_names ( guid VARCHAR, first_name VARCHAR, middle_n ame VARCHAR, last_name VARCHAR);

15 CREATE TABLE autofill_profile_emails ( guid VARCHAR, email VARCHAR);	15 CREATE TABLE autofill_profile_emails ( guid VARCHAR, email VARCHAR);

(...skipping 23 matching lines...) Expand all Loading...
39 instant_url TEXT,	39 instant_url TEXT,

40 last_modified INT,	40 last_modified INT,

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 CREATE INDEX web_intents_index ON web_intents (action);	47 CREATE INDEX web_intents_index ON web_intents (action);

48 CREATE INDEX web_intents_default_index ON web_intents_defaults (action);	48 CREATE INDEX web_intents_default_index ON web_intents_defaults (action);

49 -- following statements are required for testing migration to version 46

50 INSERT INTO web_intents VALUES ('http://poodles.com/fuzzer', 'fuzz', 'poodle/*', 'Poodle Fuzzer', 'window');

51 INSERT INTO web_intents_defaults VALUES ('fuzz', 'poodle/*', '', 0, 0, 'http://p oodles.com/fuzzer');

52 COMMIT;	49 COMMIT;

53	50

OLD	NEW