· 8 years ago · Jun 21, 2018, 11:32 AM
1CREATE TABLE IF NOT EXISTS `logs` (
2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `message` varchar(1000) NOT NULL,
4 `priority` tinyint(4) NOT NULL,
5 `priorityName` varchar(10) NOT NULL,
6 `timestamp` datetime NOT NULL,
7 PRIMARY KEY (`id`)
8)