How do I check whether all database tables are installed correctly?

AdFuz creates dedicated, indexed custom database tables upon activation to deliver high-speed ad serving, event deduplication, real-time analytics rollups, and audit logging without loading WordPress default post tables.

You can inspect, manage, and repair these tables directly from WordPress Admin > AdFuz > Tools > Database Tools.

---

Complete AdFuz Database Tables Directory

The AdFuz database schema is categorized into 5 core functional groups:

1. Ads Group

Table Name	Description	Status
wp_adfuz_ads	Core ad records, creative formats, and display settings	● Installed
wp_adfuz_ads_meta	Extended ad metadata, custom attributes, and tracking URLs	● Installed

---

2. Ad Spaces Group

Table Name	Description	Status
wp_adfuz_ad_spaces	Ad placement zones, responsive dimensions, and slot configurations	● Installed
wp_adfuz_ad_spaces_meta	Ad space metadata, styling overrides, and zone tags	● Installed

---

3. Campaigns Group

Table Name	Description	Status
wp_adfuz_campaigns	Campaign definitions, pacing rules, and budget caps	● Installed
wp_adfuz_campaigns_meta	Campaign metadata and custom settings	● Installed
wp_adfuz_campaign_ads	Relational mapping between Campaigns and Ads	● Installed
wp_adfuz_campaign_ad_spaces	Relational mapping between Campaigns and Ad Spaces	● Installed
wp_adfuz_campaign_target_countries	Country-level geo-targeting rules for active campaigns	● Installed
wp_adfuz_campaign_target_devices	Device targeting rules (Desktop, Mobile, Tablet)	● Installed

---

4. Audit & Stats Group

Table Name	Description	Status
wp_adfuz_audit_logs	System activity audit trail and change history	● Installed
wp_adfuz_audit_logs_meta	Additional contextual metadata for audit log records	● Installed

---

5. Stats & Reporting Group

Table Name	Description	Status
wp_adfuz_urls	Normalized page URLs used by tracked ad events	● Installed
wp_adfuz_event_dedup	Processed event keys used to prevent duplicate impression/click events	● Installed
wp_adfuz_stats	Partitioned raw ad interaction events for analytics and reporting	● Installed
wp_adfuz_stats_aggregation_state	Aggregation cursor state for incremental stats rollups	● Installed
wp_adfuz_daily_stats	Daily ad performance rollups by ad, campaign, placement, country, and device	● Installed
wp_adfuz_daily_stats_country	Daily ad performance rollups grouped by country	● Installed
wp_adfuz_daily_stats_device	Daily ad performance rollups grouped by device type	● Installed
wp_adfuz_stats_export_queue	Queued and generated background stats export jobs	● Installed

---

How to Access Database Tools in WordPress

1. Log in to your WordPress Admin Dashboard.
2. Navigate to AdFuz > Tools from the left sidebar menu.
3. Open the Database Tools panel.
4. Under the Tables tab, verify the Status column:
   • ● Installed indicates the table exists and is fully operational.
   • ● Missing indicates the table was not created during activation.

---

Database Management Actions

Inside Database Tools, you have individual and bulk management controls:

Per-Table Actions

• Clear Data: Truncates all rows inside the selected table while preserving the table schema and indexes.
• Drop: Drops the selected table from the database (useful for resetting a specific corrupted table).

Danger Zone Actions

Located at the bottom of the Database Tools screen:

Danger Zone Actions

• Drop ALL Plugin Tables: Irreversibly deletes all AdFuz custom database tables and all stored campaign and stats data.
• Re-install All Tables: Re-runs all database schema migrations to create any missing tables or repair damaged structures.

---

Method 2: Check via SQL Query or WP-CLI

If you prefer to verify tables through phpMyAdmin, MySQL CLI, or WP-CLI:

SQL Command (phpMyAdmin)

-- List all installed AdFuz tables
SHOW TABLES LIKE 'wp_adfuz_%';

WP-CLI Command

# Check all AdFuz tables and row counts via WP-CLI
wp db query "SHOW TABLE STATUS LIKE 'wp_adfuz_%';"

---

Troubleshooting Table Creation Issues

If any table is marked as Missing or fails to create:

1. Verify MySQL Privileges: Ensure your database user has CREATE, ALTER, INDEX, DROP, and TRIGGER permissions.
2. Re-install Tables: In AdFuz > Tools > Database Tools, scroll down to the Danger Zone and click Re-install All Tables.
3. Inspect Migrations Tab: Switch to the Migrations tab in Database Tools to review migration execution history and any failed SQL migration queries.