aboutsummaryrefslogtreecommitdiff
path: root/juick-server-core/src/main
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2017-12-22 09:10:46 +0000
committerGravatar Vitaly Takmazov2017-12-22 12:34:13 +0300
commit8c95c51f0bc226a2ec277d54154760898ccd6f32 (patch)
tree8de95c033ca9efe3c457e50b29b00d44d7f16251 /juick-server-core/src/main
parent413e12a9e5e7ec2e8e5b72e9e99e2da616537397 (diff)
jdbc: update schema
Diffstat (limited to 'juick-server-core/src/main')
-rw-r--r--juick-server-core/src/main/resources/schema.sql21
1 files changed, 17 insertions, 4 deletions
diff --git a/juick-server-core/src/main/resources/schema.sql b/juick-server-core/src/main/resources/schema.sql
index 90bb4ed4..ec41f0d2 100644
--- a/juick-server-core/src/main/resources/schema.sql
+++ b/juick-server-core/src/main/resources/schema.sql
@@ -1,9 +1,9 @@
--- MySQL dump 10.13 Distrib 5.5.44, for debian-linux-gnu (x86_64)
+-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: juick
-- ------------------------------------------------------
--- Server version 5.5.44-0+deb8u1-log
use juick;
+-- Server version 10.1.26-MariaDB-0+deb9u1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
@@ -318,6 +318,7 @@ CREATE TABLE `messages` (
`popular` tinyint(4) NOT NULL DEFAULT '0',
`hidden` tinyint(3) unsigned NOT NULL DEFAULT '0',
`likes` smallint(6) NOT NULL DEFAULT '0',
+ `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`message_id`),
KEY `user_id` (`user_id`),
KEY `ts` (`ts`),
@@ -609,7 +610,7 @@ DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
`tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`synonym_id` int(10) unsigned DEFAULT NULL,
- `name` char(70) DEFAULT NULL,
+ `name` char(70) CHARACTER SET utf8mb4 DEFAULT NULL,
`top` tinyint(1) unsigned NOT NULL DEFAULT '0',
`noindex` tinyint(1) unsigned NOT NULL DEFAULT '0',
`stat_messages` int(10) unsigned NOT NULL DEFAULT '0',
@@ -824,6 +825,18 @@ CREATE TABLE `usersinfo` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `version`
+--
+
+DROP TABLE IF EXISTS `version`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `version` (
+ `version` bigint(20) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `vk`
--
@@ -882,4 +895,4 @@ CREATE TABLE `wl_users` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2016-09-03 14:32:11
+-- Dump completed on 2017-12-22 9:08:54