From 794c92a8fb789f604c869e9adabf5aae24cd90d6 Mon Sep 17 00:00:00 2001 From: friendica 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