CREATE TABLE IF NOT EXISTS `ban_hwid` (
  `ban_id` INT(11) NOT NULL,
  `HWID` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `useHWID` tinyint(1) NOT NULL DEFAULT '1',
  KEY `ban_id` (`ban_id`,`HWID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ban_ip` (
  `ban_id` INT(11) NOT NULL,
  `ban_ip` VARCHAR(15) COLLATE utf8_bin NOT NULL DEFAULT '127.0.0.1',
  KEY `ban_id` (`ban_id`,`ban_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------


CREATE TABLE IF NOT EXISTS `ban_nick` (
  `ban_id` INT(11) NOT NULL,
  `nick` VARCHAR(50) COLLATE utf8_bin NOT NULL,
  KEY `ban_id` (`ban_id`,`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ban_reason` (
  `ban_id` INT(11) NOT NULL,
  `ban_reason` mediumtext CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  KEY `ban_id` (`ban_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `ban_unbantime` (
  `ban_id` INT(11) NOT NULL,
  `ban_unbanTime` datetime NOT NULL,
  `use_unbanTime` INT(1) NOT NULL,
  `ban_banTime` datetime NOT NULL,
  KEY `ban_id` (`ban_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------


CREATE TABLE IF NOT EXISTS `ban_xuid` (
  `ban_id` INT(11) NOT NULL,
  `ban_XUID` VARCHAR(16) COLLATE utf8_bin NOT NULL,
  KEY `ban_id` (`ban_id`,`ban_XUID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;