{"table_name":"wpbdp_listings","full_table_name":"wp_wpbdp_listings","description":"Stores wpbdp listings data created by this plugin.","detection_method":"static","confidence":"medium","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","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}],"plugin":{"slug":"business-directory-plugin","name":"Business Directory Plugin – Easy Listing Directories for WordPress","active_installs":10000,"version":"6.4.24","wp_org_url":"https://wordpress.org/plugins/business-directory-plugin/"}}