aboutsummaryrefslogtreecommitdiff
path: root/juick-server-core/src/main/resources/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'juick-server-core/src/main/resources/schema.sql')
-rw-r--r--juick-server-core/src/main/resources/schema.sql21
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