{"slug":"business-directory-plugin","name":"Business Directory Plugin – Easy Listing Directories for WordPress","description":"The easy Business Directory Plugin for WordPress. Build an easy team directory, member directory, staff directory, church directory, and more.","author":"Strategy11 Team","active_installs":10000,"version":"6.4.24","wp_org_url":"https://wordpress.org/plugins/business-directory-plugin/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"wpbdp_form_fields","full_table_name":"wp_wpbdp_form_fields","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"field_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"association","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"validators","type":"text","nullable":true,"primary_key":false},{"name":"weight","type":"int(5)","nullable":false,"primary_key":false},{"name":"display_flags","type":"text","nullable":true,"primary_key":false},{"name":"field_data","type":"blob","nullable":true,"primary_key":false},{"name":"shortname","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tag","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpbdp_form_fields ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, label varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, field_type varchar(100) NOT NULL, association varchar(100) NOT NULL, validators text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, weight int(5) NOT NULL DEFAULT 0, display_flags text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, field_data blob NULL, shortname varchar(255) NOT NULL DEFAULT '', tag varchar(255) NOT NULL DEFAULT '', KEY field_type (field_type) ) DEFAULT CHARSET"},{"table_name":"wpbdp_listings","full_table_name":"wp_wpbdp_listings","description":"Stores wpbdp listings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"listing_id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"fee_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"fee_price","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"fee_days","type":"smallint unsigned","nullable":true,"primary_key":false},{"name":"fee_images","type":"smallint unsigned","nullable":true,"primary_key":false},{"name":"expiration_date","type":"timestamp","nullable":true,"primary_key":false},{"name":"is_recurring","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_sticky","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"subscription_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"subscription_data","type":"longblob","nullable":true,"primary_key":false},{"name":"listing_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"flags","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpbdp_listings ( listing_id bigint(20) PRIMARY KEY, fee_id bigint(20) NULL, fee_price decimal(10,2) NULL DEFAULT 0.00, fee_days smallint unsigned NULL DEFAULT 0, fee_images smallint unsigned NULL DEFAULT 0, expiration_date timestamp NULL DEFAULT NULL, is_recurring tinyint(1) NOT NULL DEFAULT 0, is_sticky tinyint(1) NOT NULL DEFAULT 0, subscription_id varchar(255) NULL DEFAULT '', subscription_data longblob NULL, listing_status varchar(255) NOT NULL DEFAULT 'unknown', flags varchar(255) NOT NULL DEFAULT '' ) DEFAULT CHARSET"},{"table_name":"wpbdp_logs","full_table_name":"wp_wpbdp_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"object_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"rel_object_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"object_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"log_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"actor","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"data","type":"longblob","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpbdp_logs ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, object_id bigint(20) NULL DEFAULT 0, rel_object_id bigint(20) NULL DEFAULT 0, object_type varchar(20) NULL DEFAULT '', created_at datetime NOT NULL, log_type varchar(255) NULL DEFAULT '', actor varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', message text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', data longblob NULL ) DEFAULT CHARSET"},{"table_name":"wpbdp_payments","full_table_name":"wp_wpbdp_payments","description":"Stores wpbdp payments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"listing_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"payment_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payment_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payment_items","type":"longblob","nullable":true,"primary_key":false},{"name":"data","type":"longblob","nullable":true,"primary_key":false},{"name":"context","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_first_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_last_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_data","type":"blob","nullable":true,"primary_key":false},{"name":"gateway","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"gateway_tx_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"currency_code","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_test","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"processed_on","type":"timestamp","nullable":true,"primary_key":false},{"name":"processed_by","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpbdp_payments ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, listing_id bigint(20) NOT NULL DEFAULT 0, parent_id bigint(20) NOT NULL DEFAULT 0, payment_key varchar(255) NULL DEFAULT '', payment_type varchar(255) NULL DEFAULT '', payment_items longblob NULL, data longblob NULL, context varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_first_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_last_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_data blob NULL, gateway varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, gateway_tx_id varchar(255) NULL DEFAULT '', currency_code varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'USD', amount decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, is_test boolean NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', processed_on timestamp NULL DEFAULT NULL, processed_by varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, KEY listing_id (listing_id), KEY status (status) ) DEFAULT CHARSET"},{"table_name":"wpbdp_plans","full_table_name":"wp_wpbdp_plans","description":"Stores wpbdp plans data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"days","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"images","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"sticky","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"recurring","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"pricing_model","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"pricing_details","type":"blob","nullable":true,"primary_key":false},{"name":"supported_categories","type":"text","nullable":false,"primary_key":false},{"name":"weight","type":"int(5)","nullable":false,"primary_key":false},{"name":"enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"extra_data","type":"longblob","nullable":true,"primary_key":false},{"name":"tag","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpbdp_plans ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, label varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, amount decimal(10,2) NOT NULL DEFAULT 0.00, days smallint unsigned NOT NULL DEFAULT 0, images smallint unsigned NOT NULL DEFAULT 0, sticky tinyint(1) NOT NULL DEFAULT 0, recurring tinyint(1) NOT NULL DEFAULT 0, pricing_model varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'flat', pricing_details blob NULL, supported_categories text NOT NULL DEFAULT '', weight int(5) NOT NULL DEFAULT 0, enabled tinyint(1) NOT NULL DEFAULT 1, description TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', extra_data longblob NULL, tag varchar(255) NOT NULL DEFAULT '' ) DEFAULT CHARSET"}],"table_count":5}