diff options
Diffstat (limited to 'juick-server-core/src/main/resources/schema.sql')
| -rw-r--r-- | juick-server-core/src/main/resources/schema.sql | 21 |
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 |