CREATE TABLE `message` ( `id` int(11) NOT NULL, `message` text NOT NULL, `user` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `message` ADD PRIMARY KEY (`id`); ALTER TABLE `message` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;