{"slug":"wp-dxp","name":"WP-DXP","description":"WP-DXP is a plugin to allow you to personalize the content on your WordPress site.","author":"tommc1985filter","active_installs":10,"version":"1.6.8","wp_org_url":"https://wordpress.org/plugins/wp-dxp/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dxp_active_blocks","full_table_name":"wp_dxp_active_blocks","description":"Stores dxp active blocks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"rule_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dxp_active_blocks ( `id` bigint(20) unsigned NOT NULL default 0, `rule_id` bigint(20) unsigned NOT NULL default 0, `post_id` bigint(20) unsigned NOT NULL default 0, `name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`, `rule_id`, `post_id`), KEY rule_id (`rule_id`), KEY post_id (`post_id`) ) {$collate}; \"; $this->maybe_create_table( $table_name, $sql );"},{"table_name":"dxp_categories","full_table_name":"wp_dxp_categories","description":"Stores dxp categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"modified_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_wp_dxp_categories` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `created_at` datetime NOT NULL, `modified_at` datetime NOT NULL, PRIMARY KEY (`id`) ) {$charset_collate};\");"},{"table_name":"dxp_rules","full_table_name":"wp_dxp_rules","description":"Stores dxp rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"conditions_json","type":"mediumtext","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"modified_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_wp_dxp_rules` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `category_id` int(11) NOT NULL, `type` varchar(30) NOT NULL, `conditions_json` mediumtext NOT NULL, `created_by` bigint(20) NOT NULL, `created_at` datetime NOT NULL, `modified_at` datetime NOT NULL, PRIMARY KEY (`id`) ) {$charset_collate};\");"}],"table_count":3}