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; |