diff options
author | friendica <info@friendica.com> | 2011-11-18 22:04:41 -0800 |
---|---|---|
committer | friendica <info@friendica.com> | 2011-11-18 22:04:41 -0800 |
commit | fd4fe24406edb277814c7a45a6094a8eec0850d7 (patch) | |
tree | 7db5bceb30a569b035c600313a9dbbf66b14abac /database.sql | |
parent | 485f97b3d8937f219e2b9f3c662ee0e1966130eb (diff) | |
parent | 6893df991edfe971871a5db45055b40b871a7a4f (diff) | |
download | volse-hubzilla-fd4fe24406edb277814c7a45a6094a8eec0850d7.tar.gz volse-hubzilla-fd4fe24406edb277814c7a45a6094a8eec0850d7.tar.bz2 volse-hubzilla-fd4fe24406edb277814c7a45a6094a8eec0850d7.zip |
Merge branch 'master' into groups
Diffstat (limited to 'database.sql')
-rw-r--r-- | database.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 58b81b0ac..98067d8d6 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; -- -------------------------------------------------------- @@ -225,6 +226,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `unseen` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', `origin` tinyint(1) NOT NULL DEFAULT '0', + `forum_mode` tinyint(1) NOT NULL DEFAULT '0', `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `guid` (`guid`), @@ -243,10 +245,13 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `starred` (`starred`), KEY `deleted` (`deleted`), KEY `origin` (`origin`), + KEY `forum_mode` (`forum_mode`), 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 +446,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; |