CREATE TABLE `server_advert_groups` (
  `server_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  KEY `group_id` (`group_id`),
  KEY `server_id` (`server_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `serverbans` (
  `banid` int(2) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) NOT NULL DEFAULT '',
  `value` varchar(128) NOT NULL DEFAULT '',
  `owner` varchar(64) DEFAULT NULL,
  `reason` varchar(128) DEFAULT NULL,
  `lastby` int(2) NOT NULL DEFAULT 0,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `silent` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`banid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `authkeys` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `key_string` tinytext NOT NULL,
  `owner` tinytext NOT NULL,
  `host` tinytext NOT NULL,
  `edit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `servers` (
  `server_id` int(11) NOT NULL AUTO_INCREMENT,
  `nameport` varchar(60) NOT NULL DEFAULT '',
  `ipaddr` varchar(17) NOT NULL DEFAULT '',
  `gameinfo` varchar(73) NOT NULL DEFAULT '',
  `title` varchar(80) DEFAULT NULL,
  `owner` varchar(32) DEFAULT NULL,
  `ownername` varchar(255) DEFAULT NULL,
  `version` varchar(9) NOT NULL DEFAULT '',
  `build` varchar(60) DEFAULT NULL,
  `lastmod` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`server_id`),
  KEY `nameport` (`nameport`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

