-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 30, 2025 at 04:14 PM
-- Server version: 8.0.43
-- PHP Version: 8.4.10

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `botbanishserver_BotBanishServer_7.0`
--

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

--
-- Table structure for table `bbc_botbanishclient_debug_log`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_debug_log`;
CREATE TABLE `bbc_botbanishclient_debug_log` (
  `seq` int NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `request` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `backtrace` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_debug_trace`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_debug_trace`;
CREATE TABLE `bbc_botbanishclient_debug_trace` (
  `bot_id` int UNSIGNED NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hit_count` int UNSIGNED NOT NULL DEFAULT '0',
  `last_hit` int UNSIGNED NOT NULL DEFAULT '0',
  `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `client_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `server_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `botbanish_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `datarow` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_doc_errors`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_doc_errors`;
CREATE TABLE `bbc_botbanishclient_doc_errors` (
  `bot_id` int UNSIGNED NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hit_count` int UNSIGNED NOT NULL DEFAULT '0',
  `last_hit` int UNSIGNED NOT NULL DEFAULT '0',
  `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `error_doc` int UNSIGNED NOT NULL,
  `error_cause` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `client_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `server_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_domain_bad`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_domain_bad`;
CREATE TABLE `bbc_botbanishclient_domain_bad` (
  `id_domain` int UNSIGNED NOT NULL,
  `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_domain_good`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_domain_good`;
CREATE TABLE `bbc_botbanishclient_domain_good` (
  `id_domain` int UNSIGNED NOT NULL,
  `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_htaccess`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_htaccess`;
CREATE TABLE `bbc_botbanishclient_htaccess` (
  `id` int UNSIGNED NOT NULL,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_ip`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_ip`;
CREATE TABLE `bbc_botbanishclient_ip` (
  `ip_id` int UNSIGNED NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hit_count` int UNSIGNED NOT NULL DEFAULT '0',
  `first_hit` int UNSIGNED NOT NULL DEFAULT '0',
  `last_hit` int UNSIGNED NOT NULL DEFAULT '0',
  `forcelockout` int UNSIGNED NOT NULL DEFAULT '0',
  `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_ip_dnb`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_ip_dnb`;
CREATE TABLE `bbc_botbanishclient_ip_dnb` (
  `ip_id` int UNSIGNED NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_session`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_session`;
CREATE TABLE `bbc_botbanishclient_session` (
  `option_id` bigint UNSIGNED NOT NULL,
  `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `option_func` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `option_timeout` bigint UNSIGNED NOT NULL,
  `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_settings`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_settings`;
CREATE TABLE `bbc_botbanishclient_settings` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `value` varchar(8192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `type` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_spiders_bad`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_spiders_bad`;
CREATE TABLE `bbc_botbanishclient_spiders_bad` (
  `id_spider` int UNSIGNED NOT NULL,
  `spider_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `user_agent_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_spiders_good`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_spiders_good`;
CREATE TABLE `bbc_botbanishclient_spiders_good` (
  `id_spider` int UNSIGNED NOT NULL,
  `spider_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `user_agent_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------
--
-- Table structure for table `bbc_botbanishclient_url_block`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_url_block`;
CREATE TABLE `bbc_botbanishclient_url_block` (
  `url_id` int UNSIGNED NOT NULL,
  `url_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `system` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `bbc_botbanishclient_url_dnc`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_url_dnc`;
CREATE TABLE `bbc_botbanishclient_url_dnc` (
  `url_id` int UNSIGNED NOT NULL,
  `url_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `system` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `active` int UNSIGNED NOT NULL DEFAULT '1',
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_website_blocks`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_website_blocks`;
CREATE TABLE `bbc_botbanishclient_website_blocks` (
  `id_no` int UNSIGNED NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `subject` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `blocks` int NOT NULL,
  `date` date NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_website_downloads`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_website_downloads`;
CREATE TABLE `bbc_botbanishclient_website_downloads` (
  `id_no` int UNSIGNED NOT NULL,
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ip_addr` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hostname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `http_user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `date` date NOT NULL,
  `rpt_date` datetime NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `system` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `bbc_botbanishclient_website_visits`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_website_visits`;
CREATE TABLE `bbc_botbanishclient_website_visits` (
  `id_no` int UNSIGNED NOT NULL,
  `page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ip_addr` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hostname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `http_user_agent` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `date` date NOT NULL,
  `rpt_date` datetime NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `system` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bbc_botbanishclient_debug_log`
--
ALTER TABLE `bbc_botbanishclient_debug_log`
  ADD PRIMARY KEY (`seq`);

--
-- Indexes for table `bbc_botbanishclient_debug_trace`
--
ALTER TABLE `bbc_botbanishclient_debug_trace`
  ADD PRIMARY KEY (`bot_id`),
  ADD KEY `IP` (`bot_ip`),
  ADD KEY `Domain` (`domain_name`);

--
-- Indexes for table `bbc_botbanishclient_doc_errors`
--
ALTER TABLE `bbc_botbanishclient_doc_errors`
  ADD PRIMARY KEY (`bot_id`),
  ADD KEY `bot_ip` (`bot_ip`,`error_doc`,`error_cause`(20)) USING BTREE;

--
-- Indexes for table `bbc_botbanishclient_domain_bad`
--
ALTER TABLE `bbc_botbanishclient_domain_bad`
  ADD PRIMARY KEY (`id_domain`),
  ADD UNIQUE KEY `domain` (`domain`);

--
-- Indexes for table `bbc_botbanishclient_domain_good`
--
ALTER TABLE `bbc_botbanishclient_domain_good`
  ADD PRIMARY KEY (`id_domain`),
  ADD UNIQUE KEY `domain` (`domain`);

--
-- Indexes for table `bbc_botbanishclient_htaccess`
--
ALTER TABLE `bbc_botbanishclient_htaccess`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `updated` (`updated`);

--
-- Indexes for table `bbc_botbanishclient_ip`
--
ALTER TABLE `bbc_botbanishclient_ip`
  ADD PRIMARY KEY (`ip_id`),
  ADD UNIQUE KEY `bot_ip` (`bot_ip`),
  ADD KEY `first_hit` (`first_hit`),
  ADD KEY `last_hit` (`last_hit`);

--
-- Indexes for table `bbc_botbanishclient_ip_dnb`
--
ALTER TABLE `bbc_botbanishclient_ip_dnb`
  ADD PRIMARY KEY (`ip_id`),
  ADD UNIQUE KEY `ip` (`bot_ip`) USING BTREE;

--
-- Indexes for table `bbc_botbanishclient_session`
--
ALTER TABLE `bbc_botbanishclient_session`
  ADD PRIMARY KEY (`option_id`);

--
-- Indexes for table `bbc_botbanishclient_settings`
--
ALTER TABLE `bbc_botbanishclient_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `bbc_botbanishclient_spiders_bad`
--
ALTER TABLE `bbc_botbanishclient_spiders_bad`
  ADD PRIMARY KEY (`id_spider`),
  ADD UNIQUE KEY `user_agent` (`user_agent_part`);

--
-- Indexes for table `bbc_botbanishclient_spiders_good`
--
ALTER TABLE `bbc_botbanishclient_spiders_good`
  ADD PRIMARY KEY (`id_spider`),
  ADD UNIQUE KEY `user_agent` (`user_agent_part`);

--
-- Indexes for table `bbc_botbanishclient_url_block`
--
ALTER TABLE `bbc_botbanishclient_url_block`
  ADD PRIMARY KEY (`url_id`),
  ADD UNIQUE KEY `url_part` (`url_part`);

--
-- Indexes for table `bbc_botbanishclient_url_dnc`
--
ALTER TABLE `bbc_botbanishclient_url_dnc`
  ADD PRIMARY KEY (`url_id`),
  ADD UNIQUE KEY `url_part` (`url_part`);

--
-- Indexes for table `bbc_botbanishclient_website_blocks`
--
ALTER TABLE `bbc_botbanishclient_website_blocks`
  ADD PRIMARY KEY (`id_no`),
  ADD UNIQUE KEY `uniquehit` (`bot_ip`,`subject`,`date`),
  ADD KEY `bot_ip` (`bot_ip`,`subject`) USING BTREE;

--
-- Indexes for table `bbc_botbanishclient_website_downloads`
--
ALTER TABLE `bbc_botbanishclient_website_downloads`
  ADD PRIMARY KEY (`id_no`),
  ADD UNIQUE KEY `uniquehit` (`user_id`,`filename`,`ip_addr`,`date`);

--
-- Indexes for table `bbc_botbanishclient_website_visits`
--
ALTER TABLE `bbc_botbanishclient_website_visits`
  ADD PRIMARY KEY (`id_no`),
  ADD UNIQUE KEY `uniquehit` (`user_id`,`page_name`,`ip_addr`,`date`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_debug_log`
--
ALTER TABLE `bbc_botbanishclient_debug_log`
  MODIFY `seq` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_debug_trace`
--
ALTER TABLE `bbc_botbanishclient_debug_trace`
  MODIFY `bot_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_doc_errors`
--
ALTER TABLE `bbc_botbanishclient_doc_errors`
  MODIFY `bot_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_domain_bad`
--
ALTER TABLE `bbc_botbanishclient_domain_bad`
  MODIFY `id_domain` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_domain_good`
--
ALTER TABLE `bbc_botbanishclient_domain_good`
  MODIFY `id_domain` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_htaccess`
--
ALTER TABLE `bbc_botbanishclient_htaccess`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_ip`
--
ALTER TABLE `bbc_botbanishclient_ip`
  MODIFY `ip_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_ip_dnb`
--
ALTER TABLE `bbc_botbanishclient_ip_dnb`
  MODIFY `ip_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_session`
--
ALTER TABLE `bbc_botbanishclient_session`
  MODIFY `option_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_settings`
--
ALTER TABLE `bbc_botbanishclient_settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_spiders_bad`
--
ALTER TABLE `bbc_botbanishclient_spiders_bad`
  MODIFY `id_spider` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_spiders_good`
--
ALTER TABLE `bbc_botbanishclient_spiders_good`
  MODIFY `id_spider` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_url_block`
--
ALTER TABLE `bbc_botbanishclient_url_block`
  MODIFY `url_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_url_dnc`
--
ALTER TABLE `bbc_botbanishclient_url_dnc`
  MODIFY `url_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_website_blocks`
--
ALTER TABLE `bbc_botbanishclient_website_blocks`
  MODIFY `id_no` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_website_downloads`
--
ALTER TABLE `bbc_botbanishclient_website_downloads`
  MODIFY `id_no` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_website_visits`
--
ALTER TABLE `bbc_botbanishclient_website_visits`
  MODIFY `id_no` int UNSIGNED NOT NULL AUTO_INCREMENT;

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
