fvG4zUju

1--
2-- Rakenne taululle `amx_serverinfo`
3--
4
5CREATE TABLE IF NOT EXISTS `amx_serverinfo` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `timestamp` int(11) NOT NULL,
8  `hostname` varchar(100) NOT NULL DEFAULT 'Unknown',
9  `address` varchar(100) NOT NULL,
10  `gametype` varchar(32) NOT NULL,
11  `rcon` varchar(32) NOT NULL,
12  `amxban_version` varchar(32) NOT NULL,
13  `amxban_motd` varchar(250) NOT NULL,
14  `motd_delay` int(10) DEFAULT '10',
15  `amxban_menu` int(10) DEFAULT '1',
16  `reasons` int(10) NOT NULL,
17  `timezone_fixx` int(11) DEFAULT '0',
18  PRIMARY KEY (`id`),
19  UNIQUE KEY `motd_delay` (`motd_delay`),
20  UNIQUE KEY `amxban_menu` (`amxban_menu`),
21  UNIQUE KEY `timezone_fixx` (`timezone_fixx`)
22) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;