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

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

Issue 1083293004: Implement the statistics table for the passwords. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: address the comments Created 5 years, 8 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/password_manager/core/browser/test_password_store.cc ('k') | no next file » | 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','11'); 5 INSERT INTO "meta" VALUES('version','12');
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,
16 preferred INTEGER NOT NULL, 16 preferred INTEGER NOT NULL,
17 date_created INTEGER NOT NULL, 17 date_created INTEGER NOT NULL,
18 blacklisted_by_user INTEGER NOT NULL, 18 blacklisted_by_user INTEGER NOT NULL,
19 scheme INTEGER NOT NULL, 19 scheme INTEGER NOT NULL,
20 password_type INTEGER, 20 password_type INTEGER,
21 possible_usernames BLOB, 21 possible_usernames BLOB,
22 times_used INTEGER, 22 times_used INTEGER,
23 form_data BLOB, 23 form_data BLOB,
24 date_synced INTEGER, 24 date_synced INTEGER,
25 display_name VARCHAR, 25 display_name VARCHAR,
26 avatar_url VARCHAR, 26 avatar_url VARCHAR,
27 federation_url VARCHAR, 27 federation_url VARCHAR,
28 skip_zero_click INTEGER, 28 skip_zero_click INTEGER,
29 generation_upload_status INTEGER,
29 UNIQUE (origin_url, username_element, username_value, password_element, signon_r ealm)); 30 UNIQUE (origin_url, username_element, username_value, password_element, signon_r ealm));
30 INSERT INTO "logins" VALUES( 31 INSERT INTO "logins" VALUES(
31 'https://accounts.google.com/ServiceLogin', /* origin_url */ 32 'https://accounts.google.com/ServiceLogin', /* origin_url */
32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
33 'Email', /* username_element */ 34 'Email', /* username_element */
34 'theerikchen', /* username_value */ 35 'theerikchen', /* username_value */
35 'Passwd', /* password_element */ 36 'Passwd', /* password_element */
36 X'', /* password_value */ 37 X'', /* password_value */
37 '', /* submit_element */ 38 '', /* submit_element */
38 'https://accounts.google.com/', /* signon_realm */ 39 'https://accounts.google.com/', /* signon_realm */
39 1, /* ssl_valid */ 40 1, /* ssl_valid */
40 1, /* preferred */ 41 1, /* preferred */
41 13047429345000000, /* date_created */ 42 13047429345000000, /* date_created */
42 0, /* blacklisted_by_user */ 43 0, /* blacklisted_by_user */
43 0, /* scheme */ 44 0, /* scheme */
44 0, /* password_type */ 45 0, /* password_type */
45 X'00000000', /* possible_usernames */ 46 X'00000000', /* possible_usernames */
46 1, /* times_used */ 47 1, /* times_used */
47 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
48 0, /* date_synced */ 49 0, /* date_synced */
49 '', /* display_name */ 50 '', /* display_name */
50 '', /* avatar_url */ 51 '', /* avatar_url */
51 '', /* federation_url */ 52 '', /* federation_url */
52 0 /* skip_zero_click */ 53 0, /* skip_zero_click */
54 0 /* generation_upload_status */
53 ); 55 );
54 INSERT INTO "logins" VALUES( 56 INSERT INTO "logins" VALUES(
55 'https://accounts.google.com/ServiceLogin', /* origin_url */ 57 'https://accounts.google.com/ServiceLogin', /* origin_url */
56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
57 'Email', /* username_element */ 59 'Email', /* username_element */
58 'theerikchen2', /* username_value */ 60 'theerikchen2', /* username_value */
59 'Passwd', /* password_element */ 61 'Passwd', /* password_element */
60 X'', /* password_value */ 62 X'', /* password_value */
61 'non-empty', /* submit_element */ 63 'non-empty', /* submit_element */
62 'https://accounts.google.com/', /* signon_realm */ 64 'https://accounts.google.com/', /* signon_realm */
63 1, /* ssl_valid */ 65 1, /* ssl_valid */
64 1, /* preferred */ 66 1, /* preferred */
65 13047423600000000, /* date_created */ 67 13047423600000000, /* date_created */
66 0, /* blacklisted_by_user */ 68 0, /* blacklisted_by_user */
67 0, /* scheme */ 69 0, /* scheme */
68 0, /* password_type */ 70 0, /* password_type */
69 X'00000000', /* possible_usernames */ 71 X'00000000', /* possible_usernames */
70 1, /* times_used */ 72 1, /* times_used */
71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
72 0, /* date_synced */ 74 0, /* date_synced */
73 '', /* display_name */ 75 '', /* display_name */
74 '', /* avatar_url */ 76 '', /* avatar_url */
75 '', /* federation_url */ 77 '', /* federation_url */
76 0 /* skip_zero_click */ 78 0, /* skip_zero_click */
79 0 /* generation_upload_status */
77 ); 80 );
78 CREATE INDEX logins_signon ON logins (signon_realm); 81 CREATE INDEX logins_signon ON logins (signon_realm);
79 COMMIT; 82 COMMIT;
OLDNEW
« no previous file with comments | « components/password_manager/core/browser/test_password_store.cc ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698