wp_content_regions
StaticStores content regions data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT | YES |
| 🔑region_id | INT | NO |
| name | VARCHAR(255) | NO |
| 🔑leagues | TEXT | NO |
| match_code | VARCHAR(255) | YES |
| region | VARCHAR(255) | YES |
| team | VARCHAR(255) | YES |
| home | VARCHAR(255) | YES |
| away | VARCHAR(255) | YES |
| match_datetime | DATETIME | YES |
| time_zone | VARCHAR(50) | YES |
| provider | VARCHAR(100) | YES |
| odds | TEXT | YES |
| processed | BOOLEAN | YES |
| processed_started_at | TIMESTAMP | YES |
| process_completed_at | TIMESTAMP | YES |
| processed_failed_at | TIMESTAMP | YES |
| created_at | TIMESTAMP | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_content_regions ( id INT AUTO_INCREMENT PRIMARY KEY, region_id INT NOT NULL UNIQUE ) $charset_collate;", 'football_regions' => "CREATE TABLE IF NOT EXISTS wp_football_regions ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) UNIQUE NOT NULL, leagues TEXT NOT NULL ) $charset_collate;", 'football_games' => "CREATE TABLE IF NOT EXISTS wp_football_games ( id BIGINT NOT NULL AUTO_INCREMENT, match_code VARCHAR(255), region VARCHAR(255), team VARCHAR(255), home VARCHAR(255), away VARCHAR(255), match_datetime DATETIME, time_zone VARCHAR(50), provider VARCHAR(100), odds TEXT, processed BOOLEAN DEFAULT 0, processed_started_at TIMESTAMP NULL, process_completed_at TIMESTAMP NULL, processed_failed_at TIMESTAMP NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY match_code (match_code) ) $charset_collate;" ]; foreach ($tables as $table_name => $sql) { $result = dbDelta($sql);Safe to delete?
If you have uninstalled AI Sports Writer, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_content_regions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI Sports Writer