From 632c5570086bdfd8c8a311ccec44648697a8ef8b Mon Sep 17 00:00:00 2001
From: Mike Macgirvin <mike@macgirvin.com>
Date: Thu, 30 Sep 2010 21:00:06 -0700
Subject: pubsubhubbub db refinements

---
 database.sql | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index fd709878d..78c7d27c2 100644
--- a/database.sql
+++ b/database.sql
@@ -69,6 +69,9 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `confirm` text NOT NULL,
   `aes_allow` tinyint(1) NOT NULL DEFAULT '0',
   `ret-aes` tinyint(1) NOT NULL DEFAULT '0',
+  `usehub` tinyint(1) NOT NULL DEFAULT '0',
+  `subhub` tinyint(1) NOT NULL DEFAULT '0',
+  `hub-verify` char(255) NOT NULL,
   `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -80,7 +83,13 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `rating` tinyint(1) NOT NULL DEFAULT '0',
   `reason` text NOT NULL,
   `profile-id` int(11) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`id`)
+  PRIMARY KEY (`id`),
+  KEY `uid` (`uid`),
+  KEY `self` (`self`),
+  KEY `issued-id` (`issued-id`),
+  KEY `dfrn-id` (`dfrn-id`),
+  KEY `blocked` (`blocked`),
+  KEY `readonly` (`readonly`)  
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3

