How to Inspect & Manage Database Tables

The Database Tools panel gives administrators granular control over AdFuz’s relational database layer, allowing you to monitor storage footprints, truncate specific tables, or perform full schema repairs.

To access Database Tools, navigate to WordPress Admin > AdFuz > Tools and click Open → on Database Tools.

Plugin Tables Inspector

The Tables tab lists all 20+ dedicated database tables created by AdFuz:

Table Name	Functional Group	Status	Purpose & Description	Actions
`wp_adfuz_ads`	Ads	● Installed	Core ad records (creatives, URLs, formats)	`Clear Data` \| `Drop`
`wp_adfuz_ads_meta`	Ads	● Installed	Extended metadata & custom attributes	`Clear Data` \| `Drop`
`wp_adfuz_ad_spaces`	Ad Spaces	● Installed	Publisher placement zones & dimensions	`Clear Data` \| `Drop`
`wp_adfuz_ad_spaces_meta`	Ad Spaces	● Installed	Ad space layout and styling metadata	`Clear Data` \| `Drop`
`wp_adfuz_campaigns`	Campaigns	● Installed	Flight dates, schedules, and fallback rules	`Clear Data` \| `Drop`
`wp_adfuz_campaign_ads`	Campaigns	● Installed	Relational mapping between campaigns & ads	`Clear Data` \| `Drop`
`wp_adfuz_campaign_ad_spaces`	Campaigns	● Installed	Mapping between campaigns & ad spaces	`Clear Data` \| `Drop`
`wp_adfuz_audit_logs`	Audit & Stats	● Installed	Immutable user mutation audit trail	`Clear Data` \| `Drop`
`wp_adfuz_stats`	Stats & Reporting	● Installed	Partitioned raw interaction events stream	`Clear Data` \| `Drop`
`wp_adfuz_daily_stats`	Stats & Reporting	● Installed	Daily pre-aggregated rollups	`Clear Data` \| `Drop`

Table Management Actions

Clear Data (Orange Button): Truncates all rows inside the selected table while preserving the table schema and indexes intact. Useful for resetting test analytics or clearing audit history without breaking the site.
Drop (Red Button): Completely deletes the table from MySQL/MariaDB. AdFuz will detect the missing table and offer a 1-click recreation.

The Danger Zone (Schema Maintenance & Repairs)

Located at the bottom of the Database Tools panel:

⚠️ Danger Zone: Irreversible actions that affect all AdFuz plugin data.
[ Drop ALL Plugin Tables ]    [ Re-install All Tables ]

Drop ALL Plugin Tables: Permanently removes all AdFuz tables from the WordPress database.
Re-install All Tables: Executes a comprehensive dbDelta schema check, creating any missing tables and ensuring all indexes and column definitions match the latest plugin release.