· 8 years ago · Jan 14, 2018, 09:18 PM
1SET NAMES utf8;
2SET time_zone = '+00:00';
3
4SET NAMES utf8mb4;
5
6DROP TABLE IF EXISTS `blocks`;
7CREATE TABLE `blocks` (
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
10 `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
11 `timestamp` int(11) NOT NULL,
12 `hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;