Modify schema to include defaulting information.

chrome/browser/webdata/web_intents_table.cc

 // Copyright (c) 2011 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 "chrome/browser/webdata/web_intents_table.h"
 
 #include "base/logging.h"
 #include "base/utf_string_conversions.h"
 #include "googleurl/src/gurl.h"
 #include "sql/statement.h"
@@ skipping 37 matching lines @@
 }
 
 bool WebIntentsTable::Init() {
   if (db_->DoesTableExist("web_intents"))
     return true;
 
   if (!db_->Execute("CREATE TABLE web_intents ("
                     "service_url LONGVARCHAR,"
                     "action VARCHAR,"
                     "type VARCHAR,"
-                    "title VARCHAR,"
+                    "title LONGVARCHAR,"
                     "disposition VARCHAR,"
+                    "default_action VARCHAR,"

[James Hawkins, 2012/01/30 20:50:08]

These don't belong in the web_intents table.  Defaults are per-filter, so we
need new table web_intents_defaults that is keyed off action, type.

+                    "default_type VARCHAR,"
+                    "default_url LONGVARCHAR,"
+                    "default_user_date INTEGER,"
+                    "default_suppression INTEGER,"
                     "UNIQUE (service_url, action, type))")) {
     return false;
   }
 
   if (!db_->Execute("CREATE INDEX web_intents_index ON web_intents (action)"))
     return false;
 
   return true;
 }
 
@@ skipping 64 matching lines @@
     const WebIntentServiceData& service) {
   sql::Statement s(db_->GetUniqueStatement(
       "DELETE FROM web_intents "
       "WHERE service_url = ? AND action = ? AND type = ?"));
   s.BindString(0, service.service_url.spec());
   s.BindString16(1, service.action);
   s.BindString16(2, service.type);
 
   return s.Run();
 }