From 9da61d34184aa31d52c7d5da37508f1ba3770f1a Mon Sep 17 00:00:00 2001
From: Mike Macgirvin <mike@macgirvin.com>
Date: Tue, 5 Oct 2010 15:39:32 -0700
Subject: schema was out of date

---
 database.sql | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 78c7d27c2..1f1f4d1d4 100644
--- a/database.sql
+++ b/database.sql
@@ -53,6 +53,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `self` tinyint(1) NOT NULL DEFAULT '0',
   `rel` tinyint(1) NOT NULL DEFAULT '0',
+  `duplex` tinyint(1) NOT NULL DEFAULT '0',
   `network` char(255) NOT NULL,
   `name` char(255) NOT NULL,
   `photo` text NOT NULL, 
@@ -76,6 +77,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
   `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `term-date` datetime NOT NULL DEFAUL '0000-00-00 00:00:00',
   `priority` tinyint(3) NOT NULL,
   `blocked` tinyint(1) NOT NULL DEFAULT '1',
   `readonly` tinyint(1) NOT NULL DEFAULT '0',
@@ -131,6 +133,7 @@ CREATE TABLE IF NOT EXISTS `intro` (
   `uid` int(10) unsigned NOT NULL,
   `contact-id` int(11) NOT NULL,
   `knowyou` tinyint(1) NOT NULL,
+  `duplex` tinyint(1) NOT NULL DEFAULT '0',
   `note` text NOT NULL,
   `hash` char(255) NOT NULL,
   `datetime` datetime NOT NULL,
@@ -166,9 +169,10 @@ CREATE TABLE IF NOT EXISTS `item` (
   `author-avatar` char(255) NOT NULL,
   `title` char(255) NOT NULL,
   `body` text NOT NULL,
+  `verb` char(255) NOT NULL,
+  `object-type` char(255) NOT NULL,
+  `object` text NOT NULL,
   `resource-id` char(255) NOT NULL,
-  `like` mediumtext NOT NULL,
-  `dislike` mediumtext NOT NULL,
   `tag` mediumtext NOT NULL,
   `location` char(255) NOT NULL,
   `coord` char(255) NOT NULL,
-- 
cgit v1.2.3

