Amxbans gm 1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

CREATE TABLE IF NOT EXISTS `amx_admins_servers` (
  `admin_id` int(12) NOT NULL DEFAULT '0',
  `server_id` int(12) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `amx_amxadmins` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `access` varchar(32) DEFAULT NULL,
  `flags` varchar(32) DEFAULT NULL,
  `steamid` varchar(32) DEFAULT NULL,
  `nickname` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

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

CREATE TABLE IF NOT EXISTS `amx_banhistory` (
  `bhid` int(11) NOT NULL AUTO_INCREMENT,
  `player_ip` varchar(100) DEFAULT NULL,
  `player_id` varchar(50) NOT NULL DEFAULT '0',
  `player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
  `admin_ip` varchar(100) DEFAULT NULL,
  `admin_id` varchar(50) NOT NULL DEFAULT '0',
  `admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
  `ban_type` varchar(10) NOT NULL DEFAULT 'S',
  `ban_reason` varchar(255) NOT NULL DEFAULT '',
  `ban_created` int(11) NOT NULL DEFAULT '0',
  `ban_length` varchar(100) NOT NULL DEFAULT '',
  `server_ip` varchar(100) NOT NULL DEFAULT '',
  `server_name` varchar(100) NOT NULL DEFAULT 'Unknown',
  `unban_created` int(11) NOT NULL DEFAULT '0',
  `unban_reason` varchar(255) NOT NULL DEFAULT 'tempban expired',
  `unban_admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
  PRIMARY KEY (`bhid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=266;

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

CREATE TABLE IF NOT EXISTS `amx_banreasons` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `address` varchar(32) NOT NULL,
  `reason` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

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

CREATE TABLE IF NOT EXISTS `amx_bans` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `player_ip` varchar(100) DEFAULT NULL,
  `player_id` varchar(50) NOT NULL DEFAULT '0',
  `player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
  `admin_ip` varchar(100) DEFAULT NULL,
  `admin_id` varchar(50) NOT NULL DEFAULT '0',
  `admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
  `ban_type` varchar(10) NOT NULL DEFAULT 'S',
  `ban_reason` varchar(255) NOT NULL DEFAULT '',
  `ban_created` int(11) NOT NULL DEFAULT '0',
  `ban_length` varchar(100) NOT NULL DEFAULT '',
  `server_ip` varchar(100) NOT NULL DEFAULT '',
  `server_name` varchar(100) NOT NULL DEFAULT 'Unknown',
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=362;

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

CREATE TABLE IF NOT EXISTS `amx_levels` (
  `level` int(12) NOT NULL DEFAULT '0',
  `bans_add` enum('yes','no') NOT NULL DEFAULT 'no',
  `bans_edit` enum('yes','no','own') NOT NULL DEFAULT 'no',
  `bans_delete` enum('yes','no','own') NOT NULL DEFAULT 'no',
  `bans_unban` enum('yes','no','own') NOT NULL DEFAULT 'no',
  `bans_import` enum('yes','no') NOT NULL DEFAULT 'no',
  `bans_export` enum('yes','no') NOT NULL DEFAULT 'no',
  `amxadmins_view` enum('yes','no') NOT NULL DEFAULT 'no',
  `amxadmins_edit` enum('yes','no') NOT NULL DEFAULT 'no',
  `webadmins_view` enum('yes','no') NOT NULL DEFAULT 'no',
  `webadmins_edit` enum('yes','no') NOT NULL DEFAULT 'no',
  `permissions_edit` enum('yes','no') NOT NULL DEFAULT 'no',
  `prune_db` enum('yes','no') NOT NULL DEFAULT 'no',
  `servers_edit` enum('yes','no') NOT NULL DEFAULT 'no',
  `ip_view` enum('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `amx_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(1) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `action` varchar(100) NOT NULL,
  `remarks` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=306;

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

CREATE TABLE IF NOT EXISTS `amx_serverinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` varchar(50) NOT NULL DEFAULT '0',
  `hostname` varchar(100) NOT NULL DEFAULT 'Unknown',
  `address` varchar(32) NOT NULL DEFAULT '',
  `gametype` varchar(32) NOT NULL DEFAULT '',
  `rcon` varchar(32) DEFAULT NULL,
  `amxban_version` varchar(32) NOT NULL DEFAULT '',
  `amxban_motd` varchar(250) NOT NULL DEFAULT '',
  `motd_delay` int(10) NOT NULL DEFAULT '10',
  `amxban_menu` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6;

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

CREATE TABLE IF NOT EXISTS `amx_webadmins` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `level` varchar(32) NOT NULL DEFAULT '6',
  `logcode` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8;

CREATE TABLE IF NOT EXISTS `amx_bans` (
    bid int(11) NULL auto_increment,
    player_ip varchar(32) NULL,
    player_id varchar(35) NULL,
    player_nick varchar(100) NULL DEFAULT 'Unknown',
    admin_ip varchar(32) NULL,
    admin_id varchar(35) DEFAULT 'Unknown',
    admin_nick varchar(100) NULL DEFAULT 'Unknown',
    ban_type varchar(10) NULL DEFAULT 'S',
    ban_reason varchar(100) NULL,
    cs_ban_reason varchar(100) NULL,
    ban_created int(11) NULL,
    ban_length int(11) NULL,
    server_ip varchar(32) NULL,
    server_name varchar(100) NULL DEFAULT 'Unknown',
    ban_kicks int(11) NOT NULL DEFAULT '0',
    expired int(1) NOT NULL DEFAULT '0',
    imported int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (bid),
    KEY player_id (player_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;