diff options
| author | friendica <info@friendica.com> | 2012-10-10 17:58:56 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-10-10 17:58:56 -0700 |
| commit | 794c92a8fb789f604c869e9adabf5aae24cd90d6 (patch) | |
| tree | a9a905f2729ef70d19e62bea2b2849a05230670b /database.sql | |
| parent | 602960460a6206f20ec9cb69b3f5214391b8ddc4 (diff) | |
| download | volse-hubzilla-794c92a8fb789f604c869e9adabf5aae24cd90d6.tar.gz volse-hubzilla-794c92a8fb789f604c869e9adabf5aae24cd90d6.tar.bz2 volse-hubzilla-794c92a8fb789f604c869e9adabf5aae24cd90d6.zip | |
wall posts now display - address book structure revamp started
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 5 insertions, 3 deletions
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` ( |