diff options
| author |  Vitaly Takmazov | 2017-12-22 09:10:46 +0000 |
|---|---|---|
| committer | Vitaly Takmazov | 2017-12-22 12:34:13 +0300 |
| commit | 8c95c51f0bc226a2ec277d54154760898ccd6f32 (patch) | |
| tree | 8de95c033ca9efe3c457e50b29b00d44d7f16251 | |
| parent | 413e12a9e5e7ec2e8e5b72e9e99e2da616537397 (diff) | |
jdbc: update schema
| -rw-r--r-- | juick-server-core/src/main/resources/schema.sql | 21 |
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 |