aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-04-12 20:21:56 -0700
committerzotlabs <mike@macgirvin.com>2017-04-12 20:21:56 -0700
commit60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096 (patch)
tree3990f5d7ae5b2ba354868510396e9b6626cfdc0c
parent4a6a06fdc04963a8ad16ecd918d1d59d7be2bd14 (diff)
downloadvolse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.tar.gz
volse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.tar.bz2
volse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.zip
remove fulltext indexes for innodb
-rw-r--r--install/schema_mysql.sql8
1 files changed, 1 insertions, 7 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index adcb204bb..7964c2a6a 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -669,13 +669,7 @@ CREATE TABLE IF NOT EXISTS `item` (
KEY `item_unpublished` (`item_unpublished`),
KEY `item_delayed` (`item_delayed`),
KEY `item_pending_remove` (`item_pending_remove`),
- KEY `item_blocked` (`item_blocked`),
- FULLTEXT KEY `title` (`title`),
- FULLTEXT KEY `body` (`body`),
- FULLTEXT KEY `allow_cid` (`allow_cid`),
- FULLTEXT KEY `allow_gid` (`allow_gid`),
- FULLTEXT KEY `deny_cid` (`deny_cid`),
- FULLTEXT KEY `deny_gid` (`deny_gid`)
+ KEY `item_blocked` (`item_blocked`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `item_id` (