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

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

Powered by Google App Engine
This is Rietveld 408576698