wp_webdecoy_blocked_ips

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_webdecoy_blocked_ips ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip_address VARCHAR(45) NOT NULL, reason VARCHAR(255) DEFAULT '', blocked_at DATETIME NOT NULL, expires_at DATETIME DEFAULT NULL, created_by VARCHAR(100) DEFAULT 'system', PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY expires_at (expires_at) ) $charset_collate;"; // Local detections table (cache) $sql_detections = "CREATE TABLE IF NOT EXISTS wp_webdecoy_detections ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, remote_id VARCHAR(36) DEFAULT NULL, ip_address VARCHAR(45) NOT NULL, user_agent TEXT, score INT UNSIGNED DEFAULT 0, threat_level VARCHAR(20) DEFAULT 'MINIMAL', source VARCHAR(50) DEFAULT 'bot_scanner', flags TEXT DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY ip_address (ip_address), KEY created_at (created_at), KEY threat_level (threat_level) ) $charset_collate;"; // Rate limiting table $sql_rate_limits = "CREATE TABLE IF NOT EXISTS wp_webdecoy_rate_limits ( ip_address VARCHAR(45) NOT NULL, request_count INT UNSIGNED DEFAULT 1, window_start DATETIME NOT NULL, PRIMARY KEY (ip_address), KEY window_start (window_start) ) $charset_collate;"; // Checkout attempts table (WooCommerce) $sql_checkout = "CREATE TABLE IF NOT EXISTS wp_webdecoy_checkout_attempts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip_address VARCHAR(45) NOT NULL, order_id BIGINT UNSIGNED DEFAULT NULL, status VARCHAR(20) DEFAULT 'attempt', amount DECIMAL(10, 2) DEFAULT 0.00, card_last4 VARCHAR(4) DEFAULT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY ip_address (ip_address), KEY created_at (created_at), KEY status (status) ) $charset_collate;"; // Violation queue table — spool for rule-engine violations awaiting // delivery to the ingest service (resilient reporting: survives ingest // downtime, retried by cron). Only used when a Cloud API key is set. $sql_violation_queue = "CREATE TABLE IF NOT EXISTS wp_webdecoy_violation_queue ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, payload LONGTEXT NOT NULL, attempts TINYINT UNSIGNED DEFAULT 0, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY created_at (created_at) ) $charset_collate;"; // AI referral counts (2.10.0): visits AI products sent, by platform and // landing path, waiting to be sent to WebDecoy Cloud. Counts only; // nothing about a visitor. ref_key is sha1(platform + path), so the // key stays within index limits on older MySQL; batch_id is '' for // open counts and the claim id of a batch being sent. $sql_ai_referrals = "CREATE TABLE IF NOT EXISTS wp_webdecoy_ai_referrals ( ref_key CHAR(40) NOT NULL, batch_id VARCHAR(36) NOT NULL DEFAULT '', platform VARCHAR(50) NOT NULL, landing_path VARCHAR(500) NOT NULL, referrals BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ref_key, batch_id), KEY batch_id (batch_id) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql_blocked);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_webdecoy_blocked_ips`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from WebDecoy Bot Detection – Block AI Crawlers, Spam Bots & Card Testing