diff options
| author | zotlabs <mike@macgirvin.com> | 2017-04-12 20:21:56 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2017-04-12 20:21:56 -0700 |
| commit | 60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096 (patch) | |
| tree | 3990f5d7ae5b2ba354868510396e9b6626cfdc0c | |
| parent | 4a6a06fdc04963a8ad16ecd918d1d59d7be2bd14 (diff) | |
| download | volse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.tar.gz volse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.tar.bz2 volse-hubzilla-60d4b4c4f6ed9f41bdf2e8ec17e448f39f699096.zip | |
remove fulltext indexes for innodb
| -rw-r--r-- | install/schema_mysql.sql | 8 |
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` ( |