From a22533b7653c00b2c982946c4b2894167c5ad9f9 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Thu, 17 Dec 2015 10:51:24 +0300
Subject: schema.sql: utf8mb4, ios table

---
 schema.sql | 42 +++++++++++++++++++++++++++++-------------
 1 file changed, 29 insertions(+), 13 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index bac5d3e7..d54d6937 100644
--- a/schema.sql
+++ b/schema.sql
@@ -7,7 +7,7 @@
 /*!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 */;
-/*!40101 SET NAMES utf8 */;
+/*!40101 SET NAMES utf8mb4 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -197,6 +197,22 @@ CREATE TABLE `friends_facebook` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `ios`
+--
+
+DROP TABLE IF EXISTS `ios`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ios` (
+  `user_id` int(10) unsigned NOT NULL,
+  `token` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  UNIQUE KEY `token` (`token`),
+  KEY `user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
 --
 -- Table structure for table `jids`
 --
@@ -257,7 +273,7 @@ CREATE TABLE `meon` (
   `name` char(32) NOT NULL,
   `ico` smallint(5) unsigned DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=10845 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=10850 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -290,7 +306,7 @@ CREATE TABLE `messages` (
   KEY `place_id` (`place_id`),
   KEY `popular` (`popular`),
   KEY `hidden` (`hidden`)
-) ENGINE=InnoDB AUTO_INCREMENT=2808011 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=2814769 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -332,11 +348,11 @@ DROP TABLE IF EXISTS `messages_txt`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `messages_txt` (
   `message_id` int(10) unsigned NOT NULL,
-  `tags` varchar(255) DEFAULT NULL,
-  `repliesby` varchar(96) DEFAULT NULL,
-  `txt` text NOT NULL,
+  `tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `repliesby` varchar(96) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `txt` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`message_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -494,12 +510,12 @@ CREATE TABLE `replies` (
   `user_id` int(10) unsigned NOT NULL,
   `replyto` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  `attach` enum('jpg','mp4','png') DEFAULT NULL,
-  `txt` text NOT NULL,
+  `attach` enum('jpg','mp4','png') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `txt` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   KEY `message_id` (`message_id`),
   KEY `user_id` (`user_id`),
   KEY `ts` (`ts`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -581,7 +597,7 @@ CREATE TABLE `tags` (
   `stat_users` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`tag_id`),
   KEY `synonym_id` (`synonym_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=114701 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=115285 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -708,7 +724,7 @@ CREATE TABLE `users` (
   `karma` smallint(6) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   UNIQUE KEY `nick` (`nick`)
-) ENGINE=InnoDB AUTO_INCREMENT=29575 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=29642 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -818,4 +834,4 @@ CREATE TABLE `wl_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-10-26 10:36:02
+-- Dump completed on 2015-12-17 10:49:43
-- 
cgit v1.2.3

