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

Side by Side Diff: components/test/data/password_manager/login_db_v9.sql

Issue 818443004: Remove use_additional_auth column from logins table. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Created 5 years, 11 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','7'); 5 INSERT INTO "meta" VALUES('version','9');
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,
11 password_element VARCHAR, 11 password_element VARCHAR,
12 password_value BLOB, 12 password_value BLOB,
13 submit_element VARCHAR, 13 submit_element VARCHAR,
14 signon_realm VARCHAR NOT NULL, 14 signon_realm VARCHAR NOT NULL,
15 ssl_valid INTEGER NOT NULL, 15 ssl_valid INTEGER NOT NULL,
(...skipping 16 matching lines...) Expand all
32 'https://accounts.google.com/ServiceLogin', /* origin_url */ 32 'https://accounts.google.com/ServiceLogin', /* origin_url */
33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
34 'Email', /* username_element */ 34 'Email', /* username_element */
35 'theerikchen', /* username_value */ 35 'theerikchen', /* username_value */
36 'Passwd', /* password_element */ 36 'Passwd', /* password_element */
37 X'', /* password_value */ 37 X'', /* password_value */
38 '', /* submit_element */ 38 '', /* submit_element */
39 'https://accounts.google.com/', /* signon_realm */ 39 'https://accounts.google.com/', /* signon_realm */
40 1, /* ssl_valid */ 40 1, /* ssl_valid */
41 1, /* preferred */ 41 1, /* preferred */
42 1402955745, /* date_created */ 42 13047429345000000, /* date_created */
43 0, /* blacklisted_by_user */ 43 0, /* blacklisted_by_user */
44 0, /* scheme */ 44 0, /* scheme */
45 0, /* password_type */ 45 0, /* password_type */
46 X'00000000', /* possible_usernames */ 46 X'00000000', /* possible_usernames */
47 1, /* times_used */ 47 1, /* times_used */
48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
49 NULL, /* use_additional_auth */ 49 NULL, /* use_additional_auth */
50 0, /* date_synced */ 50 0, /* date_synced */
51 '', /* display_name */ 51 '', /* display_name */
52 '', /* avatar_url */ 52 '', /* avatar_url */
53 '', /* federation_url */ 53 '', /* federation_url */
54 0 /* is_zero_click */ 54 0 /* is_zero_click */
55 ); 55 );
56 INSERT INTO "logins" VALUES( 56 INSERT INTO "logins" VALUES(
57 'https://accounts.google.com/ServiceLogin', /* origin_url */ 57 'https://accounts.google.com/ServiceLogin', /* origin_url */
58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
59 'Email', /* username_element */ 59 'Email', /* username_element */
60 'theerikchen2', /* username_value */ 60 'theerikchen2', /* username_value */
61 'Passwd', /* password_element */ 61 'Passwd', /* password_element */
62 X'', /* password_value */ 62 X'', /* password_value */
63 '', /* submit_element */ 63 '', /* submit_element */
64 'https://accounts.google.com/', /* signon_realm */ 64 'https://accounts.google.com/', /* signon_realm */
65 1, /* ssl_valid */ 65 1, /* ssl_valid */
66 1, /* preferred */ 66 1, /* preferred */
67 1402950000, /* date_created */ 67 13047423600000000, /* date_created */
68 0, /* blacklisted_by_user */ 68 0, /* blacklisted_by_user */
69 0, /* scheme */ 69 0, /* scheme */
70 0, /* password_type */ 70 0, /* password_type */
71 X'00000000', /* possible_usernames */ 71 X'00000000', /* possible_usernames */
72 1, /* times_used */ 72 1, /* times_used */
73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
74 NULL, /* use_additional_auth */ 74 NULL, /* use_additional_auth */
75 0, /* date_synced */ 75 0, /* date_synced */
76 '', /* display_name */ 76 '', /* display_name */
77 '', /* avatar_url */ 77 '', /* avatar_url */
78 '', /* federation_url */ 78 '', /* federation_url */
79 0 /* is_zero_click */ 79 0 /* is_zero_click */
80 ); 80 );
81 CREATE INDEX logins_signon ON logins (signon_realm); 81 CREATE INDEX logins_signon ON logins (signon_realm);
82 COMMIT; 82 COMMIT;
83 83
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698