· 8 years ago · May 24, 2018, 11:58 AM
1CREATE TABLE IF NOT EXISTS `erro_banlog` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `datetime` datetime NOT NULL,
4 `server_ip` varchar(16) NOT NULL DEFAULT 'unknown',
5 `bantype` varchar(32) NOT NULL,
6 `ckey` varchar(32) NOT NULL,
7 `ip` varchar(16) NOT NULL,
8 `computer_id` int(64) NOT NULL,
9 `name` varchar(32) NOT NULL,
10 `job` varchar(255) DEFAULT NULL,
11 `duration` varchar(32) NOT NULL,
12 `reason` text NOT NULL,
13 `admin_ckey` varchar(32) NOT NULL,
14 `admin_name` varchar(32) NOT NULL,
15 `admins_online` text NOT NULL,
16 `players_online` text NOT NULL,
17 `edited_by` text,
18 `edit_info` text,
19 `unbanned_by` varchar(32) DEFAULT NULL,
20 `unbanned_datetime` datetime DEFAULT NULL,
21 `details` text,
22 PRIMARY KEY (`id`)
23)