From 170503cf246d2d3f1b99f9adb26fa181690646c6 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 12 Jan 2018 06:47:29 +0000
Subject: server-core: schema update

---
 juick-server-core/src/main/resources/schema.sql | 21 +++++++++++++++++++--
 1 file changed, 19 insertions(+), 2 deletions(-)

(limited to 'juick-server-core')

diff --git a/juick-server-core/src/main/resources/schema.sql b/juick-server-core/src/main/resources/schema.sql
index ec41f0d2..518c89ab 100644
--- a/juick-server-core/src/main/resources/schema.sql
+++ b/juick-server-core/src/main/resources/schema.sql
@@ -325,7 +325,8 @@ CREATE TABLE `messages` (
   KEY `attach` (`attach`),
   KEY `place_id` (`place_id`),
   KEY `popular` (`popular`),
-  KEY `hidden` (`hidden`)
+  KEY `hidden` (`hidden`),
+  KEY `updated_indx` (`updated`,`message_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -390,6 +391,22 @@ CREATE TABLE `messages_votes` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `messenger`
+--
+
+DROP TABLE IF EXISTS `messenger`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `messenger` (
+  `user_id` int(10) unsigned DEFAULT NULL,
+  `sender_id` bigint(20) NOT NULL,
+  `display_name` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `loginhash` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Table structure for table `places`
 --
@@ -895,4 +912,4 @@ CREATE TABLE `wl_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2017-12-22  9:08:54
+-- Dump completed on 2018-01-12  6:45:30
-- 
cgit v1.2.3