DROP TABLE IF EXISTS `cms_ban_ip`;

CREATE TABLE `cms_ban_ip` (

  `id`       INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  `ip1`      BIGINT(11)       NOT NULL DEFAULT '0',

  `ip2`      BIGINT(11)       NOT NULL DEFAULT '0',

  `ban_type` TINYINT(4)       NOT NULL DEFAULT '0',

  `link`     VARCHAR(100)     NOT NULL,

  `who`      VARCHAR(25)      NOT NULL,

  `reason`   TEXT             NOT NULL,

  `date`     INT(11)          NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `ip1` (`ip1`),

  UNIQUE KEY `ip2` (`ip2`)

)

  ENGINE = MyISAM

  DEFAULT CHARSET = utf8mb4;