Revive the statistics database for storing interaction history with the "Save password" bubble.

BUG=552010

Review URL: https://codereview.chromium.org/1413993008

Cr-Commit-Position: refs/heads/master@{#358318}

4 files changed, 102 insertions, 0 deletions

diff --git a/components/test/data/password_manager/login_db_v12.sql b/components/test/data/password_manager/login_db_v12.sql
index 9530fb5..c25cb0e 100644
--- a/components/test/data/password_manager/login_db_v12.sql
+++ b/components/test/data/password_manager/login_db_v12.sql
@@ -79,4 +79,9 @@ X'18000000020000000000000000000000000000000000000000000000', /* form_data */
 0  /* generation_upload_status */
 );
 CREATE INDEX logins_signon ON logins (signon_realm);
+CREATE TABLE stats (
+origin_domain VARCHAR NOT NULL PRIMARY KEY, 
+nopes_count INTEGER,
+dismissal_count INTEGER, 
+start_date INTEGER NOT NULL);
 COMMIT;
diff --git a/components/test/data/password_manager/login_db_v13.sql b/components/test/data/password_manager/login_db_v13.sql
index 451c3e4..c71773f 100644
--- a/components/test/data/password_manager/login_db_v13.sql
+++ b/components/test/data/password_manager/login_db_v13.sql
@@ -79,4 +79,9 @@ X'18000000020000000000000000000000000000000000000000000000', /* form_data */
 0  /* generation_upload_status */
 );
 CREATE INDEX logins_signon ON logins (signon_realm);
+CREATE TABLE stats (
+origin_domain VARCHAR NOT NULL PRIMARY KEY, 
+nopes_count INTEGER,
+dismissal_count INTEGER, 
+start_date INTEGER NOT NULL);
 COMMIT;
diff --git a/components/test/data/password_manager/login_db_v14.sql b/components/test/data/password_manager/login_db_v14.sql
index 063260f..cdf4b31 100644
--- a/components/test/data/password_manager/login_db_v14.sql
+++ b/components/test/data/password_manager/login_db_v14.sql
@@ -79,4 +79,9 @@ X'18000000020000000000000000000000000000000000000000000000', /* form_data */
 0  /* generation_upload_status */
 );
 CREATE INDEX logins_signon ON logins (signon_realm);
+CREATE TABLE stats (
+origin_domain VARCHAR NOT NULL PRIMARY KEY, 
+nopes_count INTEGER,
+dismissal_count INTEGER, 
+start_date INTEGER NOT NULL);
 COMMIT;
diff --git a/components/test/data/password_manager/login_db_v15.sql b/components/test/data/password_manager/login_db_v15.sql
new file mode 100644
index 0000000..9e3af8f
--- /dev/null
+++ b/components/test/data/password_manager/login_db_v15.sql
@@ -0,0 +1,87 @@
+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','14');
+INSERT INTO "meta" VALUES('version','15');
+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,
+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,
+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, /* ssl_valid */
+1, /* preferred */
+13047429345000000, /* date_created */
+0, /* blacklisted_by_user */
+0, /* scheme */
+0, /* password_type */
+X'00000000', /* possible_usernames */
+1, /* times_used */
+X'18000000020000000000000000000000000000000000000000000000', /* form_data */
+0, /* date_synced */
+'', /* display_name */
+'', /* icon_url */
+'', /* federation_url */
+0,  /* skip_zero_click */
+0  /* generation_upload_status */
+);
+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, /* ssl_valid */
+1, /* preferred */
+13047423600000000, /* date_created */
+0, /* blacklisted_by_user */
+0, /* scheme */
+0, /* password_type */
+X'00000000', /* possible_usernames */
+1, /* times_used */
+X'18000000020000000000000000000000000000000000000000000000', /* form_data */
+0, /* date_synced */
+'', /* display_name */
+'https://www.google.com/icon', /* icon_url */
+'', /* federation_url */
+0,  /* skip_zero_click */
+0  /* generation_upload_status */
+);
+CREATE INDEX logins_signon ON logins (signon_realm);
+CREATE TABLE stats (
+origin_domain VARCHAR NOT NULL PRIMARY KEY,
+nopes_count INTEGER,
+dismissal_count INTEGER,
+start_date INTEGER NOT NULL);
+COMMIT;