diff options
| author |  Vitaly Takmazov | 2018-06-13 09:51:10 +0000 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-06-13 09:51:10 +0000 |
| commit | fc66845def283a0a6bb60128ced5653b61423351 (patch) | |
| tree | c5721950d7224aa759fb302452fa7746a3e07bdf | |
| parent | f60be392ab48917b3ad50dcab7cd804026af8483 (diff) | |
mysql: drop fulltext index
| -rw-r--r-- | juick-server-jdbc/src/main/resources/juick.sql | 5 |
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 |