<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 5.2.2
 */

/**
 * Database `botbanishserver_7.0`
 */

/* `botbanishserver_7.0`.`bbc_botbanishclient_tables` */
$bbc_botbanishclient_tables = array(
  array('table_id' => '1','table_name' => 'bbc_botbanishclient_debug_log','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_debug_log`
	ADD PRIMARY KEY (`seq`);

ALTER TABLE `bbc_botbanishclient_debug_log`
	MODIFY `seq` int  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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '2','table_name' => 'bbc_botbanishclient_debug_trace','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

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

ALTER TABLE `bbc_botbanishclient_debug_trace`
	MODIFY `bot_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '3','table_name' => 'bbc_botbanishclient_doc_errors','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_doc_errors`
	ADD PRIMARY KEY (`bot_id`),
	ADD KEY `bot_ip` (`bot_ip`,`error_doc`,`error_cause`(20));

ALTER TABLE `bbc_botbanishclient_doc_errors`
	MODIFY `bot_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '4','table_name' => 'bbc_botbanishclient_domain_bad','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_domain_bad`
	ADD PRIMARY KEY (`id_domain`),
	ADD UNIQUE KEY`domain` (`domain`);

ALTER TABLE `bbc_botbanishclient_domain_bad`
	MODIFY `id_domain` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '5','table_name' => 'bbc_botbanishclient_domain_good','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_domain_good`
	ADD PRIMARY KEY (`id_domain`),
	ADD UNIQUE KEY`domain` (`domain`);

ALTER TABLE `bbc_botbanishclient_domain_good`
	MODIFY `id_domain` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '6','table_name' => 'bbc_botbanishclient_htaccess','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_htaccess`
	ADD PRIMARY KEY (`id`),
	ADD KEY `type` (`type`),
	ADD KEY `updated` (`updated`);

ALTER TABLE `bbc_botbanishclient_htaccess`
	MODIFY `id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '7','table_name' => 'bbc_botbanishclient_ip_bad','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_ip_bad`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_ip_bad`;
CREATE TABLE `bbc_botbanishclient_ip_bad` (
  `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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_ip_bad`
	ADD PRIMARY KEY (`ip_id`),
	ADD UNIQUE KEY`bot_ip` (`bot_ip`),
	ADD KEY `first_hit` (`first_hit`),
	ADD KEY `last_hit` (`last_hit`);

ALTER TABLE `bbc_botbanishclient_ip_bad`
	MODIFY `ip_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '8','table_name' => 'bbc_botbanishclient_ip_good','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_ip_good`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_ip_good`;
CREATE TABLE `bbc_botbanishclient_ip_good` (
  `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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_ip_good`
	ADD PRIMARY KEY (`ip_id`),
	ADD UNIQUE KEY`ip` (`bot_ip`);

ALTER TABLE `bbc_botbanishclient_ip_good`
	MODIFY `ip_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '9','table_name' => 'bbc_botbanishclient_session','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:20
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_session`
	ADD PRIMARY KEY (`option_id`);

ALTER TABLE `bbc_botbanishclient_session`
	MODIFY `option_id` bigint UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '10','table_name' => 'bbc_botbanishclient_settings','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_settings`
	ADD PRIMARY KEY (`id`),
	ADD UNIQUE KEY`name` (`name`);

ALTER TABLE `bbc_botbanishclient_settings`
	MODIFY `id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '11','table_name' => 'bbc_botbanishclient_spider_bad','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_spider_bad`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_spider_bad`;
CREATE TABLE `bbc_botbanishclient_spider_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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_spider_bad`
	ADD PRIMARY KEY (`id_spider`),
	ADD UNIQUE KEY`user_agent` (`user_agent_part`);

ALTER TABLE `bbc_botbanishclient_spider_bad`
	MODIFY `id_spider` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '12','table_name' => 'bbc_botbanishclient_spider_good','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_spider_good`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_spider_good`;
CREATE TABLE `bbc_botbanishclient_spider_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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_spider_good`
	ADD PRIMARY KEY (`id_spider`),
	ADD UNIQUE KEY`user_agent` (`user_agent_part`);

ALTER TABLE `bbc_botbanishclient_spider_good`
	MODIFY `id_spider` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '13','table_name' => 'bbc_botbanishclient_url_bad','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_url_bad`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_url_bad`;
CREATE TABLE `bbc_botbanishclient_url_bad` (
  `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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_url_bad`
	ADD PRIMARY KEY (`url_id`),
	ADD UNIQUE KEY`url_part` (`url_part`);

ALTER TABLE `bbc_botbanishclient_url_bad`
	MODIFY `url_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '14','table_name' => 'bbc_botbanishclient_url_good','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbc_botbanishclient_url_good`
-- ============================================================================

DROP TABLE IF EXISTS `bbc_botbanishclient_url_good`;
CREATE TABLE `bbc_botbanishclient_url_good` (
  `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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbc_botbanishclient_url_good`
	ADD PRIMARY KEY (`url_id`),
	ADD UNIQUE KEY`url_part` (`url_part`);

ALTER TABLE `bbc_botbanishclient_url_good`
	MODIFY `url_id` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '15','table_name' => 'bbc_botbanishclient_website_blocks','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

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`);

ALTER TABLE `bbc_botbanishclient_website_blocks`
	MODIFY `id_no` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '16','table_name' => 'bbc_botbanishclient_website_downloads','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

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

ALTER TABLE `bbc_botbanishclient_website_downloads`
	MODIFY `id_no` int UNSIGNED 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '17','table_name' => 'bbc_botbanishclient_website_visits','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 19:02:21
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

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

ALTER TABLE `bbc_botbanishclient_website_visits`
	MODIFY `id_no` int UNSIGNED 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 */;
','updated' => '2025-12-04 15:06:42'),
  array('table_id' => '18','table_name' => 'botbanish_country_code','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_country_code`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_country_code`;
CREATE TABLE `botbanish_country_code` (
  `id_country` int NOT NULL ,
  `country_code` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `active` int NOT NULL DEFAULT \'0\'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_country_code`
	ADD PRIMARY KEY (`id_country`),
	ADD UNIQUE KEY`country_code` (`country_code`);

ALTER TABLE `botbanish_country_code`
	MODIFY `id_country` int  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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '19','table_name' => 'botbanish_language_text','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text`;
CREATE TABLE `botbanish_language_text` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '20','table_name' => 'botbanish_language_text_english','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_english`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_english`;
CREATE TABLE `botbanish_language_text_english` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_english`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '21','table_name' => 'botbanish_language_text_french','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_french`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_french`;
CREATE TABLE `botbanish_language_text_french` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_french`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '22','table_name' => 'botbanish_language_text_german','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_german`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_german`;
CREATE TABLE `botbanish_language_text_german` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_german`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '23','table_name' => 'botbanish_language_text_italian','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_italian`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_italian`;
CREATE TABLE `botbanish_language_text_italian` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_italian`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '24','table_name' => 'botbanish_language_text_portuguese','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_portuguese`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_portuguese`;
CREATE TABLE `botbanish_language_text_portuguese` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_portuguese`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '25','table_name' => 'botbanish_language_text_spanish','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_spanish`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_spanish`;
CREATE TABLE `botbanish_language_text_spanish` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_spanish`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '26','table_name' => 'botbanish_language_text_swedish','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_language_text_swedish`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_language_text_swedish`;
CREATE TABLE `botbanish_language_text_swedish` (
  `lang_id` int NOT NULL,
  `lang_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_text` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_language_text_swedish`
	ADD UNIQUE KEY`lang` (`lang_id`,`lang_key`);


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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '27','table_name' => 'botbanish_languages','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:26
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_languages`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_languages`;
CREATE TABLE `botbanish_languages` (
  `lang_id` int NOT NULL ,
  `language` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lang_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_languages`
	ADD UNIQUE KEY`lang_id` (`lang_id`);

ALTER TABLE `botbanish_languages`
	MODIFY `lang_id` int  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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '28','table_name' => 'botbanish_timezones','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:22:27
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `botbanish_timezones`
-- ============================================================================

DROP TABLE IF EXISTS `botbanish_timezones`;
CREATE TABLE `botbanish_timezones` (
  `tz_id` int NOT NULL ,
  `gmt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `area` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timezone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `botbanish_timezones`
	ADD UNIQUE KEY`tz_id` (`tz_id`);

ALTER TABLE `botbanish_timezones`
	MODIFY `tz_id` int  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 */;
','updated' => '0000-00-00 00:00:00'),
 array('table_id' => '29','table_name' => 'bbc_botbanishclient_redirects','text' => '
-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 02, 2026 at 12:41 PM
-- Server version: 8.0.45
-- PHP Version: 8.4.19

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: `ngugolfclub_wp_h8iws`
--

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

--
-- Table structure for table `bbc_botbanishclient_redirects`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_redirects`;
CREATE TABLE `bbc_botbanishclient_redirects` (
  `redirect_id` bigint UNSIGNED NOT NULL,
  `redirect_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `redirect_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `redirect_func` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `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_redirects`
--
ALTER TABLE `bbc_botbanishclient_redirects`
  ADD PRIMARY KEY (`redirect_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_redirects`
--
ALTER TABLE `bbc_botbanishclient_redirects`
  MODIFY `redirect_id` bigint 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '30','table_name' => 'botbanishclient_geo','text' => '
-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 04, 2026 at 11:35 PM
-- Server version: 8.0.45
-- PHP Version: 8.4.19

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 */;

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

--
-- Table structure for table `bbc_botbanishclient_geo`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_geo`;
CREATE TABLE `bbc_botbanishclient_geo` (
  `geo_id` bigint NOT NULL,
  `bot_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `geo_info` varchar(3192) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `uploaded` int NOT NULL DEFAULT \'0\'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bbc_botbanishclient_geo`
--
ALTER TABLE `bbc_botbanishclient_geo`
  ADD PRIMARY KEY (`geo_id`),
  ADD UNIQUE KEY `ip` (`bot_ip`),
  ADD KEY `country_code` (`country_code`);
  
 ALTER TABLE `bbc_botbanishclient_geo`
	ADD KEY `uploaded` (`Uploaded`);


--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bbc_botbanishclient_geo`
--
ALTER TABLE `bbc_botbanishclient_geo`
  MODIFY `geo_id` bigint 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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '31','table_name' => 'botbanishclient_email','text' => '

/*!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_7.1`
--

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

--
-- Table structure for table `bbc_botbanishclient_email`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_email`;
CREATE TABLE IF NOT EXISTS `bbc_botbanishclient_email` (
  `email_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `hit_count` int NOT NULL DEFAULT \'0\',
  `first_hit` int NOT NULL DEFAULT \'0\',
  `last_hit` int NOT NULL DEFAULT \'0\',
  `forcelockout` int UNSIGNED NOT NULL DEFAULT \'1\',
  `domain_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT \'\',
  `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`email_id`),
  UNIQUE KEY `email` (`email`,`username`),
  KEY `first_hit` (`first_hit`),
  KEY `last_hit` (`last_hit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
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 */;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '32','table_name' => 'botbanishclient_ip_bad_default','text' => '

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 17, 2026 at 12:39 AM
-- Server version: 8.0.38
-- PHP Version: 8.3.9

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: `wordpress`
--

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

--
-- Table structure for table `bbc_botbanishclient_ip_bad_default`
--

DROP TABLE IF EXISTS `bbc_botbanishclient_ip_bad_default`;
CREATE TABLE IF NOT EXISTS `bbc_botbanishclient_ip_bad_default` (
  `ip_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`ip_id`),
  UNIQUE KEY `ip` (`bot_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
COMMIT;
','updated' => '0000-00-00 00:00:00'),
  array('table_id' => '33','table_name' => 'bbs_botbanishclient_lockout','text' => '
-- ==========================================================
--
-- Database dump of tables in `botbanishserver_7.0`
-- Date: 15:09:37
-- Program: BotBanish_DumpDatabase.php
-- Author: Randem Systems
-- System: BotBanish Server 7.0.00 (SERVER)
--
-- ==========================================================

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 */;

-- ============================================================================
-- Table structure for table `bbs_botbanishclient_lockout`
-- ============================================================================

DROP TABLE IF EXISTS `bbs_botbanishclient_lockout`;
CREATE TABLE `bbs_botbanishclient_lockout` (
  `lockout_id` int NOT NULL ,
  `tag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `description` 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;

-- ----------------------------------------------------------------------------
--
-- Dumping indexes in `botbanishserver_7.0`
--
-- ----------------------------------------------------------------------------

ALTER TABLE `bbs_botbanishclient_lockout`
	ADD PRIMARY KEY (`lockout_id`);

ALTER TABLE `bbs_botbanishclient_lockout`
	MODIFY `lockout_id` int  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 */;
','updated' => '0000-00-00 00:00:00'),
);

return $bbc_botbanishclient_tables;