-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 10, 2020 at 07:48 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_wp_booking_pro`
--

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

--
-- 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,
  `open_source_client_id` varchar(255) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `woobooking_block` (`id`, `open_source_client_id`, `name`, `type`, `alias`, `ordering`, `description`, `params`) 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, '86f1abbb-c15e-4168-9f8f-4788884e86f4', '', 'searchmenu', '', 0, '', ''),
(188, '86f1abbb-c15e-4168-9f8f-4788884e86f4', '', 'searchmenu', '', 0, '', ''),
(189, '387f2695-9134-4b01-9419-eec5198c6002', '', 'listevent', '', 0, '', ''),
(190, '82010ad7-cf81-4508-a28f-ff74480108a2', '', 'meetourcoachs', '', 0, '', ''),
(191, '4e36d305-6f81-49b2-a534-cafe296c8387', '', 'categoryimage', '', 0, '', ''),
(192, '5b88671b-8a50-4dfb-8ce3-7d2c05024cb7', '', 'meetourcoachs', '', 0, '', ''),
(193, '08d9e847-3476-481e-ada9-16e9c008fd79', '', 'meetourcoachs', '', 0, '', ''),
(194, '4a06000a-58a4-4af7-9dba-ffb1bc2c0ac8', '', 'meetourcoachs', '', 0, '', ''),
(195, 'dff9c85', '', 'listservice', '', 0, '', ''),
(196, '94e2575', '', 'search_tour', '', 0, '', '{}'),
(197, '6bef198', '', 'top_service', '', 0, '', '{}'),
(198, '21fadec', '', 'top_employee', '', 0, '', '{}'),
(199, '54dba3a', '', 'search_tour', '', 0, '', '{}'),
(200, '96ce2cd', '', 'top_service', '', 0, '', '{}'),
(201, '6d4ff08', '', 'top_employee', '', 0, '', '{}'),
(202, 'd01edd7', '', 'search_service', '', 0, '', '{}');

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

--
-- 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,
  `user_id` int(11) 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`, `user_id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 4, 'Yoga', 'upload/category/images/cover/U17hWLKkyoga_category.jpg', '', 5, 1, 'Practicing with leading Yoga experts helps improve overall health and effectively prevents the signs of aging'),
(21, 0, 'Cardio', 'upload/category/images/cover/yVx8P9tbimg64_employee.jpg', '', 3, 1, 'Cardio exercises help the body increase and control the heart rate, support the blood circulation. As a result, the oxygen supply to the whole body in general and muscle cells, in particular, is also improved in a positive way.'),
(22, 0, 'Body Combat', 'upload/category/images/cover/SRUuA5W1img27_employee.jpg', '', 6, 1, 'Combat sports is a combination of martial arts and music, which is suitable for young people. Combat sports is trained on vibrant music and helps increase excitement, the athletic ability for trainees.'),
(23, 4, 'Body building', 'upload/category/images/cover/HmpYYzT0img77_employee.jpg', '', 2, 1, 'Not only weight loss, fat reduction, Bodybuilding also boost your heart rate and improve your endurance. Increased heart rate maximum support for metabolism. Endurance, balance, and endurance will help you get ready for heavy muscle training.'),
(68, 0, 'Gym ', 'upload/category/images/cover/pD8ebDZtimg55_employee.jpg', '', 4, 1, 'Help you have a nice body, attract the opposite sex; improve health, prevent disease. In addition, the gym makes you always full of vitality, the spirit of comfort and energy for both men and women.'),
(70, 0, 'Dance', 'upload/category/images/cover/OMKuJdlsimg62_employee.png', '', 7, 1, 'Dance is the best option if you want to lose weight. It helps to consume a lot of energy and promotes health preventing diseases.'),
(71, 0, 'Yoga Classic', 'upload/category/images/cover/ds0iUMas2.jpg', '', 1, 1, 'So Fresh So High');

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

--
-- Table structure for table `woobooking_category_tag`
--

DROP TABLE IF EXISTS `woobooking_category_tag`;
CREATE TABLE `woobooking_category_tag` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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_service_detail\":\"13\",\"page_list_category\":\"9\",\"page_list_service\":\"10\",\"page_list_servicelocator\":\"198\",\"page_list_vendor\":\"215\",\"page_vendor_detail\":\"216\",\"page_user_account\":\"217\",\"page_login\":\"218\",\"page_signup\":\"219\",\"booking_style\":\"in_line\",\"order_status_config_when_scan\":\"pending\",\"timezone\":\"Asia\\/Ho_Chi_Minh\",\"default_groupuser_signup\":\"5\",\"request_payment\":\"\",\"google_map_api_key\":\"AIzaSyApRhCxfZw31OO9_fzaTFMCY7eChycn7wM\",\"client_secret_file\":\"upload_system\\/client_secret\\/file_system_wpbooking_client_secret_286176911313-aqdmhfaeb1uou3s80nc1uddrsm5g5sp5.apps.googleusercontent.com.json\",\"multi_product_in_cart\":\"0\",\"is_enable_add_google_calendar_api\":\"0\",\"is_edit_sync_on_woommerce\":\"0\",\"is_enable_send_sms\":\"0\",\"radius_for_search\":\"50\",\"unit_for_search\":\"Km\",\"default_currency\":\"USD\"}');

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

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

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

--
-- Table structure for table `woobooking_coupon`
--

DROP TABLE IF EXISTS `woobooking_coupon`;
CREATE TABLE `woobooking_coupon` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `code` varchar(11) NOT NULL,
  `amount` float NOT NULL,
  `percent` float 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;

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

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

DROP TABLE IF EXISTS `woobooking_currency`;
CREATE TABLE `woobooking_currency` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `unit_currency` varchar(200) NOT NULL,
  `symbol_currency` 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_currency`
--

INSERT INTO `woobooking_currency` (`id`, `name`, `unit_currency`, `symbol_currency`, `ordering`, `published`, `description`) VALUES
(1, 'Dolar', 'USD', '$', 0, 1, ''),
(2, 'Euro', 'EUR', '€', 0, 1, '');

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

--
-- 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,
  `user_id` int(11) NOT NULL,
  `phonecode` int(5) NOT NULL,
  `countrycode` varchar(200) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `created_date` datetime NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `address_2` 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
) 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`, `user_id`, `phonecode`, `countrycode`, `mobile`, `created_date`, `address_1`, `address_2`, `city`, `email`, `gender`, `birth_day`, `ordering`, `note_internal`) VALUES
(468, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(469, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(470, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(471, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(472, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(473, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(474, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(475, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(476, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(477, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(478, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(479, 0, 'Mary', 'Jane', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'maryjane@gmail.com', '', '', 0, ''),
(480, 0, 'ton', 'ton', '', '', 0, 0, '', '0969908147', '0000-00-00 00:00:00', '', '', '', 'bachdamongao9x@gmail.com', '', '', 0, ''),
(481, 0, 'ton', 'ton', '', '', 0, 0, '', '0969908147', '0000-00-00 00:00:00', '', '', '', 'bachdamongao9x@gmail.com', '', '', 0, ''),
(482, 0, 'admin_netbase', 'will', '', '', 0, 0, '', '0383766284', '0000-00-00 00:00:00', '', '', '', 'oanhnguyenlam.hvnh@gmail.com', '', '', 0, ''),
(483, 0, 'admin_netbase', 'will', '', '', 0, 0, '', '146555533231', '0000-00-00 00:00:00', '', '', '', 'hiep.v@netbasejsc.com', '', '', 0, ''),
(484, 0, 'adsd', 'ádd', '', '', 0, 0, '', '54564986', '0000-00-00 00:00:00', '', '', '', 'nhahiep.2102@gmail.com', '', '', 0, ''),
(485, 0, 'Thien', 'Huynh', '', '', 0, 0, '', '32323332323', '0000-00-00 00:00:00', '', '', '', 'thien@gmail.com', '', '', 0, ''),
(486, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(487, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(488, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(489, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(490, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(491, 0, 'hattepe', 'jose', '', '', 0, 0, '', '3343434', '0000-00-00 00:00:00', '', '', '', 'hattepe@gmail.com', '', '', 0, ''),
(492, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(493, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(494, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(495, 0, 'sád', 'ádsa', '', '', 0, 0, '', '232', '0000-00-00 00:00:00', '', '', '', 'dfd@dfs.sdf', '', '', 0, ''),
(496, 0, 'sgdgs', 'sdfsdf', '', '', 0, 0, '', '3433', '0000-00-00 00:00:00', '', '', '', 'sdfsd@sfsd.sdf', '', '', 0, ''),
(497, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(498, 0, 'susan', 'su', '', '', 0, 0, '', '12345678', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(499, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(500, 0, 'payl', 'nguyen', '', '', 0, 0, '', '08867', '0000-00-00 00:00:00', '', '', '', 'mynv@gmail.com', '', '', 0, ''),
(501, 0, '1', '1', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', '1@1.1', '', '', 0, ''),
(502, 0, 'Gabriel', 'gomes', '', '', 0, 0, '', '1135023222', '0000-00-00 00:00:00', '', '', '', 'carolinadgmarques@gmail.com', '', '', 0, ''),
(503, 0, 'adsd', 'dsadsad', '', '', 0, 0, '', '54564986', '0000-00-00 00:00:00', '', '', '', 'nhahiep.2102@gmail.com', '', '', 0, ''),
(504, 0, 'asadasd', 'adasda', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'dasda', '', '', 0, ''),
(505, 0, 'Viet', 'nguyen', '', '', 0, 0, '', '0977476230', '0000-00-00 00:00:00', '', '', '', 'viet@gmail.com', '', '', 0, ''),
(506, 0, 'SDAF', 'JHBHB', '', '', 0, 0, '', '52544', '0000-00-00 00:00:00', '', '', '', 'BVBH@bbmnm.com', '', '', 0, ''),
(507, 0, 'suzie', 'chutiya', '', '', 0, 0, '', '+64 21 083 47435', '0000-00-00 00:00:00', '', '', '', 'nerox50939@mailop7.com', '', '', 0, ''),
(508, 0, 'Andrea Acosta', 'Pinargote', '', '', 0, 0, '', '7542366130', '0000-00-00 00:00:00', '', '', '', 'ventas@clubparrilla.com', '', '', 0, ''),
(509, 0, 'Scott', 'Versago', '', '', 0, 0, '', '3217546465', '0000-00-00 00:00:00', '', '', '', 'scott@empire-ink.com', '', '', 0, ''),
(510, 0, 'Sonja', 'Test', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'diesistein@testtest.de', '', '', 0, ''),
(511, 0, 'Baba', 'Eko', '', '', 0, 0, '', '7186474709', '0000-00-00 00:00:00', '', '', '', 'babaeko@akint.net', '', '', 0, ''),
(512, 0, 'test', 'test', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'test', '', '', 0, ''),
(513, 0, 'Peter', 'Smith', '', '', 0, 0, '', '12313', '0000-00-00 00:00:00', '', '', '', 'peter@gmail.com', '', '', 0, ''),
(514, 0, '544t', 'erter', '', '', 0, 0, '', '34234234', '0000-00-00 00:00:00', '', '', '', 'tert@terter.tert', '', '', 0, ''),
(515, 0, '6546', '64564564', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', '6455654\\@rtter.gfhf', '', '', 0, ''),
(516, 0, 'test', 'teds', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'tesdt@test', '', '', 0, ''),
(517, 0, 'ad', 'ádad', '', '', 0, 0, '', '90840372243', '0000-00-00 00:00:00', '', '', '', 'namnk', '', '', 0, ''),
(518, 0, 'ad', 'ádad', '', '', 0, 0, '', '90840372243', '0000-00-00 00:00:00', '', '', '', 'namnk', '', '', 0, ''),
(519, 0, 'Juss', 'Tin', '', '', 0, 0, '', '0714827893792', '0000-00-00 00:00:00', '', '', '', 'khanhau@gmail.com', '', '', 0, ''),
(520, 0, 'Bevis', 'Jay', '', '', 0, 0, '', '0978065021', '0000-00-00 00:00:00', '', '', '', 'bevisjay@gmail.com', '', '', 0, ''),
(521, 0, 'Bevis', 'Jay', '', '', 0, 0, '', '0712369823', '0000-00-00 00:00:00', '', '', '', 'jayB@gmail.com', '', '', 0, ''),
(522, 0, 'Bevis', 'Juyci', '', '', 0, 0, '', '07946230673', '0000-00-00 00:00:00', '', '', '', 'J.Bevis@gmail.com', '', '', 0, ''),
(523, 0, 'njljn', 'jnjnjn', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'kmk@ddjjd.com', '', '', 0, ''),
(524, 0, 'Baba', 'Eko', '', '', 0, 0, '', '7186474709', '0000-00-00 00:00:00', '', '', '', 'babaeko@akint.net', '', '', 0, ''),
(525, 0, 'Γεο', 'Τσι', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'i.mgt@hotmail.com', '', '', 0, ''),
(526, 0, 'Γεο', 'Τσι', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'i.mgt@hotmail.com', '', '', 0, ''),
(527, 0, 'Martin', 'Bezares', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'interactiveapps2018@gmail.com', '', '', 0, ''),
(528, 0, 'Edwin', 'Rangel', '', '', 0, 0, '', '3183137539', '0000-00-00 00:00:00', '', '', '', 'edwinrangel@klasifica.com', '', '', 0, ''),
(529, 0, 'A', 'B', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'a@a.co', '', '', 0, ''),
(530, 0, 'Joel Edoardo', 'Pallotta Rodriguez', '', '', 0, 0, '', '0974149072', '0000-00-00 00:00:00', '', '', '', 'joeepr@gmail.com', '', '', 0, ''),
(531, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(532, 0, 'Ngo', 'Sơn', '', '', 0, 0, '', '0976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(533, 0, 'qa', 'b', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(534, 0, 'qa', 'b', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'xcvgsdv@gmail.com', '', '', 0, ''),
(535, 0, 'fddggg', 'dvfdfv', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'dfdf@jjj.oi', '', '', 0, ''),
(536, 0, 'juan', 'Perez', '', '', 0, 0, '', '354654654', '0000-00-00 00:00:00', '', '', '', 'fredhy2012@gmail.com', '', '', 0, ''),
(537, 0, 'qa', '4523', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'dfsjkk@tgmail.com', '', '', 0, ''),
(538, 0, 'qa', '4523', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'dfsjkk@tgmail.com', '', '', 0, ''),
(539, 0, 'John', 'Deo', '', '', 0, 0, '', '9658565656', '0000-00-00 00:00:00', '', '', '', 'ccccc@gggg.hhhh', '', '', 0, ''),
(540, 0, 'Paul', 'Nguyen', '', '', 0, 0, '', '08867867', '0000-00-00 00:00:00', '', '', '', 'mynvit88@gmail.com', '', '', 0, ''),
(541, 0, 'Paul', 'nguyen', '', '', 0, 0, '', '0981079879', '0000-00-00 00:00:00', '', '', '', 'mynvit88@gmail.com', '', '', 0, ''),
(542, 0, 'test', 'test', '', '', 0, 0, '', '0987564568', '0000-00-00 00:00:00', '', '', '', 'test@gmail.com', '', '', 0, ''),
(543, 0, 'Ryan', 'Terry', '', '', 0, 0, '', '012478421', '0000-00-00 00:00:00', '', '', '', 'Ryan.terry22@gmail.com', '', '', 0, ''),
(544, 0, 'A', 'A', '', '', 0, 0, '', '1111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(545, 0, 'A', 'A', '', '', 0, 0, '', '1111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(546, 0, 'A', 'A', '', '', 0, 0, '', '1111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(547, 0, 'A', 'A', '', '', 0, 0, '', '1111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(548, 0, 'aaa', 'aa', '', '', 0, 0, '', '1111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(549, 0, 'aa', 'aa', '', '', 0, 0, '', '11111111111', '0000-00-00 00:00:00', '', '', '', 'aa@aa.com', '', '', 0, ''),
(550, 0, 'cvc', 'df', '', '', 0, 0, '', '0386653929', '0000-00-00 00:00:00', '', '', '', 'xx@edf.fr', '', '', 0, ''),
(551, 0, 'Chachere Feed - Neckover', 'Dealer', '', '', 0, 0, '', '9365691100', '0000-00-00 00:00:00', '', '', '', 'hansfordhay@gmail.com', '', '', 0, ''),
(552, 0, 'fsdf', 'sdfsdf', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'sdf@gmail.com', '', '', 0, ''),
(553, 0, 'dsdg', 'dsgsgs', '', '', 0, 0, '', '666555448', '0000-00-00 00:00:00', '', '', '', 'dsgdsg@gmail.com', '', '', 0, ''),
(554, 0, 'dsfs', 'sdfsdf', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'dsds@dwwd.com', '', '', 0, ''),
(555, 0, 'adfs', 'sdfasd', '', '', 0, 0, '', '2323232', '0000-00-00 00:00:00', '', '', '', 'sdf@sdf.cac', '', '', 0, ''),
(556, 0, 'Karla', 'Andrews', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'asd@adsd.com', '', '', 0, ''),
(557, 0, 'Molly', 'Ringwall', '', '', 0, 0, '', '9999999999', '0000-00-00 00:00:00', '', '', '', 'molly@gmail.com', '', '', 0, ''),
(558, 0, 'rasd', 'asd', '', '', 0, 0, '', '123213213', '0000-00-00 00:00:00', '', '', '', 'asdsad@asdlkmsad', '', '', 0, ''),
(559, 0, 'a', 'a', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'arzej@o2.pl', '', '', 0, ''),
(560, 0, 'masina', 'sivaprasad', '', '', 0, 0, '', '9812344444', '0000-00-00 00:00:00', '', '', '', 'smasina@gmail.com', '', '', 0, ''),
(561, 0, 'EEE', 'NNN', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'ABC@AVBC.COM', '', '', 0, ''),
(562, 0, 'Tooooo1', 'JAA', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'ASD@ASFDS.COM', '', '', 0, ''),
(563, 0, 'First', 'Last', '', '', 0, 0, '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'test@abc.com', '', '', 0, ''),
(564, 0, 'Estefania', 'Pulgar', '', '', 0, 0, '', '0990738191', '0000-00-00 00:00:00', '', '', '', 'stefipulgar@gmail.com', '', '', 0, ''),
(565, 0, 'susan', 'vu', '', '', 0, 0, '', '146555533231', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(566, 0, 'susan', 'vu', '', '', 0, 0, '', '146555533231', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(567, 0, 'susan', 'vu', '', '', 0, 0, '', '146555533231', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(568, 0, 'susan', 'vu', '', '', 0, 0, '', '146555533231', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(569, 0, 'susan', 'vu', '', '', 0, 0, '', '0383766284', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(570, 0, 'susan', 'vu', '', '', 0, 0, '', '2149823843', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(571, 0, 'susan', 'vu', '', '', 0, 0, '', '0383766284', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(572, 0, 'susan', 'vu', '', '', 0, 0, '', '0383766284', '0000-00-00 00:00:00', '', '', '', 'susan@gmail.com', '', '', 0, ''),
(573, 0, 'sdas', 'asdasd', '', '', 0, 0, '', '123122131', '0000-00-00 00:00:00', '', '', '', 'asda@gmail.com', '', '', 0, ''),
(574, 0, 'waleed', 'Javed', '', '', 0, 0, '', '3015128802', '0000-00-00 00:00:00', '', '', '', 'cs.waleedj@gmail.com', '', '', 0, ''),
(575, 0, 'waleed', 'Grace', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'abc@gmail.com', '', '', 0, ''),
(576, 0, 'Ganesh', 'Kumar', '', '', 0, 0, '', '08438010101', '0000-00-00 00:00:00', '', '', '', 'smsnewindia@gmail.com', '', '', 0, ''),
(577, 0, 'ddzvzxv', 'zxvzxcv', '', '', 0, 0, '', '', '0000-00-00 00:00:00', '', '', '', 'zxcvz@dfg.com', '', '', 0, ''),
(578, 0, 'demo', 'demo', '', '', 0, 0, '', '23232323', '0000-00-00 00:00:00', '', '', '', 'demo@mail.com', '', '', 0, ''),
(579, 0, 'John', 'Mayer', '', '', 0, 0, '', '2102222222', '0000-00-00 00:00:00', '', '', '', 'johnzilark@gmail.com', '', '', 0, ''),
(580, 0, 'Mustapha', 'lod', '', '', 0, 0, '', '0781438057', '0000-00-00 00:00:00', '', '', '', 'okaweb2@gmail.com', '', '', 0, ''),
(581, 0, 'Phu', 'Huynh', '', '', 0, 0, '', '0987789987', '0000-00-00 00:00:00', '', '', '', 'huynh@gmail.com', '', '', 0, ''),
(582, 0, 'Cristian', 'Matei', '', '', 0, 40, 'ROU', '723012021', '0000-00-00 00:00:00', '', '', '', 'contact.cristi@gmail.com', '', '', 0, ''),
(583, 0, 'chien', 'min', '', '', 0, 84, 'VNM', '943641918', '0000-00-00 00:00:00', '', '', '', 'chienbmq@gmail.com', '', '', 0, ''),
(584, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(585, 0, 'Luisa', 'Davis', '', '', 0, 93, 'AFG', '', '0000-00-00 00:00:00', '', '', '', 'Nikko_Crist65@hotmail.com', '', '', 0, ''),
(586, 0, 'AURIMAS', 'JONAITIS', '', '', 0, 1, 'USA', '894681937', '0000-00-00 00:00:00', '', '', '', 'aurimas1982@gmail.com', '', '', 0, ''),
(587, 0, 'a', 'a', '', '', 0, 1, 'USA', '99503935', '0000-00-00 00:00:00', '', '', '', 'abbasrba@hotmail.com', '', '', 0, ''),
(588, 0, 'Danish', 'Mohammed', '', '', 0, 1, 'USA', '9290169960', '0000-00-00 00:00:00', '', '', '', 'junkcarbuyerschicago.com@gmail.com', '', '', 0, ''),
(589, 0, 'Cristian', 'R', '', '', 0, 56, 'CHL', '12315464', '0000-00-00 00:00:00', '', '', '', 'cristian@centralperk.cl', '', '', 0, ''),
(590, 0, 'avc', 'sss', '', '', 0, 84, 'VNM', '5432541054', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(591, 0, 'avc', 'sss', '', '', 0, 84, 'VNM', '5432541054', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(592, 0, 'Nguyen', 'Thanh', '', '', 0, 84, 'VNM', '1325641231', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(593, 0, 'Nguyen', 'Thanh', '', '', 0, 1, 'USA', '1325641231', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(594, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(595, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(596, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(597, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(598, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(599, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(600, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(601, 0, 'szafsa', 'fsaf', '', '', 0, 1264, 'AIA', '12314561113', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(602, 0, 'szafsa', 'fsaf', '', '', 0, 1264, 'AIA', '12132132', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(603, 0, 'szafsa', 'fsaf', '', '', 0, 244, 'AGO', '12132132', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(604, 0, 'szafsa', 'fsaf', '', '', 0, 1264, 'AIA', '12314561113', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(605, 0, 'szafsa', 'fsaf', '', '', 0, 84, 'VNM', '886285344', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(606, 0, 'szafsa', 'fsaf', '', '', 0, 84, 'VNM', '424025404', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(607, 0, 'szafsa', 'fsaf', '', '', 0, 93, 'AFG', '12354345', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(608, 0, 'szafsa', 'fsaf', '', '', 0, 1, 'USA', '12354345', '0000-00-00 00:00:00', '', '', '', 'abc@gmail.com', '', '', 0, ''),
(609, 0, 'Ngo', 'Sơn', '', '', 0, 84, 'VNM', '976747562', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, ''),
(610, 0, 'Nguyen', 'Thanh', '', '', 0, 93, 'AFG', '1325641231', '0000-00-00 00:00:00', '', '', '', 'thanh.tester22@gmail.com', '', '', 0, ''),
(611, 0, 'Steven', 'You ', '', '', 0, 1, 'USA', '3104290497', '0000-00-00 00:00:00', '', '', '', 'steven2@yahoo.com', '', '', 0, ''),
(612, 0, 'avc', 'sss', '', '', 0, 93, 'AFG', '5432541054', '0000-00-00 00:00:00', '', '', '', 'thanh.nc@netbasejsc.com', '', '', 0, ''),
(613, 0, 'rerr', 'rrrsdfsdf', '', '', 0, 56, 'CHL', '978088138', '0000-00-00 00:00:00', '', '', '', 'rrr@es.cl', '', '', 0, ''),
(614, 0, 'dda', 'dada', '', '', 0, 1, 'USA', '', '0000-00-00 00:00:00', '', '', '', 'ed@gmail.com', '', '', 0, ''),
(615, 0, 'fsffgr', 'rrrsr', '', '', 0, 1, 'USA', '5588996677', '0000-00-00 00:00:00', '', '', '', 'algo@gmail.com', '', '', 0, ''),
(616, 0, 'Maria', 'Adriana', '', '', 0, 1, 'USA', '', '0000-00-00 00:00:00', '', '', '', 'ventas@peniel.cl', '', '', 0, ''),
(617, 0, 'dsrdsr', 'werw', '', '', 0, 1, 'USA', '', '0000-00-00 00:00:00', '', '', '', 'sdfsdf@prova.it', '', '', 0, ''),
(618, 0, 'babak', 'nemaei', '', '', 0, 1, 'USA', '552302460', '0000-00-00 00:00:00', '', '', '', 'bobby@nervora.com', '', '', 0, ''),
(619, 0, 'juan', 'lol', '', '', 0, 1, 'USA', '', '0000-00-00 00:00:00', '', '', '', 'lol@nose.com', '', '', 0, ''),
(620, 0, 'test', 'test', '', '', 0, 1, 'USA', '', '0000-00-00 00:00:00', '', '', '', 'test@test.cp', '', '', 0, ''),
(621, 0, 'Demo', 'Demo', '', '', 0, 90, 'TUR', '5352553322', '0000-00-00 00:00:00', '', '', '', 'demo@demo.net', '', '', 0, ''),
(622, 0, 'Tyrel', 'Colwell', '', '', 0, 1, 'USA', '9206648935', '0000-00-00 00:00:00', '', '', '', 'tycolwell@gmail.com', '', '', 0, ''),
(623, 0, 'Nguyễn Thị', 'Xuân', '', '', 0, 93, 'AFG', '+93961650611', '0000-00-00 00:00:00', '', '', '', 'tienngguyen@gmail.com', '', '', 0, ''),
(624, 0, 'Nguyễn Thị', 'Xuân', '', '', 0, 93, 'AFG', '+93961650611', '0000-00-00 00:00:00', '', '', '', 'tienngguyen@gmail.com', '', '', 0, ''),
(625, 0, 'gyan', 'jaiswal', '', '', 0, 1, 'USA', '9716308473', '0000-00-00 00:00:00', '', '', '', 'gyanu31@gmail.com', '', '', 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_employee`
--

DROP TABLE IF EXISTS `woobooking_employee`;
CREATE TABLE `woobooking_employee` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `published` int(11) NOT NULL,
  `last_name` varchar(200) 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) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phonecode` int(5) NOT NULL,
  `countrycode` varchar(200) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `ordering` int(11) NOT NULL,
  `cover` varchar(300) NOT NULL,
  `image` varchar(255) NOT NULL,
  `params` mediumtext NOT NULL,
  `note_internal` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_employee`
--

INSERT INTO `woobooking_employee` (`id`, `first_name`, `published`, `last_name`, `location_id`, `user_id`, `opensource_user_id`, `country_code`, `email`, `phonecode`, `countrycode`, `mobile`, `ordering`, `cover`, `image`, `params`, `note_internal`) VALUES
(1, 'Billy', 1, 'Pepper', 3, 0, 1, 'AUS', 'billy@myyogateacher.com', 0, '', '265542198', 0, 'upload/employee/images/cover/U6Y253mVimg2_employee.jpg', 'upload/employee/images/fullimage/FIE5fCNTimg2_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Yoga teacher with years of teaching experience. Gold medal in Master Yoga Science & Holistic Health contest.'),
(3, 'Alex', 0, 'Brian', 3, 0, 0, 'USA', 'alex@fightclub.com', 0, '', '256996335', 0, 'upload/employee/images/cover/s8dLwmw1img31_employee.jpg', 'upload/employee/images/fullimage/WqW652db1.png', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Certification from the National Academy of Sports Medicine (NASM) USA. More than 8 years of bodybuilding experience, each coaching many stars directly.'),
(5, 'Jessica', 1, 'Smith', 4, 0, 0, 'USA', 'js@bodybuilders.com', 0, '', '266936569', 0, 'upload/employee/images/cover/YDAGqUboimg8_employee.jpg', 'upload/employee/images/fullimage/YZnwBFmQimg8_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'International veteran coach Lesmills Brazil: Bodycombat, Bodypump, Bodystep, RPM, BodyAttack, Bodybalance, BodyVive, PowerJump. Attend countless Aerobic, Dance & Rhythm, Hip Hop concerts in Brazil.'),
(7, 'John', 1, 'Franklin', 15, 0, 0, 'ITA', 'john@cardiomasters.com', 0, '', '233689554', 0, 'upload/employee/images/cover/mAmyEohJimg5_employee.jpg', 'upload/employee/images/fullimage/Q9kJXos4img5_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Certified UFC Coaches, Weight Loss, Cardio Conditioning, UFC Fit Classes. 5 years of bodybuilding training experience.'),
(8, 'Amanda', 1, 'Johnson', 18, 0, 0, 'USA', 'kelsey.rake@fightclub.com', 0, '', '244665893', 0, 'upload/employee/images/cover/76MQntLHimg32_employee.jpg', 'upload/employee/images/fullimage/ikz7KpRcimg32_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', '3 years coach at California Fitness & Yoga Centers. Training classes BodyCombat, RPM, BodyBalance, Stomp FX, Piloxing, Bums N Tums, Crunch, Cali Step.'),
(10, 'Olivia', 1, 'Franklin', 17, 0, 0, 'USA', 'ofr@myyogateacher.com', 0, '', '246335784', 0, 'upload/employee/images/cover/orKH2PvDimg59_employee.jpg', 'upload/employee/images/fullimage/iWlgLQIGimg59_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Yoga Teacher with 6 years of teaching experience and possesses qualifications such as Indian Yoga Diploma'),
(15, 'Vicky', 1, 'Johnson', 16, 0, 0, 'USA', 'vicky@bodybuilders.com', 0, '', '247845785', 0, 'upload/employee/images/cover/EIpAciQLimg26_employee.jpg', 'upload/employee/images/fullimage/MwbxjZNTimg26_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Certificate of international coach Lesmills in subjects: BODYCOMBAT, BODYPUMP, GRIT. Won many international awards for Karate, Kickboxing, Muay Thai and MMA.'),
(30, 'Alan', 1, 'Smith', 14, 0, 0, 'AGO', 'alan@myyogateacher.com', 0, '', '023847323', 0, 'upload/employee/images/cover/EyNSSsiNimg75_employee.jpg', 'upload/employee/images/fullimage/JgEaGVdVimg63_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Master\'s Degree in Yoga Science from Haridwar University, India in 2012. 2 years of teaching Yoga at Prakash Yoga Sewa, India'),
(33, 'Mini', 1, 'Rose', 3, 0, 0, 'BRA', 'mini@expert.com', 0, '', '156484961', 0, 'upload/employee/images/cover/ZCwgsNcpimg3_employee.jpg', 'upload/employee/images/fullimage/QorO9Q3Wimg3_employee.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'The benefits from Spinning meet a long list of health, fitness and lifestyle needs for a broad range of people. Whether you’re a roadie seeking performance gains or a newbie trying to drop a few pounds, Spinning likely has you covered. From saddle to saddle you’ll see the needs of many – regardless of age, gender, lifestyle – met by one experience. That’s why, as fitness options go, few are as dynamic and accommodating as Spinning.'),
(34, 'Jay', 1, 'Kil', 17, 0, 0, 'VNM', 'Jaykil.yoga@gmail.com', 0, '', '', 0, 'upload/employee/images/cover/q1F74BA82.jpg', 'upload/employee/images/fullimage/XhkAhyZ11.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Yoga teacher');

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

--
-- Table structure for table `woobooking_event`
--

DROP TABLE IF EXISTS `woobooking_event`;
CREATE TABLE `woobooking_event` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `price` float NOT NULL,
  `published` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `max_allowed_person` int(11) NOT NULL,
  `min_allowed_person` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `event_color` varchar(20) NOT NULL,
  `recurring_repeat` varchar(50) NOT NULL,
  `recurring` int(11) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `recurring_until` date NOT NULL,
  `ordering` int(11) NOT NULL,
  `publish_up` datetime NOT NULL,
  `publish_down` datetime NOT NULL,
  `close` int(11) NOT NULL,
  `close_date` datetime NOT NULL,
  `open_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_event_employee`
--

DROP TABLE IF EXISTS `woobooking_event_employee`;
CREATE TABLE `woobooking_event_employee` (
  `id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_event_tag`
--

DROP TABLE IF EXISTS `woobooking_event_tag`;
CREATE TABLE `woobooking_event_tag` (
  `id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_extra`
--

DROP TABLE IF EXISTS `woobooking_extra`;
CREATE TABLE `woobooking_extra` (
  `id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `object_id` int(11) NOT NULL,
  `duration` float NOT NULL,
  `price` float NOT NULL,
  `quality` 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;

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

--
-- Table structure for table `woobooking_finance`
--

DROP TABLE IF EXISTS `woobooking_finance`;
CREATE TABLE `woobooking_finance` (
  `id` int(11) NOT NULL,
  `payment_date` date NOT NULL,
  `name_customer` varchar(255) NOT NULL,
  `email_customer` varchar(255) NOT NULL,
  `employee` varchar(255) NOT NULL,
  `avatar_employee` varchar(255) NOT NULL,
  `service` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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
(4, 'event', 1, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(5, '', 0, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(6, '', 0, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(7, '', 0, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(8, '', 0, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(9, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sdsds', '', ''),
(10, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sdsds', '', ''),
(11, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sds', '', ''),
(12, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sdsdsds', '', ''),
(13, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sds', '', ''),
(14, '', 0, 'frontend/app/assets/images/no-image.jpg', 'sdsdsds', '', ''),
(15, '', 0, 'frontend/app/assets/images/no-image.jpg', 'new category', '', ''),
(32, 'service', 1, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(33, 'service', 1, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(34, 'service', 1, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(35, 'service', 2, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(36, 'service', 2, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(37, 'service', 2, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-08 at 1.23.31 PM.png', '', ''),
(38, 'service', 7, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(39, 'service', 7, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(40, 'service', 7, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(41, 'service', 12, 'frontend/app/assets/images/no-image.jpg', 'logo.jpg', '', ''),
(42, 'service', 12, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(43, 'service', 12, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-08 at 1.25.05 PM.png', '', ''),
(44, 'service', 36, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-08 at 1.23.31 PM.png', '', ''),
(45, 'event', 1, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(46, 'event', 1, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-08 at 1.25.05 PM.png', '', ''),
(47, 'service', 38, 'frontend/app/assets/images/no-image.jpg', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(110, 'event', 46, 'frontend/app/assets/images/no-image.jpg', 'Yoga2.png', '', ''),
(112, 'event', 48, 'frontend/app/assets/images/no-image.jpg', 'Running3.png', '', ''),
(113, 'event', 48, 'frontend/app/assets/images/no-image.jpg', 'Running2.png', '', ''),
(114, 'event', 48, 'frontend/app/assets/images/no-image.jpg', 'Running-1.jpg', '', ''),
(115, 'event', 49, 'frontend/app/assets/images/no-image.jpg', 'yoga1.jpg', '', ''),
(116, 'event', 50, 'frontend/app/assets/images/no-image.jpg', 'Yoga4.png', '', ''),
(117, 'event', 51, 'frontend/app/assets/images/no-image.jpg', 'yoga1.jpg', '', ''),
(118, 'event', 60, 'frontend/app/assets/images/no-image.jpg', 'Yoga3.png', '', ''),
(119, 'event', 61, 'frontend/app/assets/images/no-image.jpg', 'Running3.png', '', ''),
(120, 'event', 62, 'frontend/app/assets/images/no-image.jpg', 'Running2.png', '', ''),
(121, 'event', 62, 'frontend/app/assets/images/no-image.jpg', 'Running-1.jpg', '', ''),
(123, 'event', 64, 'frontend/app/assets/images/no-image.jpg', 'Running3.png', '', ''),
(124, 'event', 64, 'frontend/app/assets/images/no-image.jpg', 'Running2.png', '', ''),
(125, 'event', 64, 'frontend/app/assets/images/no-image.jpg', 'Running-1.jpg', '', ''),
(126, 'event', 65, 'frontend/app/assets/images/no-image.jpg', 'Running-1.jpg', '', ''),
(127, 'event', 66, 'frontend/app/assets/images/no-image.jpg', 'Yoga2.png', '', ''),
(128, 'event', 67, 'frontend/app/assets/images/no-image.jpg', 'Running3.png', '', ''),
(129, 'event', 68, 'frontend/app/assets/images/no-image.jpg', 'yoga1.jpg', '', ''),
(131, 'event', 70, 'frontend/app/assets/images/no-image.jpg', 'Yoga3.png', '', ''),
(137, 'event', 74, 'frontend/app/assets/images/no-image.jpg', 'Running3.png', '', ''),
(140, 'event', 77, 'frontend/app/assets/images/no-image.jpg', 'Running2.png', '', ''),
(141, 'package', 2, 'frontend/app/assets/images/no-image.jpg', 'anh3.jpg', '', ''),
(267, 'service', 85, 'frontend/app/assets/images/no-image.jpg', '1548003974356-1-Legged-Wheel-Pose.jpg', '', ''),
(268, 'service', 85, 'frontend/app/assets/images/no-image.jpg', 'download (1).jpg', '', ''),
(275, 'service', 88, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(276, 'service', 88, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(277, 'service', 88, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(278, 'service', 89, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(279, 'service', 89, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(280, 'service', 89, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(281, 'service', 90, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(282, 'service', 90, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(283, 'service', 90, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(284, 'service', 91, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(285, 'service', 91, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(286, 'service', 91, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(287, 'service', 92, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(288, 'service', 92, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(289, 'service', 92, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(290, 'service', 93, 'frontend/app/assets/images/no-image.jpg', 'd', '', ''),
(291, 'service', 93, 'frontend/app/assets/images/no-image.jpg', 'i', '', ''),
(292, 'service', 93, 'frontend/app/assets/images/no-image.jpg', '6', '', ''),
(531, 'service', 94, 'frontend/app/assets/images/no-image.jpg', '1548003974356-1-Legged-Wheel-Pose.jpg', '', ''),
(534, 'event', 47, 'frontend/app/assets/images/no-image.jpg', '1.jpg', '', ''),
(536, 'event', 47, 'frontend/app/assets/images/no-image.jpg', '3.jpg', '', ''),
(538, 'event', 63, 'frontend/app/assets/images/no-image.jpg', '2.jpg', '', ''),
(540, 'event', 63, 'frontend/app/assets/images/no-image.jpg', '4.jpg', '', ''),
(541, 'event', 64, 'frontend/app/assets/images/no-image.jpg', '03.png', '', ''),
(542, 'event', 64, 'frontend/app/assets/images/no-image.jpg', '06.png', '', ''),
(548, 'event', 71, 'frontend/app/assets/images/no-image.jpg', '1.png', '', ''),
(549, 'event', 71, 'frontend/app/assets/images/no-image.jpg', '2.png', '', ''),
(551, 'event', 71, 'frontend/app/assets/images/no-image.jpg', '5.png', '', ''),
(552, 'event', 72, 'frontend/app/assets/images/no-image.jpg', '1.jpg', '', ''),
(553, 'event', 72, 'frontend/app/assets/images/no-image.jpg', '2.jpg', '', ''),
(555, 'event', 73, 'frontend/app/assets/images/no-image.jpg', '3.jpg', '', ''),
(556, 'event', 73, 'frontend/app/assets/images/no-image.jpg', '4.jpg', '', ''),
(557, 'event', 73, 'frontend/app/assets/images/no-image.jpg', '5.jpg', '', ''),
(559, 'event', 75, 'frontend/app/assets/images/no-image.jpg', '2.jpg', '', ''),
(600, 'service', 97, 'frontend/app/assets/images/no-image.jpg', 'portfolio-1-1-1170x694.jpg', '', ''),
(602, 'event', 45, 'frontend/app/assets/images/no-image.jpg', '555x442_img8.jpg', '', ''),
(603, 'event', 45, 'frontend/app/assets/images/no-image.jpg', '555x442_img9.jpg', '', ''),
(604, 'event', 45, 'frontend/app/assets/images/no-image.jpg', '555x442_img7.jpg', '', ''),
(608, 'event', 47, 'frontend/app/assets/images/no-image.jpg', '7043852_2ce0299dde6cfbd45b992e8aef384a39.jpg', '', ''),
(609, 'event', 63, 'frontend/app/assets/images/no-image.jpg', 'unnamed.jpg', '', ''),
(610, 'event', 64, 'frontend/app/assets/images/no-image.jpg', '960x884_bg1.jpg', '', ''),
(611, 'event', 69, 'frontend/app/assets/images/no-image.jpg', 'image-caption2.jpg', '', ''),
(612, 'event', 69, 'frontend/app/assets/images/no-image.jpg', 'image-caption.jpg', '', ''),
(613, 'event', 72, 'frontend/app/assets/images/no-image.jpg', 'courses-4.jpg', '', ''),
(614, 'event', 75, 'frontend/app/assets/images/no-image.jpg', 'ft-bg-cl3.jpg', '', ''),
(615, 'event', 75, 'frontend/app/assets/images/no-image.jpg', 'service-01.jpg', '', ''),
(616, 'event', 76, 'frontend/app/assets/images/no-image.jpg', 'img_25.jpg', '', ''),
(617, 'event', 76, 'frontend/app/assets/images/no-image.jpg', 'img_11.jpg', '', ''),
(618, 'event', 76, 'frontend/app/assets/images/no-image.jpg', 'img_24.jpg', '', ''),
(621, 'service', 97, 'frontend/app/assets/images/no-image.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(644, 'service', 96, 'frontend/app/assets/images/no-image.jpg', 'sexy-dance-la-gi1.jpg', '', ''),
(645, 'service', 96, 'frontend/app/assets/images/no-image.jpg', 'Boogie_Slide.jpg', '', ''),
(684, 'service', 98, 'upload/services/gallery/QStMPNJ0img3_gallery.jpg', 'img3_gallery.jpg', '', ''),
(685, 'service', 98, 'upload/services/gallery/Y07tamzSimg6_gallery.jpg', 'img6_gallery.jpg', '', ''),
(686, 'service', 98, 'upload/services/gallery/FhzCaWfhimg17_gallery.jpg', 'img17_gallery.jpg', '', ''),
(687, 'service', 98, 'upload/services/gallery/w8xhxqguimg20_gallery.jpg', 'img20_gallery.jpg', '', ''),
(688, 'service', 100, 'upload/services/gallery/u9a03ME7img_gallery.jpg', 'img_gallery.jpg', '', ''),
(690, 'service', 100, 'upload/services/gallery/RFtIuXSnimg17_gallery.jpg', 'img17_gallery.jpg', '', ''),
(691, 'service', 100, 'upload/services/gallery/1jmQnLuImuscular-fitness-man-preparing-deadlift-barbell-his-head-modern-fitness-center-functional-training_136403-900.jpg', 'muscular-fitness-man-preparing-deadlift-barbell-his-head-modern-fitness-center-functional-training_136403-900.jpg', '', ''),
(694, 'service', 100, 'upload/services/gallery/0HdV1AOOimg17_event.jpg', 'img17_event.jpg', '', ''),
(699, 'service', 99, 'upload/services/gallery/CWjO3hrrimg48_service.jpg', 'img48_service.jpg', '', ''),
(702, 'service', 99, 'upload/services/gallery/abk6prxaimg6_gallery.jpg', 'img6_gallery.jpg', '', ''),
(703, 'service', 99, 'upload/services/gallery/ei11J2Gdimg11_gallery.jpg', 'img11_gallery.jpg', '', ''),
(704, 'service', 99, 'upload/services/gallery/M7Xq2xmIimg10_gallery.jpg', 'img10_gallery.jpg', '', ''),
(705, 'service', 45, 'upload/services/gallery/oO0XRZejimg1_gallery.jpg', 'img1_gallery.jpg', '', ''),
(706, 'service', 45, 'upload/services/gallery/PW9tOoFKimg16_gallery.jpg', 'img16_gallery.jpg', '', ''),
(707, 'service', 45, 'upload/services/gallery/ADsiESaoimg32_gallery.jpg', 'img32_gallery.jpg', '', ''),
(708, 'service', 45, 'upload/services/gallery/FaA07YVLimg58_gallery.jpg', 'img58_gallery.jpg', '', ''),
(709, 'service', 46, 'upload/services/gallery/LHEyXcQJ02.jpg', '02.jpg', '', ''),
(710, 'service', 46, 'upload/services/gallery/oRZ81g6X03.jpg', '03.jpg', '', ''),
(711, 'service', 46, 'upload/services/gallery/7BEUw7ne04.jpg', '04.jpg', '', ''),
(712, 'service', 46, 'upload/services/gallery/DJnVVPXW05.jpg', '05.jpg', '', ''),
(713, 'service', 47, 'upload/services/gallery/EEykPCo706.jpg', '06.jpg', '', ''),
(714, 'service', 47, 'upload/services/gallery/vy24VwMh07.jpg', '07.jpg', '', ''),
(715, 'service', 47, 'upload/services/gallery/H88L7P1308.jpg', '08.jpg', '', ''),
(716, 'service', 47, 'upload/services/gallery/4HmhkkD009.jpg', '09.jpg', '', ''),
(717, 'service', 48, 'upload/services/gallery/j8sg3SfM10.jpg', '10.jpg', '', ''),
(718, 'service', 48, 'upload/services/gallery/9z96XYtP11.jpg', '11.jpg', '', ''),
(719, 'service', 48, 'upload/services/gallery/H09JaHuP12.jpg', '12.jpg', '', ''),
(720, 'service', 48, 'upload/services/gallery/tYkbZjZH02.jpg', '02.jpg', '', ''),
(721, 'service', 49, 'upload/services/gallery/HY0K0hBI13.jpg', '13.jpg', '', ''),
(722, 'service', 49, 'upload/services/gallery/JRaf8xZv14.jpg', '14.jpg', '', ''),
(723, 'service', 49, 'upload/services/gallery/a1G5NMtg15.jpg', '15.jpg', '', ''),
(724, 'service', 49, 'upload/services/gallery/PTrhxyn316.jpg', '16.jpg', '', ''),
(725, 'service', 50, 'upload/services/gallery/4OSRCIU421.jpg', '21.jpg', '', ''),
(726, 'service', 50, 'upload/services/gallery/v6fnjlTB22.jpg', '22.jpg', '', ''),
(727, 'service', 50, 'upload/services/gallery/HzmcKUPt17.jpg', '17.jpg', '', ''),
(728, 'service', 50, 'upload/services/gallery/iFvsPXNP18.jpg', '18.jpg', '', ''),
(729, 'service', 86, 'upload/services/gallery/ehBPlMtximg2_gallery.jpg', 'img2_gallery.jpg', '', ''),
(730, 'service', 86, 'upload/services/gallery/CdU5L5LWimg24_gallery.jpg', 'img24_gallery.jpg', '', ''),
(731, 'service', 86, 'upload/services/gallery/qLBHN1sPimg38_gallery.jpg', 'img38_gallery.jpg', '', ''),
(732, 'service', 86, 'upload/services/gallery/DxhiETNrimg46_gallery.jpg', 'img46_gallery.jpg', '', ''),
(733, 'service', 87, 'upload/services/gallery/9fRAvuZgDance.jpg', 'Dance.jpg', '', ''),
(734, 'service', 87, 'upload/services/gallery/5LnZk9v4dance2_img.jpg', 'dance2_img.jpg', '', ''),
(735, 'service', 87, 'upload/services/gallery/jgjBlKWhdance1_img.jpg', 'dance1_img.jpg', '', ''),
(736, 'service', 87, 'upload/services/gallery/nU8Z3FcQdance3_img.jpg', 'dance3_img.jpg', '', ''),
(737, 'service', 95, 'upload/services/gallery/ngSwpePCdance4_img.jpg', 'dance4_img.jpg', '', ''),
(738, 'service', 95, 'upload/services/gallery/dz6EQ8Gadance5_img.jpg', 'dance5_img.jpg', '', ''),
(739, 'service', 95, 'upload/services/gallery/LdhhffIsdance6_img.jpg', 'dance6_img.jpg', '', ''),
(740, 'service', 95, 'upload/services/gallery/yqhU7kK1dance7_img.jpg', 'dance7_img.jpg', '', ''),
(742, 'service', 51, 'upload/services/gallery/gry9w5Aacardio1.jpg', 'cardio1.jpg', '', ''),
(743, 'service', 51, 'upload/services/gallery/CuakoyMccardio2.jpg', 'cardio2.jpg', '', ''),
(744, 'service', 51, 'upload/services/gallery/o6mvgfOocardio3.jpg', 'cardio3.jpg', '', ''),
(745, 'service', 52, 'upload/services/gallery/5uhbqXQPimg35_gallery.jpg', 'img35_gallery.jpg', '', ''),
(746, 'service', 52, 'upload/services/gallery/SLh5TWZbimg54_gallery.jpg', 'img54_gallery.jpg', '', ''),
(747, 'service', 52, 'upload/services/gallery/5cz7IF7Limg8_gallery.jpg', 'img8_gallery.jpg', '', ''),
(748, 'service', 52, 'upload/services/gallery/reFauvniimg23_gallery.jpg', 'img23_gallery.jpg', '', ''),
(750, 'service', 57, 'upload/services/gallery/jqmIaMvacardio5.jpg', 'cardio5.jpg', '', ''),
(751, 'service', 57, 'upload/services/gallery/Zca8alQXcardio6.jpg', 'cardio6.jpg', '', ''),
(752, 'service', 57, 'upload/services/gallery/3BLGnfWycardio7.jpg', 'cardio7.jpg', '', ''),
(753, 'service', 58, 'upload/services/gallery/T7VUEug6cardio9.jpg', 'cardio9.jpg', '', ''),
(754, 'service', 58, 'upload/services/gallery/0omwZIqXcardio8.jpg', 'cardio8.jpg', '', ''),
(755, 'service', 58, 'upload/services/gallery/STDUfZ6ocardio18.jpg', 'cardio18.jpg', '', ''),
(756, 'service', 58, 'upload/services/gallery/wXqSqz6acardio2.jpg', 'cardio2.jpg', '', ''),
(757, 'service', 59, 'upload/services/gallery/QV7PkVQScardio14.jpg', 'cardio14.jpg', '', ''),
(758, 'service', 59, 'upload/services/gallery/6RJc38AYcardio15.jpg', 'cardio15.jpg', '', ''),
(759, 'service', 59, 'upload/services/gallery/At05tC9jcardio16.jpg', 'cardio16.jpg', '', ''),
(760, 'service', 59, 'upload/services/gallery/CmUdj5UXcardio17.jpg', 'cardio17.jpg', '', ''),
(761, 'service', 60, 'upload/services/gallery/C6qsaYEscardio11.jpg', 'cardio11.jpg', '', ''),
(762, 'service', 60, 'upload/services/gallery/psXu8ACOcardio12.jpg', 'cardio12.jpg', '', ''),
(765, 'service', 61, 'upload/services/gallery/VallgMt0body1.jpg', 'body1.jpg', '', ''),
(766, 'service', 61, 'upload/services/gallery/GX468ZkPbody2.jpg', 'body2.jpg', '', ''),
(767, 'service', 61, 'upload/services/gallery/PJhda3r6body3.jpg', 'body3.jpg', '', ''),
(768, 'service', 61, 'upload/services/gallery/4ZWYV3kvbody4.jpg', 'body4.jpg', '', ''),
(769, 'service', 62, 'upload/services/gallery/cbZy8tfyJudo.jpg', 'Judo.jpg', '', ''),
(770, 'service', 62, 'upload/services/gallery/wzbO4GPijudo1.jpg', 'judo1.jpg', '', ''),
(771, 'service', 62, 'upload/services/gallery/bGYzDyiUjudo2.jpg', 'judo2.jpg', '', ''),
(772, 'service', 62, 'upload/services/gallery/xw14YsDAjudo3.jpg', 'judo3.jpg', '', ''),
(773, 'service', 63, 'upload/services/gallery/AbO5iulyjudo6.jpg', 'judo6.jpg', '', ''),
(774, 'service', 63, 'upload/services/gallery/eNw4YqDTjudo7.jpg', 'judo7.jpg', '', ''),
(775, 'service', 63, 'upload/services/gallery/CbzWU3Qojudo9.jpg', 'judo9.jpg', '', ''),
(776, 'service', 63, 'upload/services/gallery/eNDko5JHjudo10.jpg', 'judo10.jpg', '', ''),
(777, 'service', 64, 'upload/services/gallery/XT5dcJ8Xk2.jpg', 'k2.jpg', '', ''),
(778, 'service', 64, 'upload/services/gallery/GYzSDtfMk1.jpg', 'k1.jpg', '', ''),
(779, 'service', 64, 'upload/services/gallery/1YhITZyAk3.jpg', 'k3.jpg', '', ''),
(780, 'service', 64, 'upload/services/gallery/9GK7GhDYk4.jpg', 'k4.jpg', '', ''),
(781, 'service', 65, 'upload/services/gallery/JIzhZUeqtkd1.jpg', 'tkd1.jpg', '', ''),
(782, 'service', 65, 'upload/services/gallery/WF2bFOOotkd2.jpg', 'tkd2.jpg', '', ''),
(784, 'service', 65, 'upload/services/gallery/DrU9fqFUtkd4.jpg', 'tkd4.jpg', '', ''),
(785, 'service', 66, 'upload/services/gallery/tOeJWv62kra1.jpg', 'kra1.jpg', '', ''),
(786, 'service', 66, 'upload/services/gallery/RYLQlqFqkra2.jpg', 'kra2.jpg', '', ''),
(787, 'service', 66, 'upload/services/gallery/AErIPRX5kra3.jpg', 'kra3.jpg', '', ''),
(788, 'service', 66, 'upload/services/gallery/jZtHx378kra4.jpg', 'kra4.jpg', '', ''),
(789, 'service', 67, 'upload/services/gallery/ou7SD2yCbb1_img.jpg', 'bb1_img.jpg', '', ''),
(790, 'service', 67, 'upload/services/gallery/DoMNYBSgbb2_img.jpg', 'bb2_img.jpg', '', ''),
(791, 'service', 67, 'upload/services/gallery/PyGp27ctbb3_img.jpg', 'bb3_img.jpg', '', ''),
(792, 'service', 67, 'upload/services/gallery/khAZiJNvbb4_img.jpg', 'bb4_img.jpg', '', ''),
(793, 'service', 68, 'upload/services/gallery/wYl8ritKbb5.jpg', 'bb5.jpg', '', ''),
(794, 'service', 68, 'upload/services/gallery/dh8gRKYAbb7.jpg', 'bb7.jpg', '', ''),
(795, 'service', 68, 'upload/services/gallery/fP3ZIxC4img17_gallery.jpg', 'img17_gallery.jpg', '', ''),
(796, 'service', 68, 'upload/services/gallery/ye2q8kSAimg60_gallery.jpg', 'img60_gallery.jpg', '', ''),
(797, 'service', 69, 'upload/services/gallery/f7pzzWITbb9.jpg', 'bb9.jpg', '', ''),
(798, 'service', 69, 'upload/services/gallery/1y105cozimg3_gallery.jpg', 'img3_gallery.jpg', '', ''),
(799, 'service', 69, 'upload/services/gallery/96RvKmgjimg33_gallery.jpg', 'img33_gallery.jpg', '', ''),
(800, 'service', 69, 'upload/services/gallery/akdPbcgmimg17_gallery.jpg', 'img17_gallery.jpg', '', ''),
(801, 'service', 70, 'upload/services/gallery/igKsjLCObb14.jpg', 'bb14.jpg', '', ''),
(802, 'service', 70, 'upload/services/gallery/S4f56rSjbb13.jpg', 'bb13.jpg', '', ''),
(803, 'service', 70, 'upload/services/gallery/Xfan9utDbb11.jpg', 'bb11.jpg', '', ''),
(804, 'service', 70, 'upload/services/gallery/HQHspUUrbb12.jpg', 'bb12.jpg', '', ''),
(805, 'service', 71, 'upload/services/gallery/nyKsXJdabb18.jpg', 'bb18.jpg', '', ''),
(806, 'service', 71, 'upload/services/gallery/uFdcDG3obb17.jpg', 'bb17.jpg', '', ''),
(807, 'service', 71, 'upload/services/gallery/x5x2opaPimg35_gallery.jpg', 'img35_gallery.jpg', '', ''),
(808, 'service', 71, 'upload/services/gallery/sGkpPWKTimg6_gallery.jpg', 'img6_gallery.jpg', '', ''),
(809, 'service', 72, 'upload/services/gallery/QangV9Sfbb14.jpg', 'bb14.jpg', '', ''),
(810, 'service', 72, 'upload/services/gallery/FWnX7knRbb3_img.jpg', 'bb3_img.jpg', '', ''),
(811, 'service', 72, 'upload/services/gallery/Ji3jGiobbb7.jpg', 'bb7.jpg', '', ''),
(812, 'service', 72, 'upload/services/gallery/yRcQAKxDbb1_img.jpg', 'bb1_img.jpg', '', ''),
(813, 'service', 101, 'upload/services/gallery/6zEOHM7vimg35_gallery.jpg', 'img35_gallery.jpg', '', ''),
(814, 'service', 101, 'upload/services/gallery/pstegqCuimg9_gallery.jpg', 'img9_gallery.jpg', '', ''),
(815, 'service', 101, 'upload/services/gallery/YRcuhHnMimg48_gallery.jpg', 'img48_gallery.jpg', '', ''),
(816, 'service', 101, 'upload/services/gallery/SfK8FzNOimg17_gallery.jpg', 'img17_gallery.jpg', '', ''),
(818, 'service', 57, 'upload/services/gallery/qcJKJm3Mcardio2.jpg', 'cardio2.jpg', '', ''),
(819, 'service', 51, 'upload/services/gallery/pYbQbYY6cardio7.jpg', 'cardio7.jpg', '', ''),
(820, 'service', 60, 'upload/services/gallery/BAxdW4zhbb13.jpg', 'bb13.jpg', '', ''),
(821, 'service', 60, 'upload/services/gallery/gtnr3JkIimg18_gallery.jpg', 'img18_gallery.jpg', '', ''),
(822, 'service', 65, 'upload/services/gallery/ModftB2zk2.jpg', 'k2.jpg', '', ''),
(823, 'service', 102, 'upload/services/gallery/XGY6FIIz06.jpg', '06.jpg', '', ''),
(824, 'service', 102, 'upload/services/gallery/w4A6AQ7q04.jpg', '04.jpg', '', ''),
(828, 'vendor', 4, 'upload/vendor/gallery/mPjO4nBBpreview banner.jpg', 'preview banner.jpg', '', ''),
(829, 'vendor', 4, 'upload/vendor/gallery/m6Zce5OByoga-banner-template_23-2148670330.jpg', 'yoga-banner-template_23-2148670330.jpg', '', ''),
(830, 'vendor', 4, 'upload/vendor/gallery/QvEmlIeZbanner-OmLightYoga_low_cargo_600.jpg', 'banner-OmLightYoga_low_cargo_600.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\"],\"vendor\":[\"watch\"]}', 'super-admin', 0, 1, ''),
(3, 'Admin', '{\"access_backend\":[\"watch\"],\"calendar\":[\"watch\",\"edit\"],\"block\":[\"watch\",\"edit\"],\"appointment\":[\"watch\",\"edit\"],\"activities\":[\"watch\",\"edit\"],\"category\":[\"watch\",\"edit\"],\"config\":[\"watch\",\"edit\"],\"countries\":[\"watch\",\"edit\"],\"customer\":[\"watch\",\"edit\"],\"customers\":[\"watch\",\"edit\"],\"groupuser\":[\"watch\",\"edit\"],\"event\":[\"watch\",\"edit\"],\"employee\":[\"watch\",\"edit\"],\"dashboard\":[\"watch\",\"edit\"],\"customize\":[\"watch\",\"edit\"],\"location\":[\"watch\",\"edit\"],\"orderpackages\":[\"watch\",\"edit\"],\"orderstatus\":[\"watch\",\"edit\"],\"package\":[\"watch\",\"edit\"],\"payment\":[\"watch\",\"edit\"],\"states\":[\"watch\",\"edit\"],\"smscontent\":[\"watch\",\"edit\"],\"sms\":[\"watch\",\"edit\"],\"service\":[\"watch\",\"edit\"],\"review\":[\"watch\",\"edit\"],\"tool\":[\"watch\",\"edit\"],\"user\":[\"watch\",\"edit\"],\"vendor\":[\"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,
  `user_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,
  `phonecode` int(5) NOT NULL,
  `countrycode` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `woobooking_location` (`id`, `user_id`, `name`, `banner`, `image_location_avatar`, `map_image`, `address`, `phonecode`, `countrycode`, `mobile`, `alias`, `state_id`, `lang`, `lat`, `iframe`, `published`, `ordering`, `image`, `description`) VALUES
(3, 0, 'Brooklyn', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '130 Water St, Brooklyn, NY 11201, USA', 0, '', 0, 'address2', 6, '-73.9911912', '40.7029769', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3024.679496085888!2d-73.99114638509586!3d40.703055846100554!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c25a163b1654d3%3A0xc5475d6cd7ac2897!2s130%20Water%20St%2C%20Brooklyn%2C%20NY%2011201%2C%20USA!5e0!3m2!1sen!2s!4v1588141350262!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'frontend/app/assets/images/no-image.jpg', 'The gym is designed in a sophisticated manner, divided into separate training areas, Yoga and fitness group GroupX international group with high-class furnishings and modern equipment, bringing customers. Experience the most professional and comfortable training.'),
(4, 0, 'Jerome Ave', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '3594 Jerome Ave, The Bronx, NY 10467, USA', 0, '', 0, '', 6, '-73.8812917', '40.885261', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d5072.913119652178!2d-73.88379803060577!3d40.885649967257365!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c2f30e4f5dbd6f%3A0x5f76df8c91dcf1b5!2s3594%20Jerome%20Ave%2C%20The%20Bronx%2C%20NY%2010467%2C%20USA!5e0!3m2!1sen!2s!4v1588141735100!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'frontend/app/assets/images/no-image.jpg', 'With more than 150 Yoga classes, GroupX group fitness and services are constantly updated, discover the right bodybuilding method\r\nIn line with your fitness needs and fitness!'),
(5, 0, 'Lexington Ave', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '1395 Lexington Ave, New York, NY 10128', 0, '', 0, '', 6, '-73.954611', '40.7829333', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3021.049346486735!2d-73.9546109845929!3d40.78292927932421!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c258a48b1fa1b3%3A0x6ea61ed572d0988e!2s1395%20Lexington%20Ave%2C%20New%20York%2C%20NY%2010128%2C%20USA!5e0!3m2!1sen!2s!4v1588133989047!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 1, 0, 'frontend/app/assets/images/no-image.jpg', 'With the gym, the system is located at the most prime location in the central district in the city. New York, your practice will become more convenient and easier.'),
(14, 0, 'Canal', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '277 Canal St, New York, NY 10013', 0, '', 0, '', 6, '-74.003579', '40.7194317', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3023.9357103594716!2d-74.00357898509534!3d40.719431745098674!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c2598a17e4cbf7%3A0x7f752b42bb89c473!2s277%20Canal%20St%2C%20New%20York%2C%20NY%2010013%2C%20USA!5e0!3m2!1sen!2s!4v1588134588047!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, 'frontend/app/assets/images/no-image.jpg', 'Enjoy the gym &amp; yoga chain with sophisticated design and the most perfect service right in the heart of Las Vegas.'),
(15, 0, 'Rome', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', ' Dell\'Angeletto 3, 00184 Rome, Italy', 0, '', 0, '', 7, '12.4890123', '41.8948', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2969.909657374232!2d12.489012314944494!3d41.89479997234884!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x132f61b10a8e4fa9%3A0x59b2ba5e27ecfd56!2sVia%20dell\'Angeletto%2C%203%2C%2000184%20Roma%20RM%2C%20Italy!5e0!3m2!1sen!2s!4v1588135600080!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, 'frontend/app/assets/images/no-image.jpg', 'Transparent glass design, luxurious help expand the connection with the open space.'),
(16, 0, 'Venice', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'frontend/app/assets/images/no-image.jpg', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'Ca\' Farsetti, San Marco 4136 - Venezia - ITALY', 0, '', 0, '', 8, '12.3316516', '45.436493', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d358557.55735744117!2d12.10714115455568!3d45.40468289034315!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x477eb1daf1d63d89%3A0x7ba3c6f0bd92102f!2zVmVuaWNlLCDDnQ!5e0!3m2!1svi!2s!4v1587972244975!5m2!1svi!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, 'frontend/app/assets/images/no-image.jpg', 'With very vibrant and powerful music that keeps the body in rhythm without stopping, the energy of the trainee will consume a lot but the body will not feel tired, so this is the most effective way to lose weight.'),
(17, 0, 'Burggasse', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'Burggasse 121, 1070 Wien', 0, '', 243535623, '', 5, '16.336016', '48.2041446', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2659.128303621273!2d16.336016015176025!3d48.20414455450194!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x476d07f1c20d8e9b%3A0xd5e98eb3edc3c548!2sBurggasse%20121%2C%201070%20Wien%2C%20Austria!5e0!3m2!1sen!2s!4v1588135161350!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, '', 'With a modern, luxurious design, fully integrated with the practice, and located right at Burggasse 121, 1070 Wien, Austria'),
(18, 0, 'Gaillon', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'Gaillon 75002 Paris', 0, '', 0, '', 9, '2.3303288', '48.869259', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d5248.84073548007!2d2.3281400759220605!3d48.86926242437598!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x47e66e305f348f31%3A0xe10bbd11182c505b!2sGaillon%2C%2075002%20Paris%2C%20France!5e0!3m2!1sen!2s!4v1588136399475!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, '', ''),
(19, 0, 'Porte-Saint-Denis', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', '', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/plugins/frontend/app/assets/images/no-image.jpg', 'Porte-Saint-Denis, 75010 Paris, France', 0, '', 0, '', 9, '2.3487476', '48.873351', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d5248.411831869519!2d2.348747625922743!3d48.873350973800996!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x47e66e13a6983799%3A0xb3e15b7d827aee38!2sPorte-Saint-Denis%2C%2075010%20Paris%2C%20France!5e0!3m2!1sen!2s!4v1588143021464!5m2!1sen!2s\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 0, 0, '', '');

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

--
-- Table structure for table `woobooking_notification`
--

DROP TABLE IF EXISTS `woobooking_notification`;
CREATE TABLE `woobooking_notification` (
  `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,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

DROP TABLE IF EXISTS `woobooking_order`;
CREATE TABLE `woobooking_order` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `is_recurring` tinyint(1) NOT NULL,
  `type_recurring` varchar(200) NOT NULL,
  `payment_schedule` varchar(200) NOT NULL,
  `number_month_recurring` int(11) NOT NULL,
  `number_week_recurring` int(11) NOT NULL,
  `comment_addition` text NOT NULL,
  `open_source_order_id` int(11) NOT NULL,
  `open_source_order_status_id` varchar(50) DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `deposit_payment` float NOT NULL,
  `balance_payment` float NOT NULL,
  `total` double NOT NULL,
  `payment_paid` float NOT NULL,
  `open_source_payment_id` varchar(50) 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,
  `modify_date` datetime NOT NULL,
  `is_send_message` tinyint(1) NOT NULL,
  `time_send_sms` bigint(20) NOT NULL,
  `day_ordinal` int(11) NOT NULL,
  `order_status_alias` varchar(255) NOT NULL,
  `all_or_specific` varchar(255) NOT NULL,
  `specific_day` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_order_customer`
--

DROP TABLE IF EXISTS `woobooking_order_customer`;
CREATE TABLE `woobooking_order_customer` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_order_day_recurring`
--

DROP TABLE IF EXISTS `woobooking_order_day_recurring`;
CREATE TABLE `woobooking_order_day_recurring` (
  `id` int(11) UNSIGNED NOT NULL,
  `order_id` int(11) NOT NULL,
  `monday` tinyint(1) NOT NULL,
  `tuesday` int(1) NOT NULL,
  `wednesday` int(1) NOT NULL,
  `thursday` int(1) NOT NULL,
  `friday` int(1) NOT NULL,
  `saturday` int(1) NOT NULL,
  `sunday` int(1) 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;

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

--
-- 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,
  `service_id` int(11) 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,
  `employee_id` int(11) NOT NULL,
  `extra_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `quantity` int(11) NOT NULL,
  `deposit_payment` float NOT NULL,
  `balance_payment` float NOT NULL,
  `subtotal` float NOT NULL,
  `total` float NOT NULL,
  `payment_paid` 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,
  `service_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `date_start_recurring` date NOT NULL,
  `date_end_recurring` date NOT NULL,
  `time_start_recurring` time NOT NULL,
  `time_end_recurring` time NOT NULL,
  `timezone` time NOT NULL,
  `open_source_link_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `extra_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `order_detail_id` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `quantity` int(11) NOT NULL,
  `deposit_payment` float NOT NULL,
  `balance_payment` float NOT NULL,
  `subtotal` float NOT NULL,
  `rate_id` int(11) NOT NULL,
  `total` float NOT NULL,
  `payment_paid` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_order_package`
--

DROP TABLE IF EXISTS `woobooking_order_package`;
CREATE TABLE `woobooking_order_package` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `service_id` int(11) 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,
  `employee_id` int(11) NOT NULL,
  `extra_id` int(11) NOT NULL,
  `price` 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_order_package_rate`
--

DROP TABLE IF EXISTS `woobooking_order_package_rate`;
CREATE TABLE `woobooking_order_package_rate` (
  `id` int(11) NOT NULL,
  `order_package_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `location_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `subtotal` float NOT NULL,
  `rate_id` int(11) 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,
  `title` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `data` text NOT NULL,
  `open_source_order_status_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `woobooking_order_status` (`id`, `name`, `title`, `ordering`, `alias`, `data`, `open_source_order_status_id`) VALUES
(4, 'Pending', 'Pending', 0, '', '', 'pending'),
(5, 'Completed', 'Completed', 0, '', '', 'completed'),
(6, 'Processing', 'Processing', 0, '', '', 'processing'),
(7, 'On hold', 'On hold', 0, '', '', 'on-hold'),
(8, 'Canceled', 'Canceled', 0, '', '', 'cancelled'),
(9, 'Refunded', 'Refunded', 0, '', '', 'refunded'),
(10, 'Failed', 'Failed', 0, '', '', 'failed');

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

--
-- Table structure for table `woobooking_package`
--

DROP TABLE IF EXISTS `woobooking_package`;
CREATE TABLE `woobooking_package` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `name` varchar(200) NOT NULL,
  `params` mediumtext NOT NULL,
  `price` double NOT NULL,
  `published` int(11) NOT NULL,
  `package_color` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_package_event`
--

DROP TABLE IF EXISTS `woobooking_package_event`;
CREATE TABLE `woobooking_package_event` (
  `id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_package_tag`
--

DROP TABLE IF EXISTS `woobooking_package_tag`;
CREATE TABLE `woobooking_package_tag` (
  `id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_payment`
--

DROP TABLE IF EXISTS `woobooking_payment`;
CREATE TABLE `woobooking_payment` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` varchar(50) NOT NULL,
  `is_payment_online` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `debug` int(11) NOT NULL,
  `open_source_payment_id` varchar(50) NOT NULL,
  `image` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `ordering` int(11) NOT NULL,
  `params` mediumtext NOT NULL,
  `published` int(11) NOT NULL,
  `description` text NOT NULL,
  `event_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_payment`
--

INSERT INTO `woobooking_payment` (`id`, `type`, `is_payment_online`, `name`, `debug`, `open_source_payment_id`, `image`, `alias`, `ordering`, `params`, `published`, `description`, `event_id`, `location_id`) VALUES
(20, 'paypal', 1, 'Paypal', 0, 'paypal', 'frontend/app/assets/images/no-image.jpg', '', 5, '{\"payment_params\":{\"email\":\"digitalsolutiontoppro@gmail.com\"}}', 1, '', 0, 0),
(72, 'banktransfer', 0, 'Banktransfer', 0, 'bacs', 'frontend/app/assets/images/no-image.jpg', '', 0, 'null', 1, '', 0, 0);

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

--
-- 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` text NOT NULL,
  `dashboard` text NOT NULL,
  `appointment` text NOT NULL,
  `service` text NOT NULL,
  `employee` text NOT NULL,
  `category` text NOT NULL,
  `coupon` text NOT NULL,
  `currency` text NOT NULL,
  `calendar` text NOT NULL,
  `payment` text NOT NULL,
  `wishlist` text NOT NULL,
  `sms` text NOT NULL,
  `smscontent` text NOT NULL,
  `countries` text NOT NULL,
  `states` text NOT NULL,
  `location` text NOT NULL,
  `customer` text NOT NULL,
  `customize` text NOT NULL,
  `groupuser` text NOT NULL,
  `user` text NOT NULL,
  `vendor` text NOT NULL,
  `review` text NOT NULL,
  `config` text NOT NULL,
  `orderstatus` text 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_permission`
--

INSERT INTO `woobooking_permission` (`id`, `group_user_id`, `access_backend`, `dashboard`, `appointment`, `service`, `employee`, `category`, `coupon`, `currency`, `calendar`, `payment`, `wishlist`, `sms`, `smscontent`, `countries`, `states`, `location`, `customer`, `customize`, `groupuser`, `user`, `vendor`, `review`, `config`, `orderstatus`, `ordering`, `published`, `description`) VALUES
(27, 1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(28, 2, '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '', '', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', '[\"watch\"]', 0, 0, ''),
(30, 4, '[\"watch\"]', '', '', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(31, 5, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(32, 6, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, ''),
(34, 3, '[\"watch\"]', '[\"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\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', '[\"watch\",\"edit\"]', 0, 0, '');

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

--
-- Table structure for table `woobooking_rate`
--

DROP TABLE IF EXISTS `woobooking_rate`;
CREATE TABLE `woobooking_rate` (
  `id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `object_id` int(11) NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  `ordering` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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,
  `rating_vendor` 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`, `rating_vendor`) 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, 0),
(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, 0),
(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, 0),
(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, 0),
(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, 0),
(6, 'Mr.Trange ', 'Trange@gmail.com', 'Good job', 0, 1, 'The staff were very enthusiastic, attentive, unique treatments, I really felt very comfortable', '2020-10-31 04:43:04', 0, 0, 0, 0, 5);

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

--
-- Table structure for table `woobooking_service`
--

DROP TABLE IF EXISTS `woobooking_service`;
CREATE TABLE `woobooking_service` (
  `id` int(11) NOT NULL,
  `category_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `meta_keyword` varchar(255) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `duration` float NOT NULL,
  `open_time` time NOT NULL,
  `close_time` time NOT NULL,
  `working_day` text NOT NULL,
  `phonecode` int(5) NOT NULL,
  `countrycode` varchar(200) NOT NULL,
  `mobile` int(15) NOT NULL,
  `params` mediumtext NOT NULL,
  `price` float NOT NULL,
  `open_source_link_id` int(11) NOT NULL,
  `buffer_time_before` float NOT NULL,
  `ordering` int(11) NOT NULL,
  `buffer_time_after` float NOT NULL,
  `minimum_capacity` int(11) NOT NULL,
  `maximum_capacity` int(11) NOT NULL,
  `bringing_anyone` int(11) NOT NULL,
  `price_will_multiply` int(11) NOT NULL,
  `published` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `multiply_number` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `service_color` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `disable_payment_online` int(11) NOT NULL,
  `description` text NOT NULL,
  `distance` float NOT NULL,
  `deposit_percent` int(5) NOT NULL,
  `our_service` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_service`
--

INSERT INTO `woobooking_service` (`id`, `category_id`, `user_id`, `alias`, `meta_keyword`, `meta_description`, `duration`, `open_time`, `close_time`, `working_day`, `phonecode`, `countrycode`, `mobile`, `params`, `price`, `open_source_link_id`, `buffer_time_before`, `ordering`, `buffer_time_after`, `minimum_capacity`, `maximum_capacity`, `bringing_anyone`, `price_will_multiply`, `published`, `location_id`, `multiply_number`, `name`, `service_color`, `image`, `disable_payment_online`, `description`, `distance`, `deposit_percent`, `our_service`) VALUES
(45, 20, 4, 'hatha-yoga', 'Hatha Yoga', 'Hatha Yoga', 1.5, '09:00:00', '23:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 209, 0, 0, 1, 4, 12, 1, 0, 1, 3, 1, 'Hatha Yoga', '', 'upload/service/images/cover/zH1ZcPcEimg4_service.jpg', 1, 'The oldest form of yoga, the foundation for many other types of yoga, is slow and gentle, helping to balance the physical and mental. Hatha Yoga can also teach at a fast, continuous pace and many more advanced variants with Hatha Flow, Hatha Vinyasa ... depending on the strength of the student. This class helps to balance the mind and the mind, suitable for people who practice at any level.\r\nHatha Satwa is especially good for beginners because of its lightness and purity.', 13150.9, 0, ''),
(46, 20, 4, 'vinyasa-yoga', 'Vinyasa Yoga', 'Vinyasa Yoga', 1, '08:00:00', '18:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 67876788, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 60, 142, 0, 0, 1, 3, 20, 1, 0, 1, 5, 1, 'Vinyasa Yoga', '', 'upload/service/images/cover/0XoocgxBimg5_service.jpg', 1, 'Vinyasa is the connection between the mind and the continuous movements, the sweat generated by the heat of Vinyasa brings impurities out of the body. This technique is sometimes also referred to as Vinyasa flow because the poses move smoothly like a dance. Through Vinyasa training, you will have a healthy body, toned, and increased physical fitness more effectively.', 13142, 0, ''),
(47, 20, 4, 'gentle-yoga', 'Gentle Yoga', 'Gentle Yoga', 1.5, '07:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 985456765, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 45, 179, 0, 0, 1, 5, 10, 1, 0, 1, 15, 1, 'Gentle Yoga', '', 'upload/service/images/cover/0IvWyrOQimg1_service.jpg', 1, 'A combination of slow and simple poses, but with a profound impact on the musculoskeletal system. This is a basic, light, and relaxing class so it is very suitable for beginners but equally important for those who have experience practicing in protecting the body from joint injuries. Musculoskeletal. Improve musculoskeletal and joint problems, recover quickly after injury; Helping the body recover quickly related to cardiovascular problems; Health promotion.', 8729.42, 0, ''),
(48, 20, 4, 'pregnant-yoga', 'Pregnant Yoga', 'Pregnant Yoga', 2, '07:00:00', '21:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 2147483647, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 80, 180, 0, 0, 1, 4, 18, 1, 0, 1, 4, 1, 'Pregnant Yoga', '', 'upload/service/images/cover/4LGgo0Amimg2_service.jpg', 1, 'You’re expecting? Congratulations! You must be – excited, scared, happy, and overwhelmed – all at the same time. It’s difficult to put your finger on just what you’re feeling, isn’t it? The kicks are delightful, but the cramps are debilitating. You might be glowing with enthusiasm one moment and overcome with emotion the next. Nothing quite explains the feeling of having a life growing inside you. You may also experience a fair share of mood swings; courtesy of hormonal changes. This is precisely why yoga can be a godsend for you during pregnancy.', 13130.6, 0, ''),
(49, 20, 4, 'hot-yoga', 'Hot Yoga', 'Hot Yoga', 1, '08:00:00', '21:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 243535623, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 40, 181, 0, 0, 1, 6, 12, 1, 0, 1, 17, 1, 'Hot Yoga', '', 'upload/service/images/cover/Qypn5wL6img7_service.jpg', 1, 'Hot Yoga is a unique subject, students practice in a room with a temperature of 35-38 degrees C, stimulating sweating to increase the ability to detox. In the world, Hot Yoga has become an indispensable friend of Hollywood stars and international music such as Madonna, Lady Gaga, Beyonce, Demi Moor, Robbie Williams, Ashton Kutcher, Matthew McConaughey ...', 8245.01, 0, ''),
(50, 20, 4, 'kundalini-yoga', 'Kundalini Yoga', 'Kundalini Yoga', 1, '08:00:00', '17:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 182, 0, 0, 1, 5, 10, 1, 0, 1, 16, 1, 'Kundalini Yoga', '', 'upload/service/images/cover/5dm7iSmFimg14_service.jpg', 1, 'Kundalini Yoga is a great choice for you, an ideal style of yoga for yogis who want to experience an ancient India and leave the suffering and fatigue of life. Not only that, Kundalini is a type that helps you have a strong spirit and awakens the natural energy source but usually less active in the body. Helps muscles and bones stronger; Avoid headaches, fatigue, stress, chronic back pain and other problems.', 8621.61, 0, ''),
(51, 21, 0, 'spinning-lessons', 'Spinning Lessons', 'Spinning Lessons', 1, '07:00:00', '20:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 2147483647, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 20, 170, 0, 1, 0, 8, 16, 1, 0, 1, 3, 1, 'Spinning Lessons', '', 'upload/service/images/cover/E2dc6JJWimg17_service.jpg', 1, 'The benefits from Spinning meet a long list of health, fitness and lifestyle needs for a broad range of people. Whether you’re a roadie seeking performance gains or a newbie trying to drop a few pounds, Spinning likely has you covered. From saddle to saddle you’ll see the needs of many – regardless of age, gender, lifestyle – met by one experience. That’s why, as fitness options go, few are as dynamic and accommodating as Spinning.', 13150.9, 0, ''),
(52, 21, 0, 'cardio-box', 'Cardio Box', 'Cardio Box', 1.5, '06:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\"]', 0, '', 243535623, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 171, 0, 2, 1, 3, 12, 1, 0, 1, 17, 1, 'Cardio Box', '', 'upload/service/images/cover/XC7XADj0img18_service.jpg', 1, 'Boxing is a brutal, basic sport — and it can also serve as a brutal, basic workout to help you knock out your fitness goals. The Trainer with the energetic spirit will lead your training group to experience exercises with virtual terrain: climbing, climbing over mountain peaks, etc. to train endurance with advanced exercises. From there, you will be surprised to discover the potential athlete in you.', 8245.01, 0, ''),
(57, 21, 0, 'core-hiit', 'Core HIIT', 'Core HIIT', 0, '07:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 78954774, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 30, 172, 0, 3, 1, 6, 16, 1, 0, 1, 3, 1, 'Core HIIT', '', 'upload/service/images/cover/rJ9Mzumoimg50_service.jpg', 1, 'Done right, this type of training will have you burning those extra calories faster than the time it takes to blow dry your hair! Benefit:\r\nBurn 500 - 675 calories in 45 minutes of exercise, increase your cardiovascular fitness and fitness, create attractive toned thighs and buttocks, create group bonds when practicing, build a sense of achievement Your personal identity.', 13150.9, 0, ''),
(58, 21, 0, 'aerobic', 'Aerobic', 'Aerobic', 1, '07:00:00', '19:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 1435432534, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 30, 173, 0, 4, 1, 5, 16, 1, 0, 1, 16, 1, 'Aerobic', '', 'upload/service/images/cover/0jfuaxGacardio19.jpg', 1, 'Against the background of lively music, Aerobic will help you train specifically on the buttocks, thighs, and abdomen of the body. This modern group exercise when selected will help you beat belly fat, firm buttocks, and thighs quickly own slender physique like that.', 8621.61, 0, ''),
(59, 21, 0, 'body-attack', 'Body Attack', 'Body Attack', 1.5, '07:00:00', '21:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 908678907, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 55, 174, 0, 5, 1, 5, 10, 1, 0, 1, 14, 1, 'Body Attack', '', 'upload/service/images/cover/DuUzRk85cardio21.jpg', 1, 'BODYATTACK is a high-intensity exercise class with movements for both beginners and professionals. We combine sports activities like running, kneading, and jumping with strength exercises like push-ups and squats. Exercising primarily for the abdomen and buttocks, assisting in preventing injuries, as well as toning the abdominal muscles. Support devices include strings and dumbbells on the background of vibrant music.', 13149.1, 0, ''),
(60, 21, 0, 'body-combat', 'Body Combat', 'Body Combat', 1, '07:00:00', '20:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 908789876, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 60, 175, 0, 6, 1, 3, 8, 1, 0, 1, 4, 1, 'Body Combat', '', 'upload/service/images/cover/QPqsT0wTcardio22.jpg', 1, 'Body Combat is a combination of martial arts and music. Integrating many martial arts such as Taekwondo, Karate, Boxing, Tai Chi, and Muay Thai, this sport is practiced on a vibrant music background. Classes with vibrant nonstop music, you will be practicing specifically on the abdomen of the body such as the upper abdomen, lower abdomen, intercostal muscles, V-cut muscle. Help you burn fat to make the belly firmer.', 13130.6, 0, ''),
(61, 22, 0, 'mma', 'MMA', 'MMA', 2, '10:00:00', '22:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 906567876, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 80, 183, 0, 0, 1, 4, 12, 1, 0, 1, 5, 1, 'MMA', '', 'upload/service/images/cover/14P6DoDmbody.jpg', 1, 'When competing in this martial art, the participants can use all the attacks such as punches, kicks, objects or clamps ... The goal of MMA is to find a perfect fighting skill from different martial arts. In the world. Immersed in vibrant music, the class consists of a podium step training, training your torso and torso toned, feel the heat spread on the lower body through continuous, moving steps. strength training and cardiovascular training to help buttock, slim waist.', 13142, 0, ''),
(62, 22, 0, 'judo', 'Judo', 'Judo', 1.5, '10:30:00', '20:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 243535623, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 70, 184, 0, 0, 1, 6, 12, 1, 0, 1, 3, 1, 'Judo', '', 'upload/service/images/cover/Gys0YVFZjudo4.jpg', 1, 'Judo offers her students a set of ethical rules, ways of life and ways of life. Practiced today by over 20 million individuals, judo is undoubtedly the most popular fighting sport in the world. Judging from the number of participants, judo is the second most popular sport in all sports, football is the number one.', 13150.9, 0, ''),
(63, 22, 0, 'jiu-jitsu', 'Jiu-Jitsu', 'Jiu-Jitsu', 1.5, '07:00:00', '18:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 70, 185, 0, 0, 1, 4, 8, 1, 0, 1, 14, 1, 'Jiu-Jitsu', '', 'upload/service/images/cover/u4Agos4ajudo8.jpg', 1, 'A special feature of Jiu-Jitsu is to put the opponent in a disadvantageous position then counterattack. That is the attention in the way of attack which is preferred by Jiu-Jitsu fighters. The techniques of this martial art full of antagonism are the cleavage, which attacks the joints of large arteries and the weakest points on the human body.', 13149.1, 0, ''),
(64, 22, 0, 'karate', 'Karate', 'Karate', 1, '09:00:00', '22:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 186, 0, 0, 1, 5, 15, 1, 0, 1, 18, 1, 'Karate', '', 'upload/service/images/cover/PIv9l1a5k.jpg', 1, 'Karate has the techniques of punching, kicking, blocking, dodging, kicking, and hitting techniques. In order to strengthen the supporting moves, Karate uses hips or Kime techniques, to focus the whole body\'s energy force at the time of impact. This discipline gives you a new feeling, helps you quickly reach a standard body, and increase the physical endurance of the body.', 9195.79, 0, ''),
(65, 22, 0, 'taekwondo', 'Taekwondo', 'Taekwondo', 1.5, '06:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 2574354, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 55, 187, 0, 0, 1, 4, 10, 1, 0, 1, 3, 1, 'Taekwondo', '', 'upload/service/images/cover/VEZUzeANtkd.jpg', 1, 'Taekwondo is not only a martial art, it is also considered the \"National martial\" of Korea and represents the martial spirit of the people of the land of kimchi. Now, Taekwondo is not only loved by Koreans, it has become an international sport and developed in many parts of the world.', 13150.9, 0, ''),
(66, 22, 0, 'krav-maga', 'Krav Maga', 'Krav Maga', 1, '09:00:00', '18:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 94753453, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 60, 188, 0, 0, 1, 6, 20, 1, 0, 1, 16, 1, 'Krav Maga', '', 'upload/service/images/cover/enY2TNCjkra.jpg', 1, 'This is an ingenious combination of the quintessence of the techniques of the leading martial arts in the world. This object of concentration focuses on helping the practitioner have defensive skills against dangerous situations. In it, it emphasizes the efficiency and speed of counterattack art.', 8621.61, 0, ''),
(67, 23, 4, 'dumbbell-bench-press', 'Dumbbell Bench Press', 'Dumbbell Bench Press', 1.5, '07:00:00', '17:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 567575755, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 35, 42, 0, 1, 1, 1, 1, 1, 0, 1, 16, 1, 'Dumbbell Bench Press', '', 'upload/service/images/cover/cCgUroszbb_img.jpg', 1, 'Dumbbell Bench Press is a clever combination of equipment exercises such as a small platform, horizontal bars and a few pairs of weightlifting music. Normally, weights used in exercises are lighter than heavy weights for bodybuilding, but it can be very effective when you repeat it many times.', 8621.61, 0, ''),
(68, 23, 4, 'german-volume-training', 'German Volume Training', 'German Volume Training', 1.5, '08:10:00', '19:40:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 243535623, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 2, 60, 0, 2, 1, 7, 15, 1, 0, 1, 14, 1, 'German Volume Training', '', 'upload/service/images/cover/LB5pSWGYimgg.jpg', 1, 'This is a combination of exercises using equipment such as small platforms, bars and a few pairs of weights on the lively music. Typically, the weights used in exercises are lighter in weight than heavy weights for bodybuilding, but they can be very effective when you repeat them over and over again.', 13149.1, 0, ''),
(69, 23, 4, 'upper-lower-split-training', 'Upper/Lower Split Training', 'Upper/Lower Split Training', 1, '06:30:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 904567567, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 35, 166, 0, 3, 1, 8, 25, 1, 0, 1, 4, 1, 'Upper/Lower Split Training', '', 'upload/service/images/cover/htGanrZ7bb10.jpg', 1, 'An upper/lower workout split is a training style that breaks your workout sessions down into two categories: Upper body workout days and lower body workout days.\r\nOn upper body workout days, you will train the muscles of the upper body. This will include the chest, shoulders, back, biceps, triceps, traps, forearms, and possibly core.\r\nOn lower body workout days, you’ll focus on the muscles of the lower body. This will include the lower back, quads, hamstrings, glutes, calves, and possibly core.', 13130.6, 0, ''),
(70, 23, 4, 'tactical-strength-training', 'Tactical Strength Training', 'Tactical Strength Training', 2, '10:00:00', '21:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 346456245, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 60, 167, 0, 4, 1, 5, 15, 1, 0, 1, 17, 1, 'Tactical Strength Training', '', 'upload/service/images/cover/an086Whnbb15.jpg', 1, 'Tactical power allows athletes the ability to prevent injuries, increase strength, speed, and agility. But strength is also the early stage of building muscle endurance. Taking the foundation of your strength and developing it into a muscular endurance and work capacity is the main difference between the typical maximum strength (1RM) used in athletic and strength training strong tactics.', 8245.01, 0, ''),
(71, 23, 4, 'fst-7', 'FST-7', 'FST-7', 1.5, '07:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\",\"Sunday\"]', 0, '', 15563463, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 168, 0, 5, 1, 3, 6, 1, 0, 1, 3, 1, 'FST-7', '', 'upload/service/images/cover/DKJSBDvlbb16.jpg', 1, 'The FST 7 method is used for professionals who have reached their limits and want to grow bigger. Therefore, to follow this bodybuilding lesson plan, you must know how to practice the exercises very well. Or to put it more simply, this is an advanced fitness lesson plan. Exercising primarily for the abdomen and buttocks, assisting in preventing injuries, as well as toning the abdominal muscles. Support devices include strings and dumbbells on the background of vibrant music.', 13150.9, 0, ''),
(72, 23, 4, 'weight-training-advanced', 'Weight Training – Advanced', 'Weight Training – Advanced', 2.5, '07:00:00', '17:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 90234567, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 100, 169, 0, 6, 1, 3, 10, 1, 0, 1, 4, 1, 'Weight Training – Advanced', '', 'upload/service/images/cover/Ks67cPkmbb19.jpg', 1, 'This is a high-intensity, circuit type workout and you need to have a reasonable fitness to cope with this intensity. If you feel you are not handling it well, do only one circuit rather than degrade the intensity of the workout — or revert to a moderate intensity program. Regular medical checkups are always worthwhile. This discipline gives you a new feeling, helps you quickly reach a standard body, and increase the physical endurance of the body.', 13130.6, 0, ''),
(86, 70, 0, 'dance-fit', 'Dance Fit', 'Dance Fit', 1, '08:00:00', '21:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 98456768, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 50, 189, 0, 0, 1, 10, 30, 1, 0, 1, 3, 1, 'Dance Fit', '', 'upload/service/images/cover/vAqFAhbRimg34_service.jpg', 1, 'Dance Fit is a combination of dance and Cardio exercises that burn a lot of energy. The department uses vibrant Pop, Rock, EDM and Kpop exercises with simple modern movements. With very vibrant and powerful music that keeps the body in rhythm without stopping, the energy of the trainee will consume a lot but the body will not feel tired, so this is the most effective way to lose weight.', 13150.9, 0, ''),
(87, 70, 0, 'sexy-dance', 'Sexy Dance', 'Sexy Dance', 1, '07:00:00', '18:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 909987789, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 65, 190, 0, 0, 1, 15, 50, 1, 0, 1, 14, 1, 'Sexy Dance', '', 'upload/service/images/cover/0TnXI3w2img38_service.jpg', 1, 'Sexy Dance is a discipline that combines the most attractive dance styles to help women with a flexible and toned body. The rotation of breasts, shaking the buttocks and sexy standing poses will help improve and change the increasingly sexy body shape. Benefit:\r\nHighlight body curves, healthy, toned, seductive body, improve breasts 1, 3 through body shaking exercises, chest rotation, energy consumption to reduce belly fat to create a slim waist, Train your confidence.', 13149.1, 0, ''),
(95, 70, 0, 'freestyle-dance', 'Freestyle Dance', 'Freestyle Dance', 0, '07:00:00', '17:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 908876678, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 39, 191, 0, 0, 0, 10, 45, 1, 0, 1, 16, 1, 'Freestyle Dance', '', 'upload/service/images/cover/jZPUMpwwimg42_service.jpg', 1, 'Freestyle Dance is a dance that focuses on expressing your emotions as well as body movements. Coming to this subject, it will be a good opportunity for everyone to exercise, to be exposed to a vibrant environment, teamwork, and a stepping stone for those who want to develop in the way of art.', 8621.61, 0, ''),
(99, 68, 0, 'total-body-barbell', 'Total Body Barbell', 'Total Body Barbell', 0, '10:00:00', '22:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 789789678, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 49, 176, 0, 1, 1, 5, 29, 1, 0, 1, 14, 1, 'Total Body Barbell', '', 'upload/service/images/cover/IlnLtYk8service1_img.jpg', 1, 'Use barbell weight to change and enhance the strength of large muscle groups. Your instructor will guide you to practice with energetic tracks and increase the efficiency of the exercises. You will feel the durability, flexibility, sensitivity, and confidence of the body is increasing.\r\nThis course helps you cope and overcome the pressures of work and life better.', 13149.1, 0, ''),
(100, 68, 0, 'killer-core', 'Killer Core', 'Killer Core', 0, '08:10:00', '21:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 57, 178, 0, 3, 0, 15, 20, 1, 0, 1, 17, 1, 'Killer Core', '', 'upload/service/images/cover/lltH77zdgym1_service.jpg', 1, 'Depending on the purpose of the exercise, ability, and hobby, the practitioner will choose the right weight for you such as dumbbells, blow weights, warm weights, dumbbells, ... with a variety of different weights.\r\nIncrease the best strength and muscle.\r\nIncrease endurance, self-determination.\r\nCheap workout equipment, easy to buy.', 8245.01, 0, ''),
(101, 68, 0, 'hard-core-abs', 'Hard Core Abs', 'Hard Core Abs', 0, '06:00:00', '19:30:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"]', 0, '', 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/\",\"instagram\":\"https:\\/\\/www.instagram.com\\/?hl=vi\"}', 25, 177, 0, 2, 0, 10, 28, 1, 0, 1, 3, 1, 'Hard Core Abs', '', 'upload/service/images/cover/aiIxwB8rimg47_service.jpg', 1, 'The class uses high-level abdominal exercises, designed to give you the perfect muscle, especially the abdominal muscles. Depending on the purpose of exercise, ability and hobby, the practitioner will choose the right weight for you such as: dumbbells, blow weights, warm weights, dumbbells, ... with a variety of different weights.', 13150.9, 0, ''),
(102, 71, 0, 'yoga-hatha', 'Yoga Hatha', 'Yoga Hatha', 1, '07:00:00', '18:00:00', '[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\"]', 0, '', 24835734, '{\"facebook\":\"\",\"instagram\":\"\"}', 20, 81, 0, 0, 0, 6, 20, 1, 0, 1, 3, 1, 'Yoga Hatha', '#e6194b', 'upload/service/images/cover/RordWaoX05.jpg', 1, 'Great service', 13150.9, 0, '');

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

--
-- Table structure for table `woobooking_service_coupon`
--

DROP TABLE IF EXISTS `woobooking_service_coupon`;
CREATE TABLE `woobooking_service_coupon` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `woobooking_service_employee`
--

DROP TABLE IF EXISTS `woobooking_service_employee`;
CREATE TABLE `woobooking_service_employee` (
  `id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `enable_customize` int(11) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `price` float NOT NULL,
  `minimum_capacity` int(11) NOT NULL,
  `maximum_capacity` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_service_employee`
--

INSERT INTO `woobooking_service_employee` (`id`, `employee_id`, `service_id`, `enable_customize`, `start_time`, `end_time`, `price`, `minimum_capacity`, `maximum_capacity`, `description`) VALUES
(6, 2, 8, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(8, 4, 8, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(9, 2, 26, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(11, 4, 26, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(13, 2, 30, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(341, 33, 96, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(436, 10, 97, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(437, 33, 97, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(507, 7, 98, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(643, 15, 103, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(644, 30, 103, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(645, 33, 103, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(790, 3, 102, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(791, 5, 102, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(792, 7, 102, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(793, 33, 102, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(806, 10, 51, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(807, 15, 51, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(808, 33, 51, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(809, 7, 52, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(810, 8, 57, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(811, 33, 57, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(812, 1, 58, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(813, 8, 58, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(814, 10, 58, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(815, 8, 59, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(816, 10, 59, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(817, 1, 60, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(818, 5, 60, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(819, 7, 60, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(820, 7, 99, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(821, 15, 99, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(822, 1, 100, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(823, 5, 100, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(841, 1, 61, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(842, 8, 61, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(843, 7, 62, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(844, 8, 62, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(845, 30, 62, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(846, 1, 63, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(847, 7, 63, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(848, 1, 65, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(849, 15, 65, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(850, 7, 66, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(851, 8, 66, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(852, 10, 86, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(853, 5, 87, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(854, 8, 87, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(855, 10, 87, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(856, 10, 95, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(857, 15, 95, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(858, 33, 95, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(859, 7, 67, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(860, 15, 68, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(861, 33, 68, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(862, 5, 69, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(863, 15, 69, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(864, 15, 70, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(865, 30, 70, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(866, 7, 71, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(867, 8, 71, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(868, 1, 72, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(869, 5, 72, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(870, 10, 72, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(871, 1, 45, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(872, 5, 45, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(873, 8, 45, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(874, 33, 45, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(875, 7, 46, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(876, 10, 46, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(877, 15, 46, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(878, 10, 47, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(879, 30, 47, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(880, 1, 48, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(881, 5, 48, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(882, 8, 48, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(883, 1, 49, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(884, 8, 49, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(885, 5, 50, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(886, 7, 50, 0, '00:00:00', '00:00:00', 0, 0, 0, ''),
(887, 10, 50, 0, '00:00:00', '00:00:00', 0, 0, 0, '');

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

--
-- Table structure for table `woobooking_service_review`
--

DROP TABLE IF EXISTS `woobooking_service_review`;
CREATE TABLE `woobooking_service_review` (
  `id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `review_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_service_review`
--

INSERT INTO `woobooking_service_review` (`id`, `service_id`, `review_id`, `description`) VALUES
(1, 45, 1, ''),
(2, 46, 2, ''),
(3, 47, 3, ''),
(4, 48, 4, ''),
(5, 49, 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;

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

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

DROP TABLE IF EXISTS `woobooking_sms`;
CREATE TABLE `woobooking_sms` (
  `id` int(11) UNSIGNED NOT NULL,
  `account_id` varchar(200) NOT NULL,
  `auth_token` varchar(200) NOT NULL,
  `phonecode` int(5) NOT NULL,
  `countrycode` varchar(200) NOT NULL,
  `phone_register` 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_sms`
--

INSERT INTO `woobooking_sms` (`id`, `account_id`, `auth_token`, `phonecode`, `countrycode`, `phone_register`, `ordering`, `published`, `description`) VALUES
(1, 'AC1aa868a391e0ca3e122a15b823e7e3ba', 'b9b89b59ece98cd94d4849e3df825672', 1, 'USA', '2029534076', 0, 1, 'Twilio account');

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

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

DROP TABLE IF EXISTS `woobooking_smscontent`;
CREATE TABLE `woobooking_smscontent` (
  `id` int(11) UNSIGNED 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;

--
-- Dumping data for table `woobooking_smscontent`
--

INSERT INTO `woobooking_smscontent` (`id`, `sms_suplier_id`, `title_sms`, `action_sms`, `ordering`, `content_sms`) VALUES
(1, 1, 'Test', 'first_send', 0, 'Hello {customer_first_name} {customer_last_name}!!!!'),
(2, 1, 'Second send', 'second_send', 0, 'Hello {customer_first_name} {customer_last_name} !!!!!!!\r\nYour Payment: {orderdetail_total}'),
(3, 1, 'Request payment', 'request_payment', 0, 'Hello {customer_first_name} {customer_last_name} !!!\r\nPlease payment service today follow link: {link_request_payment}'),
(4, 1, 'Notify Employee', 'employee_notify', 0, 'Hi!!\r\nHave new order for you!\r\nService: {service_name}\r\nTime: {orderdetailrate_start_date}\r\n');

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

--
-- 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,
  `user_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`, `user_id`, `statecode`, `code`, `published`, `ordering`, `image`) VALUES
(5, 'Wien', 16, 0, '0', '', 1, 0, 'frontend/app/assets/images/no-image.jpg'),
(6, 'New York', 235, 0, '', '', 1, 0, 'frontend/app/assets/images/no-image.jpg'),
(7, 'Rome', 112, 0, '', '', 1, 0, ''),
(8, 'Venezia', 112, 0, '', '', 1, 0, ''),
(9, 'Paris', 76, 0, '', '', 1, 0, ''),
(10, 'Ha Noi', 242, 0, '', '', 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(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_tag`
--

INSERT INTO `woobooking_tag` (`id`, `name`, `alias`, `description`, `ordering`) VALUES
(1, 'title1', 'title1', 'des title1', 0),
(2, 'sfdsf', '', '', 0),
(3, 'sdfs', '', '', 0),
(4, 'sdfsdf', '', '', 0),
(5, 'ssdfsd', '', '', 0),
(6, 'đfg', '', '', 0),
(7, 'ssdfd', '', '', 0),
(8, 'sdfds', '', '', 0),
(9, 'sdds', '', '', 0),
(14, '', '', '', 0),
(15, 'Yoga Workshop', '', '', 0),
(16, 'Free', '', '', 0),
(17, 'Outdoor', '', '', 0),
(18, 'aerobic', '', '', 0),
(19, 'combat', '', '', 0),
(20, 'heavybody', '', '', 0);

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

--
-- Table structure for table `woobooking_timezone`
--

DROP TABLE IF EXISTS `woobooking_timezone`;
CREATE TABLE `woobooking_timezone` (
  `country_code` char(3) NOT NULL,
  `timezone` varchar(125) NOT NULL DEFAULT '',
  `gmt_offset` float(10,2) DEFAULT NULL,
  `dst_offset` float(10,2) DEFAULT NULL,
  `raw_offset` float(10,2) DEFAULT NULL,
  `ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_timezone`
--

INSERT INTO `woobooking_timezone` (`country_code`, `timezone`, `gmt_offset`, `dst_offset`, `raw_offset`, `ordering`) VALUES
('AD', 'Europe/Andorra', 1.00, 2.00, 1.00, 0),
('AE', 'Asia/Dubai', 4.00, 4.00, 4.00, 0),
('AF', 'Asia/Kabul', 4.50, 4.50, 4.50, 0),
('AG', 'America/Antigua', -4.00, -4.00, -4.00, 0),
('AI', 'America/Anguilla', -4.00, -4.00, -4.00, 0),
('AL', 'Europe/Tirane', 1.00, 2.00, 1.00, 0),
('AM', 'Asia/Yerevan', 4.00, 4.00, 4.00, 0),
('AO', 'Africa/Luanda', 1.00, 1.00, 1.00, 0),
('AQ', 'Antarctica/Casey', 8.00, 8.00, 8.00, 0),
('AQ', 'Antarctica/Davis', 7.00, 7.00, 7.00, 0),
('AQ', 'Antarctica/DumontDUrville', 10.00, 10.00, 10.00, 0),
('AQ', 'Antarctica/Mawson', 5.00, 5.00, 5.00, 0),
('AQ', 'Antarctica/McMurdo', 13.00, 12.00, 12.00, 0),
('AQ', 'Antarctica/Palmer', -3.00, -4.00, -4.00, 0),
('AQ', 'Antarctica/Rothera', -3.00, -3.00, -3.00, 0),
('AQ', 'Antarctica/South_Pole', 13.00, 12.00, 12.00, 0),
('AQ', 'Antarctica/Syowa', 3.00, 3.00, 3.00, 0),
('AQ', 'Antarctica/Vostok', 6.00, 6.00, 6.00, 0),
('AR', 'America/Argentina/Buenos_Aires', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Catamarca', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Cordoba', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Jujuy', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/La_Rioja', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Mendoza', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Rio_Gallegos', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Salta', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/San_Juan', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/San_Luis', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Tucuman', -3.00, -3.00, -3.00, 0),
('AR', 'America/Argentina/Ushuaia', -3.00, -3.00, -3.00, 0),
('AS', 'Pacific/Pago_Pago', -11.00, -11.00, -11.00, 0),
('AT', 'Europe/Vienna', 1.00, 2.00, 1.00, 0),
('AU', 'Antarctica/Macquarie', 11.00, 11.00, 11.00, 0),
('AU', 'Australia/Adelaide', 10.50, 9.50, 9.50, 0),
('AU', 'Australia/Brisbane', 10.00, 10.00, 10.00, 0),
('AU', 'Australia/Broken_Hill', 10.50, 9.50, 9.50, 0),
('AU', 'Australia/Currie', 11.00, 10.00, 10.00, 0),
('AU', 'Australia/Darwin', 9.50, 9.50, 9.50, 0),
('AU', 'Australia/Eucla', 8.75, 8.75, 8.75, 0),
('AU', 'Australia/Hobart', 11.00, 10.00, 10.00, 0),
('AU', 'Australia/Lindeman', 10.00, 10.00, 10.00, 0),
('AU', 'Australia/Lord_Howe', 11.00, 10.50, 10.50, 0),
('AU', 'Australia/Melbourne', 11.00, 10.00, 10.00, 0),
('AU', 'Australia/Perth', 8.00, 8.00, 8.00, 0),
('AU', 'Australia/Sydney', 11.00, 10.00, 10.00, 0),
('AW', 'America/Aruba', -4.00, -4.00, -4.00, 0),
('AX', 'Europe/Mariehamn', 2.00, 3.00, 2.00, 0),
('AZ', 'Asia/Baku', 4.00, 5.00, 4.00, 0),
('BA', 'Europe/Sarajevo', 1.00, 2.00, 1.00, 0),
('BB', 'America/Barbados', -4.00, -4.00, -4.00, 0),
('BD', 'Asia/Dhaka', 6.00, 6.00, 6.00, 0),
('BE', 'Europe/Brussels', 1.00, 2.00, 1.00, 0),
('BF', 'Africa/Ouagadougou', 0.00, 0.00, 0.00, 0),
('BG', 'Europe/Sofia', 2.00, 3.00, 2.00, 0),
('BH', 'Asia/Bahrain', 3.00, 3.00, 3.00, 0),
('BI', 'Africa/Bujumbura', 2.00, 2.00, 2.00, 0),
('BJ', 'Africa/Porto-Novo', 1.00, 1.00, 1.00, 0),
('BL', 'America/St_Barthelemy', -4.00, -4.00, -4.00, 0),
('BM', 'Atlantic/Bermuda', -4.00, -3.00, -4.00, 0),
('BN', 'Asia/Brunei', 8.00, 8.00, 8.00, 0),
('BO', 'America/La_Paz', -4.00, -4.00, -4.00, 0),
('BQ', 'America/Kralendijk', -4.00, -4.00, -4.00, 0),
('BR', 'America/Araguaina', -3.00, -3.00, -3.00, 0),
('BR', 'America/Bahia', -3.00, -3.00, -3.00, 0),
('BR', 'America/Belem', -3.00, -3.00, -3.00, 0),
('BR', 'America/Boa_Vista', -4.00, -4.00, -4.00, 0),
('BR', 'America/Campo_Grande', -3.00, -4.00, -4.00, 0),
('BR', 'America/Cuiaba', -3.00, -4.00, -4.00, 0),
('BR', 'America/Eirunepe', -5.00, -5.00, -5.00, 0),
('BR', 'America/Fortaleza', -3.00, -3.00, -3.00, 0),
('BR', 'America/Maceio', -3.00, -3.00, -3.00, 0),
('BR', 'America/Manaus', -4.00, -4.00, -4.00, 0),
('BR', 'America/Noronha', -2.00, -2.00, -2.00, 0),
('BR', 'America/Porto_Velho', -4.00, -4.00, -4.00, 0),
('BR', 'America/Recife', -3.00, -3.00, -3.00, 0),
('BR', 'America/Rio_Branco', -5.00, -5.00, -5.00, 0),
('BR', 'America/Santarem', -3.00, -3.00, -3.00, 0),
('BR', 'America/Sao_Paulo', -2.00, -3.00, -3.00, 0),
('BS', 'America/Nassau', -5.00, -4.00, -5.00, 0),
('BT', 'Asia/Thimphu', 6.00, 6.00, 6.00, 0),
('BW', 'Africa/Gaborone', 2.00, 2.00, 2.00, 0),
('BY', 'Europe/Minsk', 3.00, 3.00, 3.00, 0),
('BZ', 'America/Belize', -6.00, -6.00, -6.00, 0),
('CA', 'America/Atikokan', -5.00, -5.00, -5.00, 0),
('CA', 'America/Blanc-Sablon', -4.00, -4.00, -4.00, 0),
('CA', 'America/Cambridge_Bay', -7.00, -6.00, -7.00, 0),
('CA', 'America/Creston', -7.00, -7.00, -7.00, 0),
('CA', 'America/Dawson', -8.00, -7.00, -8.00, 0),
('CA', 'America/Dawson_Creek', -7.00, -7.00, -7.00, 0),
('CA', 'America/Edmonton', -7.00, -6.00, -7.00, 0),
('CA', 'America/Glace_Bay', -4.00, -3.00, -4.00, 0),
('CA', 'America/Goose_Bay', -4.00, -3.00, -4.00, 0),
('CA', 'America/Halifax', -4.00, -3.00, -4.00, 0),
('CA', 'America/Inuvik', -7.00, -6.00, -7.00, 0),
('CA', 'America/Iqaluit', -5.00, -4.00, -5.00, 0),
('CA', 'America/Moncton', -4.00, -3.00, -4.00, 0),
('CA', 'America/Montreal', -5.00, -4.00, -5.00, 0),
('CA', 'America/Nipigon', -5.00, -4.00, -5.00, 0),
('CA', 'America/Pangnirtung', -5.00, -4.00, -5.00, 0),
('CA', 'America/Rainy_River', -6.00, -5.00, -6.00, 0),
('CA', 'America/Rankin_Inlet', -6.00, -5.00, -6.00, 0),
('CA', 'America/Regina', -6.00, -6.00, -6.00, 0),
('CA', 'America/Resolute', -6.00, -5.00, -6.00, 0),
('CA', 'America/St_Johns', -3.50, -2.50, -3.50, 0),
('CA', 'America/Swift_Current', -6.00, -6.00, -6.00, 0),
('CA', 'America/Thunder_Bay', -5.00, -4.00, -5.00, 0),
('CA', 'America/Toronto', -5.00, -4.00, -5.00, 0),
('CA', 'America/Vancouver', -8.00, -7.00, -8.00, 0),
('CA', 'America/Whitehorse', -8.00, -7.00, -8.00, 0),
('CA', 'America/Winnipeg', -6.00, -5.00, -6.00, 0),
('CA', 'America/Yellowknife', -7.00, -6.00, -7.00, 0),
('CC', 'Indian/Cocos', 6.50, 6.50, 6.50, 0),
('CD', 'Africa/Kinshasa', 1.00, 1.00, 1.00, 0),
('CD', 'Africa/Lubumbashi', 2.00, 2.00, 2.00, 0),
('CF', 'Africa/Bangui', 1.00, 1.00, 1.00, 0),
('CG', 'Africa/Brazzaville', 1.00, 1.00, 1.00, 0),
('CH', 'Europe/Zurich', 1.00, 2.00, 1.00, 0),
('CI', 'Africa/Abidjan', 0.00, 0.00, 0.00, 0),
('CK', 'Pacific/Rarotonga', -10.00, -10.00, -10.00, 0),
('CL', 'America/Santiago', -3.00, -4.00, -4.00, 0),
('CL', 'Pacific/Easter', -5.00, -6.00, -6.00, 0),
('CM', 'Africa/Douala', 1.00, 1.00, 1.00, 0),
('CN', 'Asia/Chongqing', 8.00, 8.00, 8.00, 0),
('CN', 'Asia/Harbin', 8.00, 8.00, 8.00, 0),
('CN', 'Asia/Kashgar', 8.00, 8.00, 8.00, 0),
('CN', 'Asia/Shanghai', 8.00, 8.00, 8.00, 0),
('CN', 'Asia/Urumqi', 8.00, 8.00, 8.00, 0),
('CO', 'America/Bogota', -5.00, -5.00, -5.00, 0),
('CR', 'America/Costa_Rica', -6.00, -6.00, -6.00, 0),
('CU', 'America/Havana', -5.00, -4.00, -5.00, 0),
('CV', 'Atlantic/Cape_Verde', -1.00, -1.00, -1.00, 0),
('CW', 'America/Curacao', -4.00, -4.00, -4.00, 0),
('CX', 'Indian/Christmas', 7.00, 7.00, 7.00, 0),
('CY', 'Asia/Nicosia', 2.00, 3.00, 2.00, 0),
('CZ', 'Europe/Prague', 1.00, 2.00, 1.00, 0),
('DE', 'Europe/Berlin', 1.00, 2.00, 1.00, 0),
('DE', 'Europe/Busingen', 1.00, 2.00, 1.00, 0),
('DJ', 'Africa/Djibouti', 3.00, 3.00, 3.00, 0),
('DK', 'Europe/Copenhagen', 1.00, 2.00, 1.00, 0),
('DM', 'America/Dominica', -4.00, -4.00, -4.00, 0),
('DO', 'America/Santo_Domingo', -4.00, -4.00, -4.00, 0),
('DZ', 'Africa/Algiers', 1.00, 1.00, 1.00, 0),
('EC', 'America/Guayaquil', -5.00, -5.00, -5.00, 0),
('EC', 'Pacific/Galapagos', -6.00, -6.00, -6.00, 0),
('EE', 'Europe/Tallinn', 2.00, 3.00, 2.00, 0),
('EG', 'Africa/Cairo', 2.00, 2.00, 2.00, 0),
('EH', 'Africa/El_Aaiun', 0.00, 0.00, 0.00, 0),
('ER', 'Africa/Asmara', 3.00, 3.00, 3.00, 0),
('ES', 'Africa/Ceuta', 1.00, 2.00, 1.00, 0),
('ES', 'Atlantic/Canary', 0.00, 1.00, 0.00, 0),
('ES', 'Europe/Madrid', 1.00, 2.00, 1.00, 0),
('ET', 'Africa/Addis_Ababa', 3.00, 3.00, 3.00, 0),
('FI', 'Europe/Helsinki', 2.00, 3.00, 2.00, 0),
('FJ', 'Pacific/Fiji', 13.00, 12.00, 12.00, 0),
('FK', 'Atlantic/Stanley', -3.00, -3.00, -3.00, 0),
('FM', 'Pacific/Chuuk', 10.00, 10.00, 10.00, 0),
('FM', 'Pacific/Kosrae', 11.00, 11.00, 11.00, 0),
('FM', 'Pacific/Pohnpei', 11.00, 11.00, 11.00, 0),
('FO', 'Atlantic/Faroe', 0.00, 1.00, 0.00, 0),
('FR', 'Europe/Paris', 1.00, 2.00, 1.00, 0),
('GA', 'Africa/Libreville', 1.00, 1.00, 1.00, 0),
('GB', 'Europe/London', 0.00, 1.00, 0.00, 0),
('GD', 'America/Grenada', -4.00, -4.00, -4.00, 0),
('GE', 'Asia/Tbilisi', 4.00, 4.00, 4.00, 0),
('GF', 'America/Cayenne', -3.00, -3.00, -3.00, 0),
('GG', 'Europe/Guernsey', 0.00, 1.00, 0.00, 0),
('GH', 'Africa/Accra', 0.00, 0.00, 0.00, 0),
('GI', 'Europe/Gibraltar', 1.00, 2.00, 1.00, 0),
('GL', 'America/Danmarkshavn', 0.00, 0.00, 0.00, 0),
('GL', 'America/Godthab', -3.00, -2.00, -3.00, 0),
('GL', 'America/Scoresbysund', -1.00, 0.00, -1.00, 0),
('GL', 'America/Thule', -4.00, -3.00, -4.00, 0),
('GM', 'Africa/Banjul', 0.00, 0.00, 0.00, 0),
('GN', 'Africa/Conakry', 0.00, 0.00, 0.00, 0),
('GP', 'America/Guadeloupe', -4.00, -4.00, -4.00, 0),
('GQ', 'Africa/Malabo', 1.00, 1.00, 1.00, 0),
('GR', 'Europe/Athens', 2.00, 3.00, 2.00, 0),
('GS', 'Atlantic/South_Georgia', -2.00, -2.00, -2.00, 0),
('GT', 'America/Guatemala', -6.00, -6.00, -6.00, 0),
('GU', 'Pacific/Guam', 10.00, 10.00, 10.00, 0),
('GW', 'Africa/Bissau', 0.00, 0.00, 0.00, 0),
('GY', 'America/Guyana', -4.00, -4.00, -4.00, 0),
('HK', 'Asia/Hong_Kong', 8.00, 8.00, 8.00, 0),
('HN', 'America/Tegucigalpa', -6.00, -6.00, -6.00, 0),
('HR', 'Europe/Zagreb', 1.00, 2.00, 1.00, 0),
('HT', 'America/Port-au-Prince', -5.00, -4.00, -5.00, 0),
('HU', 'Europe/Budapest', 1.00, 2.00, 1.00, 0),
('ID', 'Asia/Jakarta', 7.00, 7.00, 7.00, 0),
('ID', 'Asia/Jayapura', 9.00, 9.00, 9.00, 0),
('ID', 'Asia/Makassar', 8.00, 8.00, 8.00, 0),
('ID', 'Asia/Pontianak', 7.00, 7.00, 7.00, 0),
('IE', 'Europe/Dublin', 0.00, 1.00, 0.00, 0),
('IL', 'Asia/Jerusalem', 2.00, 3.00, 2.00, 0),
('IM', 'Europe/Isle_of_Man', 0.00, 1.00, 0.00, 0),
('IN', 'Asia/Kolkata', 5.50, 5.50, 5.50, 0),
('IO', 'Indian/Chagos', 6.00, 6.00, 6.00, 0),
('IQ', 'Asia/Baghdad', 3.00, 3.00, 3.00, 0),
('IR', 'Asia/Tehran', 3.50, 4.50, 3.50, 0),
('IS', 'Atlantic/Reykjavik', 0.00, 0.00, 0.00, 0),
('IT', 'Europe/Rome', 1.00, 2.00, 1.00, 0),
('JE', 'Europe/Jersey', 0.00, 1.00, 0.00, 0),
('JM', 'America/Jamaica', -5.00, -5.00, -5.00, 0),
('JO', 'Asia/Amman', 2.00, 3.00, 2.00, 0),
('JP', 'Asia/Tokyo', 9.00, 9.00, 9.00, 0),
('KE', 'Africa/Nairobi', 3.00, 3.00, 3.00, 0),
('KG', 'Asia/Bishkek', 6.00, 6.00, 6.00, 0),
('KH', 'Asia/Phnom_Penh', 7.00, 7.00, 7.00, 0),
('KI', 'Pacific/Enderbury', 13.00, 13.00, 13.00, 0),
('KI', 'Pacific/Kiritimati', 14.00, 14.00, 14.00, 0),
('KI', 'Pacific/Tarawa', 12.00, 12.00, 12.00, 0),
('KM', 'Indian/Comoro', 3.00, 3.00, 3.00, 0),
('KN', 'America/St_Kitts', -4.00, -4.00, -4.00, 0),
('KP', 'Asia/Pyongyang', 9.00, 9.00, 9.00, 0),
('KR', 'Asia/Seoul', 9.00, 9.00, 9.00, 0),
('KW', 'Asia/Kuwait', 3.00, 3.00, 3.00, 0),
('KY', 'America/Cayman', -5.00, -5.00, -5.00, 0),
('KZ', 'Asia/Almaty', 6.00, 6.00, 6.00, 0),
('KZ', 'Asia/Aqtau', 5.00, 5.00, 5.00, 0),
('KZ', 'Asia/Aqtobe', 5.00, 5.00, 5.00, 0),
('KZ', 'Asia/Oral', 5.00, 5.00, 5.00, 0),
('KZ', 'Asia/Qyzylorda', 6.00, 6.00, 6.00, 0),
('LA', 'Asia/Vientiane', 7.00, 7.00, 7.00, 0),
('LB', 'Asia/Beirut', 2.00, 3.00, 2.00, 0),
('LC', 'America/St_Lucia', -4.00, -4.00, -4.00, 0),
('LI', 'Europe/Vaduz', 1.00, 2.00, 1.00, 0),
('LK', 'Asia/Colombo', 5.50, 5.50, 5.50, 0),
('LR', 'Africa/Monrovia', 0.00, 0.00, 0.00, 0),
('LS', 'Africa/Maseru', 2.00, 2.00, 2.00, 0),
('LT', 'Europe/Vilnius', 2.00, 3.00, 2.00, 0),
('LU', 'Europe/Luxembourg', 1.00, 2.00, 1.00, 0),
('LV', 'Europe/Riga', 2.00, 3.00, 2.00, 0),
('LY', 'Africa/Tripoli', 2.00, 2.00, 2.00, 0),
('MA', 'Africa/Casablanca', 0.00, 0.00, 0.00, 0),
('MC', 'Europe/Monaco', 1.00, 2.00, 1.00, 0),
('MD', 'Europe/Chisinau', 2.00, 3.00, 2.00, 0),
('ME', 'Europe/Podgorica', 1.00, 2.00, 1.00, 0),
('MF', 'America/Marigot', -4.00, -4.00, -4.00, 0),
('MG', 'Indian/Antananarivo', 3.00, 3.00, 3.00, 0),
('MH', 'Pacific/Kwajalein', 12.00, 12.00, 12.00, 0),
('MH', 'Pacific/Majuro', 12.00, 12.00, 12.00, 0),
('MK', 'Europe/Skopje', 1.00, 2.00, 1.00, 0),
('ML', 'Africa/Bamako', 0.00, 0.00, 0.00, 0),
('MM', 'Asia/Rangoon', 6.50, 6.50, 6.50, 0),
('MN', 'Asia/Choibalsan', 8.00, 8.00, 8.00, 0),
('MN', 'Asia/Hovd', 7.00, 7.00, 7.00, 0),
('MN', 'Asia/Ulaanbaatar', 8.00, 8.00, 8.00, 0),
('MO', 'Asia/Macau', 8.00, 8.00, 8.00, 0),
('MP', 'Pacific/Saipan', 10.00, 10.00, 10.00, 0),
('MQ', 'America/Martinique', -4.00, -4.00, -4.00, 0),
('MR', 'Africa/Nouakchott', 0.00, 0.00, 0.00, 0),
('MS', 'America/Montserrat', -4.00, -4.00, -4.00, 0),
('MT', 'Europe/Malta', 1.00, 2.00, 1.00, 0),
('MU', 'Indian/Mauritius', 4.00, 4.00, 4.00, 0),
('MV', 'Indian/Maldives', 5.00, 5.00, 5.00, 0),
('MW', 'Africa/Blantyre', 2.00, 2.00, 2.00, 0),
('MX', 'America/Bahia_Banderas', -6.00, -5.00, -6.00, 0),
('MX', 'America/Cancun', -6.00, -5.00, -6.00, 0),
('MX', 'America/Chihuahua', -7.00, -6.00, -7.00, 0),
('MX', 'America/Hermosillo', -7.00, -7.00, -7.00, 0),
('MX', 'America/Matamoros', -6.00, -5.00, -6.00, 0),
('MX', 'America/Mazatlan', -7.00, -6.00, -7.00, 0),
('MX', 'America/Merida', -6.00, -5.00, -6.00, 0),
('MX', 'America/Mexico_City', -6.00, -5.00, -6.00, 0),
('MX', 'America/Monterrey', -6.00, -5.00, -6.00, 0),
('MX', 'America/Ojinaga', -7.00, -6.00, -7.00, 0),
('MX', 'America/Santa_Isabel', -8.00, -7.00, -8.00, 0),
('MX', 'America/Tijuana', -8.00, -7.00, -8.00, 0),
('MY', 'Asia/Kuala_Lumpur', 8.00, 8.00, 8.00, 0),
('MY', 'Asia/Kuching', 8.00, 8.00, 8.00, 0),
('MZ', 'Africa/Maputo', 2.00, 2.00, 2.00, 0),
('NA', 'Africa/Windhoek', 2.00, 1.00, 1.00, 0),
('NC', 'Pacific/Noumea', 11.00, 11.00, 11.00, 0),
('NE', 'Africa/Niamey', 1.00, 1.00, 1.00, 0),
('NF', 'Pacific/Norfolk', 11.50, 11.50, 11.50, 0),
('NG', 'Africa/Lagos', 1.00, 1.00, 1.00, 0),
('NI', 'America/Managua', -6.00, -6.00, -6.00, 0),
('NL', 'Europe/Amsterdam', 1.00, 2.00, 1.00, 0),
('NO', 'Europe/Oslo', 1.00, 2.00, 1.00, 0),
('NP', 'Asia/Kathmandu', 5.75, 5.75, 5.75, 0),
('NR', 'Pacific/Nauru', 12.00, 12.00, 12.00, 0),
('NU', 'Pacific/Niue', -11.00, -11.00, -11.00, 0),
('NZ', 'Pacific/Auckland', 13.00, 12.00, 12.00, 0),
('NZ', 'Pacific/Chatham', 13.75, 12.75, 12.75, 0),
('OM', 'Asia/Muscat', 4.00, 4.00, 4.00, 0),
('PA', 'America/Panama', -5.00, -5.00, -5.00, 0),
('PE', 'America/Lima', -5.00, -5.00, -5.00, 0),
('PF', 'Pacific/Gambier', -9.00, -9.00, -9.00, 0),
('PF', 'Pacific/Marquesas', -9.50, -9.50, -9.50, 0),
('PF', 'Pacific/Tahiti', -10.00, -10.00, -10.00, 0),
('PG', 'Pacific/Port_Moresby', 10.00, 10.00, 10.00, 0),
('PH', 'Asia/Manila', 8.00, 8.00, 8.00, 0),
('PK', 'Asia/Karachi', 5.00, 5.00, 5.00, 0),
('PL', 'Europe/Warsaw', 1.00, 2.00, 1.00, 0),
('PM', 'America/Miquelon', -3.00, -2.00, -3.00, 0),
('PN', 'Pacific/Pitcairn', -8.00, -8.00, -8.00, 0),
('PR', 'America/Puerto_Rico', -4.00, -4.00, -4.00, 0),
('PS', 'Asia/Gaza', 2.00, 3.00, 2.00, 0),
('PS', 'Asia/Hebron', 2.00, 3.00, 2.00, 0),
('PT', 'Atlantic/Azores', -1.00, 0.00, -1.00, 0),
('PT', 'Atlantic/Madeira', 0.00, 1.00, 0.00, 0),
('PT', 'Europe/Lisbon', 0.00, 1.00, 0.00, 0),
('PW', 'Pacific/Palau', 9.00, 9.00, 9.00, 0),
('PY', 'America/Asuncion', -3.00, -4.00, -4.00, 0),
('QA', 'Asia/Qatar', 3.00, 3.00, 3.00, 0),
('RE', 'Indian/Reunion', 4.00, 4.00, 4.00, 0),
('RO', 'Europe/Bucharest', 2.00, 3.00, 2.00, 0),
('RS', 'Europe/Belgrade', 1.00, 2.00, 1.00, 0),
('RU', 'Asia/Anadyr', 12.00, 12.00, 12.00, 0),
('RU', 'Asia/Irkutsk', 9.00, 9.00, 9.00, 0),
('RU', 'Asia/Kamchatka', 12.00, 12.00, 12.00, 0),
('RU', 'Asia/Khandyga', 10.00, 10.00, 10.00, 0),
('RU', 'Asia/Krasnoyarsk', 8.00, 8.00, 8.00, 0),
('RU', 'Asia/Magadan', 12.00, 12.00, 12.00, 0),
('RU', 'Asia/Novokuznetsk', 7.00, 7.00, 7.00, 0),
('RU', 'Asia/Novosibirsk', 7.00, 7.00, 7.00, 0),
('RU', 'Asia/Omsk', 7.00, 7.00, 7.00, 0),
('RU', 'Asia/Sakhalin', 11.00, 11.00, 11.00, 0),
('RU', 'Asia/Ust-Nera', 11.00, 11.00, 11.00, 0),
('RU', 'Asia/Vladivostok', 11.00, 11.00, 11.00, 0),
('RU', 'Asia/Yakutsk', 10.00, 10.00, 10.00, 0),
('RU', 'Asia/Yekaterinburg', 6.00, 6.00, 6.00, 0),
('RU', 'Europe/Kaliningrad', 3.00, 3.00, 3.00, 0),
('RU', 'Europe/Moscow', 4.00, 4.00, 4.00, 0),
('RU', 'Europe/Samara', 4.00, 4.00, 4.00, 0),
('RU', 'Europe/Volgograd', 4.00, 4.00, 4.00, 0),
('RW', 'Africa/Kigali', 2.00, 2.00, 2.00, 0),
('SA', 'Asia/Riyadh', 3.00, 3.00, 3.00, 0),
('SB', 'Pacific/Guadalcanal', 11.00, 11.00, 11.00, 0),
('SC', 'Indian/Mahe', 4.00, 4.00, 4.00, 0),
('SD', 'Africa/Khartoum', 3.00, 3.00, 3.00, 0),
('SE', 'Europe/Stockholm', 1.00, 2.00, 1.00, 0),
('SG', 'Asia/Singapore', 8.00, 8.00, 8.00, 0),
('SH', 'Atlantic/St_Helena', 0.00, 0.00, 0.00, 0),
('SI', 'Europe/Ljubljana', 1.00, 2.00, 1.00, 0),
('SJ', 'Arctic/Longyearbyen', 1.00, 2.00, 1.00, 0),
('SK', 'Europe/Bratislava', 1.00, 2.00, 1.00, 0),
('SL', 'Africa/Freetown', 0.00, 0.00, 0.00, 0),
('SM', 'Europe/San_Marino', 1.00, 2.00, 1.00, 0),
('SN', 'Africa/Dakar', 0.00, 0.00, 0.00, 0),
('SO', 'Africa/Mogadishu', 3.00, 3.00, 3.00, 0),
('SR', 'America/Paramaribo', -3.00, -3.00, -3.00, 0),
('SS', 'Africa/Juba', 3.00, 3.00, 3.00, 0),
('ST', 'Africa/Sao_Tome', 0.00, 0.00, 0.00, 0),
('SV', 'America/El_Salvador', -6.00, -6.00, -6.00, 0),
('SX', 'America/Lower_Princes', -4.00, -4.00, -4.00, 0),
('SY', 'Asia/Damascus', 2.00, 3.00, 2.00, 0),
('SZ', 'Africa/Mbabane', 2.00, 2.00, 2.00, 0),
('TC', 'America/Grand_Turk', -5.00, -4.00, -5.00, 0),
('TD', 'Africa/Ndjamena', 1.00, 1.00, 1.00, 0),
('TF', 'Indian/Kerguelen', 5.00, 5.00, 5.00, 0),
('TG', 'Africa/Lome', 0.00, 0.00, 0.00, 0),
('TH', 'Asia/Bangkok', 7.00, 7.00, 7.00, 0),
('TJ', 'Asia/Dushanbe', 5.00, 5.00, 5.00, 0),
('TK', 'Pacific/Fakaofo', 13.00, 13.00, 13.00, 0),
('TL', 'Asia/Dili', 9.00, 9.00, 9.00, 0),
('TM', 'Asia/Ashgabat', 5.00, 5.00, 5.00, 0),
('TN', 'Africa/Tunis', 1.00, 1.00, 1.00, 0),
('TO', 'Pacific/Tongatapu', 13.00, 13.00, 13.00, 0),
('TR', 'Europe/Istanbul', 2.00, 3.00, 2.00, 0),
('TT', 'America/Port_of_Spain', -4.00, -4.00, -4.00, 0),
('TV', 'Pacific/Funafuti', 12.00, 12.00, 12.00, 0),
('TW', 'Asia/Taipei', 8.00, 8.00, 8.00, 0),
('TZ', 'Africa/Dar_es_Salaam', 3.00, 3.00, 3.00, 0),
('UA', 'Europe/Kiev', 2.00, 3.00, 2.00, 0),
('UA', 'Europe/Simferopol', 2.00, 4.00, 4.00, 0),
('UA', 'Europe/Uzhgorod', 2.00, 3.00, 2.00, 0),
('UA', 'Europe/Zaporozhye', 2.00, 3.00, 2.00, 0),
('UG', 'Africa/Kampala', 3.00, 3.00, 3.00, 0),
('UM', 'Pacific/Johnston', -10.00, -10.00, -10.00, 0),
('UM', 'Pacific/Midway', -11.00, -11.00, -11.00, 0),
('UM', 'Pacific/Wake', 12.00, 12.00, 12.00, 0),
('US', 'America/Adak', -10.00, -9.00, -10.00, 0),
('US', 'America/Anchorage', -9.00, -8.00, -9.00, 0),
('US', 'America/Boise', -7.00, -6.00, -7.00, 0),
('US', 'America/Chicago', -6.00, -5.00, -6.00, 0),
('US', 'America/Denver', -7.00, -6.00, -7.00, 0),
('US', 'America/Detroit', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Indianapolis', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Knox', -6.00, -5.00, -6.00, 0),
('US', 'America/Indiana/Marengo', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Petersburg', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Tell_City', -6.00, -5.00, -6.00, 0),
('US', 'America/Indiana/Vevay', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Vincennes', -5.00, -4.00, -5.00, 0),
('US', 'America/Indiana/Winamac', -5.00, -4.00, -5.00, 0),
('US', 'America/Juneau', -9.00, -8.00, -9.00, 0),
('US', 'America/Kentucky/Louisville', -5.00, -4.00, -5.00, 0),
('US', 'America/Kentucky/Monticello', -5.00, -4.00, -5.00, 0),
('US', 'America/Los_Angeles', -8.00, -7.00, -8.00, 0),
('US', 'America/Menominee', -6.00, -5.00, -6.00, 0),
('US', 'America/Metlakatla', -8.00, -8.00, -8.00, 0),
('US', 'America/New_York', -5.00, -4.00, -5.00, 0),
('US', 'America/Nome', -9.00, -8.00, -9.00, 0),
('US', 'America/North_Dakota/Beulah', -6.00, -5.00, -6.00, 0),
('US', 'America/North_Dakota/Center', -6.00, -5.00, -6.00, 0),
('US', 'America/North_Dakota/New_Salem', -6.00, -5.00, -6.00, 0),
('US', 'America/Phoenix', -7.00, -7.00, -7.00, 0),
('US', 'America/Shiprock', -7.00, -6.00, -7.00, 0),
('US', 'America/Sitka', -9.00, -8.00, -9.00, 0),
('US', 'America/Yakutat', -9.00, -8.00, -9.00, 0),
('US', 'Pacific/Honolulu', -10.00, -10.00, -10.00, 0),
('UY', 'America/Montevideo', -2.00, -3.00, -3.00, 0),
('UZ', 'Asia/Samarkand', 5.00, 5.00, 5.00, 0),
('UZ', 'Asia/Tashkent', 5.00, 5.00, 5.00, 0),
('VA', 'Europe/Vatican', 1.00, 2.00, 1.00, 0),
('VC', 'America/St_Vincent', -4.00, -4.00, -4.00, 0),
('VE', 'America/Caracas', -4.50, -4.50, -4.50, 0),
('VG', 'America/Tortola', -4.00, -4.00, -4.00, 0),
('VI', 'America/St_Thomas', -4.00, -4.00, -4.00, 0),
('VN', 'Asia/Ho_Chi_Minh', 7.00, 7.00, 7.00, 0),
('VU', 'Pacific/Efate', 11.00, 11.00, 11.00, 0),
('WF', 'Pacific/Wallis', 12.00, 12.00, 12.00, 0),
('WS', 'Pacific/Apia', 14.00, 13.00, 13.00, 0),
('YE', 'Asia/Aden', 3.00, 3.00, 3.00, 0),
('YT', 'Indian/Mayotte', 3.00, 3.00, 3.00, 0),
('ZA', 'Africa/Johannesburg', 2.00, 2.00, 2.00, 0),
('ZM', 'Africa/Lusaka', 2.00, 2.00, 2.00, 0),
('ZW', 'Africa/Harare', 2.00, 2.00, 2.00, 0);

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

--
-- 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, 0, 'Donald', 'MCkinney', '1992-12-31', '', 0, '', 446954783, 'businessplan@gmail.com', 'upload/account/images/hinh-anh-avatar-96.jpg', 'Questa linea di ricerca, finalizzata allo studio degli ecosistemi marini pelagici e costieri, è incentrata sulla progettazione e la realizzazione di nuovi strumenti e sensori per la misura di variabili biologiche, ottiche, fisiche e chimiche dell\'acqua di mare, e di nuove piattaforme di misura per lo studio degli ecosistemi marini a differenti scale spaziali e temporali.', 'Santa monica bullevand', '', '', '', 0, '', 0, NULL, '0000-00-00 00:00:00', 'JUNIOR UI/UX DEVERLOPER', 0, 0, ''),
(2, 0, 'admin_netbase', '', NULL, '', 0, '', 0, 'hiep.v@netbasejsc.com', '', '', '', '', '', '', 0, '', 32, NULL, '2018-03-23 03:18:36', NULL, 0, 0, ''),
(3, 3, 'admin_netbase', '', '0000-00-00', '', 0, '', 0, 'ngoson2910@gmail.com', 'http://demo12.cmsmart.net/wp_booking_pro/wp-content/uploads/2020/10/8df1c50e9caea9220a8231a8a83e5ebe.png', '', '', '', '', '', 0, '', 1, '', '2020-02-07 09:29:10', '', 0, 0, '{\"facebook\":\"\",\"instagram\":\"\",\"twitter\":\"\",\"youtube\":\"\",\"printerest\":\"\"}'),
(4, 5, 'NetBase', 'Team', '0000-00-00', '', 84, 'VNM', 462752368, 'netbase_solusion@gmail.com', 'https://demo12.cmsmart.net/wp_booking_pro/wp-content/uploads/2020/10/8df1c50e9caea9220a8231a8a83e5ebe.png', 'Netbase JSC is a software outsourcing company which focus on a total e-Commerce solutions and consulting services.', '91 Nguyen Chi Thanh', '', '', '', 0, '', 2, 'NetBase', '2020-10-22 10:23:54', '', 0, 0, '{\"facebook\":\"https:\\/\\/www.facebook.com\\/netbasejsc\",\"instagram\":\"\",\"twitter\":\"\",\"youtube\":\"https:\\/\\/www.youtube.com\\/channel\\/UCQpHPbze77Qro13o4jl4-iA\",\"printerest\":\"\"}'),
(5, 5, 'test2', 'test2', NULL, '', 0, '', 0, 'test2@gmail.com', '', '', '', '', '', '', 0, '', 3, NULL, '2020-10-23 03:38:23', NULL, 0, 0, ''),
(6, 0, 'Nguy?n Th?', 'Xuân', NULL, '', 0, '', 0, 'tienngguyen@gmail.com', '', '', '', '', '', '', 0, '', 4, NULL, '2020-10-28 09:19:42', NULL, 0, 0, ''),
(11, 5, 'tien', 'nguyen', NULL, '', 0, '', 0, 'xuantien9996@gmail.com', '', '', '', '', '', '', 0, '', 7, NULL, '2020-11-03 07:19:15', NULL, 0, 0, '');

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

--
-- Table structure for table `woobooking_vendor_review`
--

DROP TABLE IF EXISTS `woobooking_vendor_review`;
CREATE TABLE `woobooking_vendor_review` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `review_id` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `woobooking_vendor_review`
--

INSERT INTO `woobooking_vendor_review` (`id`, `user_id`, `review_id`, `description`) VALUES
(1, 4, 6, '');

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

--
-- 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;

--
-- Indexes for dumped tables
--

--
-- 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_category_tag`
--
ALTER TABLE `woobooking_category_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`category_id`),
  ADD KEY `tag_id` (`tag_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_coupon`
--
ALTER TABLE `woobooking_coupon`
  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_employee`
--
ALTER TABLE `woobooking_employee`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_event`
--
ALTER TABLE `woobooking_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_id` (`service_id`),
  ADD KEY `location_id` (`location_id`);

--
-- Indexes for table `woobooking_event_employee`
--
ALTER TABLE `woobooking_event_employee`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `employee_id` (`employee_id`);

--
-- Indexes for table `woobooking_event_tag`
--
ALTER TABLE `woobooking_event_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `tag_id` (`tag_id`);

--
-- Indexes for table `woobooking_extra`
--
ALTER TABLE `woobooking_extra`
  ADD PRIMARY KEY (`id`),
  ADD KEY `object_id` (`object_id`);

--
-- Indexes for table `woobooking_finance`
--
ALTER TABLE `woobooking_finance`
  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_notification`
--
ALTER TABLE `woobooking_notification`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `woobooking_order_day_recurring`
--
ALTER TABLE `woobooking_order_day_recurring`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_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_package`
--
ALTER TABLE `woobooking_order_package`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `order_id_2` (`order_id`);

--
-- Indexes for table `woobooking_order_package_rate`
--
ALTER TABLE `woobooking_order_package_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `woobooking_order_package_rate` (`order_package_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_package`
--
ALTER TABLE `woobooking_package`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `woobooking_package_event`
--
ALTER TABLE `woobooking_package_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `employee_id` (`package_id`);

--
-- Indexes for table `woobooking_package_tag`
--
ALTER TABLE `woobooking_package_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`package_id`),
  ADD KEY `tag_id` (`tag_id`);

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

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

--
-- Indexes for table `woobooking_rate`
--
ALTER TABLE `woobooking_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`object_id`);

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

--
-- Indexes for table `woobooking_service`
--
ALTER TABLE `woobooking_service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `woobooking_service_coupon`
--
ALTER TABLE `woobooking_service_coupon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `review_id` (`coupon_id`) USING BTREE,
  ADD KEY `service_id` (`service_id`) USING BTREE;

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

--
-- Indexes for table `woobooking_service_review`
--
ALTER TABLE `woobooking_service_review`
  ADD PRIMARY KEY (`id`),
  ADD KEY `review_id` (`review_id`) USING BTREE,
  ADD KEY `service_id` (`service_id`) USING BTREE;

--
-- 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_timezone`
--
ALTER TABLE `woobooking_timezone`
  ADD PRIMARY KEY (`country_code`,`timezone`);

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

--
-- Indexes for table `woobooking_vendor_review`
--
ALTER TABLE `woobooking_vendor_review`
  ADD PRIMARY KEY (`id`),
  ADD KEY `review_id` (`review_id`) USING BTREE,
  ADD KEY `user_id` (`user_id`) USING BTREE;

--
-- 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_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=203;

--
-- 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=72;

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

--
-- 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_coupon`
--
ALTER TABLE `woobooking_coupon`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

--
-- 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=20;

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

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

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

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

--
-- 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_package`
--
ALTER TABLE `woobooking_order_package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `woobooking_order_package_rate`
--
ALTER TABLE `woobooking_order_package_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=11;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `woobooking_service_review`
--
ALTER TABLE `woobooking_service_review`
  MODIFY `id` int(11) 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 for table `woobooking_sms`
--
ALTER TABLE `woobooking_sms`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

--
-- 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;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `woobooking_event`
--
ALTER TABLE `woobooking_event`
  ADD CONSTRAINT `woobooking_event_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `woobooking_service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `woobooking_event_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `woobooking_location` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_event_employee`
--
ALTER TABLE `woobooking_event_employee`
  ADD CONSTRAINT `woobooking_event_employee_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `woobooking_employee` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `woobooking_event_employee_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `woobooking_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_event_tag`
--
ALTER TABLE `woobooking_event_tag`
  ADD CONSTRAINT `woobooking_event_tag_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `woobooking_tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `woobooking_event_tag_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `woobooking_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_extra`
--
ALTER TABLE `woobooking_extra`
  ADD CONSTRAINT `woobooking_extra_ibfk_1` FOREIGN KEY (`object_id`) REFERENCES `woobooking_service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_order_day_recurring`
--
ALTER TABLE `woobooking_order_day_recurring`
  ADD CONSTRAINT `woobooking_order_recurring_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `woobooking_order` (`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;

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

--
-- Constraints for table `woobooking_order_package_rate`
--
ALTER TABLE `woobooking_order_package_rate`
  ADD CONSTRAINT `woobooking_order_package_rate` FOREIGN KEY (`order_package_id`) REFERENCES `woobooking_order_package` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_package_event`
--
ALTER TABLE `woobooking_package_event`
  ADD CONSTRAINT `woobooking_package_event_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `woobooking_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `woobooking_package_event_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `woobooking_package` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `woobooking_service`
--
ALTER TABLE `woobooking_service`
  ADD CONSTRAINT `woobooking_service_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `woobooking_category` (`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 */;