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

Issues Search
    My Issues | Starred     Open | Closed | All

Side by Side Diff: components/test/data/password_manager/login_db_v10.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
« no previous file with comments | « components/test/data/password_manager/login_db_v1.sql ('k') | components/test/data/password_manager/login_db_v11.sql » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
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','10'); 5 INSERT INTO "meta" VALUES('version','10');
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 20 matching lines...) Expand all
31 'https://accounts.google.com/ServiceLogin', /* origin_url */ 31 'https://accounts.google.com/ServiceLogin', /* origin_url */
32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
33 'Email', /* username_element */ 33 'Email', /* username_element */
34 'theerikchen', /* username_value */ 34 'theerikchen', /* username_value */
35 'Passwd', /* password_element */ 35 'Passwd', /* password_element */
36 X'', /* password_value */ 36 X'', /* password_value */
37 '', /* submit_element */ 37 '', /* submit_element */
38 'https://accounts.google.com/', /* signon_realm */ 38 'https://accounts.google.com/', /* signon_realm */
39 1, /* ssl_valid */ 39 1, /* ssl_valid */
40 1, /* preferred */ 40 1, /* preferred */
41 13047423600000000, /* date_created */
42 0, /* blacklisted_by_user */
43 0, /* scheme */
44 0, /* password_type */
45 X'00000000', /* possible_usernames */
46 1, /* times_used */
47 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
48 0, /* date_synced */
49 '', /* display_name */
50 'https://www.google.com/icon', /* avatar_url */
51 '', /* federation_url */
52 0 /* is_zero_click */
53 );
54 INSERT INTO "logins" VALUES(
55 'https://accounts.google.com/ServiceLogin', /* origin_url */
56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
57 'Email', /* username_element */
58 'theerikchen', /* username_value */
59 'Passwd', /* password_element */
60 X'', /* password_value */
61 'non-empty', /* submit_element */
62 'https://accounts.google.com/', /* signon_realm */
63 1, /* ssl_valid */
64 1, /* preferred */
41 13047429345000000, /* date_created */ 65 13047429345000000, /* date_created */
42 0, /* blacklisted_by_user */ 66 0, /* blacklisted_by_user */
43 0, /* scheme */ 67 0, /* scheme */
44 0, /* password_type */ 68 0, /* password_type */
45 X'00000000', /* possible_usernames */ 69 X'00000000', /* possible_usernames */
46 1, /* times_used */ 70 1, /* times_used */
47 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
48 0, /* date_synced */ 72 0, /* date_synced */
49 '', /* display_name */ 73 '', /* display_name */
50 '', /* avatar_url */ 74 '', /* avatar_url */
51 '', /* federation_url */ 75 '', /* federation_url */
52 0 /* is_zero_click */ 76 0 /* is_zero_click */
53 ); 77 );
54 INSERT INTO "logins" VALUES( 78 INSERT INTO "logins" VALUES(
55 'https://accounts.google.com/ServiceLogin', /* origin_url */ 79 'https://accounts.google.com/ServiceLogin', /* origin_url */
56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 80 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
57 'Email', /* username_element */ 81 'Email', /* username_element */
58 'theerikchen', /* username_value */ 82 'theerikchen2', /* username_value */
59 'Passwd', /* password_element */ 83 'Passwd', /* password_element */
60 X'', /* password_value */ 84 X'', /* password_value */
61 'non-empty', /* submit_element */ 85 'non-empty', /* submit_element */
62 'https://accounts.google.com/', /* signon_realm */ 86 'https://accounts.google.com/', /* signon_realm */
63 1, /* ssl_valid */ 87 1, /* ssl_valid */
64 1, /* preferred */ 88 1, /* preferred */
65 13047423600000000, /* date_created */ 89 13047423600000000, /* date_created */
66 0, /* blacklisted_by_user */ 90 0, /* blacklisted_by_user */
67 0, /* scheme */ 91 0, /* scheme */
68 0, /* password_type */ 92 0, /* password_type */
69 X'00000000', /* possible_usernames */ 93 X'00000000', /* possible_usernames */
70 1, /* times_used */ 94 1, /* times_used */
71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 95 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
72 0, /* date_synced */ 96 0, /* date_synced */
73 '', /* display_name */ 97 '', /* display_name */
74 'https://www.google.com/icon', /* avatar_url */ 98 'https://www.google.com/icon', /* avatar_url */
75 '', /* federation_url */ 99 '', /* federation_url */
76 0 /* is_zero_click */ 100 0 /* is_zero_click */
77 ); 101 );
102 INSERT INTO "logins" VALUES(
103 'http://example.com', /* origin_url */
104 'http://example.com/landing', /* action_url */
105 '', /* username_element */
106 'user', /* username_value */
107 '', /* password_element */
108 X'', /* password_value */
109 'non-empty', /* submit_element */
110 'http://example.com', /* signon_realm */
111 1, /* ssl_valid */
112 1, /* preferred */
113 13047423600000000, /* date_created */
114 0, /* blacklisted_by_user */
115 1, /* scheme */
116 0, /* password_type */
117 X'00000000', /* possible_usernames */
118 1, /* times_used */
119 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
120 0, /* date_synced */
121 '', /* display_name */
122 'https://www.google.com/icon', /* avatar_url */
123 '', /* federation_url */
124 0 /* is_zero_click */
125 );
78 CREATE INDEX logins_signon ON logins (signon_realm); 126 CREATE INDEX logins_signon ON logins (signon_realm);
79 COMMIT; 127 COMMIT;
OLDNEW
« no previous file with comments | « components/test/data/password_manager/login_db_v1.sql ('k') | components/test/data/password_manager/login_db_v11.sql » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698