· 6 years ago · Apr 24, 2019, 12:40 PM
1CREATE TABLE IF NOT EXISTS `amx_serverinfo` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `timestamp` int(11) NOT NULL,
4 `hostname` varchar(100) NOT NULL DEFAULT 'Unknown',
5 `address` varchar(100) NOT NULL,
6 `gametype` varchar(32) NOT NULL,
7 `rcon` varchar(32) NOT NULL,
8 `amxban_version` varchar(32) NOT NULL,
9 `amxban_motd` varchar(250) NOT NULL,
10 `motd_delay` int(10) DEFAULT '10',
11 `amxban_menu` int(10) DEFAULT '1',
12 `reasons` int(10) NOT NULL,
13 `timezone_fixx` int(11) DEFAULT '0',
14 PRIMARY KEY (`id`),
15 UNIQUE KEY `motd_delay` (`motd_delay`),
16 UNIQUE KEY `amxban_menu` (`amxban_menu`),
17 UNIQUE KEY `timezone_fixx` (`timezone_fixx`)
18) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;