File: inc/waf.sql

Recommend this page to a friend!
  Classes of Roman Shneer  >  PHP Web Application Firewall  >  inc/waf.sql  >  Download  
File: inc/waf.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Web Application Firewall
Block malicious requests using a white list
Author: By
Last change: Urgency bug about 404 code.
Enlarged segment value to 256
Merge branch 'mobile'
Date: 3 years ago
Size: 3,696 bytes
 

Contents

Download
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 11, 2016 at 09:19 AM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `wordpress`
--

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

--
-- Table structure for table `waf_bf_cache`
--

CREATE TABLE IF NOT EXISTS `waf_bf_cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `tt` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

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

--
-- Table structure for table `waf_blacklist`
--

CREATE TABLE IF NOT EXISTS `waf_blacklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(16) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table `waf_logs`
--

CREATE TABLE IF NOT EXISTS `waf_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `type` varchar(15) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(16) NOT NULL,
  `url` varchar(256) NOT NULL,
  `reason` text NOT NULL,
  `sid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=93 ;

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

--
-- Table structure for table `waf_segments`
--

CREATE TABLE IF NOT EXISTS `waf_segments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `lvl` tinyint(2) NOT NULL,
  `value` varchar(256) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT '0',
  `use_type` int(1) NOT NULL DEFAULT '0',
  `bf` double NOT NULL DEFAULT '0',
  `code_contains` varchar(50) NOT NULL,
  `code_size` int(11) NOT NULL,
  `code_before` varchar(20) NOT NULL,
  `code_after` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

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

--
-- Table structure for table `waf_settings`
--

CREATE TABLE IF NOT EXISTS `waf_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

--
-- Table structure for table `waf_users`
--

CREATE TABLE IF NOT EXISTS `waf_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `pass` varchar(32) NOT NULL,
  `status` int(1) NOT NULL,
  `editor` int(1) NOT NULL,
  `rmn_pass` varchar(32) NOT NULL,
  `bf` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Table structure for table `waf_vars`
--

CREATE TABLE IF NOT EXISTS `waf_vars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `method` varchar(10) NOT NULL,
  `value` text NOT NULL,
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sid` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT '0',
  `use_type` int(1) NOT NULL DEFAULT '0',
  `code_contains` varchar(50) NOT NULL,
  `code_size` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

For more information send a message to info at phpclasses dot org.