aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-06-13 09:51:10 +0000
committerGravatar Vitaly Takmazov2018-06-13 09:51:10 +0000
commitfc66845def283a0a6bb60128ced5653b61423351 (patch)
treec5721950d7224aa759fb302452fa7746a3e07bdf
parentf60be392ab48917b3ad50dcab7cd804026af8483 (diff)
mysql: drop fulltext index
-rw-r--r--juick-server-jdbc/src/main/resources/juick.sql5
1 files changed, 2 insertions, 3 deletions
diff --git a/juick-server-jdbc/src/main/resources/juick.sql b/juick-server-jdbc/src/main/resources/juick.sql
index 3571dfef..ce34385f 100644
--- a/juick-server-jdbc/src/main/resources/juick.sql
+++ b/juick-server-jdbc/src/main/resources/juick.sql
@@ -373,8 +373,7 @@ CREATE TABLE `messages_txt` (
`tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`repliesby` varchar(96) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`txt` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
- PRIMARY KEY (`message_id`),
- FULLTEXT KEY `ft_idx` (`txt`)
+ PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -945,4 +944,4 @@ CREATE TABLE `wl_users` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2018-06-13 9:46:24
+-- Dump completed on 2018-06-13 9:49:48