diff options
| author | Fabio Comuni <fabrix.xm@gmail.com> | 2011-11-17 13:40:27 +0100 |
|---|---|---|
| committer | Fabio Comuni <fabrix.xm@gmail.com> | 2011-11-17 13:40:27 +0100 |
| commit | 844a36e2b6c9cd8e934b57b7d56b7a9863f12929 (patch) | |
| tree | 3ba5f23865643ff8c660fb9c9a9eeb44327b8a1b /database.sql | |
| parent | 02281be0c3b19bcab3ae3a96475846104af11e92 (diff) | |
| parent | c9846b745dfe2a4c20ffe4e1f48bb18da3886fd4 (diff) | |
| download | volse-hubzilla-844a36e2b6c9cd8e934b57b7d56b7a9863f12929.tar.gz volse-hubzilla-844a36e2b6c9cd8e934b57b7d56b7a9863f12929.tar.bz2 volse-hubzilla-844a36e2b6c9cd8e934b57b7d56b7a9863f12929.zip | |
Merge remote-tracking branch 'friendica/master'
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 58b81b0ac..924cc49b2 100644 --- a/database.sql +++ b/database.sql @@ -113,7 +113,8 @@ CREATE TABLE IF NOT EXISTS `contact` ( KEY `issued-id` (`issued-id`), KEY `dfrn-id` (`dfrn-id`), KEY `blocked` (`blocked`), - KEY `readonly` (`readonly`) + KEY `readonly` (`readonly`), + KEY `pending` (`pending`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -245,8 +246,10 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `origin` (`origin`), KEY `last-child` (`last-child`), KEY `unseen` (`unseen`), + KEY `wall` (`wall`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), + FULLTEXT KEY `tag` (`tag`), FULLTEXT KEY `allow_cid` (`allow_cid`), FULLTEXT KEY `allow_gid` (`allow_gid`), FULLTEXT KEY `deny_cid` (`deny_cid`), @@ -441,6 +444,10 @@ CREATE TABLE IF NOT EXISTS `user` ( PRIMARY KEY (`uid`), KEY `nickname` (`nickname`), KEY `account_expired` (`account_expired`), + KEY `hidewall` (`hidewall`), + KEY `blockwall` (`blockwall`), + KEY `blocked` (`blocked`), + KEY `verified` (`verified`), KEY `login_date` (`login_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |