{"table_name":"metasync_sync_history","full_table_name":"wp_metasync_sync_history","description":"Stores metasync sync history data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_metasync_sync_history ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL DEFAULT '', source VARCHAR(50) NOT NULL DEFAULT '', status VARCHAR(25) NOT NULL DEFAULT 'draft', content_type VARCHAR(50) NOT NULL DEFAULT '', url TEXT NULL, meta_data TEXT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY id (id), KEY source (source), KEY status (status), KEY created_at (created_at), KEY idx_dedup (source, created_at), KEY idx_search (title(50), source, created_at) ) $collate;\"; dbDelta($table_sql);","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"content_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_data","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"metasync","name":"Search Atlas SEO – OTTO AI SEO Automation for WordPress","active_installs":7000,"version":"2.7.3","wp_org_url":"https://wordpress.org/plugins/metasync/"}}