{"table_name":"instarank_changes","full_table_name":"wp_instarank_changes","description":"Stores instarank changes data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_instarank_changes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, post_id bigint(20) unsigned NOT NULL, change_type varchar(50) NOT NULL, field_name varchar(100) DEFAULT NULL, old_value longtext, new_value longtext, status varchar(20) DEFAULT 'pending', applied_at datetime DEFAULT NULL, rolled_back_at datetime DEFAULT NULL, metadata longtext, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY status (status), KEY created_at (created_at) ) $charset_collate;\"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"post_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"change_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"field_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"old_value","type":"longtext","nullable":true,"primary_key":false},{"name":"new_value","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"applied_at","type":"datetime","nullable":true,"primary_key":false},{"name":"rolled_back_at","type":"datetime","nullable":true,"primary_key":false},{"name":"metadata","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"instarank","name":"InstaRank","active_installs":0,"version":"2.0.9","wp_org_url":"https://wordpress.org/plugins/instarank/"}}