| Index: components/test/data/password_manager/login_db_v19.sql
|
| diff --git a/components/test/data/password_manager/login_db_v19.sql b/components/test/data/password_manager/login_db_v19.sql
|
| deleted file mode 100644
|
| index 640a5bd96b4a8310b6b698199f9db0588bfaecd5..0000000000000000000000000000000000000000
|
| --- a/components/test/data/password_manager/login_db_v19.sql
|
| +++ /dev/null
|
| @@ -1,110 +0,0 @@
|
| -PRAGMA foreign_keys=OFF;
|
| -BEGIN TRANSACTION;
|
| -CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
|
| -INSERT INTO "meta" VALUES('last_compatible_version','18');
|
| -INSERT INTO "meta" VALUES('version','18');
|
| -CREATE TABLE logins (
|
| -origin_url VARCHAR NOT NULL,
|
| -action_url VARCHAR,
|
| -username_element VARCHAR,
|
| -username_value VARCHAR,
|
| -password_element VARCHAR,
|
| -password_value BLOB,
|
| -submit_element VARCHAR,
|
| -signon_realm VARCHAR NOT NULL,
|
| -preferred INTEGER NOT NULL,
|
| -date_created INTEGER NOT NULL,
|
| -blacklisted_by_user INTEGER NOT NULL,
|
| -scheme INTEGER NOT NULL,
|
| -password_type INTEGER,
|
| -times_used INTEGER,
|
| -form_data BLOB,
|
| -date_synced INTEGER,
|
| -display_name VARCHAR,
|
| -icon_url VARCHAR,
|
| -federation_url VARCHAR,
|
| -skip_zero_click INTEGER,
|
| -generation_upload_status INTEGER,
|
| -possible_username_pairs BLOB,
|
| -UNIQUE (origin_url, username_element, username_value, password_element, signon_realm));
|
| -INSERT INTO "logins" VALUES(
|
| -'https://accounts.google.com/ServiceLogin', /* origin_url */
|
| -'https://accounts.google.com/ServiceLoginAuth', /* action_url */
|
| -'Email', /* username_element */
|
| -'theerikchen', /* username_value */
|
| -'Passwd', /* password_element */
|
| -X'', /* password_value */
|
| -'', /* submit_element */
|
| -'https://accounts.google.com/', /* signon_realm */
|
| -1, /* preferred */
|
| -13047429345000000, /* date_created */
|
| -0, /* blacklisted_by_user */
|
| -0, /* scheme */
|
| -0, /* password_type */
|
| -1, /* times_used */
|
| -X'18000000020000000000000000000000000000000000000000000000', /* form_data */
|
| -0, /* date_synced */
|
| -'', /* display_name */
|
| -'', /* icon_url */
|
| -'', /* federation_url */
|
| -1, /* skip_zero_click */
|
| -0, /* generation_upload_status */
|
| -X'00000000' /* possible_username_pairs */
|
| -);
|
| -INSERT INTO "logins" VALUES(
|
| -'https://accounts.google.com/ServiceLogin', /* origin_url */
|
| -'https://accounts.google.com/ServiceLoginAuth', /* action_url */
|
| -'Email', /* username_element */
|
| -'theerikchen2', /* username_value */
|
| -'Passwd', /* password_element */
|
| -X'', /* password_value */
|
| -'non-empty', /* submit_element */
|
| -'https://accounts.google.com/', /* signon_realm */
|
| -1, /* preferred */
|
| -13047423600000000, /* date_created */
|
| -0, /* blacklisted_by_user */
|
| -0, /* scheme */
|
| -0, /* password_type */
|
| -1, /* times_used */
|
| -X'18000000020000000000000000000000000000000000000000000000', /* form_data */
|
| -0, /* date_synced */
|
| -'', /* display_name */
|
| -'https://www.google.com/icon', /* icon_url */
|
| -'', /* federation_url */
|
| -1, /* skip_zero_click */
|
| -0, /* generation_upload_status */
|
| -X'00000000' /* possible_username_pairs */
|
| -);
|
| -INSERT INTO "logins" VALUES(
|
| -'http://example.com', /* origin_url */
|
| -'http://example.com/landing', /* action_url */
|
| -'', /* username_element */
|
| -'user', /* username_value */
|
| -'', /* password_element */
|
| -X'', /* password_value */
|
| -'non-empty', /* submit_element */
|
| -'http://example.com', /* signon_realm */
|
| -1, /* preferred */
|
| -13047423600000000, /* date_created */
|
| -0, /* blacklisted_by_user */
|
| -1, /* scheme */
|
| -0, /* password_type */
|
| -1, /* times_used */
|
| -X'18000000020000000000000000000000000000000000000000000000', /* form_data */
|
| -0, /* date_synced */
|
| -'', /* display_name */
|
| -'https://www.google.com/icon', /* icon_url */
|
| -'', /* federation_url */
|
| -1, /* skip_zero_click */
|
| -0, /* generation_upload_status */
|
| -X'00000000' /* possible_username_pairs */
|
| -);
|
| -CREATE INDEX logins_signon ON logins (signon_realm);
|
| -CREATE TABLE stats (
|
| -origin_domain VARCHAR NOT NULL,
|
| -username_value VARCHAR,
|
| -dismissal_count INTEGER,
|
| -update_time INTEGER NOT NULL,
|
| -UNIQUE(origin_domain, username_value));
|
| -CREATE INDEX stats_origin ON stats(origin_domain);
|
| -COMMIT;
|
|
|