-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 15, 2020 at 03:23 AM
-- Server version: 5.6.49
-- PHP Version: 7.2.34

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `demo12cm_booking_real_estate`
--

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

--
-- Table structure for table `woobooking_agent`
--

DROP TABLE IF EXISTS `woobooking_agent`;
CREATE TABLE `woobooking_agent` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `published` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `opensource_user_id` int(11) NOT NULL,
  `country_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `email` varchar(50) CHARACTER SET utf8 NOT NULL,
  `phone_number` varchar(15) CHARACTER SET utf8 NOT NULL,
  `mobile` varchar(50) CHARACTER SET utf8 NOT NULL,
  `ordering` int(11) NOT NULL,
  `cover` varchar(400) CHARACTER SET utf8 NOT NULL,
  `image` varchar(400) CHARACTER SET utf8 NOT NULL,
  `params` mediumtext CHARACTER SET utf8 NOT NULL,
  `quote` text CHARACTER SET utf8 NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `woobooking_agent`
--

INSERT INTO `woobooking_agent` (`id`, `name`, `published`, `location_id`, `user_id`, `opensource_user_id`, `country_code`, `email`, `phone_number`, `mobile`, `ordering`, `cover`, `image`, `params`, `quote`, `description`) VALUES
(1, 'David Greene', 1, 4, 0, 0, 'VNM', 'David_greene@email.com', '0123456789', '', 0, '', 'upload/agents/images/cover/jcCxNPuTimage-17.jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\" David_greene@email.com\"}', 'David represented me in a purchase and sale and exemplifies some of the most important traits in a real estate agent. He has integrity, community expertise, in-depth market knowledge, effective negotiation skills, and a high-quality professional network.', 'David is a pleasure to work with. He helped me find a great first in an amazing location and has been a huge help to friends and family too. He has a background in construction, so he has an eye quality and knows exactly what to look when walking through a home. This is crucial in a market like Chicago where there are houses spanning over 100 years of age. Speaking of Chicago, David knows the city extremely well and has a vast amount of knowledge of the different neighborhoods. '),
(2, 'Adam Press', 1, 4, 0, 0, 'VNM', 'adampress@email.com', '1234567890', '', 0, '', 'upload/agents/images/cover/fHFSJhQIimage-17-(1).jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"adampress@email.com\"}', '\"Adam is an extraordinarily talented Realtor\"-- Steve Brown, former President of The National Association of Realtors.', 'With over 20 years experience on the WestSide of Los Angeles and its environs, Adam is the definitive real estate expert with respect to real estate\'s multi-factorial subtleties. The confidence you will have in knowing Adam brings his unique talents, powerful accreditations and experience in Real Estate to locate and close your special property makes Adam the best choice on the WestSide. In addition, Adam\'s empathy and understanding of his clients\' needs gives him that sixth sense in locating you that perfect property.'),
(3, 'Ryan Stabile', 1, 10, 0, 0, 'VNM', 'Ryan_stabile@email.com', '1234567890', '', 0, '', 'upload/agents/images/cover/sxmV017eimage-17-(2).jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"Ryan_stabile@email.com\"}', 'Ryan Stabile is a well educated and creative Realtor whose passion for architecture and helping people achieve their dreams has been the foundation for his career in real estate. Born, raised, and educated in Southern California, Ryan has a deep appreciation for all our area has to offer.', 'Ryan’s diverse background and previous experience in the film industry have generated an extended network that enables him to go beyond the typical avenues of matching the right home sellers and buyers.'),
(4, 'Nevin Nelson', 1, 11, 0, 0, 'VNM', 'Nevin_nelson@email.com', '1234567890', '', 0, '', 'upload/agents/images/cover/wpNPUfdkimage-22.jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"Nevin_nelson@email.com\"}', 'Excellent realtor. Does what is best for the customer! Very knowledgeable and professional. You would be lucky to have her as your realtor. ', 'Nevin was an amazing partner to have during our home buying process. She consistently went above and beyond and offered insights that we never received from other agents we had worked with outside of Redfin in the past. He never rushed us with finding our house and made it happen when we found the one we wanted. Looking forward to working with her again in the future. '),
(5, 'Dawn Sullivan', 1, 17, 0, 0, 'VNM', 'Dawn_sullivan@email.com', '1234567890', '', 0, '', 'upload/agents/images/cover/g7BxrLm0image-25.jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"Dawn_sullivan@email.com\"}', 'Dawn was our guiding light through the negotiation process and approached her job with absolute diligence, promptness and professionalism. We couldn\'t have asked for a more trusted resource.', '	\r\nDawn was such a pleasure to work with from the beginning until closing. She was always available and quickly responded with any questions I had. Her attention to detail made me feel very confident that I had made the right choice when choosing her as my selling agent. I would highly recommend her to anyone selling a home. '),
(6, 'Samantha Oliver', 1, 15, 0, 0, 'VNM', 'Samantha_oliver@email.com', '1234567890', '', 0, '', 'upload/agents/images/cover/JDjzeS3Uimage-23.jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"Samantha_oliver@email.com\"}', 'Samantha made the process of buying our home easy. Her response to questions and concerns was timely. Trust me, you’re in good hands with her. ', 'Before Samantha took the agent role, our condo stayed on the market for almost a year. After we signed a contract with her, we sold it within a week after listing on redfin. First, She did a good job providing us correct appraisals, we sold exactly at the price. Second, She sent professional photographers, who did the excellent job photo shooting and 3D display our condo. That\'s the reason why the condo sold so quickly. Samantha is also very helpful during the closing stage, she and her team answered every question we had about the process. The closing went very smooth and it took only a month to finish everything. We want to thank Samantha for her excellent job, and we will recommend her to any friends who want to sell their home. '),
(7, 'Maria Anna', 1, 17, 0, 0, 'VNM', 'Maria_anna@gmail.com', '1234567890', '', 0, '', 'upload/agents/images/cover/KbWhiNVYimage-24.jpg', '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/\",\"skype\":\"Maria_anna@gmail.com\"}', 'Excellent realtor. Does what is best for the customer! Very knowledgeable and professional. You would be lucky to have her as your realtor.', 'Maria was an amazing partner to have during our home buying process. She consistently went above and beyond and offered insights that we never received from other agents we had worked with outside of Redfin in the past. She never rushed us with finding our house and made it happen when we found the one we wanted. Looking forward to working with her again in the future.');

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

--
-- Table structure for table `woobooking_amenity`
--

DROP TABLE IF EXISTS `woobooking_amenity`;
CREATE TABLE `woobooking_amenity` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `type` varchar(255) NOT NULL,
  `published` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_amenity`
--

INSERT INTO `woobooking_amenity` (`id`, `name`, `type`, `published`, `image`, `ordering`, `description`) VALUES
(1, 'Toiletries', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Toiletries are the specific bathroom amenities such as bath gel, shower caps, toothbrushes, combs, shaving kits, etc.'),
(2, 'Cable Internet ', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'For seamless digital conferences, communication, and more.'),
(3, 'Swimming Pool', 'outdoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'An indoor pool might be the ultimate creature comfort. It offers a private, resort-style experience to its residents and supreme hospitality to its guests, whatever the weather. The indoor pool comes in many styles: For the serious swimmer, a resistance pool or lap pool builds strength, stamina, and flexibility.'),
(4, 'Electric Hot Water', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Electric Hot Water'),
(5, 'Tennis Court', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Tennis Court'),
(6, 'Freezer', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Freezer'),
(7, 'Wood stove', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'wood stove'),
(8, 'Cable TV', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Cable TV'),
(9, 'Water Softener', 'indoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Water Softener'),
(10, 'Handicap Facilities', 'outdoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Handicap Facilities'),
(11, 'Football ground', 'outdoor', 1, 'admin/app/assets/images/no-image.jpg', 0, 'Football ground.'),
(12, 'Satellite Dish', 'indoor', 1, '', 0, 'Satellite Dish'),
(13, 'Range/Oven', 'indoor', 1, '', 0, 'Range/Oven'),
(14, 'Garbage Disposal', 'indoor', 1, '', 0, 'Garbage Disposal'),
(15, 'Trash Compactor', 'indoor', 1, '', 0, 'Trash Compactor'),
(16, 'Wheelchair Ramp', 'outdoor', 1, '', 0, 'Wheelchair Ramp');

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

--
-- Table structure for table `woobooking_apps`
--

DROP TABLE IF EXISTS `woobooking_apps`;
CREATE TABLE `woobooking_apps` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_apps`
--

INSERT INTO `woobooking_apps` (`id`, `name`, `alias`, `ordering`, `description`) VALUES
(1, 'woobooking', 'woobooking', 0, '');

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

--
-- Table structure for table `woobooking_billing`
--

DROP TABLE IF EXISTS `woobooking_billing`;
CREATE TABLE `woobooking_billing` (
  `id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `email` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `company` varchar(255) NOT NULL,
  `country` varchar(50) NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `address_2` varchar(255) NOT NULL,
  `postcode` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `title` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_billing`
--

INSERT INTO `woobooking_billing` (`id`, `ordering`, `order_id`, `email`, `first_name`, `company`, `country`, `address_1`, `address_2`, `postcode`, `city`, `state`, `phone`, `title`, `alias`, `data`) VALUES
(4, 0, 8, 'nguyendinhcuong@gmail.com', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', '');

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

--
-- Table structure for table `woobooking_block`
--

DROP TABLE IF EXISTS `woobooking_block`;
CREATE TABLE `woobooking_block` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `type` varchar(50) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL,
  `params` mediumtext NOT NULL,
  `open_source_client_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_block`
--

INSERT INTO `woobooking_block` (`id`, `name`, `type`, `alias`, `ordering`, `description`, `params`, `open_source_client_id`) VALUES
(1, '', 'service-list', '', 0, '', '', ''),
(2, '', 'service-list', '', 0, '', '', ''),
(3, '', 'service-list', '', 0, '', '', ''),
(4, '', 'service-list', '', 0, '', '', ''),
(5, '', 'service-list', '', 0, '', '', ''),
(6, '', 'service-list', '', 0, '', '', ''),
(7, '', 'service-list', '', 0, '', '', ''),
(8, '', 'service-list', '', 0, '', '', ''),
(9, '', 'service-list', '', 0, '', '', ''),
(10, '', 'service-list', '', 0, '', '', ''),
(11, '', 'service-list', '', 0, '', '', ''),
(12, '', 'service-list', '', 0, '', '', ''),
(13, '', 'service-list', '', 0, '', '', ''),
(14, '', 'service-list', '', 0, '', '', ''),
(15, '', 'service-list', '', 0, '', '', ''),
(16, '', '', '', 0, '', '', ''),
(17, '', 'service-list', '', 0, '', '', ''),
(18, '', 'service-list', '', 0, '', '{\"category_id\":\"33\"}', ''),
(19, '', 'service-list', '', 0, '', '{\"category_id\":\"33\"}', ''),
(20, '', 'service-list', '', 0, '', '{\"category_id\":\"37\"}', ''),
(21, '', 'service-list', '', 0, '', '{\"category_id\":\"32\"}', ''),
(22, '', 'event-list', '', 0, '', '', ''),
(23, '', 'service-list', '', 0, '', '{\"category_id\":\"32\"}', ''),
(24, '', 'woobooking-employee-list', '', 0, '', '', ''),
(25, '', 'woobooking-employee-list', '', 0, '', '', ''),
(26, '', 'woobooking-employee-list', '', 0, '', '', ''),
(27, '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"32\"}', ''),
(28, '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"32\"}', ''),
(29, '', 'woobooking-appointment-default', '', 0, '', '', ''),
(30, '', 'woobooking-employee-list', '', 0, '', '', ''),
(31, '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"20\"}', ''),
(32, '', 'woobooking-category-list', '', 0, '', '', ''),
(33, '', '', '', 0, '', '{\"category_id\":\"20\"}', ''),
(34, '', 'woobooking-service-list', '', 0, '', '', ''),
(35, '', 'woobooking-service-list', '', 0, '', '', ''),
(36, '', 'woobooking-service-list', '', 0, '', '', ''),
(37, '', 'woobooking-service-list', '', 0, '', '', ''),
(38, '', 'woobooking-service-list', '', 0, '', '', ''),
(39, '', 'woobooking-service-list', '', 0, '', '', ''),
(40, '', 'woobooking-service-list', '', 0, '', '', ''),
(41, '', 'woobooking-service-list', '', 0, '', '', ''),
(42, '', 'woobooking-service-list', '', 0, '', '', ''),
(43, '', 'woobooking-service-list', '', 0, '', '', ''),
(44, '', 'woobooking-service-list', '', 0, '', '', ''),
(45, '', 'woobooking-service-list', '', 0, '', '', ''),
(46, '', 'woobooking-service-list', '', 0, '', '', ''),
(47, '', 'woobooking-category-list', '', 0, '', '', ''),
(48, '', 'woobooking-service-list', '', 0, '', '', ''),
(49, '', 'woobooking-service-list', '', 0, '', '', ''),
(50, '', 'woobooking-service-list', '', 0, '', '', ''),
(51, '', 'woobooking-service-list', '', 0, '', '', ''),
(52, '', 'woobooking-service-list', '', 0, '', '', ''),
(53, '', 'woobooking-service-list', '', 0, '', '', ''),
(54, '', 'woobooking-service-list', '', 0, '', '', ''),
(55, '', '', '', 0, '', '{\"category_id\":\"20\"}', ''),
(56, '', 'woobooking-service-list', '', 0, '', '', ''),
(57, '', 'woobooking-service-list', '', 0, '', '', ''),
(58, '', 'woobooking-service-list', '', 0, '', '', ''),
(59, '', 'woobooking-service-list', '', 0, '', '', ''),
(60, '', 'woobooking-service-list', '', 0, '', '', ''),
(61, '', 'woobooking-service-list', '', 0, '', '', ''),
(62, '', 'woobooking-service-list', '', 0, '', '', ''),
(63, '', 'woobooking-service-list', '', 0, '', '', ''),
(64, '', 'woobooking-service-list', '', 0, '', '', ''),
(65, '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"20\"}', ''),
(66, '', 'woobooking-category-list', '', 0, '', '', ''),
(67, '', 'woobooking-category-list', '', 0, '', '', ''),
(68, '', 'woobooking-category-list', '', 0, '', '', ''),
(69, '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}', ''),
(70, '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}', ''),
(71, '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}', ''),
(72, '', 'woobooking-category-list', '', 0, '', '', ''),
(73, '', 'woobooking-category-list', '', 0, '', '', ''),
(74, '', 'woobooking-category-list', '', 0, '', '', ''),
(75, '', 'woobooking-category-list', '', 0, '', '', ''),
(76, '', 'woobooking-category-list', '', 0, '', '', ''),
(77, '', 'woobooking-category-list', '', 0, '', '', ''),
(78, '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"list_home_page\"}', ''),
(79, '', 'woobooking-classtimeable-default', '', 0, '', '', ''),
(80, '', 'woobooking-classtimeable-default', '', 0, '', '', ''),
(81, '', 'woobooking-classtimeable-default', '', 0, '', '', ''),
(82, '', 'woobooking-block-classtimeable-default', '', 0, '', '', ''),
(83, '', 'woobooking-block-classtimeable-default', '', 0, '', '', ''),
(84, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(85, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(86, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(87, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(88, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(89, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(90, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(91, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(92, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(93, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(94, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(95, '', 'woobooking-block-classtimeable', '', 0, '', '{\"category_id\":\"20\"}', ''),
(96, '', 'woobooking-block-classtimeable', '', 0, '', '{\"category_id\":\"22\"}', ''),
(97, '', 'woobooking-block-block_classtimeable', '', 0, '', '', ''),
(98, '', 'woobooking-block-block_classtimeable', '', 0, '', '', ''),
(99, 'sdfdsfds', 'woobooking-block-classtimeable', '', 0, '', 'null', ''),
(100, '', 'woobooking-booking-training', '', 0, '', '', ''),
(101, '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"list_home_page\"}', ''),
(102, 'Table time', 'woobooking-block-classtimeable', '', 0, '', 'null', ''),
(103, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(104, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(105, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}', ''),
(106, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"category_id\":\"\",\"layout\":\"page_service_package_plan\"}', ''),
(107, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(108, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"category_id\":\"\",\"layout\":\"page_service_package_plan\"}', ''),
(109, '', 'woobooking-block-meetourcoachs', '', 0, '', '', ''),
(110, '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"15\",\"16\"],\"layout\":\"default\"}', ''),
(111, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(112, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(113, '', 'woobooking-block-categoryimage', '', 0, '', '', ''),
(114, '', 'woobooking-block-categoryimage', '', 0, '', '', ''),
(115, '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"20\",\"21\",\"22\",\"23\",\"46\"],\"layout\":\"default\"}', ''),
(116, '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"68\",\"23\",\"22\",\"21\",\"20\"],\"layout\":\"default\"}', ''),
(117, '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"20\",\"21\",\"22\",\"23\",\"46\"],\"layout\":\"default\"}', ''),
(118, '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"17\"],\"layout\":\"default\"}', ''),
(119, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"5\"],\"layout\":\"default\"}', ''),
(120, '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"15\"],\"layout\":\"default\"}', ''),
(121, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(122, '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"67\",\"20\",\"21\",\"22\",\"23\"],\"layout\":\"default\"}', ''),
(123, '', 'woobooking-block-galleryblock', '', 0, '', '{\"gallery_id\":[\"\"],\"layout\":\"default\"}', ''),
(124, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(125, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(126, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(127, '', 'woobooking-block-galleryblock', '', 0, '', '{\"gallery_id\":[\"\"],\"layout\":\"default\"}', ''),
(128, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(129, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(130, '', 'woobooking-block-galleryblock', '', 0, '', '{\"service_id\":[\"45\",\"46\",\"47\",\"48\",\"49\",\"50\",\"51\",\"52\",\"57\"],\"layout\":\"default\"}', ''),
(131, '', 'woobooking-order-list', '', 0, '', '', ''),
(132, '', 'woobooking-account-list', '', 0, '', '', ''),
(133, '', 'woobooking-block-bookingtraining', '', 0, '', '{\"service_id\":[\"45\"],\"layout\":\"default\"}', ''),
(134, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(135, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(136, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(137, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(138, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(139, '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}', ''),
(140, 'block', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(141, 'hfhfhf', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(142, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(143, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(144, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}', ''),
(145, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(146, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(147, '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}', ''),
(148, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}', ''),
(149, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(150, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(151, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(152, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(153, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(154, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(155, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(156, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"blocks\\/block_location\\/assets\\/images\\/img2.png\",\"link_1\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=20\",\"text_1\":\"HO CHI MINH\",\"path_image2\":\"blocks\\/block_location\\/assets\\/images\\/img3.png\",\"link_2\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=21\",\"text_2\":\"DA NANG\",\"path_image3\":\"blocks\\/block_location\\/assets\\/images\\/img4.png\",\"link_3\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=22\",\"text_3\":\"HA NOI\"}', ''),
(157, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"blocks\\/block_location\\/assets\\/images\\/img2.png\",\"link_1\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=20\",\"text_1\":\"HO CHI MINH\",\"path_image2\":\"blocks\\/block_location\\/assets\\/images\\/img3.png\",\"link_2\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=21\",\"text_2\":\"DA NANG\",\"path_image3\":\"blocks\\/block_location\\/assets\\/images\\/img4.png\",\"link_3\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=22\",\"text_3\":\"HA NOI\"}', ''),
(158, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(159, 'block search', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(160, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"\",\"link_1\":\"\",\"text_1\":\"\",\"path_image2\":\"\",\"link_2\":\"\",\"text_2\":\"\",\"path_image3\":\"\",\"link_3\":\"\",\"text_3\":\"\"}', ''),
(161, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"\",\"link_1\":\"\",\"text_1\":\"\",\"path_image2\":\"\",\"link_2\":\"\",\"text_2\":\"\",\"path_image3\":\"\",\"link_3\":\"\",\"text_3\":\"\"}', ''),
(162, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}', ''),
(163, '', 'woobooking-block-searchmenu', '', 0, '', '', ''),
(164, '', 'woobooking-block-searchmenu', '', 0, '', '', ''),
(165, '', 'woobooking-block-listevent', '', 0, '', '', ''),
(166, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(167, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(168, '', 'woobooking-block-bookingtraining', '', 0, '', '', ''),
(169, '', 'woobooking-block-categoryimage', '', 0, '', '', ''),
(170, '', 'woobooking-block-meetourcoachs', '', 0, '', '', ''),
(171, '', 'woobooking-block-classtimeable', '', 0, '', '', ''),
(172, '', 'woobooking-block-galleryblock', '', 0, '', '', ''),
(173, '', 'woobooking-block-location', '', 0, '', '', ''),
(174, '', 'woobooking-block-listevent', '', 0, '', '', ''),
(175, '', 'woobooking-block-priceplanclass', '', 0, '', '', ''),
(176, '', 'woobooking-block-searchmenu', '', 0, '', '', ''),
(177, '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}', ''),
(178, '', 'woobooking-block-listevent', '', 0, '', '', ''),
(179, '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}', ''),
(180, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"layout\":\"default\"}', ''),
(181, '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}', ''),
(182, '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}', ''),
(183, '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"70\",\"68\",\"23\",\"22\",\"21\",\"20\"],\"layout\":\"default\"}', ''),
(184, '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"15\"],\"layout\":\"default\"}', ''),
(185, '', 'woobooking-block-galleryblock', '', 0, '', '{\"service_id\":[\"45\",\"46\",\"47\",\"48\",\"49\",\"50\",\"51\",\"52\",\"57\",\"58\",\"59\"],\"layout\":\"default\"}', ''),
(186, '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}', ''),
(187, '', 'top_destinations_hotel', '', 0, '', '{\"filter_by_country\":[\"2\",\"9\",\"15\",\"19\",\"35\",\"242\"]}', '42a5c87'),
(188, '', 'popular_hotel', '', 0, '', '{}', 'a171f08'),
(189, '', 'top_reviews', '', 0, '', '{}', 'a29aead'),
(190, '', 'trending_destinations_hotel', '', 0, '', '{\"filter_by_country\":[\"8\",\"70\",\"76\"]}', '44fef77'),
(191, '', 'top_destinations_hotel', '', 0, '', '{\"filter_by_country\":[\"8\",\"60\",\"80\",\"112\",\"235\",\"242\"]}', 'b38c9fe'),
(192, '', 'popular_hotel', '', 0, '', '{}', '667755b'),
(193, '', 'search_hotel', '', 0, '', '{}', '75584a0'),
(194, '', 'popular_hotel', '', 0, '', '{}', '6d28770');

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

--
-- Table structure for table `woobooking_cart`
--

DROP TABLE IF EXISTS `woobooking_cart`;
CREATE TABLE `woobooking_cart` (
  `id` int(11) NOT NULL,
  `session_id` varchar(50) NOT NULL,
  `service_id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `country_code` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `open_source_link_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `extra_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `rate_id` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `quantity` int(11) NOT NULL,
  `subtotal` float NOT NULL,
  `total` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_category`
--

DROP TABLE IF EXISTS `woobooking_category`;
CREATE TABLE `woobooking_category` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_category`
--

INSERT INTO `woobooking_category` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(1, 'Apartment', '', '', 0, 1, 'Apartment'),
(2, 'Home', '', '', 0, 1, 'Home'),
(3, 'Villa', '', '', 0, 1, 'Villa'),
(4, 'Resort', '', '', 0, 1, 'Resort');

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

--
-- Table structure for table `woobooking_config`
--

DROP TABLE IF EXISTS `woobooking_config`;
CREATE TABLE `woobooking_config` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `params` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_config`
--

INSERT INTO `woobooking_config` (`id`, `title`, `alias`, `params`) VALUES
(1, 'title1', 'title1', '{\"page_real_estate_detail\":\"13\",\"page_list_real_estate\":\"14\",\"page_list_agent\":\"12\",\"page_agent_detail\":\"52\",\"page_list_realestatelocator\":\"\",\"email_type\":\"send_info_tour_config\",\"currencies_in_list\":\"EUR\",\"radius_for_search\":\"100\",\"unit_for_search\":\"Km\"}');

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

--
-- Table structure for table `woobooking_country`
--

DROP TABLE IF EXISTS `woobooking_country`;
CREATE TABLE `woobooking_country` (
  `id` int(11) NOT NULL,
  `countrycode` char(3) NOT NULL,
  `countryname` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `code` char(2) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_country`
--

INSERT INTO `woobooking_country` (`id`, `countrycode`, `countryname`, `image`, `code`, `ordering`, `published`) VALUES
(1, 'ABW', 'Aruba', 'admin/resources/flags/aw.png', 'AW', 0, 0),
(2, 'AFG', 'Afghanistan', 'admin/resources/flags/af.png', 'AF', 0, 0),
(3, 'AGO', 'Angola', 'admin/resources/flags/ao.png', 'AO', 0, 0),
(4, 'AIA', 'Anguilla', 'admin/resources/flags/ai.png', 'AI', 0, 0),
(5, 'ALA', 'Åland', 'admin/resources/flags/ax.png', 'AX', 0, 0),
(6, 'ALB', 'Albania', 'admin/resources/flags/al.png', 'AL', 0, 0),
(7, 'AND', 'Andorra', 'admin/resources/flags/ad.png', 'AD', 0, 0),
(8, 'ARE', 'United Arab Emirates', 'admin/resources/flags/ae.png', 'AE', 0, 0),
(9, 'ARG', 'Argentina', 'admin/resources/flags/ar.png', 'AR', 0, 0),
(10, 'ARM', 'Armenia', 'admin/resources/flags/am.png', 'AM', 0, 0),
(11, 'ASM', 'American Samoa', 'admin/resources/flags/as.png', 'AS', 0, 0),
(12, 'ATA', 'Antarctica', 'admin/resources/flags/aq.png', 'AQ', 0, 0),
(13, 'ATF', 'French Southern Territories', 'admin/resources/flags/tf.png', 'TF', 0, 0),
(14, 'ATG', 'Antigua and Barbuda', 'admin/resources/flags/ag.png', 'AG', 0, 0),
(15, 'AUS', 'Australia', 'admin/resources/flags/au.png', 'AU', 0, 0),
(16, 'AUT', 'Austria', 'admin/resources/flags/at.png', 'AT', 0, 0),
(17, 'AZE', 'Azerbaijan', 'admin/resources/flags/az.png', 'AZ', 0, 0),
(18, 'BDI', 'Burundi', 'admin/resources/flags/bi.png', 'BI', 0, 0),
(19, 'BEL', 'Belgium', 'admin/resources/flags/be.png', 'BE', 0, 0),
(20, 'BEN', 'Benin', 'admin/resources/flags/bj.png', 'BJ', 0, 0),
(21, 'BES', 'Bonaire', 'admin/resources/flags/bq.png', 'BQ', 0, 0),
(22, 'BFA', 'Burkina Faso', 'admin/resources/flags/bf.png', 'BF', 0, 0),
(23, 'BGD', 'Bangladesh', 'admin/resources/flags/bd.png', 'BD', 0, 0),
(24, 'BGR', 'Bulgaria', 'admin/resources/flags/bg.png', 'BG', 0, 0),
(25, 'BHR', 'Bahrain', 'admin/resources/flags/bh.png', 'BH', 0, 0),
(26, 'BHS', 'Bahamas', 'admin/resources/flags/bs.png', 'BS', 0, 0),
(27, 'BIH', 'Bosnia and Herzegovina', 'admin/resources/flags/ba.png', 'BA', 0, 0),
(28, 'BLM', 'Saint Barthélemy', 'admin/resources/flags/bl.png', 'BL', 0, 0),
(29, 'BLR', 'Belarus', 'admin/resources/flags/by.png', 'BY', 0, 0),
(30, 'BLZ', 'Belize', 'admin/resources/flags/bz.png', 'BZ', 0, 0),
(31, 'BMU', 'Bermuda', 'admin/resources/flags/bm.png', 'BM', 0, 0),
(32, 'BOL', 'Bolivia', 'admin/resources/flags/bo.png', 'BO', 0, 0),
(33, 'BRA', 'Brazil', 'admin/resources/flags/br.png', 'BR', 0, 0),
(34, 'BRB', 'Barbados', 'admin/resources/flags/bb.png', 'BB', 0, 0),
(35, 'BRN', 'Brunei', 'admin/resources/flags/bn.png', 'BN', 0, 0),
(36, 'BTN', 'Bhutan', 'admin/resources/flags/bt.png', 'BT', 0, 0),
(37, 'BVT', 'Bouvet Island', 'admin/resources/flags/bv.png', 'BV', 0, 0),
(38, 'BWA', 'Botswana', 'admin/resources/flags/bw.png', 'BW', 0, 0),
(39, 'CAF', 'Central African Republic', 'admin/resources/flags/cf.png', 'CF', 0, 0),
(40, 'CAN', 'Canada', 'admin/resources/flags/ca.png', 'CA', 0, 0),
(41, 'CCK', 'Cocos [Keeling] Islands', 'admin/resources/flags/cc.png', 'CC', 0, 0),
(42, 'CHE', 'Switzerland', 'admin/resources/flags/ch.png', 'CH', 0, 0),
(43, 'CHL', 'Chile', 'admin/resources/flags/cl.png', 'CL', 0, 0),
(44, 'CHN', 'China', 'admin/resources/flags/cn.png', 'CN', 0, 0),
(45, 'CIV', 'Ivory Coast', 'admin/resources/flags/ci.png', 'CI', 0, 0),
(46, 'CMR', 'Cameroon', 'admin/resources/flags/cm.png', 'CM', 0, 0),
(47, 'COD', 'Democratic Republic of the Congo', 'admin/resources/flags/cd.png', 'CD', 0, 0),
(48, 'COG', 'Republic of the Congo', 'admin/resources/flags/cg.png', 'CG', 0, 0),
(49, 'COK', 'Cook Islands', 'admin/resources/flags/ck.png', 'CK', 0, 0),
(50, 'COL', 'Colombia', 'admin/resources/flags/co.png', 'CO', 0, 0),
(51, 'COM', 'Comoros', 'admin/resources/flags/km.png', 'KM', 0, 0),
(52, 'CPV', 'Cape Verde', 'admin/resources/flags/cv.png', 'CV', 0, 0),
(53, 'CRI', 'Costa Rica', 'admin/resources/flags/cr.png', 'CR', 0, 0),
(54, 'CUB', 'Cuba', 'admin/resources/flags/cu.png', 'CU', 0, 0),
(55, 'CUW', 'Curacao', 'admin/resources/flags/cw.png', 'CW', 0, 0),
(56, 'CXR', 'Christmas Island', 'admin/resources/flags/cx.png', 'CX', 0, 0),
(57, 'CYM', 'Cayman Islands', 'admin/resources/flags/ky.png', 'KY', 0, 0),
(58, 'CYP', 'Cyprus', 'admin/resources/flags/cy.png', 'CY', 0, 0),
(59, 'CZE', 'Czech Republic', 'admin/resources/flags/cz.png', 'CZ', 0, 0),
(60, 'DEU', 'Germany', 'admin/resources/flags/de.png', 'DE', 0, 0),
(61, 'DJI', 'Djibouti', 'admin/resources/flags/dj.png', 'DJ', 0, 0),
(62, 'DMA', 'Dominica', 'admin/resources/flags/dm.png', 'DM', 0, 0),
(63, 'DNK', 'Denmark', 'admin/resources/flags/dk.png', 'DK', 0, 0),
(64, 'DOM', 'Dominican Republic', 'admin/resources/flags/do.png', 'DO', 0, 0),
(65, 'DZA', 'Algeria', 'admin/resources/flags/dz.png', 'DZ', 0, 0),
(66, 'ECU', 'Ecuador', 'admin/resources/flags/ec.png', 'EC', 0, 0),
(67, 'EGY', 'Egypt', 'admin/resources/flags/eg.png', 'EG', 0, 0),
(68, 'ERI', 'Eritrea', 'admin/resources/flags/er.png', 'ER', 0, 0),
(69, 'ESH', 'Western Sahara', 'admin/resources/flags/eh.png', 'EH', 0, 0),
(70, 'ESP', 'Spain', 'admin/resources/flags/es.png', 'ES', 0, 0),
(71, 'EST', 'Estonia', 'admin/resources/flags/ee.png', 'EE', 0, 0),
(72, 'ETH', 'Ethiopia', 'admin/resources/flags/et.png', 'ET', 0, 0),
(73, 'FIN', 'Finland', 'admin/resources/flags/fi.png', 'FI', 0, 0),
(74, 'FJI', 'Fiji', 'admin/resources/flags/fj.png', 'FJ', 0, 0),
(75, 'FLK', 'Falkland Islands', 'admin/resources/flags/fk.png', 'FK', 0, 0),
(76, 'FRA', 'France', 'admin/resources/flags/fr.png', 'FR', 0, 0),
(77, 'FRO', 'Faroe Islands', 'admin/resources/flags/fo.png', 'FO', 0, 0),
(78, 'FSM', 'Micronesia', 'admin/resources/flags/fm.png', 'FM', 0, 0),
(79, 'GAB', 'Gabon', 'admin/resources/flags/ga.png', 'GA', 0, 0),
(80, 'GBR', 'United Kingdom', 'admin/resources/flags/gb.png', 'GB', 0, 0),
(81, 'GEO', 'Georgia', 'admin/resources/flags/ge.png', 'GE', 0, 0),
(82, 'GGY', 'Guernsey', 'admin/resources/flags/gg.png', 'GG', 0, 0),
(83, 'GHA', 'Ghana', 'admin/resources/flags/gh.png', 'GH', 0, 0),
(84, 'GIB', 'Gibraltar', 'admin/resources/flags/gi.png', 'GI', 0, 0),
(85, 'GIN', 'Guinea', 'admin/resources/flags/gn.png', 'GN', 0, 0),
(86, 'GLP', 'Guadeloupe', 'admin/resources/flags/gp.png', 'GP', 0, 0),
(87, 'GMB', 'Gambia', 'admin/resources/flags/gm.png', 'GM', 0, 0),
(88, 'GNB', 'Guinea-Bissau', 'admin/resources/flags/gw.png', 'GW', 0, 0),
(89, 'GNQ', 'Equatorial Guinea', 'admin/resources/flags/gq.png', 'GQ', 0, 0),
(90, 'GRC', 'Greece', 'admin/resources/flags/gr.png', 'GR', 0, 0),
(91, 'GRD', 'Grenada', 'admin/resources/flags/gd.png', 'GD', 0, 0),
(92, 'GRL', 'Greenland', 'admin/resources/flags/gl.png', 'GL', 0, 0),
(93, 'GTM', 'Guatemala', 'admin/resources/flags/gt.png', 'GT', 0, 0),
(94, 'GUF', 'French Guiana', 'admin/resources/flags/gf.png', 'GF', 0, 0),
(95, 'GUM', 'Guam', 'admin/resources/flags/gu.png', 'GU', 0, 0),
(96, 'GUY', 'Guyana', 'admin/resources/flags/gy.png', 'GY', 0, 0),
(97, 'HKG', 'Hong Kong', 'admin/resources/flags/hk.png', 'HK', 0, 0),
(98, 'HMD', 'Heard Island and McDonald Islands', 'admin/resources/flags/hm.png', 'HM', 0, 0),
(99, 'HND', 'Honduras', 'admin/resources/flags/hn.png', 'HN', 0, 0),
(100, 'HRV', 'Croatia', 'admin/resources/flags/hr.png', 'HR', 0, 0),
(101, 'HTI', 'Haiti', 'admin/resources/flags/ht.png', 'HT', 0, 0),
(102, 'HUN', 'Hungary', 'admin/resources/flags/hu.png', 'HU', 0, 0),
(103, 'IDN', 'Indonesia', 'admin/resources/flags/id.png', 'ID', 0, 0),
(104, 'IMN', 'Isle of Man', 'admin/resources/flags/im.png', 'IM', 0, 0),
(105, 'IND', 'India', 'admin/resources/flags/in.png', 'IN', 0, 0),
(106, 'IOT', 'British Indian Ocean Territory', 'admin/resources/flags/io.png', 'IO', 0, 0),
(107, 'IRL', 'Ireland', 'admin/resources/flags/ie.png', 'IE', 0, 0),
(108, 'IRN', 'Iran', 'admin/resources/flags/ir.png', 'IR', 0, 0),
(109, 'IRQ', 'Iraq', 'admin/resources/flags/iq.png', 'IQ', 0, 0),
(110, 'ISL', 'Iceland', 'admin/resources/flags/is.png', 'IS', 0, 0),
(111, 'ISR', 'Israel', 'admin/resources/flags/il.png', 'IL', 0, 0),
(112, 'ITA', 'Italy', 'admin/resources/flags/it.png', 'IT', 0, 0),
(113, 'JAM', 'Jamaica', 'admin/resources/flags/jm.png', 'JM', 0, 0),
(114, 'JEY', 'Jersey', 'admin/resources/flags/je.png', 'JE', 0, 0),
(115, 'JOR', 'Jordan', 'admin/resources/flags/jo.png', 'JO', 0, 0),
(116, 'JPN', 'Japan', 'admin/resources/flags/jp.png', 'JP', 0, 1),
(117, 'KAZ', 'Kazakhstan', 'admin/resources/flags/kz.png', 'KZ', 0, 0),
(118, 'KEN', 'Kenya', 'admin/resources/flags/ke.png', 'KE', 0, 0),
(119, 'KGZ', 'Kyrgyzstan', 'admin/resources/flags/kg.png', 'KG', 0, 0),
(120, 'KHM', 'Cambodia', 'admin/resources/flags/kh.png', 'KH', 0, 0),
(121, 'KIR', 'Kiribati', 'admin/resources/flags/ki.png', 'KI', 0, 0),
(122, 'KNA', 'Saint Kitts and Nevis', 'admin/resources/flags/kn.png', 'KN', 0, 0),
(123, 'KOR', 'South Korea', 'admin/resources/flags/kr.png', 'KR', 0, 0),
(124, 'KWT', 'Kuwait', 'admin/resources/flags/kw.png', 'KW', 0, 0),
(125, 'LAO', 'Laos', 'admin/resources/flags/la.png', 'LA', 0, 0),
(126, 'LBN', 'Lebanon', 'admin/resources/flags/lb.png', 'LB', 0, 0),
(127, 'LBR', 'Liberia', 'admin/resources/flags/lr.png', 'LR', 0, 0),
(128, 'LBY', 'Libya', 'admin/resources/flags/ly.png', 'LY', 0, 0),
(129, 'LCA', 'Saint Lucia', 'admin/resources/flags/lc.png', 'LC', 0, 0),
(130, 'LIE', 'Liechtenstein', 'admin/resources/flags/li.png', 'LI', 0, 0),
(131, 'LKA', 'Sri Lanka', 'admin/resources/flags/lk.png', 'LK', 0, 0),
(132, 'LSO', 'Lesotho', 'admin/resources/flags/ls.png', 'LS', 0, 0),
(133, 'LTU', 'Lithuania', 'admin/resources/flags/lt.png', 'LT', 0, 0),
(134, 'LUX', 'Luxembourg', 'admin/resources/flags/lu.png', 'LU', 0, 0),
(135, 'LVA', 'Latvia', 'admin/resources/flags/lv.png', 'LV', 0, 0),
(136, 'MAC', 'Macao', 'admin/resources/flags/mo.png', 'MO', 0, 0),
(137, 'MAF', 'Saint Martin', 'admin/resources/flags/mf.png', 'MF', 0, 0),
(138, 'MAR', 'Morocco', 'admin/resources/flags/ma.png', 'MA', 0, 0),
(139, 'MCO', 'Monaco', 'admin/resources/flags/mc.png', 'MC', 0, 0),
(140, 'MDA', 'Moldova', 'admin/resources/flags/md.png', 'MD', 0, 0),
(141, 'MDG', 'Madagascar', 'admin/resources/flags/mg.png', 'MG', 0, 0),
(142, 'MDV', 'Maldives', 'admin/resources/flags/mv.png', 'MV', 0, 0),
(143, 'MEX', 'Mexico', 'admin/resources/flags/mx.png', 'MX', 0, 0),
(144, 'MHL', 'Marshall Islands', 'admin/resources/flags/mh.png', 'MH', 0, 0),
(145, 'MKD', 'Macedonia', 'admin/resources/flags/mk.png', 'MK', 0, 0),
(146, 'MLI', 'Mali', 'admin/resources/flags/ml.png', 'ML', 0, 0),
(147, 'MLT', 'Malta', 'admin/resources/flags/mt.png', 'MT', 0, 0),
(148, 'MMR', 'Myanmar [Burma]', 'admin/resources/flags/mm.png', 'MM', 0, 0),
(149, 'MNE', 'Montenegro', 'admin/resources/flags/me.png', 'ME', 0, 0),
(150, 'MNG', 'Mongolia', 'admin/resources/flags/mn.png', 'MN', 0, 0),
(151, 'MNP', 'Northern Mariana Islands', 'admin/resources/flags/mp.png', 'MP', 0, 0),
(152, 'MOZ', 'Mozambique', 'admin/resources/flags/mz.png', 'MZ', 0, 0),
(153, 'MRT', 'Mauritania', 'admin/resources/flags/mr.png', 'MR', 0, 0),
(154, 'MSR', 'Montserrat', 'admin/resources/flags/ms.png', 'MS', 0, 0),
(155, 'MTQ', 'Martinique', 'admin/resources/flags/mq.png', 'MQ', 0, 0),
(156, 'MUS', 'Mauritius', 'admin/resources/flags/mu.png', 'MU', 0, 0),
(157, 'MWI', 'Malawi', 'admin/resources/flags/mw.png', 'MW', 0, 0),
(158, 'MYS', 'Malaysia', 'admin/resources/flags/my.png', 'MY', 0, 0),
(159, 'MYT', 'Mayotte', 'admin/resources/flags/yt.png', 'YT', 0, 0),
(160, 'NAM', 'Namibia', 'admin/resources/flags/na.png', 'NA', 0, 0),
(161, 'NCL', 'New Caledonia', 'admin/resources/flags/nc.png', 'NC', 0, 0),
(162, 'NER', 'Niger', 'admin/resources/flags/ne.png', 'NE', 0, 0),
(163, 'NFK', 'Norfolk Island', 'admin/resources/flags/nf.png', 'NF', 0, 0),
(164, 'NGA', 'Nigeria', 'admin/resources/flags/ng.png', 'NG', 0, 0),
(165, 'NIC', 'Nicaragua', 'admin/resources/flags/ni.png', 'NI', 0, 0),
(166, 'NIU', 'Niue', 'admin/resources/flags/nu.png', 'NU', 0, 0),
(167, 'NLD', 'Netherlands', 'admin/resources/flags/nl.png', 'NL', 0, 0),
(168, 'NOR', 'Norway', 'admin/resources/flags/no.png', 'NO', 0, 0),
(169, 'NPL', 'Nepal', 'admin/resources/flags/np.png', 'NP', 0, 0),
(170, 'NRU', 'Nauru', 'admin/resources/flags/nr.png', 'NR', 0, 0),
(171, 'NZL', 'New Zealand', 'admin/resources/flags/nz.png', 'NZ', 0, 0),
(172, 'OMN', 'Oman', 'admin/resources/flags/om.png', 'OM', 0, 0),
(173, 'PAK', 'Pakistan', 'admin/resources/flags/pk.png', 'PK', 0, 0),
(174, 'PAN', 'Panama', 'admin/resources/flags/pa.png', 'PA', 0, 0),
(175, 'PCN', 'Pitcairn Islands', 'admin/resources/flags/pn.png', 'PN', 0, 0),
(176, 'PER', 'Peru', 'admin/resources/flags/pe.png', 'PE', 0, 0),
(177, 'PHL', 'Philippines', 'admin/resources/flags/ph.png', 'PH', 0, 0),
(178, 'PLW', 'Palau', 'admin/resources/flags/pw.png', 'PW', 0, 0),
(179, 'PNG', 'Papua New Guinea', 'admin/resources/flags/pg.png', 'PG', 0, 0),
(180, 'POL', 'Poland', 'admin/resources/flags/pl.png', 'PL', 0, 0),
(181, 'PRI', 'Puerto Rico', 'admin/resources/flags/pr.png', 'PR', 0, 0),
(182, 'PRK', 'North Korea', 'admin/resources/flags/kp.png', 'KP', 0, 0),
(183, 'PRT', 'Portugal', 'admin/resources/flags/pt.png', 'PT', 0, 0),
(184, 'PRY', 'Paraguay', 'admin/resources/flags/py.png', 'PY', 0, 0),
(185, 'PSE', 'Palestine', 'admin/resources/flags/ps.png', 'PS', 0, 0),
(186, 'PYF', 'French Polynesia', 'admin/resources/flags/pf.png', 'PF', 0, 0),
(187, 'QAT', 'Qatar', 'admin/resources/flags/qa.png', 'QA', 0, 0),
(188, 'REU', 'Réunion', 'admin/resources/flags/re.png', 'RE', 0, 0),
(189, 'ROU', 'Romania', 'admin/resources/flags/ro.png', 'RO', 0, 0),
(190, 'RUS', 'Russia', 'admin/resources/flags/ru.png', 'RU', 0, 0),
(191, 'RWA', 'Rwanda', 'admin/resources/flags/rw.png', 'RW', 0, 0),
(192, 'SAU', 'Saudi Arabia', 'admin/resources/flags/sa.png', 'SA', 0, 0),
(193, 'SDN', 'Sudan', 'admin/resources/flags/sd.png', 'SD', 0, 0),
(194, 'SEN', 'Senegal', 'admin/resources/flags/sn.png', 'SN', 0, 0),
(195, 'SGP', 'Singapore', 'admin/resources/flags/sg.png', 'SG', 0, 0),
(196, 'SGS', 'South Georgia and the South Sandwich Islands', 'admin/resources/flags/gs.png', 'GS', 0, 0),
(197, 'SHN', 'Saint Helena', 'admin/resources/flags/sh.png', 'SH', 0, 0),
(198, 'SJM', 'Svalbard and Jan Mayen', 'admin/resources/flags/sj.png', 'SJ', 0, 0),
(199, 'SLB', 'Solomon Islands', 'admin/resources/flags/sb.png', 'SB', 0, 0),
(200, 'SLE', 'Sierra Leone', 'admin/resources/flags/sl.png', 'SL', 0, 0),
(201, 'SLV', 'El Salvador', 'admin/resources/flags/sv.png', 'SV', 0, 0),
(202, 'SMR', 'San Marino', 'admin/resources/flags/sm.png', 'SM', 0, 0),
(203, 'SOM', 'Somalia', 'admin/resources/flags/so.png', 'SO', 0, 0),
(204, 'SPM', 'Saint Pierre and Miquelon', 'admin/resources/flags/pm.png', 'PM', 0, 0),
(205, 'SRB', 'Serbia', 'admin/resources/flags/rs.png', 'RS', 0, 0),
(206, 'SSD', 'South Sudan', 'admin/resources/flags/ss.png', 'SS', 0, 0),
(207, 'STP', 'São Tomé and Príncipe', 'admin/resources/flags/st.png', 'ST', 0, 0),
(208, 'SUR', 'Suriname', 'admin/resources/flags/sr.png', 'SR', 0, 0),
(209, 'SVK', 'Slovakia', 'admin/resources/flags/sk.png', 'SK', 0, 0),
(210, 'SVN', 'Slovenia', 'admin/resources/flags/si.png', 'SI', 0, 0),
(211, 'SWE', 'Sweden', 'admin/resources/flags/se.png', 'SE', 0, 0),
(212, 'SWZ', 'Swaziland', 'admin/resources/flags/sz.png', 'SZ', 0, 0),
(213, 'SXM', 'Sint Maarten', 'admin/resources/flags/sx.png', 'SX', 0, 0),
(214, 'SYC', 'Seychelles', 'admin/resources/flags/sc.png', 'SC', 0, 0),
(215, 'SYR', 'Syria', 'admin/resources/flags/sy.png', 'SY', 0, 0),
(216, 'TCA', 'Turks and Caicos Islands', 'admin/resources/flags/tc.png', 'TC', 0, 0),
(217, 'TCD', 'Chad', 'admin/resources/flags/td.png', 'TD', 0, 0),
(218, 'TGO', 'Togo', 'admin/resources/flags/tg.png', 'TG', 0, 0),
(219, 'THA', 'Thailand', 'admin/resources/flags/th.png', 'TH', 0, 0),
(220, 'TJK', 'Tajikistan', 'admin/resources/flags/tj.png', 'TJ', 0, 0),
(221, 'TKL', 'Tokelau', 'admin/resources/flags/tk.png', 'TK', 0, 0),
(222, 'TKM', 'Turkmenistan', 'admin/resources/flags/tm.png', 'TM', 0, 0),
(223, 'TLS', 'East Timor', 'admin/resources/flags/tl.png', 'TL', 0, 0),
(224, 'TON', 'Tonga', 'admin/resources/flags/to.png', 'TO', 0, 0),
(225, 'TTO', 'Trinidad and Tobago', 'admin/resources/flags/tt.png', 'TT', 0, 0),
(226, 'TUN', 'Tunisia', 'admin/resources/flags/tn.png', 'TN', 0, 0),
(227, 'TUR', 'Turkey', 'admin/resources/flags/tr.png', 'TR', 0, 0),
(228, 'TUV', 'Tuvalu', 'admin/resources/flags/tv.png', 'TV', 0, 0),
(229, 'TWN', 'Taiwan', 'admin/resources/flags/tw.png', 'TW', 0, 0),
(230, 'TZA', 'Tanzania', 'admin/resources/flags/tz.png', 'TZ', 0, 0),
(231, 'UGA', 'Uganda', 'admin/resources/flags/ug.png', 'UG', 0, 0),
(232, 'UKR', 'Ukraine', 'admin/resources/flags/ua.png', 'UA', 0, 0),
(233, 'UMI', 'U.S. Minor Outlying Islands', 'admin/resources/flags/um.png', 'UM', 0, 0),
(234, 'URY', 'Uruguay', 'admin/resources/flags/uy.png', 'UY', 0, 0),
(235, 'USA', 'United States', 'admin/resources/flags/us.png', 'US', 0, 0),
(236, 'UZB', 'Uzbekistan', 'admin/resources/flags/uz.png', 'UZ', 0, 0),
(237, 'VAT', 'Vatican City', 'admin/resources/flags/va.png', 'VA', 0, 0),
(238, 'VCT', 'Saint Vincent and the Grenadines', 'admin/resources/flags/vc.png', 'VC', 0, 0),
(239, 'VEN', 'Venezuela', 'admin/resources/flags/ve.png', 'VE', 0, 0),
(240, 'VGB', 'British Virgin Islands', 'admin/resources/flags/vg.png', 'VG', 0, 0),
(241, 'VIR', 'U.S. Virgin Islands', 'admin/resources/flags/vi.png', 'VI', 0, 0),
(242, 'VNM', 'Vietnam', 'admin/resources/flags/vn.png', 'VN', 0, 1),
(243, 'VUT', 'Vanuatu', 'admin/resources/flags/vu.png', 'VU', 0, 0),
(244, 'WLF', 'Wallis and Futuna', 'admin/resources/flags/wf.png', 'WF', 0, 0),
(245, 'WSM', 'Samoa', 'admin/resources/flags/ws.png', 'WS', 0, 0),
(246, 'XKX', 'Kosovo', 'admin/resources/flags/xk.png', 'XK', 0, 0),
(247, 'YEM', 'Yemen', 'admin/resources/flags/ye.png', 'YE', 0, 0),
(248, 'ZAF', 'South Africa', 'admin/resources/flags/za.png', 'ZA', 0, 0),
(249, 'ZMB', 'Zambia', 'admin/resources/flags/zm.png', 'ZM', 0, 0),
(250, 'ZWE', 'Zimbabwe', 'admin/resources/flags/zw.png', 'ZW', 0, 0);

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

--
-- Table structure for table `woobooking_currency`
--

DROP TABLE IF EXISTS `woobooking_currency`;
CREATE TABLE `woobooking_currency` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `code` varchar(4) NOT NULL,
  `symbol` varchar(2) NOT NULL,
  `rate` float NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_currency`
--

INSERT INTO `woobooking_currency` (`id`, `name`, `code`, `symbol`, `rate`, `ordering`) VALUES
(1, 'USD', 'USD', '$', 0, 0),
(2, 'EUR', 'EUR', '€', 0, 0),
(4, 'JPY', 'JPY', '¥', 0, 0);

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

--
-- Table structure for table `woobooking_customer`
--

DROP TABLE IF EXISTS `woobooking_customer`;
CREATE TABLE `woobooking_customer` (
  `id` int(11) NOT NULL,
  `user_open_source_commerce_id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `image` varchar(255) NOT NULL,
  `opensource_user_id` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `created_date` datetime NOT NULL,
  `address` varchar(255) NOT NULL,
  `post_code` varchar(255) NOT NULL,
  `city` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `birth_day` varchar(200) NOT NULL,
  `ordering` int(10) NOT NULL,
  `note_internal` varchar(500) NOT NULL,
  `country_id` int(11) NOT NULL,
  `company` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_customer`
--

INSERT INTO `woobooking_customer` (`id`, `user_open_source_commerce_id`, `first_name`, `last_name`, `image`, `opensource_user_id`, `phone`, `created_date`, `address`, `post_code`, `city`, `email`, `gender`, `birth_day`, `ordering`, `note_internal`, `country_id`, `company`) VALUES
(1, 0, 'Nguyen', 'Bac', '', '', '258741369', '2020-08-25 08:53:52', 'Address Line 2', '', '', 'bacng@gmail.com', '', '', 0, 'aaaaaaaaaaaaaa', 0, ''),
(10, 0, 'Chuong', 'Nguyen', '', '', '0848989810', '2020-11-05 09:30:56', '10 Hang Thung street', '', '', 'chuong.hnfwt@gmail.com', '', '', 0, 'a', 0, ''),
(12, 0, 'Aiko', 'Dudley', '', '', '+1 (461) 778-6838', '2020-11-13 03:19:57', 'Itaque ad perferendi', '', '', 'tienngguyen@gmail,com', '', '', 0, 'Aliquid quia in et a', 0, ''),
(13, 0, 'Faith', 'Burton', '', '', '+1 (847) 919-3464', '2020-11-13 03:34:55', 'Do sapiente dicta la', '', '', 'tienngguyen@gmail.com', '', '', 0, 'Quam qui nostssadsrum dol', 0, ''),
(14, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:36:04', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'sdadsa', 0, ''),
(15, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:37:11', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'sdadsa', 0, ''),
(16, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:38:26', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'sdadsa', 0, ''),
(17, 0, 'Selma', 'Cardenas', '', '', '+1 (102) 552-9844', '2020-11-13 03:44:06', 'Voluptatibus nostrum', '', '', 'tienngguyen@gmail.com', '', '', 0, 'Voluptatem dolore li', 0, ''),
(18, 0, 'Harper', 'Petersen', '', '', '+1 (754) 557-6758', '2020-11-13 03:46:58', 'Quisquam quidem iste', '', '', 'tienngguyen@gmail.com', '', '', 0, 'Et id veritatis fuga', 0, ''),
(19, 0, 'Harper', 'Petersen', '', '', '+1 (754) 557-6758', '2020-11-13 03:54:23', 'Quisquam quidem iste', '', '', 'tienngguyen@gmail.com', '', '', 0, 'Et id veritatis fuga', 0, ''),
(20, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:55:37', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'ewrew', 0, ''),
(21, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:56:49', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'ewrew', 0, ''),
(22, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:58:38', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'ewrew', 0, ''),
(23, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 03:58:55', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'tienngguyen@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(24, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:01:25', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(25, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:02:26', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(26, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:05:56', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(27, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:07:21', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(28, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:08:40', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(29, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:09:22', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(30, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:12:52', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(31, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:13:25', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(32, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:14:14', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(33, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:14:28', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(34, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:21:05', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(35, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:21:37', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(36, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:23:21', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(37, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:23:27', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(38, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:23:59', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(39, 0, 'Nguyễn Thị', 'Xuân', '', '', '+93961650611', '2020-11-13 04:26:21', '402- Bạch Mai-Phường Thanh Nhàn- TP Nội', '', '', 'chienbmq@gmail.com', '', '', 0, 'dsadsa', 0, ''),
(40, 0, 'Xaviera', 'Pacheco', '', '', '+1 (265) 994-5173', '2020-12-14 03:59:51', 'Laborum tempore min', '', '', 'ryfava@mailinator.com', '', '', 0, 'Dignissimos sapiente', 0, ''),
(41, 0, 'Xaviera', 'Pacheco', '', '', '+1 (265) 994-5173', '2020-12-14 04:01:08', 'Laborum tempore min', '', '', 'ryfava@mailinator.com', '', '', 0, 'Dignissimos sapiente', 0, ''),
(42, 0, 'Jolie', 'Howell', '', '', '+1 (595) 146-6255', '2020-12-14 04:27:32', 'Error dolorem aliqui', '', '', 'dumyfi@mailinator.com', '', '', 0, 'Sit culpa quia mole', 0, '');

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

--
-- Table structure for table `woobooking_customize`
--

DROP TABLE IF EXISTS `woobooking_customize`;
CREATE TABLE `woobooking_customize` (
  `id` int(11) UNSIGNED NOT NULL,
  `table_view` varchar(200) NOT NULL,
  `label_field` varchar(200) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL,
  `backend` int(5) NOT NULL,
  `frontend` int(5) NOT NULL,
  `default_value` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_email`
--

DROP TABLE IF EXISTS `woobooking_email`;
CREATE TABLE `woobooking_email` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `name` varchar(200) NOT NULL,
  `subject` text NOT NULL,
  `params` mediumtext NOT NULL,
  `type` varchar(50) NOT NULL,
  `published` int(11) NOT NULL,
  `content` mediumtext NOT NULL,
  `description` text NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_email`
--

INSERT INTO `woobooking_email` (`id`, `image`, `name`, `subject`, `params`, `type`, `published`, `content`, `description`, `ordering`) VALUES
(1, '', 'Send Email info', 'Confim your contact', '', 'send_info_tour_config', 0, 'Hi {customer_first_name}  {customer_last_name}\r\n\r\nYou recently visited our <a href=\"http://booking.cmsmart.net\">[Real Estate]</a>. We have received information about the property that interests you, the agent will contact and answer the problem.\r\n\r\nThank best regards !', 'Send Email info', 0),
(2, '', 'real_estat', '12321', '', 'first_send', 0, 'hi', 'dsada', 0);

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

--
-- Table structure for table `woobooking_emailaccount`
--

DROP TABLE IF EXISTS `woobooking_emailaccount`;
CREATE TABLE `woobooking_emailaccount` (
  `id` int(11) NOT NULL,
  `mailer` varchar(30) NOT NULL,
  `port` int(11) NOT NULL,
  `host` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_emailaccount`
--

INSERT INTO `woobooking_emailaccount` (`id`, `mailer`, `port`, `host`, `username`, `password`) VALUES
(1, 'smtp', 25, 'smtp.gmail.com', 'tienngguyen@gmail.com', 'alsaxuqixrzderew');

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

--
-- Table structure for table `woobooking_gallery`
--

DROP TABLE IF EXISTS `woobooking_gallery`;
CREATE TABLE `woobooking_gallery` (
  `id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `object_id` int(11) NOT NULL,
  `path` varchar(300) NOT NULL,
  `name` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_gallery`
--

INSERT INTO `woobooking_gallery` (`id`, `type`, `object_id`, `path`, `name`, `alias`, `description`) VALUES
(57, 'real_estate', 16, 'upload/gallery/realestate/x9hOO6ynRioHouse.jpg', 'RioHouse.jpg', '', ''),
(58, 'real_estate', 16, 'upload/gallery/realestate/mnF3UUogRioHouse2.jpg', 'RioHouse2.jpg', '', ''),
(59, 'real_estate', 16, 'upload/gallery/realestate/D8rilLmrRioHouse3.jpg', 'RioHouse3.jpg', '', ''),
(60, 'real_estate', 16, 'upload/gallery/realestate/y8jomOp7RioHouse4.jpg', 'RioHouse4.jpg', '', ''),
(65, 'real_estate', 18, 'upload/gallery/realestate/LjzAx6a1BrandyHill2.jpg', 'BrandyHill2.jpg', '', ''),
(66, 'real_estate', 18, 'upload/gallery/realestate/KmFmnZRFBrandyHill3.jpg', 'BrandyHill3.jpg', '', ''),
(67, 'real_estate', 18, 'upload/gallery/realestate/INGbWrr6BrandyHill4.jpg', 'BrandyHill4.jpg', '', ''),
(68, 'real_estate', 18, 'upload/gallery/realestate/AspWnuHoBrandyHill5.jpg', 'BrandyHill5.jpg', '', ''),
(187, 'real_estate', 7, 'upload/gallery/realestate/8Z9zoMnJNew-smyrna-resort1.jpg', 'New-smyrna-resort1.jpg', '', ''),
(227, 'real_estate', 19, 'upload/gallery/realestate/upHylE4FTownhouse1.jpg', 'Townhouse1.jpg', '', ''),
(247, 'real_estate', 1, 'upload/gallery/realestate/RctrMs0H3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '', ''),
(248, 'real_estate', 1, 'upload/gallery/realestate/1Whv56Rf3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '', ''),
(249, 'real_estate', 1, 'upload/gallery/realestate/AXjpEvAp8-storey-residential-condo-building-with-swimming-pool-middle-building_37282-895.jpg', '8-storey-residential-condo-building-with-swimming-pool-middle-building_37282-895.jpg', '', ''),
(250, 'real_estate', 1, 'upload/gallery/realestate/1uP0yoHbbeautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828.jpg', 'beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828.jpg', '', ''),
(251, 'real_estate', 2, 'upload/gallery/realestate/PzXTR3Xechairs-put-table-room-with-patterned-carpet_181624-17396.jpg', 'chairs-put-table-room-with-patterned-carpet_181624-17396.jpg', '', ''),
(252, 'real_estate', 2, 'upload/gallery/realestate/wVEWUpu7cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', 'cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', '', ''),
(253, 'real_estate', 2, 'upload/gallery/realestate/FUtAGqWZbeautiful-luxury-outdoor-swimming-pool-hotel-resort_74190-7433.jpg', 'beautiful-luxury-outdoor-swimming-pool-hotel-resort_74190-7433.jpg', '', ''),
(254, 'real_estate', 3, 'upload/gallery/realestate/9GbVO4kEloft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg', 'loft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg', '', ''),
(255, 'real_estate', 3, 'upload/gallery/realestate/ZXWUv50cluxury-classic-modern-bedroom-suite-hotel_105762-1787.jpg', 'luxury-classic-modern-bedroom-suite-hotel_105762-1787.jpg', '', ''),
(256, 'real_estate', 3, 'upload/gallery/realestate/QHIXTRHPmodern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', 'modern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', '', ''),
(257, 'real_estate', 3, 'upload/gallery/realestate/uuaxhkKXinterior-poster-living-room-kitchen_46483-543.jpg', 'interior-poster-living-room-kitchen_46483-543.jpg', '', ''),
(258, 'real_estate', 4, 'upload/gallery/realestate/OyysTuAuscandinavian-interior-living-room_33739-220.jpg', 'scandinavian-interior-living-room_33739-220.jpg', '', ''),
(259, 'real_estate', 4, 'upload/gallery/realestate/fHpeeXyslobby-living-room-hotel_1150-11124.jpg', 'lobby-living-room-hotel_1150-11124.jpg', '', ''),
(260, 'real_estate', 4, 'upload/gallery/realestate/Fb4O5RGZbeautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', 'beautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', '', ''),
(261, 'real_estate', 4, 'upload/gallery/realestate/6pMJj447illustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(262, 'real_estate', 5, 'upload/gallery/realestate/Wi1G6UW0swimming-pool-resort_1150-10729.jpg', 'swimming-pool-resort_1150-10729.jpg', '', ''),
(263, 'real_estate', 5, 'upload/gallery/realestate/oTrrUDlKbeautiful-shot-modern-house-staircase_181624-3129.jpg', 'beautiful-shot-modern-house-staircase_181624-3129.jpg', '', ''),
(264, 'real_estate', 5, 'upload/gallery/realestate/kLCA7URUbeach-luxury-living-sea-view-3d-rendering_48271-58.jpg', 'beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', '', ''),
(265, 'real_estate', 5, 'upload/gallery/realestate/jJLgvRzbillustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(266, 'real_estate', 5, 'upload/gallery/realestate/24sDFSGichairs-put-table-room-with-patterned-carpet_181624-17396.jpg', 'chairs-put-table-room-with-patterned-carpet_181624-17396.jpg', '', ''),
(268, 'real_estate', 6, 'upload/gallery/realestate/ebuMbDYmsuburban-housing-garden_53876-30332.jpg', 'suburban-housing-garden_53876-30332.jpg', '', ''),
(269, 'real_estate', 6, 'upload/gallery/realestate/B6B1XRrymodern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', 'modern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', '', ''),
(270, 'real_estate', 6, 'upload/gallery/realestate/kWUlgzhh3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '', ''),
(271, 'real_estate', 7, 'upload/gallery/realestate/9eiJCLdMspa-salon-with-beach-view_53876-31335.jpg', 'spa-salon-with-beach-view_53876-31335.jpg', '', ''),
(272, 'real_estate', 7, 'upload/gallery/realestate/BAXBRIYsbeautiful-tropical-beach-sea-with-umbrella-chair-around-swimming-pool_74190-1071.jpg', 'beautiful-tropical-beach-sea-with-umbrella-chair-around-swimming-pool_74190-1071.jpg', '', ''),
(273, 'real_estate', 7, 'upload/gallery/realestate/V1zjStVowoman-lying-pool-bent-palm-tree-trunk_79295-1651.jpg', 'woman-lying-pool-bent-palm-tree-trunk_79295-1651.jpg', '', ''),
(274, 'real_estate', 7, 'upload/gallery/realestate/cw0Yjzjbwooden-porch_90839-297.jpg', 'wooden-porch_90839-297.jpg', '', ''),
(275, 'real_estate', 8, 'upload/gallery/realestate/eL8YQALdswimming-pool-resort_1150-10729.jpg', 'swimming-pool-resort_1150-10729.jpg', '', ''),
(276, 'real_estate', 8, 'upload/gallery/realestate/GEHyvNQ63d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '', ''),
(277, 'real_estate', 8, 'upload/gallery/realestate/IzSx4WEybeautiful-modern-house-cement-view-from-garden_1127-3209.jpg', 'beautiful-modern-house-cement-view-from-garden_1127-3209.jpg', '', ''),
(278, 'real_estate', 8, 'upload/gallery/realestate/AhTCpadUinterior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', 'interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', '', ''),
(279, 'real_estate', 9, 'upload/gallery/realestate/sfEs7gqIhome-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', 'home-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', '', ''),
(281, 'real_estate', 9, 'upload/gallery/realestate/1IGWzBVjcozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', 'cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', '', ''),
(282, 'real_estate', 9, 'upload/gallery/realestate/HygEBWVnchairs-put-table-room-with-patterned-carpet_181624-17396.jpg', 'chairs-put-table-room-with-patterned-carpet_181624-17396.jpg', '', ''),
(283, 'real_estate', 10, 'upload/gallery/realestate/3qmO44Tdswimming-pool_74190-7325.jpg', 'swimming-pool_74190-7325.jpg', '', ''),
(284, 'real_estate', 10, 'upload/gallery/realestate/dtixCFN1beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', 'beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', '', ''),
(285, 'real_estate', 10, 'upload/gallery/realestate/SlJkmobLhome-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', 'home-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', '', ''),
(286, 'real_estate', 10, 'upload/gallery/realestate/LHiqIwLaillustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(287, 'real_estate', 10, 'upload/gallery/realestate/6bY9y6Lvinterior-poster-living-room-kitchen_46483-543.jpg', 'interior-poster-living-room-kitchen_46483-543.jpg', '', ''),
(288, 'real_estate', 11, 'upload/gallery/realestate/VJA47sapmodern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', 'modern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', '', ''),
(289, 'real_estate', 11, 'upload/gallery/realestate/Ozwl4s9e3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg', '', ''),
(290, 'real_estate', 11, 'upload/gallery/realestate/Ry0rchvBinterior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', 'interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', '', ''),
(291, 'real_estate', 11, 'upload/gallery/realestate/Hod3QwSebeautiful-shot-modern-house-staircase_181624-3129.jpg', 'beautiful-shot-modern-house-staircase_181624-3129.jpg', '', ''),
(292, 'real_estate', 12, 'upload/gallery/realestate/13lz2cLBcozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', 'cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', '', ''),
(293, 'real_estate', 12, 'upload/gallery/realestate/qP9nkXKhchairs-put-table-room-with-patterned-carpet_181624-17396.jpg', 'chairs-put-table-room-with-patterned-carpet_181624-17396.jpg', '', ''),
(294, 'real_estate', 12, 'upload/gallery/realestate/AtW9PecNloft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg', 'loft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg', '', ''),
(295, 'real_estate', 13, 'upload/gallery/realestate/XvCXq6WAinterior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', 'interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', '', ''),
(296, 'real_estate', 13, 'upload/gallery/realestate/cSN0bTEWsuburban-housing-garden_53876-30332.jpg', 'suburban-housing-garden_53876-30332.jpg', '', ''),
(297, 'real_estate', 13, 'upload/gallery/realestate/DjHtzKY9scandinavian-interior-living-room_33739-220.jpg', 'scandinavian-interior-living-room_33739-220.jpg', '', ''),
(298, 'real_estate', 13, 'upload/gallery/realestate/TeqzrHoXbeautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', 'beautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', '', ''),
(299, 'real_estate', 14, 'upload/gallery/realestate/t1HcZWtrspa-salon-with-beach-view_53876-31335.jpg', 'spa-salon-with-beach-view_53876-31335.jpg', '', ''),
(300, 'real_estate', 14, 'upload/gallery/realestate/kSWq0RR5beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', 'beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', '', ''),
(301, 'real_estate', 14, 'upload/gallery/realestate/0QRV66km3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '', ''),
(302, 'real_estate', 14, 'upload/gallery/realestate/WIHQNcYjmodern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', 'modern-studio-apartment-design-with-bedroom-living-space_1262-12375.jpg', '', ''),
(303, 'real_estate', 15, 'upload/gallery/realestate/ReRdfVXJinterior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', 'interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg', '', ''),
(304, 'real_estate', 15, 'upload/gallery/realestate/6GJ12OM9interior-poster-living-room-kitchen_46483-543.jpg', 'interior-poster-living-room-kitchen_46483-543.jpg', '', ''),
(305, 'real_estate', 17, 'upload/gallery/realestate/RR5C5hPrbeach-luxury-living-sea-view-3d-rendering_48271-58.jpg', 'beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', '', ''),
(306, 'real_estate', 17, 'upload/gallery/realestate/uYEtdwAoumbrella-pool-chair_74190-1704.jpg', 'umbrella-pool-chair_74190-1704.jpg', '', ''),
(307, 'real_estate', 17, 'upload/gallery/realestate/Yhf3rVYQhuge-swimming-pool-near-hotel-resort-san-teodoro-sardinia_181624-9498.jpg', 'huge-swimming-pool-near-hotel-resort-san-teodoro-sardinia_181624-9498.jpg', '', ''),
(308, 'real_estate', 17, 'upload/gallery/realestate/dtsMRYhLsun-loungers-near-palms-swimming-pool_23-2148107912.jpg', 'sun-loungers-near-palms-swimming-pool_23-2148107912.jpg', '', ''),
(309, 'real_estate', 19, 'upload/gallery/realestate/x2zJoFA4white-chairs-beach-resort-famous-resort_146671-18886.jpg', 'white-chairs-beach-resort-famous-resort_146671-18886.jpg', '', ''),
(310, 'real_estate', 19, 'upload/gallery/realestate/OGvVdqcKrestaurant-setting-with-wooden-chairs-tables-beautiful-view_181624-9887.jpg', 'restaurant-setting-with-wooden-chairs-tables-beautiful-view_181624-9887.jpg', '', ''),
(311, 'real_estate', 19, 'upload/gallery/realestate/NZWNQ4X1swimming-pool-beach-luxury-hotel-outdoor-pools-spa-amara-dolce-vita-luxury-hotel-resort-tekirova-kemer-turkey_146671-18751.jpg', 'swimming-pool-beach-luxury-hotel-outdoor-pools-spa-amara-dolce-vita-luxury-hotel-resort-tekirova-kemer-turkey_146671-18751.jpg', '', ''),
(312, 'real_estate', 19, 'upload/gallery/realestate/PHZAAahhspa-salon-with-beach-view_53876-31335.jpg', 'spa-salon-with-beach-view_53876-31335.jpg', '', ''),
(313, 'real_estate', 20, 'upload/gallery/realestate/bDHHIy23beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', 'beach-luxury-living-sea-view-3d-rendering_48271-58.jpg', '', ''),
(314, 'real_estate', 20, 'upload/gallery/realestate/A5dqA0Ks3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '', ''),
(315, 'real_estate', 20, 'upload/gallery/realestate/LkgDkCkHbeautiful-modern-house-cement-view-from-garden_1127-3209.jpg', 'beautiful-modern-house-cement-view-from-garden_1127-3209.jpg', '', ''),
(316, 'real_estate', 21, 'upload/gallery/realestate/kjgY1HbMsuburban-housing-garden_53876-30332.jpg', 'suburban-housing-garden_53876-30332.jpg', '', ''),
(317, 'real_estate', 21, 'upload/gallery/realestate/8rQozFBqbeautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', 'beautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', '', ''),
(318, 'real_estate', 22, 'upload/gallery/realestate/ukIMbbpXbeautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', 'beautiful-shot-modern-house-kitchen-dining-room_181624-2870.jpg', '', ''),
(319, 'real_estate', 22, 'upload/gallery/realestate/n9vbC2TOluxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg', 'luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg', '', ''),
(320, 'real_estate', 22, 'upload/gallery/realestate/gQZTZXXicozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', 'cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg', '', ''),
(321, 'real_estate', 23, 'upload/gallery/realestate/LioLNNalswimming-pool_74190-7325.jpg', 'swimming-pool_74190-7325.jpg', '', ''),
(322, 'real_estate', 23, 'upload/gallery/realestate/hLlPvgomhome-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', 'home-house-exterior-design-showing-tropical-pool-villa-with-greenery-garden_41487-488.jpg', '', ''),
(323, 'real_estate', 23, 'upload/gallery/realestate/5FM260Xlluxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg', 'luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg', '', ''),
(324, 'real_estate', 23, 'upload/gallery/realestate/E3p7spTEillustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(325, 'real_estate', 9, 'upload/gallery/realestate/yJW6WTxS3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg', '', ''),
(326, 'real_estate', 12, 'upload/gallery/realestate/IEEsafjphammocks-with-palm-trees_1203-201.jpg', 'hammocks-with-palm-trees_1203-201.jpg', '', ''),
(327, 'real_estate', 15, 'upload/gallery/realestate/vrosQV2kinterior-exterior-design-luxury-pool-villa_176546-284.jpg', 'interior-exterior-design-luxury-pool-villa_176546-284.jpg', '', ''),
(328, 'real_estate', 15, 'upload/gallery/realestate/ODJyn8VNillustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(329, 'real_estate', 20, 'upload/gallery/realestate/22aVLByLillustration-bedroom-interior_252025-131857.jpg', 'illustration-bedroom-interior_252025-131857.jpg', '', ''),
(330, 'real_estate', 22, 'upload/gallery/realestate/S6YBlseabeautiful-luxury-outdoor-swimming-pool-hotel-resort_74190-7433.jpg', 'beautiful-luxury-outdoor-swimming-pool-hotel-resort_74190-7433.jpg', '', '');

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

--
-- Table structure for table `woobooking_groupuser`
--

DROP TABLE IF EXISTS `woobooking_groupuser`;
CREATE TABLE `woobooking_groupuser` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `role_user` text NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_groupuser`
--

INSERT INTO `woobooking_groupuser` (`id`, `name`, `role_user`, `alias`, `ordering`, `published`, `description`) VALUES
(1, 'Customer', '[]', 'customer', 0, 1, ''),
(2, 'Super admin', '{\"access_backend\":[\"watch\"],\"activities\":[\"watch\"],\"appointment\":[\"watch\"],\"block\":[\"watch\"],\"calendar\":[\"watch\"],\"category\":[\"watch\"],\"config\":[\"watch\"],\"countries\":[\"watch\"],\"customer\":[\"watch\"],\"customers\":[\"watch\"],\"customize\":[\"watch\"],\"dashboard\":[\"watch\"],\"employee\":[\"watch\"],\"event\":[\"watch\"],\"groupuser\":[\"watch\"],\"payment\":[\"watch\"],\"package\":[\"watch\"],\"orderstatus\":[\"watch\"],\"orderpackages\":[\"watch\"],\"location\":[\"watch\"],\"review\":[\"watch\"],\"service\":[\"watch\"],\"tool\":[\"watch\"],\"user\":[\"watch\"],\"wishlist\":[\"watch\"],\"sms\":[\"watch\"],\"smscontent\":[\"watch\"],\"states\":[\"watch\"]}', 'super-admin', 0, 1, ''),
(3, 'Admin', '{\"access_backend\":[\"watch\"],\"activities\":[\"watch\",\"edit\"],\"appointment\":[\"watch\",\"edit\"],\"block\":[\"watch\",\"edit\"],\"calendar\":[\"watch\",\"edit\"],\"customers\":[\"watch\",\"edit\"],\"customer\":[\"watch\",\"edit\"],\"config\":[\"watch\",\"edit\"],\"category\":[\"watch\",\"edit\"],\"customize\":[\"watch\",\"edit\"],\"dashboard\":[\"watch\",\"edit\"],\"employee\":[\"watch\",\"edit\"],\"countries\":[\"watch\",\"edit\"],\"event\":[\"watch\",\"edit\"],\"groupuser\":[\"watch\",\"edit\"],\"payment\":[\"watch\",\"edit\"],\"package\":[\"watch\",\"edit\"],\"orderstatus\":[\"watch\",\"edit\"],\"orderpackages\":[\"watch\",\"edit\"],\"location\":[\"watch\",\"edit\"],\"review\":[\"watch\",\"edit\"],\"service\":[\"watch\",\"edit\"],\"sms\":[\"watch\",\"edit\"],\"smscontent\":[\"watch\",\"edit\"],\"states\":[\"watch\",\"edit\"],\"tool\":[\"watch\",\"edit\"],\"user\":[\"watch\",\"edit\"],\"wishlist\":[\"watch\",\"edit\"]}', 'admin', 0, 1, ''),
(4, 'Staff', '{\"access_backend\":[\"watch\"],\"category\":[\"watch\",\"edit\"],\"employee\":[\"watch\",\"edit\"],\"service\":[\"watch\",\"edit\"]}', 'staff', 0, 1, ''),
(5, 'Vendor', '[]', 'vendor', 0, 1, ''),
(6, 'User', '[]', 'user', 0, 1, '');

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

--
-- Table structure for table `woobooking_location`
--

DROP TABLE IF EXISTS `woobooking_location`;
CREATE TABLE `woobooking_location` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `banner` varchar(400) NOT NULL,
  `image_location_avatar` varchar(400) NOT NULL,
  `map_image` varchar(400) NOT NULL,
  `address` varchar(200) NOT NULL,
  `mobile` int(15) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `state_id` int(11) NOT NULL,
  `lang` varchar(50) NOT NULL,
  `lat` varchar(50) NOT NULL,
  `iframe` text NOT NULL,
  `published` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `is_top_destination` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_location`
--

INSERT INTO `woobooking_location` (`id`, `name`, `banner`, `image_location_avatar`, `map_image`, `address`, `mobile`, `alias`, `state_id`, `lang`, `lat`, `iframe`, `published`, `ordering`, `image`, `description`, `is_top_destination`) VALUES
(1, 'Corniche Rd W', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Corniche Rd W - Al Ras Al Akhdar - Abu Dhabi ', 1234567890, '', 1, '54.346049', '24.477125', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14526.693381802499!2d54.317507!3d24.462116!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMjTCsDI3JzQzLjYiTiA1NMKwMTknMDMuMCJF!5e0!3m2!1svi!2sus!4v1594364041382!5m2!1svi!2sus\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(2, '5921 Valencia Cir', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '5921 Valencia Cir, Rancho Santa Fe, CA 92067, United States', 1234567890, '', 2, '-117.1861408', '32.99115294', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d19959.53250957003!2d54.318970111639864!3d24.45877761291158!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMjTCsDI3JzQzLjYiTiA1NMKwMTknMDMuMCJF!5e0!3m2!1svi!2sus!4v1594365084539!5m2!1svi!2sus\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(3, 'Via Vittorio Veneto', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Via Vittorio Veneto, 125, 00187 Roma RM, Italy', 1234567890, '', 3, '12.49000018', '41.90776479', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14124.602082318066!2d12.492074970025726!3d41.90722516561383!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x79f6a0a46f732437!2sThe%20Westin%20Excelsior%2C%20Rome!5e0!3m2!1svi!2s!4v1594365483087!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(4, '5th Avenue at', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '5th Avenue at, Central Park S, New York, NY 10022, United States', 1234567890, '', 4, '-73.97311457', '40.76450587', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d12087.555443640455!2d-73.9744877!3d40.7644691!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x61f6aa300ba8339d!2sThe%20Plaza%20-%20A%20Fairmont%20Managed%20Hotel!5e0!3m2!1svi!2s!4v1594368554280!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(5, '6 Tran Quang Khai', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '6 Tran Quang Khai street, Loc Tho province, Nha Trang city', 1234567890, '', 5, '109.1967818', '12.23371541', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d15596.87184024012!2d109.1967711!3d12.2335162!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x70f4bfe86099684d!2sAaron%20Hotel%20in%20Nha%20Trang!5e0!3m2!1svi!2s!4v1594369370883!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(6, 'Bai Bac', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Bai Bac, Son Tra, Da Nang city', 1234567890, '', 6, '108.3065443', '16.12231055', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d30663.587098319756!2d108.31163949580076!3d16.119970598113724!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x5ade8a2bd4daad0d!2sInterContinental%20%C4%90%C3%A0%20N%E1%BA%B5ng%20Sun%20Peninsula%20Resort!5e0!3m2!1svi!2s!4v1594370072646!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(7, 'Bai Dai, Ganh Dau Commune', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Bai Dai, Ganh Dau commune, Phu Quoc district, Kien Giang province, Vietnam', 1234567890, '', 7, '', '', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d251289.48605414064!2d103.81733648115075!3d10.229431408391035!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x31081e3b9fdc2f85%3A0x1a649fb7cb98ca00!2zVmlucGVhcmwgUmVzb3J0ICYgU3BhIFBow7ogUXXhu5Fj!5e0!3m2!1svi!2s!4v1594370794442!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 0),
(8, '1 Bay Dr', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '1 Bay Dr, Lahaina, HI 96761, United States', 1234567890, '', 8, '-156.6656935', '21.00158423', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14899.106655934715!2d-156.6645123!3d21.0015878!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x60995c95d25170bc!2sMontage%20Kapalua%20Bay!5e0!3m2!1svi!2s!4v1594371853991!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(9, 'Jumeirah St', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Jumeirah St - Umm Suqeim 3 - Dubai - United Arab Emirates', 1234567890, '', 9, '55.19254693', '25.14082364', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14447.308254806174!2d55.18567720375703!3d25.14153688717421!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xb3da71b879f0e038!2sBurj%20al-Arab!5e0!3m2!1svi!2s!4v1594372711876!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(10, 'Via Marina Grande', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Via Marina Grande, 225, 80076 Capri NA, Italy', 1234567890, '', 10, '14.23534414', '40.5575716', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d12125.127893931362!2d14.2354333!3d40.55745!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x1005561892d33fd0!2sJK%20Place%20Capri!5e0!3m2!1svi!2s!4v1594373458136!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 0),
(11, 'Überfahrtstraße 10', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Überfahrtstraße 10, 83700 Rottach-Egern, Germany', 1234567890, '', 11, '47.69671247', '11.75803264', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d10741.45946641033!2d11.757683!3d47.6967534!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xb3a4dd84981754db!2sAlthoff%20Seehotel%20%C3%9Cberfahrt!5e0!3m2!1svi!2s!4v1594377085800!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(12, 'Hainstraße 25', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Hainstraße 25, 61476 Kronberg im Taunus, Germany', 1234567890, '', 12, '8.513175712', '50.18791625', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d10218.039426235238!2d8.51011!3d50.189!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xc04518e6cf877fae!2zTMOidSDEkcOgaSBGcmllZHJpY2hzaG9m!5e0!3m2!1svi!2s!4v1594377516581!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 0),
(13, 'Av. Gov. Israel Pinheiro', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Av. Gov. Israel Pinheiro, 670, Tiradentes - MG, 36325-000, Brazil', 1234567890, '', 13, '-44.171941', '-21.12729508', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14886.49461014033!2d-44.1720161!3d-21.1275653!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xf9a6dafed168d1b5!2sPequena%20Tiradentes!5e0!3m2!1svi!2s!4v1594378112053!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 0),
(14, 'Praia de Botafogo', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Praia de Botafogo, 242 - Botafogo, Rio de Janeiro - RJ, 22250-040, Brazil', 1234567890, '', 14, '-43.18150279', '-22.94261812', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14696.803804935886!2d-43.1815147!3d-22.9428253!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x6791f9ffe75b3f70!2sYoo2%20Rio%20de%20Janeiro!5e0!3m2!1svi!2s!4v1594379107617!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 0),
(15, 'Bulevar Principe Alfonso von Hohenlohe', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Bulevar Principe Alfonso von Hohenlohe, s/n, 29602 Marbella, Málaga, Spain', 1234567890, '', 15, '-4.923446974', '36.5044621', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d12828.365670342822!2d-4.925774!3d36.5036553!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x6af7e97919a98ba6!2sPuente%20Romano%20Beach%20Resort%2C%20Marbella!5e0!3m2!1svi!2s!4v1594379629794!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(16, '12 Susukinobaba-Cho', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '12 Susukinobaba-Cho, Sagatenryuji Tsukurimichicho, Ukyo Ward, Kyoto, 616-8385, Japan', 1234567890, '', 16, '35.01338684', '135.6731608', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d26142.759160361933!2d135.65813388348388!3d35.01058761241226!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x3c803c520e1113d5!2sSuiran%2C%20a%20Luxury%20Collection%20Hotel%2C%20Kyoto!5e0!3m2!1svi!2s!4v1594607084415!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(17, 'Stoke Park', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'Stoke Park, Country Club, Spa and Hotel, Park Rd, Stoke Poges SL2 4PG, United Kingdom', 1234567890, '', 17, '-0.602654', '51.53511836', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d9927.24720494966!2d-0.6027291!3d51.5350116!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x3645056ee5208a9f!2sStoke%20Park!5e0!3m2!1svi!2s!4v1594607695311!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(18, '1312 Avenue Raymond Poincaré', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '1312 Avenue Raymond Poincaré, 06360 Èze, France', 1234567890, '', 18, '43.71837864', '7.374089985', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d11534.501436872524!2d7.3740582!3d43.7183342!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x40880801fb1e7fe4!2sH%C3%B4tel%20Cap-Estel!5e0!3m2!1svi!2s!4v1594608295140!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(19, '5 Raffles Ave', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', '5 Raffles Ave, Singapore 039797', 1234567890, '', 19, '1.290840965', '103.8583325', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d13416.680011978882!2d103.85903326110915!3d1.2927294670289835!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x2030f2353a974ed5!2sMandarin%20Oriental%20Singapore!5e0!3m2!1svi!2s!4v1594609779023!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1),
(20, 'R. Rodrigo da Fonseca 88', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'admin/app/assets/images/no-image.jpg', 'R. Rodrigo da Fonseca 88, 1099-039 Lisboa, Portugal', 1234567890, '', 20, '38.72570132', '-9.155258846', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d12450.606904538125!2d-9.1544683!3d38.7258043!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbb3814d406b9a9f1!2sHotel%20Ritz!5e0!3m2!1svi!2s!4v1594610390985!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'admin/app/assets/images/no-image.jpg', '', 1);

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

--
-- Table structure for table `woobooking_neighborhood`
--

DROP TABLE IF EXISTS `woobooking_neighborhood`;
CREATE TABLE `woobooking_neighborhood` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL,
  `savgfsad` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_neighborhood`
--

INSERT INTO `woobooking_neighborhood` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`, `savgfsad`) VALUES
(1, 'Shopping center', '', '', 0, 1, 'Shopping center', 0),
(2, 'Town center', '', '', 0, 1, 'Town center', 0),
(3, 'Hospital', '', '', 0, 1, 'Hospital', 0),
(4, 'Police station', '', '', 0, 1, 'Police station', 0),
(5, 'Train station', '', '', 0, 1, 'Train station', 0),
(6, 'Bus station', '', '', 0, 1, 'Bus station', 0),
(7, 'Airport', '', '', 0, 1, 'Bus station', 0),
(8, 'Coffe shop', '', '', 0, 1, 'Coffe shop', 0),
(9, 'Beach', '', '', 0, 1, 'Beach', 0),
(10, 'Cinema', '', '', 0, 1, 'Cinema', 0),
(11, 'Park', '', '', 0, 1, 'Park', 0),
(12, 'School', '', '', 0, 1, 'School', 0),
(13, 'Univercity', '', '', 0, 1, 'Univercity', 0),
(14, 'Super market', '', '', 0, 1, 'Super market', 0),
(15, 'Exhibition', '', '', 0, 1, 'Exhibition', 0);

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

--
-- Table structure for table `woobooking_order`
--

DROP TABLE IF EXISTS `woobooking_order`;
CREATE TABLE `woobooking_order` (
  `id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `real_estate_id` int(11) NOT NULL,
  `open_source_order_id` int(11) NOT NULL,
  `order_status_id` int(11) DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `total` double NOT NULL,
  `payment_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL,
  `discount_total` double NOT NULL,
  `discount_tax` float NOT NULL,
  `shipping_tax` float NOT NULL,
  `cart_tax` float NOT NULL,
  `total_tax` float NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_order`
--

INSERT INTO `woobooking_order` (`id`, `ordering`, `customer_id`, `real_estate_id`, `open_source_order_id`, `order_status_id`, `title`, `total`, `payment_id`, `staff_id`, `alias`, `data`, `discount_total`, `discount_tax`, `shipping_tax`, `cart_tax`, `total_tax`, `created_date`) VALUES
(1, 0, 1, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-08-25 08:53:52'),
(10, 0, 10, 1, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-05 09:30:56'),
(12, 0, 12, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:19:57'),
(13, 0, 13, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:34:55'),
(14, 0, 14, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:36:04'),
(15, 0, 15, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:37:11'),
(16, 0, 16, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:38:26'),
(17, 0, 17, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:44:06'),
(18, 0, 18, 3, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:46:58'),
(19, 0, 19, 3, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:54:23'),
(20, 0, 20, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:55:37'),
(21, 0, 21, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:56:49'),
(22, 0, 22, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:58:38'),
(23, 0, 23, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 03:58:55'),
(24, 0, 24, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:01:25'),
(25, 0, 25, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:02:26'),
(26, 0, 26, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:05:56'),
(27, 0, 27, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:07:21'),
(28, 0, 28, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:08:40'),
(29, 0, 29, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:09:22'),
(30, 0, 30, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:12:52'),
(31, 0, 31, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:13:25'),
(32, 0, 32, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:14:14'),
(33, 0, 33, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:14:28'),
(34, 0, 34, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:21:05'),
(35, 0, 35, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:21:37'),
(36, 0, 36, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:23:21'),
(37, 0, 37, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:23:27'),
(38, 0, 38, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:23:59'),
(39, 0, 39, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-11-13 04:26:21'),
(40, 0, 40, 0, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-12-14 03:59:51'),
(41, 0, 41, 0, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-12-14 04:01:08'),
(42, 0, 42, 2, 0, 3, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, '2020-12-14 04:27:32');

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

--
-- Table structure for table `woobooking_order_detail`
--

DROP TABLE IF EXISTS `woobooking_order_detail`;
CREATE TABLE `woobooking_order_detail` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `open_source_link_id` int(11) NOT NULL,
  `roomtype_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `number_adult` int(11) NOT NULL,
  `number_child` int(11) NOT NULL,
  `subtotal` float NOT NULL,
  `total` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_order_detail_rate`
--

DROP TABLE IF EXISTS `woobooking_order_detail_rate`;
CREATE TABLE `woobooking_order_detail_rate` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `check_in` datetime NOT NULL,
  `check_out` datetime NOT NULL,
  `open_source_link_id` int(11) NOT NULL,
  `roomtype_id` int(11) NOT NULL,
  `price_adult` float NOT NULL,
  `price_child` float NOT NULL,
  `price_service` float NOT NULL,
  `order_detail_id` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `number_adult` int(11) NOT NULL,
  `number_child` int(11) NOT NULL,
  `nights` int(11) NOT NULL,
  `subtotal` float NOT NULL,
  `total` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_order_status`
--

DROP TABLE IF EXISTS `woobooking_order_status`;
CREATE TABLE `woobooking_order_status` (
  `id` int(11) NOT NULL,
  `name` varchar(11) DEFAULT NULL,
  `published` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_order_status`
--

INSERT INTO `woobooking_order_status` (`id`, `name`, `published`, `ordering`, `alias`, `data`) VALUES
(1, 'Sold', 1, 0, 'sold', ''),
(2, 'Rented', 1, 0, 'rented', ''),
(3, 'Current', 1, 0, 'current', '');

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

--
-- Table structure for table `woobooking_permission`
--

DROP TABLE IF EXISTS `woobooking_permission`;
CREATE TABLE `woobooking_permission` (
  `id` int(11) UNSIGNED NOT NULL,
  `group_user_id` int(11) NOT NULL,
  `access_backend` tinyint(1) NOT NULL,
  `dashboard` text NOT NULL,
  `realestate` text NOT NULL,
  `propertytype` text NOT NULL,
  `agents` text NOT NULL,
  `category` text NOT NULL,
  `currencies` text NOT NULL,
  `amenity` text NOT NULL,
  `neighborhood` text NOT NULL,
  `sms` text NOT NULL,
  `smscontent` text NOT NULL,
  `countries` text NOT NULL,
  `states` text NOT NULL,
  `location` text NOT NULL,
  `customers` text NOT NULL,
  `customize` text NOT NULL,
  `groupuser` text NOT NULL,
  `user` text NOT NULL,
  `config` text NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_permission`
--

INSERT INTO `woobooking_permission` (`id`, `group_user_id`, `access_backend`, `dashboard`, `realestate`, `propertytype`, `agents`, `category`, `currencies`, `amenity`, `neighborhood`, `sms`, `smscontent`, `countries`, `states`, `location`, `customers`, `customize`, `groupuser`, `user`, `config`, `ordering`, `published`) VALUES
(17, 1, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0),
(20, 4, 0, '', '', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0),
(21, 5, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0),
(22, 6, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0),
(23, 2, 0, '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', 0, 0),
(24, 3, 0, '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', 0, 0);

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

--
-- Table structure for table `woobooking_property_type`
--

DROP TABLE IF EXISTS `woobooking_property_type`;
CREATE TABLE `woobooking_property_type` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `color_property` varchar(200) NOT NULL,
  `published` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_property_type`
--

INSERT INTO `woobooking_property_type` (`id`, `name`, `alias`, `color_property`, `published`, `image`, `ordering`, `description`) VALUES
(12, 'For Sale', 'for-sale', '#e6194b', 1, '', 0, ''),
(13, 'For Rent', 'for-rent', '#3cb44b', 1, '', 0, '');

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

--
-- Table structure for table `woobooking_real_estate`
--

DROP TABLE IF EXISTS `woobooking_real_estate`;
CREATE TABLE `woobooking_real_estate` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `price_for` float NOT NULL,
  `recurrent_select` varchar(200) NOT NULL,
  `date_built` date NOT NULL,
  `alias` varchar(200) NOT NULL,
  `meta_keyword` varchar(255) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL,
  `created_date` datetime NOT NULL,
  `floor_plan` mediumtext NOT NULL,
  `number_bedroom_floorplan` mediumtext NOT NULL,
  `number_bathroom_floorplan` mediumtext NOT NULL,
  `square_feet_floorplan` mediumtext NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `number_room` int(11) NOT NULL,
  `number_bathroom` int(11) NOT NULL,
  `number_bedroom` int(11) NOT NULL,
  `number_floor` int(11) NOT NULL,
  `square_feet` float NOT NULL,
  `lot_size` float NOT NULL,
  `distance` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_real_estate`
--

INSERT INTO `woobooking_real_estate` (`id`, `name`, `image`, `price_for`, `recurrent_select`, `date_built`, `alias`, `meta_keyword`, `meta_description`, `ordering`, `published`, `description`, `created_date`, `floor_plan`, `number_bedroom_floorplan`, `number_bathroom_floorplan`, `square_feet_floorplan`, `update_time`, `number_room`, `number_bathroom`, `number_bedroom`, `number_floor`, `square_feet`, `lot_size`, `distance`) VALUES
(1, 'Luxury Irvine', 'upload/realestate/images/cover/TcPugKGkexterior-modern-apartment-buildings-o_100656-377.jpg', 20000, 'all', '2015-07-01', 'Luxury Irvine', 'Luxury Irvine', 'Luxury Irvine', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vulputate nec neque gravida rhoncus. Donec sit amet blandit mauris, sed bibendum risus. Cras ut urna semper, facilisis augue sed, imperdiet nulla. Duis tristique tellus tortor, dapibus gravida sem sodales id. Nullam quis convallis libero, vitae pulvinar nisi.\r\n\r\nNam eget est facilisis, porta mi ac, ultricies enim. Proin nisi diam, eleifend ac eleifend in, dapibus in orci. Vestibulum elementum lectus non nisl venenatis, tempus molestie nisi tempus. Pellentesque facilisis nibh nec purus blandit, id aliquam lorem fermentum.\r\n\r\nUt erat lacus, sagittis ac leo eu, molestie mattis libero. Nam sit amet massa et magna porttitor eleifend a aliquam nunc. Pellentesque a est a augue dignissim tristique eu nec augue. Integer pretium sollicitudin tellus, quis hendrerit nunc accumsan et. Fusce bibendum a neque vel fringilla. Vivamus viverra enim at purus gravida, in elementum neque eleifend. Curabitur sodales dapibus urna, at mattis lacus eleifend non. Donec ultricies porta orci eu congue. Nulla sodales arcu a libero aliquet, nec aliquam ante sagittis.', '2020-07-29 07:06:26', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"450\"]', '2020-12-12 08:40:10', 0, 2, 4, 1, 450, 1000, 12472.1),
(2, 'Minden House', 'upload/realestate/images/cover/DWf0XvXRnew-block-modern-apartments-with-balconies-blue-sky-background_140282-4.jpg', 32000, 'per-month', '2013-07-01', 'minden-house', 'Minden House', 'Minden House', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In ultricieseleifend faucibus. Nunc a tincidunt elit. Duis ornare dui ut magna aliquet ullamcorper. Duis pharetra pellentesque arcu, vitae placerat ligula luctus sed. Nam cursus diam odio, a condimentum nulla imperdiet a.\r\nMauris dui sapien, fermentum at pulvinar non, rhoncus non est. Sed viverra turpis eget auctor consequat. Quisque sit amet varius ligula. Donec non ullamcorper orci, ac pellentesque lectus. Nam convallis dolor eu tincidunt pharetra.\r\nEtiam quis tortor pharetra, elementum ante atper pretium. Nam convallis dolor eu tincidunt pharetra.', '2020-07-29 07:25:54', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828.jpg\"]', '[\"2\"]', '[\"2\"]', '[\"343,000\"]', '2020-12-12 08:42:54', 0, 2, 2, 1, 342374, 343000, 8728.35),
(3, 'Garnavillo Apartment', 'upload/realestate/images/cover/amugckzAnew-residential-building_97070-112.jpg', 60000, 'per-month', '2018-07-01', 'garnavillo-apartment', 'Garnavillo Apartment', 'Garnavillo Apartment', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vulputate nec neque gravida rhoncus. Donec sit amet blandit mauris, sed bibendum risus. Cras ut urna semper, facilisis augue sed, imperdiet nulla. Duis tristique tellus tortor, dapibus gravida sem sodales id. Nullam quis convallis libero, vitae pulvinar nisi.\r\n\r\nNam eget est facilisis, porta mi ac, ultricies enim. Proin nisi diam, eleifend ac eleifend in, dapibus in orci. Vestibulum elementum lectus non nisl venenatis, tempus molestie nisi tempus. Pellentesque facilisis nibh nec purus blandit, id aliquam lorem fermentum.\r\n\r\nUt erat lacus, sagittis ac leo eu, molestie mattis libero. Nam sit amet massa et magna porttitor eleifend a aliquam nunc. Pellentesque a est a augue dignissim tristique eu nec augue. Integer pretium sollicitudin tellus, quis hendrerit nunc accumsan et. Fusce bibendum a neque vel fringilla. Vivamus viverra enim at purus gravida, in elementum neque eleifend. Curabitur sodales dapibus urna, at mattis lacus eleifend non. Donec ultricies porta orci eu congue. Nulla sodales arcu a libero aliquet, nec aliquam ante sagittis.', '2020-07-29 07:40:07', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/cozy-studio-apartment-with-bedroom-living-space_1262-12323.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/illustration-bedroom-interior_252025-131857.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"150000\",\"150000\"]', '2020-12-12 08:43:22', 0, 3, 4, 2, 300000, 320000, 16815.4),
(4, 'Lake City House', 'upload/realestate/images/cover/TJxggDtUseveral-two-story-brick-houses-made-timber_116124-468.jpg', 1300, 'per-month', '2015-07-01', 'lake-city-house', 'Lake City House', 'Lake City House', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In ultricieseleifend faucibus. Nunc a tincidunt elit. Duis ornare dui ut magna aliquet ullamcorper. Duis pharetra pellentesque arcu, vitae placerat ligula luctus sed. Nam cursus diam odio, a condimentum nulla imperdiet a.\r\nMauris dui sapien, fermentum at pulvinar non, rhoncus non est. Sed viverra turpis eget auctor consequat. Quisque sit amet varius ligula. Donec non ullamcorper orci, ac pellentesque lectus. Nam convallis dolor eu tincidunt pharetra.\r\nEtiam quis tortor pharetra, elementum ante atper pretium. Nam convallis dolor eu tincidunt pharetra.', '2020-07-29 07:48:08', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"300000\"]', '2020-12-12 08:51:46', 0, 2, 4, 1, 734232, 740000, 8726.62),
(5, 'Laguna Villa', 'upload/realestate/images/cover/mlQ4lmxLinterior-exterior-design-luxury-pool-villa_176546-284.jpg', 200000, 'all', '2017-07-03', 'laguna-villa', 'Laguna Villa', 'Laguna Villa', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vulputate nec neque gravida rhoncus. Donec sit amet blandit mauris, sed bibendum risus. Cras ut urna semper, facilisis augue sed, imperdiet nulla. Duis tristique tellus tortor, dapibus gravida sem sodales id. Nullam quis convallis libero, vitae pulvinar nisi.\r\n\r\nNam eget est facilisis, porta mi ac, ultricies enim. Proin nisi diam, eleifend ac eleifend in, dapibus in orci. Vestibulum elementum lectus non nisl venenatis, tempus molestie nisi tempus. Pellentesque facilisis nibh nec purus blandit, id aliquam lorem fermentum.\r\n\r\nUt erat lacus, sagittis ac leo eu, molestie mattis libero. Nam sit amet massa et magna porttitor eleifend a aliquam nunc. Pellentesque a est a augue dignissim tristique eu nec augue. Integer pretium sollicitudin tellus, quis hendrerit nunc accumsan et. Fusce bibendum a neque vel fringilla. Vivamus viverra enim at purus gravida, in elementum neque eleifend. Curabitur sodales dapibus urna, at mattis lacus eleifend non. Donec ultricies porta orci eu congue. Nulla sodales arcu a libero aliquet, nec aliquam ante sagittis.', '2020-07-29 07:55:42', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828-1.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/illustration-bedroom-interior_252025-131857.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"110000\",\"100000\"]', '2020-12-12 08:44:02', 0, 3, 4, 2, 200000, 210000, 10339.9),
(6, 'La Mirada House', 'upload/realestate/images/cover/V2kw1Byfcarport-modern-luxury-house_41487-786.jpg', 35000, 'all', '2016-07-01', 'la-mirada-house', 'La Mirada House', 'La Mirada House', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In ultricieseleifend faucibus. Nunc a tincidunt elit. Duis ornare dui ut magna aliquet ullamcorper. Duis pharetra pellentesque arcu, vitae placerat ligula luctus sed. Nam cursus diam odio, a condimentum nulla imperdiet a.\r\nMauris dui sapien, fermentum at pulvinar non, rhoncus non est. Sed viverra turpis eget auctor consequat. Quisque sit amet varius ligula. Donec non ullamcorper orci, ac pellentesque lectus. Nam convallis dolor eu tincidunt pharetra.\r\nEtiam quis tortor pharetra, elementum ante atper pretium. Nam convallis dolor eu tincidunt pharetra', '2020-07-29 08:08:48', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/interior-poster-living-room-kitchen_46483-543.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"46000\"]', '2020-12-12 08:44:18', 0, 2, 4, 1, 45486, 46000, 9261.21),
(7, 'New Smyrna Beach Resort', 'upload/realestate/images/cover/OaXCiHHzhuge-swimming-pool-near-hotel-resort-san-teodoro-sardinia_181624-9498.jpg', 100, 'per-month', '2018-07-01', 'new-smyrna-beach-resort', 'New Smyrna Beach Resort', 'New Smyrna Beach Resort', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vulputate nec neque gravida rhoncus. Donec sit amet blandit mauris, sed bibendum risus. Cras ut urna semper, facilisis augue sed, imperdiet nulla. Duis tristique tellus tortor, dapibus gravida sem sodales id. Nullam quis convallis libero, vitae pulvinar nisi.\r\n\r\nNam eget est facilisis, porta mi ac, ultricies enim. Proin nisi diam, eleifend ac eleifend in, dapibus in orci. Vestibulum elementum lectus non nisl venenatis, tempus molestie nisi tempus. Pellentesque facilisis nibh nec purus blandit, id aliquam lorem fermentum.\r\n\r\nUt erat lacus, sagittis ac leo eu, molestie mattis libero. Nam sit amet massa et magna porttitor eleifend a aliquam nunc. Pellentesque a est a augue dignissim tristique eu nec augue. Integer pretium sollicitudin tellus, quis hendrerit nunc accumsan et. Fusce bibendum a neque vel fringilla. Vivamus viverra enim at purus gravida, in elementum neque eleifend. Curabitur sodales dapibus urna, at mattis lacus eleifend non. Donec ultricies porta orci eu congue. Nulla sodales arcu a libero aliquet, nec aliquam ante sagittis.', '2020-07-29 08:17:51', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/interior-modern-apartment-decorated-comfortably-with-huge-windows_181624-18498.jpg\"]', '[\"3\"]', '[\"2\"]', '[\"220\"]', '2020-12-12 08:44:34', 0, 2, 3, 1, 200, 220, 6822.19),
(8, 'Shreveport House', 'upload/realestate/images/cover/XaRDrwenmodern-country-houses-construction_1385-20.jpg', 500000, 'all', '2015-07-01', 'shreveport-house', 'Shreveport House', 'Shreveport House', 0, 1, 'The design of Boston — a collection of seven secluded and impeccably crafted luxury residences — is inspired by the site’s intriguing history. In 1859, vigneron Andrew Murray bought 103 acres of land to realise his dream of producing world-class wines. He named his estate Balwyn, combining ‘Bal’ (Gaelic for home) and ‘Wyn’ (a Saxon word for vine) to create ‘the home of the vine’. Today, the renowned Mim Design strongly references this local story through the selection of wine-inspired colours and materials, imbuing each home with a sense of warmth and permanence.', '2020-07-29 08:31:20', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"220\"]', '2020-12-12 08:44:57', 0, 2, 4, 1, 400, 420, 9261.21),
(9, 'Mediterranean Villa', 'upload/realestate/images/cover/7axC2w0Xinterior-exterior-design-pool-villa-which-features-living-area_41487-217.jpg', 200000, 'all', '2011-07-01', 'mediterranean-villa', 'Mediterranean Villa', 'Mediterranean Villa', 0, 1, 'Tucked away in a secluded quiet cul-de-sac behind the most beautiful white picket fence sits this 100-year-old home that has never looked better.\r\nWith an extensive renovation completed by the current owners, there is nothing left to do here other than enjoy this beautiful home and maybe walk to work, if you work in the city.\r\nAs you approach the property the facade of the home is drop dead gorgeous with the original porch and well thought out colour scheme capturing your attention.', '2020-07-29 08:37:41', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/dining-area-comfortable-studio-flat-hotel-room_1262-12324.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"300\",\"200\"]', '2020-12-12 08:45:14', 0, 3, 4, 2, 400, 420, 13144.3),
(10, 'Lake Forest Villa', 'upload/realestate/images/cover/Rw4doohVspanish-real-estate-mediterranean-seashore_182029-376.jpg', 600000, 'all', '2012-07-01', 'lake-forest-villa', 'Lake Forest Villa', 'Lake Forest Villa', 0, 1, 'This proud art deco home is still shining after a very tasteful top to bottom renovation.\r\nIt takes a certain level of creativity and skill to blend original features with modern-day living, but the vendors here have absolutely nailed it.\r\nComo Crescent is a sleepy no-thru street with quality homes, friendly neighbours, and number seven has the perfect aspect to take in the beautiful mountain views and all-day sun.\r\nThe home boasts a versatile floor plan with high ceilings and generously proportioned rooms.\r\nThe new gourmet kitchen features stunning marble benchtops with waterfall ends, spacious pantry, gas cooktop, soft-close drawers and breakfast bar; home chefs will love cooking here.', '2020-07-29 08:44:26', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-dining-set-modern-luxury-dining-room_105762-1798.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"300\",\"200\"]', '2020-12-12 08:45:34', 0, 3, 4, 2, 500, 520, 12472.1),
(11, 'Bourbonnais Villa', 'upload/realestate/images/cover/rIwjfumyremote-accomadtion_1308-4874.jpg', 700000, 'all', '2016-07-01', 'bourbonnais-villa', 'Bourbonnais Villa', 'Bourbonnais Villa', 0, 1, 'Victoria & Burke is an exclusive collection of just 16 residences perfectly located in Camberwell – Melbourne’s most affluent and highly sought-after inner-eastern suburb.\r\nIdeal for downsizers and professionals looking to secure an expertly designed home that exudes quality, functionality and style, Victoria & Burke epitomises the best of luxury apartment living. Thanks to the uniquely superior quality and location of Victoria & Burke, interest has remained high – so now is the ideal time to buy one of these residences, all of which represent a never-to-be-repeated property opportunity.\r\nApartments at Victoria & Burke feature breathtaking views of the Melbourne skyline, creating a sense of immense space in every home. The floor-to-ceiling windows perfectly frame these vistas, while highlighting the artfully curated interiors within.\r\nDesigned by acclaimed firm Carr Design, the natural, monolithic stone of the benchtops, splashbacks and bathrooms is complemented by the highest quality Gaggenau and Liebherr appliances – creating the perfect amalgamation of style and function.\r\nPlush wool carpets and refined timber detailing provide luxurious comfort, showcasing the attention to detail that has gone into crafting each aspect of every residence at Victoria & Burke.', '2020-07-29 08:53:04', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828-2.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"1000\"]', '2020-12-12 08:45:50', 0, 2, 4, 1, 1000, 1100, 13144.3),
(12, 'Lahaina Apartment', 'upload/realestate/images/cover/FB3JuFgR8-storey-residential-condo-building-with-swimming-pool-middle-building_37282-895.jpg', 700000, 'all', '2010-07-01', 'lahaina-apartment', 'Lahaina Apartment', 'Lahaina Apartment', 0, 1, 'This large family home is ideally located for easy commute yet a world away from the hustle and bustle! City train, University, Westfield and koalas! It\'s all at your fingertips here!\r\nThis home has been lovingly designed and built by a master craftsman, with a quality and attention to detail rarely seen these days. The home has been freshly painted and had new carpet laid throughout.\r\nThe house sits high on the 8,200 allotment. A huge salt (infinity edge) pool, large 4 bay shed, spacious verandahs and gardens make this house a home!\r\nThere\'s a wonderful tennis court size flat area for kids to play footy, soccer, have friends over to camp, or just hang out. Shaded by surrounding gum trees, and visible from the front verandah, so Mum can keep an eye on proceedings. Suitable for tennis court installation for the serious tennis player.\r\n', '2020-07-29 09:03:39', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/loft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828-1.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"200\",\"150\"]', '2020-12-12 08:46:18', 0, 3, 4, 2, 1500, 1600, 9915.22),
(13, 'Halfmoon House', 'upload/realestate/images/cover/C17znxGWchildren-playing-by-beautiful-house_236854-6587.jpg', 590000, 'all', '2015-07-01', 'halfmoon-house', 'Halfmoon House', 'Halfmoon House', 0, 1, 'Spacious & lovingly maintained with an emphasis on easy home entertaining, this Heritage built home will be the one to pull at your heart strings.\r\nA must see for any family looking to put some space between the adults and the kids/teens, with the expansive master suite separated from the 3 secondary bedrooms. The master suite features his and her basins, an overly generous floor to ceiling walk through wardrobe & access to the pool area. Comfort is key here, with all secondary bedrooms offering ceiling fans, ducted air & built in robes.\r\nA short stroll down the grand entrance will bring you to the double door entrance of the enormous media room, separated from the other entertaining areas for the perfect cinematic experience. Continuing to heart of the home is the light filled and breezy open plan living and dining space, both areas include ducted air, fans and pool views.\r\nThe heart of the home, A.K.A, the kitchen has something to please everybody. Including a ridiculous amount of storage and bench space, plumbed fridge space, dishwasher, gas cooktop and a clever servery window for the convenience of alfresco entertaining. Not to mention, the study nook with room for 2 - so you can help the kids with their homework while cooking or working from home with easy access to the main bedroom or kitchen.\r\nThe expansive alfresco entertaining area effortlessly integrates your indoor and outdoor entertaining spaces (this means you can simultaneously check the footy score & keep an eye on the kids while they swim). Relax under cover, splash in the saltwater pool, fall asleep in the sun poolside to the sound of water feature or sneak off down the side of the home for a quiet cuppa on your own.', '2020-07-29 09:11:33', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/illustration-bedroom-interior_252025-131857.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"200\",\"200\"]', '2020-12-12 08:46:35', 0, 3, 4, 2, 500, 520, 9261.21),
(14, 'Linwood House', 'upload/realestate/images/cover/8XIcvlifaerial-view-private-houses-with-solar-panels-roofs_181624-14567.jpg', 800000, 'all', '2020-07-29', 'linwood-house', 'Linwood House', 'Linwood House', 0, 1, 'Our sellers have taken a contract that is subject to sale of the buyers home however they are looking to be out by Christmas.\r\nTime for you to take a look at this gem and activate the sunset clause to make it yours.\r\nThis stunning larger than life home offers an outstanding lifestyle in the ever popular Norfolk Lakes estate. Beautifully designed with neutral tones, elegant fixtures & fittings, with a free flow floor plan allowing for effortless living. Yet allows each member of the family to enjoy their own pocket of the home\r\nThe amazing lifestyle offers the perfect marriage between inside and out.', '2020-07-29 09:22:36', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617-1.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"700\"]', '2020-12-12 08:46:48', 0, 2, 4, 1, 700, 750, 8726.62),
(15, 'Yorkville House', 'upload/realestate/images/cover/FQEOJ0Yghouse-isolated-field_1303-23773.jpg', 5000, 'per-month', '2013-07-01', 'yorkville-house', 'Yorkville House', 'Yorkville House', 0, 1, 'Fantastic home sitting on a huge 668m2 allotment close to parkland in a handy central location, this property represents a fantastic buying opportunity on the peninsula for the trade’s person, large extended family or for the possibility to work from home.\r\n\r\nThe shed is a multi-purpose space featuring an extra high roller door, it is insulated, airconditioned and has its own toilet and change room area.\r\nCurrently used as a home Gym and chill out zone for the current family.\r\nYour potential uses of this area are endless, why not create a \"Man Cave\", Workshop or perhaps make into a \"Granny Flat\" (subject to approval)\r\nSituated moments from schools, shops, transport and all amenities this one really is a winner.', '2020-07-29 09:29:55', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxurious-living-room-loft-villa-apartment-penthouse_41487-669.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"400\"]', '2020-12-12 08:47:00', 0, 2, 4, 1, 500, 520, 13144.3),
(17, 'Cliftton Park Villa', 'upload/realestate/images/cover/ioJniot7spanish-real-estate-mediterranean-seashore_182029-376.jpg', 5000, 'per-month', '2018-07-01', 'cliftton-park-villa', 'Cliftton Park Villa', 'Cliftton Park Villa', 0, 1, 'Luxurious, brand new home in exclusive community\r\nSophisticated comfort and design are brought together in this luxurious brand-new family home, located in the highly sought after \'Kirkdale Residences\', enjoying elevation and beautiful green outlooks. Walk to Chapel Hill State School, local shops and CBD transport.', '2020-07-29 09:45:24', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/illustration-bedroom-interior_252025-131857.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"600\",\"400\"]', '2020-12-12 08:47:15', 0, 3, 4, 2, 600, 650, 8054.01),
(19, 'Town House', 'upload/realestate/images/cover/jp1oqH0Fswimming-pool-exotic-tropical-resort-exotic-garden_179755-6066.jpg', 10000, 'all', '2020-07-29', 'town-house', 'Town House', 'Town House', 0, 1, 'In a premier heritage homes and tree-lined seaside avenue, 150m level walk to Manly Beach, this freestanding double-fronted Federation home presents exciting scope for transformation to a stunning contemporary residence using DA approved plans for alterations and additions.\r\n\r\nCelebrating the tranquillity of its idyllic coastal setting, the architect designed plans exemplify indoor-outdoor living with a laidback sense of luxury over two sun-drenched levels.\r\n\r\nWith a north side aspect, the 411sqm dual-access property at \'Manly Flats\' features a private rear garden and double garage opening to Pacific Lane.\r\n\r\nRetaining the traditional façade of the c1903 home, the DA approved plans include spacious open-plan kitchen, dining and living areas flowing to a central north-facing courtyard and landscaped rear garden. Eco-friendly design principles reference the beachside setting, while the living area dimensions are amplified by a soaring 4m high ceiling. The entire upper level is a master bedroom suite with dressing area, ensuite, sun terrace and fire place. At entry level are 2 more double bedrooms, 2 more bathrooms (one ensuite) and laundry.\r\n\r\nUse the DA approved plans or live in the existing house with a wide front verandah, 3 bedrooms with home office or 4 bedrooms, 3 bathrooms, living room, modern kitchen and casual living/dining area opening to a tropical rear garden and secure garage. Option to redesign 4 car approved garage to 2 car garage with self-contained studio above (STCA).\r\n\r\nEnjoy the ultimate beachside lifestyle in one of areas best addresses with a level walk to the beach, cafes, dining, shopping, schools, buses, Manly Swim Centre, Manly Golf Club and Manly Ferry Wharf.', '2020-07-29 10:00:50', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828-2.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/loft-luxury-living-room-with-bookshelf-near-dining-table_105762-1796.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"600\",\"600\"]', '2020-12-12 08:47:29', 0, 3, 4, 2, 600, 620, 10339.9),
(20, 'Spring House', 'upload/realestate/images/cover/JQiqogpfswimming-pool_74190-7325.jpg', 10000, 'per-month', '2018-07-01', 'spring-house', 'Spring House', 'Spring House', 0, 1, 'For the first time in 32 years, a truly rare opportunity has become available to explore and secure Alkoomi; an exquisite lifestyle package located in a blue ribbon suburb defined by its semi rural ambience and close proximity to quality schools, beautiful beaches and the very best of the Central Coast lifestyle while being only 90 minutes from Sydney. Arriving at the gates of Alkoomi and entering onto the pristine, parklike grounds youll be enveloped by total tranquillity as you take in 12.5 lush, North facing acres and a perfectly positioned, architecturally designed home meticulously crafted to take full advantage of the expansive acreage vista from every room.\r\n\r\nNature lovers will find everything here that their hearts can desire from being greeted in the mornings by the sounds of whipbirds in the bush and wallabies grazing in the paddocks, to summer evenings spent by the creek with spectacular firefly displays. Every corner of this incredible property offers a different view from so many places to sit, relax and soak in the serenity and sensational valley views.', '2020-07-29 10:08:29', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/beautiful-interior-shot-modern-house-with-white-relaxing-walls-furniture-technology_181624-3828-1.jpg\"]', '[\"4\"]', '[\"2\"]', '[\"1000\"]', '2020-12-12 08:47:41', 0, 2, 4, 1, 1000, 1200, 8054.01),
(21, 'Arrowhead Hill', 'upload/realestate/images/cover/PD5jZZH7couple-moving-new-house_33842-29.jpg', 10000, 'per-month', '2019-07-01', 'arrowhead-hill', 'Arrowhead Hill', 'Arrowhead Hill', 0, 1, 'Classic and timeless, this stunning newly completed Hamptons-inspired home occupies a commanding position in a peaceful, tightly held bay. Its spacious decks are bathed in year-long sunshine and perfect for entertaining, offering captivating views across Pittwater to Ku-ring-gai National Park.', '2020-07-29 10:18:18', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617-1.jpg\"]', '[\"2\"]', '[\"1\"]', '[\"150\"]', '2020-12-12 08:47:51', 0, 1, 2, 1, 500, 520, 8634.67),
(22, 'Tustin House', 'upload/realestate/images/cover/8EeVYTx8beautiful-shot-fence-leading-house-green-grass-area_181624-18255.jpg', 50000, 'per-month', '2009-09-10', 'tustin-house', 'Tustin House', 'Tustin House', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In ultricieseleifend faucibus. Nunc a tincidunt elit. Duis ornare dui ut magna aliquet ullamcorper. Duis pharetra pellentesque arcu, vitae placerat ligula luctus sed. Nam cursus diam odio, a condimentum nulla imperdiet a.\r\nMauris dui sapien, fermentum at pulvinar non, rhoncus non est. Sed viverra turpis eget auctor consequat. Quisque sit amet varius ligula. Donec non ullamcorper orci, ac pellentesque lectus. Nam convallis dolor eu tincidunt pharetra.\r\nEtiam quis tortor pharetra, elementum ante atper pretium. Nam convallis dolor eu tincidunt pharetra.', '2020-09-04 04:16:55', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxury-classic-modern-bedroom-suite-hotel_105762-1787.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/interior-poster-living-room-kitchen_46483-543.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"342,374\",\"343,000\"]', '2020-12-12 08:48:11', 0, 3, 4, 2, 342374, 343000, 12472.1),
(23, 'Yorba Hill', 'upload/realestate/images/cover/zdQX0xhTclimate-landscape-paradise-hotel-sunset_1203-5734.jpg', 50000, 'per-month', '2010-09-02', 'yorba-hill', 'Yorba Hill', 'Yorba Hill', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vulputate nec neque gravida rhoncus. Donec sit amet blandit mauris, sed bibendum risus. Cras ut urna semper, facilisis augue sed, imperdiet nulla. Duis tristique tellus tortor, dapibus gravida sem sodales id. Nullam quis convallis libero, vitae pulvinar nisi.\r\n\r\nNam eget est facilisis, porta mi ac, ultricies enim. Proin nisi diam, eleifend ac eleifend in, dapibus in orci. Vestibulum elementum lectus non nisl venenatis, tempus molestie nisi tempus. Pellentesque facilisis nibh nec purus blandit, id aliquam lorem fermentum.\r\n\r\nUt erat lacus, sagittis ac leo eu, molestie mattis libero. Nam sit amet massa et magna porttitor eleifend a aliquam nunc. Pellentesque a est a augue dignissim tristique eu nec augue. Integer pretium sollicitudin tellus, quis hendrerit nunc accumsan et. Fusce bibendum a neque vel fringilla. Vivamus viverra enim at purus gravida, in elementum neque eleifend. Curabitur sodales dapibus urna, at mattis lacus eleifend non. Donec ultricies porta orci eu congue. Nulla sodales arcu a libero aliquet, nec aliquam ante sagittis.', '2020-09-04 04:20:01', '[\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/3d-rendering-wood-classic-living-room-with-marble-tile-bookshelf_105762-617-1.jpg\",\"http:\\/\\/demo12.cmsmart.net\\/booking_real_estate\\/wp-content\\/uploads\\/2020\\/12\\/luxurious-living-room-loft-villa-apartment-penthouse_41487-669-1.jpg\"]', '[\"4\",\"0\"]', '[\"2\",\"1\"]', '[\"450\",\"450\"]', '2020-12-12 08:48:30', 0, 3, 4, 2, 450, 450, 9261.21);

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

--
-- Table structure for table `woobooking_real_estate_property`
--

DROP TABLE IF EXISTS `woobooking_real_estate_property`;
CREATE TABLE `woobooking_real_estate_property` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `object_id` int(11) NOT NULL,
  `real_estate_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `distance_between` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_real_estate_property`
--

INSERT INTO `woobooking_real_estate_property` (`id`, `type`, `object_id`, `real_estate_id`, `description`, `distance_between`) VALUES
(358, 'destination', 14, 16, '', 0),
(359, 'property_type', 13, 16, '', 0),
(360, 'category', 1, 16, '', 0),
(361, 'agent', 2, 16, '', 0),
(362, 'neighborhood', 1, 16, '', 2000),
(363, 'neighborhood', 3, 16, '', 2000),
(364, 'neighborhood', 4, 16, '', 3000),
(365, 'neighborhood', 8, 16, '', 500),
(366, 'neighborhood', 12, 16, '', 2000),
(367, 'amenity', 1, 16, '', 0),
(368, 'amenity', 2, 16, '', 0),
(369, 'amenity', 3, 16, '', 0),
(370, 'amenity', 10, 16, '', 0),
(371, 'amenity', 13, 16, '', 0),
(372, 'amenity', 14, 16, '', 0),
(512, 'destination', 8, 18, '', 0),
(513, 'property_type', 13, 18, '', 0),
(514, 'category', 4, 18, '', 0),
(515, 'agent', 5, 18, '', 0),
(516, 'neighborhood', 1, 18, '', 2000),
(517, 'neighborhood', 5, 18, '', 3000),
(518, 'neighborhood', 8, 18, '', 300),
(519, 'neighborhood', 9, 18, '', 2000),
(520, 'neighborhood', 11, 18, '', 500),
(521, 'amenity', 1, 18, '', 0),
(522, 'amenity', 2, 18, '', 0),
(523, 'amenity', 3, 18, '', 0),
(524, 'amenity', 5, 18, '', 0),
(525, 'amenity', 9, 18, '', 0),
(526, 'amenity', 10, 18, '', 0),
(527, 'amenity', 13, 18, '', 0),
(3498, 'destination', 2, 1, '', 0),
(3499, 'property_type', 12, 1, '', 0),
(3500, 'category', 1, 1, '', 0),
(3501, 'agent', 1, 1, '', 0),
(3502, 'neighborhood', 1, 1, '', 200),
(3503, 'neighborhood', 2, 1, '', 1000),
(3504, 'neighborhood', 3, 1, '', 300),
(3505, 'neighborhood', 12, 1, '', 500),
(3506, 'neighborhood', 4, 1, '', 2000),
(3507, 'amenity', 1, 1, '', 0),
(3508, 'amenity', 2, 1, '', 0),
(3509, 'amenity', 3, 1, '', 0),
(3510, 'amenity', 4, 1, '', 0),
(3511, 'amenity', 6, 1, '', 0),
(3512, 'amenity', 8, 1, '', 0),
(3513, 'amenity', 10, 1, '', 0),
(3514, 'amenity', 11, 1, '', 0),
(3515, 'destination', 3, 2, '', 0),
(3516, 'property_type', 13, 2, '', 0),
(3517, 'category', 2, 2, '', 0),
(3518, 'agent', 3, 2, '', 0),
(3519, 'neighborhood', 1, 2, '', 300),
(3520, 'neighborhood', 2, 2, '', 500),
(3521, 'neighborhood', 4, 2, '', 1000),
(3522, 'neighborhood', 8, 2, '', 200),
(3523, 'neighborhood', 12, 2, '', 500),
(3524, 'neighborhood', 11, 2, '', 300),
(3525, 'amenity', 1, 2, '', 0),
(3526, 'amenity', 2, 2, '', 0),
(3527, 'amenity', 3, 2, '', 0),
(3528, 'amenity', 4, 2, '', 0),
(3529, 'amenity', 5, 2, '', 0),
(3530, 'amenity', 6, 2, '', 0),
(3531, 'amenity', 7, 2, '', 0),
(3532, 'amenity', 10, 2, '', 0),
(3533, 'destination', 14, 3, '', 0),
(3534, 'property_type', 13, 3, '', 0),
(3535, 'category', 1, 3, '', 0),
(3536, 'agent', 3, 3, '', 0),
(3537, 'neighborhood', 1, 3, '', 300),
(3538, 'neighborhood', 2, 3, '', 400),
(3539, 'neighborhood', 3, 3, '', 500),
(3540, 'neighborhood', 4, 3, '', 1000),
(3541, 'neighborhood', 8, 3, '', 200),
(3542, 'neighborhood', 6, 3, '', 50),
(3543, 'neighborhood', 12, 3, '', 300),
(3544, 'amenity', 1, 3, '', 0),
(3545, 'amenity', 2, 3, '', 0),
(3546, 'amenity', 3, 3, '', 0),
(3547, 'amenity', 5, 3, '', 0),
(3548, 'amenity', 7, 3, '', 0),
(3549, 'amenity', 10, 3, '', 0),
(3550, 'amenity', 11, 3, '', 0),
(3551, 'destination', 15, 5, '', 0),
(3552, 'property_type', 12, 5, '', 0),
(3553, 'category', 3, 5, '', 0),
(3554, 'agent', 5, 5, '', 0),
(3555, 'neighborhood', 1, 5, '', 300),
(3556, 'neighborhood', 3, 5, '', 400),
(3557, 'neighborhood', 4, 5, '', 500),
(3558, 'neighborhood', 8, 5, '', 100),
(3559, 'neighborhood', 12, 5, '', 1000),
(3560, 'neighborhood', 9, 5, '', 2000),
(3561, 'amenity', 1, 5, '', 0),
(3562, 'amenity', 2, 5, '', 0),
(3563, 'amenity', 3, 5, '', 0),
(3564, 'amenity', 5, 5, '', 0),
(3565, 'amenity', 9, 5, '', 0),
(3566, 'amenity', 10, 5, '', 0),
(3567, 'amenity', 11, 5, '', 0),
(3568, 'amenity', 15, 5, '', 0),
(3569, 'destination', 17, 6, '', 0),
(3570, 'property_type', 12, 6, '', 0),
(3571, 'category', 2, 6, '', 0),
(3572, 'agent', 6, 6, '', 0),
(3573, 'neighborhood', 1, 6, '', 300),
(3574, 'neighborhood', 7, 6, '', 2000),
(3575, 'neighborhood', 8, 6, '', 200),
(3576, 'neighborhood', 9, 6, '', 1000),
(3577, 'neighborhood', 11, 6, '', 500),
(3578, 'neighborhood', 12, 6, '', 1000),
(3579, 'neighborhood', 14, 6, '', 500),
(3580, 'amenity', 1, 6, '', 0),
(3581, 'amenity', 2, 6, '', 0),
(3582, 'amenity', 8, 6, '', 0),
(3583, 'amenity', 9, 6, '', 0),
(3584, 'amenity', 10, 6, '', 0),
(3585, 'amenity', 12, 6, '', 0),
(3586, 'amenity', 13, 6, '', 0),
(3587, 'destination', 18, 7, '', 0),
(3588, 'property_type', 13, 7, '', 0),
(3589, 'category', 4, 7, '', 0),
(3590, 'agent', 4, 7, '', 0),
(3591, 'neighborhood', 2, 7, '', 1000),
(3592, 'neighborhood', 3, 7, '', 1000),
(3593, 'neighborhood', 9, 7, '', 2000),
(3594, 'neighborhood', 12, 7, '', 1000),
(3595, 'neighborhood', 6, 7, '', 50),
(3596, 'neighborhood', 14, 7, '', 500),
(3597, 'amenity', 1, 7, '', 0),
(3598, 'amenity', 2, 7, '', 0),
(3599, 'amenity', 3, 7, '', 0),
(3600, 'amenity', 4, 7, '', 0),
(3601, 'amenity', 9, 7, '', 0),
(3602, 'amenity', 10, 7, '', 0),
(3603, 'amenity', 13, 7, '', 0),
(3604, 'destination', 17, 8, '', 0),
(3605, 'property_type', 12, 8, '', 0),
(3606, 'category', 2, 8, '', 0),
(3607, 'agent', 1, 8, '', 0),
(3608, 'neighborhood', 1, 8, '', 300),
(3609, 'neighborhood', 2, 8, '', 500),
(3610, 'neighborhood', 3, 8, '', 1000),
(3611, 'neighborhood', 8, 8, '', 200),
(3612, 'neighborhood', 14, 8, '', 500),
(3613, 'neighborhood', 12, 8, '', 2000),
(3614, 'amenity', 1, 8, '', 0),
(3615, 'amenity', 2, 8, '', 0),
(3616, 'amenity', 3, 8, '', 0),
(3617, 'amenity', 4, 8, '', 0),
(3618, 'amenity', 5, 8, '', 0),
(3619, 'amenity', 8, 8, '', 0),
(3620, 'amenity', 10, 8, '', 0),
(3621, 'destination', 4, 9, '', 0),
(3622, 'property_type', 12, 9, '', 0),
(3623, 'category', 3, 9, '', 0),
(3624, 'agent', 5, 9, '', 0),
(3625, 'neighborhood', 3, 9, '', 2000),
(3626, 'neighborhood', 6, 9, '', 30),
(3627, 'neighborhood', 12, 9, '', 1000),
(3628, 'neighborhood', 14, 9, '', 500),
(3629, 'neighborhood', 11, 9, '', 500),
(3630, 'neighborhood', 4, 9, '', 1000),
(3631, 'amenity', 1, 9, '', 0),
(3632, 'amenity', 2, 9, '', 0),
(3633, 'amenity', 3, 9, '', 0),
(3634, 'amenity', 5, 9, '', 0),
(3635, 'amenity', 8, 9, '', 0),
(3636, 'amenity', 10, 9, '', 0),
(3637, 'amenity', 12, 9, '', 0),
(3638, 'destination', 2, 10, '', 0),
(3639, 'property_type', 12, 10, '', 0),
(3640, 'category', 3, 10, '', 0),
(3641, 'agent', 2, 10, '', 0),
(3642, 'neighborhood', 3, 10, '', 1000),
(3643, 'neighborhood', 4, 10, '', 2000),
(3644, 'neighborhood', 14, 10, '', 500),
(3645, 'neighborhood', 11, 10, '', 300),
(3646, 'neighborhood', 12, 10, '', 1000),
(3647, 'amenity', 1, 10, '', 0),
(3648, 'amenity', 2, 10, '', 0),
(3649, 'amenity', 3, 10, '', 0),
(3650, 'amenity', 4, 10, '', 0),
(3651, 'amenity', 5, 10, '', 0),
(3652, 'amenity', 8, 10, '', 0),
(3653, 'amenity', 9, 10, '', 0),
(3654, 'amenity', 10, 10, '', 0),
(3655, 'destination', 4, 11, '', 0),
(3656, 'property_type', 12, 11, '', 0),
(3657, 'category', 3, 11, '', 0),
(3658, 'agent', 1, 11, '', 0),
(3659, 'neighborhood', 1, 11, '', 1000),
(3660, 'neighborhood', 4, 11, '', 1000),
(3661, 'neighborhood', 3, 11, '', 2000),
(3662, 'neighborhood', 14, 11, '', 500),
(3663, 'neighborhood', 12, 11, '', 2000),
(3664, 'amenity', 1, 11, '', 0),
(3665, 'amenity', 2, 11, '', 0),
(3666, 'amenity', 3, 11, '', 0),
(3667, 'amenity', 4, 11, '', 0),
(3668, 'amenity', 5, 11, '', 0),
(3669, 'amenity', 11, 11, '', 0),
(3670, 'amenity', 12, 11, '', 0),
(3671, 'amenity', 13, 11, '', 0),
(3672, 'destination', 8, 12, '', 0),
(3673, 'property_type', 12, 12, '', 0),
(3674, 'category', 1, 12, '', 0),
(3675, 'agent', 4, 12, '', 0),
(3676, 'neighborhood', 1, 12, '', 2000),
(3677, 'neighborhood', 3, 12, '', 1000),
(3678, 'neighborhood', 4, 12, '', 2000),
(3679, 'neighborhood', 12, 12, '', 1000),
(3680, 'neighborhood', 14, 12, '', 300),
(3681, 'neighborhood', 8, 12, '', 500),
(3682, 'amenity', 1, 12, '', 0),
(3683, 'amenity', 2, 12, '', 0),
(3684, 'amenity', 3, 12, '', 0),
(3685, 'amenity', 4, 12, '', 0),
(3686, 'amenity', 5, 12, '', 0),
(3687, 'amenity', 8, 12, '', 0),
(3688, 'amenity', 10, 12, '', 0),
(3689, 'amenity', 11, 12, '', 0),
(3690, 'amenity', 15, 12, '', 0),
(3691, 'destination', 17, 13, '', 0),
(3692, 'property_type', 12, 13, '', 0),
(3693, 'category', 2, 13, '', 0),
(3694, 'agent', 5, 13, '', 0),
(3695, 'neighborhood', 1, 13, '', 2000),
(3696, 'neighborhood', 3, 13, '', 2000),
(3697, 'neighborhood', 4, 13, '', 3000),
(3698, 'neighborhood', 7, 13, '', 5000),
(3699, 'neighborhood', 8, 13, '', 300),
(3700, 'neighborhood', 14, 13, '', 500),
(3701, 'amenity', 1, 13, '', 0),
(3702, 'amenity', 2, 13, '', 0),
(3703, 'amenity', 3, 13, '', 0),
(3704, 'amenity', 4, 13, '', 0),
(3705, 'amenity', 5, 13, '', 0),
(3706, 'amenity', 8, 13, '', 0),
(3707, 'amenity', 10, 13, '', 0),
(3708, 'amenity', 14, 13, '', 0),
(3709, 'destination', 12, 14, '', 0),
(3710, 'property_type', 12, 14, '', 0),
(3711, 'category', 2, 14, '', 0),
(3712, 'agent', 5, 14, '', 0),
(3713, 'neighborhood', 1, 14, '', 2000),
(3714, 'neighborhood', 3, 14, '', 3000000),
(3715, 'neighborhood', 8, 14, '', 500),
(3716, 'neighborhood', 12, 14, '', 2000),
(3717, 'neighborhood', 14, 14, '', 300),
(3718, 'amenity', 1, 14, '', 0),
(3719, 'amenity', 3, 14, '', 0),
(3720, 'amenity', 5, 14, '', 0),
(3721, 'amenity', 6, 14, '', 0),
(3722, 'amenity', 9, 14, '', 0),
(3723, 'amenity', 10, 14, '', 0),
(3724, 'destination', 4, 15, '', 0),
(3725, 'property_type', 13, 15, '', 0),
(3726, 'category', 2, 15, '', 0),
(3727, 'agent', 5, 15, '', 0),
(3728, 'neighborhood', 1, 15, '', 2000),
(3729, 'neighborhood', 11, 15, '', 500),
(3730, 'neighborhood', 14, 15, '', 300),
(3731, 'neighborhood', 8, 15, '', 500),
(3732, 'neighborhood', 3, 15, '', 2000),
(3733, 'neighborhood', 4, 15, '', 2000),
(3734, 'amenity', 1, 15, '', 0),
(3735, 'amenity', 2, 15, '', 0),
(3736, 'amenity', 4, 15, '', 0),
(3737, 'amenity', 5, 15, '', 0),
(3738, 'amenity', 10, 15, '', 0),
(3739, 'amenity', 14, 15, '', 0),
(3740, 'amenity', 16, 15, '', 0),
(3741, 'destination', 20, 17, '', 0),
(3742, 'property_type', 13, 17, '', 0),
(3743, 'category', 3, 17, '', 0),
(3744, 'agent', 5, 17, '', 0),
(3745, 'neighborhood', 1, 17, '', 2000),
(3746, 'neighborhood', 3, 17, '', 1000),
(3747, 'neighborhood', 14, 17, '', 500),
(3748, 'neighborhood', 8, 17, '', 300),
(3749, 'neighborhood', 12, 17, '', 1000),
(3750, 'amenity', 1, 17, '', 0),
(3751, 'amenity', 2, 17, '', 0),
(3752, 'amenity', 4, 17, '', 0),
(3753, 'amenity', 5, 17, '', 0),
(3754, 'amenity', 9, 17, '', 0),
(3755, 'amenity', 10, 17, '', 0),
(3756, 'destination', 15, 19, '', 0),
(3757, 'property_type', 12, 19, '', 0),
(3758, 'category', 3, 19, '', 0),
(3759, 'agent', 4, 19, '', 0),
(3760, 'neighborhood', 1, 19, '', 2000),
(3761, 'neighborhood', 2, 19, '', 1000),
(3762, 'neighborhood', 3, 19, '', 2000),
(3763, 'neighborhood', 4, 19, '', 1000),
(3764, 'neighborhood', 11, 19, '', 500),
(3765, 'neighborhood', 12, 19, '', 1000),
(3766, 'amenity', 1, 19, '', 0),
(3767, 'amenity', 2, 19, '', 0),
(3768, 'amenity', 3, 19, '', 0),
(3769, 'amenity', 4, 19, '', 0),
(3770, 'amenity', 7, 19, '', 0),
(3771, 'amenity', 9, 19, '', 0),
(3772, 'amenity', 10, 19, '', 0),
(3773, 'amenity', 13, 19, '', 0),
(3774, 'destination', 20, 20, '', 0),
(3775, 'property_type', 13, 20, '', 0),
(3776, 'category', 2, 20, '', 0),
(3777, 'agent', 1, 20, '', 0),
(3778, 'neighborhood', 1, 20, '', 2000),
(3779, 'neighborhood', 3, 20, '', 2000),
(3780, 'neighborhood', 9, 20, '', 2000),
(3781, 'neighborhood', 11, 20, '', 300),
(3782, 'neighborhood', 7, 20, '', 5000),
(3783, 'neighborhood', 8, 20, '', 1000),
(3784, 'amenity', 1, 20, '', 0),
(3785, 'amenity', 2, 20, '', 0),
(3786, 'amenity', 3, 20, '', 0),
(3787, 'amenity', 4, 20, '', 0),
(3788, 'amenity', 6, 20, '', 0),
(3789, 'amenity', 10, 20, '', 0),
(3790, 'amenity', 15, 20, '', 0),
(3791, 'destination', 10, 21, '', 0),
(3792, 'property_type', 13, 21, '', 0),
(3793, 'category', 2, 21, '', 0),
(3794, 'agent', 3, 21, '', 0),
(3795, 'neighborhood', 1, 21, '', 2000),
(3796, 'neighborhood', 2, 21, '', 1000),
(3797, 'neighborhood', 5, 21, '', 2000),
(3798, 'neighborhood', 7, 21, '', 6000),
(3799, 'neighborhood', 11, 21, '', 500),
(3800, 'neighborhood', 14, 21, '', 500),
(3801, 'amenity', 1, 21, '', 0),
(3802, 'amenity', 2, 21, '', 0),
(3803, 'amenity', 3, 21, '', 0),
(3804, 'amenity', 4, 21, '', 0),
(3805, 'amenity', 7, 21, '', 0),
(3806, 'amenity', 11, 21, '', 0),
(3807, 'amenity', 13, 21, '', 0),
(3808, 'destination', 2, 22, '', 0),
(3809, 'property_type', 13, 22, '', 0),
(3810, 'category', 2, 22, '', 0),
(3811, 'agent', 6, 22, '', 0),
(3812, 'neighborhood', 1, 22, '', 500),
(3813, 'neighborhood', 3, 22, '', 1000),
(3814, 'neighborhood', 2, 22, '', 2000),
(3815, 'neighborhood', 5, 22, '', 500),
(3816, 'neighborhood', 9, 22, '', 2000),
(3817, 'amenity', 1, 22, '', 0),
(3818, 'amenity', 2, 22, '', 0),
(3819, 'amenity', 3, 22, '', 0),
(3820, 'amenity', 4, 22, '', 0),
(3821, 'amenity', 5, 22, '', 0),
(3822, 'amenity', 6, 22, '', 0),
(3823, 'amenity', 7, 22, '', 0),
(3824, 'amenity', 10, 22, '', 0),
(3825, 'destination', 17, 23, '', 0),
(3826, 'property_type', 12, 23, '', 0),
(3827, 'category', 3, 23, '', 0),
(3828, 'agent', 1, 23, '', 0),
(3829, 'neighborhood', 3, 23, '', 2000),
(3830, 'neighborhood', 4, 23, '', 2000),
(3831, 'neighborhood', 7, 23, '', 10000),
(3832, 'neighborhood', 14, 23, '', 300),
(3833, 'neighborhood', 12, 23, '', 2000),
(3834, 'amenity', 1, 23, '', 0),
(3835, 'amenity', 2, 23, '', 0),
(3836, 'amenity', 3, 23, '', 0),
(3837, 'amenity', 4, 23, '', 0),
(3838, 'amenity', 8, 23, '', 0),
(3839, 'amenity', 10, 23, '', 0),
(3840, 'amenity', 11, 23, '', 0),
(3841, 'destination', 12, 4, '', 0),
(3842, 'property_type', 13, 4, '', 0),
(3843, 'category', 2, 4, '', 0),
(3844, 'agent', 4, 4, '', 0),
(3845, 'neighborhood', 1, 4, '', 300),
(3846, 'neighborhood', 15, 4, '', 400),
(3847, 'neighborhood', 14, 4, '', 100),
(3848, 'neighborhood', 3, 4, '', 500),
(3849, 'neighborhood', 12, 4, '', 200),
(3850, 'neighborhood', 6, 4, '', 30),
(3851, 'amenity', 1, 4, '', 0),
(3852, 'amenity', 2, 4, '', 0),
(3853, 'amenity', 3, 4, '', 0),
(3854, 'amenity', 4, 4, '', 0),
(3855, 'amenity', 5, 4, '', 0),
(3856, 'amenity', 8, 4, '', 0),
(3857, 'amenity', 10, 4, '', 0),
(3858, 'amenity', 11, 4, '', 0);

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

--
-- Table structure for table `woobooking_review`
--

DROP TABLE IF EXISTS `woobooking_review`;
CREATE TABLE `woobooking_review` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `comments` text NOT NULL,
  `created_date` datetime NOT NULL,
  `rating_ambience` float NOT NULL,
  `rating_cleanliness` float NOT NULL,
  `rating_staff` float NOT NULL,
  `rating_value` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_review`
--

INSERT INTO `woobooking_review` (`id`, `name`, `email`, `title`, `ordering`, `published`, `comments`, `created_date`, `rating_ambience`, `rating_cleanliness`, `rating_staff`, `rating_value`) VALUES
(1, 'Mohammed', 'mohammed@gmail.com', 'Perfect', 0, 1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', '2020-08-02 16:24:48', 5, 5, 5, 5),
(2, 'Mr.Jone', 'Jone@gmail.com', 'wonderful! Feeling very comfortable when usin', 0, 1, 'wonderful! Feeling very comfortable when usin', '2020-09-08 02:13:06', 5, 5, 5, 5),
(3, 'Mr Simple ', 'Simple@gmail.com', 'wonderful!', 0, 1, 'wonderful! Feeling very comfortable when using this service, I will definitely come back with my family', '2020-09-08 02:14:12', 5, 5, 5, 5),
(4, 'Thomas Tom', 'Thomas@gmail.com', 'I will definitely recommend it to my friends', 0, 1, 'I am very satisfied with the service and the staff, I will definitely recommend it to my friends', '2020-09-08 02:16:11', 4, 5, 5, 5),
(5, 'Marry Role', 'Role@gmail.com', 'Good service, enthusiastic', 0, 1, 'Good service, enthusiastic, highly skilled team will definitely come back next time', '2020-09-08 02:17:02', 5, 5, 5, 5);

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

--
-- Table structure for table `woobooking_shipping`
--

DROP TABLE IF EXISTS `woobooking_shipping`;
CREATE TABLE `woobooking_shipping` (
  `id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `email` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `company` varchar(255) NOT NULL,
  `country` varchar(50) NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `address_2` varchar(255) NOT NULL,
  `postcode` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `title` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_shipping`
--

INSERT INTO `woobooking_shipping` (`id`, `ordering`, `order_id`, `email`, `first_name`, `company`, `country`, `address_1`, `address_2`, `postcode`, `city`, `state`, `phone`, `title`, `alias`, `data`) VALUES
(2, 0, 238, '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, 0, 243, '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, 0, 7, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(5, 0, 9, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(6, 0, 10, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(7, 0, 11, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(8, 0, 12, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(9, 0, 13, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(10, 0, 14, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(11, 0, 15, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(12, 0, 16, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(13, 0, 17, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(14, 0, 18, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(15, 0, 19, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(16, 0, 20, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(17, 0, 21, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(18, 0, 22, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(19, 0, 23, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(20, 0, 24, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(21, 0, 25, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(22, 0, 26, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(23, 0, 27, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(24, 0, 28, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(25, 0, 29, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(26, 0, 30, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(27, 0, 31, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(28, 0, 32, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(29, 0, 33, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(30, 0, 34, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(31, 0, 35, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(32, 0, 36, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(33, 0, 37, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(34, 0, 38, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(35, 0, 39, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(36, 0, 40, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(37, 0, 41, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(38, 0, 42, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(39, 0, 43, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(40, 0, 44, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(41, 0, 45, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(42, 0, 46, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(43, 0, 47, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(44, 0, 48, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(45, 0, 49, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(46, 0, 50, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(47, 0, 51, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(48, 0, 6, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(49, 0, 7, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', ''),
(50, 0, 8, '', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', '');

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

--
-- Table structure for table `woobooking_sms`
--

DROP TABLE IF EXISTS `woobooking_sms`;
CREATE TABLE `woobooking_sms` (
  `id` int(11) NOT NULL,
  `account_id` varchar(200) NOT NULL,
  `auth_token` varchar(200) NOT NULL,
  `phone_register` varchar(200) NOT NULL,
  `phonecode` varchar(200) NOT NULL,
  `countrycode` char(3) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_smscontent`
--

DROP TABLE IF EXISTS `woobooking_smscontent`;
CREATE TABLE `woobooking_smscontent` (
  `id` int(11) NOT NULL,
  `sms_suplier_id` int(11) NOT NULL,
  `title_sms` varchar(200) NOT NULL,
  `action_sms` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `content_sms` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_state`
--

DROP TABLE IF EXISTS `woobooking_state`;
CREATE TABLE `woobooking_state` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `country_id` int(11) NOT NULL,
  `statecode` char(3) NOT NULL,
  `code` char(2) NOT NULL,
  `published` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_state`
--

INSERT INTO `woobooking_state` (`id`, `name`, `country_id`, `statecode`, `code`, `published`, `ordering`, `image`) VALUES
(1, 'Al Ras Al Akhdar ', 8, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(2, 'Rancho Santa Fe', 235, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(3, '125, 00187 Roma RM', 112, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(4, 'Central Park S', 235, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(5, 'Nha Trang City', 242, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(6, 'Da Nang City', 242, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(7, 'Kien Giang province', 242, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(8, 'Lahaina, HI 96761', 235, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(9, 'Umm Suqeim 3 - Dubai ', 8, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(10, '225, 80076 Capri NA', 112, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(11, '83700 Rottach-Egern', 60, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(12, '61476 Kronberg im Taunus', 60, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(13, '670, Tiradentes - MG, 36325-000', 33, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(14, 'Rio de Janeiro - RJ, 22250-040', 33, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(15, '29602 Marbella, Málaga', 70, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(16, 'Kyoto, 616-8385', 116, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(17, 'Stoke Poges SL2 4PG', 80, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(18, '06360 Èze', 76, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(19, 'Singapore', 195, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(20, 'Lisboa', 183, '', '', 1, 0, 'admin/app/assets/images/no-image.jpg'),
(21, 'vgnhnh', 1, '', '', 1, 0, '');

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

--
-- Table structure for table `woobooking_tag`
--

DROP TABLE IF EXISTS `woobooking_tag`;
CREATE TABLE `woobooking_tag` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_user`
--

DROP TABLE IF EXISTS `woobooking_user`;
CREATE TABLE `woobooking_user` (
  `id` int(11) NOT NULL,
  `group_user_id` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `birthday` date DEFAULT NULL,
  `gender` varchar(255) NOT NULL,
  `phonecode` int(5) NOT NULL,
  `countrycode` varchar(255) NOT NULL,
  `mobile` int(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `address` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `postcode` int(11) NOT NULL,
  `address_bill` text NOT NULL,
  `open_source_user_id` int(11) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `business` varchar(255) DEFAULT NULL,
  `published` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `params` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `woobooking_user`
--

INSERT INTO `woobooking_user` (`id`, `group_user_id`, `first_name`, `last_name`, `birthday`, `gender`, `phonecode`, `countrycode`, `mobile`, `email`, `image`, `description`, `address`, `country`, `city`, `state`, `postcode`, `address_bill`, `open_source_user_id`, `company`, `created`, `business`, `published`, `ordering`, `params`) VALUES
(1, 3, '', '', NULL, '', 0, '', 0, 'tienngguyen@gmail.com', '', '', '', '', '', '', 0, '', 1, NULL, '0000-00-00 00:00:00', NULL, 0, 0, ''),
(2, 0, 'Nguy?n Th?', 'Xuân', NULL, '', 0, '', 0, 'tienngguyenn@gmail.com', '', '', '', '', '', '', 0, '', 2, NULL, '2020-10-28 09:12:41', NULL, 0, 0, '');

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

--
-- Table structure for table `woobooking_view`
--

DROP TABLE IF EXISTS `woobooking_view`;
CREATE TABLE `woobooking_view` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `published` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_view`
--

INSERT INTO `woobooking_view` (`id`, `name`, `image`, `alias`, `published`, `ordering`, `description`) VALUES
(1, 'cronjob', '', '', 0, 0, ''),
(2, 'db_appointments', '', '', 0, 0, ''),
(3, 'calendar', '', '', 1, 0, ''),
(4, 'appointment', '', '', 1, 0, ''),
(5, 'event', '', '', 0, 0, ''),
(6, 'package', '', '', 1, 0, ''),
(7, 'employee', '', '', 0, 0, ''),
(8, 'category', '', '', 1, 0, ''),
(9, 'service', '', '', 0, 0, ''),
(10, 'location', '', '', 0, 0, ''),
(11, 'wbcustomer', '', '', 1, 0, ''),
(12, 'finance', '', '', 0, 0, ''),
(13, 'coupon', '', '', 0, 0, ''),
(14, 'report', '', '', 0, 0, ''),
(15, 'invoice', '', '', 0, 0, ''),
(16, 'notification', '', '', 0, 0, ''),
(17, 'config', '', '', 1, 0, ''),
(18, 'permission', '', '', 0, 0, ''),
(19, 'usergroup', '', '', 0, 0, ''),
(20, 'user', '', '', 0, 0, ''),
(21, 'custom', '', '', 0, 0, ''),
(22, 'membership', '', '', 0, 0, ''),
(23, 'translate', '', '', 0, 0, ''),
(24, 'payment', '', '', 1, 0, ''),
(25, 'currency', '', '', 0, 0, ''),
(26, 'tool', '', '', 0, 0, '');

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

--
-- Table structure for table `woobooking_wishlist`
--

DROP TABLE IF EXISTS `woobooking_wishlist`;
CREATE TABLE `woobooking_wishlist` (
  `id` int(11) UNSIGNED NOT NULL,
  `service_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_wishlist`
--

INSERT INTO `woobooking_wishlist` (`id`, `service_id`, `user_id`, `ordering`) VALUES
(72, 51, 2, 0),
(73, 103, 3, 0),
(111, 103, 1, 0),
(112, 61, 1, 0),
(114, 103, 0, 0),
(257, 61, 19, 0),
(307, 45, 19, 0),
(308, 103, 19, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `woobooking_agent`
--
ALTER TABLE `woobooking_agent`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_amenity`
--
ALTER TABLE `woobooking_amenity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_apps`
--
ALTER TABLE `woobooking_apps`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_billing`
--
ALTER TABLE `woobooking_billing`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_block`
--
ALTER TABLE `woobooking_block`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_cart`
--
ALTER TABLE `woobooking_cart`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `woobooking_category`
--
ALTER TABLE `woobooking_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_config`
--
ALTER TABLE `woobooking_config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_country`
--
ALTER TABLE `woobooking_country`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_currency`
--
ALTER TABLE `woobooking_currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_customer`
--
ALTER TABLE `woobooking_customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_customize`
--
ALTER TABLE `woobooking_customize`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_email`
--
ALTER TABLE `woobooking_email`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_emailaccount`
--
ALTER TABLE `woobooking_emailaccount`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_gallery`
--
ALTER TABLE `woobooking_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_groupuser`
--
ALTER TABLE `woobooking_groupuser`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_location`
--
ALTER TABLE `woobooking_location`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_neighborhood`
--
ALTER TABLE `woobooking_neighborhood`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_order`
--
ALTER TABLE `woobooking_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_status_id` (`order_status_id`);

--
-- Indexes for table `woobooking_order_detail`
--
ALTER TABLE `woobooking_order_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `order_id_2` (`order_id`);

--
-- Indexes for table `woobooking_order_detail_rate`
--
ALTER TABLE `woobooking_order_detail_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_detail_id` (`order_detail_id`);

--
-- Indexes for table `woobooking_order_status`
--
ALTER TABLE `woobooking_order_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `woobooking_permission`
--
ALTER TABLE `woobooking_permission`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_property_type`
--
ALTER TABLE `woobooking_property_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_real_estate`
--
ALTER TABLE `woobooking_real_estate`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_real_estate_property`
--
ALTER TABLE `woobooking_real_estate_property`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_review`
--
ALTER TABLE `woobooking_review`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_shipping`
--
ALTER TABLE `woobooking_shipping`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_sms`
--
ALTER TABLE `woobooking_sms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_smscontent`
--
ALTER TABLE `woobooking_smscontent`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_state`
--
ALTER TABLE `woobooking_state`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_tag`
--
ALTER TABLE `woobooking_tag`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `woobooking_user`
--
ALTER TABLE `woobooking_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_view`
--
ALTER TABLE `woobooking_view`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `woobooking_wishlist`
--
ALTER TABLE `woobooking_wishlist`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `woobooking_agent`
--
ALTER TABLE `woobooking_agent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `woobooking_amenity`
--
ALTER TABLE `woobooking_amenity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `woobooking_apps`
--
ALTER TABLE `woobooking_apps`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `woobooking_billing`
--
ALTER TABLE `woobooking_billing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `woobooking_block`
--
ALTER TABLE `woobooking_block`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;

--
-- AUTO_INCREMENT for table `woobooking_cart`
--
ALTER TABLE `woobooking_cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_category`
--
ALTER TABLE `woobooking_category`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `woobooking_country`
--
ALTER TABLE `woobooking_country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT for table `woobooking_currency`
--
ALTER TABLE `woobooking_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `woobooking_customer`
--
ALTER TABLE `woobooking_customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `woobooking_customize`
--
ALTER TABLE `woobooking_customize`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `woobooking_email`
--
ALTER TABLE `woobooking_email`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `woobooking_emailaccount`
--
ALTER TABLE `woobooking_emailaccount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `woobooking_gallery`
--
ALTER TABLE `woobooking_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=331;

--
-- AUTO_INCREMENT for table `woobooking_groupuser`
--
ALTER TABLE `woobooking_groupuser`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `woobooking_location`
--
ALTER TABLE `woobooking_location`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `woobooking_neighborhood`
--
ALTER TABLE `woobooking_neighborhood`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `woobooking_order`
--
ALTER TABLE `woobooking_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `woobooking_order_detail`
--
ALTER TABLE `woobooking_order_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_order_detail_rate`
--
ALTER TABLE `woobooking_order_detail_rate`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_order_status`
--
ALTER TABLE `woobooking_order_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `woobooking_permission`
--
ALTER TABLE `woobooking_permission`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `woobooking_property_type`
--
ALTER TABLE `woobooking_property_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `woobooking_real_estate`
--
ALTER TABLE `woobooking_real_estate`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `woobooking_real_estate_property`
--
ALTER TABLE `woobooking_real_estate_property`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3859;

--
-- AUTO_INCREMENT for table `woobooking_review`
--
ALTER TABLE `woobooking_review`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `woobooking_shipping`
--
ALTER TABLE `woobooking_shipping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `woobooking_sms`
--
ALTER TABLE `woobooking_sms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_smscontent`
--
ALTER TABLE `woobooking_smscontent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_state`
--
ALTER TABLE `woobooking_state`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `woobooking_tag`
--
ALTER TABLE `woobooking_tag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_user`
--
ALTER TABLE `woobooking_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `woobooking_view`
--
ALTER TABLE `woobooking_view`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `woobooking_wishlist`
--
ALTER TABLE `woobooking_wishlist`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=309;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `woobooking_order`
--
ALTER TABLE `woobooking_order`
  ADD CONSTRAINT `woobooking_order_ibfk_1` FOREIGN KEY (`order_status_id`) REFERENCES `woobooking_order_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_order_detail`
--
ALTER TABLE `woobooking_order_detail`
  ADD CONSTRAINT `woobooking_order_detail_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `woobooking_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_order_detail_rate`
--
ALTER TABLE `woobooking_order_detail_rate`
  ADD CONSTRAINT `woobooking_order_detail_rate_ibfk_1` FOREIGN KEY (`order_detail_id`) REFERENCES `woobooking_order_detail` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
SET FOREIGN_KEY_CHECKS=1;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;