{"slug":"wp-businessdirectory","name":"WP-BusinessDirectory – Business directory plugin for WordPress","description":"WP-BusinessDirectory is not just a simple business directory plugin, it is the most advanced business directory, classified ads directory, job listing …","author":"CMSJunkie - WordPress Business Directory Plugins","active_installs":50,"version":"4.0.2","wp_org_url":"https://wordpress.org/plugins/wp-businessdirectory/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"jbusinessdirectory_application_settings","full_table_name":"wp_jbusinessdirectory_application_settings","description":"Stores jbusinessdirectory application settings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"value","type":"text","nullable":true,"primary_key":false},{"name":"text","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(110)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_application_settings` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `value` text, `text` varchar(100) DEFAULT NULL, `description` varchar(110) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE"},{"table_name":"jbusinessdirectory_attribute_category","full_table_name":"wp_jbusinessdirectory_attribute_category","description":"Stores jbusinessdirectory attribute category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"attributeId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_attribute_category` ( `attributeId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`attributeId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_attribute_options","full_table_name":"wp_jbusinessdirectory_attribute_options","description":"Stores jbusinessdirectory attribute options data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"attribute_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_attribute_options` ( `id` int NOT NULL AUTO_INCREMENT, `attribute_id` int DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_attribute_id` (`attribute_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_attribute_types","full_table_name":"wp_jbusinessdirectory_attribute_types","description":"Stores jbusinessdirectory attribute types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_attribute_types` ( `id` int NOT NULL AUTO_INCREMENT, `code` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_attributes","full_table_name":"wp_jbusinessdirectory_attributes","description":"Stores jbusinessdirectory attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":true,"primary_key":false},{"name":"is_mandatory","type":"int","nullable":false,"primary_key":false},{"name":"show_in_filter","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"only_for_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_in_front","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_on_search","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_icon","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_name","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"color","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"group","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"attribute_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_in_list_view","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_attribute_for_selling","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `code` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL, `is_mandatory` int NOT NULL DEFAULT '0', `show_in_filter` tinyint(1) NOT NULL DEFAULT '1', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `show_in_front` tinyint(1) NOT NULL DEFAULT '0', `show_on_search` tinyint(1) NOT NULL DEFAULT '0', `show_icon` tinyint(1) NOT NULL DEFAULT '0', `show_name` tinyint(1) NOT NULL DEFAULT '1', `color` varchar(10) DEFAULT NULL, `group` varchar(255) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `attribute_type` tinyint(1) NOT NULL DEFAULT '1', `show_in_list_view` tinyint(1) NOT NULL DEFAULT '0', `use_attribute_for_selling` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_type` (`type`), KEY `idx_attribute_type` (`attribute_type`) ) ENGINE"},{"table_name":"jbusinessdirectory_billing_details","full_table_name":"wp_jbusinessdirectory_billing_details","description":"Stores jbusinessdirectory billing details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"vat_details","type":"varchar(455)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_billing_details` ( `id` int NOT NULL AUTO_INCREMENT, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `company_name` varchar(55) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `postal_code` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `region` varchar(45) DEFAULT NULL, `country` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `user_id` int DEFAULT NULL, `vat_details` varchar(455) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_blocked_users","full_table_name":"wp_jbusinessdirectory_blocked_users","description":"Stores jbusinessdirectory blocked users data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"user_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"blocked_id","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_blocked_users` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `blocked_id` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_blocked_id` (`blocked_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_bookmarks","full_table_name":"wp_jbusinessdirectory_bookmarks","description":"Stores jbusinessdirectory bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_id","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"note","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"item_type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"company_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ordering","type":"int","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_bookmarks` ( `id` int NOT NULL AUTO_INCREMENT, `item_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `note` varchar(255) DEFAULT NULL, `item_type` tinyint(1) DEFAULT '1', `company_id` varchar(100) DEFAULT NULL, `ordering` int NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unq_bkm` (`item_id`,`user_id`,`item_type`), KEY `idx_item_id` (`item_id`), KEY `idx_user_id` (`user_id`), KEY `idx_item_type` (`item_type`) ) ENGINE"},{"table_name":"jbusinessdirectory_campaign_has_plans","full_table_name":"wp_jbusinessdirectory_campaign_has_plans","description":"Stores jbusinessdirectory campaign has plans data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"campaign_id","type":"int","nullable":false,"primary_key":false},{"name":"campaign_plan_id","type":"int","nullable":false,"primary_key":false},{"name":"nr_clicks","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_campaign_has_plans` ( `campaign_id` int NOT NULL, `campaign_plan_id` int NOT NULL, `nr_clicks` int DEFAULT '0', PRIMARY KEY (`campaign_id`,`campaign_plan_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_campaign_plans","full_table_name":"wp_jbusinessdirectory_campaign_plans","description":"Stores jbusinessdirectory campaign plans data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":false,"primary_key":false},{"name":"image","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"click_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_campaign_plans` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) DEFAULT NULL, `type` int NOT NULL DEFAULT '1', `image` varchar(100) DEFAULT NULL, `click_price` decimal(12,2) DEFAULT NULL, `published` tinyint DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_published` (`published`) ) ENGINE"},{"table_name":"jbusinessdirectory_campaigns","full_table_name":"wp_jbusinessdirectory_campaigns","description":"Stores jbusinessdirectory campaigns data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(145)","nullable":false,"primary_key":false},{"name":"type","type":"int","nullable":false,"primary_key":false},{"name":"initial_budget","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"budget","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":true,"primary_key":false},{"name":"item_id","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_campaigns` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) NOT NULL, `type` int NOT NULL DEFAULT '1', `initial_budget` decimal(12,2) DEFAULT '0.00', `budget` decimal(12,2) DEFAULT '0.00', `status` tinyint DEFAULT '0', `published` tinyint DEFAULT '1', `item_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_items_id` (`item_id`), KEY `idx_status` (`published`) ) ENGINE"},{"table_name":"jbusinessdirectory_categories","full_table_name":"wp_jbusinessdirectory_categories","description":"Stores jbusinessdirectory categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"parent_id","type":"int","nullable":false,"primary_key":false},{"name":"lft","type":"int","nullable":false,"primary_key":false},{"name":"rgt","type":"int","nullable":false,"primary_key":false},{"name":"level","type":"int UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"imageLocation","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"markerLocation","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"color","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"clickCount","type":"int","nullable":false,"primary_key":false},{"name":"meta_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_description","type":"text","nullable":true,"primary_key":false},{"name":"meta_keywords","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"iconImgLocation","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"keywords","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"user_as_container","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_categories` ( `id` int NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT '0', `lft` int NOT NULL DEFAULT '0', `rgt` int NOT NULL DEFAULT '0', `level` int UNSIGNED NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '1', `name` varchar(100) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `description` text, `published` tinyint NOT NULL DEFAULT '1', `imageLocation` varchar(250) DEFAULT NULL, `markerLocation` varchar(250) DEFAULT NULL, `color` varchar(10) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `clickCount` int NOT NULL DEFAULT '0', `meta_title` varchar(255) DEFAULT NULL, `meta_description` text, `meta_keywords` varchar(255) DEFAULT NULL, `iconImgLocation` varchar(250) DEFAULT NULL, `keywords` varchar(250) DEFAULT NULL, `user_as_container` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_parent` (`parent_id`), KEY `idx_name` (`name`), KEY `idx_state` (`published`), KEY `idx_type` (`type`), KEY `idx_lft` (`lft`), KEY `idx_rgt` (`rgt`), KEY `idx_level` (`level`) ) ENGINE"},{"table_name":"jbusinessdirectory_cities","full_table_name":"wp_jbusinessdirectory_cities","description":"Stores jbusinessdirectory cities data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"region_id","type":"int","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_cities` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(65) DEFAULT NULL, `region_id` int DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_region` (`region_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_companies","full_table_name":"wp_jbusinessdirectory_companies","description":"Stores jbusinessdirectory companies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"comercialName","type":"varchar(120)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"meta_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"meta_description","type":"text","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"province","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"area","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"website","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"keywords","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"registrationCode","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"fax","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"state","type":"tinyint","nullable":true,"primary_key":false},{"name":"typeId","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"logoLocation","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"creationDate","type":"timestamp","nullable":true,"primary_key":false},{"name":"modified","type":"datetime","nullable":true,"primary_key":false},{"name":"mainSubcategory","type":"int","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"activity_radius","type":"decimal(10,0)","nullable":false,"primary_key":false},{"name":"userId","type":"int","nullable":false,"primary_key":false},{"name":"created_by","type":"int","nullable":false,"primary_key":false},{"name":"averageRating","type":"decimal(2,1)","nullable":false,"primary_key":false},{"name":"review_score","type":"decimal(2,1)","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"websiteCount","type":"int","nullable":false,"primary_key":false},{"name":"contactCount","type":"int","nullable":false,"primary_key":false},{"name":"taxCode","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"package_id","type":"int","nullable":false,"primary_key":false},{"name":"facebook","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"twitter","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"googlep","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"skype","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"linkedin","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"youtube","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"instagram","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"pinterest","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"whatsapp","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"slogan","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"publish_only_city","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"business_hours","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"notes_hours","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"custom_tab_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"custom_tab_content","type":"text","nullable":true,"primary_key":false},{"name":"job_tab_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"job_tab_content","type":"text","nullable":true,"primary_key":false},{"name":"business_cover_image","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"publish_start_date","type":"date","nullable":true,"primary_key":false},{"name":"publish_end_date","type":"date","nullable":true,"primary_key":false},{"name":"notified_date","type":"timestamp","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"establishment_year","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"employees","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ad_image","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"disapproval_text","type":"text","nullable":true,"primary_key":false},{"name":"yelp_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"enable_request_quote","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"trail_weeks_hours","type":"text","nullable":true,"primary_key":false},{"name":"trail_weeks_status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"trail_weeks_address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ad_caption","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"recommended","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"company_view","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"opening_status","type":"tinyint","nullable":false,"primary_key":false},{"name":"min_project_size","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"hourly_rate","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"tiktok","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"areas_served","type":"varchar(455)","nullable":true,"primary_key":false},{"name":"available_dates","type":"varchar(445)","nullable":true,"primary_key":false},{"name":"review_status","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_companies` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `comercialName` varchar(120) DEFAULT NULL, `short_description` varchar(500) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `street_number` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `countryId` int DEFAULT NULL, `website` varchar(250) DEFAULT NULL, `keywords` varchar(250) DEFAULT NULL, `registrationCode` varchar(20) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `state` tinyint DEFAULT '1', `typeId` varchar(255) DEFAULT NULL, `logoLocation` varchar(245) DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `modified` datetime DEFAULT NULL, `mainSubcategory` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `activity_radius` decimal(10,0) NOT NULL DEFAULT '0', `userId` int NOT NULL DEFAULT '0', `created_by` int NOT NULL DEFAULT '0', `averageRating` decimal(2,1) NOT NULL DEFAULT '0.0', `review_score` decimal(2,1) NOT NULL DEFAULT '0.0', `approved` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int NOT NULL DEFAULT '0', `websiteCount` int NOT NULL DEFAULT '0', `contactCount` int NOT NULL DEFAULT '0', `taxCode` varchar(45) DEFAULT NULL, `package_id` int NOT NULL DEFAULT '0', `facebook` varchar(150) DEFAULT NULL, `twitter` varchar(150) DEFAULT NULL, `googlep` varchar(150) DEFAULT NULL, `skype` varchar(150) DEFAULT NULL, `linkedin` varchar(150) DEFAULT NULL, `youtube` varchar(150) DEFAULT NULL, `instagram` varchar(150) DEFAULT NULL, `pinterest` varchar(150) DEFAULT NULL, `whatsapp` varchar(150) DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `mobile` varchar(55) DEFAULT NULL, `slogan` varchar(500) DEFAULT NULL, `publish_only_city` tinyint(1) DEFAULT '0', `featured` tinyint(1) NOT NULL DEFAULT '0', `business_hours` varchar(255) DEFAULT NULL, `notes_hours` varchar(255) DEFAULT NULL, `custom_tab_name` varchar(100) DEFAULT NULL, `custom_tab_content` text, `job_tab_name` varchar(100) DEFAULT NULL, `job_tab_content` text, `business_cover_image` varchar(245) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `notified_date` timestamp NULL DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `establishment_year` varchar(10) DEFAULT NULL, `employees` varchar(100) DEFAULT NULL, `ad_image` varchar(250) DEFAULT NULL, `disapproval_text` text, `yelp_id` varchar(255) DEFAULT NULL, `enable_request_quote` tinyint(1) DEFAULT '1', `trail_weeks_hours` text, `trail_weeks_status` tinyint(1) DEFAULT '1', `trail_weeks_address` varchar(100) DEFAULT NULL, `ad_caption` varchar(245) DEFAULT NULL, `recommended` tinyint(1) DEFAULT '0', `ordering` tinyint NOT NULL DEFAULT '0', `company_view` tinyint(1) DEFAULT '0', `opening_status` tinyint NOT NULL DEFAULT '0', `min_project_size` varchar(100) DEFAULT NULL, `hourly_rate` varchar(10) DEFAULT NULL, `tiktok` varchar(150) DEFAULT NULL, `areas_served` varchar(455) DEFAULT NULL, `available_dates` varchar(445) DEFAULT NULL, `review_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_type` (`typeId`), KEY `idx_user` (`userId`), KEY `idx_state` (`state`), KEY `idx_approved` (`approved`), KEY `idx_country` (`countryId`), KEY `idx_package` (`package_id`), KEY `idx_name` (`name`), KEY `idx_keywords` (`keywords`), KEY `idx_description` (`description`(100)), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_maincat` (`mainSubcategory`), KEY `idx_zipcode` (`latitude`,`longitude`), KEY `idx_phone` (`phone`), KEY `idx_creationDate` (`creationDate`), KEY `idx_review_score` (`review_score`), KEY `idx_province` (`province`), KEY `idx_area` (`area`), KEY `idx_publish_start_date` (`publish_start_date`), KEY `idx_publish_end_date` (`publish_end_date`), KEY `idx_alias` (`alias`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_activity_city","full_table_name":"wp_jbusinessdirectory_company_activity_city","description":"Stores jbusinessdirectory company activity city data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"city_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_activity_city` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `city_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`company_id`,`city_id`), KEY `idx_company` (`company_id`), KEY `idx_city` (`city_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_activity_country","full_table_name":"wp_jbusinessdirectory_company_activity_country","description":"Stores jbusinessdirectory company activity country data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"country_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_activity_country` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `country_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`company_id`,`country_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_activity_region","full_table_name":"wp_jbusinessdirectory_company_activity_region","description":"Stores jbusinessdirectory company activity region data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"region_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_activity_region` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `region_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`company_id`,`region_id`), KEY `idx_company` (`company_id`), KEY `idx_city` (`region_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_announcements","full_table_name":"wp_jbusinessdirectory_company_announcements","description":"Stores jbusinessdirectory company announcements data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"call_to_action","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"button_text","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"button_link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"expiration_date","type":"date","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_announcements` ( `id` int NOT NULL AUTO_INCREMENT, `call_to_action` int NOT NULL, `company_id` int NOT NULL, `title` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, `button_text` varchar(255) DEFAULT NULL, `button_link` varchar(255) DEFAULT NULL, `status` tinyint DEFAULT '1', `expiration_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company_id` (`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_articles","full_table_name":"wp_jbusinessdirectory_company_articles","description":"Stores jbusinessdirectory company articles data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"article_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_articles` ( `article_id` int NOT NULL, `company_id` int NOT NULL, PRIMARY KEY (`article_id`), KEY `idx_company` (`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_attachments","full_table_name":"wp_jbusinessdirectory_company_attachments","description":"Stores jbusinessdirectory company attachments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"type","type":"tinyint","nullable":true,"primary_key":false},{"name":"object_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"path","type":"varchar(155)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_attachments` ( `id` int NOT NULL AUTO_INCREMENT, `type` tinyint DEFAULT NULL, `object_id` int DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `path` varchar(155) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_type` (`type`), KEY `idx_object` (`object_id`), KEY `idx_status` (`status`), KEY `idx_order` (`ordering`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_attributes","full_table_name":"wp_jbusinessdirectory_company_attributes","description":"Stores jbusinessdirectory company attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"attribute_id","type":"int","nullable":false,"primary_key":false},{"name":"value","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"option_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int NOT NULL, `attribute_id` int NOT NULL, `value` varchar(250) DEFAULT NULL, `option_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `company_UNIQUE` (`company_id`,`attribute_id`,`value`), KEY `idx_company_id` (`company_id`), KEY `idx_attribute_id` (`attribute_id`), KEY `idx_option_id` (`option_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_category","full_table_name":"wp_jbusinessdirectory_company_category","description":"Stores jbusinessdirectory company category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_category` ( `companyId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`companyId`,`categoryId`), KEY `idx_category` (`companyId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_city","full_table_name":"wp_jbusinessdirectory_company_city","description":"Stores jbusinessdirectory company city data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"city_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_city` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `city_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`company_id`,`city_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_claim","full_table_name":"wp_jbusinessdirectory_company_claim","description":"Stores jbusinessdirectory company claim data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":true,"primary_key":false},{"name":"firstName","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"lastName","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"function","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_claim` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int DEFAULT NULL, `firstName` varchar(55) DEFAULT NULL, `lastName` varchar(55) DEFAULT NULL, `function` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `email` varchar(65) DEFAULT NULL, `status` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_contact","full_table_name":"wp_jbusinessdirectory_company_contact","description":"Stores jbusinessdirectory company contact data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"contact_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"contact_function","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"contact_department","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"contact_job_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"contact_phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"contact_fax","type":"varchar(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_contact` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `contact_name` varchar(50) DEFAULT NULL, `contact_function` varchar(50) DEFAULT NULL, `contact_department` varchar(100) DEFAULT NULL, `contact_job_title` varchar(100) DEFAULT NULL, `contact_email` varchar(60) DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `contact_fax` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`,`companyId`), KEY `R_13` (`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_editors","full_table_name":"wp_jbusinessdirectory_company_editors","description":"Stores jbusinessdirectory company editors data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"editor_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_editors` ( `company_id` int NOT NULL, `editor_id` int NOT NULL, PRIMARY KEY (`company_id`,`editor_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_appointments","full_table_name":"wp_jbusinessdirectory_company_event_appointments","description":"Stores jbusinessdirectory company event appointments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"time","type":"time","nullable":true,"primary_key":false},{"name":"remarks","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"event_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_appointments` ( `id` int NOT NULL AUTO_INCREMENT, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `company_name` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `date` date DEFAULT NULL, `time` time DEFAULT NULL, `remarks` varchar(300) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `event_id` int NOT NULL, `company_id` int NOT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_event` (`event_id`), KEY `idx_user_id` (`user_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_associated_items","full_table_name":"wp_jbusinessdirectory_company_event_associated_items","description":"Stores jbusinessdirectory company event associated items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"event_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_associated_items` ( `event_id` int NOT NULL, `company_id` int NOT NULL, PRIMARY KEY (`event_id`,`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_booking_tickets","full_table_name":"wp_jbusinessdirectory_company_event_booking_tickets","description":"Stores jbusinessdirectory company event booking tickets data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"booking_id","type":"int","nullable":false,"primary_key":false},{"name":"ticket_id","type":"int","nullable":false,"primary_key":false},{"name":"ticket_quantity","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_booking_tickets` ( `booking_id` int NOT NULL, `ticket_id` int NOT NULL, `ticket_quantity` int DEFAULT NULL, PRIMARY KEY (`booking_id`,`ticket_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_bookings","full_table_name":"wp_jbusinessdirectory_company_event_bookings","description":"Stores jbusinessdirectory company event bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"event_id","type":"int","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"paid_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"country_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_bookings` ( `id` int NOT NULL AUTO_INCREMENT, `event_id` int NOT NULL, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `postal_code` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `region` varchar(45) DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paid_at` datetime DEFAULT NULL, `status` tinyint DEFAULT NULL, `user_id` int DEFAULT NULL, `initial_amount` decimal(12,2) DEFAULT NULL, `vat_amount` decimal(12,2) DEFAULT NULL, `vat` decimal(12,2) DEFAULT NULL, `country_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_event` (`event_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_category","full_table_name":"wp_jbusinessdirectory_company_event_category","description":"Stores jbusinessdirectory company event category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"eventId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_category` ( `eventId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`eventId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_pictures","full_table_name":"wp_jbusinessdirectory_company_event_pictures","description":"Stores jbusinessdirectory company event pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"eventId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"picture_title","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `eventId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', `picture_title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_event` (`eventId`), KEY `idx_status` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_tickets","full_table_name":"wp_jbusinessdirectory_company_event_tickets","description":"Stores jbusinessdirectory company event tickets data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"event_id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"min_booking","type":"int","nullable":true,"primary_key":false},{"name":"max_booking","type":"int","nullable":true,"primary_key":false},{"name":"quantity","type":"int","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_tickets` ( `id` int NOT NULL AUTO_INCREMENT, `event_id` int NOT NULL, `name` varchar(255) DEFAULT NULL, `description` text, `price` decimal(12,2) DEFAULT NULL, `published` tinyint NOT NULL DEFAULT '1', `min_booking` int DEFAULT NULL, `max_booking` int DEFAULT NULL, `quantity` int DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_event_id` (`event_id`), KEY `idx_published` (`published`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_event_types","full_table_name":"wp_jbusinessdirectory_company_event_types","description":"Stores jbusinessdirectory company event types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_event_types` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_events","full_table_name":"wp_jbusinessdirectory_company_events","description":"Stores jbusinessdirectory company events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(110)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"meta_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"meta_description","type":"text","nullable":true,"primary_key":false},{"name":"meta_keywords","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"end_time","type":"time","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"province","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"area","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"view_count","type":"int","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"recurring_id","type":"int","nullable":true,"primary_key":false},{"name":"contact_phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"doors_open_time","type":"time","nullable":true,"primary_key":false},{"name":"booking_open_date","type":"date","nullable":true,"primary_key":false},{"name":"booking_close_date","type":"date","nullable":true,"primary_key":false},{"name":"booking_open_time","type":"time","nullable":true,"primary_key":false},{"name":"booking_close_time","type":"time","nullable":true,"primary_key":false},{"name":"show_start_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_end_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_end_date","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_doors_open_time","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"currency_id","type":"int","nullable":false,"primary_key":false},{"name":"total_tickets","type":"int","nullable":true,"primary_key":false},{"name":"expiration_email_date","type":"datetime","nullable":true,"primary_key":false},{"name":"main_subcategory","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"enable_subscription","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"recurring_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attendance_mode","type":"tinyint","nullable":true,"primary_key":false},{"name":"attendance_url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"min_age","type":"tinyint","nullable":true,"primary_key":false},{"name":"max_age","type":"tinyint","nullable":true,"primary_key":false},{"name":"ticket_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"cover_image","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_events` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `name` varchar(110) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `short_description` varchar(245) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `start_date` date DEFAULT NULL, `start_time` time DEFAULT NULL, `end_date` date DEFAULT NULL, `end_time` time DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `view_count` int NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '0', `state` tinyint(1) DEFAULT NULL, `recurring_id` int DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `contact_email` varchar(60) DEFAULT NULL, `doors_open_time` time DEFAULT NULL, `booking_open_date` date DEFAULT NULL, `booking_close_date` date DEFAULT NULL, `booking_open_time` time DEFAULT NULL, `booking_close_time` time DEFAULT NULL, `show_start_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_date` tinyint(1) NOT NULL DEFAULT '0', `show_doors_open_time` tinyint(1) NOT NULL DEFAULT '0', `currency_id` int NOT NULL DEFAULT '0', `total_tickets` int DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `user_id` int DEFAULT NULL, `enable_subscription` tinyint(1) NOT NULL DEFAULT '0', `postalCode` varchar(55) DEFAULT NULL, `countryId` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `recurring_info` varchar(255) DEFAULT NULL, `attendance_mode` tinyint DEFAULT NULL, `attendance_url` varchar(245) DEFAULT NULL, `min_age` tinyint DEFAULT NULL, `max_age` tinyint DEFAULT NULL, `ticket_url` varchar(255) DEFAULT NULL, `cover_image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_name` (`name`), KEY `idx_alias` (`alias`), KEY `idx_countryId` (`countryId`), KEY `idx_created` (`created`), KEY `idx_recurring_id` (`recurring_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_user_id` (`user_id`), KEY `idx_search` (`start_date`,`end_time`,`end_date`,`state`,`approved`,`start_time`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_currency` (`currency_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_locations","full_table_name":"wp_jbusinessdirectory_company_locations","description":"Stores jbusinessdirectory company locations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"postalCode","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"activity_radius","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"province","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"area","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"identifier","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_locations` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(80) DEFAULT NULL, `company_id` int DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `postalCode` varchar(45) DEFAULT NULL, `countryId` int DEFAULT NULL, `activity_radius` decimal(10,2) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `identifier` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_country` (`countryId`), KEY `idx_company` (`company_id`), KEY `idx_identifier` (`identifier`), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_province` (`province`), KEY `idx_area` (`area`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_marketing_email_sent","full_table_name":"wp_jbusinessdirectory_company_marketing_email_sent","description":"Stores jbusinessdirectory company marketing email sent data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"email_type","type":"int","nullable":true,"primary_key":false},{"name":"number_email_sent","type":"int","nullable":true,"primary_key":false},{"name":"sending_date","type":"datetime","nullable":true,"primary_key":false},{"name":"failed_sent","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_marketing_email_sent` ( `id` int NOT NULL AUTO_INCREMENT, `email_type` int DEFAULT NULL, `number_email_sent` int DEFAULT NULL, `sending_date` datetime DEFAULT NULL, `failed_sent` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_members","full_table_name":"wp_jbusinessdirectory_company_members","description":"Stores jbusinessdirectory company members data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":false,"primary_key":false},{"name":"description","type":"varchar(350)","nullable":true,"primary_key":false},{"name":"image","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_members` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int NOT NULL, `name` varchar(50) DEFAULT NULL, `title` varchar(50) DEFAULT NULL, `type` int NOT NULL DEFAULT '0', `description` varchar(350) DEFAULT NULL, `image` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_membership","full_table_name":"wp_jbusinessdirectory_company_membership","description":"Stores jbusinessdirectory company membership data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"membership_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_membership` ( `company_id` int NOT NULL, `membership_id` int NOT NULL, PRIMARY KEY (`company_id`,`membership_id`), KEY `idx_category` (`company_id`,`membership_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_category","full_table_name":"wp_jbusinessdirectory_company_offer_category","description":"Stores jbusinessdirectory company offer category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"offerId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_category` ( `offerId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`offerId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_coupons","full_table_name":"wp_jbusinessdirectory_company_offer_coupons","description":"Stores jbusinessdirectory company offer coupons data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"offer_id","type":"int","nullable":true,"primary_key":false},{"name":"code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"generated_time","type":"datetime","nullable":true,"primary_key":false},{"name":"order_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_coupons` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `offer_id` int DEFAULT NULL, `code` varchar(50) DEFAULT NULL, `generated_time` datetime DEFAULT NULL, `order_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_offer_id` (`offer_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_order_products","full_table_name":"wp_jbusinessdirectory_company_offer_order_products","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"order_id","type":"int","nullable":false,"primary_key":false},{"name":"offer_id","type":"int","nullable":false,"primary_key":false},{"name":"quantity","type":"int","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"currencyId","type":"int","nullable":false,"primary_key":false},{"name":"combination_ids","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"combination_values","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_order_products` ( `order_id` int NOT NULL, `offer_id` int NOT NULL, `quantity` int DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, `currencyId` int NOT NULL, `combination_ids` varchar(255) DEFAULT NULL, `combination_values` varchar(255) DEFAULT NULL, PRIMARY KEY (`order_id`,`offer_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_orders","full_table_name":"wp_jbusinessdirectory_company_offer_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"token","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tracking_link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"shipping","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"shipping_method","type":"int","nullable":true,"primary_key":false},{"name":"vat_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"country_id","type":"int","nullable":true,"primary_key":false},{"name":"currency_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_orders` ( `id` int NOT NULL AUTO_INCREMENT, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `postal_code` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `region` varchar(45) DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `status` tinyint DEFAULT NULL, `token` varchar(255) DEFAULT NULL, `tracking_link` varchar(255) DEFAULT NULL, `shipping` decimal(12,2) DEFAULT NULL, `initial_amount` decimal(12,2) DEFAULT NULL, `shipping_method` int DEFAULT NULL, `vat_amount` decimal(12,2) DEFAULT NULL, `vat` decimal(12,2) DEFAULT NULL, `country_id` int DEFAULT NULL, `currency_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_pictures","full_table_name":"wp_jbusinessdirectory_company_offer_pictures","description":"Stores jbusinessdirectory company offer pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"offerId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"picture_title","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `offerId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', `picture_title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_offer` (`offerId`), KEY `idx_status` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offer_types","full_table_name":"wp_jbusinessdirectory_company_offer_types","description":"Stores jbusinessdirectory company offer types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offer_types` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_name` (`name`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_offers","full_table_name":"wp_jbusinessdirectory_company_offers","description":"Stores jbusinessdirectory company offers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"currencyId","type":"int","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(110)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"meta_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"meta_description","type":"text","nullable":true,"primary_key":false},{"name":"meta_keywords","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"specialPrice","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"price_base","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"price_base_unit","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"special_price_base","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"special_price_base_unit","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"total_coupons","type":"int","nullable":false,"primary_key":false},{"name":"startDate","type":"date","nullable":true,"primary_key":false},{"name":"endDate","type":"date","nullable":true,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"offerOfTheDay","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"viewCount","type":"int","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"street_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"county","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"province","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"area","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"publish_start_date","type":"date","nullable":true,"primary_key":false},{"name":"publish_end_date","type":"date","nullable":true,"primary_key":false},{"name":"view_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"url","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"article_id","type":"int","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"show_time","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"publish_start_time","type":"time","nullable":true,"primary_key":false},{"name":"publish_end_time","type":"time","nullable":true,"primary_key":false},{"name":"expiration_email_date","type":"datetime","nullable":true,"primary_key":false},{"name":"main_subcategory","type":"int","nullable":true,"primary_key":false},{"name":"enable_offer_selling","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"min_purchase","type":"int","nullable":true,"primary_key":false},{"name":"max_purchase","type":"int","nullable":true,"primary_key":false},{"name":"quantity","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"postalCode","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"price_text","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"offer_type","type":"int","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"item_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"notify_offer_quantity","type":"int","nullable":true,"primary_key":false},{"name":"use_stock_price","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"contact_email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"add_to_price_list","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"review_score","type":"decimal(2,1)","nullable":true,"primary_key":false},{"name":"packages","type":"varchar(75)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_offers` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `currencyId` int NOT NULL, `subject` varchar(110) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` decimal(12,2) DEFAULT NULL, `specialPrice` decimal(12,2) DEFAULT NULL, `price_base` decimal(12,2) DEFAULT NULL, `price_base_unit` varchar(45) DEFAULT NULL, `special_price_base` decimal(12,2) DEFAULT NULL, `special_price_base_unit` varchar(45) DEFAULT NULL, `total_coupons` int NOT NULL DEFAULT '0', `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `approved` tinyint(1) NOT NULL DEFAULT '0', `offerOfTheDay` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int DEFAULT '0', `alias` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `view_type` tinyint NOT NULL DEFAULT '1', `url` varchar(145) DEFAULT NULL, `article_id` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `show_time` tinyint(1) DEFAULT '0', `publish_start_time` time DEFAULT NULL, `publish_end_time` time DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `enable_offer_selling` tinyint(1) DEFAULT '1', `min_purchase` int DEFAULT NULL, `max_purchase` int DEFAULT NULL, `quantity` int DEFAULT NULL, `user_id` int DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `countryId` int DEFAULT NULL, `price_text` varchar(100) DEFAULT NULL, `offer_type` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `item_type` tinyint(1) NOT NULL DEFAULT '1', `notify_offer_quantity` int DEFAULT NULL, `use_stock_price` tinyint(1) DEFAULT NULL, `contact_email` varchar(100) DEFAULT NULL, `add_to_price_list` tinyint(1) DEFAULT '0', `review_score` decimal(2,1) DEFAULT '0.0', `packages` varchar(75) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_company` (`companyId`), KEY `idx_country` (`countryId`), KEY `idx_approved` (`approved`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_latitude` (`latitude`), KEY `idx_longitude` (`longitude`), KEY `idx_price` (`price`), KEY `idx_specialPrice` (`specialPrice`), KEY `idx_subject` (`subject`), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_area` (`area`), KEY `idx_province` (`province`), KEY `idx_short_description` (`short_description`(100)), KEY `idx_address` (`address`), KEY `idx_user_id` (`user_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_search` (`state`,`endDate`,`startDate`,`publish_end_date`,`publish_start_date`), KEY `idx_publish_time` (`publish_start_time`,`publish_end_time`), KEY `idx_offer_type` (`offer_type`), KEY `idx_packages` (`packages`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_pictures","full_table_name":"wp_jbusinessdirectory_company_pictures","description":"Stores jbusinessdirectory company pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"picture_title","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', `picture_title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`), KEY `idx_picture_enable` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_pictures_extra","full_table_name":"wp_jbusinessdirectory_company_pictures_extra","description":"Stores jbusinessdirectory company pictures extra data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"image_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"image_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"image_enable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"image_title","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_pictures_extra` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL DEFAULT '0', `image_info` varchar(255) DEFAULT NULL, `image_path` varchar(255) DEFAULT NULL, `image_enable` tinyint(1) NOT NULL DEFAULT '1', `image_title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`), KEY `idx_image_enable` (`image_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_product_merchants","full_table_name":"wp_jbusinessdirectory_company_product_merchants","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"product_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_product_merchants` ( `product_id` int NOT NULL, `company_id` int NOT NULL, PRIMARY KEY (`product_id`,`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_projects","full_table_name":"wp_jbusinessdirectory_company_projects","description":"Stores jbusinessdirectory company projects data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_projects` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `company_id` int NOT NULL, `user_id` int DEFAULT NULL, `description` text, `status` tinyint DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_companyId` (`company_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_projects_pictures","full_table_name":"wp_jbusinessdirectory_company_projects_pictures","description":"Stores jbusinessdirectory company projects pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"projectId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_projects_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `projectId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_projectId` (`projectId`), KEY `idx_status` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_provider_hours","full_table_name":"wp_jbusinessdirectory_company_provider_hours","description":"Stores jbusinessdirectory company provider hours data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"weekday","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"start_hour","type":"time","nullable":true,"primary_key":false},{"name":"end_hour","type":"time","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"item_type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"provider_id","type":"int","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_provider_hours` ( `id` int NOT NULL AUTO_INCREMENT, `weekday` tinyint(1) DEFAULT NULL, `start_hour` time DEFAULT NULL, `end_hour` time DEFAULT NULL, `type` tinyint(1) DEFAULT NULL, `status` tinyint(1) DEFAULT '1', `item_type` tinyint(1) DEFAULT '0', `provider_id` int NOT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_provider_id` (`provider_id`), KEY `idx_item_type` (`item_type`), KEY `idx_type` (`type`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_provider_services","full_table_name":"wp_jbusinessdirectory_company_provider_services","description":"Stores jbusinessdirectory company provider services data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"provider_id","type":"int","nullable":false,"primary_key":false},{"name":"service_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_provider_services` ( `provider_id` int NOT NULL, `service_id` int NOT NULL, PRIMARY KEY (`provider_id`,`service_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_providers","full_table_name":"wp_jbusinessdirectory_company_providers","description":"Stores jbusinessdirectory company providers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"max_clients","type":"int","nullable":true,"primary_key":false},{"name":"availability","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"image","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"istart_date","type":"date","nullable":true,"primary_key":false},{"name":"iend_date","type":"date","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_providers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` text, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `max_clients` int DEFAULT NULL, `availability` varchar(255) DEFAULT NULL, `published` tinyint NOT NULL DEFAULT '1', `company_id` int NOT NULL, `image` varchar(255) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `istart_date` date DEFAULT NULL, `iend_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company_id` (`company_id`), KEY `idx_published` (`published`), KEY `idx_availability` (`availability`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_ratings","full_table_name":"wp_jbusinessdirectory_company_ratings","description":"Stores jbusinessdirectory company ratings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"rating","type":"decimal(2,1)","nullable":false,"primary_key":false},{"name":"ipAddress","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_ratings` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `rating` decimal(2,1) NOT NULL DEFAULT '0.0', `ipAddress` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_region","full_table_name":"wp_jbusinessdirectory_company_region","description":"Stores jbusinessdirectory company region data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"region_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_region` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `region_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`company_id`,`region_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_registered","full_table_name":"wp_jbusinessdirectory_company_registered","description":"Stores jbusinessdirectory company registered data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"joined_company_id","type":"int","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_registered` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int NOT NULL, `joined_company_id` int NOT NULL, `approved` tinyint NOT NULL DEFAULT '0', `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_join_company` (`joined_company_id`), KEY `idx_user` (`user_id`), KEY `idx_approved` (`approved`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_related","full_table_name":"wp_jbusinessdirectory_company_related","description":"Stores jbusinessdirectory company related data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"related_company_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_related` ( `company_id` int NOT NULL, `related_company_id` int NOT NULL, PRIMARY KEY (`company_id`,`related_company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_requests","full_table_name":"wp_jbusinessdirectory_company_requests","description":"Stores jbusinessdirectory company requests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"quote_id","type":"int","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_requests` ( `company_id` int NOT NULL, `quote_id` int NOT NULL, `status` tinyint(1) DEFAULT '0', PRIMARY KEY (`company_id`,`quote_id`), KEY `idx_company_quote` (`company_id`,`quote_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_review_abuses","full_table_name":"wp_jbusinessdirectory_company_review_abuses","description":"Stores jbusinessdirectory company review abuses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"reviewId","type":"int","nullable":false,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_review_abuses` ( `id` int NOT NULL AUTO_INCREMENT, `reviewId` int NOT NULL, `email` varchar(45) DEFAULT NULL, `description` text, `state` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_reviewId` (`reviewId`), KEY `idx_state` (`state`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_review_responses","full_table_name":"wp_jbusinessdirectory_company_review_responses","description":"Stores jbusinessdirectory company review responses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"state","type":"tinyint","nullable":false,"primary_key":false},{"name":"reviewId","type":"int","nullable":false,"primary_key":false},{"name":"firstName","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"lastName","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"response","type":"text","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_review_responses` ( `id` int NOT NULL AUTO_INCREMENT, `state` tinyint NOT NULL DEFAULT '0', `reviewId` int NOT NULL, `firstName` varchar(45) DEFAULT NULL, `lastName` varchar(45) DEFAULT NULL, `response` text, `email` varchar(45) DEFAULT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_state` (`state`), KEY `idx_review` (`reviewId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_reviews","full_table_name":"wp_jbusinessdirectory_company_reviews","description":"Stores jbusinessdirectory company reviews data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE"},{"table_name":"jbusinessdirectory_company_reviews_criteria","full_table_name":"wp_jbusinessdirectory_company_reviews_criteria","description":"Stores jbusinessdirectory company reviews criteria data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(77)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"published","type":"tinyint","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews_criteria` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(77) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `published` tinyint DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_published` (`published`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_reviews_criteria_category","full_table_name":"wp_jbusinessdirectory_company_reviews_criteria_category","description":"Stores jbusinessdirectory company reviews criteria category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"criteriaId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews_criteria_category` ( `criteriaId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`criteriaId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_reviews_question","full_table_name":"wp_jbusinessdirectory_company_reviews_question","description":"Stores jbusinessdirectory company reviews question data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"int","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"is_mandatory","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews_question` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `type` int DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `published` tinyint NOT NULL DEFAULT '1', `is_mandatory` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_published` (`published`), KEY `idx_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_reviews_question_answer","full_table_name":"wp_jbusinessdirectory_company_reviews_question_answer","description":"Stores jbusinessdirectory company reviews question answer data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews_question_answer` ( `id` int NOT NULL AUTO_INCREMENT, `review_id` int DEFAULT NULL, `question_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `answer` varchar(455) COLLATE"},{"table_name":"jbusinessdirectory_company_reviews_user_criteria","full_table_name":"wp_jbusinessdirectory_company_reviews_user_criteria","description":"Stores jbusinessdirectory company reviews user criteria data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"review_id","type":"int","nullable":true,"primary_key":false},{"name":"criteria_id","type":"int","nullable":true,"primary_key":false},{"name":"score","type":"decimal(2,1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_reviews_user_criteria` ( `id` int NOT NULL AUTO_INCREMENT, `review_id` int DEFAULT NULL, `criteria_id` int DEFAULT NULL, `score` decimal(2,1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_review_id` (`review_id`), KEY `idx_criteria_id` (`criteria_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_service_bookings","full_table_name":"wp_jbusinessdirectory_company_service_bookings","description":"Stores jbusinessdirectory company service bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"service_id","type":"int","nullable":false,"primary_key":false},{"name":"provider_id","type":"int","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"time","type":"time","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"paid_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"country_id","type":"int","nullable":true,"primary_key":false},{"name":"currency_id","type":"int","nullable":true,"primary_key":false},{"name":"initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat","type":"decimal(12,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_service_bookings` ( `id` int NOT NULL AUTO_INCREMENT, `service_id` int NOT NULL, `provider_id` int NOT NULL, `date` date DEFAULT NULL, `time` time DEFAULT NULL, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `postal_code` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `region` varchar(45) DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paid_at` datetime DEFAULT NULL, `status` tinyint DEFAULT NULL, `user_id` int DEFAULT NULL, `url` varchar(245) DEFAULT NULL, `country_id` int DEFAULT NULL, `currency_id` int DEFAULT NULL, `initial_amount` decimal(12,2) DEFAULT NULL, `vat_amount` decimal(12,2) DEFAULT NULL, `vat` decimal(12,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_service_id` (`service_id`), KEY `idx_provider_id` (`provider_id`), KEY `idx_status` (`status`), KEY `idx_user_id` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_services","full_table_name":"wp_jbusinessdirectory_company_services","description":"Stores jbusinessdirectory company services data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"duration","type":"int","nullable":true,"primary_key":false},{"name":"show_duration","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"currency_id","type":"int","nullable":false,"primary_key":false},{"name":"max_booking","type":"int","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"attendance_mode","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"istart_date","type":"date","nullable":true,"primary_key":false},{"name":"iend_date","type":"date","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_services` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` text, `duration` int DEFAULT NULL, `show_duration` tinyint(1) NOT NULL DEFAULT '0', `price` decimal(12,2) DEFAULT NULL, `currency_id` int NOT NULL, `max_booking` int DEFAULT NULL, `published` tinyint NOT NULL DEFAULT '1', `company_id` int NOT NULL, `attendance_mode` tinyint(1) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `istart_date` date DEFAULT NULL, `iend_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_published` (`published`), KEY `idx_show_duration` (`show_duration`), KEY `idx_company_id` (`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_services_list","full_table_name":"wp_jbusinessdirectory_company_services_list","description":"Stores jbusinessdirectory company services list data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"service_section","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"service_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"service_description","type":"text","nullable":true,"primary_key":false},{"name":"service_price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"service_image","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_services_list` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `service_section` varchar(100) DEFAULT NULL, `service_name` varchar(100) DEFAULT NULL, `service_description` text, `service_price` decimal(12,2) DEFAULT NULL, `service_image` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_sounds","full_table_name":"wp_jbusinessdirectory_company_sounds","description":"Stores jbusinessdirectory company sounds data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"url","type":"varchar(450)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_sounds` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `url` varchar(450) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company_id` (`company_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_testimonials","full_table_name":"wp_jbusinessdirectory_company_testimonials","description":"Stores jbusinessdirectory company testimonials data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":false,"primary_key":false},{"name":"testimonial_title","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"testimonial_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"testimonial_description","type":"varchar(450)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_testimonials` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `testimonial_title` varchar(50) DEFAULT NULL, `testimonial_name` varchar(50) DEFAULT NULL, `testimonial_description` varchar(450) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_types","full_table_name":"wp_jbusinessdirectory_company_types","description":"Stores jbusinessdirectory company types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"only_for_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"company_view","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_types` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `company_view` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_only_for_admin` (`only_for_admin`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_videos","full_table_name":"wp_jbusinessdirectory_company_videos","description":"Stores jbusinessdirectory company videos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"companyId","type":"int","nullable":true,"primary_key":false},{"name":"url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_videos` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int DEFAULT NULL, `url` varchar(245) DEFAULT NULL, `title` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_company_zipcodes","full_table_name":"wp_jbusinessdirectory_company_zipcodes","description":"Stores jbusinessdirectory company zipcodes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"zip_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_company_zipcodes` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int NOT NULL, `zip_code` varchar(10) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), KEY `company_id` (`company_id`), KEY `latitude` (`latitude`), KEY `longitude` (`longitude`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_attachments","full_table_name":"wp_jbusinessdirectory_conference_session_attachments","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"type","type":"tinyint","nullable":true,"primary_key":false},{"name":"object_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"path","type":"varchar(155)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_attachments` ( `id` int NOT NULL AUTO_INCREMENT, `type` tinyint DEFAULT NULL, `object_id` int DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `path` varchar(155) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_type` (`type`), KEY `idx_object` (`object_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_categories","full_table_name":"wp_jbusinessdirectory_conference_session_categories","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"sessionId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_categories` ( `sessionId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`sessionId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_companies","full_table_name":"wp_jbusinessdirectory_conference_session_companies","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"sessionId","type":"int","nullable":false,"primary_key":false},{"name":"companyId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_companies` ( `sessionId` int NOT NULL, `companyId` int NOT NULL, PRIMARY KEY (`sessionId`,`companyId`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_levels","full_table_name":"wp_jbusinessdirectory_conference_session_levels","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_levels` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_locations","full_table_name":"wp_jbusinessdirectory_conference_session_locations","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"position","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"capacity","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_locations` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `position` varchar(255) DEFAULT NULL, `capacity` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_registers","full_table_name":"wp_jbusinessdirectory_conference_session_registers","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"session_id","type":"int","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":true,"primary_key":false},{"name":"last_updated","type":"timestamp","nullable":false,"primary_key":false},{"name":"joined","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_registers` ( `id` int NOT NULL AUTO_INCREMENT, `session_id` int NOT NULL, `user_id` int DEFAULT NULL, `status` int DEFAULT NULL, `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `joined` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_unique` (`user_id`,`session_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_speakers","full_table_name":"wp_jbusinessdirectory_conference_session_speakers","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"sessionId","type":"int","nullable":false,"primary_key":false},{"name":"speakerId","type":"int","nullable":false,"primary_key":false},{"name":"speaker_order","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_speakers` ( `sessionId` int NOT NULL, `speakerId` int NOT NULL, `speaker_order` int NOT NULL DEFAULT '0', PRIMARY KEY (`sessionId`,`speakerId`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_session_types","full_table_name":"wp_jbusinessdirectory_conference_session_types","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"clickCount","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_session_types` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `clickCount` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_sessions","full_table_name":"wp_jbusinessdirectory_conference_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_time","type":"time","nullable":true,"primary_key":false},{"name":"locationId","type":"int","nullable":true,"primary_key":false},{"name":"sessiontypeId","type":"int","nullable":true,"primary_key":false},{"name":"sessionlevelId","type":"int","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(355)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"conferenceId","type":"int","nullable":true,"primary_key":false},{"name":"video","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"color","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"register_url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"time_zone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"session_url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"lock_content","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_sessions` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `start_time` time DEFAULT NULL, `end_time` time DEFAULT NULL, `locationId` int DEFAULT NULL, `sessiontypeId` int DEFAULT NULL, `sessionlevelId` int DEFAULT NULL, `short_description` varchar(355) DEFAULT NULL, `description` text, `viewCount` int NOT NULL DEFAULT '0', `published` tinyint(1) DEFAULT '1', `conferenceId` int DEFAULT NULL, `video` varchar(255) DEFAULT NULL, `color` varchar(10) DEFAULT NULL, `register_url` varchar(245) DEFAULT NULL, `time_zone` varchar(45) DEFAULT NULL, `session_url` varchar(245) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `lock_content` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_published` (`published`), KEY `idx_name` (`name`), KEY `idx_short_description` (`short_description`(100)), KEY `conference` (`conferenceId`), KEY `idx_sessiontypeId` (`sessiontypeId`), KEY `idx_sessionlevelId` (`sessionlevelId`), KEY `idx_alias` (`alias`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_speaker_types","full_table_name":"wp_jbusinessdirectory_conference_speaker_types","description":"Stores jbusinessdirectory conference speaker types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"color","type":"varchar(10)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_speaker_types` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `color` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_conference_speakers","full_table_name":"wp_jbusinessdirectory_conference_speakers","description":"Stores jbusinessdirectory conference speakers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(75)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(125)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"company_logo","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"countryId","type":"int","nullable":true,"primary_key":false},{"name":"speaker_language","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"biography","type":"text","nullable":true,"primary_key":false},{"name":"sessionId","type":"int","nullable":true,"primary_key":false},{"name":"photo","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"speakertypeId","type":"int","nullable":true,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"facebook","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"twitter","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"googlep","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"linkedin","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"short_biography","type":"text","nullable":true,"primary_key":false},{"name":"additional_info_link","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conference_speakers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(75) DEFAULT NULL, `alias` varchar(125) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `company_name` varchar(55) DEFAULT NULL, `company_logo` varchar(255) DEFAULT NULL, `countryId` int DEFAULT NULL, `speaker_language` varchar(100) DEFAULT NULL, `biography` text, `sessionId` int DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `speakertypeId` int DEFAULT NULL, `featured` tinyint(1) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `facebook` varchar(100) DEFAULT NULL, `twitter` varchar(100) DEFAULT NULL, `googlep` varchar(100) DEFAULT NULL, `linkedin` varchar(100) DEFAULT NULL, `short_biography` text, `additional_info_link` varchar(100) DEFAULT NULL, `viewCount` int NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_published` (`published`), KEY `idx_speakertypeId` (`speakertypeId`), KEY `idx_name` (`name`), KEY `idx_title` (`title`), KEY `idx_company_name` (`company_name`), KEY `idx_phone` (`phone`), KEY `idx_countryId` (`countryId`), KEY `idx_alias` (`alias`), KEY `idx_session` (`sessionId`), KEY `idx_featured` (`featured`) ) ENGINE"},{"table_name":"jbusinessdirectory_conferences","full_table_name":"wp_jbusinessdirectory_conferences","description":"Stores jbusinessdirectory conferences data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(125)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(125)","nullable":true,"primary_key":false},{"name":"short_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"place","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"logo","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"registration_link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"viewCount","type":"int","nullable":false,"primary_key":false},{"name":"featured","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_conferences` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(125) DEFAULT NULL, `alias` varchar(125) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `description` text, `place` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `registration_link` varchar(255) DEFAULT NULL, `viewCount` int NOT NULL DEFAULT '0', `featured` tinyint(1) DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '1', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_featured` (`featured`), KEY `idx_published` (`published`), KEY `search` (`start_date`,`end_date`,`alias`) ) ENGINE"},{"table_name":"jbusinessdirectory_countries","full_table_name":"wp_jbusinessdirectory_countries","description":"Stores jbusinessdirectory countries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"country_name","type":"char(255)","nullable":true,"primary_key":false},{"name":"country_code","type":"varchar(4)","nullable":true,"primary_key":false},{"name":"country_currency","type":"char(255)","nullable":true,"primary_key":false},{"name":"country_currency_short","type":"char(50)","nullable":true,"primary_key":false},{"name":"logo","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_countries` ( `id` int NOT NULL AUTO_INCREMENT, `country_name` char(255) DEFAULT NULL, `country_code` varchar(4) DEFAULT NULL, `country_currency` char(255) DEFAULT NULL, `country_currency_short` char(50) DEFAULT NULL, `logo` varchar(100) DEFAULT NULL, `description` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_code` (`country_code`), KEY `idx_name` (`country_name`) ) ENGINE"},{"table_name":"jbusinessdirectory_currencies","full_table_name":"wp_jbusinessdirectory_currencies","description":"Stores jbusinessdirectory currencies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"currency_id","type":"int","nullable":false,"primary_key":true},{"name":"currency_name","type":"char(10)","nullable":true,"primary_key":false},{"name":"currency_description","type":"varchar(70)","nullable":true,"primary_key":false},{"name":"currency_symbol","type":"varchar(10)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_currencies` ( `currency_id` int NOT NULL AUTO_INCREMENT, `currency_name` char(10) DEFAULT NULL, `currency_description` varchar(70) DEFAULT NULL, `currency_symbol` varchar(10) DEFAULT NULL, PRIMARY KEY (`currency_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_date_formats","full_table_name":"wp_jbusinessdirectory_date_formats","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"dateFormat","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"calendarFormat","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"defaultDateValue","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_date_formats` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(45) DEFAULT NULL, `dateFormat` varchar(45) DEFAULT NULL, `calendarFormat` varchar(45) DEFAULT NULL, `defaultDateValue` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_default_attributes","full_table_name":"wp_jbusinessdirectory_default_attributes","description":"Stores jbusinessdirectory default attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"listing_config","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"offer_config","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"event_config","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_default_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(55) DEFAULT NULL, `listing_config` tinyint(1) DEFAULT NULL, `offer_config` tinyint(1) DEFAULT NULL, `event_config` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_directory_apps","full_table_name":"wp_jbusinessdirectory_directory_apps","description":"Stores jbusinessdirectory directory apps data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"app_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"store_link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"doc_link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"version","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"required_version","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_directory_apps` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `app_name` varchar(255) DEFAULT NULL, `description` text, `icon` varchar(50) DEFAULT '', `store_link` varchar(255) DEFAULT '', `doc_link` varchar(255) DEFAULT '', `version` varchar(50) DEFAULT NULL, `required_version` varchar(50) DEFAULT NULL, `type` tinyint NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_discounts","full_table_name":"wp_jbusinessdirectory_discounts","description":"Stores jbusinessdirectory discounts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"char(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":false,"primary_key":false},{"name":"end_date","type":"date","nullable":false,"primary_key":false},{"name":"value","type":"decimal(6,2)","nullable":false,"primary_key":false},{"name":"percent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"price_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"package_ids","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"state","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"uses_per_coupon","type":"int","nullable":true,"primary_key":false},{"name":"coupon_used","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_discounts` ( `id` int NOT NULL AUTO_INCREMENT, `name` char(255) DEFAULT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `value` decimal(6,2) NOT NULL DEFAULT '0.00', `percent` tinyint(1) NOT NULL DEFAULT '0', `price_type` tinyint(1) NOT NULL DEFAULT '1', `package_ids` varchar(255) DEFAULT NULL, `code` varchar(50) NOT NULL DEFAULT '0', `state` tinyint(1) NOT NULL DEFAULT '1', `uses_per_coupon` int DEFAULT NULL, `coupon_used` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_code` (`code`), KEY `idx_state` (`state`), KEY `idx_date` (`end_date`,`start_date`) ) ENGINE"},{"table_name":"jbusinessdirectory_emails","full_table_name":"wp_jbusinessdirectory_emails","description":"Stores jbusinessdirectory emails data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"email_id","type":"int","nullable":false,"primary_key":true},{"name":"email_subject","type":"char(255)","nullable":true,"primary_key":false},{"name":"email_name","type":"char(255)","nullable":true,"primary_key":false},{"name":"email_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"email_content","type":"blob","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"send_to_admin","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_emails` ( `email_id` int NOT NULL AUTO_INCREMENT, `email_subject` char(255) DEFAULT NULL, `email_name` char(255) DEFAULT NULL, `email_type` varchar(255) DEFAULT NULL, `email_content` blob NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `send_to_admin` tinyint(1) DEFAULT '1', PRIMARY KEY (`email_id`), KEY `idx_type` (`email_type`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_event_attributes","full_table_name":"wp_jbusinessdirectory_event_attributes","description":"Stores jbusinessdirectory event attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"event_id","type":"int","nullable":false,"primary_key":false},{"name":"attribute_id","type":"int","nullable":false,"primary_key":false},{"name":"value","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"option_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_event_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `event_id` int NOT NULL, `attribute_id` int NOT NULL, `value` varchar(250) DEFAULT NULL, `option_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `event_UNIQUE` (`event_id`,`attribute_id`,`value`), KEY `idx_option_id` (`option_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_event_videos","full_table_name":"wp_jbusinessdirectory_event_videos","description":"Stores jbusinessdirectory event videos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"eventId","type":"int","nullable":true,"primary_key":false},{"name":"url","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_event_videos` ( `id` int NOT NULL AUTO_INCREMENT, `eventId` int DEFAULT NULL, `url` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `ids_eventId` (`eventId`) ) ENGINE"},{"table_name":"jbusinessdirectory_language_translations","full_table_name":"wp_jbusinessdirectory_language_translations","description":"Stores jbusinessdirectory language translations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"type","type":"int","nullable":false,"primary_key":false},{"name":"object_id","type":"int","nullable":false,"primary_key":false},{"name":"language_tag","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"content_short","type":"varchar(355)","nullable":true,"primary_key":false},{"name":"content","type":"text","nullable":true,"primary_key":false},{"name":"additional_content","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_language_translations` ( `id` int NOT NULL AUTO_INCREMENT, `type` int NOT NULL DEFAULT '0', `object_id` int NOT NULL, `language_tag` varchar(10) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `content_short` varchar(355) DEFAULT NULL, `content` text, `additional_content` text, PRIMARY KEY (`id`), KEY `idx_object` (`object_id`), KEY `ids_langauge` (`language_tag`), KEY `ids_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_logs","full_table_name":"wp_jbusinessdirectory_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_id","type":"int","nullable":true,"primary_key":false},{"name":"item_type","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"action","type":"tinyint","nullable":true,"primary_key":false},{"name":"date","type":"timestamp","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_logs` ( `id` int NOT NULL AUTO_INCREMENT, `item_id` int DEFAULT NULL, `item_type` int DEFAULT NULL, `user_id` int DEFAULT NULL, `action` tinyint DEFAULT NULL, `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_memberships","full_table_name":"wp_jbusinessdirectory_memberships","description":"Stores jbusinessdirectory memberships data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"logo_location","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"show_in_front","type":"tinyint","nullable":true,"primary_key":false},{"name":"url","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"image_title","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_memberships` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `description` varchar(250) DEFAULT NULL, `logo_location` varchar(250) DEFAULT NULL, `status` tinyint DEFAULT '1', `show_in_front` tinyint DEFAULT '1', `url` varchar(245) DEFAULT NULL, `image_title` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_message_replies","full_table_name":"wp_jbusinessdirectory_message_replies","description":"Stores jbusinessdirectory message replies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"message_id","type":"int","nullable":true,"primary_key":false},{"name":"content","type":"varchar(455)","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_message_replies` ( `id` int NOT NULL AUTO_INCREMENT, `message_id` int DEFAULT NULL, `content` varchar(455) DEFAULT NULL, `user_id` int DEFAULT NULL, `created` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_messages","full_table_name":"wp_jbusinessdirectory_messages","description":"Stores jbusinessdirectory messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"surname","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"email","type":"char(255)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"item_id","type":"int","nullable":false,"primary_key":false},{"name":"contact_id","type":"int","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":true,"primary_key":false},{"name":"read","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"date","type":"timestamp","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_messages` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) DEFAULT NULL, `surname` varchar(145) DEFAULT NULL, `email` char(255) DEFAULT NULL, `message` text, `item_id` int NOT NULL, `contact_id` int DEFAULT NULL, `type` tinyint DEFAULT NULL, `read` tinyint(1) DEFAULT NULL, `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_item_id` (`item_id`), KEY `idx_contact_id` (`contact_id`), KEY `idx_type` (`type`), KEY `idx_user_id` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_mobile_app_config","full_table_name":"wp_jbusinessdirectory_mobile_app_config","description":"Stores jbusinessdirectory mobile app config data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_mobile_app_config` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `value` text, PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE"},{"table_name":"jbusinessdirectory_mobile_app_menus","full_table_name":"wp_jbusinessdirectory_mobile_app_menus","description":"Stores jbusinessdirectory mobile app menus data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"title","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"group","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"position","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"lang","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"icon","type":"varchar(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_mobile_app_menus` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(45) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `group` varchar(45) DEFAULT NULL, `position` varchar(45) DEFAULT NULL, `type` varchar(45) DEFAULT NULL, `lang` varchar(45) DEFAULT NULL, `icon` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_mobile_app_notifications","full_table_name":"wp_jbusinessdirectory_mobile_app_notifications","description":"Stores jbusinessdirectory mobile app notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"body","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"nr_contacts","type":"int","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"itemType","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"itemId","type":"int","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_mobile_app_notifications` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `body` varchar(255) DEFAULT NULL, `nr_contacts` int DEFAULT '0', `type` varchar(255) DEFAULT NULL, `itemType` tinyint(1) DEFAULT NULL, `itemId` int DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_title` (`title`) ) ENGINE"},{"table_name":"jbusinessdirectory_mobile_devices","full_table_name":"wp_jbusinessdirectory_mobile_devices","description":"Stores jbusinessdirectory mobile devices data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"device_id","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"token","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"firebase_token","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":true,"primary_key":false},{"name":"enable_push_notifications","type":"tinyint","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_mobile_devices` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `device_id` varchar(30) NOT NULL, `token` varchar(255) DEFAULT NULL, `firebase_token` varchar(255) DEFAULT NULL, `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `enable_push_notifications` tinyint DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_token` (`token`), KEY `idx_firebase` (`firebase_token`), KEY `idx_user` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_news","full_table_name":"wp_jbusinessdirectory_news","description":"Stores jbusinessdirectory news data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"link","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"publish_date","type":"datetime","nullable":true,"primary_key":false},{"name":"retrieve_date","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_news` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `description` text, `publish_date` datetime DEFAULT NULL, `retrieve_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"jbusinessdirectory_offer_attributes","full_table_name":"wp_jbusinessdirectory_offer_attributes","description":"Stores jbusinessdirectory offer attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"offer_id","type":"int","nullable":false,"primary_key":false},{"name":"attribute_id","type":"int","nullable":false,"primary_key":false},{"name":"value","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"option_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_offer_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `offer_id` int NOT NULL, `attribute_id` int NOT NULL, `value` varchar(250) DEFAULT NULL, `option_id` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `event_UNIQUE` (`offer_id`,`attribute_id`,`value`), KEY `idx_option` (`option_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_offer_shipping_methods","full_table_name":"wp_jbusinessdirectory_offer_shipping_methods","description":"Stores jbusinessdirectory offer shipping methods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"offer_id","type":"int","nullable":true,"primary_key":false},{"name":"shipping_method_id","type":"int","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_offer_shipping_methods` ( `id` int NOT NULL AUTO_INCREMENT, `offer_id` int DEFAULT NULL, `shipping_method_id` int DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `IND_UNQ` (`offer_id`,`shipping_method_id`), KEY `idx_offer` (`offer_id`), KEY `idx_shipping_method` (`shipping_method_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_offer_stock","full_table_name":"wp_jbusinessdirectory_offer_stock","description":"Stores jbusinessdirectory offer stock data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"offer_id","type":"int","nullable":false,"primary_key":false},{"name":"qty","type":"int","nullable":true,"primary_key":false},{"name":"notify_stock_qty","type":"int","nullable":false,"primary_key":false},{"name":"stock_main_category","type":"int","nullable":false,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_offer_stock` ( `id` int NOT NULL AUTO_INCREMENT, `offer_id` int NOT NULL, `qty` int DEFAULT NULL, `notify_stock_qty` int NOT NULL DEFAULT '0', `stock_main_category` int NOT NULL DEFAULT '0', `price` decimal(12,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_offer` (`offer_id`), KEY `ixd_category` (`stock_main_category`) ) ENGINE"},{"table_name":"jbusinessdirectory_offer_stock_config","full_table_name":"wp_jbusinessdirectory_offer_stock_config","description":"Stores jbusinessdirectory offer stock config data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"stock_id","type":"int","nullable":false,"primary_key":false},{"name":"attribute_id","type":"int","nullable":true,"primary_key":false},{"name":"attribute_value","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_offer_stock_config` ( `id` int NOT NULL AUTO_INCREMENT, `stock_id` int NOT NULL, `attribute_id` int DEFAULT NULL, `attribute_value` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_stock` (`stock_id`), KEY `idx_attribute` (`attribute_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_offer_videos","full_table_name":"wp_jbusinessdirectory_offer_videos","description":"Stores jbusinessdirectory offer videos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"offerId","type":"int","nullable":true,"primary_key":false},{"name":"url","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_offer_videos` ( `id` int NOT NULL AUTO_INCREMENT, `offerId` int DEFAULT NULL, `url` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_offerId` (`offerId`) ) ENGINE"},{"table_name":"jbusinessdirectory_order_packages","full_table_name":"wp_jbusinessdirectory_order_packages","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(200)","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":"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}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_order_packages` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `name` varchar(145) DEFAULT NULL, `description` varchar(200) DEFAULT NULL, `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', `ordering` tinyint NOT NULL DEFAULT '0', `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_price` (`price`), KEY `idx_order` (`order_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_order_taxes","full_table_name":"wp_jbusinessdirectory_order_taxes","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"int","nullable":false,"primary_key":false},{"name":"tax_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"tax_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"order_type","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_order_taxes` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `tax_name` varchar(50) DEFAULT NULL, `tax_type` tinyint(1) NOT NULL DEFAULT '1', `tax_amount` decimal(12,2) DEFAULT NULL, `tax_description` varchar(255) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `order_type` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_tax_type` (`tax_type`), KEY `idx_order` (`order_id`), KEY `idx_order_type` (`order_type`) ) ENGINE"},{"table_name":"jbusinessdirectory_orders","full_table_name":"wp_jbusinessdirectory_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"invoice_number","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"package_id","type":"int","nullable":false,"primary_key":false},{"name":"initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"amount_paid","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"paid_at","type":"datetime","nullable":true,"primary_key":false},{"name":"state","type":"tinyint","nullable":true,"primary_key":false},{"name":"transaction_id","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"service","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(145)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"start_trial_date","type":"date","nullable":true,"primary_key":false},{"name":"end_trial_date","type":"date","nullable":true,"primary_key":false},{"name":"trial_initial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"only_trial","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"expiration_email_date","type":"datetime","nullable":true,"primary_key":false},{"name":"discount_code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"vat_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"observation","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"trial_amount","type":"decimal(6,2)","nullable":true,"primary_key":false},{"name":"trial_days","type":"tinyint","nullable":true,"primary_key":false},{"name":"subscription_id","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"notify_payment","type":"tinyint","nullable":false,"primary_key":false},{"name":"expiration_processed","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_orders` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` varchar(145) DEFAULT NULL, `invoice_number` varchar(145) DEFAULT NULL, `company_id` int NOT NULL, `package_id` int NOT NULL, `initial_amount` decimal(12,2) DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, `amount_paid` decimal(12,2) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `paid_at` datetime DEFAULT NULL, `state` tinyint DEFAULT NULL, `transaction_id` varchar(145) DEFAULT NULL, `user_name` varchar(145) DEFAULT NULL, `service` varchar(145) DEFAULT NULL, `description` varchar(145) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `start_trial_date` date DEFAULT NULL, `end_trial_date` date DEFAULT NULL, `trial_initial_amount` decimal(12,2) DEFAULT NULL, `only_trial` tinyint(1) DEFAULT '0', `type` tinyint NOT NULL DEFAULT '0', `currency` varchar(10) DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `discount_code` varchar(50) DEFAULT NULL, `discount_amount` decimal(12,2) DEFAULT '0.00', `vat` decimal(12,2) DEFAULT NULL, `vat_amount` decimal(12,2) DEFAULT NULL, `observation` varchar(250) DEFAULT NULL, `trial_amount` decimal(6,2) DEFAULT NULL, `trial_days` tinyint DEFAULT NULL, `subscription_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `notify_payment` tinyint NOT NULL DEFAULT '0', `expiration_processed` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `unq_invoice_numner` (`invoice_number`), KEY `idx_company` (`company_id`), KEY `idx_package` (`package_id`), KEY `idx_order` (`order_id`), KEY `idx_state` (`state`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_start_date` (`start_date`), KEY `idx_start_trial_date` (`start_trial_date`), KEY `idx_type` (`type`), KEY `idx_subscription` (`subscription_id`), KEY `idx_end_date` (`end_date`), KEY `idx_end_trial_date` (`end_trial_date`), KEY `idx_date` (`start_date`), KEY `idx_user_id` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_package_businesstypes","full_table_name":"wp_jbusinessdirectory_package_businesstypes","description":"Stores jbusinessdirectory package businesstypes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"package_id","type":"int","nullable":false,"primary_key":false},{"name":"businesstype_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_package_businesstypes` ( `id` int NOT NULL AUTO_INCREMENT, `package_id` int NOT NULL, `businesstype_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_package_businesstype` (`package_id`,`businesstype_id`), KEY `idx_package_id` (`package_id`), KEY `idx_businesstype_id` (`businesstype_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_package_fields","full_table_name":"wp_jbusinessdirectory_package_fields","description":"Stores jbusinessdirectory package fields data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"package_id","type":"int","nullable":true,"primary_key":false},{"name":"feature","type":"varchar(145)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_package_fields` ( `id` int NOT NULL AUTO_INCREMENT, `package_id` int DEFAULT NULL, `feature` varchar(145) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_package_id` (`package_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_packages","full_table_name":"wp_jbusinessdirectory_packages","description":"Stores jbusinessdirectory packages data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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"},{"table_name":"jbusinessdirectory_payment_processor_fields","full_table_name":"wp_jbusinessdirectory_payment_processor_fields","description":"Stores jbusinessdirectory payment processor fields data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"column_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"column_value","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"processor_id","type":"int","nullable":false,"primary_key":false},{"name":"column_mode","type":"tinyint(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_payment_processor_fields` ( `id` int NOT NULL AUTO_INCREMENT, `column_name` varchar(100) DEFAULT NULL, `column_value` varchar(255) DEFAULT NULL, `processor_id` int NOT NULL, `column_mode` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_processor_id` (`processor_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_payment_processor_services","full_table_name":"wp_jbusinessdirectory_payment_processor_services","description":"Stores jbusinessdirectory payment processor services data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"processor_id","type":"int","nullable":true,"primary_key":false},{"name":"app_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_payment_processor_services` ( `id` int NOT NULL AUTO_INCREMENT, `processor_id` int DEFAULT NULL, `app_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_processor_id` (`processor_id`), KEY `idx_app` (`app_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_payment_processors","full_table_name":"wp_jbusinessdirectory_payment_processors","description":"Stores jbusinessdirectory payment processors data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mode","type":"enum('live','test')","nullable":false,"primary_key":false},{"name":"timeout","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"displayfront","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_payment_processors` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `mode` enum('live','test') NOT NULL DEFAULT 'live', `timeout` int DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `ordering` tinyint NOT NULL DEFAULT '0', `displayfront` tinyint(1) NOT NULL DEFAULT '1', `company_id` int NOT NULL DEFAULT '-1', PRIMARY KEY (`id`), KEY `idx_displayfront` (`displayfront`), KEY `idx_status` (`status`), KEY `idx_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_payments","full_table_name":"wp_jbusinessdirectory_payments","description":"Stores jbusinessdirectory payments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"payment_id","type":"int","nullable":false,"primary_key":true},{"name":"order_id","type":"int","nullable":false,"primary_key":false},{"name":"booking_id","type":"int","nullable":true,"primary_key":false},{"name":"processor_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"payment_date","type":"date","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(80)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"char(5)","nullable":false,"primary_key":false},{"name":"payment_method","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"response_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"message","type":"blob","nullable":true,"primary_key":false},{"name":"payment_status","type":"tinyint","nullable":false,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_payments` ( `payment_id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `booking_id` int DEFAULT NULL, `processor_type` varchar(100) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `payment_date` date NOT NULL, `transaction_id` varchar(80) NOT NULL, `amount` decimal(12,2) NOT NULL DEFAULT '0.00', `currency` char(5) NOT NULL, `payment_method` varchar(100) DEFAULT NULL, `response_code` varchar(45) DEFAULT NULL, `message` blob, `payment_status` tinyint NOT NULL DEFAULT '0', `type` tinyint NOT NULL DEFAULT '1', PRIMARY KEY (`payment_id`), KEY `NewIndex` (`order_id`), KEY `idx_booking_id` (`booking_id`), KEY `idx_processor_type` (`processor_type`), KEY `idx_transaction_id` (`transaction_id`), KEY `idx_payment_status` (`payment_status`) ) ENGINE"},{"table_name":"jbusinessdirectory_regions","full_table_name":"wp_jbusinessdirectory_regions","description":"Stores jbusinessdirectory regions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"country_id","type":"int","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_regions` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(65) DEFAULT NULL, `country_id` int DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_country` (`country_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_reports","full_table_name":"wp_jbusinessdirectory_reports","description":"Stores jbusinessdirectory reports data created by this plugin.","detection_method":"static","confidence":"medium","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":"selected_params","type":"text","nullable":true,"primary_key":false},{"name":"custom_params","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"listing_status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_reports` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) DEFAULT NULL, `description` text, `selected_params` text, `custom_params` text, `type` tinyint(1) DEFAULT NULL, `listing_status` tinyint(1) NOT NULL DEFAULT '1', `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_type` (`type`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote","full_table_name":"wp_jbusinessdirectory_request_quote","description":"Stores jbusinessdirectory request quote data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"additional_information","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"summary","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":true,"primary_key":false},{"name":"creationDate","type":"timestamp","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"category_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"latitude","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"longitude","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"quote_date_time","type":"datetime","nullable":true,"primary_key":false},{"name":"province","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"district","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"neighborhood","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"timeframe","type":"varchar(65)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote` ( `id` int NOT NULL AUTO_INCREMENT, `additional_information` varchar(255) DEFAULT NULL, `summary` text, `status` int DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `category_id` int NOT NULL, `company_id` int NOT NULL DEFAULT '0', `title` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `latitude` varchar(50) DEFAULT NULL, `longitude` varchar(50) DEFAULT NULL, `quote_date_time` datetime DEFAULT NULL, `province` varchar(65) DEFAULT NULL, `district` varchar(65) DEFAULT NULL, `neighborhood` varchar(65) DEFAULT NULL, `timeframe` varchar(65) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_category` (`category_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote_messages","full_table_name":"wp_jbusinessdirectory_request_quote_messages","description":"Stores jbusinessdirectory request quote messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"quote_reply_id","type":"int","nullable":false,"primary_key":false},{"name":"sender_id","type":"int","nullable":false,"primary_key":false},{"name":"text","type":"text","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote_messages` ( `id` int NOT NULL AUTO_INCREMENT, `quote_reply_id` int NOT NULL, `sender_id` int NOT NULL, `text` text, `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_quote_reply` (`quote_reply_id`), KEY `idx_created` (`created`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote_question_category","full_table_name":"wp_jbusinessdirectory_request_quote_question_category","description":"Stores jbusinessdirectory request quote question category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"questionId","type":"int","nullable":false,"primary_key":false},{"name":"categoryId","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote_question_category` ( `questionId` int NOT NULL, `categoryId` int NOT NULL, PRIMARY KEY (`questionId`,`categoryId`), KEY `idx_category` (`questionId`,`categoryId`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote_question_options","full_table_name":"wp_jbusinessdirectory_request_quote_question_options","description":"Stores jbusinessdirectory request quote question options data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"question_id","type":"int","nullable":false,"primary_key":false},{"name":"answer","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote_question_options` ( `id` int NOT NULL AUTO_INCREMENT, `question_id` int NOT NULL, `answer` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_question` (`question_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote_questions","full_table_name":"wp_jbusinessdirectory_request_quote_questions","description":"Stores jbusinessdirectory request quote questions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"category_id","type":"int","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","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":"image","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote_questions` ( `id` int NOT NULL AUTO_INCREMENT, `category_id` int NOT NULL, `name` varchar(255) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '1', `ordering` tinyint NOT NULL DEFAULT '0', `image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_category` (`category_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_request_quote_replies","full_table_name":"wp_jbusinessdirectory_request_quote_replies","description":"Stores jbusinessdirectory request quote replies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"company_id","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"int","nullable":true,"primary_key":false},{"name":"quote_id","type":"int","nullable":true,"primary_key":false},{"name":"date","type":"timestamp","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_request_quote_replies` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `status` int DEFAULT NULL, `quote_id` int DEFAULT NULL, `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `price` decimal(12,2) DEFAULT NULL, `message` text, PRIMARY KEY (`id`), KEY `idx_quote` (`quote_id`), KEY `idx_company` (`company_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_review_pictures","full_table_name":"wp_jbusinessdirectory_review_pictures","description":"Stores jbusinessdirectory review pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"reviewId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_review_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `reviewId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_reviewId` (`reviewId`), KEY `idx_status` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_scheduled_notifications","full_table_name":"wp_jbusinessdirectory_scheduled_notifications","description":"Stores jbusinessdirectory scheduled notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"body","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"frequency","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_scheduled_notifications` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `body` varchar(255) DEFAULT NULL, `type` tinyint(1) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `frequency` varchar(255) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_name` (`name`) ) ENGINE"},{"table_name":"jbusinessdirectory_search_logs","full_table_name":"wp_jbusinessdirectory_search_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"object_type","type":"tinyint","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"value","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"has_text","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_search_logs` ( `id` int NOT NULL AUTO_INCREMENT, `item_type` tinyint NOT NULL DEFAULT '1', `object_type` tinyint DEFAULT NULL, `date` date DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `has_text` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_item_value` (`value`), KEY `idx_item_type` (`item_type`), KEY `idx_object_type` (`object_type`), KEY `idx_date` (`date`) ) ENGINE"},{"table_name":"jbusinessdirectory_search_logs_archive","full_table_name":"wp_jbusinessdirectory_search_logs_archive","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"object_type","type":"tinyint","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"value","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"has_text","type":"tinyint","nullable":false,"primary_key":false},{"name":"item_count","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_search_logs_archive` ( `id` int NOT NULL AUTO_INCREMENT, `item_type` tinyint NOT NULL DEFAULT '1', `object_type` tinyint DEFAULT NULL, `date` date DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `has_text` tinyint NOT NULL DEFAULT '0', `item_count` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_unq` (`item_type`,`date`,`object_type`,`value`) ) ENGINE"},{"table_name":"jbusinessdirectory_shipping_methods","full_table_name":"wp_jbusinessdirectory_shipping_methods","description":"Stores jbusinessdirectory shipping methods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"duration","type":"int","nullable":true,"primary_key":false},{"name":"traceable","type":"tinyint","nullable":true,"primary_key":false},{"name":"published","type":"tinyint","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"default","type":"tinyint","nullable":true,"primary_key":false},{"name":"threshold","type":"decimal(12,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_shipping_methods` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` text, `price` decimal(12,2) DEFAULT NULL, `duration` int DEFAULT NULL, `traceable` tinyint DEFAULT '0', `published` tinyint NOT NULL DEFAULT '1', `user_id` int DEFAULT NULL, `default` tinyint DEFAULT '0', `threshold` decimal(12,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_status` (`published`) ) ENGINE"},{"table_name":"jbusinessdirectory_statistics","full_table_name":"wp_jbusinessdirectory_statistics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_id","type":"int","nullable":false,"primary_key":false},{"name":"item_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false},{"name":"article_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_statistics` ( `id` int NOT NULL AUTO_INCREMENT, `item_id` int NOT NULL, `item_type` tinyint NOT NULL DEFAULT '1', `date` date DEFAULT NULL, `type` tinyint NOT NULL DEFAULT '0', `article_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_item_id` (`item_id`), KEY `idx_item_type` (`item_type`) ) ENGINE"},{"table_name":"jbusinessdirectory_statistics_archive","full_table_name":"wp_jbusinessdirectory_statistics_archive","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"item_id","type":"int","nullable":false,"primary_key":false},{"name":"item_type","type":"tinyint","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"type","type":"tinyint","nullable":false,"primary_key":false},{"name":"article_id","type":"int","nullable":true,"primary_key":false},{"name":"item_count","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_statistics_archive` ( `id` int NOT NULL AUTO_INCREMENT, `item_id` int NOT NULL, `item_type` tinyint NOT NULL DEFAULT '1', `date` date DEFAULT NULL, `type` tinyint NOT NULL DEFAULT '0', `article_id` int DEFAULT NULL, `item_count` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_unq` (`item_id`,`item_type`,`date`,`type`), KEY `idx_article` (`article_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_subscriptions","full_table_name":"wp_jbusinessdirectory_subscriptions","description":"Stores jbusinessdirectory subscriptions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"trial_start_date","type":"date","nullable":true,"primary_key":false},{"name":"trial_end_date","type":"date","nullable":true,"primary_key":false},{"name":"trial_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"subscription_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"processor_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"payment_id","type":"int","nullable":false,"primary_key":false},{"name":"company_id","type":"int","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":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_subscriptions` ( `id` int NOT NULL AUTO_INCREMENT, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `trial_start_date` date DEFAULT NULL, `trial_end_date` date DEFAULT NULL, `trial_amount` decimal(12,2) DEFAULT NULL, `subscription_id` varchar(255) DEFAULT NULL, `processor_type` varchar(100) NOT NULL, `amount` decimal(12,2) DEFAULT NULL, `payment_id` int NOT NULL, `company_id` int NOT NULL, `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', `status` tinyint DEFAULT '0', `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_subscription` (`subscription_id`), KEY `idx_payment` (`payment_id`), KEY `idx_status` (`status`) ) ENGINE"},{"table_name":"jbusinessdirectory_tax_countries","full_table_name":"wp_jbusinessdirectory_tax_countries","description":"Stores jbusinessdirectory tax countries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"country_id","type":"int","nullable":true,"primary_key":false},{"name":"tax_id","type":"int","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(12,2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_tax_countries` ( `id` int NOT NULL AUTO_INCREMENT, `country_id` int DEFAULT NULL, `tax_id` int DEFAULT NULL, `amount` decimal(12,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_tax_id` (`tax_id`), KEY `idx_country` (`country_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_tax_services","full_table_name":"wp_jbusinessdirectory_tax_services","description":"Stores jbusinessdirectory tax services data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"tax_id","type":"int","nullable":true,"primary_key":false},{"name":"app_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_tax_services` ( `id` int NOT NULL AUTO_INCREMENT, `tax_id` int DEFAULT NULL, `app_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_tax_id` (`tax_id`), KEY `idx_app` (`app_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_taxes","full_table_name":"wp_jbusinessdirectory_taxes","description":"Stores jbusinessdirectory taxes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"tax_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"tax_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_amount","type":"decimal(12,2)","nullable":true,"primary_key":false},{"name":"tax_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_taxes` ( `id` int NOT NULL AUTO_INCREMENT, `tax_name` varchar(200) DEFAULT NULL, `tax_type` tinyint(1) NOT NULL DEFAULT '1', `tax_amount` decimal(12,2) DEFAULT NULL, `tax_description` varchar(255) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_tax_type` (`tax_type`) ) ENGINE"},{"table_name":"jbusinessdirectory_trip_bookings","full_table_name":"wp_jbusinessdirectory_trip_bookings","description":"Stores jbusinessdirectory trip bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"trip_id","type":"int","nullable":false,"primary_key":false},{"name":"trip_date","type":"date","nullable":false,"primary_key":false},{"name":"trip_time","type":"time","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false},{"name":"confirmed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"tinyint","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_trip_bookings` ( `id` int NOT NULL AUTO_INCREMENT, `trip_id` int NOT NULL, `trip_date` date NOT NULL, `trip_time` time DEFAULT NULL, `first_name` varchar(45) DEFAULT NULL, `last_name` varchar(45) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `postal_code` varchar(45) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `confirmed_at` datetime DEFAULT NULL, `status` tinyint DEFAULT NULL, `user_id` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_trip` (`trip_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_trip_capacity_overrides","full_table_name":"wp_jbusinessdirectory_trip_capacity_overrides","description":"Stores jbusinessdirectory trip capacity overrides data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"tripId","type":"int","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"capacity","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_trip_capacity_overrides` ( `id` int NOT NULL AUTO_INCREMENT, `tripId` int NOT NULL, `start_date` date DEFAULT NULL, `capacity` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_tripId` (`tripId`) ) ENGINE"},{"table_name":"jbusinessdirectory_trip_dates","full_table_name":"wp_jbusinessdirectory_trip_dates","description":"Stores jbusinessdirectory trip dates data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"tripId","type":"int","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":false,"primary_key":false},{"name":"end_date","type":"date","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_trip_dates` ( `id` int NOT NULL AUTO_INCREMENT, `tripId` int NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, PRIMARY KEY (`id`), KEY `idx_tripId` (`tripId`) ) ENGINE"},{"table_name":"jbusinessdirectory_trip_pictures","full_table_name":"wp_jbusinessdirectory_trip_pictures","description":"Stores jbusinessdirectory trip pictures data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"tripId","type":"int","nullable":false,"primary_key":false},{"name":"picture_info","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"picture_path","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"picture_enable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"picture_title","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_trip_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `tripId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) NOT NULL, `picture_path` varchar(255) NOT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', `picture_title` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `idx_tripId` (`tripId`), KEY `idx_picture_enable` (`picture_enable`) ) ENGINE"},{"table_name":"jbusinessdirectory_trips","full_table_name":"wp_jbusinessdirectory_trips","description":"Stores jbusinessdirectory trips data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"alias","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_time","type":"time","nullable":true,"primary_key":false},{"name":"frequency","type":"int","nullable":false,"primary_key":false},{"name":"recurring_info","type":"longtext","nullable":true,"primary_key":false},{"name":"capacity","type":"int","nullable":true,"primary_key":false},{"name":"organizer","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"companyId","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_trips` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `alias` varchar(100) NOT NULL DEFAULT '', `description` text, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `start_time` time DEFAULT NULL, `end_time` time DEFAULT NULL, `frequency` int NOT NULL DEFAULT '0', `recurring_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `capacity` int DEFAULT NULL, `organizer` varchar(100) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `approved` tinyint(1) NOT NULL DEFAULT '1', `companyId` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_name` (`name`), KEY `idx_alias` (`alias`), KEY `idx_frequency` (`frequency`) ) ENGINE"},{"table_name":"jbusinessdirectory_user_notifications","full_table_name":"wp_jbusinessdirectory_user_notifications","description":"Stores jbusinessdirectory user notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"user_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"notification_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"read","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_user_notifications` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` varchar(255) DEFAULT NULL, `notification_id` varchar(255) DEFAULT NULL, `read` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_notification` (`notification_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_user_profiles","full_table_name":"wp_jbusinessdirectory_user_profiles","description":"Stores jbusinessdirectory user profiles data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"token","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"provider_type","type":"tinyint","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"verified","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"activation_code","type":"varchar(245)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_user_profiles` ( `id` int NOT NULL AUTO_INCREMENT, `token` varchar(255) DEFAULT NULL, `provider_type` tinyint DEFAULT NULL, `user_id` int DEFAULT NULL, `verified` tinyint(1) DEFAULT NULL, `activation_code` varchar(245) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_video_attributes","full_table_name":"wp_jbusinessdirectory_video_attributes","description":"Stores jbusinessdirectory video attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"video_id","type":"int","nullable":false,"primary_key":false},{"name":"attribute_id","type":"int","nullable":false,"primary_key":false},{"name":"value","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"option_id","type":"int","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_video_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `video_id` int NOT NULL, `attribute_id` int NOT NULL, `value` varchar(250) DEFAULT NULL, `option_id` int DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `video_UNIQUE` (`video_id`,`attribute_id`,`value`), KEY `idx_option_id` (`option_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_video_category","full_table_name":"wp_jbusinessdirectory_video_category","description":"Stores jbusinessdirectory video category data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"video_id","type":"int","nullable":false,"primary_key":false},{"name":"category_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_video_category` ( `video_id` int NOT NULL, `category_id` int NOT NULL, PRIMARY KEY (`video_id`,`category_id`) ) ENGINE"},{"table_name":"jbusinessdirectory_videos","full_table_name":"wp_jbusinessdirectory_videos","description":"Stores jbusinessdirectory videos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"alias","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"main_subcategory","type":"int","nullable":true,"primary_key":false},{"name":"duration","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"thumbnail","type":"varchar(245)","nullable":true,"primary_key":false},{"name":"transcript","type":"text","nullable":true,"primary_key":false},{"name":"ordering","type":"tinyint","nullable":false,"primary_key":false},{"name":"meta_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_keywords","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_jbusinessdirectory_videos` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `description` text, `main_subcategory` int DEFAULT NULL, `duration` varchar(10) DEFAULT NULL, `thumbnail` varchar(245) DEFAULT NULL, `transcript` text, `ordering` tinyint NOT NULL DEFAULT '0', `meta_title` varchar(255) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_description` varchar(255) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_name` (`name`) ) ENGINE"}],"table_count":150}