Ultrabans MySQL Tables

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `banlist`
-- ----------------------------
DROP TABLE IF EXISTS `banlist`;
CREATE TABLE `banlist` (
  `name` VARCHAR(32) NOT NULL,
  `reason` text NOT NULL,
  `admin` VARCHAR(32) NOT NULL,
  `time` BIGINT(20) NOT NULL,
  `temptime` BIGINT(20) NOT NULL,
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `type` INT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of banlist
-- ----------------------------

-- ----------------------------
-- Table structure for `banlistip`
-- ----------------------------
DROP TABLE IF EXISTS `banlistip`;
CREATE TABLE `banlistip` (
  `name` VARCHAR(32) NOT NULL,
  `lastip` tinytext NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of banlistip
-- ----------------------------