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

Side by Side Diff: components/test/data/password_manager/login_db_v2_broken.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 -- Version 4 schema with meta.version==2. Tests http://crbug.com/295851 1 -- Version 4 schema with meta.version==2. Tests http://crbug.com/295851
2 PRAGMA foreign_keys=OFF; 2 PRAGMA foreign_keys=OFF;
3 BEGIN TRANSACTION; 3 BEGIN TRANSACTION;
4 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR ); 4 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR );
5 INSERT INTO "meta" VALUES('last_compatible_version','1'); 5 INSERT INTO "meta" VALUES('last_compatible_version','1');
6 INSERT INTO "meta" VALUES('version','2'); 6 INSERT INTO "meta" VALUES('version','2');
7 CREATE TABLE logins ( 7 CREATE TABLE logins (
8 origin_url VARCHAR NOT NULL, 8 origin_url VARCHAR NOT NULL,
9 action_url VARCHAR, 9 action_url VARCHAR,
10 username_element VARCHAR, 10 username_element VARCHAR,
(...skipping 43 matching lines...) Expand 10 before | Expand all | Expand 10 after
54 1, /* ssl_valid */ 54 1, /* ssl_valid */
55 1, /* preferred */ 55 1, /* preferred */
56 1402950000, /* date_created */ 56 1402950000, /* date_created */
57 0, /* blacklisted_by_user */ 57 0, /* blacklisted_by_user */
58 0, /* scheme */ 58 0, /* scheme */
59 0, /* password_type */ 59 0, /* password_type */
60 X'00000000', /* possible_usernames */ 60 X'00000000', /* possible_usernames */
61 1, /* times_used */ 61 1, /* times_used */
62 X'18000000020000000000000000000000000000000000000000000000' /* form_data */ 62 X'18000000020000000000000000000000000000000000000000000000' /* form_data */
63 ); 63 );
64 INSERT INTO "logins" VALUES(
65 'http://example.com', /* origin_url */
66 'http://example.com/landing', /* action_url */
67 '', /* username_element */
68 'user', /* username_value */
69 '', /* password_element */
70 X'', /* password_value */
71 '', /* submit_element */
72 'http://example.com', /* signon_realm */
73 1, /* ssl_valid */
74 1, /* preferred */
75 1402950000, /* date_created */
76 0, /* blacklisted_by_user */
77 1, /* scheme */
78 0, /* password_type */
79 X'00000000', /* possible_usernames */
80 1, /* times_used */
81 X'18000000020000000000000000000000000000000000000000000000' /* form_data */
82 );
64 CREATE INDEX logins_signon ON logins (signon_realm); 83 CREATE INDEX logins_signon ON logins (signon_realm);
65 COMMIT; 84 COMMIT;
66 85
OLDNEW
« no previous file with comments | « components/test/data/password_manager/login_db_v2.sql ('k') | components/test/data/password_manager/login_db_v3.sql » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698