{"table_name":"jbusinessdirectory_packages","full_table_name":"wp_jbusinessdirectory_packages","description":"Stores jbusinessdirectory packages data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_jbusinessdirectory_packages` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) DEFAULT NULL, `description` text, `show_features` tinyint(1) DEFAULT '1', `show_buttons` tinyint(1) DEFAULT '1', `price_description` text, `expiration_type` tinyint(1) DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, `trial_price` decimal(12,2) DEFAULT NULL, `trial_days` smallint NOT NULL DEFAULT '0', `trial_period_unit` varchar(10) NOT NULL DEFAULT 'D', `trial_period_amount` smallint DEFAULT NULL, `recurrence_count` tinyint DEFAULT NULL, `special_price` decimal(12,2) DEFAULT NULL, `special_from_date` date DEFAULT NULL, `special_to_date` date DEFAULT NULL, `days` smallint NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '0', `ordering` tinyint NOT NULL DEFAULT '0', `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', `show_price_per_month` tinyint(1) NOT NULL DEFAULT '0', `max_pictures` smallint NOT NULL DEFAULT '15', `max_videos` smallint NOT NULL DEFAULT '5', `max_attachments` smallint NOT NULL DEFAULT '5', `max_categories` smallint NOT NULL DEFAULT '10', `popular` tinyint(1) NOT NULL DEFAULT '0', `max_offers` smallint NOT NULL DEFAULT '0', `offer_count_type` tinyint(1) NOT NULL DEFAULT '0', `max_events` smallint NOT NULL DEFAULT '0', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `package_usergroup` varchar(255) DEFAULT '1', `bg_color` varchar(45) DEFAULT NULL, `text_color` varchar(45) DEFAULT NULL, `border_color` varchar(45) DEFAULT NULL, `show_disable_features` tinyint(1) DEFAULT '1', `max_quote_replies` int NOT NULL DEFAULT '5', `renewal_price` decimal(12,2) DEFAULT NULL, `max_zipcodes` smallint NOT NULL DEFAULT '0', `package_type` tinyint(1) DEFAULT '1', `max_trips` smallint NOT NULL DEFAULT '0', `max_locations` smallint NOT NULL DEFAULT '0', `max_description_length` smallint DEFAULT '1200', `max_sounds` smallint NOT NULL DEFAULT '5', `max_projects` smallint DEFAULT '5', `max_activity_cities` smallint DEFAULT '0', `max_activity_regions` smallint DEFAULT '0', `max_activity_countries` smallint DEFAULT '0', `require_review` tinyint DEFAULT '0', `fixed_end_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_package_usergroup` (`package_usergroup`), KEY `idx_status` (`status`), KEY `idx_price` (`price`), KEY `idx_expiration_type` (`expiration_type`), KEY `idx_only_for_admin` (`only_for_admin`) ) ENGINE","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"show_features","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"show_buttons","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"price_description","type":"text","nullable":true,"primary_key":false},{"name":"expiration_type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"trial_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"trial_days","type":"smallint","nullable":false,"primary_key":false},{"name":"trial_period_unit","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"trial_period_amount","type":"smallint","nullable":true,"primary_key":false},{"name":"recurrence_count","type":"tinyint","nullable":true,"primary_key":false},{"name":"special_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"special_from_date","type":"date","nullable":true,"primary_key":false},{"name":"special_to_date","type":"date","nullable":true,"primary_key":false},{"name":"days","type":"smallint","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"time_unit","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"time_amount","type":"mediumint","nullable":false,"primary_key":false},{"name":"show_price_per_month","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"max_pictures","type":"smallint","nullable":false,"primary_key":false},{"name":"max_videos","type":"smallint","nullable":false,"primary_key":false},{"name":"max_attachments","type":"smallint","nullable":false,"primary_key":false},{"name":"max_categories","type":"smallint","nullable":false,"primary_key":false},{"name":"popular","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"max_offers","type":"smallint","nullable":false,"primary_key":false},{"name":"offer_count_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"max_events","type":"smallint","nullable":false,"primary_key":false},{"name":"only_for_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"package_usergroup","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"bg_color","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"text_color","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"border_color","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"show_disable_features","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"max_quote_replies","type":"int","nullable":false,"primary_key":false},{"name":"renewal_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"max_zipcodes","type":"smallint","nullable":false,"primary_key":false},{"name":"package_type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"max_trips","type":"smallint","nullable":false,"primary_key":false},{"name":"max_locations","type":"smallint","nullable":false,"primary_key":false},{"name":"max_description_length","type":"smallint","nullable":true,"primary_key":false},{"name":"max_sounds","type":"smallint","nullable":false,"primary_key":false},{"name":"max_projects","type":"smallint","nullable":true,"primary_key":false},{"name":"max_activity_cities","type":"smallint","nullable":true,"primary_key":false},{"name":"max_activity_regions","type":"smallint","nullable":true,"primary_key":false},{"name":"max_activity_countries","type":"smallint","nullable":true,"primary_key":false},{"name":"require_review","type":"tinyint","nullable":true,"primary_key":false},{"name":"fixed_end_date","type":"date","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-businessdirectory","name":"WP-BusinessDirectory – Business directory plugin for WordPress","active_installs":50,"version":"4.0.2","wp_org_url":"https://wordpress.org/plugins/wp-businessdirectory/"}}