-- https://www.phpmyadmin.net/
--
-- Máy chủ: localhost
-- Thời gian đã tạo: Th3 04, 2020 lúc 09:38 PM
-- Phiên bản máy phục vụ: 5.5.63-MariaDB
-- Phiên bản PHP: 7.2.21

START TRANSACTION;



--
-- Cơ sở dữ liệu: `wpbookingpro_1`
--

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_apps`
--

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

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `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', '', '', '', '', '');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `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\"]}');

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

--
-- Cấu trúc bảng cho bảng `woobooking_category`
--

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

--
-- Đang đổ dữ liệu cho bảng `woobooking_category`
--

INSERT INTO `woobooking_category` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Yoga', 'upload/employees/images/cover/14 Nov 1999welfare-ngo-preview2.jpg', '', 5, 1, 'Practicing with leading Yoga experts helps improve overall health and effectively prevents the signs of aging'),
(21, 'Cardio', 'upload/employees/images/cover/23 Jan 2013course_7.jpg', '', 9, 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, 'Body Combat', 'upload/employees/images/cover/12 Jul 1981course_5.jpg', '', 10, 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, 'Body building', 'upload/employees/images/cover/29 Jan 2017course_6.jpg', '', 11, 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, 'Gym ', 'upload/employees/images/cover/20 Feb 2008class_04-1200x600.jpg', '', 0, 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, 'Dance', 'upload/employees/images/cover/22 Jun 197108.png', '', 0, 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.');

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

--
-- Cấu trúc bảng cho bảng `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;

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_config`
--

INSERT INTO `woobooking_config` (`id`, `title`, `alias`, `params`) VALUES
(1, 'title1', 'title1', '{\"booking_style\":\"in_line\",\"using_jquery_ui\":\"1\",\"jquery_ui_version\":\"jquery-ui-1.11.4\",\"multi_product_in_cart\":\"1\",\"login_before_checkout\":\"1\",\"auto_create_account\":\"1\",\"group_user_when_register\":\"\",\"auto_login_when_create_account\":\"0\",\"clear_cart_when_checkout_finish\":\"1\",\"apply_for_coupon_membership\":\"0\",\"enable_vendor_application\":\"0\",\"path_media\":\"\",\"max_search_month\":\"6\",\"backup_database_path\":\"\",\"backup_media_path\":\"\",\"category_image_with\":\"5\",\"category_image_height\":\"5\",\"debug_end_user\":\"0\",\"debug_dev\":\"0\"}');

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

--
-- Cấu trúc bảng cho bảng `woobooking_country`
--

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

--
-- Đang đổ dữ liệu cho bảng `woobooking_country`
--

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

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

--
-- Cấu trúc bảng cho bảng `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,
  `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_customer`
--

INSERT INTO `woobooking_customer` (`id`, `user_open_source_commerce_id`, `first_name`, `last_name`, `image`, `opensource_user_id`, `mobile`, `created_date`, `address_1`, `address_2`, `city`, `email`, `gender`, `birth_day`, `ordering`, `note_internal`) VALUES
(468, 0, 'Ngo', 'Sơn', '', '', '1234567890', '0000-00-00 00:00:00', '', '', '', 'ngoson2910@gmail.com', '', '', 0, '');

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

--
-- Cấu trúc bảng cho bảng `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,
  `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_employee`
--

INSERT INTO `woobooking_employee` (`id`, `first_name`, `published`, `last_name`, `location_id`, `user_id`, `opensource_user_id`, `country_code`, `email`, `mobile`, `ordering`, `cover`, `image`, `params`, `note_internal`) VALUES
(1, 'Billy', 1, 'Pepper', 3, 0, 0, 'AUS', 'billy@myyogateacher.com', '265542198', 0, 'upload/employees/images/cover/01 Jan 1982360x390_img9.jpg', 'upload/employees/images/cover/21 Jul 2009360x390_img9.jpg', '{\"facebook\":\"\",\"instagram\":\"\"}', 'Yoga teacher with years of teaching experience. Gold medal in Master Yoga Science & Holistic Health contest.'),
(3, 'Alex', 1, 'Brian', 3, 0, 0, 'USA', 'alex@fightclub.com', '256996335', 0, 'upload/employees/images/cover/23 Mar 2004360x390_img2.jpg', 'upload/employees/images/cover/12 Sep 1995360x390_img2.jpg', 'null', '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', '266936569', 0, 'upload/employees/images/cover/06 Oct 1970360x390_img8.jpg', 'upload/employees/images/cover/16 Nov 2008360x390_img8.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', '233689554', 0, 'upload/employees/images/cover/08 Sep 1996360x390_img7.jpg', 'upload/employees/images/cover/04 Jan 1973360x390_img7.jpg', 'null', 'Certified UFC Coaches, Weight Loss, Cardio Conditioning, UFC Fit Classes. 5 years of bodybuilding training experience.'),
(8, 'Amanda', 1, 'Johnson', 5, 0, 0, 'USA', 'kelsey.rake@fightclub.com', '244665893', 0, 'upload/employees/images/cover/18 Dec 1981360x390_img6.jpg', 'upload/employees/images/cover/13 Apr 2009360x390_img6.jpg', 'null', '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', 3, 0, 0, 'USA', 'ofr@myyogateacher.com', '246335784', 0, 'upload/employees/images/cover/21 Nov 2016360x390_img4.jpg', 'upload/employees/images/cover/27 Dec 2002360x390_img4.jpg', 'null', 'Yoga Teacher with 6 years of teaching experience and possesses qualifications such as Indian Yoga Diploma'),
(15, 'Vicky', 1, 'Johnson', 5, 0, 0, 'USA', 'vicky@bodybuilders.com', '247845785', 0, 'upload/employees/images/cover/12 Nov 1998458x494_img1-450x468.jpg', 'upload/employees/images/cover/12 Dec 1972458x494_img1-450x468.jpg', 'null', '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', 4, 0, 0, 'AGO', 'alan@myyogateacher.com', '023847323', 0, 'upload/employees/images/cover/28 Feb 2002360x390_img5.jpg', 'upload/employees/images/cover/22 Jun 2000360x390_img5.jpg', 'null', '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', '156484961', 0, 'upload/employees/images/cover/02 Dec 1975360x390_img3.jpg', 'upload/employees/images/cover/22 Jul 1980360x390_img3.jpg', 'null', '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.');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_event`
--

INSERT INTO `woobooking_event` (`id`, `name`, `price`, `published`, `location_id`, `max_allowed_person`, `min_allowed_person`, `service_id`, `event_color`, `recurring_repeat`, `recurring`, `alias`, `description`, `recurring_until`, `ordering`, `publish_up`, `publish_down`, `close`, `close_date`, `open_date`) VALUES
(45, 'Yoga DIY - Lunging, foot & knee alignment and breathing', 8000, 1, 3, 20, 5, 45, '#e6194b', 'weekly', 1, '', 'This class helps to balance the mind and the mind, suitable for people practicing at any level. It is especially good for beginners because of its lightness and purity.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '2020-03-04 03:50:02', '2020-03-04 03:50:02'),
(47, 'Yoga DIY - Sun and Moon salutation flows for every day', 7677, 1, 4, 15, 6, 47, '#ffe119', 'weekly', 0, '', 'Join us for this class and familiarize yourself with the essential components of the Moon and Sun Salutations! We will learn you all the essential parts and get you prepared for new horizons.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-10 07:00:00', '2020-03-02 15:00:00'),
(63, 'Yoga DIY - Transitioning into downward facing dog', 56, 1, 5, 10, 5, 46, '#fabebe', 'weekly', 1, '', 'Like many transitions in yoga, the ability to step forward from downward dog into a lunge isn’t only about strength and flexibility, it’s also about technique. You will learn quick and easy techniques to follow to eliminate that hesitant response the next time you are in down dog and the teacher cues for you to step your foot forward. These techniques involve the mind, breath, and body.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-05-13 00:00:00', '2020-03-05 00:00:00'),
(64, 'Yoga DIY - Practice Yoga Safely', 56, 1, 4, 15, 5, 46, '#008080', 'weekly', 1, '', 'Yoga offers a complete body and mind workout, with a complement of benefits you rarely find elsewhere. Yet as Yoga has become more popular, Yoga-related injuries have also become more common. With the proper intention and attitude, you can keep your Yoga practice safe and injury-free.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-15 00:00:00', '2020-03-04 00:00:00'),
(69, 'Dance Fit - Pop, Rock, EDM and Kpop exercises are exciting', 5678, 1, 3, 40, 20, 59, '#800000', 'weekly', 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.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-31 00:00:00', '2020-03-13 00:00:00'),
(71, 'Let\'s Dance - Body movement', 56, 1, 4, 10, 3, 59, '#aaffc3', 'weekly', 1, '', 'The music used is the most vibrant and updated music genres regularly in the World. Unlimited Latin, Jazz, House, Techno ... Department welcomes all subjects.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-16 04:00:00', '2020-03-03 00:00:00'),
(72, 'Aerobic - Quick body fat reduction', 56, 1, 3, 15, 5, 60, '#ffe119', 'weekly', 0, '', 'Effective weight loss brings a glamorous body\r\nRemove stress, refreshed spirit\r\nDetox for the body, prevent aging\r\nConfidently \"adventure\" with friends at parties\r\nMaximum exercise stimulates tachycardia and better blood circulation.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-18 00:00:00', '2020-03-14 00:00:00'),
(73, 'Combat Sports - Discover your abilities', 50, 1, 3, 25, 10, 49, '#f032e6', 'weekly', 1, '', 'Flexible body, sensitive.\r\nMental comfort and fun.\r\nBurn 600 - 700 calories within 60 minutes of training.\r\nEnhance the activity of the heart, blood circulation.\r\nReduce the risk of heart disease.\r\nSelf-defense ability with some basic martial arts moves.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-10 11:00:00', '2020-03-07 11:00:00'),
(75, 'Cardio - Moving and movement', 78, 1, 4, 25, 7, 60, '#ffd8b1', 'weekly', 1, '', 'A heavy body, a lot of fat in the thighs and stomach makes you lose confidence when wearing clothes on the street or meeting friends at parties. This worrying issue will be solved if you look for weight loss exercise. To lose weight as well as want your body toned, you should apply cardio training process now.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-14 10:00:00', '2020-03-07 10:00:00'),
(76, 'Karate - Focus the whole body energy force', 67, 1, 5, 40, 15, 66, '#000075', 'weekly', 0, '', 'Remember that karate is a peaceful, non-violent martial art. The karate moves seem violent but mostly for self-defense. Practice a lot of the techniques you learn so that when you fight, you don\'t need to think, just act.', '0000-00-00', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2020-03-12 07:00:00', '2020-03-03 04:00:00');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_event_employee`
--

INSERT INTO `woobooking_event_employee` (`id`, `employee_id`, `event_id`, `description`) VALUES
(591, 1, 47, ''),
(592, 5, 47, ''),
(593, 7, 47, ''),
(594, 10, 63, ''),
(595, 30, 63, ''),
(596, 10, 64, ''),
(597, 30, 64, ''),
(598, 33, 64, ''),
(599, 3, 69, ''),
(600, 5, 69, ''),
(601, 8, 69, ''),
(602, 5, 76, ''),
(603, 30, 76, ''),
(604, 3, 75, ''),
(605, 5, 75, ''),
(606, 5, 73, ''),
(607, 15, 73, ''),
(608, 5, 72, ''),
(609, 7, 72, ''),
(610, 3, 71, ''),
(611, 5, 71, ''),
(616, 1, 45, ''),
(617, 10, 45, '');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_event_tag`
--

INSERT INTO `woobooking_event_tag` (`id`, `event_id`, `tag_id`, `description`) VALUES
(459, 47, 17, ''),
(460, 63, 14, ''),
(461, 63, 16, ''),
(462, 64, 16, ''),
(463, 69, 17, ''),
(464, 76, 20, ''),
(465, 76, 17, ''),
(466, 75, 20, ''),
(467, 73, 19, ''),
(468, 72, 18, ''),
(469, 71, 16, ''),
(470, 71, 17, ''),
(473, 45, 15, '');

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

--
-- Cấu trúc bảng cho bảng `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;

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_finance`
--

INSERT INTO `woobooking_finance` (`id`, `payment_date`, `name_customer`, `email_customer`, `employee`, `avatar_employee`, `service`, `status`) VALUES
(1, '2019-11-21', 'Valdecy Oliveira', 'brancodesign2014@gmail.com', 'Andrea Barber', 'upload/finances/avatar_employee/img1.jpg', 'Pregnant Yoga', 0),
(2, '2019-11-22', 'Hans Peter', 'hans.peter@gmail.com', 'Edwina Appleby', 'upload/finances/avatar_employee/img1.jpg', '\r\nAerobic', 0);

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_gallery`
--

INSERT INTO `woobooking_gallery` (`id`, `type`, `object_id`, `path`, `name`, `alias`, `description`) VALUES
(4, 'event', 1, 'upload/services/gallery/im1.jpg', 'new category', '', ''),
(5, '', 0, '', 'new category', '', ''),
(6, '', 0, '', 'new category', '', ''),
(7, '', 0, '', 'new category', '', ''),
(8, '', 0, '', 'new category', '', ''),
(9, '', 0, '', 'sdsds', '', ''),
(10, '', 0, '', 'sdsds', '', ''),
(11, '', 0, '', 'sds', '', ''),
(12, '', 0, '', 'sdsdsds', '', ''),
(13, '', 0, '', 'sds', '', ''),
(14, '', 0, '', 'sdsdsds', '', ''),
(15, '', 0, '', 'new category', '', ''),
(32, 'service', 1, 'upload/services/gallery/16 Jul 2006Screen Shot 2019-10-14 at 11.07.19 PM.png', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(33, 'service', 1, 'upload/services/gallery/09 Jul 2003Screen Shot 2019-10-14 at 11.07.39 PM.png', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(34, 'service', 1, 'upload/services/gallery/18 Dec 2017Screen Shot 2019-10-07 at 5.09.40 PM.png', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(35, 'service', 2, 'upload/services/gallery/02 Sep 1989Screen Shot 2019-10-14 at 11.07.39 PM.png', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(36, 'service', 2, 'upload/services/gallery/19 Jun 1992Screen Shot 2019-10-14 at 11.07.19 PM.png', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(37, 'service', 2, 'upload/services/gallery/11 Feb 2006Screen Shot 2019-10-08 at 1.23.31 PM.png', 'Screen Shot 2019-10-08 at 1.23.31 PM.png', '', ''),
(38, 'service', 7, 'upload/services/gallery/17 Jan 1993', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(39, 'service', 7, 'upload/services/gallery/09 Aug 1971', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(40, 'service', 7, 'upload/services/gallery/16 Nov 1990', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(41, 'service', 12, 'upload/services/gallery/19 Oct 1979', 'logo.jpg', '', ''),
(42, 'service', 12, 'upload/services/gallery/05 Nov 1970', 'Screen Shot 2019-10-14 at 11.07.39 PM.png', '', ''),
(43, 'service', 12, 'upload/services/gallery/24 Sep 1991', 'Screen Shot 2019-10-08 at 1.25.05 PM.png', '', ''),
(44, 'service', 36, 'upload/services/gallery/01 Jan 1983', 'Screen Shot 2019-10-08 at 1.23.31 PM.png', '', ''),
(45, 'event', 1, 'upload/events/gallery/13 Apr 1993', 'Screen Shot 2019-10-14 at 11.07.19 PM.png', '', ''),
(46, 'event', 1, 'upload/events/gallery/23 Feb 2014', 'Screen Shot 2019-10-08 at 1.25.05 PM.png', '', ''),
(47, 'service', 38, 'upload/services/gallery/30 Mar 2002', 'Screen Shot 2019-10-07 at 5.09.40 PM.png', '', ''),
(110, 'event', 46, 'upload/events/gallery/I7usuTnDYoga2.png', 'Yoga2.png', '', ''),
(112, 'event', 48, 'upload/events/gallery/7nWCNbI6Running3.png', 'Running3.png', '', ''),
(113, 'event', 48, 'upload/events/gallery/mOTTkn1VRunning2.png', 'Running2.png', '', ''),
(114, 'event', 48, 'upload/events/gallery/SqlYwYXsRunning-1.jpg', 'Running-1.jpg', '', ''),
(115, 'event', 49, 'upload/events/gallery/5VOmpu7Dyoga1.jpg', 'yoga1.jpg', '', ''),
(116, 'event', 50, 'upload/events/gallery/Y4QjTN0pYoga4.png', 'Yoga4.png', '', ''),
(117, 'event', 51, 'upload/events/gallery/j5IIMsvByoga1.jpg', 'yoga1.jpg', '', ''),
(118, 'event', 60, 'upload/events/gallery/JBAY235SYoga3.png', 'Yoga3.png', '', ''),
(119, 'event', 61, 'upload/events/gallery/PJjecnLxRunning3.png', 'Running3.png', '', ''),
(120, 'event', 62, 'upload/events/gallery/QEpt2aViRunning2.png', 'Running2.png', '', ''),
(121, 'event', 62, 'upload/events/gallery/RQ2TyhF0Running-1.jpg', 'Running-1.jpg', '', ''),
(123, 'event', 64, 'upload/events/gallery/jhArvhlkRunning3.png', 'Running3.png', '', ''),
(124, 'event', 64, 'upload/events/gallery/aQ8kVfSRRunning2.png', 'Running2.png', '', ''),
(125, 'event', 64, 'upload/events/gallery/LEZLjy2DRunning-1.jpg', 'Running-1.jpg', '', ''),
(126, 'event', 65, 'upload/events/gallery/GvO2kfW4Running-1.jpg', 'Running-1.jpg', '', ''),
(127, 'event', 66, 'upload/events/gallery/NBorqggsYoga2.png', 'Yoga2.png', '', ''),
(128, 'event', 67, 'upload/events/gallery/yPjcy5nZRunning3.png', 'Running3.png', '', ''),
(129, 'event', 68, 'upload/events/gallery/BC5RZawByoga1.jpg', 'yoga1.jpg', '', ''),
(131, 'event', 70, 'upload/events/gallery/Efg5lBpAYoga3.png', 'Yoga3.png', '', ''),
(137, 'event', 74, 'upload/events/gallery/FHJAh4kCRunning3.png', 'Running3.png', '', ''),
(140, 'event', 77, 'upload/events/gallery/iGRBI0QkRunning2.png', 'Running2.png', '', ''),
(141, 'package', 2, 'upload/packages/gallery/z51LBHdtanh3.jpg', 'anh3.jpg', '', ''),
(267, 'service', 85, 'upload/services/gallery/FnCLRyFh1548003974356-1-Legged-Wheel-Pose.jpg', '1548003974356-1-Legged-Wheel-Pose.jpg', '', ''),
(268, 'service', 85, 'upload/services/gallery/7W5DkEJndownload (1).jpg', 'download (1).jpg', '', ''),
(275, 'service', 88, 'upload/services/gallery/EnXaQiYsd', 'd', '', ''),
(276, 'service', 88, 'upload/services/gallery/guvpu5OHi', 'i', '', ''),
(277, 'service', 88, 'upload/services/gallery/iAcQYzaW6', '6', '', ''),
(278, 'service', 89, 'upload/services/gallery/0qjC6TF7d', 'd', '', ''),
(279, 'service', 89, 'upload/services/gallery/wwqZEX2Ki', 'i', '', ''),
(280, 'service', 89, 'upload/services/gallery/Q17C5w5T6', '6', '', ''),
(281, 'service', 90, 'upload/services/gallery/pV7yN8w8d', 'd', '', ''),
(282, 'service', 90, 'upload/services/gallery/njRZmHcUi', 'i', '', ''),
(283, 'service', 90, 'upload/services/gallery/MpfdDyr06', '6', '', ''),
(284, 'service', 91, 'upload/services/gallery/cgQ1rI4Wd', 'd', '', ''),
(285, 'service', 91, 'upload/services/gallery/msHZghA2i', 'i', '', ''),
(286, 'service', 91, 'upload/services/gallery/ATGXZNSS6', '6', '', ''),
(287, 'service', 92, 'upload/services/gallery/360U36Ovd', 'd', '', ''),
(288, 'service', 92, 'upload/services/gallery/hRxwJLXXi', 'i', '', ''),
(289, 'service', 92, 'upload/services/gallery/fmtjvUtU6', '6', '', ''),
(290, 'service', 93, 'upload/services/gallery/9Xu6SN5fd', 'd', '', ''),
(291, 'service', 93, 'upload/services/gallery/8Tq8NwrMi', 'i', '', ''),
(292, 'service', 93, 'upload/services/gallery/74St3U6S6', '6', '', ''),
(531, 'service', 94, 'upload/services/gallery/iGKEO8qw1548003974356-1-Legged-Wheel-Pose.jpg', '1548003974356-1-Legged-Wheel-Pose.jpg', '', ''),
(534, 'event', 47, 'upload/events/gallery/kflRa13d1.jpg', '1.jpg', '', ''),
(536, 'event', 47, 'upload/events/gallery/GEkjruqF3.jpg', '3.jpg', '', ''),
(538, 'event', 63, 'upload/events/gallery/tk9OoU5T2.jpg', '2.jpg', '', ''),
(540, 'event', 63, 'upload/events/gallery/XKABSWte4.jpg', '4.jpg', '', ''),
(541, 'event', 64, 'upload/events/gallery/VN5LRQnP03.png', '03.png', '', ''),
(542, 'event', 64, 'upload/events/gallery/vNv2oohw06.png', '06.png', '', ''),
(548, 'event', 71, 'upload/events/gallery/t6c9tuQE1.png', '1.png', '', ''),
(549, 'event', 71, 'upload/events/gallery/Or42hiRM2.png', '2.png', '', ''),
(551, 'event', 71, 'upload/events/gallery/BrQLOE1R5.png', '5.png', '', ''),
(552, 'event', 72, 'upload/events/gallery/iGtdkxWd1.jpg', '1.jpg', '', ''),
(553, 'event', 72, 'upload/events/gallery/RIqpE6J32.jpg', '2.jpg', '', ''),
(555, 'event', 73, 'upload/events/gallery/zhk0u4z03.jpg', '3.jpg', '', ''),
(556, 'event', 73, 'upload/events/gallery/GfahTbyw4.jpg', '4.jpg', '', ''),
(557, 'event', 73, 'upload/events/gallery/mM6Iqi3x5.jpg', '5.jpg', '', ''),
(559, 'event', 75, 'upload/events/gallery/4Gou0Nmp2.jpg', '2.jpg', '', ''),
(600, 'service', 97, 'upload/services/gallery/l095Iwhdportfolio-1-1-1170x694.jpg', 'portfolio-1-1-1170x694.jpg', '', ''),
(602, 'event', 45, 'upload/events/gallery/y85QuQFK555x442_img8.jpg', '555x442_img8.jpg', '', ''),
(603, 'event', 45, 'upload/events/gallery/6S7f43lY555x442_img9.jpg', '555x442_img9.jpg', '', ''),
(604, 'event', 45, 'upload/events/gallery/RJG7753H555x442_img7.jpg', '555x442_img7.jpg', '', ''),
(608, 'event', 47, 'upload/events/gallery/STsnNu6D7043852_2ce0299dde6cfbd45b992e8aef384a39.jpg', '7043852_2ce0299dde6cfbd45b992e8aef384a39.jpg', '', ''),
(609, 'event', 63, 'upload/events/gallery/vwdjXkcGunnamed.jpg', 'unnamed.jpg', '', ''),
(610, 'event', 64, 'upload/events/gallery/vTEqdhiv960x884_bg1.jpg', '960x884_bg1.jpg', '', ''),
(611, 'event', 69, 'upload/events/gallery/Rkj7mlonimage-caption2.jpg', 'image-caption2.jpg', '', ''),
(612, 'event', 69, 'upload/events/gallery/Meve8ElVimage-caption.jpg', 'image-caption.jpg', '', ''),
(613, 'event', 72, 'upload/events/gallery/9NVR7D8Kcourses-4.jpg', 'courses-4.jpg', '', ''),
(614, 'event', 75, 'upload/events/gallery/ssYr7XsVft-bg-cl3.jpg', 'ft-bg-cl3.jpg', '', ''),
(615, 'event', 75, 'upload/events/gallery/IUvjX1dPservice-01.jpg', 'service-01.jpg', '', ''),
(616, 'event', 76, 'upload/events/gallery/SB62inOkimg_25.jpg', 'img_25.jpg', '', ''),
(617, 'event', 76, 'upload/events/gallery/on2q29pGimg_11.jpg', 'img_11.jpg', '', ''),
(618, 'event', 76, 'upload/events/gallery/eq9YfYbwimg_24.jpg', 'img_24.jpg', '', ''),
(621, 'service', 97, 'upload/services/gallery/cXKY5c40bai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(622, 'service', 98, 'upload/services/gallery/4vIBDLLJbad-fitness-rules_1.jpg', 'bad-fitness-rules_1.jpg', '', ''),
(623, 'service', 98, 'upload/services/gallery/7ETRCrUebai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(624, 'service', 99, 'upload/services/gallery/kl0eKVcpclass_04-1200x600.jpg', 'class_04-1200x600.jpg', '', ''),
(625, 'service', 99, 'upload/services/gallery/Z6GxzgZRbai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(626, 'service', 45, 'upload/services/gallery/Yd8uLwg0yoga-1.jpg', 'yoga-1.jpg', '', ''),
(627, 'service', 45, 'upload/services/gallery/6U7HswrNbai-tap-yoga-tot-cho-xuong-khop-feature.jpg', 'bai-tap-yoga-tot-cho-xuong-khop-feature.jpg', '', ''),
(628, 'service', 46, 'upload/services/gallery/CYfvBD4sbai-tap-yoga-tot-cho-xuong-khop-feature.jpg', 'bai-tap-yoga-tot-cho-xuong-khop-feature.jpg', '', ''),
(629, 'service', 46, 'upload/services/gallery/K9Fe9ygpYoga là gì 7.jpg', 'Yoga là gì 7.jpg', '', ''),
(630, 'service', 47, 'upload/services/gallery/KNtqLPwscomo-yoga.jpg', 'como-yoga.jpg', '', ''),
(631, 'service', 47, 'upload/services/gallery/oeIuO4s7Yoga là gì 7.jpg', 'Yoga là gì 7.jpg', '', ''),
(632, 'service', 48, 'upload/services/gallery/ZUbYwztcpregnant-yoga_wide-de88addf0b08bf5b9b3e3f450060a14920167c0c.jpg', 'pregnant-yoga_wide-de88addf0b08bf5b9b3e3f450060a14920167c0c.jpg', '', ''),
(633, 'service', 48, 'upload/services/gallery/s12sltY5pregnancy-yoga-banner-1166x560.jpg', 'pregnancy-yoga-banner-1166x560.jpg', '', ''),
(634, 'service', 49, 'upload/services/gallery/1cKiRLim456240409.jpg', '456240409.jpg', '', ''),
(635, 'service', 49, 'upload/services/gallery/xVpwBkKlNhững-lợi-ích-của-Hot-Yoga-1200x800.jpg', 'Những-lợi-ích-của-Hot-Yoga-1200x800.jpg', '', ''),
(636, 'service', 50, 'upload/services/gallery/RUMe1iSfkriya_etg.jpg', 'kriya_etg.jpg', '', ''),
(637, 'service', 50, 'upload/services/gallery/IHOKLcvybai-tap-yoga-tot-cho-xuong-khop-feature.jpg', 'bai-tap-yoga-tot-cho-xuong-khop-feature.jpg', '', ''),
(638, 'service', 86, 'upload/services/gallery/tzCMSdal33170123_1976152045789287_4104958247767638016_o.jpg', '33170123_1976152045789287_4104958247767638016_o.jpg', '', ''),
(639, 'service', 86, 'upload/services/gallery/aWc2mXcIsexy-dance-la-gi1.jpg', 'sexy-dance-la-gi1.jpg', '', ''),
(640, 'service', 87, 'upload/services/gallery/004YdZbDsexy-dance-la-gi1.jpg', 'sexy-dance-la-gi1.jpg', '', ''),
(641, 'service', 87, 'upload/services/gallery/6R6MP1gn33170123_1976152045789287_4104958247767638016_o.jpg', '33170123_1976152045789287_4104958247767638016_o.jpg', '', ''),
(642, 'service', 87, 'upload/services/gallery/r6uKyhKIBoogie_Slide.jpg', 'Boogie_Slide.jpg', '', ''),
(643, 'service', 95, 'upload/services/gallery/wnSIL1TcBoogie_Slide.jpg', 'Boogie_Slide.jpg', '', ''),
(644, 'service', 96, 'upload/services/gallery/PD0vQBMRsexy-dance-la-gi1.jpg', 'sexy-dance-la-gi1.jpg', '', ''),
(645, 'service', 96, 'upload/services/gallery/mHkBFHEyBoogie_Slide.jpg', 'Boogie_Slide.jpg', '', ''),
(646, 'service', 61, 'upload/services/gallery/aae3Ey6Zbodycombat-1070205-TwoByOne.jpg', 'bodycombat-1070205-TwoByOne.jpg', '', ''),
(647, 'service', 61, 'upload/services/gallery/81bS9LlZBODYCOMBAT 1920x1040 MOD A .jpg', 'BODYCOMBAT 1920x1040 MOD A .jpg', '', ''),
(648, 'service', 62, 'upload/services/gallery/mV2vnnJ7Lima-2019-Eduardo-Avila-day-3.jpg', 'Lima-2019-Eduardo-Avila-day-3.jpg', '', ''),
(649, 'service', 63, 'upload/services/gallery/amMVtHe1featureimage-brazilian-jiu-jitsu-elle-man-1219.png', 'featureimage-brazilian-jiu-jitsu-elle-man-1219.png', '', ''),
(650, 'service', 63, 'upload/services/gallery/nlufirqK1_96FA5T__PjyxjQqPdKrlCQ.jpeg', '1_96FA5T__PjyxjQqPdKrlCQ.jpeg', '', ''),
(651, 'service', 64, 'upload/services/gallery/RV9k8vLIimg_25.jpg', 'img_25.jpg', '', ''),
(653, 'service', 64, 'upload/services/gallery/fhBZ4HfEimg_11.jpg', 'img_11.jpg', '', ''),
(654, 'service', 65, 'upload/services/gallery/j76VcEy14252394d7da6e597abc491efe4915e31.jpg', '4252394d7da6e597abc491efe4915e31.jpg', '', ''),
(655, 'service', 65, 'upload/services/gallery/hruX3V5D929628-19768245-1600-900.jpg', '929628-19768245-1600-900.jpg', '', ''),
(656, 'service', 66, 'upload/services/gallery/gjFSJS0ogiam-can-bang-vo-krav-maga-3-1200x665.jpg', 'giam-can-bang-vo-krav-maga-3-1200x665.jpg', '', ''),
(658, 'service', 51, 'upload/services/gallery/WngT3LN4screen-0.jpg', 'screen-0.jpg', '', ''),
(659, 'service', 52, 'upload/services/gallery/VfqPCzMncardio-box.jpg', 'cardio-box.jpg', '', ''),
(660, 'service', 52, 'upload/services/gallery/xbjMZM9hunnamed (4).jpg', 'unnamed (4).jpg', '', ''),
(661, 'service', 57, 'upload/services/gallery/lRVLJQ6Ybai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(662, 'service', 57, 'upload/services/gallery/rUN8odMDbad-fitness-rules_1.jpg', 'bad-fitness-rules_1.jpg', '', ''),
(663, 'service', 58, 'upload/services/gallery/iHdXFO4Ecover-nhay-aerobic-1581822288.jpeg', 'cover-nhay-aerobic-1581822288.jpeg', '', ''),
(664, 'service', 58, 'upload/services/gallery/iB87ZTcTggiam mo bung 1.jpg2.jpg3.jpg4.jpg5.jpg6.jpg7.jpg', 'ggiam mo bung 1.jpg2.jpg3.jpg4.jpg5.jpg6.jpg7.jpg', '', ''),
(665, 'service', 59, 'upload/services/gallery/rpZ5yJacreebok_ss15_-_bodyattack__9_jpeg-rotator-ashx.jpg', 'reebok_ss15_-_bodyattack__9_jpeg-rotator-ashx.jpg', '', ''),
(666, 'service', 59, 'upload/services/gallery/gnRerMzUWEB0045_New_Website_-_Images_BodyAttack_1800x580.jpg', 'WEB0045_New_Website_-_Images_BodyAttack_1800x580.jpg', '', ''),
(667, 'service', 60, 'upload/services/gallery/eGHUEMVKBODYCOMBAT 1920x1040 MOD A .jpg', 'BODYCOMBAT 1920x1040 MOD A .jpg', '', ''),
(668, 'service', 60, 'upload/services/gallery/683S8v2Qbodycombat-1070205-TwoByOne.jpg', 'bodycombat-1070205-TwoByOne.jpg', '', ''),
(669, 'service', 67, 'upload/services/gallery/EFUd3zmebai-tap-gym-elle-man-featured-image.jpg', 'bai-tap-gym-elle-man-featured-image.jpg', '', ''),
(670, 'service', 67, 'upload/services/gallery/A58cVB4Lfitness-la-gi-1280x720.jpg', 'fitness-la-gi-1280x720.jpg', '', ''),
(671, 'service', 68, 'upload/services/gallery/LLATrEsSbai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(672, 'service', 68, 'upload/services/gallery/0SWvMGsJfitness-la-gi-1280x720.jpg', 'fitness-la-gi-1280x720.jpg', '', ''),
(673, 'service', 69, 'upload/services/gallery/AvkmDQzQLayer 1.png', 'Layer 1.png', '', ''),
(674, 'service', 70, 'upload/services/gallery/ysOaEuHlbad-fitness-rules_1.jpg', 'bad-fitness-rules_1.jpg', '', ''),
(675, 'service', 70, 'upload/services/gallery/elpLzztCfitness-la-gi-1280x720.jpg', 'fitness-la-gi-1280x720.jpg', '', ''),
(676, 'service', 71, 'upload/services/gallery/W6qxTZS1cardio-box.jpg', 'cardio-box.jpg', '', ''),
(677, 'service', 71, 'upload/services/gallery/F0jKkkDRunnamed (1).jpg', 'unnamed (1).jpg', '', ''),
(678, 'service', 72, 'upload/services/gallery/nam1yhg4bai-tap-yoga-tot-cho-xuong-khop-feature.jpg', 'bai-tap-yoga-tot-cho-xuong-khop-feature.jpg', '', ''),
(679, 'service', 72, 'upload/services/gallery/gYDu6cNgbai-tap-gym-ELLE-Man-feature.jpg', 'bai-tap-gym-ELLE-Man-feature.jpg', '', ''),
(680, 'service', 66, 'upload/services/gallery/pnOb0Rjofitness-la-gi-1280x720.jpg', 'fitness-la-gi-1280x720.jpg', '', '');

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

--
-- Cấu trúc bảng cho bảng `woobooking_location`
--

CREATE TABLE `woobooking_location` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `banner` varchar(400) NOT NULL,
  `image_location_avatar` varchar(400) NOT NULL,
  `map_image` varchar(400) NOT NULL,
  `address` varchar(200) NOT NULL,
  `alias` varchar(200) NOT NULL,
  `state_id` int(11) NOT NULL,
  `lang` varchar(50) NOT NULL,
  `lat` varchar(50) 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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_location`
--

INSERT INTO `woobooking_location` (`id`, `name`, `banner`, `image_location_avatar`, `map_image`, `address`, `alias`, `state_id`, `lang`, `lat`, `published`, `ordering`, `image`, `description`) VALUES
(3, 'CALIFORNIA', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/class-2-1-1170x694-1.jpg', 'upload/locations/images/12 Mar 2014class-2-1-1170x694.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_51.png', '415 Temple Lane, Antioch, CA 94509', 'address2', 4, '21.0064286', '105.8654489', 1, 0, 'upload/locations/images/im1.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, 'MIAMI', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/class-3-1-1170x694-1.jpg', 'upload/locations/images/20 Oct 2019class-3-1-1170x694.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_52.png', '31 NW 57th St, Miami, FL 33127', '', 3, '', '', 1, 0, 'upload/locations/images/im1.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, 'New York', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/class-6-1-1170x694-1.jpg', 'upload/locations/images/07 Oct 2018class-6-1-1170x694.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_72.png', 'Montclair, New Jersey', '', 6, '', '', 1, 0, 'upload/locations/images/im1.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, 'PARIS', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/class-5-1-1170x694-1.jpg', 'upload/locations/images/12 Mar 1985class-5-1-1170x694.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_73.png', 'Las Vegas, Nevada', '', 6, '', '', 0, 0, '', 'Enjoy the gym & yoga chain with sophisticated design and the most perfect service right in the heart of Las Vegas.'),
(15, 'ROME', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/blog-1-1.jpg', 'upload/locations/images/19 Jan 2017blog-1-1.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_73.png', ' Dell\'Angeletto 3, 00184 Rome, Italy', '', 6, '', '', 0, 0, '', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.'),
(16, 'VENICE', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/blog-6-1.jpg', 'upload/locations/images/25 Jun 1987blog-6-1.jpg', 'http://45.119.84.18/~wpbookingpro/wp-content/uploads/2020/02/Screenshot_51.png', 'Ca\' Farsetti, San Marco 4136 - Venezia - ITALY', '', 6, '', '', 0, 0, '', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_notification`
--

INSERT INTO `woobooking_notification` (`id`, `name`, `image`, `alias`, `ordering`, `description`) VALUES
(20, 'Yoga', 'upload/services/images/image-cover-rbwx5797-anh1.jpg', '', 5, ''),
(21, 'Cardio', 'upload/services/images/image-cover-UsfbDi7H-anh2.jpg', '', 9, ''),
(22, 'Combat Sports', 'upload/services/images/image-cover-VYEUjPNq-anh3.jpg', '', 10, ''),
(23, 'Bodybuilding', 'upload/services/images/image-cover-L0T85YOJ-anh4.jpg', '', 11, ''),
(46, 'Boxing room', 'upload/services/images/image-cover-VW24WlTK-anh5.jpg', '', 11, ''),
(47, 'Meo', 'upload/services/images/image-cover-VW24WlTK-anh5.jpg', '', 0, 'Hahahahahah'),
(48, 'new category', '', '', 0, ''),
(49, 'new category', '', '', 0, ''),
(50, 'new category', '', '', 0, ''),
(51, 'new category', '', '', 0, ''),
(52, 'new category', '', '', 0, ''),
(53, 'new category', '', '', 0, '');

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

--
-- Cấu trúc bảng cho bảng `woobooking_order`
--

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

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_order_customer`
--

INSERT INTO `woobooking_order_customer` (`id`, `order_id`, `customer_id`, `alias`, `data`) VALUES
(1, 0, 0, 'title1', 'des title1');

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

--
-- Cấu trúc bảng cho bảng `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,
  `subtotal` float NOT NULL,
  `total` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Cấu trúc bảng cho bảng `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,
  `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,
  `subtotal` float NOT NULL,
  `rate_id` int(11) NOT NULL,
  `total` float NOT NULL,
  `total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Cấu trúc bảng cho bảng `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;

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

--
-- Cấu trúc bảng cho bảng `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;

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

--
-- Cấu trúc bảng cho bảng `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Đang đổ dữ liệu cho bảng `woobooking_order_status`
--

INSERT INTO `woobooking_order_status` (`id`, `name`, `title`, `ordering`, `alias`, `data`) VALUES
(4, 'pending', 'Pending', 0, '', ''),
(5, 'complete', 'Complete', 0, '', '');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_package`
--

INSERT INTO `woobooking_package` (`id`, `image`, `name`, `params`, `price`, `published`, `package_color`, `description`, `ordering`) VALUES
(2, 'blocks/block_priceplanclass/assets/images/the-member1.png', 'Silver members', '{\"booking_style\":\"integrate\",\"using_jquery_ui\":\"1\",\"jquery_ui_version\":\"jquery-ui-1.11.4\",\"path_media\":\"sdfsdfs34343\",\"backup_database_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\",\"backup_media_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\"}', 79, 0, '', 'dd', 0),
(3, 'blocks/block_priceplanclass/assets/images/the-member2.png', 'Gold members', '{\"booking_style\":\"integrate\",\"using_jquery_ui\":\"1\",\"jquery_ui_version\":\"jquery-ui-1.11.4\",\"path_media\":\"sdfsdfs34343\",\"backup_database_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\",\"backup_media_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\"}', 89, 0, '', 'tt', 0),
(4, 'blocks/block_priceplanclass/assets/images/the-member3.png', 'Diamond members', '{\"booking_style\":\"integrate\",\"using_jquery_ui\":\"1\",\"jquery_ui_version\":\"jquery-ui-1.11.4\",\"path_media\":\"sdfsdfs34343\",\"backup_database_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\",\"backup_media_path\":\"\\/public_html\\/wooboking_fitness_v1\\/wp-content\\/uploads\"}', 99, 0, '', 'rrr', 0);

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_package_event`
--

INSERT INTO `woobooking_package_event` (`id`, `package_id`, `event_id`, `description`) VALUES
(4, 3, 45, ''),
(5, 3, 47, ''),
(6, 3, 63, ''),
(7, 4, 45, ''),
(8, 4, 47, ''),
(9, 4, 63, ''),
(10, 4, 69, ''),
(11, 2, 45, ''),
(12, 2, 47, '');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_package_tag`
--

INSERT INTO `woobooking_package_tag` (`id`, `package_id`, `tag_id`, `description`) VALUES
(7, 35, 14, ''),
(8, 36, 14, ''),
(9, 37, 14, ''),
(16, 2, 3, ''),
(17, 2, 4, '');

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

--
-- Cấu trúc bảng cho bảng `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,
  `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_payment`
--

INSERT INTO `woobooking_payment` (`id`, `type`, `is_payment_online`, `name`, `debug`, `image`, `alias`, `ordering`, `params`, `published`, `description`, `event_id`, `location_id`) VALUES
(20, 'paypal', 1, 'Paypal', 1, 'upload/payment/images/12 Dec 2002paypal-logo-2015_grande.png', '', 5, '{\"payment_params\":{\"email\":\"digitalsolutiontoppro@gmail.com\"}}', 1, '', 0, 0),
(72, 'banktransfer', 0, 'Banktransfer', 0, 'upload/payment/images/01 Oct 1995Screenshot_38.png', '', 0, 'null', 1, '', 0, 0);

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_rate`
--

INSERT INTO `woobooking_rate` (`id`, `type`, `object_id`, `from`, `to`, `ordering`, `description`) VALUES
(102, 'event', 61, '2019-12-23 15:05:00', '2019-12-23 15:37:00', 0, ''),
(103, 'event', 62, '2019-12-26 15:17:00', '2019-12-26 15:49:00', 0, ''),
(106, 'event', 65, '2019-12-29 16:00:00', '2019-12-29 16:32:00', 0, ''),
(108, 'event', 68, '2020-01-01 16:13:00', '2020-01-01 16:45:00', 0, ''),
(118, 'event', 66, '2019-12-30 16:02:00', '2019-12-30 16:34:00', 0, ''),
(122, 'event', 0, '2019-12-13 08:01:35', '2019-12-13 08:01:35', 0, ''),
(123, 'event', 0, '2019-12-13 08:02:03', '2019-12-13 08:02:03', 0, ''),
(124, 'event', 0, '2019-12-13 08:05:06', '2019-12-13 08:05:06', 0, ''),
(125, 'event', 0, '2019-12-13 08:06:22', '2019-12-13 08:06:22', 0, ''),
(126, 'event', 0, '2019-12-10 10:39:00', '2019-12-28 11:11:00', 0, ''),
(127, 'event', 0, '2019-12-16 05:34:18', '2019-12-16 05:34:18', 0, ''),
(128, 'event', 0, '2019-12-16 05:38:30', '2019-12-16 05:38:30', 0, ''),
(129, 'event', 0, '2019-12-16 09:03:27', '2019-12-16 09:03:27', 0, ''),
(130, 'event', 0, '2019-12-16 09:03:51', '2019-12-16 09:03:51', 0, ''),
(131, 'event', 0, '2019-12-16 09:03:51', '2019-12-16 09:03:51', 0, ''),
(132, 'event', 0, '2019-12-16 09:07:56', '2019-12-16 09:07:56', 0, ''),
(133, 'event', 0, '2019-12-16 14:54:00', '2019-12-16 15:26:00', 0, ''),
(134, 'event', 0, '2020-01-10 16:38:00', '2020-01-10 17:10:00', 0, ''),
(135, 'event', 0, '2019-12-16 09:14:41', '2019-12-16 09:14:41', 0, ''),
(136, 'event', 0, '2019-12-16 09:15:31', '2019-12-16 09:15:31', 0, ''),
(137, 'event', 0, '2019-12-16 09:19:00', '2019-12-16 09:19:00', 0, ''),
(138, 'event', 0, '2019-12-16 09:26:14', '2019-12-16 09:26:14', 0, ''),
(139, 'event', 0, '2019-12-16 09:27:38', '2019-12-16 09:27:38', 0, ''),
(140, 'event', 0, '2019-12-16 09:34:22', '2019-12-16 09:34:22', 0, ''),
(141, 'event', 0, '2019-12-16 09:41:52', '2019-12-16 09:41:52', 0, ''),
(142, 'event', 0, '2019-12-16 09:42:47', '2019-12-16 09:42:47', 0, ''),
(143, 'event', 0, '2019-12-16 09:46:27', '2019-12-16 09:46:27', 0, ''),
(144, 'event', 0, '2019-12-16 09:47:38', '2019-12-16 09:47:38', 0, ''),
(145, 'event', 0, '2019-12-16 09:49:19', '2019-12-16 09:49:19', 0, ''),
(146, 'event', 0, '2019-12-16 09:50:26', '2019-12-16 09:50:26', 0, ''),
(147, 'event', 0, '2019-12-16 09:50:50', '2019-12-16 09:50:50', 0, ''),
(148, 'event', 0, '2019-12-16 09:51:37', '2019-12-16 09:51:37', 0, ''),
(149, 'event', 0, '2019-12-16 09:51:37', '2019-12-16 09:51:37', 0, ''),
(150, 'event', 0, '2019-12-16 09:54:50', '2019-12-16 09:54:50', 0, ''),
(151, 'event', 0, '2019-12-16 09:56:07', '2019-12-16 09:56:07', 0, ''),
(152, 'event', 0, '2019-12-16 09:56:36', '2019-12-16 09:56:36', 0, ''),
(153, 'event', 0, '2019-12-16 10:07:42', '2019-12-16 10:07:42', 0, ''),
(154, 'event', 0, '2019-12-16 11:26:55', '2019-12-16 11:26:55', 0, ''),
(155, 'event', 0, '2019-12-16 11:58:51', '2019-12-16 11:58:51', 0, ''),
(156, 'event', 0, '2019-12-16 11:59:45', '2019-12-16 11:59:45', 0, ''),
(157, 'event', 0, '2019-12-16 12:01:32', '2019-12-16 12:01:32', 0, ''),
(181, 'event', 48, '2019-12-18 10:00:00', '2019-12-18 11:30:00', 0, ''),
(182, 'event', 48, '2019-12-19 10:00:00', '2019-12-19 11:30:00', 0, ''),
(183, 'event', 48, '2019-12-20 10:00:00', '2019-12-20 11:30:00', 0, ''),
(184, 'event', 49, '2019-12-18 11:21:00', '2019-12-18 11:21:00', 0, ''),
(185, 'event', 49, '2019-12-19 10:19:00', '2019-12-19 10:51:00', 0, ''),
(186, 'event', 49, '2019-12-20 10:19:00', '2019-12-20 10:51:00', 0, ''),
(187, 'event', 50, '2019-12-18 10:21:00', '2019-12-18 10:53:00', 0, ''),
(188, 'event', 50, '2019-12-19 10:21:00', '2019-12-19 10:53:00', 0, ''),
(189, 'event', 50, '2019-12-22 10:21:00', '2019-12-22 10:53:00', 0, ''),
(193, 'event', 51, '2019-12-20 10:22:00', '2019-12-20 10:54:00', 0, ''),
(194, 'event', 51, '2019-12-21 10:22:00', '2019-12-21 10:54:00', 0, ''),
(195, 'event', 60, '2019-12-23 10:23:00', '2019-12-23 10:55:00', 0, ''),
(196, 'event', 60, '2019-12-24 10:23:00', '2019-12-24 10:55:00', 0, ''),
(197, 'event', 60, '2019-12-25 10:23:00', '2019-12-25 10:55:00', 0, ''),
(198, 'event', 67, '2020-01-01 10:24:00', '2020-01-01 10:56:00', 0, ''),
(199, 'event', 67, '2020-01-02 10:24:00', '2020-01-02 10:56:00', 0, ''),
(200, 'event', 67, '2020-01-03 10:24:00', '2020-01-03 10:56:00', 0, ''),
(203, 'event', 70, '2019-12-30 10:56:00', '2019-12-30 13:58:00', 0, ''),
(204, 'event', 70, '2020-01-05 10:26:00', '2020-01-05 10:58:00', 0, ''),
(215, 'event', 74, '2019-12-18 22:29:00', '2019-12-18 22:29:00', 0, ''),
(216, 'event', 77, '2020-01-04 10:31:00', '2020-01-04 17:03:00', 0, ''),
(217, 'event', 77, '2020-01-06 10:31:00', '2020-01-06 19:03:00', 0, ''),
(234, 'event', 78, '2019-12-19 20:46:00', '2020-01-23 21:18:00', 0, ''),
(309, 'event', 46, '2019-12-20 10:16:00', '2019-12-20 10:48:00', 0, ''),
(310, 'event', 46, '2019-12-20 07:47:11', '2019-12-20 07:47:11', 0, ''),
(541, 'event', 47, '2020-03-11 05:00:00', '2020-03-19 06:00:00', 0, ''),
(542, 'event', 47, '2020-03-27 11:00:00', '2020-04-04 12:30:00', 0, ''),
(543, 'event', 63, '2020-03-18 05:00:00', '2020-03-31 07:00:00', 0, ''),
(544, 'event', 64, '2020-03-17 09:00:00', '2020-03-31 10:30:00', 0, ''),
(545, 'event', 69, '2020-04-01 07:30:00', '2020-04-24 10:00:00', 0, ''),
(546, 'event', 76, '2020-03-05 05:00:00', '2020-03-12 06:00:00', 0, ''),
(547, 'event', 76, '2020-03-21 04:00:00', '2020-03-28 05:00:00', 0, ''),
(548, 'event', 75, '2020-03-07 10:30:00', '2020-03-14 11:30:00', 0, ''),
(549, 'event', 75, '2020-03-16 03:30:00', '2020-03-23 05:00:00', 0, ''),
(550, 'event', 73, '2020-03-11 07:00:00', '2020-03-18 08:00:00', 0, ''),
(551, 'event', 72, '2020-03-19 05:30:00', '2020-03-24 07:00:00', 0, ''),
(552, 'event', 71, '2020-03-18 03:00:00', '2020-03-31 04:30:00', 0, ''),
(553, 'event', 71, '2020-03-19 10:30:00', '2020-03-31 12:00:00', 0, ''),
(558, 'event', 45, '2020-03-02 06:00:00', '2020-03-20 07:30:00', 0, ''),
(559, 'event', 45, '2020-03-11 05:00:00', '2020-03-26 06:30:00', 0, '');

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

--
-- Cấu trúc bảng cho bảng `woobooking_service`
--

CREATE TABLE `woobooking_service` (
  `id` int(11) NOT NULL,
  `category_id` int(11) UNSIGNED NOT NULL,
  `duration` float 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,
  `multiply_number` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `disable_payment_online` int(11) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Đang đổ dữ liệu cho bảng `woobooking_service`
--

INSERT INTO `woobooking_service` (`id`, `category_id`, `duration`, `price`, `open_source_link_id`, `buffer_time_before`, `ordering`, `buffer_time_after`, `minimum_capacity`, `maximum_capacity`, `bringing_anyone`, `price_will_multiply`, `published`, `multiply_number`, `name`, `image`, `disable_payment_online`, `description`) VALUES
(45, 20, 1.5, 50, 6305, 0, 0, 1, 4, 12, 1, 0, 1, 1, 'Hatha Yoga', 'upload/services/images/image-cover-45-unnamed.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.'),
(46, 20, 1, 60, 6304, 0, 0, 1, 3, 20, 1, 0, 1, 1, 'Vinyasa Yoga', 'upload/services/images/image-cover-46-2-dong-tac-don-gian-giup-giam-beo-vung-lung-vai-va-bap-tay-204903.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.'),
(47, 20, 1.5, 45, 6306, 0, 0, 1, 5, 10, 1, 0, 1, 1, 'Gentle Yoga', 'upload/services/images/image-cover-47-4.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.'),
(48, 20, 2, 80, 6306, 0, 0, 1, 4, 18, 1, 0, 1, 1, 'Pregnant Yoga', 'upload/services/images/image-cover-48-960x884_bg1.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.'),
(49, 20, 1, 40, 6305, 0, 0, 1, 6, 12, 1, 0, 1, 1, 'Hot Yoga', 'upload/services/images/image-cover-49-unnamed.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 ...'),
(50, 20, 1, 50, 6306, 0, 0, 1, 5, 10, 1, 0, 1, 1, 'Kundalini Yoga', 'upload/services/images/image-cover-50-dich-vu-day-pilates-tai-nha-kem-pt-3.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.'),
(51, 21, 1, 20, 6303, 0, 0, 0, 8, 16, 1, 0, 1, 1, 'Spinning Lessons', 'upload/services/images/image-cover-51-portfolio-5-1-843x500.jpg', 0, '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.'),
(52, 21, 1.5, 50, 6306, 0, 0, 1, 3, 12, 1, 0, 1, 1, 'Cardio Box', 'upload/services/images/image-cover-52-BodyCombat.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.'),
(57, 21, 0, 30, 6302, 0, 0, 1, 6, 16, 1, 0, 1, 1, 'Core HIIT', 'upload/services/images/image-cover-57-portfolio-3-1-843x500.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!'),
(58, 21, 1, 30, 6305, 0, 0, 1, 5, 16, 1, 0, 1, 1, 'Aerobic', 'upload/services/images/image-cover-58-active-aerobics-beautiful-903171-150x150.jpg', 1, 'The basic effects of aerobic exercise:\r\n- Strengthen the muscles involved in the respiratory process.\r\n- Strengthen and strengthen the heart muscle.\r\n- Increases red blood cells, enabling oxygen to be provided to the entire body.'),
(59, 21, 1.5, 55, 6302, 0, 0, 1, 5, 10, 1, 0, 1, 1, 'Body Attack', 'upload/services/images/image-cover-59-adult-arms-beauty-917660-150x150.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'),
(60, 21, 1, 60, 6301, 0, 0, 1, 3, 8, 1, 0, 1, 1, 'Body Combat', 'upload/services/images/image-cover-60-athlete-barbell-blurred-background-700446-150x150.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.'),
(61, 22, 2, 80, 6306, 0, 0, 1, 4, 12, 1, 0, 1, 1, 'MMA', 'upload/services/images/image-cover-61-action-adult-athlete-598664-150x150.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.'),
(62, 22, 1.5, 70, 6305, 0, 0, 1, 6, 12, 1, 0, 1, 1, 'Judo', 'upload/services/images/image-cover-62-Judo-game-HD-picture-04-150x150.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.'),
(63, 22, 1.5, 70, 6304, 0, 0, 1, 4, 8, 1, 0, 1, 1, 'Jiu-Jitsu', 'upload/services/images/image-cover-63-download-150x150.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.'),
(64, 22, 1, 50, 6303, 0, 0, 1, 5, 15, 1, 0, 1, 1, 'Karate', 'upload/services/images/image-cover-64-1103984-free-karate-wallpaper-1920x1080-mobile-150x150.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.'),
(65, 22, 1.5, 55, 6306, 0, 0, 1, 4, 10, 1, 0, 1, 1, 'Taekwondo', 'upload/services/images/image-cover-65-taekwondo-1866283_960_720-150x150.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.'),
(66, 22, 1, 60, 6303, 0, 0, 1, 6, 20, 1, 0, 1, 1, 'Krav Maga', 'upload/services/images/image-cover-66-images-150x150.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.'),
(67, 23, 1.5, 35, 0, 0, 0, 1, 1, 1, 1, 0, 1, 1, 'Dumbbell Bench Press', 'upload/services/images/image-cover-67-athlete-barbell-body-949126-150x150.jpg', 1, '. Supple body toned muscle.\r\n. Strengthened endurance.\r\n. Burn 540 calories within 60 minutes of exercise.'),
(68, 23, 1.5, 2, 0, 0, 0, 1, 7, 15, 1, 0, 1, 1, 'German Volume Training', 'upload/services/images/image-cover-68-athlete-barbell-body-931321-150x150.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.'),
(69, 23, 1, 35, 6305, 0, 0, 1, 8, 25, 1, 0, 1, 1, 'Upper/Lower Split Training', 'upload/services/images/image-cover-69-athlete-biceps-blonde-136410-e1527867386172-131x150.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.'),
(70, 23, 2, 60, 6304, 0, 0, 1, 5, 15, 1, 0, 1, 1, 'Tactical Strength Training', 'upload/services/images/image-cover-70-active-athlete-barbell-703010-150x150.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.'),
(71, 23, 1.5, 50, 6306, 0, 0, 1, 3, 6, 1, 0, 1, 1, 'FST-7', 'upload/services/images/image-cover-71-action-energy-active-adult-1032117-150x150.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.'),
(72, 23, 2.5, 100, 6306, 0, 0, 1, 3, 10, 1, 0, 1, 1, 'Weight Training – Advanced', 'upload/services/images/image-cover-72-adult-body-bodybuilding-931324-150x150.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.'),
(86, 70, 1, 50, 6304, 0, 0, 1, 10, 30, 1, 0, 1, 1, 'Dance Fit', 'upload/services/images/image-cover-86-1.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.'),
(87, 70, 1, 65, 0, 0, 0, 1, 15, 50, 1, 0, 1, 1, 'Sexy Dance', 'upload/services/images/image-cover-87-5_3.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.'),
(95, 70, 0, 39, 0, 0, 0, 0, 10, 45, 1, 0, 1, 1, 'Freestyle Dance', 'upload/services/images/image-cover-95-2_3.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.'),
(97, 68, 0, 57, 0, 0, 0, 0, 5, 15, 1, 0, 1, 1, 'Killer Core', 'upload/services/images/image-cover-97-5.jpg', 1, 'Killer Core - a class that uses exercise tools such as stretchers, dumbbells combined with bodyweight to increase strength and stability for central muscle groups.'),
(98, 68, 0, 25, 0, 0, 0, 0, 10, 28, 1, 0, 1, 1, 'Hard Core Abs', 'upload/services/images/image-cover-98-stop-letting-your-genetic-ceiling-sabotage-your-goals-tall-v2.jpg', 1, 'The class uses high-level abdominal exercises, designed to give you the perfect muscle, especially the abdominal muscles.'),
(99, 68, 0, 49, 0, 0, 0, 1, 5, 20, 1, 0, 1, 1, 'Total Body Barbell', 'upload/services/images/image-cover-99-blog-2-1.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.');

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

--
-- Cấu trúc bảng cho bảng `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,
  `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_service_employee`
--

INSERT INTO `woobooking_service_employee` (`id`, `employee_id`, `service_id`, `enable_customize`, `price`, `minimum_capacity`, `maximum_capacity`, `description`) VALUES
(6, 2, 8, 0, 0, 0, 0, ''),
(8, 4, 8, 0, 0, 0, 0, ''),
(9, 2, 26, 0, 0, 0, 0, ''),
(11, 4, 26, 0, 0, 0, 0, ''),
(13, 2, 30, 0, 0, 0, 0, ''),
(309, 5, 97, 0, 0, 0, 0, ''),
(310, 10, 97, 0, 0, 0, 0, ''),
(311, 33, 97, 0, 0, 0, 0, ''),
(314, 3, 98, 0, 0, 0, 0, ''),
(315, 7, 98, 0, 0, 0, 0, ''),
(316, 3, 99, 0, 0, 0, 0, ''),
(317, 7, 99, 0, 0, 0, 0, ''),
(331, 10, 47, 0, 0, 0, 0, ''),
(332, 30, 47, 0, 0, 0, 0, ''),
(335, 7, 50, 0, 0, 0, 0, ''),
(336, 10, 50, 0, 0, 0, 0, ''),
(337, 3, 86, 0, 0, 0, 0, ''),
(338, 10, 86, 0, 0, 0, 0, ''),
(339, 8, 87, 0, 0, 0, 0, ''),
(340, 15, 95, 0, 0, 0, 0, ''),
(341, 33, 96, 0, 0, 0, 0, ''),
(342, 1, 61, 0, 0, 0, 0, ''),
(343, 8, 61, 0, 0, 0, 0, ''),
(344, 30, 62, 0, 0, 0, 0, ''),
(345, 1, 63, 0, 0, 0, 0, ''),
(346, 7, 63, 0, 0, 0, 0, ''),
(348, 1, 65, 0, 0, 0, 0, ''),
(349, 3, 65, 0, 0, 0, 0, ''),
(350, 15, 65, 0, 0, 0, 0, ''),
(356, 8, 59, 0, 0, 0, 0, ''),
(357, 10, 59, 0, 0, 0, 0, ''),
(358, 1, 60, 0, 0, 0, 0, ''),
(359, 5, 60, 0, 0, 0, 0, ''),
(360, 7, 60, 0, 0, 0, 0, ''),
(361, 10, 51, 0, 0, 0, 0, ''),
(362, 15, 51, 0, 0, 0, 0, ''),
(363, 33, 51, 0, 0, 0, 0, ''),
(364, 3, 52, 0, 0, 0, 0, ''),
(365, 7, 52, 0, 0, 0, 0, ''),
(366, 3, 57, 0, 0, 0, 0, ''),
(367, 8, 57, 0, 0, 0, 0, ''),
(368, 33, 57, 0, 0, 0, 0, ''),
(370, 1, 58, 0, 0, 0, 0, ''),
(371, 8, 58, 0, 0, 0, 0, ''),
(372, 10, 58, 0, 0, 0, 0, ''),
(376, 5, 69, 0, 0, 0, 0, ''),
(378, 3, 71, 0, 0, 0, 0, ''),
(379, 7, 71, 0, 0, 0, 0, ''),
(380, 8, 71, 0, 0, 0, 0, ''),
(382, 3, 67, 0, 0, 0, 0, ''),
(383, 7, 67, 0, 0, 0, 0, ''),
(384, 15, 68, 0, 0, 0, 0, ''),
(385, 33, 68, 0, 0, 0, 0, ''),
(386, 3, 70, 0, 0, 0, 0, ''),
(387, 15, 70, 0, 0, 0, 0, ''),
(388, 30, 70, 0, 0, 0, 0, ''),
(389, 1, 72, 0, 0, 0, 0, ''),
(390, 5, 72, 0, 0, 0, 0, ''),
(391, 10, 72, 0, 0, 0, 0, ''),
(395, 10, 46, 0, 0, 0, 0, ''),
(396, 15, 46, 0, 0, 0, 0, ''),
(400, 1, 49, 0, 0, 0, 0, ''),
(401, 8, 49, 0, 0, 0, 0, ''),
(402, 1, 48, 0, 0, 0, 0, ''),
(403, 5, 48, 0, 0, 0, 0, ''),
(404, 8, 48, 0, 0, 0, 0, ''),
(405, 3, 64, 0, 0, 0, 0, ''),
(406, 8, 66, 0, 0, 0, 0, ''),
(413, 1, 45, 0, 0, 0, 0, ''),
(414, 5, 45, 0, 0, 0, 0, ''),
(415, 33, 45, 0, 0, 0, 0, '');

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `woobooking_shipping`
--

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

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

--
-- Cấu trúc bảng cho bảng `woobooking_state`
--

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

--
-- Đang đổ dữ liệu cho bảng `woobooking_state`
--

INSERT INTO `woobooking_state` (`id`, `name`, `country_id`, `statecode`, `code`, `published`, `ordering`, `image`) VALUES
(3, 'Antioch', 235, '0', '21', 1, 0, ''),
(4, 'Ha Noi', 242, '0', '', 0, 0, ''),
(5, 'Da Nang', 242, '0', '', 1, 0, ''),
(6, 'New York', 235, '', '', 0, 0, '');

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

--
-- Cấu trúc bảng cho bảng `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Đang đổ dữ liệu cho bảng `woobooking_tag`
--

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

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

--
-- Cấu trúc bảng cho bảng `woobooking_user`
--

CREATE TABLE `woobooking_user` (
  `id` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `birthday` date 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,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Đang đổ dữ liệu cho bảng `woobooking_user`
--

INSERT INTO `woobooking_user` (`id`, `first_name`, `last_name`, `birthday`, `mobile`, `email`, `image`, `description`, `address`, `open_source_user_id`, `company`, `created`, `business`, `published`, `ordering`) VALUES
(1, 'Donald', 'MCkinney', '1992-12-31', 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, NULL, '0000-00-00 00:00:00', 'JUNIOR UI/UX DEVERLOPER', 0, 0),
(2, 'admin_netbase', '', '0000-00-00', 0, 'hiep.v@netbasejsc.com', '', '', '', 32, NULL, '2018-03-23 03:18:36', NULL, 0, 0),
(3, 'admin_netbase', '', '0000-00-00', 0, 'ngoson2910@gmail.com', '', '', '', 1, NULL, '2020-02-07 09:29:10', NULL, 0, 0);

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

--
-- Cấu trúc bảng cho bảng `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;

--
-- Đang đổ dữ liệu cho bảng `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, '');

--
-- Chỉ mục cho các bảng đã đổ
--

--
-- Chỉ mục cho bảng `woobooking_apps`
--
ALTER TABLE `woobooking_apps`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_billing`
--
ALTER TABLE `woobooking_billing`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_block`
--
ALTER TABLE `woobooking_block`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_category`
--
ALTER TABLE `woobooking_category`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_category_tag`
--
ALTER TABLE `woobooking_category_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`category_id`),
  ADD KEY `tag_id` (`tag_id`);

--
-- Chỉ mục cho bảng `woobooking_config`
--
ALTER TABLE `woobooking_config`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_country`
--
ALTER TABLE `woobooking_country`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_customer`
--
ALTER TABLE `woobooking_customer`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_employee`
--
ALTER TABLE `woobooking_employee`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_event`
--
ALTER TABLE `woobooking_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_id` (`service_id`),
  ADD KEY `location_id` (`location_id`);

--
-- Chỉ mục cho bảng `woobooking_event_employee`
--
ALTER TABLE `woobooking_event_employee`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `employee_id` (`employee_id`);

--
-- Chỉ mục cho bảng `woobooking_event_tag`
--
ALTER TABLE `woobooking_event_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `tag_id` (`tag_id`);

--
-- Chỉ mục cho bảng `woobooking_extra`
--
ALTER TABLE `woobooking_extra`
  ADD PRIMARY KEY (`id`),
  ADD KEY `object_id` (`object_id`);

--
-- Chỉ mục cho bảng `woobooking_finance`
--
ALTER TABLE `woobooking_finance`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_gallery`
--
ALTER TABLE `woobooking_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_location`
--
ALTER TABLE `woobooking_location`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_notification`
--
ALTER TABLE `woobooking_notification`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_order`
--
ALTER TABLE `woobooking_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_status_id` (`order_status_id`);

--
-- Chỉ mục cho bảng `woobooking_order_customer`
--
ALTER TABLE `woobooking_order_customer`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `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`);

--
-- Chỉ mục cho bảng `woobooking_order_detail_rate`
--
ALTER TABLE `woobooking_order_detail_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_detail_id` (`order_detail_id`);

--
-- Chỉ mục cho bảng `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`);

--
-- Chỉ mục cho bảng `woobooking_order_package_rate`
--
ALTER TABLE `woobooking_order_package_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `woobooking_order_package_rate` (`order_package_id`);

--
-- Chỉ mục cho bảng `woobooking_order_status`
--
ALTER TABLE `woobooking_order_status`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `id` (`id`);

--
-- Chỉ mục cho bảng `woobooking_package`
--
ALTER TABLE `woobooking_package`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_package_event`
--
ALTER TABLE `woobooking_package_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`event_id`),
  ADD KEY `employee_id` (`package_id`);

--
-- Chỉ mục cho bảng `woobooking_package_tag`
--
ALTER TABLE `woobooking_package_tag`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`package_id`),
  ADD KEY `tag_id` (`tag_id`);

--
-- Chỉ mục cho bảng `woobooking_payment`
--
ALTER TABLE `woobooking_payment`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_rate`
--
ALTER TABLE `woobooking_rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_id` (`object_id`);

--
-- Chỉ mục cho bảng `woobooking_service`
--
ALTER TABLE `woobooking_service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Chỉ mục cho bảng `woobooking_service_employee`
--
ALTER TABLE `woobooking_service_employee`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `event_id` (`employee_id`,`service_id`);

--
-- Chỉ mục cho bảng `woobooking_shipping`
--
ALTER TABLE `woobooking_shipping`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_state`
--
ALTER TABLE `woobooking_state`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_tag`
--
ALTER TABLE `woobooking_tag`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Chỉ mục cho bảng `woobooking_user`
--
ALTER TABLE `woobooking_user`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `woobooking_view`
--
ALTER TABLE `woobooking_view`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- AUTO_INCREMENT cho các bảng đã đổ
--

--
-- AUTO_INCREMENT cho bảng `woobooking_apps`
--
ALTER TABLE `woobooking_apps`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT cho bảng `woobooking_billing`
--
ALTER TABLE `woobooking_billing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT cho bảng `woobooking_block`
--
ALTER TABLE `woobooking_block`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;

--
-- AUTO_INCREMENT cho bảng `woobooking_category`
--
ALTER TABLE `woobooking_category`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT cho bảng `woobooking_category_tag`
--
ALTER TABLE `woobooking_category_tag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT cho bảng `woobooking_country`
--
ALTER TABLE `woobooking_country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT cho bảng `woobooking_customer`
--
ALTER TABLE `woobooking_customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=469;

--
-- AUTO_INCREMENT cho bảng `woobooking_employee`
--
ALTER TABLE `woobooking_employee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT cho bảng `woobooking_event`
--
ALTER TABLE `woobooking_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT cho bảng `woobooking_event_employee`
--
ALTER TABLE `woobooking_event_employee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=618;

--
-- AUTO_INCREMENT cho bảng `woobooking_event_tag`
--
ALTER TABLE `woobooking_event_tag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=474;

--
-- AUTO_INCREMENT cho bảng `woobooking_extra`
--
ALTER TABLE `woobooking_extra`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT cho bảng `woobooking_finance`
--
ALTER TABLE `woobooking_finance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT cho bảng `woobooking_gallery`
--
ALTER TABLE `woobooking_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=681;

--
-- AUTO_INCREMENT cho bảng `woobooking_location`
--
ALTER TABLE `woobooking_location`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT cho bảng `woobooking_notification`
--
ALTER TABLE `woobooking_notification`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT cho bảng `woobooking_order`
--
ALTER TABLE `woobooking_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=432;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_customer`
--
ALTER TABLE `woobooking_order_customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_detail`
--
ALTER TABLE `woobooking_order_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=443;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_detail_rate`
--
ALTER TABLE `woobooking_order_detail_rate`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=581;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_package`
--
ALTER TABLE `woobooking_order_package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_package_rate`
--
ALTER TABLE `woobooking_order_package_rate`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT cho bảng `woobooking_order_status`
--
ALTER TABLE `woobooking_order_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT cho bảng `woobooking_package`
--
ALTER TABLE `woobooking_package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT cho bảng `woobooking_package_event`
--
ALTER TABLE `woobooking_package_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT cho bảng `woobooking_package_tag`
--
ALTER TABLE `woobooking_package_tag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT cho bảng `woobooking_payment`
--
ALTER TABLE `woobooking_payment`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT cho bảng `woobooking_rate`
--
ALTER TABLE `woobooking_rate`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=560;

--
-- AUTO_INCREMENT cho bảng `woobooking_service`
--
ALTER TABLE `woobooking_service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT cho bảng `woobooking_service_employee`
--
ALTER TABLE `woobooking_service_employee`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=416;

--
-- AUTO_INCREMENT cho bảng `woobooking_shipping`
--
ALTER TABLE `woobooking_shipping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT cho bảng `woobooking_state`
--
ALTER TABLE `woobooking_state`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT cho bảng `woobooking_tag`
--
ALTER TABLE `woobooking_tag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT cho bảng `woobooking_user`
--
ALTER TABLE `woobooking_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT cho bảng `woobooking_view`
--
ALTER TABLE `woobooking_view`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- Các ràng buộc cho các bảng đã đổ
--

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `woobooking_order`
--
ALTER TABLE `woobooking_order`
  ADD CONSTRAINT `woobooking_order_ibfk_1` FOREIGN KEY (`order_status_id`) REFERENCES `woobooking_order_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;

--
-- Các ràng buộc cho bảng `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;
COMMIT;

