aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2015-12-17 10:51:24 +0300
committerGravatar Vitaly Takmazov2015-12-17 10:51:24 +0300
commita22533b7653c00b2c982946c4b2894167c5ad9f9 (patch)
treed3620b55a366474b11b516abe1c2ffa87ff89e9c
parent2def905ecd0f0182a3873da84b3d6acd302eaad9 (diff)
schema.sql: utf8mb4, ios table
-rw-r--r--schema.sql42
1 files changed, 29 insertions, 13 deletions
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 */;
@@ -198,6 +198,22 @@ CREATE TABLE `friends_facebook` (
/*!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