CREATE TABLE IF NOT EXISTS `wpua_defender_lockout` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `status` varchar(16) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `lockout_message` text COLLATE utf8mb4_unicode_520_ci, `release_time` int(11) DEFAULT NULL, `lock_time` int(11) DEFAULT NULL, `lock_time_404` int(11) DEFAULT NULL, `attempt` int(11) DEFAULT NULL, `attempt_404` int(11) DEFAULT NULL, `meta` text COLLATE utf8mb4_unicode_520_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci


CREATE TABLE IF NOT EXISTS `wpua_defender_lockout_log` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `log` text COLLATE utf8mb4_unicode_520_ci, `ip` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `date` int(11) DEFAULT NULL, `type` varchar(16) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `blog_id` int(11) DEFAULT NULL, `tried` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci