Index: components/test/data/password_manager/login_db_v2.sql |
diff --git a/components/test/data/password_manager/login_db_v2.sql b/components/test/data/password_manager/login_db_v2.sql |
new file mode 100644 |
index 0000000000000000000000000000000000000000..d9776c5059ded8292148e99f67d276ef6fe0e0f9 |
--- /dev/null |
+++ b/components/test/data/password_manager/login_db_v2.sql |
@@ -0,0 +1,59 @@ |
+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','1'); |
+INSERT INTO "meta" VALUES('version','2'); |
+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, |
+ssl_valid INTEGER NOT NULL, |
+preferred INTEGER NOT NULL, |
+date_created INTEGER NOT NULL, |
+blacklisted_by_user INTEGER NOT NULL, |
+scheme INTEGER NOT NULL, |
+password_type INTEGER, |
+possible_usernames BLOB, |
+UNIQUE (origin_url, username_element, username_value, password_element, submit_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, /* ssl_valid */ |
+1, /* preferred */ |
+1402955745, /* date_created */ |
+0, /* blacklisted_by_user */ |
+0, /* scheme */ |
+0, /* password_type */ |
+X'00000000' /* possible_usernames */ |
+); |
+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 */ |
+'', /* submit_element */ |
+'https://accounts.google.com/', /* signon_realm */ |
+1, /* ssl_valid */ |
+1, /* preferred */ |
+1402950000, /* date_created */ |
+0, /* blacklisted_by_user */ |
+0, /* scheme */ |
+0, /* password_type */ |
+X'00000000' /* possible_usernames */ |
+); |
+CREATE INDEX logins_signon ON logins (signon_realm); |
+COMMIT; |
+ |