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

Side by Side Diff: components/test/data/password_manager/login_db_v3.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','3'); 5 INSERT INTO "meta" VALUES('version','3');
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 39 matching lines...) Expand 10 before | Expand all | Expand 10 after
50 'https://accounts.google.com/', /* signon_realm */ 50 'https://accounts.google.com/', /* signon_realm */
51 1, /* ssl_valid */ 51 1, /* ssl_valid */
52 1, /* preferred */ 52 1, /* preferred */
53 1402950000, /* date_created */ 53 1402950000, /* date_created */
54 0, /* blacklisted_by_user */ 54 0, /* blacklisted_by_user */
55 0, /* scheme */ 55 0, /* scheme */
56 0, /* password_type */ 56 0, /* password_type */
57 X'00000000', /* possible_usernames */ 57 X'00000000', /* possible_usernames */
58 1 /* times_used */ 58 1 /* times_used */
59 ); 59 );
60 INSERT INTO "logins" VALUES(
61 'http://example.com', /* origin_url */
62 'http://example.com/landing', /* action_url */
63 '', /* username_element */
64 'user', /* username_value */
65 '', /* password_element */
66 X'', /* password_value */
67 '', /* submit_element */
68 'http://example.com', /* signon_realm */
69 1, /* ssl_valid */
70 1, /* preferred */
71 1402950000, /* date_created */
72 0, /* blacklisted_by_user */
73 1, /* scheme */
74 0, /* password_type */
75 X'00000000', /* possible_usernames */
76 1 /* times_used */
77 );
60 CREATE INDEX logins_signon ON logins (signon_realm); 78 CREATE INDEX logins_signon ON logins (signon_realm);
61 COMMIT; 79 COMMIT;
62 80
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698