diff options
| author | friendica <info@friendica.com> | 2011-11-15 23:12:56 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2011-11-15 23:12:56 -0800 |
| commit | 7b58de743a5b0694792e744a004a37584a3c8ccb (patch) | |
| tree | 0a113759ae59e60a17b793e349376a153a006bbf /database.sql | |
| parent | 3bd2b731b2040e1025caef68e7da1f07907ae809 (diff) | |
| download | volse-hubzilla-7b58de743a5b0694792e744a004a37584a3c8ccb.tar.gz volse-hubzilla-7b58de743a5b0694792e744a004a37584a3c8ccb.tar.bz2 volse-hubzilla-7b58de743a5b0694792e744a004a37584a3c8ccb.zip | |
add a few more sql indexes
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; |