From f60be392ab48917b3ad50dcab7cd804026af8483 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 13 Jun 2018 09:48:19 +0000
Subject: mysql schema changes

---
 juick-server-jdbc/src/main/resources/juick.sql | 28 ++++++++++++++++++++------
 1 file changed, 22 insertions(+), 6 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 eb14a3e4..3571dfef 100644
--- a/juick-server-jdbc/src/main/resources/juick.sql
+++ b/juick-server-jdbc/src/main/resources/juick.sql
@@ -155,12 +155,12 @@ DROP TABLE IF EXISTS `facebook`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `facebook` (
   `user_id` int(10) unsigned DEFAULT NULL,
-  `fb_id` bigint(20) unsigned NOT NULL,
+  `fb_id` bigint(20) unsigned DEFAULT NULL,
   `loginhash` char(36) DEFAULT NULL,
   `access_token` char(255) DEFAULT NULL,
   `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  `fb_name` char(64) NOT NULL,
-  `fb_link` char(255) NOT NULL,
+  `fb_name` char(64) DEFAULT NULL,
+  `fb_link` char(255) DEFAULT NULL,
   `crosspost` tinyint(1) unsigned NOT NULL DEFAULT '1',
   KEY `user_id` (`user_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -178,7 +178,6 @@ CREATE TABLE `favorites` (
   `message_id` int(10) unsigned NOT NULL,
   `ts` datetime NOT NULL,
   `like_id` int(10) unsigned NOT NULL DEFAULT '1',
-  UNIQUE KEY `user_id_2` (`user_id`,`message_id`),
   KEY `user_id` (`user_id`),
   KEY `message_id` (`message_id`),
   KEY `like_id` (`like_id`)
@@ -572,6 +571,22 @@ CREATE TABLE `replies` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `search`
+--
+
+DROP TABLE IF EXISTS `search`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search` (
+  `id` bigint(20) unsigned NOT NULL,
+  `weight` int(11) NOT NULL,
+  `query` varchar(3072) NOT NULL,
+  `group_id` int(11) DEFAULT NULL,
+  KEY `query` (`query`(768))
+) ENGINE=SPHINX DEFAULT CHARSET=utf8mb4 CONNECTION='sphinx://127.0.0.1:3312/messages';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Table structure for table `sphinx`
 --
@@ -650,7 +665,8 @@ CREATE TABLE `tags` (
   `stat_messages` int(10) unsigned NOT NULL DEFAULT '0',
   `stat_users` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`tag_id`),
-  KEY `synonym_id` (`synonym_id`)
+  KEY `synonym_id` (`synonym_id`),
+  KEY `stat_msg_indx` (`name`,`stat_messages`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -929,4 +945,4 @@ CREATE TABLE `wl_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2018-04-20  7:47:13
+-- Dump completed on 2018-06-13  9:46:24
-- 
cgit v1.2.3

