{"table_name":"content_regions","full_table_name":"wp_content_regions","description":"Stores content regions data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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);","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"region_id","type":"INT","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"leagues","type":"TEXT","nullable":false,"primary_key":true},{"name":"match_code","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"region","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"team","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"home","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"away","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"match_datetime","type":"DATETIME","nullable":true,"primary_key":false},{"name":"time_zone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"provider","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"odds","type":"TEXT","nullable":true,"primary_key":false},{"name":"processed","type":"BOOLEAN","nullable":true,"primary_key":false},{"name":"processed_started_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"process_completed_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"processed_failed_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"plugin":{"slug":"ai-sports-writer","name":"AI Sports Writer","active_installs":10,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/ai-sports-writer/"}}