{"slug":"instarank","name":"InstaRank","description":"AI-powered SEO optimization and programmatic content for WordPress. Auto-apply improvements and sync custom post types.","author":"instarank","active_installs":0,"version":"2.0.9","wp_org_url":"https://wordpress.org/plugins/instarank/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"instarank_auth_log","full_table_name":"wp_instarank_auth_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"instarank_changes","full_table_name":"wp_instarank_changes","description":"Stores instarank changes data created by this plugin.","detection_method":"static","confidence":"high","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}],"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');"}],"table_count":2}