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

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

Powered by Google App Engine
This is Rietveld 408576698