PHP Classes

File: bans.sql

Recommend this page to a friend!
  Classes of Lee J   PHP bans and trap   bans.sql   Download  
File: bans.sql
Role: Auxiliary data
Content type: text/plain
Description: mysql database file
Class: PHP bans and trap
Manage database of banned IP addresses
Author: By
Last change:
Date: 14 years ago
Size: 1,078 bytes
 

Contents

Class file image Download
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 ;