From 794c92a8fb789f604c869e9adabf5aae24cd90d6 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 10 Oct 2012 17:58:56 -0700
Subject: wall posts now display - address book structure revamp started

---
 database.sql | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 248502859..fc162833a 100644
--- a/database.sql
+++ b/database.sql
@@ -284,9 +284,10 @@ CREATE TABLE IF NOT EXISTS `deliverq` (
 
 CREATE TABLE IF NOT EXISTS `event` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
+  `account` int(10) unsigned NOT NULL DEFAULT '0',
   `uid` int(11) NOT NULL,
   `cid` int(11) NOT NULL,
-  `uri` char(255) NOT NULL,
+  `message_id` char(255) NOT NULL,
   `created` datetime NOT NULL,
   `edited` datetime NOT NULL,
   `start` datetime NOT NULL,
@@ -305,13 +306,14 @@ CREATE TABLE IF NOT EXISTS `event` (
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
   KEY `cid` (`cid`),
-  KEY `uri` (`uri`),
+  KEY `uri` (`message_id`),
   KEY `type` (`type`),
   KEY `start` (`start`),
   KEY `finish` (`finish`),
   KEY `adjust` (`adjust`),
   KEY `nofinish` (`nofinish`),
-  KEY `ignore` (`ignore`)
+  KEY `ignore` (`ignore`),
+  KEY `account` (`account`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `fcontact` (
-- 
cgit v1.2.3

