<?php
/**
 * Uninstall script for AI 404 Redirect plugin
 * 
 * This file runs when the plugin is deleted via the WordPress admin.
 * It removes all plugin data including database tables and options.
 */

// If uninstall not called from WordPress, then exit
if (!defined('WP_UNINSTALL_PLUGIN')) {
    exit;
}

// Delete database tables
global $wpdb;

$hits_table = $wpdb->prefix . 'ai_404_redirect_hits';
$redirects_table = $wpdb->prefix . 'ai_404_manual_redirects';

// Drop tables with proper escaping
$wpdb->query("DROP TABLE IF EXISTS `{$hits_table}`"); // phpcs:ignore WordPress.DB.DirectDatabaseQuery,WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$wpdb->query("DROP TABLE IF EXISTS `{$redirects_table}`"); // phpcs:ignore WordPress.DB.DirectDatabaseQuery,WordPress.DB.PreparedSQL.InterpolatedNotPrepared

// Delete plugin options
delete_option('ai_404_redirect_version');

// Clear any cached data
if (function_exists('wp_cache_flush')) {
    wp_cache_flush();
}