Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(340)

Side by Side Diff: components/test/data/password_manager/login_db_v18.sql

Issue 2291123008: Test that LoginDatabase preserves PasswordForm::Scheme through migration (Closed)
Patch Set: Add comment Created 4 years, 3 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
OLDNEW
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('last_compatible_version','18'); 4 INSERT INTO "meta" VALUES('last_compatible_version','18');
5 INSERT INTO "meta" VALUES('version','18'); 5 INSERT INTO "meta" VALUES('version','18');
6 CREATE TABLE logins ( 6 CREATE TABLE logins (
7 origin_url VARCHAR NOT NULL, 7 origin_url VARCHAR NOT NULL,
8 action_url VARCHAR, 8 action_url VARCHAR,
9 username_element VARCHAR, 9 username_element VARCHAR,
10 username_value VARCHAR, 10 username_value VARCHAR,
(...skipping 57 matching lines...) Expand 10 before | Expand all | Expand 10 after
68 X'00000000', /* possible_usernames */ 68 X'00000000', /* possible_usernames */
69 1, /* times_used */ 69 1, /* times_used */
70 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 70 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
71 0, /* date_synced */ 71 0, /* date_synced */
72 '', /* display_name */ 72 '', /* display_name */
73 'https://www.google.com/icon', /* icon_url */ 73 'https://www.google.com/icon', /* icon_url */
74 '', /* federation_url */ 74 '', /* federation_url */
75 1, /* skip_zero_click */ 75 1, /* skip_zero_click */
76 0 /* generation_upload_status */ 76 0 /* generation_upload_status */
77 ); 77 );
78 INSERT INTO "logins" VALUES(
79 'http://example.com', /* origin_url */
80 'http://example.com/landing', /* action_url */
81 '', /* username_element */
82 'user', /* username_value */
83 '', /* password_element */
84 X'', /* password_value */
85 'non-empty', /* submit_element */
86 'http://example.com', /* signon_realm */
87 1, /* preferred */
88 13047423600000000, /* date_created */
89 0, /* blacklisted_by_user */
90 1, /* scheme */
91 0, /* password_type */
92 X'00000000', /* possible_usernames */
93 1, /* times_used */
94 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
95 0, /* date_synced */
96 '', /* display_name */
97 'https://www.google.com/icon', /* icon_url */
98 '', /* federation_url */
99 1, /* skip_zero_click */
100 0 /* generation_upload_status */
101 );
78 CREATE INDEX logins_signon ON logins (signon_realm); 102 CREATE INDEX logins_signon ON logins (signon_realm);
79 CREATE TABLE stats ( 103 CREATE TABLE stats (
80 origin_domain VARCHAR NOT NULL, 104 origin_domain VARCHAR NOT NULL,
81 username_value VARCHAR, 105 username_value VARCHAR,
82 dismissal_count INTEGER, 106 dismissal_count INTEGER,
83 update_time INTEGER NOT NULL, 107 update_time INTEGER NOT NULL,
84 UNIQUE(origin_domain, username_value)); 108 UNIQUE(origin_domain, username_value));
85 CREATE INDEX stats_origin ON stats(origin_domain); 109 CREATE INDEX stats_origin ON stats(origin_domain);
86 COMMIT; 110 COMMIT;
OLDNEW
« no previous file with comments | « components/test/data/password_manager/login_db_v17.sql ('k') | components/test/data/password_manager/login_db_v1_broken.sql » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698