db削除

SET @prefix = 'wp_';

-- sHub-Log custom tables
SET @sql = CONCAT('DROP TABLE IF EXISTS `', @prefix, 'syntaxhub_securelog_login_errors`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('DROP TABLE IF EXISTS `', @prefix, 'syntaxhub_securelog_protected_ips`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql = CONCAT('DROP TABLE IF EXISTS `', @prefix, 'syntaxhub_securelog_attack_logs`');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

-- sHub-Log options
SET @sql = CONCAT(
  'DELETE FROM `', @prefix, 'options` ',
  'WHERE `option_name` IN (',
  '''syntaxhub_securelog_limit_time'',',
  '''syntaxhub_securelog_limit_count'',',
  '''syntaxhub_securelog_block_duration'',',
  '''syntaxhub_securelog_block_redirect_url'',',
  '''syntaxhub_securelog_auto_block_attacks'',',
  '''syntaxhub_securelog_detect_bad_query'',',
  '''syntaxhub_securelog_detect_rate_limit'',',
  '''syntaxhub_securelog_detect_rest_api'',',
  '''syntaxhub_securelog_attack_log_retention_days'',',
  '''syntaxhub_securelog_attack_summary_period_days'',',
  '''syntaxhub_securelog_db_version''',
  ')'
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

-- sHub-Log transients
SET @sql = CONCAT(
  'DELETE FROM `', @prefix, 'options` ',
  'WHERE `option_name` LIKE ''\\_transient\\_syntaxhub\\_securelog\\_rate\\_%'' ESCAPE ''\\'' ',
  'OR `option_name` LIKE ''\\_transient\\_timeout\\_syntaxhub\\_securelog\\_rate\\_%'' ESCAPE ''\\'''
);
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;