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

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

Issue 2747733004: [Password Manager] Send username correction votes (Closed)
Patch Set: Changes addressed to reviewer comments Created 3 years, 9 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
(Empty)
1 PRAGMA foreign_keys=OFF;
2 BEGIN TRANSACTION;
3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR );
4 INSERT INTO "meta" VALUES('last_compatible_version','18');
5 INSERT INTO "meta" VALUES('version','18');
6 CREATE TABLE logins (
7 origin_url VARCHAR NOT NULL,
8 action_url VARCHAR,
9 username_element VARCHAR,
10 username_value VARCHAR,
11 password_element VARCHAR,
12 password_value BLOB,
13 submit_element VARCHAR,
14 signon_realm VARCHAR NOT NULL,
15 preferred INTEGER NOT NULL,
16 date_created INTEGER NOT NULL,
17 blacklisted_by_user INTEGER NOT NULL,
18 scheme INTEGER NOT NULL,
19 password_type INTEGER,
20 times_used INTEGER,
21 form_data BLOB,
22 date_synced INTEGER,
23 display_name VARCHAR,
24 icon_url VARCHAR,
25 federation_url VARCHAR,
26 skip_zero_click INTEGER,
27 generation_upload_status INTEGER,
28 possible_username_pairs BLOB,
29 UNIQUE (origin_url, username_element, username_value, password_element, signon_r ealm));
30 INSERT INTO "logins" VALUES(
31 'https://accounts.google.com/ServiceLogin', /* origin_url */
32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
33 'Email', /* username_element */
34 'theerikchen', /* username_value */
35 'Passwd', /* password_element */
36 X'', /* password_value */
37 '', /* submit_element */
38 'https://accounts.google.com/', /* signon_realm */
39 1, /* preferred */
40 13047429345000000, /* date_created */
41 0, /* blacklisted_by_user */
42 0, /* scheme */
43 0, /* password_type */
44 1, /* times_used */
45 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
46 0, /* date_synced */
47 '', /* display_name */
48 '', /* icon_url */
49 '', /* federation_url */
50 1, /* skip_zero_click */
51 0, /* generation_upload_status */
52 X'00000000' /* possible_username_pairs */
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 'theerikchen2', /* username_value */
59 'Passwd', /* password_element */
60 X'', /* password_value */
61 'non-empty', /* submit_element */
62 'https://accounts.google.com/', /* signon_realm */
63 1, /* preferred */
64 13047423600000000, /* date_created */
65 0, /* blacklisted_by_user */
66 0, /* scheme */
67 0, /* password_type */
68 1, /* times_used */
69 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
70 0, /* date_synced */
71 '', /* display_name */
72 'https://www.google.com/icon', /* icon_url */
73 '', /* federation_url */
74 1, /* skip_zero_click */
75 0, /* generation_upload_status */
76 X'00000000' /* possible_username_pairs */
77 );
78 INSERT INTO "logins" VALUES(
79 'http://example.com', /* origin_url */
80 'http://example.com/landing', /* action_url */
81 '', /* username_element */
82 'user', /* username_value */
83 '', /* password_element */
84 X'', /* password_value */
85 'non-empty', /* submit_element */
86 'http://example.com', /* signon_realm */
87 1, /* preferred */
88 13047423600000000, /* date_created */
89 0, /* blacklisted_by_user */
90 1, /* scheme */
91 0, /* password_type */
92 1, /* times_used */
93 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
94 0, /* date_synced */
95 '', /* display_name */
96 'https://www.google.com/icon', /* icon_url */
97 '', /* federation_url */
98 1, /* skip_zero_click */
99 0, /* generation_upload_status */
100 X'00000000' /* possible_username_pairs */
101 );
102 CREATE INDEX logins_signon ON logins (signon_realm);
103 CREATE TABLE stats (
104 origin_domain VARCHAR NOT NULL,
105 username_value VARCHAR,
106 dismissal_count INTEGER,
107 update_time INTEGER NOT NULL,
108 UNIQUE(origin_domain, username_value));
109 CREATE INDEX stats_origin ON stats(origin_domain);
110 COMMIT;
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698