-- Table structure for table `joseb_jbusinessdirectory_cities`
--

CREATE TABLE `joseb_jbusinessdirectory_cities` (
  `id` int(11) NOT NULL,
  `name` varchar(65) DEFAULT NULL,
  `region_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_cities`
--

INSERT INTO `joseb_jbusinessdirectory_cities` (`id`, `name`, `region_id`) VALUES
(1, 'Toronto', NULL),
(2, 'Montreal', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_companies`
--

CREATE TABLE `joseb_jbusinessdirectory_companies` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `alias` varchar(100) NOT NULL DEFAULT '',
  `comercialName` varchar(120) DEFAULT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `meta_title` varchar(100) NOT NULL,
  `meta_description` text DEFAULT NULL,
  `street_number` varchar(20) DEFAULT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(60) DEFAULT NULL,
  `county` varchar(60) DEFAULT NULL,
  `province` varchar(60) DEFAULT NULL,
  `area` varchar(60) DEFAULT NULL,
  `countryId` int(11) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `keywords` varchar(150) DEFAULT NULL,
  `registrationCode` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `state` tinyint(4) DEFAULT 1,
  `typeId` varchar(255) DEFAULT NULL,
  `logoLocation` varchar(245) DEFAULT NULL,
  `creationDate` timestamp NULL DEFAULT current_timestamp(),
  `modified` datetime DEFAULT NULL,
  `mainSubcategory` int(11) DEFAULT NULL,
  `latitude` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `activity_radius` float DEFAULT NULL,
  `userId` int(11) NOT NULL DEFAULT 0,
  `averageRating` float NOT NULL DEFAULT 0,
  `review_score` float NOT NULL DEFAULT 0,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `viewCount` int(11) NOT NULL DEFAULT 0,
  `websiteCount` int(11) NOT NULL DEFAULT 0,
  `contactCount` int(11) NOT NULL DEFAULT 0,
  `taxCode` varchar(45) DEFAULT NULL,
  `package_id` int(11) 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(255) 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 DEFAULT NULL,
  `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` int(11) DEFAULT NULL,
  `ad_image` varchar(250) DEFAULT NULL,
  `disapproval_text` text DEFAULT NULL,
  `yelp_id` varchar(255) DEFAULT NULL,
  `enable_request_quote` tinyint(1) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_companies`
--

INSERT INTO `joseb_jbusinessdirectory_companies` (`id`, `name`, `alias`, `comercialName`, `short_description`, `description`, `meta_title`, `meta_description`, `street_number`, `address`, `city`, `county`, `province`, `area`, `countryId`, `website`, `keywords`, `registrationCode`, `phone`, `email`, `fax`, `state`, `typeId`, `logoLocation`, `creationDate`, `modified`, `mainSubcategory`, `latitude`, `longitude`, `activity_radius`, `userId`, `averageRating`, `review_score`, `approved`, `viewCount`, `websiteCount`, `contactCount`, `taxCode`, `package_id`, `facebook`, `twitter`, `googlep`, `skype`, `linkedin`, `youtube`, `instagram`, `pinterest`, `whatsapp`, `postalCode`, `mobile`, `slogan`, `publish_only_city`, `featured`, `business_hours`, `notes_hours`, `custom_tab_name`, `custom_tab_content`, `business_cover_image`, `publish_start_date`, `publish_end_date`, `notified_date`, `time_zone`, `establishment_year`, `employees`, `ad_image`, `disapproval_text`, `yelp_id`, `enable_request_quote`) VALUES
(1, 'Wedding Venue', 'wedding-venue', 'Home & Gardem', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut mollis justo nulla, a tempus elit pulvinar eget. Nunc tempus leo in arcu mattis lobortis. Fusce ut sollicitudin nulla. Lorem ipsum dolor sit amet, consectetur adipiscing elit.', '<p>Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Proin pellentesque, lorem porttitor commodo hendrerit, enim leo mattis risus, ac viverra ante tellus quis velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Morbi dignissim tristique sapien ut pretium. Duis sollicitudin dolor sed nisi venenatis quis fringilla diam suscipit. Sed convallis lectus non nibh suscipit ullamcorper. Fusce in magna ac lacus semper convallis. Morbi sagittis auctor massa vel consequat. Nulla fermentum, sapien a sagittis accumsan, tellus ipsum posuere tellus, a lacinia tortor lacus in nisl. Vestibulum posuere dictum ipsum ac viverra. Integer neque neque, blandit non adipiscing vel, auctor non odio. Maecenas quis nibh a diam eleifend rhoncus sed in turpis. Pellentesque mollis fermentum dolor et mollis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed ullamcorper ante ac nunc commodo vitae rutrum sem placerat. Morbi et nisi metus.</p>', '', NULL, '123', 'Old San Francisco Rd', 'Sunnyvale', 'California', NULL, NULL, 226, 'http://www.garden.com', 'wedding, planning, venue', '342423422', '34242123123', 'email@decoration.com', '434312312321', 1, '6', '/companies/1/image1-1426883774.jpg', '2015-12-20 17:37:45', '2015-12-20 20:37:45', 8, '37.3681865', '-122.031385', 0, 0, 4, 0, 2, 23, 0, 0, '123123', 0, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '94086', '', 'Your event in a magical place!', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(4, 'Water Sports', 'water-sports', 'Rent a car', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut mollis justo nulla, a tempus elit pulvinar eget. Nunc tempus leo in arcu mattis lobortis. Fusce ut sollicitudin nulla. Lorem ipsum dolor sit amet, consectetur adipiscing elit.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut mollis justo nulla, a tempus elit pulvinar eget. Nunc tempus leo in arcu mattis lobortis. Fusce ut sollicitudin nulla. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut laoreet feugiat lectus id ornare. Nulla ut odio eget justo faucibus consectetur. Ut faucibus ultrices accumsan. Aenean leo neque, accumsan ac eleifend vel, pulvinar id urna. Phasellus non malesuada augue. Maecenas id egestas quam, at molestie tortor. Sed quis dictum eros.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut mollis justo nulla, a tempus elit pulvinar eget. Nunc tempus leo in arcu mattis lobortis. Fusce ut sollicitudin nulla. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut laoreet feugiat lectus id ornare. Nulla ut odio eget justo faucibus consectetur. Ut faucibus ultrices accumsan. Aenean leo neque, accumsan ac eleifend vel, pulvinar id urna. Phasellus non malesuada augue. Maecenas id egestas quam, at molestie tortor. Sed quis dictum eros.</p>', '', '', '11', 'Young Street', 'Toronto', 'Ontario', NULL, NULL, 36, 'http://www.cmsjunkie.com', '', 'JBD-5512312', '0010727321321', 'office@email.com', '0010269/220123', 1, '6', '/companies/4/image3-1469610244.jpg', '2015-12-25 17:37:45', '2016-08-17 08:56:04', 5, '43.64208175305137', '-79.3842687603319', 0, 0, 5, 0, 2, 4, 0, 0, '123123', 0, '', '', '', '', '', '', '', '', NULL, '23123213', '001072744333', 'Live your life at maximum.', 0, 0, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(5, 'Yoga Club', 'yoga-club', 'AQUACON PROJECT', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. ', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam.</p>\r\n<p>Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. Praesent suscipit vitae sem vel sodales.</p>', '', '', '44', 'Young Street', 'Toronto', 'Ontario', NULL, NULL, 36, 'http://www.cmsjunkie.com', '', 'YG-12312', '0727321321', 'office@site.com', '0269/220123', 1, '6', '/companies/5/iamge3-1469609893.jpg', '2015-12-22 02:30:40', '2016-08-17 08:55:08', 29, '43.650081332730466', '-79.37849521636963', 15, 0, 3, 0, 2, 7, 0, 0, '123', 0, '', '', '', '', '', '', '', '', NULL, '1312312', '', 'Get in harmony with your body and soul!', 0, 0, '10:00 AM,05:00 PM,10:00 AM,05:00 PM,10:00 AM,05:00 PM,10:00 AM,05:00 PM,10:00 AM,05:00 PM,10:00 AM,05:00 PM,closed,', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(7, 'Professional Photos', 'professional-photos', 'FINE JEWELERY', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. ', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam.</p>\r\n<p>Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. Praesent suscipit vitae sem vel sodales.</p>', '', '', '33', 'Richmong', 'Toronto', 'Ontario', NULL, NULL, 36, 'http://www.cmsjunkie.com', 'keywords1', 'JBD-343243', '123123', 'office@shopping.com', '213123', 1, '6', '/companies/7/image1-1469609373.jpg', '2011-11-24 02:31:39', '2016-07-27 08:50:35', 24, '43.649677652720534', '-79.37798023223877', 30, 0, 4.25, 0, 2, 21, 0, 0, '123123', 0, 'http://www.facebook.com/cmsjunkie', 'http://www.twiter.com', 'http://www.googleplus.com', '', '', '', '', '', NULL, '23213', '', 'We save the special moments for eternity. ', 0, 1, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(8, 'Vintage photography', 'vintage-photography', 'Contruction Company', 'Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc.', '<p>Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Proin pellentesque, lorem porttitor commodo hendrerit, enim leo mattis risus, ac viverra ante tellus quis velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Morbi dignissim tristique sapien ut pretium. Duis sollicitudin dolor sed nisi venenatis quis fringilla diam suscipit. Sed convallis lectus non nibh suscipit ullamcorper. Fusce in magna ac lacus semper convallis. Morbi sagittis auctor massa vel consequat. Nulla fermentum, sapien a sagittis accumsan, tellus ipsum posuere tellus, a lacinia tortor lacus in nisl. Vestibulum posuere dictum ipsum ac viverra. Integer neque neque, blandit non adipiscing vel, auctor non odio. Maecenas quis nibh a diam eleifend rhoncus sed in turpis. Pellentesque mollis fermentum dolor et mollis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed ullamcorper ante ac nunc commodo vitae rutrum sem placerat. Morbi et nisi metus.</p>', '', '', '22', 'Lawrance', 'Toronto', 'Ontario', '', '', 36, 'http://google.com', '', 'JBD-343412', '0727321321', 'office@site.com', '0269/220123', 1, '6', '/companies/8/image7-1469608618.jpg', '2011-11-24 02:32:07', '2018-02-26 08:57:18', 24, '43.65057816594119', '-79.37493324279785', 0, 0, 4.66667, 0, 2, 186, 0, 0, '12312', 0, 'http://www.facebook.com/cmsjunkie', 'http://www.twitter.com/cmsjunkie', 'http://www.google.com/cmsjunkie', '', '', '', '', '', '', '23123123', '', 'Good old day are coming back.', 0, 1, '', '', '', '', '/companies/8/cropped-1519401860.png', NULL, NULL, NULL, '0', '', 0, NULL, NULL, NULL, 1),
(9, 'Flower Shop', 'flower-shop', 'IT Services', 'Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc.', '<p>Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Proin pellentesque, lorem porttitor commodo hendrerit, enim leo mattis risus, ac viverra ante tellus quis velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Morbi dignissim tristique sapien ut pretium. Duis sollicitudin dolor sed nisi venenatis quis fringilla diam suscipit. Sed convallis lectus non nibh suscipit ullamcorper. Fusce in magna ac lacus semper convallis. Morbi sagittis auctor massa vel consequat. Nulla fermentum, sapien a sagittis accumsan, tellus ipsum posuere tellus, a lacinia tortor lacus in nisl. Vestibulum posuere dictum ipsum ac viverra. Integer neque neque, blandit non adipiscing vel, auctor non odio. Maecenas quis nibh a diam eleifend rhoncus sed in turpis. Pellentesque mollis fermentum dolor et mollis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed ullamcorper ante ac nunc commodo vitae rutrum sem placerat. Morbi et nisi metus.</p>', '', '', '32', 'Queen Street', 'Toronto', 'Ontario', NULL, NULL, 36, 'http://google.com', '', '3424234221212', '0727321321', 'office@company.com', '0010269/220123', 1, '5', '/companies/9/image11-1469561156.jpg', '2011-12-01 07:24:29', '2016-08-17 08:58:55', 11, '43.650391853968806', '-79.38038349151611', 20, 0, 1.5, 0, 2, 15, 0, 0, '123123', 0, '', '', '', '', '', '', '', '', NULL, '123213123', '', 'One flow for one happy person. ', 0, 0, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(12, 'Tea Shop', 'tea-shop', 'Almedia', 'Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc.', '<p>Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Proin pellentesque, lorem porttitor commodo hendrerit, enim leo mattis risus, ac viverra ante tellus quis velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Morbi dignissim tristique sapien ut pretium. Duis sollicitudin dolor sed nisi venenatis quis fringilla diam suscipit. Sed convallis lectus non nibh suscipit ullamcorper. Fusce in magna ac lacus semper convallis. Morbi sagittis auctor massa vel consequat. Nulla fermentum, sapien a sagittis accumsan, tellus ipsum posuere tellus, a lacinia tortor lacus in nisl. Vestibulum posuere dictum ipsum ac viverra. Integer neque neque, blandit non adipiscing vel, auctor non odio. Maecenas quis nibh a diam eleifend rhoncus sed in turpis. Pellentesque mollis fermentum dolor et mollis. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed ullamcorper ante ac nunc commodo vitae rutrum sem placerat. Morbi et nisi metus.</p>', '', '', '74444', 'Peg Keller Rd', 'Abita Springs', 'Louisiana', NULL, NULL, 226, 'http://www.cmsjunkie.com', '', 'RT545412SD', '001010727321321', 'directory@director.com', '', 1, '1', '/companies/12/image5-1469560881.jpg', '2011-12-02 08:32:19', '2016-08-17 08:58:17', 29, '43.65538688599313', '-79.35828778892756', 20, 0, 4, 0, 2, 97, 0, 0, '123123123', 0, 'http://https://www.facebook.com/cmsjunkie', 'http://https://twitter.com/cmsjunkie', 'http://https://plus.google.com/100376620356699373069/posts', '', '', '', '', '', NULL, '70420', '', 'Enjoy our best tea for a great day!', 0, 0, '09:30 AM,06:00 PM,09:30 AM,06:00 PM,09:30 AM,06:00 PM,09:30 AM,06:00 PM,09:30 AM,06:00 PM,10:00 AM,02:00 PM,closed,', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(29, 'Yacht Club', 'yacht-club', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. ', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam.</p>\r\n<p>Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. Praesent suscipit vitae sem vel sodales.</p>', '', '', '77877', 'Mosby Creek Rd', 'Cottage Grove', 'Oregon', NULL, NULL, 226, '', '', '', '+1 232 883 9932', 'office@site.com', '', 1, '6', '/companies/29/image3-1469555619.jpg', '2015-12-20 15:44:58', '2016-08-17 08:57:57', 5, '43.77616', '-123.00627400000002', 0, 0, 0, 0, 2, 6, 0, 0, NULL, 0, 'http://www.facebook.com/cmsjunkie', 'http://www.twiter.com', 'http://www.googleplus.com', '', '', '', '', '', NULL, '97424', '+1 555 883 9932', 'We provide any yacht you want.', 0, 0, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(30, 'Real Property', 'real-property', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. ', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam.</p>\r\n<p>Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. Praesent suscipit vitae sem vel sodales.</p>', '', '', '1123', 'New York Ave', 'New York', 'New York', NULL, NULL, 226, '', '', '', '+1 232 883 9932', 'office@site.com', '', 1, '6', '/companies/30/image9-1469555370.jpg', '2016-01-20 16:12:27', '2016-07-26 17:50:05', 79, '40.645796', '-73.94583599999999', 0, 0, 0, 0, 2, 3, 0, 0, NULL, 0, 'http://www.facebook.com/cmsjunkie', 'http://www.twiter.com', 'http://www.googleplus.com', '', '', '', '', '', NULL, '11203', '+1 555 883 9932', 'We can sell it for you', 0, 0, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(31, 'Restaurant One', 'restaurant-one', NULL, 'Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam.</p>\r\n<p>Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. Praesent suscipit vitae sem vel sodales.</p>', '', '', '12', 'New Hartford St', 'Wolcott', 'New York', NULL, NULL, 226, '', '', '', '+1 232 883 9932', 'office@site.com', '', 1, '1', '/companies/31/image11-1469554921.jpg', '2016-01-20 17:30:06', '2016-08-17 08:57:32', 75, '43.2157525', '-76.81465800000001', 0, 0, 0, 0, 2, 7, 0, 0, NULL, 0, '', '', '', '', '', '', '', '', NULL, '14590', '+1 555 883 9932', 'The food taste like never before.', 0, 0, '', NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(32, 'Fashion Inc.', 'fashion-inc', NULL, 'Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus. Curabitu', '<p>Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus. Curabitur blandit dui purus, non viverra magna consequat vitae. Nunc volutpat malesuada orci vitae varius.</p>\r\n<p>Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus. Curabitur tincidunt nibh et nisl porttitor, eget ultrices turpis maximus. Fusce molestie elit eget felis cursus volutpat. Nam tincidunt lacus nec massa sagittis, eu dapibus purus bibendum. Ut hendrerit, felis nec congue posuere, lorem urna eleifend est, ac venenatis quam augue a arcu. Nullam sit amet finibus diam. Aenean placerat gravida mi at eleifend. Sed felis nulla, tempus ac vulputate vitae, condimentum vel nunc. Nam egestas, nunc sit amet tempor pellentesque, sapien justo aliquam tortor, at posuere elit purus eget orci. Aliquam hendrerit enim turpis, vitae ultrices libero accumsan nec. Pellentesque placerat volutpat fermentum. Sed tempor volutpat massa a auctor.</p>', '', '', '1', 'Rue Sherbrooke Est', 'Montréal', 'Québec', '', '', 36, '', '', '', '+1 555 888 9932', 'office@site.com', '', 1, '2', '/companies/32/fashiongirl-1469554561.jpg', '2015-12-22 05:36:50', '2018-02-23 16:08:08', 8, '45.5125554', '-73.56943790000003', 0, 0, 0, 0, 2, 7, 0, 0, NULL, 0, 'http://www.facebook.com/cmsjunkie', 'http://www.twiter.com', 'http://www.googleplus.com', '', '', '', '', '', '', 'H2X 3V8', '+1 555 883 9932', 'Fashion is art!', 0, 0, '', '', '', '', '/companies/32/cropped-1519402079.png', NULL, NULL, NULL, '0', '', 0, NULL, NULL, NULL, 1),
(33, 'Amusement Park', 'amusement-park', NULL, 'Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus.', '<p>Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus. Curabitur blandit dui purus, non viverra magna consequat vitae. Nunc volutpat malesuada orci vitae varius.</p>\r\n<p>Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus. Curabitur tincidunt nibh et nisl porttitor, eget ultrices turpis maximus. Fusce molestie elit eget felis cursus volutpat. Nam tincidunt lacus nec massa sagittis, eu dapibus purus bibendum. Ut hendrerit, felis nec congue posuere, lorem urna eleifend est, ac venenatis quam augue a arcu. Nullam sit amet finibus diam. Aenean placerat gravida mi at eleifend. Sed felis nulla, tempus ac vulputate vitae, condimentum vel nunc. Nam egestas, nunc sit amet tempor pellentesque, sapien justo aliquam tortor, at posuere elit purus eget orci. Aliquam hendrerit enim turpis, vitae ultrices libero accumsan nec. Pellentesque placerat volutpat fermentum. Sed tempor volutpat massa a auctor.</p>', '', '', '12', 'Hopkins Ave', 'Jersey City', 'New Jersey', '', '', 226, '', '', '', '+1 444 777 9999', 'office@site.com', '', 1, '6', '/companies/33/image2-1469554130.jpg', '2016-01-23 05:41:43', '2018-02-23 16:07:27', 3, '40.7343489', '-74.05115409999996', 0, 0, 0, 0, 2, 7, 0, 0, NULL, 0, '', '', '', '', '', '', '', '', '', '07306', '+1 555 883 9932', 'Our main concern is your entertainment ', 0, 0, '', '', '', '', '/companies/33/cropped-1519402034.png', NULL, NULL, NULL, '0', '', 0, NULL, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_activity_city`
--

CREATE TABLE `joseb_jbusinessdirectory_company_activity_city` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_activity_city`
--

INSERT INTO `joseb_jbusinessdirectory_company_activity_city` (`id`, `company_id`, `city_id`) VALUES
(24, 1, -1),
(27, 4, -1),
(23, 8, -1),
(26, 9, -1),
(25, 12, -1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_activity_region`
--

CREATE TABLE `joseb_jbusinessdirectory_company_activity_region` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `region_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_announcements`
--

CREATE TABLE `joseb_jbusinessdirectory_company_announcements` (
  `id` int(11) NOT NULL,
  `call_to_action` int(11) NOT NULL,
  `company_id` int(11) 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(4) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_articles`
--

CREATE TABLE `joseb_jbusinessdirectory_company_articles` (
  `article_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_attachments`
--

CREATE TABLE `joseb_jbusinessdirectory_company_attachments` (
  `id` int(11) NOT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `path` varchar(155) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `ordering` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_attachments`
--

INSERT INTO `joseb_jbusinessdirectory_company_attachments` (`id`, `type`, `object_id`, `name`, `path`, `status`, `ordering`) VALUES
(22, 2, 13, 'Treatment instructions', '/offers/13/SPA_Woman_Face_1280_770_d-1426864490.jpg', 1, 0),
(23, 1, 12, 'Healthcare catalog', '/companies/12/natural-health-1426863987.jpg', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_attributes`
--

CREATE TABLE `joseb_jbusinessdirectory_company_attributes` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `value` varchar(250) DEFAULT NULL,
  `option_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_category`
--

CREATE TABLE `joseb_jbusinessdirectory_company_category` (
  `companyId` int(11) NOT NULL,
  `categoryId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_category`
--

INSERT INTO `joseb_jbusinessdirectory_company_category` (`companyId`, `categoryId`) VALUES
(1, 8),
(1, 35),
(4, 5),
(4, 60),
(5, 29),
(5, 42),
(5, 60),
(6, 5),
(6, 17),
(7, 13),
(7, 24),
(8, 13),
(8, 24),
(9, 11),
(9, 46),
(12, 29),
(12, 41),
(12, 42),
(20, 290),
(20, 292),
(29, 5),
(29, 60),
(29, 63),
(30, 79),
(31, 75),
(31, 77),
(31, 78),
(32, 8),
(32, 35),
(32, 38),
(33, 3);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_claim`
--

CREATE TABLE `joseb_jbusinessdirectory_company_claim` (
  `id` int(11) NOT NULL,
  `companyId` int(11) 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(3) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_contact`
--

CREATE TABLE `joseb_jbusinessdirectory_company_contact` (
  `id` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `contact_name` varchar(50) DEFAULT NULL,
  `contact_function` varchar(50) DEFAULT NULL,
  `contact_department` varchar(100) DEFAULT NULL,
  `contact_email` varchar(60) DEFAULT NULL,
  `contact_phone` varchar(20) DEFAULT NULL,
  `contact_fax` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_contact`
--

INSERT INTO `joseb_jbusinessdirectory_company_contact` (`id`, `companyId`, `contact_name`, `contact_function`, `contact_department`, `contact_email`, `contact_phone`, `contact_fax`) VALUES
(1, 8, '', NULL, NULL, '', '', ''),
(2, 1, '', NULL, NULL, '', '', ''),
(3, 12, 'Joanne Smith', NULL, NULL, 'joaan@joann.com', '+1 323 999 672', '+1 323 231 754'),
(4, 9, 'John rice', NULL, NULL, 'john@organic.co', '+1 221 359 888', ''),
(5, 4, '', NULL, NULL, '', '', ''),
(6, 7, 'John Doe', NULL, NULL, 'john@john.com', '01 232 495 999', ''),
(7, 5, '', NULL, NULL, '', '', ''),
(8, 29, 'John Smith', NULL, NULL, 'john@smith.com', '+1 221 359 888', ''),
(9, 30, '', NULL, NULL, '', '', ''),
(10, 31, 'Chef Michael', NULL, NULL, 'joaan@joann.com', '', ''),
(11, 32, '', NULL, NULL, '', '', ''),
(12, 33, 'Brian Lindow', NULL, NULL, 'office@site.com', '+1 323 999 672', '');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_events`
--

CREATE TABLE `joseb_jbusinessdirectory_company_events` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `name` varchar(110) DEFAULT NULL,
  `alias` varchar(100) NOT NULL DEFAULT '',
  `short_description` varchar(245) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `meta_title` varchar(100) NOT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `street_number` varchar(20) 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(11) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `state` tinyint(1) DEFAULT NULL,
  `recurring_id` int(11) 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(11) NOT NULL,
  `total_tickets` int(11) DEFAULT NULL,
  `expiration_email_date` datetime DEFAULT NULL,
  `main_subcategory` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `enable_subscription` tinyint(1) NOT NULL DEFAULT 0,
  `postalCode` varchar(55) DEFAULT NULL,
  `countryId` int(11) DEFAULT NULL,
  `time_zone` varchar(15) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_events`
--

INSERT INTO `joseb_jbusinessdirectory_company_events` (`id`, `company_id`, `name`, `alias`, `short_description`, `description`, `meta_title`, `meta_description`, `meta_keywords`, `price`, `type`, `start_date`, `start_time`, `end_date`, `end_time`, `address`, `street_number`, `city`, `county`, `province`, `area`, `location`, `latitude`, `longitude`, `featured`, `created`, `view_count`, `approved`, `state`, `recurring_id`, `contact_phone`, `contact_email`, `doors_open_time`, `booking_open_date`, `booking_close_date`, `booking_open_time`, `booking_close_time`, `show_start_time`, `show_end_time`, `show_end_date`, `show_doors_open_time`, `currency_id`, `total_tickets`, `expiration_email_date`, `main_subcategory`, `user_id`, `enable_subscription`, `postalCode`, `countryId`, `time_zone`) VALUES
(9, 33, 'Celebration Party', 'celebration-party', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla accumsan enim dignissim consectetur viverra. Vestibulum a erat vitae quam pellentesque varius vel at ipsum. Pellentesque ultricies.', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla accumsan enim dignissim consectetur viverra. Vestibulum a erat vitae quam pellentesque varius vel at ipsum. Pellentesque ultricies porttitor bibendum. Donec et justo quis tortor egestas rhoncus hendrerit ac massa. Sed tempus iaculis mi at sollicitudin. Etiam a ligula eget magna condimentum consectetur non pulvinar purus. Phasellus quis lobortis mauris. Nullam eleifend iaculis sem, nec hendrerit quam molestie vitae. Cras condimentum, augue at pretium pellentesque, ipsum arcu ullamcorper erat, eu laoreet libero erat id erat. Vestibulum ut dolor commodo, condimentum purus in, egestas purus. In hac habitasse platea dictumst. Nam rutrum sapien quam, in viverra libero interdum a. Vivamus sollicitudin dolor eget tincidunt faucibus. Cras pretium justo neque, quis imperdiet nulla vehicula a. Nulla facilisi. Aliquam justo ligula, fringilla vel orci in, imperdiet aliquam elit. Vivamus ac lorem blandit, tempor felis eget, placerat lectus.</p>', '', '', '', '0', 4, '2019-08-14', '15:00:00', '2021-11-22', '19:00:00', ' Scarborough Heights Boulevard', NULL, 'Toronto', 'Ontario', NULL, NULL, 'Toronto, Canada', '43.72347870000001', '-79.22839210000001', 0, '2018-06-01 11:21:20', 1, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
(10, 12, 'Bike Adventure', 'bike-adventure', 'Nulla consectetur magna et cursus sagittis. Quisque ac consectetur elit. Ut volutpat tellus non orci fermentum, sit amet tincidunt quam scelerisque. Integer eleifend congue eros.', '<p>Nulla consectetur magna et cursus sagittis. Quisque ac consectetur elit. Ut volutpat tellus non orci fermentum, sit amet tincidunt quam scelerisque. Integer eleifend congue eros pellentesque pharetra. Integer sed diam lectus. Donec ultricies, arcu a vulputate fringilla, nisi quam vestibulum libero, faucibus bibendum nunc justo sed ante. Etiam luctus quis nisl nec ornare. Fusce urna leo, tincidunt at commodo non, vestibulum et erat. In faucibus posuere purus, at egestas dolor dictum ac. Maecenas volutpat lectus eget purus hendrerit, sit amet hendrerit diam mattis. Nulla imperdiet metus ac metus molestie, sed imperdiet leo eleifend. Fusce non tellus porta risus convallis vehicula. Donec quis convallis ligula.</p>', '', '', '', '0', 5, '2019-09-21', '17:00:00', '2021-11-21', '20:00:00', ' Gamble Avenue', NULL, 'Toronto', 'Ontario', NULL, NULL, 'Gamble Avenue, Toronto, Canada', '43.6903736', '-79.34918140000002', 0, '2018-06-01 11:21:20', 5, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
(11, 1, 'Violin concert', 'violin-concert', 'Nulla sagittis pretium sagittis. Aliquam tincidunt sodales dui, a facilisis nisi sollicitudin quis. Sed nec mattis augue. Sed hendrerit odio non mauris fermentum semper. ', '<p>Nulla sagittis pretium sagittis. Aliquam tincidunt sodales dui, a facilisis nisi sollicitudin quis. Sed nec mattis augue. Sed hendrerit odio non mauris fermentum semper. Praesent vehicula nec libero a imperdiet. Proin posuere nibh libero, ac euismod nulla tincidunt in. Mauris est nunc, fringilla ac facilisis a, ornare a leo. Nam lobortis tortor fringilla, lobortis nisl sit amet, cursus dolor. In at lectus massa. Integer ut nulla dapibus, volutpat nisi vitae, laoreet tellus. Quisque hendrerit blandit leo at dapibus.</p>', '', '', '', '0', 5, '2019-11-22', '15:00:00', '2021-11-24', '12:00:00', '#24 St. John', '', 'New York', 'New York', '', '', 'Gamble Avenue, Toronto, Canada', '40.72644570551446', '-74.11376953125', 1, '2018-06-01 11:21:20', 3, 1, 1, 0, '', '', '00:00:00', NULL, NULL, '00:00:00', '00:00:00', 0, 0, 0, 0, 2, NULL, NULL, 209, 0, 0, '', NULL, NULL),
(12, 8, 'Photography Course', 'photography-course', 'Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus.', '<p>Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus. Curabitur tincidunt nibh et nisl porttitor, eget ultrices turpis maximus. Fusce molestie elit eget felis cursus volutpat. Nam tincidunt lacus nec massa sagittis, eu dapibus purus bibendum. Ut hendrerit, felis nec congue posuere, lorem urna eleifend est, ac venenatis quam augue a arcu. Nullam sit amet finibus diam. Aenean placerat gravida mi at eleifend. Sed felis nulla, tempus ac vulputate vitae, condimentum vel nunc. Nam egestas, nunc sit amet tempor pellentesque, sapien justo aliquam tortor, at posuere elit purus eget orci. Aliquam hendrerit enim turpis, vitae ultrices libero accumsan nec. Pellentesque placerat volutpat fermentum. Sed tempor volutpat massa a auctor.</p>', '', '', '', '0', 3, '2019-09-23', '10:00:00', '2021-09-23', '19:30:00', '29895 Minnesota 34', '', 'Detroit Lakes', 'Minnesota', '', '', 'London, UK', '46.828117', '-95.77565600000003', 0, '2018-06-01 11:21:20', 27, 1, 1, 0, '999 231 3231', 'contact@photography.com', '00:00:00', NULL, NULL, '00:00:00', '00:00:00', 0, 0, 0, 0, 2, NULL, NULL, 192, 0, 0, '', NULL, NULL),
(13, 32, 'Fashion Presentation', 'fashion-presentation', 'Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus.', '<p>Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus. Curabitur tincidunt nibh et nisl porttitor, eget ultrices turpis maximus. Fusce molestie elit eget felis cursus volutpat. Nam tincidunt lacus nec massa sagittis, eu dapibus purus bibendum. Ut hendrerit, felis nec congue posuere, lorem urna eleifend est, ac venenatis quam augue a arcu. Nullam sit amet finibus diam. Aenean placerat gravida mi at eleifend. Sed felis nulla, tempus ac vulputate vitae, condimentum vel nunc. Nam egestas, nunc sit amet tempor pellentesque, sapien justo aliquam tortor, at posuere elit purus eget orci. Aliquam hendrerit enim turpis, vitae ultrices libero accumsan nec. Pellentesque placerat volutpat fermentum. Sed tempor volutpat massa a auctor.</p>', '', '', '', '0', 5, '2019-12-17', '17:00:00', '2021-09-23', '19:30:00', '9291 Lee Highway', '', 'Warrenton', 'Virginia', '', '', 'Paris, France', '38.694513', '-77.89013299999999', 0, '2018-06-01 11:21:20', 4, 1, 1, 0, '', '', '17:30:00', NULL, NULL, '00:00:00', '00:00:00', 1, 1, 1, 1, 2, NULL, NULL, 174, 0, 0, '', NULL, NULL),
(14, 31, 'Wine testing', 'wine-testing', 'Cras eget lorem libero. Nulla facilisi. Aliquam ac volutpat erat. Etiam vulputate pellentesque maximus. Nunc id metus nunc. Phasellus finibus ante et finibus viverra. Sed nec mattis augue.', '<p>Aliquam dignissim sagittis urna eu ultrices. Curabitur hendrerit mi leo, sed tincidunt libero venenatis eu. Curabitur non feugiat diam. Proin pharetra, leo ut pellentesque dignissim, orci libero tempus odio, congue volutpat arcu eros consectetur tortor. Cras eget volutpat felis. Ut lobortis lectus eget ligula condimentum hendrerit. Curabitur et justo nunc. Duis malesuada, est vel pellentesque viverra, nulla lorem ornare dui, eget elementum sapien elit et sapien. Nulla placerat laoreet arcu, eu ullamcorper massa viverra quis. Cras quis faucibus leo, ut iaculis sem. Cras et egestas odio, quis mollis mi. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus</p>', '', '', '', '0', 5, '2019-01-29', '02:00:00', '2021-09-23', '02:00:00', '#34 west street', NULL, 'New York', 'New York', NULL, NULL, 'Burgundy, France', '40.759078', '-73.986201', 0, '2018-06-01 11:21:20', 2, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
(15, 30, 'Design Trends', 'design-trends', 'Mauris quis finibus tellus, eget dignissim tellus. Cras eget lorem libero. Nulla facilisi. Aliquam ac volutpat erat. Nunc id metus nunc. Phasellus finibus ante et finibus viverra.', '<p>Mauris quis finibus tellus, eget dignissim tellus. Cras eget lorem libero. Nulla facilisi. Aliquam ac volutpat erat. Nunc id metus nunc. Phasellus finibus ante et finibus viverra. Mauris scelerisque dignissim mauris, sit amet congue nisi sagittis vel. Etiam lacinia sapien in nulla ultricies eleifend. Aliquam feugiat vitae magna id aliquet. Nam sem ligula, sollicitudin in placerat quis, scelerisque elementum tortor. Aenean imperdiet dictum lorem. Praesent sit amet arcu id mi hendrerit scelerisque. Integer tincidunt massa eget lectus laoreet porttitor. Fusce quis luctus orci.</p>', '', '', '', '25', 5, '2019-09-11', '11:00:00', '2021-09-23', '18:30:00', '7777 Hollywood Boulevard', '12', 'Los Angeles', 'California', '', 'Broad', 'New York, US', '34.10199989999999', '-118.35907500000002', 1, '2018-06-01 11:21:20', 2, 1, 1, 0, '(999) 23545', 'support@cmsjunkie.com', '07:00:00', '2019-02-11', '2020-02-19', '00:00:00', '00:00:00', 1, 1, 0, 1, 143, 50, NULL, 215, 0, 1, '88998', 226, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_appointments`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_appointments` (
  `id` int(11) NOT NULL,
  `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(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_associated_items`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_associated_items` (
  `event_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_event_associated_items`
--

INSERT INTO `joseb_jbusinessdirectory_company_event_associated_items` (`event_id`, `company_id`) VALUES
(11, 7),
(11, 8),
(11, 9),
(11, 32),
(12, 1),
(12, 7),
(12, 8),
(12, 9),
(13, 1),
(13, 7),
(13, 8),
(13, 32);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_bookings`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_bookings` (
  `id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `address` varchar(55) 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,
  `country` varchar(45) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `paid_at` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_booking_tickets`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_booking_tickets` (
  `booking_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_quantity` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_category`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_category` (
  `eventId` int(11) NOT NULL,
  `categoryId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_event_category`
--

INSERT INTO `joseb_jbusinessdirectory_company_event_category` (`eventId`, `categoryId`) VALUES
(9, 206),
(10, 171),
(10, 199),
(11, 209),
(12, 192),
(13, 174),
(14, 211),
(15, 215);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_pictures`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_pictures` (
  `id` int(10) NOT NULL,
  `eventId` int(10) NOT NULL DEFAULT 0,
  `picture_info` varchar(255) NOT NULL,
  `picture_path` varchar(255) NOT NULL,
  `picture_enable` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_event_pictures`
--

INSERT INTO `joseb_jbusinessdirectory_company_event_pictures` (`id`, `eventId`, `picture_info`, `picture_path`, `picture_enable`) VALUES
(101, 13, '', '/events/13/image6.jpg', 1),
(96, 11, '', '/events/11/image2.jpg', 1),
(100, 13, '', '/events/13/image5.jpg', 1),
(94, 11, '', '/events/11/image4.jpg', 1),
(62, 14, '', '/events/14/image1-1427103268.jpg', 1),
(95, 11, '', '/events/11/iamge3.jpg', 1),
(58, 15, '', '/events/15/w1-1427103368.jpg', 1),
(57, 15, '', '/events/15/image1-1427103376.jpeg', 1),
(56, 15, '', '/events/15/image4.jpg', 1),
(80, 9, '', '/events/9/image5.jpg', 1),
(79, 9, '', '/events/9/image3.jpg', 1),
(78, 9, '', '/events/9/image4.jpg', 1),
(61, 14, '', '/events/14/image3-1427103263.jpg', 1),
(60, 14, '', '/events/14/image1.jpg', 1),
(59, 15, '', '/events/15/image3-1427103371.jpg', 1),
(77, 10, '', '/events/10/image2.jpeg', 1),
(76, 10, '', '/events/10/image3.jpg', 1),
(75, 10, '', '/events/10/image1.jpg', 1),
(99, 13, '', '/events/13/image2.jpg', 1),
(98, 13, '', '/events/13/image7.jpg', 1),
(97, 13, '', '/events/13/image1.jpg', 1),
(109, 12, '', '/events/12/image7.jpg', 1),
(108, 12, '', '/events/12/image2.jpg', 1),
(107, 12, '', '/events/12/image5.jpg', 1),
(93, 11, '', '/events/11/image1.jpg', 1),
(106, 12, '', '/events/12/image13.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_tickets`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_tickets` (
  `id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `price` float DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `min_booking` int(11) DEFAULT NULL,
  `max_booking` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_event_types`
--

CREATE TABLE `joseb_jbusinessdirectory_company_event_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_event_types`
--

INSERT INTO `joseb_jbusinessdirectory_company_event_types` (`id`, `name`, `ordering`) VALUES
(1, 'Seminar', NULL),
(2, 'Training', NULL),
(3, 'Workshop', NULL),
(4, 'Party', NULL),
(5, 'Presentation', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_locations`
--

CREATE TABLE `joseb_jbusinessdirectory_company_locations` (
  `id` int(11) NOT NULL,
  `name` varchar(80) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `street_number` varchar(20) DEFAULT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(60) DEFAULT NULL,
  `county` varchar(60) DEFAULT NULL,
  `postalCode` varchar(45) DEFAULT NULL,
  `countryId` int(11) 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_marketing_email_sent`
--

CREATE TABLE `joseb_jbusinessdirectory_company_marketing_email_sent` (
  `id` int(11) NOT NULL,
  `email_type` int(11) DEFAULT NULL,
  `number_email_sent` int(11) DEFAULT NULL,
  `sending_date` datetime DEFAULT NULL,
  `failed_sent` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_membership`
--

CREATE TABLE `joseb_jbusinessdirectory_company_membership` (
  `company_id` int(11) NOT NULL,
  `membership_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offers`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offers` (
  `id` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `currencyId` int(11) NOT NULL,
  `subject` varchar(110) NOT NULL,
  `description` text DEFAULT NULL,
  `meta_title` varchar(100) NOT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `price` float DEFAULT NULL,
  `specialPrice` float DEFAULT NULL,
  `price_base` float DEFAULT NULL,
  `price_base_unit` varchar(45) DEFAULT NULL,
  `special_price_base` float DEFAULT NULL,
  `special_price_base_unit` varchar(45) DEFAULT NULL,
  `total_coupons` int(11) 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(10) DEFAULT 0,
  `alias` varchar(100) NOT NULL DEFAULT '',
  `address` varchar(45) DEFAULT NULL,
  `street_number` varchar(20) 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(2) NOT NULL DEFAULT 1,
  `url` varchar(145) DEFAULT NULL,
  `article_id` int(11) 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(11) DEFAULT NULL,
  `enable_offer_selling` tinyint(1) DEFAULT 1,
  `min_purchase` int(11) DEFAULT NULL,
  `max_purchase` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `postalCode` varchar(55) DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `countryId` int(11) DEFAULT NULL,
  `price_text` varchar(100) DEFAULT NULL,
  `offer_type` int(11) DEFAULT NULL,
  `time_zone` varchar(15) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_offers`
--

INSERT INTO `joseb_jbusinessdirectory_company_offers` (`id`, `companyId`, `currencyId`, `subject`, `description`, `meta_title`, `meta_description`, `meta_keywords`, `price`, `specialPrice`, `price_base`, `price_base_unit`, `special_price_base`, `special_price_base_unit`, `total_coupons`, `startDate`, `endDate`, `state`, `approved`, `offerOfTheDay`, `viewCount`, `alias`, `address`, `street_number`, `city`, `short_description`, `county`, `province`, `area`, `publish_start_date`, `publish_end_date`, `view_type`, `url`, `article_id`, `latitude`, `longitude`, `featured`, `created`, `show_time`, `publish_start_time`, `publish_end_time`, `expiration_email_date`, `main_subcategory`, `enable_offer_selling`, `min_purchase`, `max_purchase`, `quantity`, `user_id`, `postalCode`, `type`, `countryId`, `price_text`, `offer_type`, `time_zone`) VALUES
(3, 12, 0, 'Garden arrangements', '<p>Etiam eget urna est. Nullam turpis magna, pharetra id venenatis id, adipiscing at velit. In lobortis ornare congue. Sed vitae neque lacus, et rutrum lorem. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Pellentesque quis rhoncus felis. Sed adipiscing tellus laoreet neque adipiscing ac euismod felis gravida. Aenean fermentum, nulla non adipiscing tristique, lacus justo ornare nunc, eu aliquam nunc massa non justo. Sed at sapien vitae eros luctus condimentum non at libero. Morbi id arcu nec mi suscipit molestie. Integer ullamcorper suscipit erat, quis convallis quam interdum convallis. Sed lectus justo, vehicula et euismod rhoncus, tempus vel magna. Pellentesque laoreet, odio id iaculis bibendum, erat quam mollis urna, ac pretium neque mi vitae nisl. Fusce euismod bibendum risus vel suscipit. Suspendisse sapien tortor, vehicula sed lobortis tempus, pellentesque ut lectus.</p>', '', '', '', 120, 90, NULL, NULL, NULL, NULL, 0, '2017-02-01', '2019-12-10', 1, 1, 1, 16, 'garden-arrangements', '7777 Forest Blvd', NULL, 'Dallas', 'Etiam eget urna est. Nullam turpis magna, pharetra id venenatis id, adipiscing at velit. In lobortis ornare congue. Sed vitae neque lacus, et rutrum lorem. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae;', 'Texas', NULL, NULL, NULL, NULL, 1, '', 0, '32.9113547', '-96.77428509999999', 0, '2015-03-19 21:04:23', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(13, 5, 0, 'Yoga meditation day', '<p>Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Proin pellentesque, lorem porttitor commodo hendrerit, enim leo mattis risus, ac viverra ante tellus quis velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Morbi dignissim tristique sapien ut pretium. Duis sollicitudin dolor sed nisi venenatis quis fringilla diam suscipit. Sed convallis lectus non nibh suscipit ullamcorper. Fusce in magna ac lacus semper convallis. Morbi sagittis auctor massa vel consequat. Nulla fermentum, sapien a sagittis accumsan, tellus ipsum posuere tellus, a lacinia tortor lacus in nisl. Vestibulum posuere dictum ipsum ac viverra. Integer neque neque, blandit non adipiscing vel, auctor non odio. Maecenas quis nibh a diam eleifend rhoncus sed in turpis. Pellentesque mollis fermentum dolor et mollis. Cum sociis natoque penatibus et mag</p>', '', '', '', 69.99, 49.99, NULL, NULL, NULL, NULL, 0, '2017-02-03', '2020-01-04', 1, 1, 1, 26, 'yoga-meditation-day', 'Country Hills Blvd NW', NULL, 'Beaumont', 'Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc', 'Texas', NULL, NULL, NULL, NULL, 1, '', 0, '43.70957890823799', '-79.50366217643023', 0, '2015-03-19 21:04:23', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(14, 8, 0, 'Camera time', '<p>Duis faucibus odio quis sapien imperdiet, nec congue turpis pellentesque. Integer mi turpis, eleifend et mollis eu, dapibus quis elit. Pellentesque at turpis urna. Sed scelerisque Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula. Etiam quis libero nisl. Vestibulum quis ornare dui. Suspendisse quis lobortis nunc. Pellentesque quis pharetra metus. Phasellus vulputate orci in pharetra feugiat. Etiam vehicula lacus augue, et lacinia turpis mollis id. Phasellus sed feugiat nunc, sed pharetra risus. Etiam eleifend quis lectus et gravida. Nunc pretium nisi id mi maximus mollis. Aliquam tempus dictum mi. Donec cursus pharetra neque, at gravida dolor vestibulum sit amet. Donec quam urna, molestie pharetra venenatis in, tincidunt quis elit. Praesent pharetra eget metus vitae vestibulum. Mauris gravida turpis lorem, aliquam semper justo auc.</p>', '', '', '', 88, 55, NULL, NULL, NULL, NULL, 20, '2017-05-25', '2021-09-25', 1, 1, 0, 11, 'camera-time', 'Chopin Ave', NULL, 'Toronto', 'Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula.', 'Ontario', NULL, NULL, NULL, NULL, 1, '', 0, '43.737594787503966', '-79.27854752537314', 0, '2015-03-19 21:04:23', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(15, 1, 0, 'Book now and get 20 % off', '<p>Morbi porta luctus enim at scelerisque. Cras imperdiet nibh eget commodo blandit. Aliquam nec commodo lectus. Donec pellentesque, massa quis porta aliquet, massa metus accumsan metus, nec dignissim tortor mi eu erat. Phasellus pulvinar metus a tortor eleifend, a hendrerit tortor rutrum. Aliquam in tellus gravida, varius sem quis, interdum elit. Pellentesque nec egestas augue. Donec ullamcorper ante eu libero hendrerit, vel tempus dolor dapibus. Quisque finibus nisi eu sem venenatis porta. Praesent tempor nisi urna. Integer convallis dolor id ullamcorper consectetur. Morbi sodales mi et orci sollicitudin, sit amet pretium ante vulputate. Nullam ultrices vehicula urna in condimentum. Nulla lacus tortor, lobortis pulvinar turpis vitae, hendrerit gravida enim. Vestibulum eros magna, elementum ut pulvinar eget, placerat et augue. Vestibulum eget sapien vitae dui facilisis maximus a vel ligula. Nunc urna tortor, lobortis eu interdum vitae, mattis sit amet libero. Phasellus quis dapibus arcu, vulputate hendrerit est. Ut mattis bibendum gravida. Ut molestie ornare sapien nec dictum.</p>', '', '', '', 90, 70, NULL, NULL, NULL, NULL, 0, '2017-05-26', '2021-12-31', 1, 1, 0, 2, 'book-now-and-get-20-off', 'Chopin Ave', NULL, 'Toronto', 'Morbi porta luctus enim at scelerisque. Cras imperdiet nibh eget commodo blandit. Aliquam nec commodo lectus. Donec pellentesque, massa quis porta aliquet, massa metus accumsan metus, nec dignissim tortor mi eu erat. Phasellus pulvinar metus a torto', 'Ontario', NULL, NULL, NULL, NULL, 1, '', 0, '43.737032009283475', '-79.27838659283225', 0, '2016-01-19 22:04:23', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(16, 29, 0, 'Yacht Final Sale', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed egestas maximus arcu a posuere. Phasellus eget tellus ac purus vulputate auctor. Donec nec semper elit, quis iaculis purus. Praesent vitae facilisis enim. Vestibulum laoreet tristique velit quis porttitor. Nam venenatis vestibulum est ut aliquam. Vivamus placerat sollicitudin est ut aliquet. Fusce imperdiet auctor felis, ut egestas sem condimentum sed. Pellentesque porta sit amet justo non imperdiet. Mauris leo lorem, ultricies eu consectetur eu, laoreet nec tortor. In hac habitasse platea dictumst. Donec facilisis nulla vitae est vulputate feugiat. Nam consequat orci elit, quis condimentum massa aliquet id. Sed tortor est, dictum ac viverra a, aliquam vel lectus. Ut non ipsum sodales, cursus neque id, sollicitudin nunc. Duis vitae placerat lacus. Vestibulum sit amet neque congue, euismod diam id, sagittis felis. Aenean fringilla tempor velit sit amet pretium. Praesent sollicitudin libero in quam semper, ac vestibulum libero tempus. Integer euismod ipsum et varius mollis.</p>', '', '', '', 80000, 65000, NULL, NULL, NULL, NULL, 0, '2017-06-26', '2020-09-26', 1, 1, 0, 5, 'yacht-final-sale', '130 Yorkland Boulevard', NULL, 'Beaumont', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed egestas maximus arcu a posuere. Phasellus eget tellus ac purus vulputate auctor. Donec nec semper elit, quis iaculis purus.', 'Texas', NULL, NULL, NULL, NULL, 1, '', 0, '29.874468564024614', '-94.1099853347987', 0, '2015-03-19 21:04:23', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(17, 30, 0, 'Travel to Rome', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam. Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. P</p>', '', '', '', 1100, 890, NULL, NULL, NULL, NULL, 10, '2017-03-20', '2021-10-20', 1, 1, 0, 1, 'travel-to-rome', '24 Viale Leonardo da Vinci', NULL, 'Rome', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.', 'Lazio', NULL, NULL, NULL, NULL, 1, '', 0, '41.8546831', '12.48038459999998', 0, '2015-12-20 01:12:33', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(18, 31, 0, 'Chinese night', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam. Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus. P</p>', '', '', '', 95, 75, NULL, NULL, NULL, NULL, 0, '2017-03-20', '2021-12-20', 1, 1, 0, 3, 'chinese-night', 'Coon Creek Rd', NULL, 'Armada', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.', 'Michigan', NULL, NULL, NULL, NULL, 1, '', 0, '42.870074', '-82.92174699999998', 0, '2015-12-20 03:01:35', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(19, 7, 0, 'Photograpy course', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam. Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus.</p>', '', '', '', 100, 80, NULL, NULL, NULL, NULL, 50, '2017-03-20', '2021-12-20', 1, 1, 0, 1, 'photograpy-course', 'Mont Steet', NULL, 'Loretto', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.', 'Minnesota', NULL, NULL, NULL, NULL, 1, '', 0, '45.11', '-93.67000000000002', 0, '2016-01-20 03:46:55', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(20, 9, 0, 'Flower bucket', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nunc scelerisque enim ut magna vulputate feugiat. Suspendisse rutrum lectus et diam congue, sed pretium eros facilisis. Pellentesque pretium lectus orci, non accumsan velit vestibulum a. Fusce orci dui, tincidunt et tortor non, auctor rutrum mauris. Vestibulum sed ultricies enim, at ultrices quam. Quisque pellentesque libero eget dui elementum scelerisque. Pellentesque tempor arcu in hendrerit molestie. Phasellus euismod nisi in malesuada convallis. Praesent sapien neque, fermentum a laoreet eget, tempus ultricies nulla. Mauris mi tortor, maximus eu risus vitae, bibendum vestibulum leo. Nulla vitae efficitur lectus. Aenean aliquet massa magna. Nullam at dapibus mi. Vivamus massa nibh, venenatis mattis nibh pretium, pretium volutpat leo. Vestibulum eu sem elit. Duis consequat, magna id semper elementum, est nisi pharetra orci, eget molestie diam purus sed sem. Vestibulum est purus, sollicitudin eget lectus ut, molestie aliquam purus.</p>', '', '', '', 55, 45, NULL, NULL, NULL, NULL, 30, '2017-03-20', '2021-03-20', 1, 1, 0, 7, 'real-estate-offer', 'U.S. 101', NULL, 'Florence', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.', 'Oregon', NULL, NULL, NULL, NULL, 1, '', 0, '44.244779', '-124.11095399999999', 1, '2015-03-20 03:02:25', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(21, 33, 0, 'Roller Coaster', '<p>Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus. Curabitur blandit dui purus, non viverra magna consequat vitae. Nunc volutpat malesuada orci vitae varius. Suspendisse accumsan nunc non dictum bibendum. Sed suscipit id ipsum ut tincidunt. Vivamus condimentum diam at condimentum scelerisque. Etiam vulputate pellentesque maximus. Curabitur tincidunt nibh et nisl porttitor, eget ultrices turpis maximus. Fusce molestie elit eget felis cursus volutpat. Nam tincidunt lacus nec massa sagittis, eu dapibus purus bibendum. Ut hendrerit, felis nec congue posuere, lorem urna eleifend est, ac venenatis quam augue a arcu. Nullam sit amet finibus diam. Aenean placerat gravida mi at eleifend. Sed felis nulla, tempus ac vulputate vitae, condimentum vel nunc. Nam egestas, nunc sit amet tempor pellentesque, sapien justo aliquam tortor, at posuere elit purus eget orci. Aliquam hendrerit enim turpis, vitae ultrices libero accumsan nec.</p>', '', '', '', 50, 30, NULL, NULL, NULL, NULL, 10, '2017-03-23', '2020-03-23', 1, 1, 0, 3, 'roller-coaster', 'Hopkins Ave', NULL, 'Jersey City', 'Donec eleifend purus nulla, non vehicula nisi dictum quis. Maecenas in odio purus. Etiam vulputate nisi eget pharetra tincidunt. Morbi et eros consectetur, ultricies ligula quis, ullamcorper neque. Donec pellentesque felis vel luctus tempus. ', 'New Jersey', NULL, NULL, NULL, NULL, 1, '', 0, '40.7367335', '-74.05566350000004', 1, '2015-12-22 18:01:16', 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL),
(22, 8, 143, 'Modern Photo course ', '<p>Duis faucibus odio quis sapien imperdiet, nec congue turpis pellentesque. Integer mi turpis, eleifend et mollis eu, dapibus quis elit. Pellentesque at turpis urna. Sed scelerisque Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula. Etiam quis libero nisl. Vestibulum quis ornare dui. Suspendisse quis lobortis nunc. Pellentesque quis pharetra metus. Phasellus vulputate orci in pharetra feugiat. Etiam vehicula lacus augue, et lacinia turpis mollis id. Phasellus sed feugiat nunc, sed pharetra risus. Etiam eleifend quis lectus et gravida. Nunc pretium nisi id mi maximus mollis. Aliquam tempus dictum mi. Donec cursus pharetra neque, at gravida dolor vestibulum sit amet. Donec quam urna, molestie pharetra venenatis in, tincidunt quis elit. Praesent pharetra eget metus vitae vestibulum. Mauris gravida turpis lorem, aliquam semper justo auc.</p>', '', '', '', 125, 65, 0, '0', 0, '0', 60, '2018-02-01', '2021-02-23', 1, 1, 0, 5, 'modern-photo-course', 'Elizabeth Street', '200', 'Toronto', 'Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula.', 'Ontario', 'Toronto Division', '', NULL, NULL, 1, '', 0, '43.6590522', '-79.38796100000002', 0, '2018-02-23 14:36:24', 0, '00:00:00', '00:00:00', NULL, 124, 1, NULL, NULL, NULL, 0, 'M5G 2C4', 1, NULL, NULL, NULL, NULL),
(23, 8, 143, 'Photography Basics Course', '<p>Duis faucibus odio quis sapien imperdiet, nec congue turpis pellentesque. Integer mi turpis, eleifend et mollis eu, dapibus quis elit. Pellentesque at turpis urna. Sed scelerisque Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula. Etiam quis libero nisl. Vestibulum quis ornare dui. Suspendisse quis lobortis nunc. Pellentesque quis pharetra metus. Phasellus vulputate orci in pharetra feugiat. Etiam vehicula lacus augue, et lacinia turpis mollis id. Phasellus sed feugiat nunc, sed pharetra risus. Etiam eleifend quis lectus et gravida. Nunc pretium nisi id mi maximus mollis. Aliquam tempus dictum mi. Donec cursus pharetra neque, at gravida dolor vestibulum sit amet. Donec quam urna, molestie pharetra venenatis in, tincidunt quis elit. Praesent pharetra eget metus vitae vestibulum. Mauris gravida turpis lorem, aliquam semper justo auc.</p>', '', '', '', 180, 120, 0, '0', 0, '0', 20, '2018-02-23', '2021-02-23', 1, 1, 0, 16, 'photography-basics-course', 'Lawrence Avenue West', '22', 'Toronto', 'Diam scelerisque fermentum finibus. Mauris elementum euismod erat sed condimentum. Nulla imperdiet mattis massa, at fermentum erat tristique ac. Praesent eget velit maximus, blandit nisi at, porta ligula.', 'Ontario', 'Toronto Division', '', NULL, NULL, 1, '', 0, '43.7112087', '-79.46759759999998', 0, '2018-02-23 14:41:07', 0, '00:00:00', '00:00:00', NULL, 124, 1, NULL, NULL, NULL, 0, '23123123', 1, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_category`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_category` (
  `offerId` int(11) NOT NULL,
  `categoryId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_offer_category`
--

INSERT INTO `joseb_jbusinessdirectory_company_offer_category` (`offerId`, `categoryId`) VALUES
(3, 93),
(3, 109),
(13, 140),
(14, 115),
(15, 99),
(16, 103),
(17, 147),
(18, 86),
(18, 88),
(19, 115),
(19, 124),
(20, 147),
(21, 121),
(21, 142),
(22, 116),
(22, 124),
(23, 116),
(23, 124);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_coupons`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_coupons` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `offer_id` int(11) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `generated_time` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_orders`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_orders` (
  `id` int(11) NOT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `address` varchar(55) 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,
  `country` varchar(45) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `tracking_link` varchar(255) DEFAULT NULL,
  `shipping` decimal(8,2) DEFAULT NULL,
  `initial_amount` decimal(8,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_order_products`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_order_products` (
  `order_id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `currencyId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_pictures`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_pictures` (
  `id` int(10) NOT NULL,
  `offerId` int(10) NOT NULL DEFAULT 0,
  `picture_info` varchar(255) NOT NULL,
  `picture_path` varchar(255) NOT NULL,
  `picture_enable` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_offer_pictures`
--

INSERT INTO `joseb_jbusinessdirectory_company_offer_pictures` (`id`, `offerId`, `picture_info`, `picture_path`, `picture_enable`) VALUES
(187, 19, '', '/offers/19/image4.jpg', 1),
(188, 19, '', '/offers/19/image8.jpg', 1),
(189, 19, '', '/offers/19/image12.jpg', 1),
(150, 15, '', '/offers/15/image4.jpg', 1),
(154, 14, '', '/offers/14/image2.jpg', 1),
(155, 14, '', '/offers/14/image5.jpg', 1),
(153, 14, '', '/offers/14/image8.jpg', 1),
(145, 18, '', '/offers/18/image3.jpg', 1),
(183, 3, '', '/offers/3/image2.jpg', 1),
(144, 18, '', '/offers/18/image1.jpg', 1),
(186, 19, '', '/offers/19/image9.jpg', 1),
(185, 13, '', '/offers/13/image1.png', 1),
(184, 13, '', '/offers/13/image4.jpg', 1),
(143, 18, '', '/offers/18/image2.jpg', 1),
(152, 15, '', '/offers/15/image5.jpg', 1),
(149, 16, '', '/offers/16/image1.jpg', 1),
(151, 15, '', '/offers/15/image6.jpg', 1),
(174, 17, '', '/offers/17/image8.jpg', 1),
(173, 17, '', '/offers/17/image1.jpg', 1),
(172, 17, '', '/offers/17/image4.jpg', 1),
(138, 20, '', '/offers/20/image1.jpg', 1),
(136, 20, '', '/offers/20/image9.jpg', 1),
(137, 20, '', '/offers/20/iamge10.jpg', 1),
(135, 21, '', '/offers/21/image1.jpg', 1),
(134, 21, '', '/offers/21/image14.jpg', 1),
(233, 23, '', '/offers/23/stockphoto102338735.jpg', 1),
(232, 23, '', '/offers/23/blogimage7.jpg', 1),
(240, 22, '', '/offers/22/image11.jpg', 1),
(234, 23, '', '/offers/23/womensbanner.jpg', 1),
(239, 22, '', '/offers/22/image5.jpg', 1),
(238, 22, '', '/offers/22/blogimage4.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_offer_types`
--

CREATE TABLE `joseb_jbusinessdirectory_company_offer_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_pictures`
--

CREATE TABLE `joseb_jbusinessdirectory_company_pictures` (
  `id` int(10) NOT NULL,
  `companyId` int(10) NOT NULL DEFAULT 0,
  `picture_info` varchar(255) NOT NULL,
  `picture_path` varchar(255) NOT NULL,
  `picture_enable` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_pictures`
--

INSERT INTO `joseb_jbusinessdirectory_company_pictures` (`id`, `companyId`, `picture_info`, `picture_path`, `picture_enable`) VALUES
(503, 4, '', '/companies/4/image3.jpg', 1),
(512, 31, '', '/companies/31/image8.jpg', 1),
(527, 9, '', '/companies/9/image1.jpg', 1),
(485, 7, '', '/companies/7/image4.jpg', 1),
(452, 30, '', '/companies/30/image1.jpg', 1),
(550, 32, '', '/companies/32/image4.jpg', 1),
(549, 32, '', '/companies/32/image7.jpg', 1),
(544, 33, '', '/companies/33/image4.jpg', 1),
(543, 33, '', '/companies/33/image3.jpg', 1),
(542, 33, '', '/companies/33/image2.jpg', 1),
(528, 9, '', '/companies/9/image7.jpeg', 1),
(511, 31, '', '/companies/31/image3-1426883370.jpg', 1),
(548, 32, '', '/companies/32/image6.jpg', 1),
(547, 32, '', '/companies/32/image5.jpg', 1),
(546, 32, '', '/companies/32/image2.jpg', 1),
(541, 33, '', '/companies/33/image1.jpg', 1),
(451, 30, '', '/companies/30/image6.jpg', 1),
(450, 30, '', '/companies/30/image11.jpg', 1),
(449, 30, '', '/companies/30/image5.jpg', 1),
(522, 12, '', '/companies/12/image2.jpg', 1),
(521, 12, '', '/companies/12/iamge4.jpg', 1),
(518, 12, '', '/companies/12/iamge3.jpg', 1),
(519, 12, '', '/companies/12/image1.jpg', 1),
(520, 12, '', '/companies/12/image5.jpg', 1),
(348, 1, '', '/companies/1/image3-1426883856.jpg', 1),
(347, 1, '', '/companies/1/image2-1426883853.jpg', 1),
(346, 1, '', '/companies/1/image1-1426883851.jpg', 1),
(517, 29, '', '/companies/29/image2.jpg', 1),
(516, 29, '', '/companies/29/image3.jpg', 1),
(497, 5, '', '/companies/5/iamge3.jpg', 1),
(495, 5, '', '/companies/5/image4.jpg', 1),
(496, 5, '', '/companies/5/iamge2.jpg', 1),
(349, 1, '', '/companies/1/image4-1426883859.jpg', 1),
(350, 1, '', '/companies/1/image5-1426883862.jpg', 1),
(526, 9, '', '/companies/9/iamge5.jpg', 1),
(525, 9, '', '/companies/9/image9.jpg', 1),
(524, 9, '', '/companies/9/image2.jpg', 1),
(523, 9, '', '/companies/9/iamge10.jpg', 1),
(484, 7, '', '/companies/7/image11.jpg', 1),
(483, 7, '', '/companies/7/image8.jpg', 1),
(482, 7, '', '/companies/7/image6.jpg', 1),
(481, 7, '', '/companies/7/image2.jpg', 1),
(480, 7, '', '/companies/7/iamge5.jpg', 1),
(545, 32, '', '/companies/32/image1.jpg', 1),
(502, 4, '', '/companies/4/iamge5.jpg', 1),
(501, 4, '', '/companies/4/image4.jpg', 1),
(500, 4, '', '/companies/4/image1.jpg', 1),
(499, 4, '', '/companies/4/image2.jpg', 1),
(510, 31, '', '/companies/31/image1-1426883363.jpg', 1),
(509, 31, '', '/companies/31/image9.jpg', 1),
(508, 31, '', '/companies/31/image10.jpg', 1),
(448, 30, '', '/companies/30/image7.jpg', 1),
(515, 29, '', '/companies/29/image1.jpg', 1),
(514, 29, '', '/companies/29/image4.jpg', 1),
(513, 31, '', '/companies/31/image2-1426883367.jpg', 1),
(586, 8, '', '/companies/8/image8.jpg', 1),
(585, 8, '', '/companies/8/image7.jpg', 1),
(584, 8, '', '/companies/8/image2.jpg', 1),
(583, 8, '', '/companies/8/image11.jpg', 1),
(582, 8, '', '/companies/8/image1.jpg', 1),
(581, 8, '', '/companies/8/image5.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_projects`
--

CREATE TABLE `joseb_jbusinessdirectory_company_projects` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `company_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_projects_pictures`
--

CREATE TABLE `joseb_jbusinessdirectory_company_projects_pictures` (
  `id` int(11) NOT NULL,
  `projectId` int(11) NOT NULL DEFAULT 0,
  `picture_info` varchar(255) NOT NULL,
  `picture_path` varchar(255) NOT NULL,
  `picture_enable` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_providers`
--

CREATE TABLE `joseb_jbusinessdirectory_company_providers` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `max_clients` int(11) DEFAULT NULL,
  `availability` varchar(255) DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `company_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_provider_hours`
--

CREATE TABLE `joseb_jbusinessdirectory_company_provider_hours` (
  `id` int(11) NOT NULL,
  `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(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_provider_hours`
--

INSERT INTO `joseb_jbusinessdirectory_company_provider_hours` (`id`, `weekday`, `start_hour`, `end_hour`, `type`, `status`, `item_type`, `provider_id`) VALUES
(1, 1, '08:00:00', '20:00:00', 0, 1, 1, 8),
(2, 2, '08:00:00', '20:00:00', 0, 1, 1, 8),
(3, 3, '08:00:00', '20:00:00', 0, 1, 1, 8),
(4, 4, '08:00:00', '20:00:00', 0, 1, 1, 8),
(5, 5, '08:00:00', '20:00:00', 0, 1, 1, 8),
(6, 6, '08:00:00', '17:00:00', 0, 1, 1, 8),
(7, 7, NULL, NULL, 0, 0, 1, 8),
(8, 1, '09:00:00', '17:00:00', 0, 1, 1, 33),
(9, 2, '09:00:00', '17:00:00', 0, 1, 1, 33),
(10, 3, '09:00:00', '17:00:00', 0, 1, 1, 33),
(11, 4, '09:00:00', '17:00:00', 0, 1, 1, 33),
(12, 5, '09:00:00', '17:00:00', 0, 1, 1, 33),
(13, 6, '09:00:00', '14:00:00', 0, 1, 1, 33),
(14, 7, NULL, NULL, 0, 0, 1, 33),
(15, 1, '10:00:00', '17:00:00', 0, 1, 1, 32),
(16, 2, '10:00:00', '17:00:00', 0, 1, 1, 32),
(17, 3, '10:00:00', '17:00:00', 0, 1, 1, 32),
(18, 4, '10:00:00', '17:00:00', 0, 1, 1, 32),
(19, 5, '10:00:00', '17:00:00', 0, 1, 1, 32),
(20, 6, '10:00:00', '13:00:00', 0, 1, 1, 32),
(21, 7, NULL, NULL, 0, 0, 1, 32);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_provider_services`
--

CREATE TABLE `joseb_jbusinessdirectory_company_provider_services` (
  `provider_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_ratings`
--

CREATE TABLE `joseb_jbusinessdirectory_company_ratings` (
  `id` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `rating` float NOT NULL,
  `ipAddress` varchar(45) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_ratings`
--

INSERT INTO `joseb_jbusinessdirectory_company_ratings` (`id`, `companyId`, `rating`, `ipAddress`) VALUES
(1, 8, 4, '5.15.238.52'),
(2, 12, 4, '5.15.238.52'),
(3, 5, 3, '5.15.238.52'),
(4, 4, 5, '5.15.238.52'),
(5, 1, 3, '5.15.238.52'),
(6, 7, 3.5, '5.15.238.52'),
(7, 9, 1.5, '5.15.238.52'),
(8, 8, 5, '127.0.0.1'),
(9, 1, 5, '127.0.0.1'),
(10, 7, 5, '127.0.0.1');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_related`
--

CREATE TABLE `joseb_jbusinessdirectory_company_related` (
  `company_id` int(11) NOT NULL,
  `related_company_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_related`
--

INSERT INTO `joseb_jbusinessdirectory_company_related` (`company_id`, `related_company_id`) VALUES
(8, 1),
(8, 7),
(8, 32);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_requests`
--

CREATE TABLE `joseb_jbusinessdirectory_company_requests` (
  `company_id` int(11) NOT NULL,
  `quote_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `email` varchar(55) DEFAULT NULL,
  `likeCount` smallint(6) DEFAULT 0,
  `dislikeCount` smallint(6) DEFAULT 0,
  `state` tinyint(4) NOT NULL DEFAULT 1,
  `itemId` int(11) NOT NULL,
  `creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
  `aproved` tinyint(1) NOT NULL DEFAULT 0,
  `ipAddress` varchar(45) DEFAULT NULL,
  `abuseReported` tinyint(1) NOT NULL DEFAULT 0,
  `rating` float NOT NULL DEFAULT 0,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `review_type` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_reviews`
--

INSERT INTO `joseb_jbusinessdirectory_company_reviews` (`id`, `name`, `subject`, `description`, `userId`, `email`, `likeCount`, `dislikeCount`, `state`, `itemId`, `creationDate`, `aproved`, `ipAddress`, `abuseReported`, `rating`, `approved`, `review_type`) VALUES
(8, 'Kelly', 'The best experience ever', 'Ut scelerisque eget mi eget porttitor. Nunc risus enim, volutpat et tempor eu, pretium et est. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam turpis nisl, laoreet varius mauris ac, porta pulvinar felis. Vestibulum placerat, velit eleifend facilisis cursus, turpis nisl ullamcorper eros, eu tristique est nisl a dui. Vestibulum elementum diam sed iaculis porttitor.', 439, NULL, 0, 0, 1, 12, '2015-03-24 13:03:37', 0, '127.0.0.1', 0, 4.17, 2, 1),
(9, 'Sam', 'A happy customer', 'Sed non risus erat. Cras ac dapibus augue. Pellentesque non purus at massa viverra tempus vel vestibulum elit. Quisque in libero in diam consectetur convallis at sed dolor. Nunc finibus arcu sed maximus lacinia. Vestibulum et eleifend lectus, ut laoreet elit. ', 439, NULL, 0, 0, 1, 12, '2015-03-24 13:09:42', 0, '127.0.0.1', 0, 4.67, 2, 1),
(4, 'Loren Jonson', 'Love the products', 'I had such a good experience on this store.', 0, NULL, 0, 0, 1, 9, '2015-03-20 18:09:48', 0, '127.0.0.1', 0, 5, 2, 1),
(5, 'John', 'This is what I was looking for', 'Praesent quis tellus id enim imperdiet tempor. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Cras interdum ut ante non porta. Pellentesque convallis est vel velit luctus, in consequat tortor rutrum. In lectus quam, tempor eu diam efficitur, fringilla aliquet sapien.', 439, NULL, 0, 0, 1, 8, '2015-03-24 11:59:05', 0, '127.0.0.1', 0, 5, 2, 1),
(6, 'Michael', 'Greate store', 'Praesent id leo ex. Donec condimentum tincidunt metus at auctor. Nulla facilisis orci vitae ipsum volutpat pharetra. Proin eleifend lobortis nunc, in fringilla justo. Ut sollicitudin lacinia ex eget dapibus. Cras pharetra diam eu malesuada sagittis. Mauris eget ligula gravida, imperdiet ligula a, dictum ex. ', 439, NULL, 0, 0, 1, 29, '2015-03-24 12:49:41', 0, '127.0.0.1', 0, 4.33, 2, 1),
(7, 'Kevin', 'The best experience ever', 'Pellentesque convallis est vel velit luctus, in consequat tortor rutrum. In lectus quam, tempor eu diam efficitur, fringilla aliquet sapien. Praesent quis tellus id enim imperdiet tempor. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Cras interdum ut ante non porta. ', 439, NULL, 0, 0, 1, 8, '2015-03-24 12:58:42', 0, '127.0.0.1', 0, 4.83, 2, 1),
(10, 'John', 'Great food, great service', 'Maecenas convallis malesuada iaculis. Nullam non maximus velit, id molestie est. Pellentesque lobortis sodales tortor. Proin non sollicitudin felis, aliquam ornare massa. Fusce vel turpis est. Nam tempus turpis at orci rutrum tincidunt quis ac odio. Maecenas nec molestie arcu. Suspendisse potenti. Donec gravida diam urna, rutrum malesuada nisi tempor in. Vivamus vel ligula sed ante mattis venenatis. Cras ultricies ornare elit nec blandit. Morbi convallis tellus laoreet, egestas sapien non, condimentum ante. Donec egestas scelerisque est ut aliquam. Nam vulputate felis eu massa imperdiet facilisis. Interdum et malesuada fames ac ante ipsum primis in faucibus. ', 439, NULL, 0, 0, 1, 31, '2015-03-24 16:16:10', 0, '127.0.0.1', 0, 3.83, 2, 1),
(11, 'John McColin', 'Great experience', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Eu tincidunt tortor aliquam nulla facilisi. Urna nunc id cursus metus. Integer eget aliquet nibh praesent tristique magna sit. Sed euismod nisi porta lorem. ', 0, 'john@gmail.com', 0, 0, 1, 8, '2018-02-26 13:14:32', 0, '::1', 0, 5, 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews_criteria`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews_criteria` (
  `id` int(11) NOT NULL,
  `name` varchar(77) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL,
  `published` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_reviews_criteria`
--

INSERT INTO `joseb_jbusinessdirectory_company_reviews_criteria` (`id`, `name`, `ordering`, `published`) VALUES
(1, 'Service', 1, NULL),
(2, 'Quality', 2, NULL),
(3, 'Staff', 3, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews_criteria_category`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews_criteria_category` (
  `criteriaId` int(11) NOT NULL,
  `categoryId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_reviews_criteria_category`
--

INSERT INTO `joseb_jbusinessdirectory_company_reviews_criteria_category` (`criteriaId`, `categoryId`) VALUES
(1, -1),
(2, -1),
(3, -1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews_question`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews_question` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `is_mandatory` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews_question_answer`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews_question_answer` (
  `id` int(11) NOT NULL,
  `review_id` int(11) DEFAULT NULL,
  `question_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `answer` varchar(455) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_reviews_user_criteria`
--

CREATE TABLE `joseb_jbusinessdirectory_company_reviews_user_criteria` (
  `id` int(11) NOT NULL,
  `review_id` int(11) DEFAULT NULL,
  `criteria_id` int(11) DEFAULT NULL,
  `score` decimal(2,1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_reviews_user_criteria`
--

INSERT INTO `joseb_jbusinessdirectory_company_reviews_user_criteria` (`id`, `review_id`, `criteria_id`, `score`) VALUES
(28, 3, 1, 5.0),
(29, 3, 2, 4.0),
(30, 3, 3, 5.0),
(31, 4, 1, 5.0),
(32, 4, 2, 5.0),
(33, 4, 3, 5.0),
(34, 5, 1, 5.0),
(35, 5, 2, 5.0),
(36, 5, 3, 5.0),
(37, 6, 1, 4.0),
(38, 6, 2, 4.0),
(39, 6, 3, 5.0),
(40, 7, 1, 5.0),
(41, 7, 2, 5.0),
(42, 7, 3, 5.0),
(43, 8, 1, 4.0),
(44, 8, 2, 5.0),
(45, 8, 3, 4.0),
(46, 9, 1, 5.0),
(47, 9, 2, 5.0),
(48, 9, 3, 5.0),
(49, 10, 1, 4.0),
(50, 10, 2, 4.0),
(51, 10, 3, 4.0);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_review_abuses`
--

CREATE TABLE `joseb_jbusinessdirectory_company_review_abuses` (
  `id` int(11) NOT NULL,
  `reviewId` int(11) NOT NULL,
  `email` varchar(45) NOT NULL,
  `description` text NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_review_responses`
--

CREATE TABLE `joseb_jbusinessdirectory_company_review_responses` (
  `id` int(11) NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `reviewId` int(11) NOT NULL,
  `firstName` varchar(45) DEFAULT NULL,
  `lastName` varchar(45) DEFAULT NULL,
  `response` text DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_services`
--

CREATE TABLE `joseb_jbusinessdirectory_company_services` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `show_duration` tinyint(1) NOT NULL DEFAULT 0,
  `price` float DEFAULT NULL,
  `currency_id` int(10) NOT NULL,
  `max_booking` int(11) DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `company_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_services_list`
--

CREATE TABLE `joseb_jbusinessdirectory_company_services_list` (
  `id` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `service_section` varchar(100) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `service_description` text DEFAULT NULL,
  `service_price` float DEFAULT NULL,
  `service_image` varchar(250) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_service_bookings`
--

CREATE TABLE `joseb_jbusinessdirectory_company_service_bookings` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `first_name` varchar(45) DEFAULT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `address` varchar(55) 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,
  `country` varchar(45) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `paid_at` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_sounds`
--

CREATE TABLE `joseb_jbusinessdirectory_company_sounds` (
  `id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `url` varchar(450) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_testimonials`
--

CREATE TABLE `joseb_jbusinessdirectory_company_testimonials` (
  `id` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `testimonial_title` varchar(50) DEFAULT NULL,
  `testimonial_name` varchar(50) DEFAULT NULL,
  `testimonial_description` varchar(450) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_testimonials`
--

INSERT INTO `joseb_jbusinessdirectory_company_testimonials` (`id`, `companyId`, `testimonial_title`, `testimonial_name`, `testimonial_description`) VALUES
(6, 8, 'Great experience', 'John Doe', 'Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc.'),
(7, 33, '', '', ''),
(8, 32, '', '', ''),
(9, 8, 'Wonderfull services', 'Clara ', 'Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. ');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_types`
--

CREATE TABLE `joseb_jbusinessdirectory_company_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `ordering` tinyint(4) DEFAULT NULL,
  `only_for_admin` tinyint(1) NOT NULL DEFAULT 0,
  `company_view` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_types`
--

INSERT INTO `joseb_jbusinessdirectory_company_types` (`id`, `name`, `ordering`, `only_for_admin`, `company_view`) VALUES
(1, 'Manufacturer/producer', 1, 0, 0),
(2, 'Distributor ', 2, 0, 0),
(4, 'Wholesaler ', 3, 0, 0),
(5, 'Retailer', 4, 0, 0),
(6, 'Service Provider', 5, 0, 0),
(7, 'Subcontractor', 6, 0, 0),
(8, 'Agent/Representative', 7, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_company_videos`
--

CREATE TABLE `joseb_jbusinessdirectory_company_videos` (
  `id` int(11) NOT NULL,
  `companyId` int(11) DEFAULT NULL,
  `url` varchar(245) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_company_videos`
--

INSERT INTO `joseb_jbusinessdirectory_company_videos` (`id`, `companyId`, `url`) VALUES
(55, 8, 'https://www.youtube.com/watch?v=nAvIGmiFilM'),
(54, 8, 'https://www.youtube.com/watch?v=u9prcUCHlqM');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conferences`
--

CREATE TABLE `joseb_jbusinessdirectory_conferences` (
  `id` int(11) NOT NULL,
  `name` varchar(125) DEFAULT NULL,
  `alias` varchar(125) DEFAULT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `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(11) NOT NULL DEFAULT 0,
  `featured` tinyint(1) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_sessions`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_sessions` (
  `id` int(11) NOT NULL,
  `name` varchar(125) DEFAULT NULL,
  `alias` varchar(125) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `locationId` int(11) DEFAULT NULL,
  `sessiontypeId` int(11) DEFAULT NULL,
  `sessionlevelId` int(11) DEFAULT NULL,
  `short_description` varchar(355) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `viewCount` int(11) NOT NULL DEFAULT 0,
  `published` tinyint(1) DEFAULT 1,
  `conferenceId` int(11) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_attachments`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_attachments` (
  `id` int(11) NOT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `path` varchar(155) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `ordering` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_categories`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_categories` (
  `sessionId` int(11) NOT NULL,
  `categoryId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_companies`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_companies` (
  `sessionId` int(11) NOT NULL,
  `companyId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_levels`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_levels` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_locations`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_locations` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_speakers`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_speakers` (
  `sessionId` int(11) NOT NULL,
  `speakerId` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_session_types`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_session_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `clickCount` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_speakers`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_speakers` (
  `id` int(11) NOT NULL,
  `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(11) DEFAULT NULL,
  `speaker_language` varchar(100) DEFAULT NULL,
  `biography` text DEFAULT NULL,
  `sessionId` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `speakertypeId` int(11) 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 DEFAULT NULL,
  `additional_info_link` varchar(100) DEFAULT NULL,
  `viewCount` int(11) NOT NULL DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_conference_speaker_types`
--

CREATE TABLE `joseb_jbusinessdirectory_conference_speaker_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_countries`
--

CREATE TABLE `joseb_jbusinessdirectory_countries` (
  `id` int(10) NOT NULL,
  `country_name` char(255) NOT NULL,
  `country_code` varchar(4) DEFAULT NULL,
  `country_currency` char(255) NOT NULL,
  `country_currency_short` char(50) NOT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `description` varchar(245) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_countries`
--

INSERT INTO `joseb_jbusinessdirectory_countries` (`id`, `country_name`, `country_code`, `country_currency`, `country_currency_short`, `logo`, `description`) VALUES
(1, 'Andorra', 'AD', 'Euro', 'EUR', '/flags/andorra.png', NULL),
(2, 'United Arab Emirates', 'AE', 'UAE Dirham', 'AED', '/flags/united-arab-emirates.png', NULL),
(3, 'Afghanistan', 'AF', 'Afghani', 'AFA', '/flags/afghanistan.png', NULL),
(4, 'Antigua and Barbuda', 'AG', 'East Caribbean Dollar', 'XCD', '/flags/antigua-and-barbuda.png', NULL),
(5, 'Anguilla', 'AI', 'East Caribbean Dollar', 'XCD', '/flags/anguilla.png', NULL),
(6, 'Albania', 'AL', 'Lek', 'ALL', '/flags/albania.png', NULL),
(7, 'Armenia', 'AM', 'Armenian Dram', 'AMD', '/flags/armenia.png', NULL),
(8, 'Netherlands Antilles', 'AN', 'Netherlands Antillean guilder', 'ANG', '/flags/netherlands-antilles.png', NULL),
(9, 'Angola', 'AO', 'Kwanza', 'AOA', '/flags/angola.png', NULL),
(11, 'Argentina', 'AR', 'Argentine Peso', 'ARS', '/flags/argentina.png', NULL),
(12, 'American Samoa', 'AS', 'US Dollar', 'USD', '/flags/american-samoa.png', NULL),
(13, 'Austria', 'AT', 'Euro', 'EUR', '/flags/austria.png', NULL),
(14, 'Australia', 'AU', 'Australian dollar', 'AUD', '/flags/australia.png', NULL),
(15, 'Aruba', 'AW', 'Aruban Guilder', 'AWG', '/flags/aruba.png', NULL),
(16, 'Azerbaijan', 'AZ', 'Azerbaijani Manat', 'AZM', '/flags/azerbaijan.png', NULL),
(17, 'Bosnia and Herzegovina', 'BA', 'Convertible Marka', 'BAM', '/flags/bosnia-and-herzegovina.png', NULL),
(18, 'Barbados', 'BB', 'Barbados Dollar', 'BBD', '/flags/barbados.png', NULL),
(19, 'Bangladesh', 'BD', 'Taka', 'BDT', '/flags/bangladesh.png', NULL),
(20, 'Belgium', 'BE', 'Euro', 'EUR', '/flags/belgium.png', NULL),
(21, 'Burkina Faso', 'BF', 'CFA Franc BCEAO', 'XOF', '/flags/burkina-faso.png', NULL),
(22, 'Bulgaria', 'BG', 'Lev', 'BGL', '/flags/bulgaria.png', NULL),
(23, 'Bahrain', 'BH', 'Bahraini Dinar', 'BHD', '/flags/bahrain.png', NULL),
(24, 'Burundi', 'BI', 'Burundi Franc', 'BIF', '/flags/burundi.png', NULL),
(25, 'Benin', 'BJ', 'CFA Franc BCEAO', 'XOF', '/flags/benin.png', NULL),
(26, 'Bermuda', 'BM', 'Bermudian Dollar', 'BMD', '/flags/bermuda.png', NULL),
(27, 'Brunei Darussalam', 'BN', 'Brunei Dollar', 'BND', '/flags/brunei-darussalam.png', NULL),
(28, 'Bolivia', 'BO', 'Boliviano', 'BOB', '/flags/bolivia.png', NULL),
(29, 'Brazil', 'BR', 'Brazilian Real', 'BRL', '/flags/brazil.png', NULL),
(30, 'The Bahamas', 'BS', 'Bahamian Dollar', 'BSD', '/flags/the-bahamas.png', NULL),
(31, 'Bhutan', 'BT', 'Ngultrum', 'BTN', '/flags/bhutan.png', NULL),
(32, 'Bouvet Island', 'BV', 'Norwegian Krone', 'NOK', '/flags/bouvet-island.png', NULL),
(33, 'Botswana', 'BW', 'Pula', 'BWP', '/flags/botswana.png', NULL),
(34, 'Belarus', 'BY', 'Belarussian Ruble', 'BYN', '/flags/belarus.png', NULL),
(35, 'Belize', 'BZ', 'Belize Dollar', 'BZD', '/flags/belize.png', NULL),
(36, 'Canada', 'CA', 'Canadian Dollar', 'CAD', '/flags/canada.png', NULL),
(37, 'Cocos (Keeling) Islands', 'CC', 'Australian Dollar', 'AUD', '/flags/cocos-(keeling)-islands.png', NULL),
(39, 'Central African Republic', 'CF', 'CFA Franc BEAC', 'XAF', '/flags/central-african-republic.png', NULL),
(41, 'Switzerland', 'CH', 'Swiss Franc', 'CHF', '/flags/switzerland.png', NULL),
(42, 'Cote d\'Ivoire', 'CI', 'CFA Franc BCEAO', 'XOF', '/flags/cote-d\'ivoire.png', NULL),
(43, 'Cook Islands', 'CK', 'New Zealand Dollar', 'NZD', '/flags/cook-islands.png', NULL),
(44, 'Chile', 'CL', 'Chilean Peso', 'CLP', '/flags/chile.png', NULL),
(45, 'Cameroon', 'CM', 'CFA Franc BEAC', 'XAF', '/flags/cameroon.png', NULL),
(46, 'China', 'CN', 'Yuan Renminbi', 'CNY', '/flags/china.png', NULL),
(47, 'Colombia', 'CO', 'Colombian Peso', 'COP', '/flags/colombia.png', NULL),
(48, 'Costa Rica', 'CR', 'Costa Rican Colon', 'CRC', '/flags/costa-rica.png', NULL),
(49, 'Cuba', 'CU', 'Cuban Peso', 'CUP', '/flags/cuba.png', NULL),
(50, 'Cape Verde', 'CV', 'Cape Verdean Escudo', 'CVE', '/flags/cape-verde.png', NULL),
(51, 'Christmas Island', 'CX', 'Australian Dollar', 'AUD', '/flags/christmas-island.png', NULL),
(52, 'Cyprus', 'CY', 'Cyprus Pound', 'CYP', '/flags/cyprus.png', NULL),
(53, 'Czech Republic', 'CZ', 'Czech Koruna', 'CZK', '/flags/czech-republic.png', NULL),
(54, 'Germany', 'DE', 'Euro', 'EUR', '/flags/germany.png', NULL),
(55, 'Djibouti', 'DJ', 'Djibouti Franc', 'DJF', '/flags/djibouti.png', NULL),
(56, 'Denmark', 'DK', 'Danish Krone', 'DKK', '/flags/denmark.png', NULL),
(57, 'Dominica', 'DM', 'East Caribbean Dollar', 'XCD', '/flags/dominica.png', NULL),
(58, 'Dominican Republic', 'DO', 'Dominican Peso', 'DOP', '/flags/dominican-republic.png', NULL),
(59, 'Algeria', 'DZ', 'Algerian Dinar', 'DZD', '/flags/algeria.png', NULL),
(60, 'Ecuador', 'EC', 'US dollar', 'USD', '/flags/ecuador.png', NULL),
(61, 'Estonia', 'EE', 'Kroon', 'EEK', '/flags/estonia.png', NULL),
(62, 'Egypt', 'EG', 'Egyptian Pound', 'EGP', '/flags/egypt.png', NULL),
(63, 'Western Sahara', 'EH', 'Moroccan Dirham', 'MAD', '/flags/western-sahara.png', NULL),
(64, 'Eritrea', 'ER', 'Nakfa', 'ERN', '/flags/eritrea.png', NULL),
(65, 'Spain', 'ES', 'Euro', 'EUR', '/flags/spain.png', NULL),
(66, 'Ethiopia', 'ET', 'Ethiopian Birr', 'ETB', '/flags/ethiopia.png', NULL),
(67, 'Finland', 'FI', 'Euro', 'EUR', '/flags/finland.png', NULL),
(68, 'Fiji', 'FJ', 'Fijian Dollar', 'FJD', '/flags/fiji.png', NULL),
(69, 'Falkland Islands (Islas Malvinas)', 'FK', 'Falkland Islands Pound', 'FKP', '/flags/falkland-islands-(islas-malvinas).png', NULL),
(71, 'Faroe Islands', 'FO', 'Danish Krone', 'DKK', '/flags/faroe-islands.png', NULL),
(72, 'France', 'FR', 'Euro', 'EUR', '/flags/france.png', NULL),
(74, 'Gabon', 'GA', 'CFA Franc BEAC', 'XAF', '/flags/gabon.png', NULL),
(75, 'Grenada', 'GD', 'East Caribbean Dollar', 'XCD', '/flags/grenada.png', NULL),
(76, 'Georgia', 'GE', 'Lari', 'GEL', '/flags/georgia.png', NULL),
(77, 'French Guiana', 'GF', 'Euro', 'EUR', '/flags/french-guiana.png', NULL),
(78, 'Guernsey', 'GG', 'Pound Sterling', 'GBP', '/flags/guernsey.png', NULL),
(79, 'Ghana', 'GH', 'Cedi', 'GHC', '/flags/ghana.png', NULL),
(80, 'Gibraltar', 'GI', 'Gibraltar Pound', 'GIP', '/flags/gibraltar.png', NULL),
(81, 'Greenland', 'GL', 'Danish Krone', 'DKK', '/flags/greenland.png', NULL),
(82, 'The Gambia', 'GM', 'Dalasi', 'GMD', '/flags/the-gambia.png', NULL),
(83, 'Guinea', 'GN', 'Guinean Franc', 'GNF', '/flags/guinea.png', NULL),
(84, 'Guadeloupe', 'GP', 'Euro', 'EUR', '/flags/guadeloupe.png', NULL),
(85, 'Equatorial Guinea', 'GQ', 'CFA Franc BEAC', 'XAF', '/flags/equatorial-guinea.png', NULL),
(86, 'Greece', 'GR', 'Euro', 'EUR', '/flags/greece.png', NULL),
(87, 'South Georgia and the South Sandwich Islands', 'GS', 'Pound Sterling', 'GBP', '/flags/south-georgia-and-the-south-sandwich-islands.png', NULL),
(88, 'Guatemala', 'GT', 'Quetzal', 'GTQ', '/flags/guatemala.png', NULL),
(89, 'Guam', 'GU', 'US Dollar', 'USD', '/flags/guam.png', NULL),
(90, 'Guinea-Bissau', 'GW', 'CFA Franc BCEAO', 'XOF', '/flags/guinea-bissau.png', NULL),
(91, 'Guyana', 'GY', 'Guyana Dollar', 'GYD', '/flags/guyana.png', NULL),
(92, 'Hong Kong (SAR)', 'HK', 'Hong Kong Dollar', 'HKD', '/flags/hong-kong-(sar).png', NULL),
(93, 'Heard Island and McDonald Islands', 'HM', 'Australian Dollar', 'AUD', '/flags/heard-island-and-mcdonald-islands.png', NULL),
(94, 'Honduras', 'HN', 'Lempira', 'HNL', '/flags/honduras.png', NULL),
(95, 'Croatia', 'HR', 'Kuna', 'HRK', '/flags/croatia.png', NULL),
(96, 'Haiti', 'HT', 'Gourde', 'HTG', '/flags/haiti.png', NULL),
(97, 'Hungary', 'HU', 'Forint', 'HUF', '/flags/hungary.png', NULL),
(98, 'Indonesia', 'ID', 'Rupiah', 'IDR', '/flags/indonesia.png', NULL),
(99, 'Ireland', 'IE', 'Euro', 'EUR', '/flags/ireland.png', NULL),
(100, 'Israel', 'IL', 'New Israeli Sheqel', 'ILS', '/flags/israel.png', NULL),
(102, 'India', 'IN', 'Indian Rupee', 'INR', '/flags/india.png', NULL),
(103, 'British Indian Ocean Territory', 'IO', 'US Dollar', 'USD', '/flags/british-indian-ocean-territory.png', NULL),
(104, 'Iraq', 'IQ', 'Iraqi Dinar', 'IQD', '/flags/iraq.png', NULL),
(105, 'Iran', 'IR', 'Iranian Rial', 'IRR', '/flags/iran.png', NULL),
(106, 'Iceland', 'IS', 'Iceland Krona', 'ISK', '/flags/iceland.png', NULL),
(107, 'Italy', 'IT', 'Euro', 'EUR', '/flags/italy.png', NULL),
(108, 'Jersey', 'JE', 'Pound Sterling', 'GBP', '/flags/jersey.png', NULL),
(109, 'Jamaica', 'JM', 'Jamaican dollar', 'JMD', '/flags/jamaica.png', NULL),
(110, 'Jordan', 'JO', 'Jordanian Dinar', 'JOD', '/flags/jordan.png', NULL),
(111, 'Japan', 'JP', 'Yen', 'JPY', '/flags/japan.png', NULL),
(112, 'Kenya', 'KE', 'Kenyan shilling', 'KES', '/flags/kenya.png', NULL),
(113, 'Kyrgyzstan', 'KG', 'Som', 'KGS', '/flags/kyrgyzstan.png', NULL),
(114, 'Cambodia', 'KH', 'Riel', 'KHR', '/flags/cambodia.png', NULL),
(115, 'Kiribati', 'KI', 'Australian dollar', 'AUD', '/flags/kiribati.png', NULL),
(116, 'Comoros', 'KM', 'Comoro Franc', 'KMF', '/flags/comoros.png', NULL),
(117, 'Saint Kitts and Nevis', 'KN', 'East Caribbean Dollar', 'XCD', '/flags/saint-kitts-and-nevis.png', NULL),
(118, 'Korea North', 'KP', 'North Korean Won', 'KPW', '/flags/korea-north.png', NULL),
(119, 'Korea South', 'KR', 'Won', 'KRW', '/flags/korea-south.png', NULL),
(120, 'Kuwait', 'KW', 'Kuwaiti Dinar', 'KWD', '/flags/kuwait.png', NULL),
(121, 'Cayman Islands', 'KY', 'Cayman Islands Dollar', 'KYD', '/flags/cayman-islands.png', NULL),
(122, 'Kazakhstan', 'KZ', 'Tenge', 'KZT', '/flags/kazakhstan.png', NULL),
(123, 'Laos', 'LA', 'Kip', 'LAK', '/flags/laos.png', NULL),
(124, 'Lebanon', 'LB', 'Lebanese Pound', 'LBP', '/flags/lebanon.png', NULL),
(125, 'Saint Lucia', 'LC', 'East Caribbean Dollar', 'XCD', '/flags/saint-lucia.png', NULL),
(126, 'Liechtenstein', 'LI', 'Swiss Franc', 'CHF', '/flags/liechtenstein.png', NULL),
(127, 'Sri Lanka', 'LK', 'Sri Lanka Rupee', 'LKR', '/flags/sri-lanka.png', NULL),
(128, 'Liberia', 'LR', 'Liberian Dollar', 'LRD', '/flags/liberia.png', NULL),
(129, 'Lesotho', 'LS', 'Loti', 'LSL', '/flags/lesotho.png', NULL),
(130, 'Lithuania', 'LT', 'Lithuanian Litas', 'LTL', '/flags/lithuania.png', NULL),
(131, 'Luxembourg', 'LU', 'Euro', 'EUR', '/flags/luxembourg.png', NULL),
(132, 'Latvia', 'LV', 'Latvian Lats', 'LVL', '/flags/latvia.png', NULL),
(133, 'Libya', 'LY', 'Libyan Dinar', 'LYD', '/flags/libya.png', NULL),
(134, 'Morocco', 'MA', 'Moroccan Dirham', 'MAD', '/flags/morocco.png', NULL),
(135, 'Monaco', 'MC', 'Euro', 'EUR', '/flags/monaco.png', NULL),
(136, 'Moldova', 'MD', 'Moldovan Leu', 'MDL', '/flags/moldova.png', NULL),
(137, 'Madagascar', 'MG', 'Malagasy Franc', 'MGF', '/flags/madagascar.png', NULL),
(138, 'Marshall Islands', 'MH', 'US dollar', 'USD', '/flags/marshall-islands.png', NULL),
(140, 'Mali', 'ML', 'CFA Franc BCEAO', 'XOF', '/flags/mali.png', NULL),
(141, 'Burma', 'MM', 'kyat', 'MMK', '/flags/burma.png', NULL),
(142, 'Mongolia', 'MN', 'Tugrik', 'MNT', '/flags/mongolia.png', NULL),
(143, 'Macao', 'MO', 'Pataca', 'MOP', '/flags/macao.png', NULL),
(144, 'Northern Mariana Islands', 'MP', 'US Dollar', 'USD', '/flags/northern-mariana-islands.png', NULL),
(145, 'Martinique', 'MQ', 'Euro', 'EUR', '/flags/martinique.png', NULL),
(146, 'Mauritania', 'MR', 'Ouguiya', 'MRO', '/flags/mauritania.png', NULL),
(147, 'Montserrat', 'MS', 'East Caribbean Dollar', 'XCD', '/flags/montserrat.png', NULL),
(148, 'Malta', 'MT', 'Maltese Lira', 'MTL', '/flags/malta.png', NULL),
(149, 'Mauritius', 'MU', 'Mauritius Rupee', 'MUR', '/flags/mauritius.png', NULL),
(150, 'Maldives', 'MV', 'Rufiyaa', 'MVR', '/flags/maldives.png', NULL),
(151, 'Malawi', 'MW', 'Kwacha', 'MWK', '/flags/malawi.png', NULL),
(152, 'Mexico', 'MX', 'Mexican Peso', 'MXN', '/flags/mexico.png', NULL),
(153, 'Malaysia', 'MY', 'Malaysian Ringgit', 'MYR', '/flags/malaysia.png', NULL),
(154, 'Mozambique', 'MZ', 'Metical', 'MZM', '/flags/mozambique.png', NULL),
(155, 'Namibia', 'NA', 'Namibian Dollar', 'NAD', '/flags/namibia.png', NULL),
(156, 'New Caledonia', 'NC', 'CFP Franc', 'XPF', '/flags/new-caledonia.png', NULL),
(157, 'Niger', 'NE', 'CFA Franc BCEAO', 'XOF', '/flags/niger.png', NULL),
(158, 'Norfolk Island', 'NF', 'Australian Dollar', 'AUD', '/flags/norfolk-island.png', NULL),
(159, 'Nigeria', 'NG', 'Naira', 'NGN', '/flags/nigeria.png', NULL),
(160, 'Nicaragua', 'NI', 'Cordoba Oro', 'NIO', '/flags/nicaragua.png', NULL),
(161, 'Netherlands', 'NL', 'Euro', 'EUR', '/flags/netherlands.png', NULL),
(162, 'Norway', 'NO', 'Norwegian Krone', 'NOK', '/flags/norway.png', NULL),
(163, 'Nepal', 'NP', 'Nepalese Rupee', 'NPR', '/flags/nepal.png', NULL),
(164, 'Nauru', 'NR', 'Australian Dollar', 'AUD', '/flags/nauru.png', NULL),
(165, 'Niue', 'NU', 'New Zealand Dollar', 'NZD', '/flags/niue.png', NULL),
(166, 'New Zealand', 'NZ', 'New Zealand Dollar', 'NZD', '/flags/new-zealand.png', NULL),
(167, 'Oman', 'OM', 'Rial Omani', 'OMR', '/flags/oman.png', NULL),
(168, 'Panama', 'PA', 'balboa', 'PAB', '/flags/panama.png', NULL),
(169, 'Peru', 'PE', 'Nuevo Sol', 'PEN', '/flags/peru.png', NULL),
(170, 'French Polynesia', 'PF', 'CFP Franc', 'XPF', '/flags/french-polynesia.png', NULL),
(171, 'Papua New Guinea', 'PG', 'Kina', 'PGK', '/flags/papua-new-guinea.png', NULL),
(172, 'Philippines', 'PH', 'Philippine Peso', 'PHP', '/flags/philippines.png', NULL),
(173, 'Pakistan', 'PK', 'Pakistan Rupee', 'PKR', '/flags/pakistan.png', NULL),
(174, 'Poland', 'PL', 'Zloty', 'PLN', '/flags/poland.png', NULL),
(175, 'Saint Pierre and Miquelon', 'PM', 'Euro', 'EUR', '/flags/saint-pierre-and-miquelon.png', NULL),
(176, 'Pitcairn Islands', 'PN', 'New Zealand Dollar', 'NZD', '/flags/pitcairn-islands.png', NULL),
(177, 'Puerto Rico', 'PR', 'US dollar', 'USD', '/flags/puerto-rico.png', NULL),
(179, 'Portugal', 'PT', 'Euro', 'EUR', '/flags/portugal.png', NULL),
(180, 'Palau', 'PW', 'US dollar', 'USD', '/flags/palau.png', NULL),
(181, 'Paraguay', 'PY', 'Guarani', 'PYG', '/flags/paraguay.png', NULL),
(182, 'Qatar', 'QA', 'Qatari Rial', 'QAR', '/flags/qatar.png', NULL),
(184, 'Romania', 'RO', 'Leu', 'RON', '/flags/romania.png', NULL),
(185, 'Russia', 'RU', 'Russian Ruble', 'RUB', '/flags/russia.png', NULL),
(186, 'Rwanda', 'RW', 'Rwanda Franc', 'RWF', '/flags/rwanda.png', NULL),
(187, 'Saudi Arabia', 'SA', 'Saudi Riyal', 'SAR', '/flags/saudi-arabia.png', NULL),
(188, 'Solomon Islands', 'SB', 'Solomon Islands Dollar', 'SBD', '/flags/solomon-islands.png', NULL),
(189, 'Seychelles', 'SC', 'Seychelles Rupee', 'SCR', '/flags/seychelles.png', NULL),
(190, 'Sudan', 'SD', 'Sudanese Dinar', 'SDD', '/flags/sudan.png', NULL),
(191, 'Sweden', 'SE', 'Swedish Krona', 'SEK', '/flags/sweden.png', NULL),
(192, 'Singapore', 'SG', 'Singapore Dollar', 'SGD', '/flags/singapore.png', NULL),
(193, 'Saint Helena', 'SH', 'Saint Helenian Pound', 'SHP', '/flags/saint-helena.png', NULL),
(194, 'Slovenia', 'SI', 'Tolar', 'SIT', '/flags/slovenia.png', NULL),
(195, 'Svalbard', 'SJ', 'Norwegian Krone', 'NOK', '/flags/svalbard.png', NULL),
(196, 'Slovakia', 'SK', 'Slovak Koruna', 'SKK', '/flags/slovakia.png', NULL),
(197, 'Sierra Leone', 'SL', 'Leone', 'SLL', '/flags/sierra-leone.png', NULL),
(198, 'San Marino', 'SM', 'Euro', 'EUR', '/flags/san-marino.png', NULL),
(199, 'Senegal', 'SN', 'CFA Franc BCEAO', 'XOF', '/flags/senegal.png', NULL),
(200, 'Somalia', 'SO', 'Somali Shilling', 'SOS', '/flags/somalia.png', NULL),
(201, 'Suriname', 'SR', 'Suriname Guilder', 'SRG', '/flags/suriname.png', NULL),
(203, 'El Salvador', 'SV', 'El Salvador Colon', 'SVC', '/flags/el-salvador.png', NULL),
(204, 'Syria', 'SY', 'Syrian Pound', 'SYP', '/flags/syria.png', NULL),
(205, 'Swaziland', 'SZ', 'Lilangeni', 'SZL', '/flags/swaziland.png', NULL),
(206, 'Turks and Caicos Islands', 'TC', 'US Dollar', 'USD', '/flags/turks-and-caicos-islands.png', NULL),
(207, 'Chad', 'TD', 'CFA Franc BEAC', 'XAF', '/flags/chad.png', NULL),
(208, 'French Southern and Antarctic Lands', 'TF', 'Euro', 'EUR', '/flags/french-southern-and-antarctic-lands.png', NULL),
(209, 'Togo', 'TG', 'CFA Franc BCEAO', 'XOF', '/flags/togo.png', NULL),
(210, 'Thailand', 'TH', 'Baht', 'THB', '/flags/thailand.png', NULL),
(211, 'Tajikistan', 'TJ', 'Somoni', 'TJS', '/flags/tajikistan.png', NULL),
(212, 'Tokelau', 'TK', 'New Zealand Dollar', 'NZD', '/flags/tokelau.png', NULL),
(213, 'Turkmenistan', 'TM', 'Manat', 'TMM', '/flags/turkmenistan.png', NULL),
(214, 'Tunisia', 'TN', 'Tunisian Dinar', 'TND', '/flags/tunisia.png', NULL),
(215, 'Tonga', 'TO', 'Pa\'anga', 'TOP', '/flags/tonga.png', NULL),
(216, 'East Timor', 'TL', 'Timor Escudo', 'TPE', '/flags/east-timor.png', NULL),
(217, 'Turkey', 'TR', 'Turkish Lira', 'TRL', '/flags/turkey.png', NULL),
(218, 'Trinidad and Tobago', 'TT', 'Trinidad and Tobago Dollar', 'TTD', '/flags/trinidad-and-tobago.png', NULL),
(219, 'Tuvalu', 'TV', 'Australian Dollar', 'AUD', '/flags/tuvalu.png', NULL),
(220, 'Taiwan', 'TW', 'New Taiwan Dollar', 'TWD', '/flags/taiwan.png', NULL),
(221, 'Tanzania', 'TZ', 'Tanzanian Shilling', 'TZS', '/flags/tanzania.png', NULL),
(222, 'Ukraine', 'UA', 'Hryvnia', 'UAH', '/flags/ukraine.png', NULL),
(223, 'Uganda', 'UG', 'Uganda Shilling', 'UGX', '/flags/uganda.png', NULL),
(224, 'United Kingdom', 'GB', 'Pound Sterling', 'GBP', '/flags/united-kingdom.png', NULL),
(225, 'United States Minor Outlying Islands', 'UM', 'US Dollar', 'USD', '/flags/united-states-minor-outlying-islands.png', NULL),
(226, 'United States', 'US', 'US Dollar', 'USD', '/flags/united-states.png', NULL),
(227, 'Uruguay', 'UY', 'Peso Uruguayo', 'UYU', '/flags/uruguay.png', NULL),
(228, 'Uzbekistan', 'UZ', 'Uzbekistan Sum', 'UZS', '/flags/uzbekistan.png', NULL),
(229, 'Holy See (Vatican City)', 'VA', 'Euro', 'EUR', '/flags/holy-see-(vatican-city).png', NULL),
(230, 'Saint Vincent and the Grenadines', 'VC', 'East Caribbean Dollar', 'XCD', '/flags/saint-vincent-and-the-grenadines.png', NULL),
(231, 'Venezuela', 'VE', 'Bolivar', 'VEB', '/flags/venezuela.png', NULL),
(232, 'British Virgin Islands', 'VG', 'US dollar', 'USD', '/flags/british-virgin-islands.png', NULL),
(233, 'Virgin Islands', 'VI', 'US Dollar', 'USD', '/flags/virgin-islands.png', NULL),
(234, 'Vietnam', 'VN', 'Dong', 'VND', '/flags/vietnam.png', NULL),
(235, 'Vanuatu', 'VU', 'Vatu', 'VUV', '/flags/vanuatu.png', NULL),
(236, 'Wallis and Futuna', 'WF', 'CFP Franc', 'XPF', '/flags/wallis-and-futuna.png', NULL),
(237, 'Samoa', 'WS', 'Tala', 'WST', '/flags/samoa.png', NULL),
(238, 'Yemen', 'YE', 'Yemeni Rial', 'YER', '/flags/yemen.png', NULL),
(239, 'Mayotte', 'YT', 'Euro', 'EUR', '/flags/mayotte.png', NULL),
(240, 'Yugoslavia', 'YU', 'Yugoslavian Dinar', 'YUM', '/flags/yugoslavia.png', NULL),
(241, 'South Africa', 'ZA', 'Rand', 'ZAR', '/flags/south-africa.png', NULL),
(242, 'Zambia', 'ZM', 'Kwacha', 'ZMK', '/flags/zambia.png', NULL),
(243, 'Zimbabwe', 'ZW', 'Zimbabwe Dollar', 'ZWD', '/flags/zimbabwe.png', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_currencies`
--

CREATE TABLE `joseb_jbusinessdirectory_currencies` (
  `currency_id` int(10) NOT NULL,
  `currency_name` char(10) NOT NULL,
  `currency_description` varchar(70) DEFAULT NULL,
  `currency_symbol` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_currencies`
--

INSERT INTO `joseb_jbusinessdirectory_currencies` (`currency_id`, `currency_name`, `currency_description`, `currency_symbol`) VALUES
(2, 'AED', 'UAE Dirham', '#'),
(3, 'AFN', 'Afghani', '?'),
(4, 'ALL', 'Lek', 'Lek'),
(5, 'AMD', 'Armenian Dram', '#'),
(6, 'ANG', 'Netherlands Antillian Guilder', 'f'),
(7, 'AOA', 'Kwanza', '#'),
(8, 'ARS', 'Argentine Peso', '$'),
(9, 'AUD', 'Australian Dollar', '$'),
(10, 'AWG', 'Aruban Guilder', 'f'),
(11, 'AZN', 'Azerbaijanian Manat', '???'),
(12, 'BAM', 'Convertible Marks', 'KM'),
(13, 'BBD', 'Barbados Dollar', '$'),
(14, 'BDT', 'Taka', '#'),
(15, 'BGN', 'Bulgarian Lev', '??'),
(16, 'BHD', 'Bahraini Dinar', '#'),
(17, 'BIF', 'Burundi Franc', '#'),
(18, 'BMD', 'Bermudian Dollar (customarily known as Bermuda Dollar)', '$'),
(19, 'BND', 'Brunei Dollar', '$'),
(20, 'BOB BOV', 'Boliviano Mvdol', '$b'),
(21, 'BRL', 'Brazilian Real', 'R$'),
(22, 'BSD', 'Bahamian Dollar', '$'),
(23, 'BWP', 'Pula', 'P'),
(24, 'BYN', 'Belarussian Ruble', 'p.'),
(25, 'BZD', 'Belize Dollar', 'BZ$'),
(26, 'CAD', 'Canadian Dollar', '$'),
(27, 'CDF', 'Congolese Franc', '#'),
(28, 'CHF', 'Swiss Franc', 'CHF'),
(29, 'CLP CLF', 'Chilean Peso Unidades de fomento', '$'),
(30, 'CNY', 'Yuan Renminbi', 'Y'),
(31, 'COP COU', 'Colombian Peso Unidad de Valor Real', '$'),
(32, 'CRC', 'Costa Rican Colon', '?'),
(33, 'CUP CUC', 'Cuban Peso Peso Convertible', '?'),
(34, 'CVE', 'Cape Verde Escudo', '#'),
(35, 'CZK', 'Czech Koruna', 'Kč'),
(36, 'DJF', 'Djibouti Franc', '#'),
(37, 'DKK', 'Danish Krone', 'kr'),
(38, 'DOP', 'Dominican Peso', 'RD$'),
(39, 'DZD', 'Algerian Dinar', '#'),
(40, 'EEK', 'Kroon', '#'),
(41, 'EGP', 'Egyptian Pound', 'E£'),
(42, 'ERN', 'Nakfa', '#'),
(43, 'ETB', 'Ethiopian Birr', '#'),
(44, 'EUR', 'Euro', '€'),
(45, 'FJD', 'Fiji Dollar', '$'),
(46, 'FKP', 'Falkland Islands Pound', '£'),
(47, 'GBP', 'Pound Sterling', '£'),
(48, 'GEL', 'Lari', '#'),
(49, 'GHS', 'Cedi', '#'),
(50, 'GIP', 'Gibraltar Pound', '£'),
(51, 'GMD', 'Dalasi', '#'),
(52, 'GNF', 'Guinea Franc', '#'),
(53, 'GTQ', 'Quetzal', 'Q'),
(54, 'GYD', 'Guyana Dollar', '$'),
(55, 'HKD', 'Hong Kong Dollar', '$'),
(56, 'HNL', 'Lempira', 'L'),
(57, 'HRK', 'Croatian Kuna', 'kn'),
(58, 'HTG USD', 'Gourde US Dollar', '$'),
(59, 'HUF', 'Forint', 'Ft'),
(60, 'IDR', 'Rupiah', 'Rp'),
(61, 'ILS', 'New Israeli Sheqel', '?'),
(62, 'INR', 'Indian Rupee', '#'),
(63, 'INR BTN', 'Indian Rupee Ngultrum', '#'),
(64, 'IQD', 'Iraqi Dinar', '#'),
(65, 'IRR', 'Iranian Rial', '?'),
(66, 'ISK', 'Iceland Krona', 'kr'),
(67, 'JMD', 'Jamaican Dollar', 'J$'),
(68, 'JOD', 'Jordanian Dinar', '#'),
(69, 'JPY', 'Yen', 'Y'),
(70, 'KES', 'Kenyan Shilling', '#'),
(71, 'KGS', 'Som', '??'),
(72, 'KHR', 'Riel', '?'),
(73, 'KMF', 'Comoro Franc', '#'),
(74, 'KPW', 'North Korean Won', '?'),
(75, 'KRW', 'Won', '?'),
(76, 'KWD', 'Kuwaiti Dinar', '#'),
(77, 'KYD', 'Cayman Islands Dollar', '$'),
(78, 'KZT', 'Tenge', '??'),
(79, 'LAK', 'Kip', '?'),
(80, 'LBP', 'Lebanese Pound', 'L'),
(81, 'LKR', 'Sri Lanka Rupee', '?'),
(82, 'LRD', 'Liberian Dollar', '$'),
(83, 'LTL', 'Lithuanian Litas', 'Lt'),
(84, 'LVL', 'Latvian Lats', 'Ls'),
(85, 'LYD', 'Libyan Dinar', '#'),
(86, 'MAD', 'Moroccan Dirham', '#'),
(87, 'MDL', 'Moldovan Leu', '#'),
(88, 'MGA', 'Malagasy Ariary', '#'),
(89, 'MKD', 'Denar', '???'),
(90, 'MMK', 'Kyat', '#'),
(91, 'MNT', 'Tugrik', '?'),
(92, 'MOP', 'Pataca', '#'),
(93, 'MRO', 'Ouguiya', '#'),
(94, 'MUR', 'Mauritius Rupee', '?'),
(95, 'MVR', 'Rufiyaa', '#'),
(96, 'MWK', 'Kwacha', '#'),
(97, 'MXN MXV', 'Mexican Peso Mexican Unidad de Inversion (UDI)', '$'),
(98, 'MYR', 'Malaysian Ringgit', 'RM'),
(99, 'MZN', 'Metical', 'MT'),
(100, 'NGN', 'Naira', '?'),
(101, 'NIO', 'Cordoba Oro', 'C$'),
(102, 'NOK', 'Norwegian Krone', 'kr'),
(103, 'NPR', 'Nepalese Rupee', '?'),
(104, 'NZD', 'New Zealand Dollar', '$'),
(105, 'OMR', 'Rial Omani', '?'),
(106, 'PAB USD', 'Balboa US Dollar', 'B/.'),
(107, 'PEN', 'Nuevo Sol', 'S/.'),
(108, 'PGK', 'Kina', '#'),
(109, 'PHP', 'Philippine Peso', 'Php'),
(110, 'PKR', 'Pakistan Rupee', '?'),
(111, 'PLN', 'Zloty', 'zł'),
(112, 'PYG', 'Guarani', 'Gs'),
(113, 'QAR', 'Qatari Rial', '?'),
(114, 'RON', 'New Leu', 'lei'),
(115, 'RSD', 'Serbian Dinar', '???.'),
(116, 'RUB', 'Russian Ruble', '???'),
(117, 'RWF', 'Rwanda Franc', '#'),
(118, 'SAR', 'Saudi Riyal', '?'),
(119, 'SBD', 'Solomon Islands Dollar', '$'),
(120, 'SCR', 'Seychelles Rupee', '?'),
(121, 'SDG', 'Sudanese Pound', '#'),
(122, 'SEK', 'Swedish Krona', 'kr'),
(123, 'SGD', 'Singapore Dollar', '$'),
(124, 'SHP', 'Saint Helena Pound', 'L'),
(125, 'SLL', 'Leone', '#'),
(126, 'SOS', 'Somali Shilling', 'S'),
(127, 'SRD', 'Surinam Dollar', '$'),
(128, 'STD', 'Dobra', '#'),
(129, 'SVC USD', 'El Salvador Colon US Dollar', '$'),
(130, 'SYP', 'Syrian Pound', 'L'),
(131, 'SZL', 'Lilangeni', '#'),
(132, 'THB', 'Baht', '?'),
(133, 'TJS', 'Somoni', '#'),
(134, 'TMT', 'Manat', '#'),
(135, 'TND', 'Tunisian Dinar', '#'),
(136, 'TOP', 'Pa\'anga', '#'),
(137, 'TRY', 'Turkish Lira', 'TL'),
(138, 'TTD', 'Trinidad and Tobago Dollar', 'TT$'),
(139, 'TWD', 'New Taiwan Dollar', 'NT$'),
(140, 'TZS', 'Tanzanian Shilling', '#'),
(141, 'UAH', 'Hryvnia', '?'),
(142, 'UGX', 'Uganda Shilling', '#'),
(143, 'USD', 'US Dollar', '$'),
(144, 'UYU UYI', 'Peso Uruguayo Uruguay Peso en Unidades Indexadas', '$U'),
(145, 'UZS', 'Uzbekistan Sum', '??'),
(146, 'VEF', 'Bolivar Fuerte', 'Bs'),
(147, 'VND', 'Dong', '?'),
(148, 'VUV', 'Vatu', '#'),
(149, 'WST', 'Tala', '#'),
(150, 'XAF', 'CFA Franc BEAC', '#'),
(151, 'XAG', 'Silver', '#'),
(152, 'XAU', 'Gold', '#'),
(153, 'XBA', 'Bond Markets Units European Composite Unit (EURCO)', '#'),
(154, 'XBB', 'European Monetary Unit (E.M.U.-6)', '#'),
(155, 'XBC', 'European Unit of Account 9(E.U.A.-9)', '#'),
(156, 'XBD', 'European Unit of Account 17(E.U.A.-17)', '#'),
(157, 'XCD', 'East Caribbean Dollar', '$'),
(158, 'XDR', 'SDR', '#'),
(159, 'XFU', 'UIC-Franc', '#'),
(160, 'XOF', 'CFA Franc BCEAO', '#'),
(161, 'XPD', 'Palladium', '#'),
(162, 'XPF', 'CFP Franc', '#'),
(163, 'XPT', 'Platinum', '#'),
(164, 'XTS', 'Codes specifically reserved for testing purposes', '#'),
(165, 'YER', 'Yemeni Rial', '?'),
(166, 'ZAR', 'Rand', 'R'),
(167, 'ZAR LSL', 'Rand Loti', '#'),
(168, 'ZAR NAD', 'Rand Namibia Dollar', '#'),
(169, 'ZMK', 'Zambian Kwacha', '#'),
(170, 'ZWL', 'Zimbabwe Dollar', '#');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_date_formats`
--

CREATE TABLE `joseb_jbusinessdirectory_date_formats` (
  `id` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `dateFormat` varchar(45) DEFAULT NULL,
  `calendarFormat` varchar(45) NOT NULL,
  `defaultDateValue` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_date_formats`
--

INSERT INTO `joseb_jbusinessdirectory_date_formats` (`id`, `name`, `dateFormat`, `calendarFormat`, `defaultDateValue`) VALUES
(1, 'y-m-d', 'Y-m-d', '%Y-%m-%d', '0000-00-00'),
(2, 'd-m-y', 'd-m-Y', '%d-%m-%Y', '00-00-0000'),
(3, 'm/d/y', 'm/d/Y', '%m/%d/%Y', '00-00-0000');

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_default_attributes`
--

CREATE TABLE `joseb_jbusinessdirectory_default_attributes` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `listing_config` tinyint(1) DEFAULT NULL,
  `offer_config` tinyint(1) DEFAULT NULL,
  `event_config` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_default_attributes`
--

INSERT INTO `joseb_jbusinessdirectory_default_attributes` (`id`, `name`, `listing_config`, `offer_config`, `event_config`) VALUES
(2, 'comercial_name', 3, -1, -1),
(3, 'tax_code', 3, -1, -1),
(4, 'registration_code', 3, -1, -1),
(5, 'website', 2, -1, -1),
(6, 'type', 2, 2, 2),
(7, 'slogan', 2, -1, -1),
(8, 'description', 1, 1, 1),
(9, 'keywords', 2, -1, -1),
(10, 'category', 1, 1, 1),
(11, 'logo', 1, -1, -1),
(12, 'street_number', 1, 1, 1),
(13, 'address', 1, 1, 1),
(14, 'city', 1, 1, 1),
(15, 'region', 1, 1, 1),
(16, 'country', 1, 1, 1),
(17, 'postal_code', 1, 1, 1),
(18, 'map', 1, 1, 1),
(20, 'phone', 1, -1, 1),
(21, 'mobile_phone', 2, -1, -1),
(22, 'fax', 3, -1, -1),
(23, 'email', 1, -1, 1),
(24, 'pictures', 2, 2, 2),
(25, 'video', 2, 2, 2),
(26, 'social_networks', 2, -1, -1),
(27, 'short_description', 2, 2, 2),
(28, 'contact_person', 2, -1, -1),
(29, 'attachments', 2, 2, 2),
(30, 'custom_tab', 2, -1, -1),
(31, 'cover_image', 2, -1, -1),
(32, 'opening_hours', 2, -1, -1),
(33, 'metadata_information', 2, 2, 2),
(34, 'publish_dates', 3, -1, -1),
(35, 'province', 2, 2, 2),
(36, 'area', 2, 2, 2),
(37, 'sounds', 2, 2, -1),
(38, 'establishment_year', 2, -1, -1),
(39, 'employees', 2, -1, -1),
(40, 'services_list', 2, -1, -1),
(41, 'testimonials', 2, -1, -1),
(42, 'ad_images', 3, -1, -1),
(43, 'price_text', -1, 2, -1),
(44, 'related_listing', 2, -1, -1),
(45, 'radius', 2, -1, -1),
(46, 'associated_listings', -1, -1, 2);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_directory_apps`
--

CREATE TABLE `joseb_jbusinessdirectory_directory_apps` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `app_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `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(4) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_directory_apps`
--

INSERT INTO `joseb_jbusinessdirectory_directory_apps` (`id`, `name`, `app_name`, `description`, `icon`, `store_link`, `doc_link`, `version`, `required_version`, `type`) VALUES
(1, 'JBD Appointments', 'JBD Appointments', 'Allows the possibility to define business services and book them online', 'directoryApps/service_booking.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-appointments', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-appointments', NULL, NULL, 1),
(2, 'JBD Event Bookings', 'JBD Event Bookings', 'Allows the possibility to create and book tickets for events', 'directoryApps/event_ticket_reservation.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-event-booking', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#event-booking', NULL, NULL, 1),
(3, 'JBD Event Appointments', 'JBD Event Appointments', 'Allows the possibility to define event appointments and book them online', 'directoryApps/event_appointment.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-event-appointments', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#event-appointment', NULL, NULL, 1),
(4, 'JBD Recurring Events', 'JBD Recurring Events', 'Allows the possibility to have recurring events', 'directoryApps/recurring_events.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-recurring-events', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-recurring-events', NULL, NULL, 1),
(5, 'JBD Sell Offers', 'JBD Sell Offers', 'Allows the possibility to sell offers online', 'directoryApps/offer_selling.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-sell-offers', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#offer-selling', NULL, NULL, 1),
(6, 'JBD Conference', 'JBD Conference', 'Adds the possibility of creating conferences, sessions and speakers', 'directoryApps/conference.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-conference', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-conference', NULL, NULL, 1),
(7, 'JBD Paypal Subscriptions', 'JBD PayPal Subscriptions', 'Provides the possibility of having PayPal subscriptions', 'directoryApps/paypal.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-paypal-subscriptions', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-paypal-subscriptions', NULL, NULL, 1),
(8, 'JBD Stripe', 'JBD Stripe', 'Provides the possibility to receive payments using Stripe payment gateway', 'directoryApps/stripe.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-stripe', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-stripe', NULL, NULL, 1),
(9, 'JBD Stripe Subscriptions', 'JBD Stripe Subscriptions', 'Enables the receiving of a recurring payment through Stripe Subscriptions', 'directoryApps/stripe_subscription.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-stripe-subscriptions', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-stripe-subscription', NULL, NULL, 1),
(10, 'J-CategoryBanners', 'J-CategoryBanners', 'Links Joomla banners with directory categories', 'directoryApps/j_category_banners.png', 'https://www.cmsjunkie.com/joomla-business-directory/j-categorybanners', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#j-categorybanners', NULL, NULL, 2),
(11, 'J-BusinessDirectory Content', 'J-BusinessDirectory Content', 'Allows the site administrator and the business owners to create articles that will be associated with business listings', 'directoryApps/jbd_content_plugin.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-content-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#j-businessdirectory-content-plugin', NULL, NULL, 2),
(12, 'JBD Payfast Subscriptions', 'JBD Payfast Subscriptions', 'Provides the possibility of having Payfast recurring payments.', 'directoryApps/payfastsubscription.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-payfast-subscriptions', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-payfast-subscription', NULL, NULL, 1),
(13, 'J-BusinessDirectory Maps', 'J-BusinessDirectory Maps', 'Joomla map module that displays business listing on a map', 'directoryApps/jbd_maps.png', 'https://www.cmsjunkie.com/j-businessdirectory-map-module', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-maps', NULL, NULL, 2),
(14, 'JBusinessDirectory - Locations', 'JBusinessDirectory - Locations', 'Joomla module that allows you to provide some quick links for your visitors, for the regions and the cities of your directory.', 'directoryApps/jbd_locations.png', 'https://www.cmsjunkie.com/j-businessdirectory-locations-module', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-locations', NULL, NULL, 2),
(15, 'JBusinessDirectory - Reviews', 'JBusinessDirectory - Reviews', 'Display reviews based on the selected criterias and options', 'directoryApps/jbd_reviews.png', 'https://www.cmsjunkie.com/j-businessdirectory-reviews', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-reviews', NULL, NULL, 2),
(16, 'Smart Search - Offers Finder', 'Smart Search - Offers Finder', 'Smart Search - finder plugin for indexing offers of J-BusinessDirectory extension.', 'directoryApps/jbd_finder_offers.png', 'https://www.cmsjunkie.com/j-businessdirectory-offer-finder-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-finder-offers', NULL, NULL, 2),
(17, 'Smart Search - Events Finder', 'Smart Search - Events Finder', 'Smart Search - finder plugin for indexing events of J-BusinessDirectory extension', 'directoryApps/jbd_finder_events.png', 'https://www.cmsjunkie.com/j-businessdirectory-events-finder-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-finder-events', NULL, NULL, 2),
(18, 'Smart Search - Business Listings Finder', 'Smart Search - Business Listings Finder', 'Smart Search - finder plugin for indexing busines listings of J-BusinessDirectory extension', 'directoryApps/jbd_finder_listings.png', 'https://www.cmsjunkie.com/j-businessdirectory-listing-finder-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-finder-listings', NULL, NULL, 2),
(19, 'JBusinessDirectory Offer Search', 'JBusinessDirectory Offer Search', 'Joomla! plugin which allows you to search for J-BusinessDirectory offers and categories with the Joomla Search component.', 'directoryApps/jbd_search_offers.png', 'https://www.cmsjunkie.com/j-businessdirectory-offers-search-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-search-offers', NULL, NULL, 2),
(20, 'JBusinessDirectory Event Search', 'JBusinessDirectory Event Search', 'Joomla! plugin which allows you to search for J-BusinessDirectory events and categories with the Joomla Search component.', 'directoryApps/jbd_search_events.png', 'https://www.cmsjunkie.com/j-businessdirectory-events-search-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-search-events', NULL, NULL, 2),
(21, 'JBusinessDirectory Listing Search', 'Search - Business Listings', 'Joomla! plugin which allows you to search for J-BusinessDirectory listings and categories with the Joomla Search component.', 'directoryApps/jbd_search_listings.png', 'https://www.cmsjunkie.com/j-businessdirectory-listing-search-plugin', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-search-listings', NULL, NULL, 2),
(22, 'JBD Campaigns', 'JBD Campaigns', 'Allows the possibility to create paid campaigns for businesses', 'directoryApps/jbd_campaigns.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-campaigns', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-campaigns', NULL, NULL, 1),
(23, 'JBD Authorize', 'JBD Authorize', 'Provides the possibility to receive payments using the Authorize.net payment gateway.', 'directoryApps/jbd_authorize.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-authorize', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-authorize', NULL, NULL, 1),
(24, 'JBD Authorize Subscriptions', 'JBD Authorize Subscriptions', 'Provides the possibility to receive recurring payments using the Authorize.net payment gateway.', 'directoryApps/jbd_authorize_subscriptions.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-authorize-subscription', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-authorize-subscription', NULL, NULL, 1),
(25, 'JBD Quote Requests', 'JBD Quote Requests', 'Allows users to request quotes about different categories to business owners', 'directoryApps/jbd_quote_requests.png', 'https://www.cmsjunkie.com/joomla-business-directory/jbd-quote-requests', 'https://www.cmsjunkie.com/docs/jbusinessdirectory/directoryapps.html#jbd-quote-requests', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_discounts`
--

CREATE TABLE `joseb_jbusinessdirectory_discounts` (
  `id` int(10) NOT NULL,
  `name` char(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `value` float(6,2) NOT NULL,
  `percent` tinyint(1) NOT NULL DEFAULT 0,
  `price_type` tinyint(1) NOT NULL DEFAULT 1,
  `package_ids` varchar(255) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT 1,
  `uses_per_coupon` int(11) DEFAULT NULL,
  `coupon_used` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `joseb_jbusinessdirectory_emails`
--

CREATE TABLE `joseb_jbusinessdirectory_emails` (
  `email_id` int(10) NOT NULL,
  `email_subject` char(255) NOT NULL,
  `email_name` char(255) NOT NULL,
  `email_type` varchar(255) NOT NULL,
  `email_content` blob NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `send_to_admin` tinyint(1) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `joseb_jbusinessdirectory_emails`
--

INSERT INTO `joseb_jbusinessdirectory_emails` (`email_id`, `email_subject`, `email_name`, `email_type`, `email_content`, `status`, `send_to_admin`) VALUES
(2, 'A new review has been posted for your business listing', 'Review Email', 'Review Email', 0x[encoded data, 4384 characters], 1, 1),
(3, 'Your review has received a response', 'Review Response Email', 'Review Response Email', 0x[encoded data, 4204 characters], 1, 1),
(4, 'Payment Receipt from [company_name]', 'Order E-mail', 'Order Email', 0x[encoded data, 5534 characters], 1, 1),
(5, 'You have been contacted for the company [business_name]', 'Contact E-Mail', 'Contact Email', 0x[encoded data, 4256 characters], 1, 1),
(6, 'A new review abuse was reported', 'Report Abuse', 'Report Abuse Email', 0x[encoded data, 4358 characters], 1, 1),
(7, 'Your business listing is about to expire', 'Expiration Notification', 'Expiration Notification Email', 0x[encoded data, 4290 characters], 1, 1),
(8, 'New Business Listing', 'New Business Listing Notification', 'New Company Notification Email', 0x[encoded data, 4868 characters], 1, 1),
(9, 'Your business listing was approved', 'Business Listing Approval', 'Approve Email', 0x[encoded data, 4344 characters], 1, 1),
(10, 'Payment details', 'Payment details', 'Payment Details Email', 0x[encoded data, 5666 characters], 1, 1),
(11, 'A new quote request was posted', 'Request Quote', 'Request Quote Email', 0x[encoded data, 4328 characters], 1, 1);
INSERT INTO `joseb_jbusinessdirectory_emails` (`email_id`, `email_subject`, `email_name`, `email_type`, `email_content`, `status`, `send_to_admin`) VALUES
(12, 'Your business was added on our directory', 'Listing creation notification', 'Listing Creation Notification', 0x[encoded data, 4850 characters], 1, 0),
(13, 'Your claim was approved', 'Positive claim response', 'Claim Response Email', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f205b637573746f6d65725f6e616d655d2c203c6272202f3e3c6272202f3e20436f6e67726174756c6174696f6e732c20796f757220636c61696d20666f72206c697374696e67205b636c61696d65645f636f6d70616e795f6e616d655d20686173206265656e20617070726f7665642e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 1),
(14, 'You claim was not approved', 'Negative claim response', 'Claim Negative Response Email', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f205b637573746f6d65725f6e616d655d2c203c6272202f3e3c6272202f3e20596f757220636c61696d20666f72206c697374696e67203c623e5b636c61696d65645f636f6d70616e795f6e616d655d3c2f623e20776173206e6f7420617070726f7665642e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 1),
(15, 'A new offer was added on your directory', 'Offer Creation', 'Offer Creation Notification', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f2c203c6272202f3e3c6272202f3e2041206e6577206f666665723c7374726f6e673e205b6f666665725f6e616d655d203c2f7374726f6e673e20686173206265656e206164646564206f6e20796f7572206469726563746f72792e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c703ec2a03c2f703e, 1, 1),
(16, 'Your new offer was  approved', 'Offer Approval', 'Offer Approval Notification', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f5b757365725f6e616d655d2c203c6272202f3e3c6272202f3e20596f7572206f66666572203c623e5b6f666665725f6e616d655d3c2f623e2077617320617070726f766564206279207468652061646d696e6973747261746f722e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 1),
(17, 'A new event has been added to your directory', 'Event Creation Notification', 'Event Creation Notification', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f2c203c6272202f3e3c6272202f3e2041206e6577206576656e74203c7374726f6e673e5b6576656e745f6e616d655d3c2f7374726f6e673e20686173206265656e206164646564206f6e20796f7572206469726563746f72792e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 1),
(18, 'Your new event was published', 'Event Approval Notificaiton', 'Event Approval Notification', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f5b757365725f6e616d655d2c203c6272202f3e3c6272202f3e20596f7572206576656e74203c623e5b6576656e745f6e616d655d3c2f623e2077617320617070726f766564206279207468652061646d696e6973747261746f722e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 1),
(19, 'Your booking details for [event_name]', 'Event Reservation Notification', 'Event Reservation Notification', 0x[encoded data, 5052 characters], 1, 1),
(20, 'Your ticket booking payment details for [event_name]', 'Event Payment Details', 'Event Payment Details', 0x[encoded data, 5342 characters], 1, 1),
(21, 'Your event is about to expire', 'Event Expiration Notification', 'Event Expiration Notification Email', 0x[encoded data, 4174 characters], 1, 0),
(22, 'Your offer is about to expire', 'Offer Expiration Notification', 'Offer Expiration Notification Email', 0x[encoded data, 4174 characters], 1, 0);
INSERT INTO `joseb_jbusinessdirectory_emails` (`email_id`, `email_subject`, `email_name`, `email_type`, `email_content`, `status`, `send_to_admin`) VALUES
(23, 'Report Notification', 'Report Notification', 'Report Notification', 0x[encoded data, 4164 characters], 1, 1),
(24, 'A business has been updated', 'Business Update Notification', 'Business Update Notification', 0x[encoded data, 4754 characters], 1, 1),
(25, 'A review on offer has received an response', 'Offer Review Response Email', 'Offer Review Response Email', 0x[encoded data, 4266 characters], 1, 1),
(26, 'A new review has been posted for an offer', 'Offer Review Email', 'Offer Review Email', 0x[encoded data, 4174 characters], 1, 1),
(27, 'A new abuse was reported for an offer', 'Report Abuse Offer Review', 'Report Abuse Offer Review', 0x[encoded data, 4414 characters], 1, 1),
(28, 'Your order nr. [offer_order_id] has been completed', 'Offer Order Notification', 'Offer Order Notification', 0x[encoded data, 4146 characters], 1, 1),
(29, 'You have been contacted for the event [event_name]', 'Event Contact Email', 'Event Contact Email', 0x[encoded data, 4234 characters], 1, 1),
(30, 'You have been contacted for the offer [offer_name]', 'Offer Contact Email', 'Offer Contact Email', 0x[encoded data, 4234 characters], 1, 1),
(31, 'You have reserved an appointment for [event_name] on [appointment_date]', 'Event Appointment Email', 'Event Appointment Email', 0x[encoded data, 4684 characters], 1, 1),
(32, 'Your appointment status has changed', 'Event Appointment Status Notification', 'Event Appointment Status Notification', 0x[encoded data, 4268 characters], 1, 1);
INSERT INTO `joseb_jbusinessdirectory_emails` (`email_id`, `email_subject`, `email_name`, `email_type`, `email_content`, `status`, `send_to_admin`) VALUES
(33, 'Monthly Statistical for your listing', 'Business Statistics Email', 'Business Statistics Email', 0x[encoded data, 8010 characters], 1, 0),
(34, 'Take advantage of new features for your business', 'Business Upgrade Notification', 'Business Upgrade Notification', 0x[encoded data, 4438 characters], 1, 0),
(35, 'Your appointment booking nr. [service_booking_id] has been completed', 'Service Booking Notification', 'Service Booking Notification', 0x[encoded data, 4326 characters], 1, 0),
(36, 'New companies have joined your event [event_name]', 'Company Association Notification', 'Company Association Notification', 0x[encoded data, 4122 characters], 1, 1),
(37, 'Your business [business_name] was disapproved', 'Business Listing Disapproval', 'Disapprove Email', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f5b757365725f6e616d655d2c203c6272202f3e3c6272202f3e20596f757220627573696e657373206c697374696e672077697468206e616d65203c7374726f6e673e5b627573696e6573735f6e616d655d3c2f7374726f6e673e20686173206265656e20646973617070726f766564206279207468652061646d696e6973747261746f722e3c6272202f3e3c6272202f3e205468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 0),
(38, 'Business [company_name] has been claimed.', 'Claim Request Email', 'Claim Request Email', 0x3c646976207374796c653d226d617267696e3a203070783b206261636b67726f756e642d636f6c6f723a20236634663366343b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20666f6e742d73697a653a20313270783b223e0d0a3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223463446334634223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d2270616464696e673a20313570783b223e3c63656e7465723e0d0a3c7461626c652077696474683d22353730222063656c6c73706163696e673d2230222063656c6c70616464696e673d22302220616c69676e3d2263656e74657222206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c746420616c69676e3d226c656674223e0d0a3c646976207374796c653d22626f726465723a20736f6c69642031707820236439643964393b206261636b67726f756e642d636f6c6f723a20236666666666663b223e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a2048656c7665746963612c417269616c2c73616e732d73657269663b20626f726465723a20736f6c69642031707820236666666666663b20636f6c6f723a20233434343b2077696474683a20313030253b2220626f726465723d2230222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d2232222076616c69676e3d22626f74746f6d22206865696768743d223330223ec2a03c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d226c696e652d6865696768743a20333270783b2070616464696e672d6c6566743a20333070783b222076616c69676e3d22626173656c696e65223e5b636f6d70616e795f6c6f676f5d3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226d617267696e2d746f703a20313570783b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b20636f6c6f723a20233434343b206c696e652d6865696768743a20312e363b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c74723e0d0a3c7464207374796c653d22626f726465722d746f703a20736f6c69642031707820236439643964393b20626f726465722d626f74746f6d3a20736f6c69642031707820236439643964393b2220636f6c7370616e3d2232223e0d0a3c646976207374796c653d2270616464696e673a203135707820303b223e48656c6c6f5b757365725f6e616d655d2cc2a03c6272202f3e3c6272202f3e427573696e657373206c697374696e672077697468206e616d65c2a03c7374726f6e673e5b627573696e6573735f6e616d655d3c2f7374726f6e673ec2a0686173206265656ec2a0636c61696d65642e3c6272202f3e3c6272202f3e5468616e6b20796f752c0d0a3c6469763e5b636f6d70616e795f6e616d655d205465616d3c2f6469763e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c7461626c65207374796c653d226c696e652d6865696768743a20312e353b20666f6e742d73697a653a20313270783b20666f6e742d66616d696c793a20417269616c2c73616e732d73657269663b206d617267696e2d72696768743a20333070783b206d617267696e2d6c6566743a20333070783b2220626f726465723d2230222077696474683d22353130222063656c6c73706163696e673d2230222063656c6c70616464696e673d223022206267636f6c6f723d2223666666666666223e0d0a3c74626f64793e0d0a3c7472207374796c653d22666f6e742d73697a653a20313170783b20636f6c6f723a20233939393939393b222076616c69676e3d226d6964646c65223e0d0a3c74643e5b6469726563746f72795f776562736974655d3c2f74643e0d0a3c74643e0d0a3c646976207374796c653d22666c6f61743a2072696768743b2070616464696e672d746f703a20313070783b223e5b636f6d70616e795f736f6369616c5f6e6574776f726b735d3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c74723e0d0a3c7464207374796c653d22636f6c6f723a20236666666666663b2220636f6c7370616e3d223222206865696768743d223135223ec2a03c6272202f3e3c6272202f3e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e0d0a3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f63656e7465723e3c2f74643e0d0a3c2f74723e0d0a3c2f74626f64793e0d0a3c2f7461626c653e0d0a3c2f6469763e, 1, 0),
(39, 'Your order has been shipped', 'Offer Shipping Notification', 'Offer Shipping Notification', 0x[encoded data, 4706 characters], 1, 0),
(40, 'Tickets booking for [event_name]', 'Event Reservation Waiting Notification', 'Event Reservation Waiting Notification', 0x[encoded data, 6962 characters], 1, 0),
(41, 'Service booking nr. [service_booking_id] has been made', 'Service Booking Waiting Notification', 'Service Booking Waiting Notification', 0x[encoded data, 5328 characters], 1, 0);
INSERT INTO `joseb_jbusinessdirectory_emails` (`email_id`, `email_subject`, `email_name`, `email_type`, `email_content`, `status`, `send_to_admin`) VALUES
(42, 'Order nr. [offer_order_id] has been made', 'Offer Order Waiting Notification', 'Offer Order Waiting Notification', 0x[encoded data, 5080 characters], 1, 0),
(43, 'Campaign Payment nr. [campaign_id] has been made', 'Campaign Payment Notification', 'Campaign Payment Notification', 0x[encoded data, 4348 characters], 1, 0),
(44, 'Campaign Payment nr. [campaign_id] waiting for confirmation', 'Campaign Payment Waiting Notification', 'Campaign Payment Waiting Notification', 0x[encoded data, 4766 characters], 1, 0),
(45, 'A new request for [business_name]', 'Request Quote', 'Request Quote', 0x[encoded data, 4412 characters], 1, 0),
(46, 'User changed for listing [business_name]', 'Listing User Changed', 'Listing User Changed', 0x[encoded data, 4146 characters], 1, 0);

-- --------------------------------------------------------

--
