| 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
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..640a5bd96b4a8310b6b698199f9db0588bfaecd5
|
| --- /dev/null
|
| +++ b/components/test/data/password_manager/login_db_v19.sql
|
| @@ -0,0 +1,110 @@
|
| +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;
|
|
|