From fc66845def283a0a6bb60128ced5653b61423351 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 13 Jun 2018 09:51:10 +0000
Subject: mysql: drop fulltext index

---
 juick-server-jdbc/src/main/resources/juick.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'juick-server-jdbc/src/main/resources/juick.sql')

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
-- 
cgit v1.2.3

