From 60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Wed, 12 Apr 2017 20:21:56 -0700 Subject: remove fulltext indexes for innodb --- install/schema_mysql.sql | 8 +------- 1 file changed, 1 insertion(+), 7 deletions(-) (limited to 'install') 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` ( -- cgit v1.2.3