Alter the ActivityLog db table schemas.

chrome/browser/extensions/url_actions.cc

Index: chrome/browser/extensions/url_actions.cc
diff --git a/chrome/browser/extensions/url_actions.cc b/chrome/browser/extensions/url_actions.cc
deleted file mode 100644
index 06dd541821372cd74a5d109d44e417503e8d3b60..0000000000000000000000000000000000000000
--- a/chrome/browser/extensions/url_actions.cc
+++ /dev/null
@@ -1,103 +0,0 @@
-// Copyright (c) 2013 The Chromium Authors. All rights reserved.
-// Use of this source code is governed by a BSD-style license that can be
-// found in the LICENSE file.
-
-#include "base/logging.h"
-#include "base/utf_string_conversions.h"
-#include "chrome/browser/extensions/url_actions.h"
-#include "content/public/browser/browser_thread.h"
-
-using content::BrowserThread;
-
-namespace extensions {
-
-const char* UrlAction::kTableName = "activitylog_urls";
-const char* UrlAction::kTableStructure = "("
-    "extension_id LONGVARCHAR NOT NULL, "
-    "time INTEGER NOT NULL, "
-    "url_action_type LONGVARCHAR NOT NULL, "
-    "url LONGVARCHAR NOT NULL, "
-    "url_title LONGVARCHAR, "
-    "tech_message LONGVARCHAR NOT NULL, "
-    "extra LONGCHAR VAR NOT NULL)";
-
-UrlAction::UrlAction(const std::string& extension_id,
-                     const base::Time& time,
-                     const UrlActionType verb,
-                     const GURL& url,
-                     const string16& url_title,
-                     const std::string& tech_message,
-                     const std::string& extra)
-    : extension_id_(extension_id),
-      time_(time),
-      verb_(verb),
-      url_(url),
-      url_title_(url_title),
-      technical_message_(tech_message),
-      extra_(extra) { }
-
-UrlAction::~UrlAction() {
-}
-
-void UrlAction::Record(sql::Connection* db) {
-  std::string sql_str = "INSERT INTO " + std::string(kTableName) +
-      " (extension_id, time, url_action_type, url, url_title, tech_message,"
-      "  extra) VALUES (?,?,?,?,?,?,?)";
-  sql::Statement statement(db->GetCachedStatement(
-      sql::StatementID(SQL_FROM_HERE), sql_str.c_str()));
-  statement.BindString(0, extension_id_);
-  statement.BindInt64(1, time_.ToInternalValue());
-  statement.BindString(2, VerbAsString());
-  statement.BindString(3, history::URLDatabase::GURLToDatabaseURL(url_));
-  statement.BindString16(4, url_title_);
-  statement.BindString(5, technical_message_);
-  statement.BindString(6, extra_);
-  if (!statement.Run())
-    LOG(ERROR) << "Activity log database I/O failed: " << sql_str;
-}
-
-std::string UrlAction::PrettyPrintFori18n() {
-  // TODO(felt): implement this for real when the UI is redesigned.
-  return PrettyPrintForDebug();
-}
-
-std::string UrlAction::PrettyPrintForDebug() {
-  // TODO(felt): implement this for real when the UI is redesigned.
-  return "Injected scripts (" + technical_message_ + ") onto "
-      + std::string(url_.spec());
-}
-
-std::string UrlAction::VerbAsString() const {
-  switch (verb_) {
-    case MODIFIED:
-      return "MODIFIED";
-    case READ:
-      return "READ";
-    case INSERTED:
-      return "INSERTED";
-    case XHR:
-      return "XHR";
-    default:
-      NOTREACHED();
-      return NULL;
-  }
-}
-
-UrlAction::UrlActionType UrlAction::StringAsUrlActionType(
-    const std::string& str) {
-  if (str == "MODIFIED") {
-    return MODIFIED;
-  } else if (str == "READ") {
-    return READ;
-  } else if (str == "INSERTED") {
-    return INSERTED;
-  } else if (str == "XHR") {
-    return XHR;
-  } else {
-    NOTREACHED();
-    return MODIFIED;  // this should never happen!
-  }
-}
-
-}  // namespace extensions
-