CREATE TABLE `ts2_servers` (
  `i_server_id` int(8) NOT NULL auto_increment,
  `s_server_name` varchar(32) default NULL,
  `s_server_welcomemessage` varchar(128) default NULL,
  `i_server_maxusers` int(8) default NULL,
  `i_server_udpport` int(8) default NULL,
  `s_server_password` varchar(32) default NULL,
  `b_server_clan_server` tinyint(1) default NULL,
  `b_server_allow_codec_celp51` tinyint(1) default NULL,
  `b_server_allow_codec_celp63` tinyint(1) default NULL,
  `b_server_allow_codec_gsm148` tinyint(1) default NULL,
  `b_server_allow_codec_gsm164` tinyint(1) default NULL,
  `b_server_allow_codec_celp52` tinyint(1) default NULL,
  `b_server_allow_codec_speex2150` tinyint(1) default NULL,
  `b_server_allow_codec_speex3950` tinyint(1) default NULL,
  `b_server_allow_codec_speex5950` tinyint(1) default NULL,
  `b_server_allow_codec_speex8000` tinyint(1) default NULL,
  `b_server_allow_codec_speex11000` tinyint(1) default NULL,
  `b_server_allow_codec_speex15000` tinyint(1) default NULL,
  `b_server_allow_codec_speex18200` tinyint(1) default NULL,
  `b_server_allow_codec_speex24600` tinyint(1) default NULL,
  `s_server_webposturl` varchar(128) default NULL,
  `s_server_weblinkurl` varchar(128) default NULL,
  `b_server_active` tinyint(1) default NULL,
  `dt_server_created` varchar(24) default NULL,
  `s_server_description` text NOT NULL,
  PRIMARY KEY  (`i_server_id`),
  KEY `b_server_active` (`b_server_active`),
  KEY `i_server_udpport` (`i_server_udpport`)
) ENGINE=MyISAM ;
