SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `bans`
--
CREATE DATABASE `bans` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `bans`;
-- --------------------------------------------------------
--
-- Table structure for table `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(150) collate latin1_general_ci NOT NULL,
`host` varchar(255) collate latin1_general_ci NOT NULL,
`last_ref` varchar(255) collate latin1_general_ci NOT NULL,
`last_url` varchar(255) collate latin1_general_ci NOT NULL,
`last_agent` varchar(255) collate latin1_general_ci NOT NULL,
`reason` text collate latin1_general_ci NOT NULL,
`add_date` date NOT NULL,
`add_date2` varchar(30) collate latin1_general_ci NOT NULL,
`attempts` int(20) NOT NULL default '0',
`last_attempt` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`expiry` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
|
Download
