· 6 years ago · Apr 15, 2019, 04:42 PM
1 /*
2 CREATE TABLE IF NOT EXISTS `dice_logs` (
3 `id` INT NOT NULL AUTO_INCREMENT,
4 `date` int(11) NOT NULL,
5 `map` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
6 `communityid` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
7 `name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
8 `dice` tinyint(1) NOT NULL,
9 `option` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
10 PRIMARY KEY (`id`)
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
12 */