CREATE TABLE IF NOT EXISTS `#__mokosuite_waf_log` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` VARCHAR(45) NOT NULL,
  `uri` VARCHAR(2048) NOT NULL DEFAULT '',
  `rule` VARCHAR(50) NOT NULL,
  `detail` VARCHAR(512) NOT NULL DEFAULT '',
  `user_agent` VARCHAR(512) NOT NULL DEFAULT '',
  `created` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ip` (`ip`),
  KEY `idx_rule` (`rule`),
  KEY `idx_created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
