· 8 years ago · May 26, 2018, 09:48 PM
1--
2-- Table structure for table `acp_bans`
3--
4
5CREATE TABLE IF NOT EXISTS `acp_bans` (
6`bid` int(11) NOT NULL,
7 `player_ip` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
8 `player_id` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
9 `player_nick` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'Unknown',
10 `cookie_ip` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
11 `admin_ip` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
12 `admin_id` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
13 `admin_nick` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT 'Unknown',
14 `admin_uid` int(11) NOT NULL,
15 `ban_type` varchar(10) CHARACTER SET cp1251 NOT NULL DEFAULT 'S',
16 `ban_reason` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
17 `ban_created` int(11) NOT NULL DEFAULT '0',
18 `ban_length` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
19 `server_ip` varchar(100) CHARACTER SET cp1251 NOT NULL DEFAULT '',
20 `server_name` varchar(100) CHARACTER SET cp1251 NOT NULL DEFAULT 'Unknown',
21 `expired` int(11) DEFAULT '0',
22 `ban_kicks` int(11) DEFAULT NULL
23) ENGINE=MyISAM AUTO_INCREMENT=818085 DEFAULT CHARSET=latin1;