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

Side by Side Diff: components/test/data/password_manager/login_db_v6.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','1'); 4 INSERT INTO "meta" VALUES('last_compatible_version','1');
5 INSERT INTO "meta" VALUES('version','6'); 5 INSERT INTO "meta" VALUES('version','6');
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 48 matching lines...) Expand 10 before | Expand all | Expand 10 after
59 1402950000, /* date_created */ 59 1402950000, /* date_created */
60 0, /* blacklisted_by_user */ 60 0, /* blacklisted_by_user */
61 0, /* scheme */ 61 0, /* scheme */
62 0, /* password_type */ 62 0, /* password_type */
63 X'00000000', /* possible_usernames */ 63 X'00000000', /* possible_usernames */
64 1, /* times_used */ 64 1, /* times_used */
65 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 65 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
66 NULL, /* use_additional_auth */ 66 NULL, /* use_additional_auth */
67 0 /* date_synced */ 67 0 /* date_synced */
68 ); 68 );
69 INSERT INTO "logins" VALUES(
70 'http://example.com', /* origin_url */
71 'http://example.com/landing', /* action_url */
72 '', /* username_element */
73 'user', /* username_value */
74 '', /* password_element */
75 X'', /* password_value */
76 '', /* submit_element */
77 'http://example.com', /* signon_realm */
78 1, /* ssl_valid */
79 1, /* preferred */
80 1402950000, /* date_created */
81 0, /* blacklisted_by_user */
82 1, /* scheme */
83 0, /* password_type */
84 X'00000000', /* possible_usernames */
85 1, /* times_used */
86 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
87 NULL, /* use_additional_auth */
88 0 /* date_synced */
89 );
69 CREATE INDEX logins_signon ON logins (signon_realm); 90 CREATE INDEX logins_signon ON logins (signon_realm);
70 COMMIT; 91 COMMIT;
71 92
OLDNEW
« no previous file with comments | « components/test/data/password_manager/login_db_v5.sql ('k') | components/test/data/password_manager/login_db_v7.sql » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698