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

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

Issue 2127533003: Remove PasswordForm::ssl_valid (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Adjust //ios Created 4 years, 5 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','14'); 4 INSERT INTO "meta" VALUES('last_compatible_version','18');
5 INSERT INTO "meta" VALUES('version','17'); 5 INSERT INTO "meta" VALUES('version','18');
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,
16 preferred INTEGER NOT NULL, 15 preferred INTEGER NOT NULL,
17 date_created INTEGER NOT NULL, 16 date_created INTEGER NOT NULL,
18 blacklisted_by_user INTEGER NOT NULL, 17 blacklisted_by_user INTEGER NOT NULL,
19 scheme INTEGER NOT NULL, 18 scheme INTEGER NOT NULL,
20 password_type INTEGER, 19 password_type INTEGER,
21 possible_usernames BLOB, 20 possible_usernames BLOB,
22 times_used INTEGER, 21 times_used INTEGER,
23 form_data BLOB, 22 form_data BLOB,
24 date_synced INTEGER, 23 date_synced INTEGER,
25 display_name VARCHAR, 24 display_name VARCHAR,
26 icon_url VARCHAR, 25 icon_url VARCHAR,
27 federation_url VARCHAR, 26 federation_url VARCHAR,
28 skip_zero_click INTEGER, 27 skip_zero_click INTEGER,
29 generation_upload_status INTEGER, 28 generation_upload_status INTEGER,
30 UNIQUE (origin_url, username_element, username_value, password_element, signon_r ealm)); 29 UNIQUE (origin_url, username_element, username_value, password_element, signon_r ealm));
31 INSERT INTO "logins" VALUES( 30 INSERT INTO "logins" VALUES(
32 'https://accounts.google.com/ServiceLogin', /* origin_url */ 31 'https://accounts.google.com/ServiceLogin', /* origin_url */
33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
34 'Email', /* username_element */ 33 'Email', /* username_element */
35 'theerikchen', /* username_value */ 34 'theerikchen', /* username_value */
36 'Passwd', /* password_element */ 35 'Passwd', /* password_element */
37 X'', /* password_value */ 36 X'', /* password_value */
38 '', /* submit_element */ 37 '', /* submit_element */
39 'https://accounts.google.com/', /* signon_realm */ 38 'https://accounts.google.com/', /* signon_realm */
40 1, /* ssl_valid */
41 1, /* preferred */ 39 1, /* preferred */
42 13047429345000000, /* date_created */ 40 13047429345000000, /* date_created */
43 0, /* blacklisted_by_user */ 41 0, /* blacklisted_by_user */
44 0, /* scheme */ 42 0, /* scheme */
45 0, /* password_type */ 43 0, /* password_type */
46 X'00000000', /* possible_usernames */ 44 X'00000000', /* possible_usernames */
47 1, /* times_used */ 45 1, /* times_used */
48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 46 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
49 0, /* date_synced */ 47 0, /* date_synced */
50 '', /* display_name */ 48 '', /* display_name */
51 '', /* icon_url */ 49 '', /* icon_url */
52 '', /* federation_url */ 50 '', /* federation_url */
53 1, /* skip_zero_click */ 51 1, /* skip_zero_click */
54 0 /* generation_upload_status */ 52 0 /* generation_upload_status */
55 ); 53 );
56 INSERT INTO "logins" VALUES( 54 INSERT INTO "logins" VALUES(
57 'https://accounts.google.com/ServiceLogin', /* origin_url */ 55 'https://accounts.google.com/ServiceLogin', /* origin_url */
58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ 56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
59 'Email', /* username_element */ 57 'Email', /* username_element */
60 'theerikchen2', /* username_value */ 58 'theerikchen2', /* username_value */
61 'Passwd', /* password_element */ 59 'Passwd', /* password_element */
62 X'', /* password_value */ 60 X'', /* password_value */
63 'non-empty', /* submit_element */ 61 'non-empty', /* submit_element */
64 'https://accounts.google.com/', /* signon_realm */ 62 'https://accounts.google.com/', /* signon_realm */
65 1, /* ssl_valid */
66 1, /* preferred */ 63 1, /* preferred */
67 13047423600000000, /* date_created */ 64 13047423600000000, /* date_created */
68 0, /* blacklisted_by_user */ 65 0, /* blacklisted_by_user */
69 0, /* scheme */ 66 0, /* scheme */
70 0, /* password_type */ 67 0, /* password_type */
71 X'00000000', /* possible_usernames */ 68 X'00000000', /* possible_usernames */
72 1, /* times_used */ 69 1, /* times_used */
73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ 70 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
74 0, /* date_synced */ 71 0, /* date_synced */
75 '', /* display_name */ 72 '', /* display_name */
76 'https://www.google.com/icon', /* icon_url */ 73 'https://www.google.com/icon', /* icon_url */
77 '', /* federation_url */ 74 '', /* federation_url */
78 1, /* skip_zero_click */ 75 1, /* skip_zero_click */
79 0 /* generation_upload_status */ 76 0 /* generation_upload_status */
80 ); 77 );
81 CREATE INDEX logins_signon ON logins (signon_realm); 78 CREATE INDEX logins_signon ON logins (signon_realm);
82 CREATE TABLE stats ( 79 CREATE TABLE stats (
83 origin_domain VARCHAR NOT NULL, 80 origin_domain VARCHAR NOT NULL,
84 username_value VARCHAR, 81 username_value VARCHAR,
85 dismissal_count INTEGER, 82 dismissal_count INTEGER,
86 update_time INTEGER NOT NULL, 83 update_time INTEGER NOT NULL,
87 UNIQUE(origin_domain, username_value)); 84 UNIQUE(origin_domain, username_value));
88 CREATE INDEX stats_origin ON stats(origin_domain); 85 CREATE INDEX stats_origin ON stats(origin_domain);
89 COMMIT; 86 COMMIT;
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698