CREATE TABLE `posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`channel_id` int(11) DEFAULT 0,
`pub` int(1) DEFAULT 0,
`message_id` int(11) DEFAULT 0,
`message` text DEFAULT NULL,
`created` timestamp NULL DEFAULT current_timestamp(),
`hash` char(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `HASH` (`hash`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3436 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;