server-core: schema update

1 files changed, 19 insertions, 2 deletions

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 */;
 
@@ -391,6 +392,22 @@ CREATE TABLE `messages_votes` (
 /*!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