-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 19, 2020 at 09:11 AM
-- Server version: 5.6.49
-- PHP Version: 7.3.6
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `booking_woobook`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_activity`
--
DROP TABLE IF EXISTS `tbpro_activity`;
CREATE TABLE `tbpro_activity` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_activity`
--
INSERT INTO `tbpro_activity` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Yoga', 'upload/activities/images/cover/44179905_2089403601104706_1795510498272215040_o.jpg', '', 5, 1, 'Yoga with Netbase Team'),
(74, 'Scuba', 'upload/activities/images/cover/image-discover-sea.jpg', '', 0, 1, 'Scuba dive with Netbase Team'),
(75, 'Sight seeing', 'upload/activities/images/cover/H30B7Y0V14249.sightseeing.jpg', '', 0, 1, 'Enjoy the amazing scenery of the area.'),
(76, 'Kayaking', 'upload/activities/images/cover/WnzfEvYNKayaking-2.jpg', '', 0, 1, 'Use kayak for moving across water. ... A kayak is a low-to-the-water, canoe-like boat in which the paddler sits facing forward, legs in front, using a double-bladed paddle to pull front-to-back on one side and then the other in rotation.'),
(77, 'Relaxing', 'upload/activities/images/cover/LvHsD43Gmaxresdefault.jpg', '', 0, 1, ''),
(78, 'Walking', 'upload/activities/images/cover/nSbgtj8vfree-walking-tours_1.jpg', '', 0, 1, ''),
(79, 'experience', 'upload/activities/images/cover/vCnHYYcWtour-di-3-gg-marrakech.jpg', '', 0, 1, 'experience new things to make your life more colourful'),
(80, 'Explore cuisines', 'upload/activities/images/cover/fdmteO93download.jpg', '', 0, 1, 'explore different cuisines');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_apps`
--
DROP TABLE IF EXISTS `tbpro_apps`;
CREATE TABLE `tbpro_apps` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_apps`
--
INSERT INTO `tbpro_apps` (`id`, `name`, `alias`, `ordering`, `description`) VALUES
(1, 'woobooking', 'woobooking', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_billing`
--
DROP TABLE IF EXISTS `tbpro_billing`;
CREATE TABLE `tbpro_billing` (
`id` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`email` varchar(50) NOT NULL,
`first_name` varchar(50) NOT NULL,
`company` varchar(255) NOT NULL,
`country` varchar(50) NOT NULL,
`address_1` varchar(255) NOT NULL,
`address_2` varchar(255) NOT NULL,
`postcode` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`title` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_billing`
--
INSERT INTO `tbpro_billing` (`id`, `ordering`, `order_id`, `email`, `first_name`, `company`, `country`, `address_1`, `address_2`, `postcode`, `city`, `state`, `phone`, `title`, `alias`, `data`) VALUES
(4, 0, 8, 'nguyendinhcuong@gmail.com', 'sdfds', 'sdfsdfds', 'VN', 'sdfdsfdsf', '', '34334', 'ssdf', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_block`
--
DROP TABLE IF EXISTS `tbpro_block`;
CREATE TABLE `tbpro_block` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`open_source_client_id` varchar(255) NOT NULL,
`type` varchar(50) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`description` text NOT NULL,
`params` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_block`
--
INSERT INTO `tbpro_block` (`id`, `name`, `open_source_client_id`, `type`, `alias`, `ordering`, `description`, `params`) VALUES
(1, '', '', 'service-list', '', 0, '', ''),
(2, '', '', 'service-list', '', 0, '', ''),
(3, '', '', 'service-list', '', 0, '', ''),
(4, '', '', 'service-list', '', 0, '', ''),
(5, '', '', 'service-list', '', 0, '', ''),
(6, '', '', 'service-list', '', 0, '', ''),
(7, '', '', 'service-list', '', 0, '', ''),
(8, '', '', 'service-list', '', 0, '', ''),
(9, '', '', 'service-list', '', 0, '', ''),
(10, '', '', 'service-list', '', 0, '', ''),
(11, '', '', 'service-list', '', 0, '', ''),
(12, '', '', 'service-list', '', 0, '', ''),
(13, '', '', 'service-list', '', 0, '', ''),
(14, '', '', 'service-list', '', 0, '', ''),
(15, '', '', 'service-list', '', 0, '', ''),
(16, '', '', '', '', 0, '', ''),
(17, '', '', 'service-list', '', 0, '', ''),
(18, '', '', 'service-list', '', 0, '', '{\"category_id\":\"33\"}'),
(19, '', '', 'service-list', '', 0, '', '{\"category_id\":\"33\"}'),
(20, '', '', 'service-list', '', 0, '', '{\"category_id\":\"37\"}'),
(21, '', '', 'service-list', '', 0, '', '{\"category_id\":\"32\"}'),
(22, '', '', 'event-list', '', 0, '', ''),
(23, '', '', 'service-list', '', 0, '', '{\"category_id\":\"32\"}'),
(24, '', '', 'woobooking-employee-list', '', 0, '', ''),
(25, '', '', 'woobooking-employee-list', '', 0, '', ''),
(26, '', '', 'woobooking-employee-list', '', 0, '', ''),
(27, '', '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"32\"}'),
(28, '', '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"32\"}'),
(29, '', '', 'woobooking-appointment-default', '', 0, '', ''),
(30, '', '', 'woobooking-employee-list', '', 0, '', ''),
(31, '', '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"20\"}'),
(32, '', '', 'woobooking-category-list', '', 0, '', ''),
(33, '', '', '', '', 0, '', '{\"category_id\":\"20\"}'),
(34, '', '', 'woobooking-service-list', '', 0, '', ''),
(35, '', '', 'woobooking-service-list', '', 0, '', ''),
(36, '', '', 'woobooking-service-list', '', 0, '', ''),
(37, '', '', 'woobooking-service-list', '', 0, '', ''),
(38, '', '', 'woobooking-service-list', '', 0, '', ''),
(39, '', '', 'woobooking-service-list', '', 0, '', ''),
(40, '', '', 'woobooking-service-list', '', 0, '', ''),
(41, '', '', 'woobooking-service-list', '', 0, '', ''),
(42, '', '', 'woobooking-service-list', '', 0, '', ''),
(43, '', '', 'woobooking-service-list', '', 0, '', ''),
(44, '', '', 'woobooking-service-list', '', 0, '', ''),
(45, '', '', 'woobooking-service-list', '', 0, '', ''),
(46, '', '', 'woobooking-service-list', '', 0, '', ''),
(47, '', '', 'woobooking-category-list', '', 0, '', ''),
(48, '', '', 'woobooking-service-list', '', 0, '', ''),
(49, '', '', 'woobooking-service-list', '', 0, '', ''),
(50, '', '', 'woobooking-service-list', '', 0, '', ''),
(51, '', '', 'woobooking-service-list', '', 0, '', ''),
(52, '', '', 'woobooking-service-list', '', 0, '', ''),
(53, '', '', 'woobooking-service-list', '', 0, '', ''),
(54, '', '', 'woobooking-service-list', '', 0, '', ''),
(55, '', '', '', '', 0, '', '{\"category_id\":\"20\"}'),
(56, '', '', 'woobooking-service-list', '', 0, '', ''),
(57, '', '', 'woobooking-service-list', '', 0, '', ''),
(58, '', '', 'woobooking-service-list', '', 0, '', ''),
(59, '', '', 'woobooking-service-list', '', 0, '', ''),
(60, '', '', 'woobooking-service-list', '', 0, '', ''),
(61, '', '', 'woobooking-service-list', '', 0, '', ''),
(62, '', '', 'woobooking-service-list', '', 0, '', ''),
(63, '', '', 'woobooking-service-list', '', 0, '', ''),
(64, '', '', 'woobooking-service-list', '', 0, '', ''),
(65, '', '', 'woobooking-service-list', '', 0, '', '{\"category_id\":\"20\"}'),
(66, '', '', 'woobooking-category-list', '', 0, '', ''),
(67, '', '', 'woobooking-category-list', '', 0, '', ''),
(68, '', '', 'woobooking-category-list', '', 0, '', ''),
(69, '', '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}'),
(70, '', '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}'),
(71, '', '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"home_page\"}'),
(72, '', '', 'woobooking-category-list', '', 0, '', ''),
(73, '', '', 'woobooking-category-list', '', 0, '', ''),
(74, '', '', 'woobooking-category-list', '', 0, '', ''),
(75, '', '', 'woobooking-category-list', '', 0, '', ''),
(76, '', '', 'woobooking-category-list', '', 0, '', ''),
(77, '', '', 'woobooking-category-list', '', 0, '', ''),
(78, '', '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"list_home_page\"}'),
(79, '', '', 'woobooking-classtimeable-default', '', 0, '', ''),
(80, '', '', 'woobooking-classtimeable-default', '', 0, '', ''),
(81, '', '', 'woobooking-classtimeable-default', '', 0, '', ''),
(82, '', '', 'woobooking-block-classtimeable-default', '', 0, '', ''),
(83, '', '', 'woobooking-block-classtimeable-default', '', 0, '', ''),
(84, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(85, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(86, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(87, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(88, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(89, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(90, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(91, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(92, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(93, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(94, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(95, '', '', 'woobooking-block-classtimeable', '', 0, '', '{\"category_id\":\"20\"}'),
(96, '', '', 'woobooking-block-classtimeable', '', 0, '', '{\"category_id\":\"22\"}'),
(97, '', '', 'woobooking-block-block_classtimeable', '', 0, '', ''),
(98, '', '', 'woobooking-block-block_classtimeable', '', 0, '', ''),
(99, 'sdfdsfds', '', 'woobooking-block-classtimeable', '', 0, '', 'null'),
(100, '', '', 'woobooking-booking-training', '', 0, '', ''),
(101, '', '', 'woobooking-category-list', '', 0, '', '{\"children_layout\":\"list_home_page\"}'),
(102, 'Table time', '', 'woobooking-block-classtimeable', '', 0, '', 'null'),
(103, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(104, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(105, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}'),
(106, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"category_id\":\"\",\"layout\":\"page_service_package_plan\"}'),
(107, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(108, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"category_id\":\"\",\"layout\":\"page_service_package_plan\"}'),
(109, '', '', 'woobooking-block-meetourcoachs', '', 0, '', ''),
(110, '', '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"15\",\"16\"],\"layout\":\"default\"}'),
(111, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(112, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(113, '', '', 'woobooking-block-categoryimage', '', 0, '', ''),
(114, '', '', 'woobooking-block-categoryimage', '', 0, '', ''),
(115, '', '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"20\",\"21\",\"22\",\"23\",\"46\"],\"layout\":\"default\"}'),
(116, '', '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"68\",\"23\",\"22\",\"21\",\"20\"],\"layout\":\"default\"}'),
(117, '', '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"20\",\"21\",\"22\",\"23\",\"46\"],\"layout\":\"default\"}'),
(118, '', '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"17\"],\"layout\":\"default\"}'),
(119, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"5\"],\"layout\":\"default\"}'),
(120, '', '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"15\"],\"layout\":\"default\"}'),
(121, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(122, '', '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"67\",\"20\",\"21\",\"22\",\"23\"],\"layout\":\"default\"}'),
(123, '', '', 'woobooking-block-galleryblock', '', 0, '', '{\"gallery_id\":[\"\"],\"layout\":\"default\"}'),
(124, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(125, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(126, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(127, '', '', 'woobooking-block-galleryblock', '', 0, '', '{\"gallery_id\":[\"\"],\"layout\":\"default\"}'),
(128, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(129, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(130, '', '', 'woobooking-block-galleryblock', '', 0, '', '{\"service_id\":[\"45\",\"46\",\"47\",\"48\",\"49\",\"50\",\"51\",\"52\",\"57\"],\"layout\":\"default\"}'),
(131, '', '', 'woobooking-order-list', '', 0, '', ''),
(132, '', '', 'woobooking-account-list', '', 0, '', ''),
(133, '', '', 'woobooking-block-bookingtraining', '', 0, '', '{\"service_id\":[\"45\"],\"layout\":\"default\"}'),
(134, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(135, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(136, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(137, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(138, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(139, '', '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}'),
(140, 'block', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(141, 'hfhfhf', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(142, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(143, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(144, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}'),
(145, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(146, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(147, '', '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}'),
(148, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}'),
(149, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(150, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(151, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(152, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(153, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(154, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(155, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(156, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"blocks\\/block_location\\/assets\\/images\\/img2.png\",\"link_1\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=20\",\"text_1\":\"HO CHI MINH\",\"path_image2\":\"blocks\\/block_location\\/assets\\/images\\/img3.png\",\"link_2\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=21\",\"text_2\":\"DA NANG\",\"path_image3\":\"blocks\\/block_location\\/assets\\/images\\/img4.png\",\"link_3\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=22\",\"text_3\":\"HA NOI\"}'),
(157, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"blocks\\/block_location\\/assets\\/images\\/img2.png\",\"link_1\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=20\",\"text_1\":\"HO CHI MINH\",\"path_image2\":\"blocks\\/block_location\\/assets\\/images\\/img3.png\",\"link_2\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=21\",\"text_2\":\"DA NANG\",\"path_image3\":\"blocks\\/block_location\\/assets\\/images\\/img4.png\",\"link_3\":\"http:\\/\\/45.119.84.18\\/~wbkfitnes\\/woobooking-service-list\\/?category_id=22\",\"text_3\":\"HA NOI\"}'),
(158, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(159, 'block search', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(160, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"\",\"link_1\":\"\",\"text_1\":\"\",\"path_image2\":\"\",\"link_2\":\"\",\"text_2\":\"\",\"path_image3\":\"\",\"link_3\":\"\",\"text_3\":\"\"}'),
(161, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"path_image1\":\"\",\"link_1\":\"\",\"text_1\":\"\",\"path_image2\":\"\",\"link_2\":\"\",\"text_2\":\"\",\"path_image3\":\"\",\"link_3\":\"\",\"text_3\":\"\"}'),
(162, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}'),
(163, '', '', 'woobooking-block-searchmenu', '', 0, '', ''),
(164, '', '', 'woobooking-block-searchmenu', '', 0, '', ''),
(165, '', '', 'woobooking-block-listevent', '', 0, '', ''),
(166, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(167, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(168, '', '', 'woobooking-block-bookingtraining', '', 0, '', ''),
(169, '', '', 'woobooking-block-categoryimage', '', 0, '', ''),
(170, '', '', 'woobooking-block-meetourcoachs', '', 0, '', ''),
(171, '', '', 'woobooking-block-classtimeable', '', 0, '', ''),
(172, '', '', 'woobooking-block-galleryblock', '', 0, '', ''),
(173, '', '', 'woobooking-block-location', '', 0, '', ''),
(174, '', '', 'woobooking-block-listevent', '', 0, '', ''),
(175, '', '', 'woobooking-block-priceplanclass', '', 0, '', ''),
(176, '', '', 'woobooking-block-searchmenu', '', 0, '', ''),
(177, '', '', 'woobooking-block-searchmenu', '', 0, '', '{\"layout\":\"default\"}'),
(178, '', '', 'woobooking-block-listevent', '', 0, '', ''),
(179, '', '', 'woobooking-block-listevent', '', 0, '', '{\"layout\":\"default\"}'),
(180, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"layout\":\"default\"}'),
(181, '', '', 'woobooking-block-priceplanclass', '', 0, '', '{\"list_package_id\":[\"2\",\"3\",\"4\"],\"layout\":\"default\"}'),
(182, '', '', 'woobooking-block-bookingtraining', '', 0, '', '{\"layout\":\"default\"}'),
(183, '', '', 'woobooking-block-categoryimage', '', 0, '', '{\"category_id\":[\"70\",\"68\",\"23\",\"22\",\"21\",\"20\"],\"layout\":\"default\"}'),
(184, '', '', 'woobooking-block-meetourcoachs', '', 0, '', '{\"employee_id\":[\"1\",\"3\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"15\"],\"layout\":\"default\"}'),
(185, '', '', 'woobooking-block-galleryblock', '', 0, '', '{\"service_id\":[\"45\",\"46\",\"47\",\"48\",\"49\",\"50\",\"51\",\"52\",\"57\",\"58\",\"59\"],\"layout\":\"default\"}'),
(186, '', '', 'woobooking-block-location', '', 0, '', '{\"layout\":\"default\",\"locations\":[\"3\",\"4\",\"5\"]}'),
(187, '', '5e2b1320-1b2b-4418-9cc8-bafd59f44b94', 'listevent', '', 0, '', ''),
(188, '', '6ed1debf-52e5-484b-94e0-646b0f99aa26', 'priceplanclass', '', 0, '', ''),
(189, '', '6035d154-ab95-4434-93a3-16f73c48c3d7', 'classtimeable', '', 0, '', ''),
(190, '', 'e4cbb3b7-3cd2-4cdf-a758-8881fb4ccf06', 'location', '', 0, '', ''),
(191, '', '92bb37e0-465e-48f9-beb4-750bff1acc76', 'meetourcoachs', '', 0, '', '{\"employee_id\":[\"3\",\"5\",\"6\",\"7\",\"8\"],\"layout\":\"default\"}'),
(192, '', 'c5cf6fb5-7d9c-49dd-b7cf-b04ebfe34dd7', 'searchmenu', '', 0, '', ''),
(193, '', '8c046af6-479d-4583-8a3d-43e7a26f43fb', 'listevent', '', 0, '', ''),
(194, '', '325560eb-95c0-4b43-86e2-b7de8d9712b2', 'meetourcoachs', '', 0, '', ''),
(195, '', 'ffc2957c-1d1f-45f8-9e4e-349550a2a4ad', 'categories', '', 0, '', ''),
(196, '', '16fb29b', 'list_destination', '', 0, '', ''),
(197, '', '7267395', 'categories', '', 0, '', ''),
(198, '', '53bea49', 'categories', '', 0, '', ''),
(199, '', '3f4138c', 'list_activities', '', 0, '', ''),
(200, '', 'dd8776d', 'tour_destination', '', 0, '', ''),
(201, '', '476647a', 'list_activities', '', 0, '', ''),
(202, '', '38daf54', 'search_tour', '', 0, '', ''),
(203, '', '93fdaeb', 'top_activities', '', 0, '', ''),
(204, '', '23d06a0', 'tour_popular_in_month', '', 0, '', ''),
(205, '', 'd43e437', 'list_destination', '', 0, '', ''),
(206, '', '9a217b2', 'list_activities', '', 0, '', ''),
(207, '', 'a967e98', 'tour_destination', '', 0, '', '{}'),
(208, '', '91a6bf2', 'recent_articles', '', 0, '', '{}'),
(209, '', '3e8961f', 'recent_articles', '', 0, '', '{}'),
(210, '', '09d9ecb', 'recent_articles', '', 0, '', '{}'),
(211, '', '409d930', 'top_activity', '', 0, '', '{}'),
(212, '', '27edc28', 'tour_popular_in_month', '', 0, '', '{}'),
(213, '', 'be31991', 'tour_destination', '', 0, '', '{}'),
(214, '', '9d855fc', 'search_tour', '', 0, '', '{}');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_cart`
--
DROP TABLE IF EXISTS `tbpro_cart`;
CREATE TABLE `tbpro_cart` (
`id` int(11) NOT NULL,
`session_id` varchar(50) NOT NULL,
`service_id` int(11) NOT NULL,
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`country_code` varchar(20) NOT NULL,
`email` varchar(50) NOT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`open_source_link_id` int(11) NOT NULL,
`location_id` int(11) NOT NULL,
`type` varchar(30) NOT NULL,
`employee_id` int(11) NOT NULL,
`extra_id` int(11) NOT NULL,
`price` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`rate_id` int(11) NOT NULL,
`params` mediumtext NOT NULL,
`quantity` int(11) NOT NULL,
`subtotal` float NOT NULL,
`total` float NOT NULL,
`total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_category`
--
DROP TABLE IF EXISTS `tbpro_category`;
CREATE TABLE `tbpro_category` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_category`
--
INSERT INTO `tbpro_category` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Yoga', 'upload/employees/images/cover/12 Dec 199028 Jan 1989anh13-d.jpg', '', 5, 1, ''),
(21, 'Cardio', 'upload/services/images/image-cover-UsfbDi7H-anh2.jpg', '', 9, 0, ''),
(22, 'Combat Sports', 'upload/services/images/image-cover-VYEUjPNq-anh3.jpg', '', 10, 1, ''),
(23, 'Bodybuilding', 'upload/services/images/image-cover-L0T85YOJ-anh4.jpg', '', 11, 1, ''),
(70, 'Radiant1', 'upload/employees/images/cover/12 Mar 1978961fd3a4-sap-xep-cong-viec-khoa-hoc-6.png', '', 0, 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_category_tag`
--
DROP TABLE IF EXISTS `tbpro_category_tag`;
CREATE TABLE `tbpro_category_tag` (
`id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_config`
--
DROP TABLE IF EXISTS `tbpro_config`;
CREATE TABLE `tbpro_config` (
`id` int(11) NOT NULL,
`title` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`params` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_config`
--
INSERT INTO `tbpro_config` (`id`, `title`, `alias`, `params`) VALUES
(1, 'title1', 'title1', '{\"page_tour_detail\":187,\"page_tour_checkout\":189,\"page_list_tour\":\"5\",\"page_list_tour_search_result\":\"167\"}');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_country`
--
DROP TABLE IF EXISTS `tbpro_country`;
CREATE TABLE `tbpro_country` (
`id` int(11) NOT NULL,
`countrycode` char(3) NOT NULL,
`countryname` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`code` char(2) DEFAULT NULL,
`phonecode` int(5) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_country`
--
INSERT INTO `tbpro_country` (`id`, `countrycode`, `countryname`, `image`, `code`, `phonecode`, `ordering`, `published`) VALUES
(1, 'ABW', 'Aruba', 'admin/resources/flags/aw.png', 'AW', 297, 0, 0),
(2, 'AFG', 'Afghanistan', 'admin/resources/flags/af.png', 'AF', 93, 0, 0),
(3, 'AGO', 'Angola', 'admin/resources/flags/ao.png', 'AO', 244, 0, 0),
(4, 'AIA', 'Anguilla', 'admin/resources/flags/ai.png', 'AI', 1264, 0, 0),
(5, 'ALA', 'Åland', 'admin/resources/flags/ax.png', 'AX', 358, 0, 0),
(6, 'ALB', 'Albania', 'admin/resources/flags/al.png', 'AL', 355, 0, 0),
(7, 'AND', 'Andorra', 'admin/resources/flags/ad.png', 'AD', 376, 0, 0),
(8, 'ARE', 'United Arab Emirates', 'admin/resources/flags/ae.png', 'AE', 971, 0, 0),
(9, 'ARG', 'Argentina', 'admin/resources/flags/ar.png', 'AR', 54, 0, 0),
(10, 'ARM', 'Armenia', 'admin/resources/flags/am.png', 'AM', 374, 0, 0),
(11, 'ASM', 'American Samoa', 'admin/resources/flags/as.png', 'AS', 1684, 0, 0),
(12, 'ATA', 'Antarctica', 'admin/resources/flags/aq.png', 'AQ', 0, 0, 0),
(13, 'ATF', 'French Southern Territories', 'admin/resources/flags/tf.png', 'TF', 0, 0, 0),
(14, 'ATG', 'Antigua and Barbuda', 'admin/resources/flags/ag.png', 'AG', 1268, 0, 0),
(15, 'AUS', 'Australia', 'admin/resources/flags/au.png', 'AU', 61, 0, 0),
(16, 'AUT', 'Austria', 'admin/resources/flags/at.png', 'AT', 43, 0, 0),
(17, 'AZE', 'Azerbaijan', 'admin/resources/flags/az.png', 'AZ', 994, 0, 0),
(18, 'BDI', 'Burundi', 'admin/resources/flags/bi.png', 'BI', 257, 0, 0),
(19, 'BEL', 'Belgium', 'admin/resources/flags/be.png', 'BE', 32, 0, 0),
(20, 'BEN', 'Benin', 'admin/resources/flags/bj.png', 'BJ', 229, 0, 0),
(21, 'BES', 'Bonaire', 'admin/resources/flags/bq.png', 'BQ', 599, 0, 0),
(22, 'BFA', 'Burkina Faso', 'admin/resources/flags/bf.png', 'BF', 226, 0, 0),
(23, 'BGD', 'Bangladesh', 'admin/resources/flags/bd.png', 'BD', 880, 0, 0),
(24, 'BGR', 'Bulgaria', 'admin/resources/flags/bg.png', 'BG', 359, 0, 0),
(25, 'BHR', 'Bahrain', 'admin/resources/flags/bh.png', 'BH', 973, 0, 0),
(26, 'BHS', 'Bahamas', 'admin/resources/flags/bs.png', 'BS', 1242, 0, 0),
(27, 'BIH', 'Bosnia and Herzegovina', 'admin/resources/flags/ba.png', 'BA', 387, 0, 0),
(28, 'BLM', 'Saint Barthélemy', 'admin/resources/flags/bl.png', 'BL', 590, 0, 0),
(29, 'BLR', 'Belarus', 'admin/resources/flags/by.png', 'BY', 375, 0, 0),
(30, 'BLZ', 'Belize', 'admin/resources/flags/bz.png', 'BZ', 501, 0, 0),
(31, 'BMU', 'Bermuda', 'admin/resources/flags/bm.png', 'BM', 1441, 0, 0),
(32, 'BOL', 'Bolivia', 'admin/resources/flags/bo.png', 'BO', 591, 0, 0),
(33, 'BRA', 'Brazil', 'admin/resources/flags/br.png', 'BR', 55, 0, 0),
(34, 'BRB', 'Barbados', 'admin/resources/flags/bb.png', 'BB', 1246, 0, 0),
(35, 'BRN', 'Brunei', 'admin/resources/flags/bn.png', 'BN', 673, 0, 0),
(36, 'BTN', 'Bhutan', 'admin/resources/flags/bt.png', 'BT', 975, 0, 0),
(37, 'BVT', 'Bouvet Island', 'admin/resources/flags/bv.png', 'BV', 0, 0, 0),
(38, 'BWA', 'Botswana', 'admin/resources/flags/bw.png', 'BW', 267, 0, 0),
(39, 'CAF', 'Central African Republic', 'admin/resources/flags/cf.png', 'CF', 236, 0, 0),
(40, 'CAN', 'Canada', 'admin/resources/flags/ca.png', 'CA', 1, 0, 0),
(41, 'CCK', 'Cocos [Keeling] Islands', 'admin/resources/flags/cc.png', 'CC', 672, 0, 0),
(42, 'CHE', 'Switzerland', 'admin/resources/flags/ch.png', 'CH', 41, 0, 0),
(43, 'CHL', 'Chile', 'admin/resources/flags/cl.png', 'CL', 56, 0, 0),
(44, 'CHN', 'China', 'admin/resources/flags/cn.png', 'CN', 86, 0, 0),
(45, 'CIV', 'Ivory Coast', 'admin/resources/flags/ci.png', 'CI', 225, 0, 0),
(46, 'CMR', 'Cameroon', 'admin/resources/flags/cm.png', 'CM', 237, 0, 0),
(47, 'COD', 'Democratic Republic of the Congo', 'admin/resources/flags/cd.png', 'CD', 242, 0, 0),
(48, 'COG', 'Republic of the Congo', 'admin/resources/flags/cg.png', 'CG', 242, 0, 0),
(49, 'COK', 'Cook Islands', 'admin/resources/flags/ck.png', 'CK', 682, 0, 0),
(50, 'COL', 'Colombia', 'admin/resources/flags/co.png', 'CO', 57, 0, 0),
(51, 'COM', 'Comoros', 'admin/resources/flags/km.png', 'KM', 269, 0, 0),
(52, 'CPV', 'Cape Verde', 'admin/resources/flags/cv.png', 'CV', 238, 0, 0),
(53, 'CRI', 'Costa Rica', 'admin/resources/flags/cr.png', 'CR', 506, 0, 0),
(54, 'CUB', 'Cuba', 'admin/resources/flags/cu.png', 'CU', 53, 0, 0),
(55, 'CUW', 'Curacao', 'admin/resources/flags/cw.png', 'CW', 599, 0, 0),
(56, 'CXR', 'Christmas Island', 'admin/resources/flags/cx.png', 'CX', 61, 0, 0),
(57, 'CYM', 'Cayman Islands', 'admin/resources/flags/ky.png', 'KY', 1345, 0, 0),
(58, 'CYP', 'Cyprus', 'admin/resources/flags/cy.png', 'CY', 357, 0, 0),
(59, 'CZE', 'Czech Republic', 'admin/resources/flags/cz.png', 'CZ', 420, 0, 0),
(60, 'DEU', 'Germany', 'admin/resources/flags/de.png', 'DE', 49, 0, 0),
(61, 'DJI', 'Djibouti', 'admin/resources/flags/dj.png', 'DJ', 253, 0, 0),
(62, 'DMA', 'Dominica', 'admin/resources/flags/dm.png', 'DM', 1767, 0, 0),
(63, 'DNK', 'Denmark', 'admin/resources/flags/dk.png', 'DK', 45, 0, 0),
(64, 'DOM', 'Dominican Republic', 'admin/resources/flags/do.png', 'DO', 1809, 0, 0),
(65, 'DZA', 'Algeria', 'admin/resources/flags/dz.png', 'DZ', 213, 0, 0),
(66, 'ECU', 'Ecuador', 'admin/resources/flags/ec.png', 'EC', 593, 0, 0),
(67, 'EGY', 'Egypt', 'admin/resources/flags/eg.png', 'EG', 20, 0, 0),
(68, 'ERI', 'Eritrea', 'admin/resources/flags/er.png', 'ER', 291, 0, 0),
(69, 'ESH', 'Western Sahara', 'admin/resources/flags/eh.png', 'EH', 212, 0, 0),
(70, 'ESP', 'Spain', 'admin/resources/flags/es.png', 'ES', 34, 0, 0),
(71, 'EST', 'Estonia', 'admin/resources/flags/ee.png', 'EE', 372, 0, 0),
(72, 'ETH', 'Ethiopia', 'admin/resources/flags/et.png', 'ET', 251, 0, 0),
(73, 'FIN', 'Finland', 'admin/resources/flags/fi.png', 'FI', 358, 0, 0),
(74, 'FJI', 'Fiji', 'admin/resources/flags/fj.png', 'FJ', 679, 0, 0),
(75, 'FLK', 'Falkland Islands', 'admin/resources/flags/fk.png', 'FK', 500, 0, 0),
(76, 'FRA', 'France', 'admin/resources/flags/fr.png', 'FR', 33, 0, 0),
(77, 'FRO', 'Faroe Islands', 'admin/resources/flags/fo.png', 'FO', 298, 0, 0),
(78, 'FSM', 'Micronesia', 'admin/resources/flags/fm.png', 'FM', 691, 0, 0),
(79, 'GAB', 'Gabon', 'admin/resources/flags/ga.png', 'GA', 241, 0, 0),
(80, 'GBR', 'United Kingdom', 'admin/resources/flags/gb.png', 'GB', 44, 0, 0),
(81, 'GEO', 'Georgia', 'admin/resources/flags/ge.png', 'GE', 995, 0, 0),
(82, 'GGY', 'Guernsey', 'admin/resources/flags/gg.png', 'GG', 44, 0, 0),
(83, 'GHA', 'Ghana', 'admin/resources/flags/gh.png', 'GH', 233, 0, 0),
(84, 'GIB', 'Gibraltar', 'admin/resources/flags/gi.png', 'GI', 350, 0, 0),
(85, 'GIN', 'Guinea', 'admin/resources/flags/gn.png', 'GN', 224, 0, 0),
(86, 'GLP', 'Guadeloupe', 'admin/resources/flags/gp.png', 'GP', 590, 0, 0),
(87, 'GMB', 'Gambia', 'admin/resources/flags/gm.png', 'GM', 220, 0, 0),
(88, 'GNB', 'Guinea-Bissau', 'admin/resources/flags/gw.png', 'GW', 245, 0, 0),
(89, 'GNQ', 'Equatorial Guinea', 'admin/resources/flags/gq.png', 'GQ', 240, 0, 0),
(90, 'GRC', 'Greece', 'admin/resources/flags/gr.png', 'GR', 30, 0, 0),
(91, 'GRD', 'Grenada', 'admin/resources/flags/gd.png', 'GD', 1473, 0, 0),
(92, 'GRL', 'Greenland', 'admin/resources/flags/gl.png', 'GL', 299, 0, 0),
(93, 'GTM', 'Guatemala', 'admin/resources/flags/gt.png', 'GT', 502, 0, 0),
(94, 'GUF', 'French Guiana', 'admin/resources/flags/gf.png', 'GF', 594, 0, 0),
(95, 'GUM', 'Guam', 'admin/resources/flags/gu.png', 'GU', 1671, 0, 0),
(96, 'GUY', 'Guyana', 'admin/resources/flags/gy.png', 'GY', 592, 0, 0),
(97, 'HKG', 'Hong Kong', 'admin/resources/flags/hk.png', 'HK', 852, 0, 0),
(98, 'HMD', 'Heard Island and McDonald Islands', 'admin/resources/flags/hm.png', 'HM', 0, 0, 0),
(99, 'HND', 'Honduras', 'admin/resources/flags/hn.png', 'HN', 504, 0, 0),
(100, 'HRV', 'Croatia', 'admin/resources/flags/hr.png', 'HR', 385, 0, 0),
(101, 'HTI', 'Haiti', 'admin/resources/flags/ht.png', 'HT', 509, 0, 0),
(102, 'HUN', 'Hungary', 'admin/resources/flags/hu.png', 'HU', 36, 0, 0),
(103, 'IDN', 'Indonesia', 'admin/resources/flags/id.png', 'ID', 62, 0, 0),
(104, 'IMN', 'Isle of Man', 'admin/resources/flags/im.png', 'IM', 44, 0, 0),
(105, 'IND', 'India', 'admin/resources/flags/in.png', 'IN', 91, 0, 0),
(106, 'IOT', 'British Indian Ocean Territory', 'admin/resources/flags/io.png', 'IO', 246, 0, 0),
(107, 'IRL', 'Ireland', 'admin/resources/flags/ie.png', 'IE', 353, 0, 0),
(108, 'IRN', 'Iran', 'admin/resources/flags/ir.png', 'IR', 98, 0, 0),
(109, 'IRQ', 'Iraq', 'admin/resources/flags/iq.png', 'IQ', 964, 0, 0),
(110, 'ISL', 'Iceland', 'admin/resources/flags/is.png', 'IS', 354, 0, 0),
(111, 'ISR', 'Israel', 'admin/resources/flags/il.png', 'IL', 972, 0, 0),
(112, 'ITA', 'Italy', 'admin/resources/flags/it.png', 'IT', 39, 0, 0),
(113, 'JAM', 'Jamaica', 'admin/resources/flags/jm.png', 'JM', 1876, 0, 0),
(114, 'JEY', 'Jersey', 'admin/resources/flags/je.png', 'JE', 44, 0, 0),
(115, 'JOR', 'Jordan', 'admin/resources/flags/jo.png', 'JO', 962, 0, 0),
(116, 'JPN', 'Japan', 'admin/resources/flags/jp.png', 'JP', 81, 0, 0),
(117, 'KAZ', 'Kazakhstan', 'admin/resources/flags/kz.png', 'KZ', 7, 0, 0),
(118, 'KEN', 'Kenya', 'admin/resources/flags/ke.png', 'KE', 254, 0, 0),
(119, 'KGZ', 'Kyrgyzstan', 'admin/resources/flags/kg.png', 'KG', 996, 0, 0),
(120, 'KHM', 'Cambodia', 'admin/resources/flags/kh.png', 'KH', 855, 0, 0),
(121, 'KIR', 'Kiribati', 'admin/resources/flags/ki.png', 'KI', 686, 0, 0),
(122, 'KNA', 'Saint Kitts and Nevis', 'admin/resources/flags/kn.png', 'KN', 1869, 0, 0),
(123, 'KOR', 'South Korea', 'admin/resources/flags/kr.png', 'KR', 82, 0, 0),
(124, 'KWT', 'Kuwait', 'admin/resources/flags/kw.png', 'KW', 965, 0, 0),
(125, 'LAO', 'Laos', 'admin/resources/flags/la.png', 'LA', 856, 0, 0),
(126, 'LBN', 'Lebanon', 'admin/resources/flags/lb.png', 'LB', 961, 0, 0),
(127, 'LBR', 'Liberia', 'admin/resources/flags/lr.png', 'LR', 231, 0, 0),
(128, 'LBY', 'Libya', 'admin/resources/flags/ly.png', 'LY', 218, 0, 0),
(129, 'LCA', 'Saint Lucia', 'admin/resources/flags/lc.png', 'LC', 1758, 0, 0),
(130, 'LIE', 'Liechtenstein', 'admin/resources/flags/li.png', 'LI', 423, 0, 0),
(131, 'LKA', 'Sri Lanka', 'admin/resources/flags/lk.png', 'LK', 94, 0, 0),
(132, 'LSO', 'Lesotho', 'admin/resources/flags/ls.png', 'LS', 266, 0, 0),
(133, 'LTU', 'Lithuania', 'admin/resources/flags/lt.png', 'LT', 370, 0, 0),
(134, 'LUX', 'Luxembourg', 'admin/resources/flags/lu.png', 'LU', 352, 0, 0),
(135, 'LVA', 'Latvia', 'admin/resources/flags/lv.png', 'LV', 371, 0, 0),
(136, 'MAC', 'Macao', 'admin/resources/flags/mo.png', 'MO', 853, 0, 0),
(137, 'MAF', 'Saint Martin', 'admin/resources/flags/mf.png', 'MF', 590, 0, 0),
(138, 'MAR', 'Morocco', 'admin/resources/flags/ma.png', 'MA', 212, 0, 0),
(139, 'MCO', 'Monaco', 'admin/resources/flags/mc.png', 'MC', 377, 0, 0),
(140, 'MDA', 'Moldova', 'admin/resources/flags/md.png', 'MD', 373, 0, 0),
(141, 'MDG', 'Madagascar', 'admin/resources/flags/mg.png', 'MG', 261, 0, 0),
(142, 'MDV', 'Maldives', 'admin/resources/flags/mv.png', 'MV', 960, 0, 0),
(143, 'MEX', 'Mexico', 'admin/resources/flags/mx.png', 'MX', 52, 0, 0),
(144, 'MHL', 'Marshall Islands', 'admin/resources/flags/mh.png', 'MH', 692, 0, 0),
(145, 'MKD', 'Macedonia', 'admin/resources/flags/mk.png', 'MK', 389, 0, 0),
(146, 'MLI', 'Mali', 'admin/resources/flags/ml.png', 'ML', 223, 0, 0),
(147, 'MLT', 'Malta', 'admin/resources/flags/mt.png', 'MT', 356, 0, 0),
(148, 'MMR', 'Myanmar [Burma]', 'admin/resources/flags/mm.png', 'MM', 95, 0, 0),
(149, 'MNE', 'Montenegro', 'admin/resources/flags/me.png', 'ME', 382, 0, 0),
(150, 'MNG', 'Mongolia', 'admin/resources/flags/mn.png', 'MN', 976, 0, 0),
(151, 'MNP', 'Northern Mariana Islands', 'admin/resources/flags/mp.png', 'MP', 1670, 0, 0),
(152, 'MOZ', 'Mozambique', 'admin/resources/flags/mz.png', 'MZ', 258, 0, 0),
(153, 'MRT', 'Mauritania', 'admin/resources/flags/mr.png', 'MR', 222, 0, 0),
(154, 'MSR', 'Montserrat', 'admin/resources/flags/ms.png', 'MS', 1664, 0, 0),
(155, 'MTQ', 'Martinique', 'admin/resources/flags/mq.png', 'MQ', 596, 0, 0),
(156, 'MUS', 'Mauritius', 'admin/resources/flags/mu.png', 'MU', 230, 0, 0),
(157, 'MWI', 'Malawi', 'admin/resources/flags/mw.png', 'MW', 265, 0, 0),
(158, 'MYS', 'Malaysia', 'admin/resources/flags/my.png', 'MY', 60, 0, 0),
(159, 'MYT', 'Mayotte', 'admin/resources/flags/yt.png', 'YT', 269, 0, 0),
(160, 'NAM', 'Namibia', 'admin/resources/flags/na.png', 'NA', 264, 0, 0),
(161, 'NCL', 'New Caledonia', 'admin/resources/flags/nc.png', 'NC', 687, 0, 0),
(162, 'NER', 'Niger', 'admin/resources/flags/ne.png', 'NE', 227, 0, 0),
(163, 'NFK', 'Norfolk Island', 'admin/resources/flags/nf.png', 'NF', 672, 0, 0),
(164, 'NGA', 'Nigeria', 'admin/resources/flags/ng.png', 'NG', 234, 0, 0),
(165, 'NIC', 'Nicaragua', 'admin/resources/flags/ni.png', 'NI', 505, 0, 0),
(166, 'NIU', 'Niue', 'admin/resources/flags/nu.png', 'NU', 683, 0, 0),
(167, 'NLD', 'Netherlands', 'admin/resources/flags/nl.png', 'NL', 31, 0, 0),
(168, 'NOR', 'Norway', 'admin/resources/flags/no.png', 'NO', 47, 0, 0),
(169, 'NPL', 'Nepal', 'admin/resources/flags/np.png', 'NP', 977, 0, 0),
(170, 'NRU', 'Nauru', 'admin/resources/flags/nr.png', 'NR', 674, 0, 0),
(171, 'NZL', 'New Zealand', 'admin/resources/flags/nz.png', 'NZ', 64, 0, 0),
(172, 'OMN', 'Oman', 'admin/resources/flags/om.png', 'OM', 968, 0, 0),
(173, 'PAK', 'Pakistan', 'admin/resources/flags/pk.png', 'PK', 92, 0, 0),
(174, 'PAN', 'Panama', 'admin/resources/flags/pa.png', 'PA', 507, 0, 0),
(175, 'PCN', 'Pitcairn Islands', 'admin/resources/flags/pn.png', 'PN', 0, 0, 0),
(176, 'PER', 'Peru', 'admin/resources/flags/pe.png', 'PE', 51, 0, 0),
(177, 'PHL', 'Philippines', 'admin/resources/flags/ph.png', 'PH', 63, 0, 0),
(178, 'PLW', 'Palau', 'admin/resources/flags/pw.png', 'PW', 680, 0, 0),
(179, 'PNG', 'Papua New Guinea', 'admin/resources/flags/pg.png', 'PG', 675, 0, 0),
(180, 'POL', 'Poland', 'admin/resources/flags/pl.png', 'PL', 48, 0, 0),
(181, 'PRI', 'Puerto Rico', 'admin/resources/flags/pr.png', 'PR', 1787, 0, 0),
(182, 'PRK', 'North Korea', 'admin/resources/flags/kp.png', 'KP', 850, 0, 0),
(183, 'PRT', 'Portugal', 'admin/resources/flags/pt.png', 'PT', 351, 0, 0),
(184, 'PRY', 'Paraguay', 'admin/resources/flags/py.png', 'PY', 595, 0, 0),
(185, 'PSE', 'Palestine', 'admin/resources/flags/ps.png', 'PS', 970, 0, 0),
(186, 'PYF', 'French Polynesia', 'admin/resources/flags/pf.png', 'PF', 689, 0, 0),
(187, 'QAT', 'Qatar', 'admin/resources/flags/qa.png', 'QA', 974, 0, 0),
(188, 'REU', 'Réunion', 'admin/resources/flags/re.png', 'RE', 262, 0, 0),
(189, 'ROU', 'Romania', 'admin/resources/flags/ro.png', 'RO', 40, 0, 0),
(190, 'RUS', 'Russia', 'admin/resources/flags/ru.png', 'RU', 70, 0, 0),
(191, 'RWA', 'Rwanda', 'admin/resources/flags/rw.png', 'RW', 250, 0, 0),
(192, 'SAU', 'Saudi Arabia', 'admin/resources/flags/sa.png', 'SA', 966, 0, 0),
(193, 'SDN', 'Sudan', 'admin/resources/flags/sd.png', 'SD', 249, 0, 0),
(194, 'SEN', 'Senegal', 'admin/resources/flags/sn.png', 'SN', 221, 0, 0),
(195, 'SGP', 'Singapore', 'admin/resources/flags/sg.png', 'SG', 65, 0, 0),
(196, 'SGS', 'South Georgia and the South Sandwich Islands', 'admin/resources/flags/gs.png', 'GS', 0, 0, 0),
(197, 'SHN', 'Saint Helena', 'admin/resources/flags/sh.png', 'SH', 290, 0, 0),
(198, 'SJM', 'Svalbard and Jan Mayen', 'admin/resources/flags/sj.png', 'SJ', 47, 0, 0),
(199, 'SLB', 'Solomon Islands', 'admin/resources/flags/sb.png', 'SB', 677, 0, 0),
(200, 'SLE', 'Sierra Leone', 'admin/resources/flags/sl.png', 'SL', 232, 0, 0),
(201, 'SLV', 'El Salvador', 'admin/resources/flags/sv.png', 'SV', 503, 0, 0),
(202, 'SMR', 'San Marino', 'admin/resources/flags/sm.png', 'SM', 378, 0, 0),
(203, 'SOM', 'Somalia', 'admin/resources/flags/so.png', 'SO', 252, 0, 0),
(204, 'SPM', 'Saint Pierre and Miquelon', 'admin/resources/flags/pm.png', 'PM', 508, 0, 0),
(205, 'SRB', 'Serbia', 'admin/resources/flags/rs.png', 'RS', 381, 0, 0),
(206, 'SSD', 'South Sudan', 'admin/resources/flags/ss.png', 'SS', 211, 0, 0),
(207, 'STP', 'São Tomé and Príncipe', 'admin/resources/flags/st.png', 'ST', 239, 0, 0),
(208, 'SUR', 'Suriname', 'admin/resources/flags/sr.png', 'SR', 597, 0, 0),
(209, 'SVK', 'Slovakia', 'admin/resources/flags/sk.png', 'SK', 421, 0, 0),
(210, 'SVN', 'Slovenia', 'admin/resources/flags/si.png', 'SI', 386, 0, 0),
(211, 'SWE', 'Sweden', 'admin/resources/flags/se.png', 'SE', 46, 0, 0),
(212, 'SWZ', 'Swaziland', 'admin/resources/flags/sz.png', 'SZ', 268, 0, 0),
(213, 'SXM', 'Sint Maarten', 'admin/resources/flags/sx.png', 'SX', 1, 0, 0),
(214, 'SYC', 'Seychelles', 'admin/resources/flags/sc.png', 'SC', 248, 0, 0),
(215, 'SYR', 'Syria', 'admin/resources/flags/sy.png', 'SY', 963, 0, 0),
(216, 'TCA', 'Turks and Caicos Islands', 'admin/resources/flags/tc.png', 'TC', 1649, 0, 0),
(217, 'TCD', 'Chad', 'admin/resources/flags/td.png', 'TD', 235, 0, 0),
(218, 'TGO', 'Togo', 'admin/resources/flags/tg.png', 'TG', 228, 0, 0),
(219, 'THA', 'Thailand', 'admin/resources/flags/th.png', 'TH', 66, 0, 0),
(220, 'TJK', 'Tajikistan', 'admin/resources/flags/tj.png', 'TJ', 992, 0, 0),
(221, 'TKL', 'Tokelau', 'admin/resources/flags/tk.png', 'TK', 690, 0, 0),
(222, 'TKM', 'Turkmenistan', 'admin/resources/flags/tm.png', 'TM', 7370, 0, 0),
(223, 'TLS', 'East Timor', 'admin/resources/flags/tl.png', 'TL', 670, 0, 0),
(224, 'TON', 'Tonga', 'admin/resources/flags/to.png', 'TO', 676, 0, 0),
(225, 'TTO', 'Trinidad and Tobago', 'admin/resources/flags/tt.png', 'TT', 1868, 0, 0),
(226, 'TUN', 'Tunisia', 'admin/resources/flags/tn.png', 'TN', 216, 0, 0),
(227, 'TUR', 'Turkey', 'admin/resources/flags/tr.png', 'TR', 90, 0, 0),
(228, 'TUV', 'Tuvalu', 'admin/resources/flags/tv.png', 'TV', 688, 0, 0),
(229, 'TWN', 'Taiwan', 'admin/resources/flags/tw.png', 'TW', 886, 0, 0),
(230, 'TZA', 'Tanzania', 'admin/resources/flags/tz.png', 'TZ', 255, 0, 0),
(231, 'UGA', 'Uganda', 'admin/resources/flags/ug.png', 'UG', 256, 0, 0),
(232, 'UKR', 'Ukraine', 'admin/resources/flags/ua.png', 'UA', 380, 0, 0),
(233, 'UMI', 'U.S. Minor Outlying Islands', 'admin/resources/flags/um.png', 'UM', 1, 0, 0),
(234, 'URY', 'Uruguay', 'admin/resources/flags/uy.png', 'UY', 598, 0, 0),
(235, 'USA', 'United States', 'admin/resources/flags/us.png', 'US', 1, 0, 0),
(236, 'UZB', 'Uzbekistan', 'admin/resources/flags/uz.png', 'UZ', 998, 0, 0),
(237, 'VAT', 'Vatican City', 'admin/resources/flags/va.png', 'VA', 39, 0, 0),
(238, 'VCT', 'Saint Vincent and the Grenadines', 'admin/resources/flags/vc.png', 'VC', 1784, 0, 0),
(239, 'VEN', 'Venezuela', 'admin/resources/flags/ve.png', 'VE', 58, 0, 0),
(240, 'VGB', 'British Virgin Islands', 'admin/resources/flags/vg.png', 'VG', 1284, 0, 0),
(241, 'VIR', 'U.S. Virgin Islands', 'admin/resources/flags/vi.png', 'VI', 1340, 0, 0),
(242, 'VNM', 'Vietnam', 'admin/resources/flags/vn.png', 'VN', 84, 0, 1),
(243, 'VUT', 'Vanuatu', 'admin/resources/flags/vu.png', 'VU', 678, 0, 0),
(244, 'WLF', 'Wallis and Futuna', 'admin/resources/flags/wf.png', 'WF', 681, 0, 0),
(245, 'WSM', 'Samoa', 'admin/resources/flags/ws.png', 'WS', 684, 0, 0),
(246, 'XKX', 'Kosovo', 'admin/resources/flags/xk.png', 'XK', 381, 0, 0),
(247, 'YEM', 'Yemen', 'admin/resources/flags/ye.png', 'YE', 967, 0, 0),
(248, 'ZAF', 'South Africa', 'admin/resources/flags/za.png', 'ZA', 27, 0, 0),
(249, 'ZMB', 'Zambia', 'admin/resources/flags/zm.png', 'ZM', 260, 0, 0),
(250, 'ZWE', 'Zimbabwe', 'admin/resources/flags/zw.png', 'ZW', 263, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_coupon`
--
DROP TABLE IF EXISTS `tbpro_coupon`;
CREATE TABLE `tbpro_coupon` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`code` varchar(11) NOT NULL,
`amount` float NOT NULL,
`percent` float NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_currency`
--
DROP TABLE IF EXISTS `tbpro_currency`;
CREATE TABLE `tbpro_currency` (
`id` int(11) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 NOT NULL,
`code` char(3) COLLATE utf8_unicode_ci NOT NULL,
`symbol` char(4) COLLATE utf8_unicode_ci NOT NULL,
`ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `tbpro_currency`
--
INSERT INTO `tbpro_currency` (`id`, `name`, `code`, `symbol`, `ordering`) VALUES
(1, 'EURO', 'EUR', '€', 0),
(5, 'Dollar', 'USD', '$', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_customer`
--
DROP TABLE IF EXISTS `tbpro_customer`;
CREATE TABLE `tbpro_customer` (
`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,
`country_code` varchar(10) NOT NULL,
`address_1` varchar(255) NOT NULL,
`address_2` varchar(255) NOT NULL,
`city` varchar(50) NOT NULL,
`created_date` datetime NOT NULL,
`email` varchar(50) NOT NULL,
`zip_code` int(5) NOT NULL,
`state` text 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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_customize`
--
DROP TABLE IF EXISTS `tbpro_customize`;
CREATE TABLE `tbpro_customize` (
`id` int(11) UNSIGNED NOT NULL,
`table_view` varchar(200) NOT NULL,
`label_field` varchar(200) NOT NULL,
`field_name` varchar(200) NOT NULL,
`type` varchar(200) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL,
`backend` int(5) NOT NULL,
`frontend` int(5) NOT NULL,
`default_value` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_destination`
--
DROP TABLE IF EXISTS `tbpro_destination`;
CREATE TABLE `tbpro_destination` (
`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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_discount`
--
DROP TABLE IF EXISTS `tbpro_discount`;
CREATE TABLE `tbpro_discount` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`amount` float NOT NULL,
`percent` float NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_discount`
--
INSERT INTO `tbpro_discount` (`id`, `name`, `amount`, `percent`, `alias`, `ordering`, `published`, `description`) VALUES
(1, '10%', 0, 10, '', 0, 1, 'One popular way to offer discounts is through percentage-based discounts. This can include smaller incentive percentages like 5% or 10% off, larger discounts to really drive sales like 20% and 25%, or significant percentages like 50%+ to liquidate merchandise that’s old or isn’t moving. You can also easily apply these discounts to multiple collections, products, and locations in Shopify, or offer them based on a specific purchase, like “Buy two sneakers, get 50% off any sweater.”\r\n\r\n '),
(2, 'christmas discount', 50, 0, '', 0, 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_email`
--
DROP TABLE IF EXISTS `tbpro_email`;
CREATE TABLE `tbpro_email` (
`id` int(11) NOT NULL,
`image` varchar(255) NOT NULL,
`name` varchar(200) NOT NULL,
`subject` text NOT NULL,
`params` mediumtext NOT NULL,
`type` varchar(50) NOT NULL,
`published` int(11) NOT NULL,
`content` mediumtext NOT NULL,
`description` text NOT NULL,
`ordering` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_email`
--
INSERT INTO `tbpro_email` (`id`, `image`, `name`, `subject`, `params`, `type`, `published`, `content`, `description`, `ordering`) VALUES
(2, 'blocks/block_priceplanclass/assets/images/the-member1.png', 'Send Email info tour', 'Confim your booking', '{\"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\"}', 'send_info_tour', 0, 'Hi {customer_first_name} {customer_last_name},\r\n\r\nYou recently visited our [Tour Operator]. I thought I’d quickly check-in and ask if you found what you were looking for? I also have additional resources for you:\r\n\r\n- Tour name: {tour_name}\r\n\r\n- Duartion: {tour_duration} days\r\n\r\n- Location: {location_i}\r\n\r\n- Order ID: {order_id}\r\n\r\n- Price : {orderdetail_total}$\r\n\r\nI’ve actually looked at your company and am happy to share how you compare to the industry benchmarks we’ve seen out there. Do you want to talk tomorrow at [two times you\'re available]?\r\n\r\nBest regards,\r\n[Name]\r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n ', 'email email tour info', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_employee`
--
DROP TABLE IF EXISTS `tbpro_employee`;
CREATE TABLE `tbpro_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,
`category_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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_event`
--
DROP TABLE IF EXISTS `tbpro_event`;
CREATE TABLE `tbpro_event` (
`id` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`price` float NOT NULL,
`published` int(11) NOT NULL,
`location_id` int(11) NOT NULL,
`max_allowed_person` int(11) NOT NULL,
`min_allowed_person` int(11) NOT NULL,
`service_id` int(11) NOT NULL,
`event_color` varchar(20) NOT NULL,
`recurring_repeat` varchar(50) NOT NULL,
`recurring` int(11) NOT NULL,
`alias` varchar(200) NOT NULL,
`description` text NOT NULL,
`recurring_until` date NOT NULL,
`ordering` int(11) NOT NULL,
`publish_up` datetime NOT NULL,
`publish_down` datetime NOT NULL,
`close` int(11) NOT NULL,
`close_date` datetime NOT NULL,
`open_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_event_employee`
--
DROP TABLE IF EXISTS `tbpro_event_employee`;
CREATE TABLE `tbpro_event_employee` (
`id` int(11) NOT NULL,
`employee_id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_event_tag`
--
DROP TABLE IF EXISTS `tbpro_event_tag`;
CREATE TABLE `tbpro_event_tag` (
`id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_extra`
--
DROP TABLE IF EXISTS `tbpro_extra`;
CREATE TABLE `tbpro_extra` (
`id` int(11) NOT NULL,
`type` varchar(30) NOT NULL,
`object_id` int(11) NOT NULL,
`duration` float NOT NULL,
`price` float NOT NULL,
`quality` int(11) NOT NULL,
`path` varchar(300) NOT NULL,
`name` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_facility`
--
DROP TABLE IF EXISTS `tbpro_facility`;
CREATE TABLE `tbpro_facility` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_facility`
--
INSERT INTO `tbpro_facility` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Coffee', 'upload/facilities/images/cover/coffee.png', '', 5, 1, ''),
(21, 'Hairdryer', 'upload/facilities/images/cover/hairdryer.png', '', 9, 0, ''),
(22, 'Fridge', 'upload/facilities/images/cover/fridge.png', '', 10, 1, ''),
(23, 'Wifi', 'upload/facilities/images/cover/wifi.png', '', 11, 1, ''),
(70, 'Air-Conditioning', 'upload/facilities/images/cover/air-conditioning.png', '', 0, 1, ''),
(72, 'No smoking', 'upload/facilities/images/cover/non-smoking.png', '', 0, 0, 'No smoking');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_finance`
--
DROP TABLE IF EXISTS `tbpro_finance`;
CREATE TABLE `tbpro_finance` (
`id` int(11) NOT NULL,
`payment_date` date NOT NULL,
`name_customer` varchar(255) NOT NULL,
`email_customer` varchar(255) NOT NULL,
`employee` varchar(255) NOT NULL,
`avatar_employee` varchar(255) NOT NULL,
`service` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_gallery`
--
DROP TABLE IF EXISTS `tbpro_gallery`;
CREATE TABLE `tbpro_gallery` (
`id` int(11) NOT NULL,
`type` varchar(30) NOT NULL,
`object_id` int(11) NOT NULL,
`path` varchar(300) NOT NULL,
`name` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_gallery`
--
INSERT INTO `tbpro_gallery` (`id`, `type`, `object_id`, `path`, `name`, `alias`, `description`) VALUES
(141, 'package', 2, 'upload/packages/gallery/z51LBHdtanh3.jpg', 'anh3.jpg', '', ''),
(538, 'activity', 70, 'upload/gallery/activities/hinh-anh-hoc-nhay-sexy-dance-o-dau-tai-ha-noi.jpg', 'hinh-anh-hoc-nhay-sexy-dance-o-dau-tai-ha-noi.jpg', '', ''),
(539, 'destination', 17, 'upload/gallery/destinations/home-training.jpg', 'home-training.jpg', '', ''),
(540, 'destination', 17, 'upload/gallery/destinations/anh1.jpeg', 'anh1.jpeg', '', ''),
(541, 'itinerary', 1, 'upload/gallery/itineraries/Paris-18-1024x682.webp', 'Paris-18-1024x682.webp', '', ''),
(542, 'itinerary', 1, 'upload/gallery/itineraries/Paris-67-1024x683.webp', 'Paris-67-1024x683.webp', '', ''),
(543, 'itinerary', 1, 'upload/gallery/itineraries/Paris-195-1024x683.jpg', 'Paris-195-1024x683.jpg', '', ''),
(544, 'itinerary', 1, 'upload/gallery/itineraries/Paris-210.jpg', 'Paris-210.jpg', '', ''),
(545, 'itinerary', 1, 'upload/gallery/itineraries/Paris-304-1024x683.jpg', 'Paris-304-1024x683.jpg', '', ''),
(546, 'itinerary', 1, 'upload/gallery/itineraries/PortugalSintra-9-1024x682.jpg', 'PortugalSintra-9-1024x682.jpg', '', ''),
(547, 'itinerary', 2, 'upload/gallery/itineraries/Paris-238.webp', 'Paris-238.webp', '', ''),
(548, 'itinerary', 2, 'upload/gallery/itineraries/Paris-73-1024x683.jpg', 'Paris-73-1024x683.jpg', '', ''),
(549, 'itinerary', 2, 'upload/gallery/itineraries/Paris-125.jpg', 'Paris-125.jpg', '', ''),
(550, 'itinerary', 3, 'upload/gallery/itineraries/Paris-419-1024x683.jpg', 'Paris-419-1024x683.jpg', '', ''),
(551, 'itinerary', 3, 'upload/gallery/itineraries/Paris-196-1024x683.jpg', 'Paris-196-1024x683.jpg', '', ''),
(552, 'tour', 12, 'upload/gallery/tours/Paris-18-1024x682.webp', 'Paris-18-1024x682.webp', '', ''),
(553, 'tour', 12, 'upload/gallery/tours/Paris-238.webp', 'Paris-238.webp', '', ''),
(554, 'tour', 12, 'upload/gallery/tours/Paris-196-1024x683.jpg', 'Paris-196-1024x683.jpg', '', ''),
(555, 'tour', 13, 'upload/gallery/tours/38826.jpg', '38826.jpg', '', ''),
(556, 'tour', 13, 'upload/gallery/tours/Hon Mun Island 2.jpg', 'Hon Mun Island 2.jpg', '', ''),
(557, 'tour', 13, 'upload/gallery/tours/mot-island.jpg', 'mot-island.jpg', '', ''),
(558, 'tour', 13, 'upload/gallery/tours/Trip-to-Komodo-Island-29-1024x682.jpg', 'Trip-to-Komodo-Island-29-1024x682.jpg', '', ''),
(559, 'itinerary', 5, 'upload/gallery/itineraries/Rainbow-Troops.jpg', 'Rainbow-Troops.jpg', '', ''),
(560, 'itinerary', 5, 'upload/gallery/itineraries/indonesia-gili-walk-group-landscape-hires-1800x800-cropped-85.jpeg', 'indonesia-gili-walk-group-landscape-hires-1800x800-cropped-85.jpeg', '', ''),
(561, 'itinerary', 4, 'upload/gallery/itineraries/ez0rogqip0tszvxneifn.webp', 'ez0rogqip0tszvxneifn.webp', '', ''),
(562, 'itinerary', 4, 'upload/gallery/itineraries/IMG_7761.jfif', 'IMG_7761.jfif', '', ''),
(563, 'tour', 14, 'upload/gallery/tours/04.jpg', '04.jpg', '', ''),
(564, 'tour', 14, 'upload/gallery/tours/20044853.jpg', '20044853.jpg', '', ''),
(565, 'tour', 14, 'upload/gallery/tours/unnamed.jpg', 'unnamed.jpg', '', ''),
(566, 'itinerary', 6, 'upload/gallery/itineraries/242d942ea66469e15ed88e701df1a261.jpg', '242d942ea66469e15ed88e701df1a261.jpg', '', ''),
(567, 'itinerary', 6, 'upload/gallery/itineraries/sunworld_halong_(1).jpg', 'sunworld_halong_(1).jpg', '', ''),
(568, 'itinerary', 6, 'upload/gallery/itineraries/Sunlight_Halong_Bay_Cruise-1-e1564808093701.jpg', 'Sunlight_Halong_Bay_Cruise-1-e1564808093701.jpg', '', ''),
(569, 'itinerary', 7, 'upload/gallery/itineraries/20044853.jpg', '20044853.jpg', '', ''),
(570, 'itinerary', 7, 'upload/gallery/itineraries/unnamed.jpg', 'unnamed.jpg', '', ''),
(571, 'itinerary', 8, 'upload/gallery/itineraries/20.jpg', '20.jpg', '', ''),
(572, 'itinerary', 9, 'upload/gallery/itineraries/jw-5d1487225df5c6.06387123.png', 'jw-5d1487225df5c6.06387123.png', '', ''),
(573, 'itinerary', 10, 'upload/gallery/itineraries/jw-5d14872ae5da70.98820408.jpeg', 'jw-5d14872ae5da70.98820408.jpeg', '', ''),
(574, 'itinerary', 10, 'upload/gallery/itineraries/jw-5d14872d740f74.85697861.jpeg', 'jw-5d14872d740f74.85697861.jpeg', '', ''),
(575, 'itinerary', 10, 'upload/gallery/itineraries/jw-5d14872f5d72f6.45928259.jpeg', 'jw-5d14872f5d72f6.45928259.jpeg', '', ''),
(576, 'itinerary', 11, 'upload/gallery/itineraries/jw-5d14873741fa93.38805758.jpeg', 'jw-5d14873741fa93.38805758.jpeg', '', ''),
(577, 'tour', 15, 'upload/gallery/tours/Canva-Fuji-Mountain-View-1024x634.jpg', 'Canva-Fuji-Mountain-View-1024x634.jpg', '', ''),
(578, 'tour', 15, 'upload/gallery/tours/Th10_prbig_1827.jpg', 'Th10_prbig_1827.jpg', '', ''),
(579, 'tour', 15, 'upload/gallery/tours/20.jpg', '20.jpg', '', ''),
(580, 'itinerary', 12, 'upload/gallery/itineraries/Paris-238.webp', 'Paris-238.webp', '', ''),
(582, 'tour', 16, 'upload/gallery/tours/mfixYvyQChamps-Elysees_1.jpg', 'Champs-Elysees_1.jpg', '', ''),
(583, 'tour', 16, 'upload/gallery/tours/OfmxeU7GChamps-Elysees_2.jpg', 'Champs-Elysees_2.jpg', '', ''),
(584, 'tour', 17, 'upload/gallery/tours/Rf6q5XeUmaxresdefault.jpg', 'maxresdefault.jpg', '', ''),
(585, 'tour', 17, 'upload/gallery/tours/9XSxOS54Santas-Lapland-How-to-Work-at-Santa-Claus-Village-Finland.jpg', 'Santas-Lapland-How-to-Work-at-Santa-Claus-Village-Finland.jpg', '', ''),
(586, 'tour', 18, 'upload/gallery/tours/PsnMP6RElake-tahoe-family-vacation-summer-things-do-via-magazine-shutterstock_140427961.jpg', 'lake-tahoe-family-vacation-summer-things-do-via-magazine-shutterstock_140427961.jpg', '', ''),
(587, 'tour', 18, 'upload/gallery/tours/BhelDB5Rsand-harbor-lake-tahoe.jpg', 'sand-harbor-lake-tahoe.jpg', '', ''),
(588, 'tour', 19, 'upload/gallery/tours/yN9Bc7p41_513638_02.jpg', '1_513638_02.jpg', '', ''),
(589, 'tour', 19, 'upload/gallery/tours/rymnFMvpHanauma-Bay-Oahu-Hawaii.jpg', 'Hanauma-Bay-Oahu-Hawaii.jpg', '', ''),
(591, 'tour', 20, 'upload/gallery/tours/uLSRjldhgolden-gate-bridge-at-san-francisco-top.jpg', 'golden-gate-bridge-at-san-francisco-top.jpg', '', ''),
(592, 'tour', 20, 'upload/gallery/tours/kSUFUHONlocation_img-3624-230665892-148.jpg', 'location_img-3624-230665892-148.jpg', '', ''),
(596, 'tour', 21, 'upload/gallery/tours/f7WFPumoseoul-541fd1a6c03db.jpg', 'seoul-541fd1a6c03db.jpg', '', ''),
(597, 'tour', 21, 'upload/gallery/tours/4ocHmeubsteven-roe-991118-unsplash-1600x1000.jpg', 'steven-roe-991118-unsplash-1600x1000.jpg', '', ''),
(598, 'tour', 22, 'upload/gallery/tours/au8RVFxZHdr_parliament.jpg', 'Hdr_parliament.jpg', '', ''),
(599, 'tour', 22, 'upload/gallery/tours/vcuTmgWzSocial-and-Local-Palace-of-Westminster-Case-Study.jpg', 'Social-and-Local-Palace-of-Westminster-Case-Study.jpg', '', ''),
(600, 'tour', 23, 'upload/gallery/tours/TvE3psKYafrica.jpg', 'africa.jpg', '', ''),
(601, 'tour', 23, 'upload/gallery/tours/ht7wC3txafrica-onyx-truth.jpg', 'africa-onyx-truth.jpg', '', ''),
(602, 'tour', 24, 'upload/gallery/tours/a9cmNcFm148114_896c2cf7.jpg', '148114_896c2cf7.jpg', '', ''),
(603, 'tour', 24, 'upload/gallery/tours/EagZfv6LRoute-Boghe-Kaedi_Village.jpg', 'Route-Boghe-Kaedi_Village.jpg', '', ''),
(606, 'tour', 26, 'upload/gallery/tours/7WbcwrScbd5ed7bd893a9ef5d4597bf0792439d9.jpg', 'bd5ed7bd893a9ef5d4597bf0792439d9.jpg', '', ''),
(607, 'tour', 26, 'upload/gallery/tours/qLYHfkSvNeverland_Boys__Vang_Vieng_copy.jpg', 'Neverland_Boys__Vang_Vieng_copy.jpg', '', ''),
(608, 'tour', 27, 'upload/gallery/tours/ARkPKTY4pagoda-in-an-Inthanon-mountain.jpg.jpg', 'pagoda-in-an-Inthanon-mountain.jpg.jpg', '', ''),
(609, 'tour', 27, 'upload/gallery/tours/xtSu79RxPalais-d-été-Ayuthaya-3.jpg', 'Palais-d-été-Ayuthaya-3.jpg', '', ''),
(610, 'tour', 28, 'upload/gallery/tours/25s5Miq8city_beijing.jpg', 'city_beijing.jpg', '', ''),
(611, 'tour', 28, 'upload/gallery/tours/qXbhKOv8hero_image_22_1555942794.jpg', 'hero_image_22_1555942794.jpg', '', ''),
(612, 'tour', 29, 'upload/gallery/tours/4ZIz0uvUdiverse-travel-bunaken-01-04-19-1.jpg', 'diverse-travel-bunaken-01-04-19-1.jpg', '', ''),
(613, 'tour', 29, 'upload/gallery/tours/oguYpAwzoasis-mentawai-4.jpeg', 'oasis-mentawai-4.jpeg', '', ''),
(614, 'tour', 30, 'upload/gallery/tours/zzI6GyDNha-long-bay.jpg', 'ha-long-bay.jpg', '', ''),
(615, 'tour', 30, 'upload/gallery/tours/MT5oQzrYhalong-bay_3.jpg', 'halong-bay_3.jpg', '', ''),
(616, 'tour', 31, 'upload/gallery/tours/pqfI3K2u5df8d3b068199.jpeg', '5df8d3b068199.jpeg', '', ''),
(617, 'tour', 31, 'upload/gallery/tours/zMhj7KjKvolcanic-cone-Japan-Mount-Fuji.jpg', 'volcanic-cone-Japan-Mount-Fuji.jpg', '', ''),
(618, 'activity', 75, 'upload/gallery/activities/fA9l51wpC8Kj5_dCnE75BMxGpYYdcJVuEQbV3CnmF8ONfpQKM2nSWWBIIZYawS1qMa7rEFnffYG+i9OZUEt8PuKdInSV4NhZ1LlG4iuV6rp4mp8FO2uJwIFDbz_tKBkJl3SKoObz3Xz3x_nYAfcq+WVIq6QecJrzHcvOUloUTNIiXCuF7DQTaOLlt0ytAxxHxlKpdCKFSL+2VtYJ25ckRjDqdhAwsJ.jpg', 'C8Kj5_dCnE75BMxGpYYdcJVuEQbV3CnmF8ONfpQKM2nSWWBIIZYawS1qMa7rEFnffYG+i9OZUEt8PuKdInSV4NhZ1LlG4iuV6rp4mp8FO2uJwIFDbz_tKBkJl3SKoObz3Xz3x_nYAfcq+WVIq6QecJrzHcvOUloUTNIiXCuF7DQTaOLlt0ytAxxHxlKpdCKFSL+2VtYJ', '', ''),
(620, 'tour', 36, 'upload/gallery/tours/N7EsMk5YIndia-War-Memorial-arch-New-Delhi-Sir.jpg', 'India-War-Memorial-arch-New-Delhi-Sir.jpg', '', ''),
(632, 'itinerary', 14, 'upload/gallery/itineraries/uw0xCBwv102911_f0237ea8.jpg', '102911_f0237ea8.jpg', '', ''),
(633, 'itinerary', 14, 'upload/gallery/itineraries/jBHwBypO102911_2d4c82.jpg', '102911_2d4c82.jpg', '', ''),
(634, 'itinerary', 15, 'upload/gallery/itineraries/jfwQWwFF80890_50dcb0.jpg', '80890_50dcb0.jpg', '', ''),
(635, 'itinerary', 15, 'upload/gallery/itineraries/0V9dUFiD80890_63054b97.jpg', '80890_63054b97.jpg', '', ''),
(636, 'tour', 43, 'upload/gallery/tours/vykdFjqC62086_a5d10a24.jpg', '62086_a5d10a24.jpg', '', ''),
(637, 'tour', 43, 'upload/gallery/tours/GvJqC91B62086_46163d8f.jpg', '62086_46163d8f.jpg', '', ''),
(638, 'tour', 44, 'upload/gallery/tours/Q1GdECrR92355_e1cf887c.jpg', '92355_e1cf887c.jpg', '', ''),
(639, 'tour', 44, 'upload/gallery/tours/cvHoL2Ow92355_7ed8248b.jpg', '92355_7ed8248b.jpg', '', ''),
(640, 'tour', 45, 'upload/gallery/tours/ZDAFdSlU92355_7ed8248b.jpg', '92355_7ed8248b.jpg', '', ''),
(641, 'tour', 45, 'upload/gallery/tours/546Ky7nT92355_e1cf887c.jpg', '92355_e1cf887c.jpg', '', ''),
(642, 'tour', 46, 'upload/gallery/tours/m8NtbIWR133430_5e26f898522d7.jpg', '133430_5e26f898522d7.jpg', '', ''),
(643, 'tour', 46, 'upload/gallery/tours/j0Q8c61O133430_5e26f8987d4f0.jpg', '133430_5e26f8987d4f0.jpg', '', ''),
(644, 'tour', 47, 'upload/gallery/tours/c72qjyLM4.jpg', '4.jpg', '', ''),
(645, 'tour', 47, 'upload/gallery/tours/Sw92JILZ1.jpg', '1.jpg', '', ''),
(646, 'tour', 48, 'upload/gallery/tours/u3Qzde7x108450_5e45ea2e4f847.jpg', '108450_5e45ea2e4f847.jpg', '', ''),
(647, 'tour', 48, 'upload/gallery/tours/XoZMlRdF108450_5e45ea2e4f84c.jpg', '108450_5e45ea2e4f84c.jpg', '', ''),
(648, 'tour', 49, 'upload/gallery/tours/8UpCgZwx147254_793e6219.jpg', '147254_793e6219.jpg', '', ''),
(649, 'tour', 49, 'upload/gallery/tours/FlBrfy0o147254_5df9f909ee66c.jpg', '147254_5df9f909ee66c.jpg', '', ''),
(650, 'tour', 50, 'upload/gallery/tours/LmUWpdPr152981_c12946d8.jpg', '152981_c12946d8.jpg', '', ''),
(651, 'tour', 50, 'upload/gallery/tours/ElIRj5Zh152981_b7329347.jpg', '152981_b7329347.jpg', '', ''),
(652, 'tour', 51, 'upload/gallery/tours/jIQg9ox51.jpg', '1.jpg', '', ''),
(653, 'tour', 51, 'upload/gallery/tours/J5aRat5U3.jpg', '3.jpg', '', ''),
(654, 'tour', 42, 'upload/gallery/tours/miu35yPA1.jpg', '1.jpg', '', ''),
(655, 'tour', 42, 'upload/gallery/tours/AoJSli8f6.jpg', '6.jpg', '', ''),
(656, 'tour', 42, 'upload/gallery/tours/ZJMSnFTP3.jpg', '3.jpg', '', ''),
(657, 'tour', 42, 'upload/gallery/tours/yRBgoaZm2.jpg', '2.jpg', '', ''),
(664, 'tour', 34, 'upload/gallery/tours/67emjvxEtokyo-mt-fuji.jpg', 'tokyo-mt-fuji.jpg', '', ''),
(669, 'tour', 33, 'upload/gallery/tours/u5hgAWJ31.jpg', '1.jpg', '', ''),
(670, 'tour', 33, 'upload/gallery/tours/wzARujQl2.jpg', '2.jpg', '', ''),
(671, 'tour', 33, 'upload/gallery/tours/QobRnump3.jpg', '3.jpg', '', ''),
(672, 'tour', 33, 'upload/gallery/tours/62DNDPT84.jpg', '4.jpg', '', ''),
(673, 'tour', 33, 'upload/gallery/tours/YRJpYOrv5.jpg', '5.jpg', '', ''),
(674, 'tour', 35, 'upload/gallery/tours/Khi84lEY1.jpg', '1.jpg', '', ''),
(675, 'tour', 35, 'upload/gallery/tours/aXFkaLoT2.jpg', '2.jpg', '', ''),
(676, 'tour', 35, 'upload/gallery/tours/ARSxkrt83.jpg', '3.jpg', '', ''),
(677, 'tour', 35, 'upload/gallery/tours/YuMSneSe4.jpg', '4.jpg', '', ''),
(678, 'tour', 36, 'upload/gallery/tours/Zk7iOLfZgolden-triangle-taj-mahal.jpg', 'golden-triangle-taj-mahal.jpg', '', ''),
(679, 'tour', 36, 'upload/gallery/tours/RzuED1Ydimages.jpg', 'images.jpg', '', ''),
(680, 'tour', 37, 'upload/gallery/tours/A6R5S2xzHimalaya.png', 'Himalaya.png', '', ''),
(681, 'tour', 38, 'upload/gallery/tours/4FWMoQ8ymaxresdefault.jpg', 'maxresdefault.jpg', '', ''),
(682, 'tour', 38, 'upload/gallery/tours/Q0GBFKwN60477_5df9de9e21512.jpg', '60477_5df9de9e21512.jpg', '', ''),
(683, 'tour', 39, 'upload/gallery/tours/tznX8dZw1 (1).jpg', '1 (1).jpg', '', ''),
(684, 'tour', 39, 'upload/gallery/tours/bVaWjvhJ3 (1).jpg', '3 (1).jpg', '', ''),
(685, 'tour', 39, 'upload/gallery/tours/WMR2lfWh2 (1).jpg', '2 (1).jpg', '', ''),
(686, 'tour', 40, 'upload/gallery/tours/GByo3V8480890_50dcb0.jpg', '80890_50dcb0.jpg', '', ''),
(687, 'tour', 40, 'upload/gallery/tours/HdUudp8n92355_e1cf887c.jpg', '92355_e1cf887c.jpg', '', ''),
(688, 'tour', 41, 'upload/gallery/tours/uzLhvdLD152981_c12946d8.jpg', '152981_c12946d8.jpg', '', ''),
(689, 'tour', 41, 'upload/gallery/tours/7TsU96YJ133430_5e26f898522d7.jpg', '133430_5e26f898522d7.jpg', '', ''),
(693, 'tour', 25, 'upload/gallery/tours/DPOl81DE1.jpg', '1.jpg', '', ''),
(694, 'tour', 25, 'upload/gallery/tours/cutuvzCA4.jpg', '4.jpg', '', ''),
(695, 'tour', 52, 'upload/gallery/tours/bv14fMQi1.jpg', '1.jpg', '', ''),
(696, 'tour', 52, 'upload/gallery/tours/MPD0eMI03.jpg', '3.jpg', '', ''),
(697, 'tour', 25, 'upload/gallery/tours/9Nxpb1tA2.jpg', '2.jpg', '', ''),
(698, 'tour', 53, 'upload/gallery/tours/r05O4YFG1.jpg', '1.jpg', '', ''),
(699, 'tour', 53, 'upload/gallery/tours/TVzVhyMc3.jpg', '3.jpg', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_itinerary`
--
DROP TABLE IF EXISTS `tbpro_itinerary`;
CREATE TABLE `tbpro_itinerary` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`tour_id` int(11) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_itinerary`
--
INSERT INTO `tbpro_itinerary` (`id`, `name`, `tour_id`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(28, 'Paris Getaway 2 Nights day 1', 42, '', '', 0, 1, 'We will meet outside of Taylor Institution Library entrance, St Giles at 20:45 and then travel overnight to the wonderful city of Paris by coach and ferry/eurotunnel. We will depart from Dover in the early hours of the morning, on arrival in France please note that you will have to put your watches forward by one hour. From Calais the journey to Paris will take about 4 hours, we will make a breakfast stop on the outskirts of the city where you will also be able to freshen up.
'),
(29, 'Paris Getaway 2 Nights day 2', 42, '', '', 0, 1, 'Morning guided sightseeing includes a drive past the Latin Quarter, Les Invalides, Place de la Concorde, the Arc de Triomphe, and a stop to take photos of the Eiffel Tower from one of the best panoramic viewing points. Also admire the heart of the city from a different perspective on a SEINE RIVER CRUISE. Board your comfortable boat near the Eiffel Tower and spend a relaxing hour gliding by many of the city\'s important landmarks such as the L\'Institut de France, magnificent Notre Dame Cathedral, Hôtel de Ville, the Conciergerie, famous Louvre Palace and museum, and much more.
'),
(30, 'Paris Getaway 2 Nights day 3', 42, '', '', 0, 1, 'Your vacation ends with breakfast this morning.
'),
(31, 'thai d1', 25, '', '', 0, 1, 'We’ll pick you up at 8:00am from the CHIANG MAI GATE HOTEL in Chiang Mai city and transfer you to our training base in the lovely Mae Wang valley around 1 hour from the city.\r\nOn arrival at our ‘base camp’ in\r\n\r\nMae Wang we’ll introduce you immediately to your Tuk Tuk and crack on with the drive training. This all takes place ‘off road’ and is a thorough session giving all participants the time to get used to these wonderful vehicles and master all the controls.'),
(32, 'thaid2', 25, '', '', 0, 1, 'After breakfast we’ll explore the local area and forest around the village before getting back into the Tuk Tuks and heading further into the foothills of Doi Inthanon, Thailand’s highest mountain. With lots of stops to explore and relax this is a fantastic journey through spectacular mountain scenery and a real insight into this part of the world.'),
(33, 'Tokyod1', 34, '', '', 0, 1, 'Start off your exciting day of exploration with a pickup from select hotels/hostels in the early afternoon, before heading to the tour meeting point at Hamamatsucho Bus Terminal.\r\nOur first stop is Tokyo’s 40-story-tall World Trade Center building where you will get to marvel at impressive 360-degree views from the skyscraper’s Seaside Top observation platform. From this unique vantage point you’ll have 20 minutes to spot the city’s iconic Tokyo Tower, the Tokyo Skytree and, if the weather’s clear, perhaps the majestic Mount Fuji.'),
(34, 'tokyod2', 34, '', '', 0, 1, 'Free Day'),
(35, 'Champsd1', 35, '', '', 0, 1, 'We take you on a tour of this fascinating place that is sure to awe you not only with its appearance, but also with its much layered history. What does the Champs Elysées really mean, and why is the main street of Paris called that way? After which model was it made, and why? From the 17th century to our days, this avenue is a constant inspiration (as well as a mystery) to classical artists and pop singers alike. It is our goal to make you acquainted with all of the historical, symbolical and artistic aspects of this unique place.'),
(36, 'Champs Elysees Walking Tourd2', 35, '', '', 0, 1, 'Our visit starts at place de la Concorde, at the site of the Obelisk. Your guide will be carrying a red canvas tote bag. During the tour, we walk up the street and visit the major sites, all the while getting to know about a unique and world changing history of this unique site. The tour ends near the Arc de Triomphe.'),
(37, 'godend1', 36, '', '', 0, 1, 'Your adventure begins with a welcome meeting at 6 pm. If you arrive with hours (or days) to spare, consider striking out on your own, perhaps to visit the World Heritage-listed Humayun\'s Tomb. A great (and tasty) way to get under the city’s skin in very little time is to book an Urban Adventure like the Delhi City Food Crawl. After the 6 pm meeting, head out for an optional meal with your group at a local restaurant.'),
(38, 'godend2', 36, '', '', 0, 1, 'Join your group leader on an excursion through Old Delhi. Ride the city’s metro system, and then hop in a rickshaw to the once water-filled square of Chandni Chowk. Discover the Jama Masjid, Delhi’s oldest mosque, before learning about the history of the Sikh religion at the Sheeshganj Gurudwara. Accommodation: Hotel'),
(39, 'Hanconed1', 37, '', '', 0, 1, 'Transfer to Hakone by train\r\nToday you will travel on your own from the Tokyo Shinjuku Station to Hakone-Yumoto Station via limited express train. Upon arrival you will make your own way to your accommodation and have the rest of the day to enjoy free time to visit the town and its scenic attractions or take a dip in one of the many “onsen” hot springs around. Have dinner on your own and overnight in Hakone.'),
(40, 'Hanconed2', 37, '', '', 0, 1, 'Free day in Hakone for sightseeing\r\nHave breakfast at your accommodation this morning and then enjoy a free day in Hakone on a self-guided adventure to visit the sights that the Fuji Hakone National Park has to offer. If you would like to make a visit to Mt. Fuji you can organise a day trip on your own from Hakone.'),
(41, 'Skyed1', 38, '', '', 0, 1, 'Leaving Christchurch in the morning, travel through the fertile farmland of the Canterbury Plains to the shores of the stunning, glacier-fed Lake Tekapo, where you can view the solitary Church of the Good Shepherd and take in the sights of the spectacular Southern Alps. Then continue to the location of New Zealand\'s tallest mountain, Aoraki / Mount Cook, situated in a national park and UNESCO World Heritage site.'),
(42, 'skyed2', 38, '', '', 0, 1, 'Although celebrated as New Zealand\'s ‘adventure capital’ Queenstown offers far more than a fast paced action-packed holiday. Settled on the shores of Lake Wakatipu beneath a soaring panorama of the Remarkables Mountain Range, this alpine town is surrounded by a plethora of historic, gastronomic and scenic wonders.'),
(43, 'mexicod1', 40, '', '', 0, 1, 'The first day starts by heading to Tlatelolco, considered the largest archaeological site in Mexico City. Learn about the importance of this place, which was once part of the capital of the Aztec empire.\r\n\r\nNext, the tour continues to the Basilica of Guadalupe. This is the building most important religious in Mexico and one of the most visited in the Catholic world.\r\n\r\nReceive more than twenty million pilgrims a year.'),
(44, 'mexicod2', 40, '', '', 0, 1, 'The second day we will go to Xochimilco “World Heritage” we invite you to enjoy a tour of its canals, on board a trajinera, to evoke those times when the lake environment dominated the landscape of Anahuac.\r\n\r\nWe will pass through the colonial district of Coyoacán, you will also explore the world of the famous painter Mexican Frida Kahlo.'),
(45, 'mexicod3', 40, '', '', 0, 1, 'On the third day you will visit the Anthropology Museum, where you’ll get to admire some of the pieces amongst the vast collection of pre-hispanic art inside of the museum.\r\n\r\nOur guide will explain pieces like the Sun Stone, also called the Aztec calendar; the Coatlicue,and several other pieces that reflected the thought, lifestyle and religion of the differfent civilizations developed inside the ancient Mexico.'),
(46, 'Romed1', 39, '', '', 0, 1, 'Taste a black hard-boiled egg, a Hakone speciality that is believed to add 7 years to your life! Enjoy an exciting pirate-ship boat ride across Lake Ashinoko, formed by a volcanic eruption nearly 3,000 years ago. The Hakone Tozan “switchback train” with take you through the mountains zig-zagging its way through the scenic hills and valleys with breathtaking views.'),
(47, 'Romed2', 39, '', '', 0, 1, 'Have breakfast at your accommodation this morning and then check-out. You will depart Hakone today and make your own way back to Tokyo with your included transportation of your Hakone Free Pass. Your trip will come to an end upon arrival to the Tokyo Shinjuku Station.'),
(48, 'hightlightd1', 41, '', '', 0, 1, 'Arrive in Auckland at any time. There are no planned activities during the day, so check into the hotel and explore the city. If you arrive early enough, opt to visit the Maritime Museum, walk the waterfront, or even take the ferry to Waiheke Island.'),
(49, 'hightlightd2', 41, '', '', 0, 1, 'Travel backroads to a remote conservation farm where they are using natural means to boost the stocks of traditionally farmed marine life. Farmers have created a balanced ecosystem to attract native birds and animals back to the area.'),
(50, 'VtoSd1', 43, '', '', 0, 1, 'Stop en route at Waitomo. Enjoy free time to visit the Waitomo Caves, famous for their glow-worms and adventure activities, or explore this scenic area by foot.\r\nContinue to Rotorua for an engaging cultural experience on the grounds of a historic Maori village.\r\nAccommodation:\r\n- Rock Solid Backpackers Rotorua (or similar).\r\nMeals Included:\r\n- Breakfast'),
(51, 'VtoSd2', 43, '', '', 0, 1, 'Travelling to Taupo on a clear day is nothing short of breathtaking. From the shores of the lake to the snow capped peaks of Tongariro National Park in the distance, there will be no shortage of photo opportunities. Then, once again, the day is yours so take advantage of the adrenaline capital of the North Island and book some fun activities with your fellow adrenaline junkie friends. Get sprayed with water as you whitewater raft, soak in serenity in thermally heated pools, or stroll downtown in search of something tasty to try.'),
(52, 'Sedonad1', 44, '', '', 0, 1, 'We start out nice and early (8am from Castle Rock Hostel) to make the most of the daylight and head straight into the heart of the snow capped Highlands - Experience tales of Clan rebellion, romance and betrayal, beauty and brutality in stark contrast to each other as you step into the history steeped and snowy silent Highlands. George R.R. Martin has nothing on Scottish history. We stop off for some whisky tasting to take away the chill before heading to Loch Ness for drinks and a night of laughs and relaxation. 8am start from Castle Rock Hostel. Getting to know your guide and group. Forth Bridges. Dunkeld. Hermitage/Killiecrankie. Clava Cairns. Sleep on the shores of Loch Ness!'),
(53, 'Sedonad2', 0, '', '', 0, 1, 'We set off for a cheeky wee bit of Nessie hunting, and a bracing swim for the very, VERY brave among the group. Battlefields, Glens, Lochs and Castles are today\'s agenda as we make our way deeper into the Highlands across the Corrieshalloch Gorge and take in the beautiful scenery of Torridon before crossing the water to the Isle of Skye!. Rogie Falls. Corrieshalloch Gorge. Kinlochewe. Torridon. Eilean Donan Castle. Kyleakin'),
(54, 'Sedonad2', 0, '', '', 0, 1, 'Stop en route at Waitomo. Enjoy free time to visit the Waitomo Caves, famous for their glow-worms and adventure activities, or explore this scenic area by foot.\r\n\r\nContinue to Rotorua for an engaging cultural experience on the grounds of a historic Maori village.'),
(55, 'Sedonad2', 44, '', '', 0, 1, 'Stop en route at Waitomo. Enjoy free time to visit the Waitomo Caves, famous for their glow-worms and adventure activities, or explore this scenic area by foot.\r\n\r\nContinue to Rotorua for an engaging cultural experience on the grounds of a historic Maori village.'),
(56, 'Cayond1', 45, '', '', 0, 1, 'Check into your hotel. In the afternoon, there’s time to rest or discover Scotland’s great cultural city. This evening, meet your Tour Director and traveling companions for dinner at the hotel.'),
(57, 'Cayond2', 45, '', '', 0, 1, 'Start your day with an orientation drive taking in the fine 12th-century cathedral, imposing university buildings, and elegant Georgian squares. Then, head into The Trossachs National Park and enjoy views of rugged hills and beautiful lochs. Pause in Aberfoyle before continuing on to Stirling where you will have time to admire the castle, a great symbol of Scottish independence and favored residence of Scotland’s kings and queens. After arrival in Edinburgh, why not join an optional excursion: a traditional Scottish night out with Highland dancers, bagpipers, and of course, the Ceremony of the Haggis?'),
(58, 'Alaskad1', 46, '', '', 0, 1, 'A full day\'s adventure lies ahead exploring the incredible Isle of Skye as we set off from Kyleakin around the island that has inspired countless artists and creators. Crammed with stunning vistas, breathtaking hikes and entrancing tales of warriors, monsters and faeries. Spend most of the day off the bus getting amongst it!\r\nSligachan The Cuillin Faerie Pools Portree Old Man of Storr Kilt Rock The Quiraing'),
(59, 'Alaskad2', 46, '', '', 0, 1, 'We depart Edinburgh in the morning and set off on our adventure, a full day of exploration and excitement ahead. We strike out into the Highlands seeking out spectacular scenery, clan rivalry and the odd monster.\r\nForth Bridges Pitlochry/Dunkeld Whisky Drinking Highland Folk Museum Culloden Battlefield Loch Ness Glen Shiel Eilean Donan Castle Kyleakin'),
(60, 'Southwestd1', 47, '', '', 0, 1, 'We start out nice and early (8am from Castle Rock Hostel) to make the most of the daylight and head straight into the heart of the snow capped Highlands - Experience tales of Clan rebellion, romance and betrayal, beauty and brutality in stark contrast to each other as you step into the history steeped and snowy silent Highlands. George R.R. Martin has nothing on Scottish history. We stop off for some whisky tasting to take away the chill before heading to Loch Ness for drinks and a night of laughs and relaxation. 8am start from Castle Rock Hostel'),
(61, 'Southwestd2', 47, '', '', 0, 1, 'Winter scenery provides a perfect backdrop for our full day on Skye.We will hike up to one of the islands more distinctive rock formations, the Old Man of Storr, with some of the finest viewpoints anywhere in the world. Tonight its off to the local for some Christmas Eve entertainment! (And a cheeky dram or seven...). Sligachan. Cuillin Ridge. Portree. The Old Man of Storr. Kilt Rock. Quiraing. Faerie Pools. Kyleakin'),
(62, 'Sedonad3', 47, '', '', 0, 1, 'Taking it easy (mind the hangovers!), we say goodbye to the misty isle and head south taking in views of the Nevis range and Britain’s highest mountain, Ben Nevis. We’ll discover the haunting beauty of Glen Coe and hear tales of clan massacres before continuing our journey through ‘braveheart country’ and onwards to Edinburgh for some heartfelt goodbyes. Ben Nevis. Fort William. Glen Coe. Rannoch Moor. Doune Castle. Wallace Monument'),
(63, 'Helid1', 50, '', '', 0, 1, 'As you head south, watch as mountain views begin to morph into swamps, plantations and palms. Beautiful scenery will constantly be flying by your window as you make your way to your campsite for the night. Then there\'s only one thing left to do: devour s\'mores around a roaring campfire. What are s\'mores? Melted chocolate and marshmallow heated over a fire and sandwiched between two crackers. We\'re pretty sure it\'ll be the best thing you\'ve ever tasted!'),
(64, 'Helid2', 50, '', '', 0, 1, 'After breakfast, set out for St Andrews. Along the way, breathe in the sea air as you travel along the Eastern peninsula of Fife, previously home to monarchs for more than 500 years and is now teeming with rolling green farmland and delightful villages. Here, you will stop in the charming fishing town of Crail. Later, retire to your luxurious five-star accommodation in St Andrews. This evening, choose your dining.'),
(65, 'Bangkok Stopoverd1', 51, '', '', 0, 1, 'Leave the city behind this morning and venture into a world of lakes and glaciers in the epic Alaska Range. Head north along the Parks Highway to Denali National Park (approximately 5 hours), keeping an eye out for caribou as you go. Home to the highest peak in the United States known as Denali (Mount McKinley), as well as grizzly bears, wolves, moose and Dall sheep, this national park is a true wilderness with endless snowy peaks. Accommodation: Camping (with facilities)'),
(66, 'Bangkok Stopoverd2', 51, '', '', 0, 1, 'Today, embark on a fascinating walking discovery of St Andrews, taking in sights of the University of St Andrews and its beautiful grounds including colleges of St Mary’s and St Salvator’s, as well as the Museum of the University of St Andrews (MUSA). The rest of the day is at leisure for you to explore. Tonight, you might like to try the local dining scene.'),
(67, 'Bangkok Stopoverd3', 51, '', '', 0, 0, 'Wake from your peaceful slumber and take a canoe back to the lodge in the morning. Today is a big travel day, with approximately 8 hours total driving time, but it\'s also a really beautiful drive with plenty of wildlife and some great views along the way. You\'ll leave the main highway and start to head deep into Wrangell-St Elias National Park: the largest national park in the USA, being almost six times the size of Yellowstone. The evening is free once you\'ve arrived at the campsite, so take a hike and do some exploring, or just kick back and soak up the camp vibes. Accommodation: Camping (with basic facilities)');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_location`
--
DROP TABLE IF EXISTS `tbpro_location`;
CREATE TABLE `tbpro_location` (
`id` int(11) NOT NULL,
`country_id` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`country_code` varchar(10) NOT NULL,
`banner` varchar(400) NOT NULL,
`image_location_avatar` varchar(400) NOT NULL,
`map_image` varchar(400) NOT NULL,
`mobile` varchar(50) NOT NULL,
`address` varchar(200) NOT NULL,
`iframe` text 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;
--
-- Dumping data for table `tbpro_location`
--
INSERT INTO `tbpro_location` (`id`, `country_id`, `name`, `country_code`, `banner`, `image_location_avatar`, `map_image`, `mobile`, `address`, `iframe`, `alias`, `state_id`, `lang`, `lat`, `published`, `ordering`, `image`, `description`) VALUES
(17, 0, 'Versailles', 'VNM', '', '', '', '+33 06 23 12 45 54', 'Versailles, France', '<iframe src="https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d10511.185482571464!2d2.1203554!3d48.8048649!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x538fcc15f59ce8f!2zTMOidSDEkcOgaSBWZXJzYWlsbGVz!5e0!3m2!1svi!2s!4v1585899729105!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 9, '', '', 0, 0, '', 'The Palace of Versailles has been listed as a World Heritage Site for 30 years and is one of the greatest achievements in French 17th century art. Louis XIII\'s old hunting pavilion was transformed and extended by his son, Louis XIV, when he installed the Court and government there in 1682. A succession of kings continued to embellish the Palace up until the French Revolution.\r\n\r\nIn 1789, the French Revolution forced Louis XVI to leave Versailles for Paris. The Palace would never again be a royal residence and a new role was assigned to it in the 19th century, when it became the Museum of the History of France in 1837 by order of King Louis-Philippe, who came to the throne in 1830. The rooms of the Palace were then devoted to housing new collections of paintings and sculptures representing great figures and important events that had marked the History of France. These collections continued to be expanded until the early 20th century at which time, under the influence of its most eminent curator, Pierre de Nolhac, the Palace rediscovered its historical role when the whole central part was restored to the appearance it had had as a royal residence during the Ancien Régime.\r\n\r\n '),
(18, 0, 'Buton Island', 'IDN', '', '', '', '+62 85396908251', 'Buton Island, South East Sulawesi, Indonesia', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3966.3056304169445!2d106.80649301476913!3d-6.223371695495003!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e69f151bcf7200f%3A0x6ee40b271a82586a!2sIndonesia%20Stock%20Exchange!5e0!3m2!1svi!2s!4v1584495744222!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 10, '', '', 0, 0, '', 'Any prospective traveler would enter Buton Island through Baubau, an hour’s flight from the South Sulawesi capital of Makassar.\r\n\r\nBaubau, the island’s capital, is a bustling little town and pretty developed (but not commercialized) for its tourism.\r\n\r\nBaubau sports lovely beaches all along its coast and on the surrounding uninhabited islets. The most well-known among these is Nirwana Beach on the main island, a long stretch of beach bookended by short cliffs and usually the prime holiday destination for locals and tourists alike.\r\n\r\nAnother significant destination on the island is Desa Tenun (weaving village), famed for its weaving and woven textiles.\r\n\r\nThe village’s houses, most of which retain the traditional architecture, are painted in bright, loud colors that are also distinctive to the woven fabrics of Buton.\r\n\r\n '),
(19, 0, 'Ha Long', 'VNM', '', '', '', '+84 934747562', 'Ha Long, Quang Ninh, Vietnam', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d238637.4487194976!2d107.00954203101978!3d20.843408353365028!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x314a5796518cee87%3A0x55c6b0bcc85478db!2zVuG7i25oIEjhuqEgTG9uZw!5e0!3m2!1svi!2s!4v1585134606379!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 11, '', '', 0, 0, '', 'The city\'s economy has recently[when?] switched from coal mining to tourism, due to the large number of visitors drawn by the Hạ Long Islets every year. At present,[when?] Hạ Long is experiencing rapid growth not only in tourism sphere, but as a place upon the main road to southern China. In 2007 Vietnam-China Business Forum, a $400 million deal was signed to build a highway linking Hạ Long, Móng Cái and Quảng Ninh.\r\n\r\nHạ Long city is divided into two parts: East Hạ Long and West Hạ Long. The eastern part, Hòn Gai, where most of the official buildings and industry are concentrated, is connected by bridge with the western part, Bãi Cháy, considered to be more of a tourism attraction.\r\n\r\nThe biggest hotel in Vietnam is planned to be built on the bay, beginning from 2007.\r\n\r\n '),
(20, 0, 'Mount Fuji', 'VNM', '', '', '', '+81 6 4536 8675', 'Near the Pacific Ocean coast in Yamanashi and Shizuoka ken (prefectures) of central Honshu, about 60 miles (100 km) west of the Tokyo-Yokohama metropolitan area.', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3241.7477985333253!2d139.74324421560047!3d35.658584838820325!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x60188bbd9009ec09%3A0x481a93f0d2a409dd!2sTh%C3%A1p%20Tokyo!5e0!3m2!1svi!2s!4v1584495930233!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 12, '', '', 0, 0, '', 'Mount Fuji (富士山, Fujisan) is with 3776 meters Japan\'s highest mountain. It is not surprising that the nearly perfectly shaped volcano has been worshiped as a sacred mountain and experienced big popularity among artists and common people throughout the centuries.\r\n\r\nMount Fuji is an active volcano, which most recently erupted in 1707. It stands on the border between Yamanashi and Shizuoka prefectures and can be seen from Tokyo and Yokohama on clear days.\r\n\r\nAnother easy way to view Mount Fuji is from the train on a trip between Tokyo and Osaka. If you take the shinkansen from Tokyo in direction of Nagoya, Kyoto and Osaka, the best view of the mountain can be enjoyed from around Shin-Fuji Station on the right hand side of the train, about 40-45 minutes into the journey.\r\n\r\nNote however, that clouds and poor visibility often block the view of Mount Fuji, and you have to consider yourself lucky if you get a clear view of the mountain. Visibility tends to be better during the colder seasons of the year than in summer, and in the early morning and late evening hours than during the middle of the day.\r\n\r\nIf you want to enjoy Mount Fuji at a more leisurely pace and from a nice natural surrounding, you should head to the Fuji Five Lake (Fujigoko) region at the northern foot of the mountain, or to Hakone, a nearby hot spring resort. Mount Fuji is officially open for climbing during July and August via several routes.\r\n\r\n '),
(21, 0, 'Champs-Elysées', 'VNM', '', '', '', '', 'Champs-Elysées, Paris France', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d5248.940112091356!2d2.3043990286906446!3d48.86831507450493!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x47e66fc518637631%3A0x7c6b92d2c2465999!2zQ2hhbXBzLcOJbHlzw6llcywgUGEgcmksIFBow6Fw!5e0!3m2!1svi!2s!4v1585219073159!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 9, '', '', 0, 0, '', 'The Avenue des Champs-Élysées needs no introduction. A fixture on the list of the French capital’s top attractions, it is visited each day by nearly 300,000 people, who come to admire its majestic monuments, enjoy a shopping spree, or get caught up in the excitement of the major festive events that are organized here. There’s always something going on here, along the world’s most beautiful avenue, by day or by night.\r\n\r\n '),
(22, 0, 'San Francisco', 'VNM', '', '', '', '', 'San Francisco, CA, USA', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3152.2167428390203!2d-122.41186708435792!3d37.80839191799702!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x808580fb7e2e4e9b%3A0x26fe89c5cc5cbf8e!2sSan%20Francisco!5e0!3m2!1svi!2s!4v1585219396316!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 14, '', '', 0, 0, '', 'San Francisco, city and port, coextensive with San Francisco county, northern California, U.S., located on a peninsula between the Pacific Ocean and San Francisco Bay. It is a cultural and financial centre of the western United States and one of the country’s most cosmopolitan cities. Area 46 square miles (120 square km). Pop. (2000) 776,733; San Francisco–San Mateo–Redwood City Metro Division, 1,731,183; San Francisco–Oakland–Fremont Metro Area, 4,123,740; (2010) 805,235; San Francisco–San Mateo–Redwood City Metro Division, 1,776,095; San Francisco–Oakland–Fremont Metro Area, 4,335,391.\r\n\r\n '),
(23, 0, 'Sixth Avenue', 'VNM', '', '', '', '', 'Sixth Avenue, NewYork, NY, USA', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3022.869042344132!2d-73.9949864842973!3d40.742907043660395!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c25a200c80098b%3A0x5d67779a4ec44d11!2zNnRoIEF2ZSwgTmV3IFlvcmssIE5ZLCBIb2EgS-G7sw!5e0!3m2!1svi!2s!4v1585219468812!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 15, '', '', 0, 0, '', 'Sixth Avenue – also known as Avenue of the Americas, although this name is seldom used by New Yorkers – is a major thoroughfare in New York City\'s borough of Manhattan, on which traffic runs northbound, or \"uptown\". It is commercial for much of its length.\r\n\r\n '),
(24, 0, 'Lake Tahoe', 'VNM', '', '', '', '', 'Located 1,897 meters atop the majestic Sierra Nevada mountain range on the California and Nevada border', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d198181.90350084036!2d-120.18505163166557!3d39.09298471602523!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x809978a1b91f1151%3A0x8c3f1fafeeafb520!2zSOG7kyBUYWhvZQ!5e0!3m2!1svi!2s!4v1585219569082!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 14, '', '', 0, 0, '', 'Located 1,897 meters atop the majestic Sierra Nevada mountain range on the California and Nevada border, Lake Tahoe is widely considered one of the most beautiful places in the world. This natural treasure offers the ultimate high-country experience with superb outdoor recreation and magnificent scenery throughout the year.\r\n\r\n '),
(25, 0, 'Yeouido', 'VNM', '', '', '', '', '330, Yeouidong-ro, Yeongdeungpo-gu, Seoul, South Korea', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3164.2139711628283!2d126.931849835219!3d37.526453089197794!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x357c9f47ec02ef6f%3A0x279df9ba732c1f53!2s330%20Yeouidong-ro%2C%20Yeoeuido-dong%2C%20Yeongdeungpo-gu%2C%20Seoul%2C%20H%C3%A0n%20Qu%E1%BB%91c!5e0!3m2!1svi!2s!4v1585219632260!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 16, '', '', 0, 0, '', 'Situated in Yeouido, the heart of politics, media, banking and finance, Yeouido Hangang Park is easily accessible via public transportation. As one of the most popular parks along Hangang River, the park attracts many visitors, residents, and office workers.\r\n\r\n '),
(26, 0, 'Hawaii', 'VNM', '', '', '', '', 'Hawaii, Hawaii,US', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d286583.0632063752!2d-155.51968954388963!3d19.30771506793258!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x795161b6c0b9c9b1%3A0x3e5b7b263c84ae26!2zVsaw4budbiBxdeG7kWMgZ2lhIE7DumkgbOG7rWEgSGF3YWlp!5e0!3m2!1svi!2s!4v1585219681312!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 17, '', '', 0, 0, '', 'Hawaii (Hawaiian: Hawai‘i) is a group of volcanic islands in the central Pacific Ocean. The islands lie 2,397 miles from San Francisco, California, to the east and 5,293 miles from Manila, in the Philippines, to the west. The capital is Honolulu, located on the island of Oahu. The islands were annexed by the United States in 1900, and as a U.S. territory saw population expansion and the establishment of a plantation system for growing sugar cane and pineapples. On the morning of December 7, 1941, hundreds of Japanese fighter planes attacked the American naval base at Pearl Harbor near Honolulu. The surprise attack destroyed nearly 20 vessels, killed more than 2,000 American soldiers and propelled the United States into World War II. Hawaii became the 50th U.S. state on August 21, 1959.\r\n\r\n '),
(27, 0, 'Westminster Abbey', 'VNM', '', '', '', '', 'Westminster Abbey CHURCH, LONDON, UNITED KINGDOM', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d1241.8769574605785!2d-0.12866924164831792!3d51.499383214646!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x487604c4ba43352f%3A0xda8effa2059b537a!2sTu%20vi%E1%BB%87n%20Westminster!5e0!3m2!1svi!2s!4v1585219729579!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 13, '', '', 0, 0, '', 'Westminster Abbey, London church that is the site of coronations and other ceremonies of national significance. It stands just west of the Houses of Parliament in the Greater London borough of Westminster. Situated on the grounds of a former Benedictine monastery, it was refounded as the Collegiate Church of St. Peter in Westminster by Queen Elizabeth I in 1560. In 1987 Westminster Abbey, St. Margaret’s Church, and the Houses of Parliament were collectively designated a UNESCO World Heritage site.\r\n\r\n '),
(28, 0, 'Khartoum', 'VNM', '', '', '', '', 'Khartoum, Sudan', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3843.073343319486!2d32.52239621534454!3d15.587729756300357!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x168e8e3d41d03913%3A0xe61911ed4032aabd!2sKhartoum%20Sudan!5e0!3m2!1svi!2s!4v1585219780635!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 18, '', '', 0, 0, '', 'Khartoum, Arabic Al-Khurṭūm, (“Elephant’s Trunk”), city, executive capital of Sudan, just south of the confluence of the Blue and White Nile rivers. It has bridge connections with its sister towns, Khartoum North and Omdurman, with which it forms Sudan’s largest conurbation. Originally an Egyptian army camp (pitched 1821), Khartoum grew into a garrisoned army town. The Mahdists besieged and destroyed it in 1885 and killed Major General Charles George Gordon, then the British governor-general of the Sudan. Reoccupied in 1898, Khartoum was rebuilt by Governor-General Lord Kitchener and served as the seat of the Anglo-Egyptian Sudan government until 1956, when the city became the capital of the independent republic of Sudan.\r\n\r\n '),
(29, 0, 'Nouakchott', 'VNM', '', '', '', '', 'Nouakchott, Mauritania', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3792.6618122000336!2d-15.968973084636987!3d18.08720413700338!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0xe96528101df8721%3A0x4d3b6bec3cf9de2a!2sMauritanian%20Airways%2C%20Nouakchott%2C%20M%C3%B4-ri-ta-ni!5e0!3m2!1svi!2s!4v1585219828183!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 19, '', '', 0, 0, '', 'Nouakchott, city, capital of Mauritania, on a plateau near the West African Atlantic coast, about 270 miles (435 km) north-northeast of Dakar, Senegal. Originally a coastal village on the desert trail north from Dakar, it was developed after independence (1960) as the capital of the new nation. Nouakchott was a major refugee centre during the Saharan droughts of the 1970s, and its rapid growth during that period (together with a sharp decline in the number of Mauritania’s nomads) was attributed to migration and urbanization in response to the droughts. The city focuses on a square, the Place de l’Indépendence, and includes an airport and industrial area. It is centrally located on the main north-south highway, connecting the more populated agricultural south with the sparsely populated but mineral-rich north. A port facility has been built about 5 miles (8 km) west for the export of petroleum and copper. The copper is mined near Akjoujt (120 miles (195 km) northeast). While there has been a steady increase in the port’s activity, the level of traffic remains below that of the more northern port of Nouadhibou. The University of Nouakchott was founded in 1981. Pop. (2000) 558,195; (2005 est.) 743,500.\r\n\r\n '),
(30, 0, 'Bangkok', 'VNM', '', '', '', '', 'Bangkok, Thailand', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3875.205178551791!2d100.57158071533387!3d13.766496900660577!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x30e29e880e4a0e63%3A0x46d2ae2c185387dd!2sThailand%20Cultural%20Centre!5e0!3m2!1svi!2s!4v1585219908649!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 21, '', '', 0, 0, '', 'Bangkok, Thai Krung Thep, city, capital, and chief port of Thailand. It is the only cosmopolitan city in a country of small towns and villages and is Thailand\'s cultural and commercial centre. Bangkok is located on the delta of the Chao Phraya River, about 25 miles (40 km) from the Gulf of Thailand.\r\n\r\n '),
(31, 0, 'Chiang Mai', 'VNM', '', '', '', '', 'Chiang Mai, Mueang Chiang Mai District, Chiang Mai, Thailand', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d60433.374730528616!2d98.92145779648094!3d18.794323891486112!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x30da3a7e90bb6f5d%3A0x98d46270a59b4367!2zVGjDoG5oIHBo4buRIENoaWFuZyBNYWksIE11ZWFuZyBDaGlhbmcgTWFpLCBDaGnhu4FuZyBNYWksIFRow6FpIExhbg!5e0!3m2!1svi!2s!4v1585219950860!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 22, '', '', 0, 0, '', 'Chiang Mai is the largest and most culturally significant city in northern Thailand, and is the capital of Chiang Mai Province. It is located 700 km (435 mi) north of Bangkok, among the highest mountains in the country. The city is on the Ping river, a major tributary of the Chao Phraya river\r\n\r\n '),
(32, 0, 'Beijing China Railway Express Co', 'VNM', '', '', '', '', 'Beijing China Railway Express Co., Ltd. (Eastern District Branch), Chaoyang, Beijing, China', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3059.82368245196!2d116.45680261568519!3d39.92296179344408!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x35f1acfa0d205bb5%3A0x533c098511ff7ef2!2sBeijing%20China%20Railway%20Express%20Co.%2C%20Ltd.%20(Eastern%20District%20Branch)%2C%20Chaoyang%20Qu%2C%20Beijing%20Shi%2C%20Trung%20Qu%E1%BB%91c!5e0!3m2!1svi!2s!4v1585219988297!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 23, '', '', 0, 0, '', 'Beijing, Jing for short, is a metropolis in northern China and the capital of China. Lying 70 mi (102 km) west of Bohai Sea, it borders Hebei Province to the north, west, south, and for a small section in the east and Tianjin to the southeast. This city is a major transportation hub, with dozens of railways, roads and motorways passing through the city. It is also the destination of many international flights arriving in China. It is regarded as the political, educational, and cultural center of China.\r\n\r\n '),
(33, 0, 'Phnom Penh', 'VNM', '', '', '', '', 'Phnom Penh, Cambodia', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3909.211862427514!2d104.95392301532355!3d11.536654447853977!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x31095766df2aa573%3A0x3e2f58723e428ea5!2sCambodia%20Airways%20Stadium!5e0!3m2!1svi!2s!4v1585220030522!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 24, '', '', 0, 0, '', 'Phnom Penh is the capital and largest city of Cambodia. It is a center of security, politics, economics, cultural heritage, and diplomacy. The Capital was additionally modified its boundary in four stages\r\n\r\n '),
(34, 0, 'Kamloops', 'VNM', '', '', '', '', 'Kamloops, BC, Canada', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2529.6774263811644!2d-120.3722606840594!3d50.65168168072535!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x537e2c722beab01b%3A0xc624b7cbc769d444!2sCanadas%20Best%20Value%20Inn%20Kamloops!5e0!3m2!1svi!2s!4v1585220068752!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 25, '', '', 0, 0, '', 'Kamloops is located at the crossroads of the Coquihalla Highway, Yellowhead Highway, and Trans-Canada Highway. The Kamloops Airport is a 15-minute drive from downtown, the cultural hub of the city. It’s easy to get here.\r\n\r\n '),
(35, 0, 'Vancouver', 'VNM', '', '', '', '', 'Vancouver, BC, Canada', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2602.3438979382136!2d-123.11330958409499!3d49.28882827825583!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x5486719d24e2e021%3A0xb7057fe085c86109!2sCanada%20Place!5e0!3m2!1svi!2s!4v1585220115322!5m2!1svi!2s" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', 25, '', '', 0, 0, '', 'Vancouver, city, southwestern British Columbia, Canada. It is the major urban centre of western Canada and the focus of one of the country’s most populous metropolitan regions. Vancouver lies between Burrard Inlet (an arm of the Strait of Georgia) to the north and the Fraser River delta to the south, opposite Vancouver Island. The city is just north of the U.S. state of Washington. It has a fine natural harbour on a superb site facing the sea and mountains. Pop. (2011) 603,502; metro. area, 2,313,328; (2016) 631,486; metro. area, 2,463,431.\r\n\r\n '),
(36, 0, 'New Delhi', 'IND', '', '', '', '', '', '', '', 0, '', '', 0, 0, '', ''),
(37, 0, 'Japan', 'JPN', '', '', '', '', 'Japan\'s Fuji-Hakone-Izu National Park west of Tokyo', '', '', 12, '', '', 0, 0, '', ''),
(38, 0, 'mexico', 'VNM', '', '', '', '', '', '', '', 26, '', '', 0, 0, '', ''),
(39, 0, 'Las Vegas', 'ASM', '', '', '', '', 'Sedona, Monument Valley & Antelope Canyon', '', '', 27, '', '', 0, 0, '', ''),
(40, 0, 'Ninh Binh', 'VNM', '', '', '', '', 'Ninh Binh Viet Nam', '', '', 28, '', '', 0, 0, '', ''),
(41, 0, 'Sapa', 'VNM', '', '', '', '', 'North Vietnam', '', '', 29, '', '', 0, 0, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_notification`
--
DROP TABLE IF EXISTS `tbpro_notification`;
CREATE TABLE `tbpro_notification` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order`
--
DROP TABLE IF EXISTS `tbpro_order`;
CREATE TABLE `tbpro_order` (
`id` int(11) NOT NULL,
`type` varchar(255) 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,
`adult_number` int(11) NOT NULL,
`children_number` int(11) NOT NULL,
`infant_number` int(11) NOT NULL,
`created_date` datetime NOT 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,
`total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_orderpackage`
--
DROP TABLE IF EXISTS `tbpro_orderpackage`;
CREATE TABLE `tbpro_orderpackage` (
`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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order_customer`
--
DROP TABLE IF EXISTS `tbpro_order_customer`;
CREATE TABLE `tbpro_order_customer` (
`id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`alias` varchar(200) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order_detail`
--
DROP TABLE IF EXISTS `tbpro_order_detail`;
CREATE TABLE `tbpro_order_detail` (
`id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`tour_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,
`adult` int(11) NOT NULL,
`children` int(11) NOT NULL,
`infant` int(11) NOT NULL,
`params` mediumtext NOT NULL,
`quantity` int(11) NOT NULL,
`subtotal` float NOT NULL,
`total` float NOT NULL,
`total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order_detail_rate`
--
DROP TABLE IF EXISTS `tbpro_order_detail_rate`;
CREATE TABLE `tbpro_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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order_package_rate`
--
DROP TABLE IF EXISTS `tbpro_order_package_rate`;
CREATE TABLE `tbpro_order_package_rate` (
`id` int(11) NOT NULL,
`order_package_id` int(11) NOT NULL,
`service_id` int(11) NOT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`location_id` int(11) NOT NULL,
`employee_id` int(11) NOT NULL,
`price` int(11) NOT NULL,
`params` mediumtext NOT NULL,
`subtotal` float NOT NULL,
`rate_id` int(11) NOT NULL,
`total` float NOT NULL,
`total_tax` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_order_status`
--
DROP TABLE IF EXISTS `tbpro_order_status`;
CREATE TABLE `tbpro_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;
--
-- Dumping data for table `tbpro_order_status`
--
INSERT INTO `tbpro_order_status` (`id`, `name`, `title`, `ordering`, `alias`, `data`) VALUES
(4, 'pending', 'Pending', 0, '', ''),
(5, 'complete', 'Complete', 0, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_package`
--
DROP TABLE IF EXISTS `tbpro_package`;
CREATE TABLE `tbpro_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;
--
-- Dumping data for table `tbpro_package`
--
INSERT INTO `tbpro_package` (`id`, `image`, `name`, `params`, `price`, `published`, `package_color`, `description`, `ordering`) VALUES
(2, 'blocks/block_priceplanclass/assets/images/the-member1.png', 'Silver members12', '{\"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\"}', 78, 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),
(5, 'blocks/block_priceplanclass/assets/images/the-member1.png', 'Silver members321', '{\"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, '', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_package_event`
--
DROP TABLE IF EXISTS `tbpro_package_event`;
CREATE TABLE `tbpro_package_event` (
`id` int(11) NOT NULL,
`package_id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_package_tag`
--
DROP TABLE IF EXISTS `tbpro_package_tag`;
CREATE TABLE `tbpro_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;
--
-- Dumping data for table `tbpro_package_tag`
--
INSERT INTO `tbpro_package_tag` (`id`, `package_id`, `tag_id`, `description`) VALUES
(7, 35, 14, ''),
(8, 36, 14, ''),
(9, 37, 14, ''),
(16, 2, 3, ''),
(17, 2, 4, '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_payment`
--
DROP TABLE IF EXISTS `tbpro_payment`;
CREATE TABLE `tbpro_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;
--
-- Dumping data for table `tbpro_payment`
--
INSERT INTO `tbpro_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', 1, 'upload/payment/images/01 Oct 1995Screenshot_38.png', '', 0, 'null', 1, '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_rate`
--
DROP TABLE IF EXISTS `tbpro_rate`;
CREATE TABLE `tbpro_rate` (
`id` int(11) NOT NULL,
`type` varchar(50) NOT NULL,
`object_id` int(11) NOT NULL,
`from` datetime NOT NULL,
`to` datetime NOT NULL,
`ordering` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_season`
--
DROP TABLE IF EXISTS `tbpro_season`;
CREATE TABLE `tbpro_season` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_season`
--
INSERT INTO `tbpro_season` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Spring', 'upload/seasons/images/cover/season-winter.jpg', '', 5, 1, 'Warm'),
(21, 'Winter', 'upload/seasons/images/cover/season-winter.jpg', '', 9, 1, 'Cold'),
(22, 'Autumn', 'upload/seasons/images/cover/season-winter.jpg', '', 10, 1, 'Cool'),
(70, 'Summer', 'upload/seasons/images/cover/season-winter.jpg', '', 0, 1, 'Hot');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_service`
--
DROP TABLE IF EXISTS `tbpro_service`;
CREATE TABLE `tbpro_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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_service_employee`
--
DROP TABLE IF EXISTS `tbpro_service_employee`;
CREATE TABLE `tbpro_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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_shipping`
--
DROP TABLE IF EXISTS `tbpro_shipping`;
CREATE TABLE `tbpro_shipping` (
`id` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`email` varchar(50) NOT NULL,
`first_name` varchar(50) NOT NULL,
`company` varchar(255) NOT NULL,
`country` varchar(50) NOT NULL,
`address_1` varchar(255) NOT NULL,
`address_2` varchar(255) NOT NULL,
`postcode` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`title` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_sms`
--
DROP TABLE IF EXISTS `tbpro_sms`;
CREATE TABLE `tbpro_sms` (
`id` int(11) UNSIGNED NOT NULL,
`account_id` varchar(200) NOT NULL,
`auth_token` varchar(200) NOT NULL,
`phonecode` int(5) NOT NULL,
`countrycode` varchar(200) NOT NULL,
`phone_register` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_sms`
--
INSERT INTO `tbpro_sms` (`id`, `account_id`, `auth_token`, `phonecode`, `countrycode`, `phone_register`, `ordering`, `published`, `description`) VALUES
(1, 'AC1aa868a391e0ca3e122a15b823e7e3ba', 'b9b89b59ece98cd94d4849e3df825672', 1, 'USA', '2029534076', 0, 1, 'Twilio account');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_smscontent`
--
DROP TABLE IF EXISTS `tbpro_smscontent`;
CREATE TABLE `tbpro_smscontent` (
`id` int(11) UNSIGNED NOT NULL,
`sms_suplier_id` int(11) NOT NULL,
`title_sms` varchar(200) NOT NULL,
`action_sms` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`content_sms` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_state`
--
DROP TABLE IF EXISTS `tbpro_state`;
CREATE TABLE `tbpro_state` (
`id` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`country_id` int(11) NOT NULL,
`statecode` char(3) NOT NULL,
`code` char(2) NOT NULL,
`published` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_state`
--
INSERT INTO `tbpro_state` (`id`, `name`, `country_id`, `statecode`, `code`, `published`, `ordering`, `image`) VALUES
(9, 'Paris', 76, '', '', 1, 0, ''),
(10, 'Jakarta', 103, '', '', 1, 0, ''),
(11, 'Quang Ninh', 242, '', '', 1, 0, ''),
(12, 'Tokyo', 116, '', '', 1, 0, ''),
(13, 'London', 80, '', '', 1, 0, ''),
(14, 'California', 235, '', '', 1, 0, ''),
(15, 'New York', 235, '', '', 1, 0, ''),
(16, 'Seoul', 123, '', '', 1, 0, ''),
(17, 'Hawaii', 235, '', '', 1, 0, ''),
(18, 'Khartoum', 193, '', '', 1, 0, ''),
(19, 'Nouakchott', 153, '', '', 1, 0, ''),
(21, 'Bangkok', 219, '', '', 1, 0, ''),
(22, 'Chiang Mai', 219, '', '', 1, 0, ''),
(23, ' Beijing', 44, '', '', 1, 0, ''),
(24, 'Phnom Penh', 120, '', '', 1, 0, ''),
(25, 'British Columbia', 40, '', '', 1, 0, ''),
(26, 'mexico', 143, '', '', 0, 0, ''),
(27, 'Las Vegas', 11, '', '', 1, 0, ''),
(28, 'Ninh Binh', 242, '', '', 1, 0, ''),
(29, 'Sapa ', 242, '', '', 1, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_tag`
--
DROP TABLE IF EXISTS `tbpro_tag`;
CREATE TABLE `tbpro_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;
--
-- Dumping data for table `tbpro_tag`
--
INSERT INTO `tbpro_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', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_tour`
--
DROP TABLE IF EXISTS `tbpro_tour`;
CREATE TABLE `tbpro_tour` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`language` varchar(255) NOT NULL,
`group_size` int(5) NOT NULL,
`image` varchar(200) NOT NULL,
`destination_id` int(11) NOT NULL,
`tour_type_id` int(11) NOT NULL,
`activity_id` int(11) NOT NULL,
`duration` int(11) NOT NULL,
`created_date` datetime NOT NULL,
`price` float NOT NULL,
`adult_price` float NOT NULL,
`season_id` int(11) NOT NULL,
`children_price` float NOT NULL,
`infant_price` float NOT NULL,
`alias` varchar(200) NOT NULL,
`is_feature` tinyint(4) NOT NULL,
`highlight` text NOT NULL,
`rating` float NOT NULL,
`included` text NOT NULL,
`excluded` text NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_tour`
--
INSERT INTO `tbpro_tour` (`id`, `name`, `language`, `group_size`, `image`, `destination_id`, `tour_type_id`, `activity_id`, `duration`, `created_date`, `price`, `adult_price`, `season_id`, `children_price`, `infant_price`, `alias`, `is_feature`, `highlight`, `rating`, `included`, `excluded`, `ordering`, `published`, `description`) VALUES
(25, 'Thailand Island Hopper', 'English', 3, 'upload/tours/images/cover/2-6-680x500.jpg', 0, 0, 0, 4, '0000-00-00 00:00:00', 350, 350, 0, 320, 300, '', 1, '\r\n - Experience the thrill of driving your own Tuk Tuk123
\r\n - Delve into culture and indulge in a tribe jungle feast
\r\n - Relax and take a dip under stunning waterfalls
\r\n - Feel gratitude and be blessed by Thai monks
\r\n - Star gaze in the lush mountains of Chiang Mai
\r\n
', 4, '\r\n\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Optional
\r\n - Additional Services
\r\n
', 0, 1, 'See the best of Thailand\'s East and West coast islands as we take you on an epic 14-Day island-hopping adventure. You will discover all the highlights and hidden gems this country has to offer as we start off in Bangkok and head south via Khao Sok National Park to Koh Phangan and Koh Tao where you will take part in loads of amazing island activities before switching to the 1222\r\n\r\nWest coast islands Phi Phi and Phuket. A great way to spend two weeks in this awesome country and a great extension of our 8 Day Thailand Experience.\r\n\r\n '),
(33, 'Palace of Versailles', 'English', 6, 'upload/tours/images/cover/9w9ARBrHParis-196-1024x683.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 200, 200, 0, 180, 150, '', 1, '\r\n - The local hosts are all great storytellers; each one with a different background ranging from history to journalism. They can’t wait to share some unique insights and personal anecdotes with you
\r\n - Want to adjust the route a bit? No problem - your private host can also fully personalize the tour to your preferences and your group\'s wishes!
\r\n
', 0, '\r\n - Private guide
\r\n - A taste of the famous French baguette
\r\n - English-speaking licensed guide, dedicated to you and your party only!
\r\n - Skip the line entrance into the Palace (Hall of Mirrors, Queen\'s Apartment, State Apartments)
\r\n - \"Musical Gardens\" and \"Fountain Show\" included on selected dates.
\r\n
', '\r\n - Hotel pickup and drop-off
\r\n - Food and drinks
\r\n - Gratuities (optional)
\r\n
', 0, 1, 'Paris is one of Europe’s most popular destinations and with that, lines can be long to visit the more popular sites. The last thing you want to do on vacation is to wait in line after line after line. What fun would that be?'),
(34, 'Mountain Fuji, Tokyo', 'Japanese, English', 5, 'upload/tours/images/cover/atfk1DUVTh10_prbig_1827.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 895, 895, 0, 800, 700, '', 1, '\r\n - Flexibility to customize your itinerary to your own preferences
\r\n - Great overview and orientation of the city
\r\n - Private guide for a more personalized experience
\r\n
', 2.5, '\r\n - Local and professional guide
\r\n
', '\r\n - Entrance fees (you and guide) *Kachi kachi ropeway is 800JPY per person
\r\n - Lunch (you and guide)
\r\n - Hotel pickup and drop-off
\r\n - Transportation fee to move around (you and guide) *One day bus pass is 1,000-1,500JPY per person
\r\n
', 0, 1, 'Discover Mt. Fuji, the highest mountain in Japan and listed as the World Heritage in 2013, During full-day tour by air-conditioned coach at Hakone Area which is famous for its natural beauty. Enjoy a breathtaking view of Mt.Fuji through Pirate cruise on Lake Ashi. Visit 5th station of Mt.Fuji at 2,000 meters above ground.\r\nThis tour will take you to the Mt Fuji area, which has earned the title of UNESCO World Heritage site.'),
(35, 'Champs Elysees Walking Tour', 'English', 10, 'upload/tours/images/cover/FvZFDLsv5.jpg', 0, 0, 0, 5, '0000-00-00 00:00:00', 89, 89, 0, 80, 70, '', 1, 'Get settled into one of the world’s most captivating cities with this 3-day welcome package that includes a city tour.', 4, '\r\n - Accommodation
\r\n - Guide
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Meals
\r\n - Optional
\r\n - Additional Services
\r\n
', 0, 1, 'This two-hour tour unveils the hidden history of the most famous avenue in the world – also the widest one in Paris and the unofficial main street of the city. If Paris was built to outshine all the other cities of the world, Avenue Champs Elysées was built to outshine all the streets of the world and of Paris alike.\r\n\r\n \r\n\r\n '),
(36, 'Golden Triangle', 'English', 15, 'upload/tours/images/cover/PVjNb3hoIndia-War-Memorial-arch-New-Delhi-Sir.jpg', 0, 0, 0, 8, '0000-00-00 00:00:00', 599, 599, 0, 499, 700, '', 1, '\r\n - Explore the pulsating city of New Delhi
\r\n - Visit the iconic and sparkling Taj Mahal
\r\n - Experience local life at Dhula Village
\r\n - Uncover the unique pink city of Jaipur
\r\n
', 5, '\r\n - Hotels (6 nts), comfortable tented camp (1 nt)
\r\n - Chief Experience Officer (CEO) throughout, local guides
\r\n - Private vehicle, taxis, auto-rickshaw, cycle-rickshaw
\r\n
', '\r\n - Flight
\r\n - Insurrance
\r\n - Meal
\r\n
', 0, 1, 'This compact Indian journey will introduce you to three very different northern cities and the colourful rural life of Rajasthan. From the hectic pace of Delhi with its bustling markets, magnificent monuments, and colonial past, travel by private transport to Agra and the mesmerizing beauty of the Taj Mahal — truly one of the wonders of the world. Discover why Jaipur is called the Pink City and get a taste of rural life at a Dhula village.'),
(37, 'Hakone Discovery, Gateway to Mt. Fuji 3D/2N', 'Japanese, English', 20, 'upload/tours/images/cover/PiMHplYO0qJZZv47Himalaya-image.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 467, 467, 0, 367, 666, '', 1, '\r\n - Visit the iconic city of Agra
\r\n - Stay in a beautiful royal palace
\r\n - Explore bustling New Delhi
\r\n - Marvel at the shimmering Taj Mahal
\r\n
', 5, '\r\n - 2 nights in a Ryokan-type accommodation (shared bathroom) or hostel (depending on availability)
\r\n - 2 Breakfast(s)
\r\n
', '\r\n - Tour Guide
\r\n - Tour Leader
\r\n - Travel Insurance
\r\n
', 0, 1, 'Start and end in Tokyo! With the self-guided tour Hakone Discovery, Gateway to Mt. Fuji 3D/2N, you have a 3 day tour package taking you through Tokyo, Japan and 2 other destinations in Japan. Hakone Discovery, Gateway to Mt. Fuji 3D/2N includes accommodation in a hostel as well as meals, transport and more'),
(38, 'Skye, The Highlands & Loch Ness - from Edinburgh', 'English', 33, 'upload/tours/images/cover/0kA4Fgcu60477_5df9de9e21512.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 171, 171, 0, 151, 180, '', 1, '\r\n - Spend two nights on the rugged Isle of Skye
\r\n - Snap a photo of Britain’s highest mountain, Ben Nevis.
\r\n - Step back in time with a visit to Eilean Donan Castle
\r\n - See the Black Houses - ancient dwellings of the Scots
\r\n
', 4, '\r\n - Guide
\r\n - Your tour will be conducted by a knowledgeable and friendly English-speaking Driver-Guide
\r\n - Transport
\r\n - Luxury modern air-conditioned MAN or Mercedes Benz coach, no older than 3 years.
\r\n
', '\r\n - Accommodation
\r\n - Insurance
\r\n - Meals
\r\n
', 0, 1, 'Take our three day tour from Edinburgh (departs 09:00) to enjoy the natural beauty and delights of one of Scotland’s favourite islands: The Isle of Skye.'),
(39, 'Rome To Amalfi Coast', 'English', 200, 'upload/tours/images/cover/8L4aKU34102353_0a8d61.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 292, 292, 0, 192, 300, '', 1, '\r\n - Start and end in Rome! With the discovery tour Rome To Amalfi Coast
\r\n - you have a 3 day tour package taking you through Rome, Italy and 5 other destinations in Italy. Rome To Amalfi Coast includes accommodation
\r\n - expert guide, meals, transport and more
\r\n
', 4, '\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n
', 0, 1, 'Want to take your breath away? Well, let’s discover the Amalfi Coast, the pearl of Italy.SEE VESUVIUS, ONLY WITH US!!Enjoy the crystalline waters, the sheer cliffs clinging to the sea, the pebbled beaches and Italian fishing villages. We’ll accompany you to the Blue Grotto on the world-renowned Capri Island, the amazing black sand beach of Positano, and be overwhelmed by the breathtaking view from Vesuvius.\r\n\r\n '),
(40, 'Mexico City - 3 Days', 'English', 99, 'upload/tours/images/cover/fyMPLf1X80890_50dcb0.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 111, 111, 0, 50, 150, '', 1, '\r\n - With the in-depth cultural tour Mexico City - 3 Days
\r\n - 3 day tour package taking you through Mexico City, Mexico
\r\n - 2 other destinations in Mexico. Mexico City !
\r\n
', 4, '\r\n - Guide
\r\n - Transport
\r\n - Additional Services
\r\n
', '', 0, 1, 'Two weeks is barely enough time to thoroughly explore your hometown, let alone a place as fascinating as Mexico. For adventurers on a tight time-budget, this 15-day trip wraps up the must-sees of both islands with a nice little bow. Check out the Coromandel Peninsula\'s gorgeous beaches, hang with the Maori in a traditional village, and get your adrenaline fix in Queenstown. Consider this your New Zealand starter kit.'),
(41, '3 Day Akureyri & Local Highlights', 'English', 19, 'upload/tours/images/cover/VBfb7vui94445_b84f4f0a.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 111, 111, 0, 50, 150, '', 1, '\r\n - Learn to surf New Zealand\'s world-famous waves
\r\n - Experience Maori culture directly from the Maori
\r\n - Kayak to a remote part of Auckland\'s tranquil harbour
\r\n - Enjoy free time to visit the illuminating Waitomo Caves
\r\n
', 4, '\r\n - Accommodation
\r\n - Flights
\r\n - Meals
\r\n
', '', 0, 1, 'Start and end in Akureyri! With the adventure tour 3 Day Akureyri & Local Highlights, you have a 3 day tour package taking you through Akureyri, Iceland and 6 other destinations in Iceland. 3 Day Akureyri & Local Highlights includes accommodation as well as flights, meals.3 Day Akureyri & Local Highlights focuses on the Local Highlights of the Northern part of Iceland with the town of Akureyri as a base. The town is centrally located in North Iceland and therefore perfect for all day trips. We make sure that each day is an adventure that you will be able to share with friends for the rest of your life.'),
(42, 'Paris Getaway 2 Nights', 'English, French', 30, 'upload/tours/images/cover/BBHln8Ze1.jpg', 0, 0, 0, 2, '0000-00-00 00:00:00', 675, 675, 0, 576, 50, '', 1, '\r\n - Enjoy the freedom and flexibility of an independent tour
\r\n - Relax as you cruise past iconic landmarks on the River Seine
\r\n - Marvel at the impressive wonder of the renowned Eiffel Tower
\r\n
', 5, '\r\n - Accommodation
\r\n - Guide
\r\n - Buffet breakfast daily
\r\n - Transport
\r\n
', '\r\n - Flights
\r\n - Insurance is not included.
\r\n
\r\n\r\n
\r\n', 0, 1, 'Start and end in Paris! With the independent tour Paris Getaway 2 Nights, you have a 3 day tour package taking you through Paris, France. Paris Getaway 2 Nights includes accommodation as well as meals, transport and more.'),
(43, 'Vegas to San Fran', 'English', 13, 'upload/tours/images/cover/AUQX8zah62086_a5d10a24.jpg', 0, 0, 0, 6, '0000-00-00 00:00:00', 1065, 1065, 0, 700, 100, '', 1, '\r\n - Drive through Death Valley
\r\n - Walk along the stunning salt flats
\r\n - Explore Yosemite National Park
\r\n - Float down Merced River
\r\n
', 5, '\r\n - Accommodation
\r\n - Guide
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Meals
\r\n
', 0, 1, 'City, coast, hot springs, national parks and a whole load of wide-open roads – take on Vegas to San Fran in just six days with a Lonely Planet Experience, powered by Intrepid. Stop by Sierra Nevada to soak in local hot springs and pass by Mono and Tenaya lakes on your way to the extraordinary Yosemite National Park. With two full days spent here, marvel at Half Dome and hike the Hetch Hetchy Valley with your small group, plus reap the benefits of the freedom to explore at your own pace. Once you wind up along the culture-filled harbourside of San Francisco, you’ll have found your calling. The Western USA is a place for dreamers – let one be you.\r\n\r\n '),
(44, 'Sedona, Monument Valley & Antelope Canyon Experience 3D/2N (from Las Vegas)', 'English', 20, 'upload/tours/images/cover/V1RCmqFz92355_7ed8248b.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 592, 592, 0, 400, 10, '', 1, '\r\n - Start and end in Las Vegas! With the adventure tour Sedona, Monument Valley & Antelope Canyon Experience 3D/2N (from Las Vegas)
\r\n - You have a 3 day tour package taking you through Las Vegas, USA and 6 other destinations in USA.
\r\n - SedonaExperience Sedona, Monument Valley & Antelope Canyon on this 3-day package through some of the most unique and stunning landscapes of the American West.,
\r\n
', 4, '\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Optional
\r\n - Additional Services
\r\n
', 0, 1, 'Monument Valley & Antelope Canyon Experience 3D/2N (from Las Vegas) includes accommodation in a hotel as well as an expert guide, meals, transport and more.'),
(45, 'Incredible Canyons of the West Experience 3D/2N (from Las Vegas)', 'English', 20, 'upload/tours/images/cover/WFkNhHWn92353_5b87342a.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 794, 794, 0, 666, 70, '', 1, '\r\n - Start and end in Las Vegas
\r\n - you have a 3 day tour package taking you through Las Vegas, USA and 4 other destinations in USA.
\r\n - Incredible Canyons of the West Experience 3D/2N (from Las Vegas) includes accommodation in a hotel as well as an expert guide, meals, transport and more.
\r\n
', 4, '\r\n - Accommodation
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n
', 0, 1, 'Experience the Canyons of the West on this 3-day package. Make a visit to the Grand Canyon, considered one of the 7 wonders of the world. Have a tour through Lake Powell and Bryce Canyon. End your experience with a visit to Zion National Park and discover its unique geography before heading back to Las Vegas.'),
(46, 'Alaska Camping: Kenai Peninsula', 'English', 13, 'upload/tours/images/cover/uMgZuGK2133430_5e26f898522d7.jpg', 0, 0, 0, 6, '0000-00-00 00:00:00', 947, 947, 0, 700, 100, '', 1, '\r\n - Start and end in Anchorage
\r\n - With the adventure tour Alaska Camping: Kenai Peninsula,
\r\n - 6 day tour package taking you through Anchorage, USA and 2 other destinations in USA.
\r\n - Alaska Camping: Kenai Peninsula includes accommodation in a hotel as well as an expert guide, meals, transport and more.
\r\n
', 4, '\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Homer
\r\n
', 0, 1, 'Now\'s the time to explore the United States on your terms with this tour that\'s affordable for young travellers. They don\'t call it the Last Frontier for nothing. Venturing through Alaska\'s incredible, remote natural landscapes on this six-day tour will feel like you\'re at the edge of the continent — because, um, you are. Kayak along majestic mountains, hike to glaciers and ice fields, and set up camp in the wilderness to sleep under a blanket of stars and you\'ll soon know why we call it The Great Outdoors.'),
(47, 'Southwest National Parks', 'English', 50, 'upload/tours/images/cover/nlvoverG1.jpg', 0, 0, 0, 4, '0000-00-00 00:00:00', 785, 785, 0, 600, 100, '', 1, '\r\n - Dance all night in the party capital of the world
\r\n - Drive through monument valley in a 4WD
\r\n - Embark on a Navajo-led tour of Antelope Canyon
\r\n - Enjoy a scenic flight over the Grand Canyon
\r\n
', 4, '\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Optional
\r\n - Additional Services
\r\n
', 0, 1, 'This trip starts and finishes in Las Vegas, but where you travel in between is worlds apart from the glittering lights of Sin City. This one\'s all about Mother Nature, as you journey through the Zion canyon and the organic amphitheatre of Bryce, before heading through Monument Valley, Lake Powell and saving the best till last at the gobsmacking Grand Canyon. Along the way you\'ll be hiking, camping under starlit skies and spotting wildlife, with options for a Navajo led hike around Antelope Canyon and a helicopter over the Grand Canyon\'s rim.'),
(50, 'Helicopter Tour in Nepal', 'English', 4, 'upload/tours/images/cover/HYR8dXAB152981_c12946d8.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 2290, 2290, 0, 1500, 700, '', 1, '\r\n - Start and end in Kathmandu with the helicopter ride tour Helicopter Tour in Nepal
\r\n - 3 day tour package taking you through Kathmandu, Nepal and Langtang National Park
\r\n - Helicopter Tour in Nepal includes accommodation in a hotel as well as flights, an expert guide, transport and more.
\r\n
', 5, '\r\n - Accommodation
\r\n - Flights
\r\n - Guide
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Insurance
\r\n - Meals
\r\n
', 0, 1, 'Langtang Heli Tour is comfortable way to reach Langtang Valley,is a famous viewpoint near Kyanjing Ri where hundreds of trekkers reach every year. Our destination of this one in a life heli tour will be Langtang Himalayan range. The flight takes off from Tribhuvan International Airport, Kathmandu'),
(51, 'Bangkok Stopover 3 Day', 'English', 48, 'upload/tours/images/cover/EGW48e7G2.jpg', 0, 0, 0, 3, '0000-00-00 00:00:00', 189, 189, 0, 111, 13, '', 1, '\r\n - Work that chopstick magic with the best eats in China
\r\n - Brag to your friends on a cable car ride at the Great Wall
\r\n - Get your shopping fix at one of the 100,000 street vendors
\r\n - Experience the hustle and bustle from a tuk-tuk
\r\n
', 5, '\r\n - Accommodation
\r\n - Guide
\r\n - Meals
\r\n - Transport
\r\n - Additional Services
\r\n
', '\r\n - Flights
\r\n - Insurance
\r\n - Optional
\r\n - Additional Services
\r\n
', 0, 1, 'This Bangkok stopover is all about the eccentric city vibes and its tuk-tuk filled streets. Whether you\'re keen to retrace history or ready to fuel your appetite with delicious street food, you\'re sure to find something in this incredible city.');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_tourpackage`
--
DROP TABLE IF EXISTS `tbpro_tourpackage`;
CREATE TABLE `tbpro_tourpackage` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_tourpackage`
--
INSERT INTO `tbpro_tourpackage` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(20, 'Yoga', 'upload/activities/images/cover/44179905_2089403601104706_1795510498272215040_o.jpg', '', 5, 1, 'Yoga with Netbase Team'),
(70, 'Dances', 'upload/activities/images/cover/hinh-anh-hoc-nhay-sexy-dance-o-dau-tai-ha-noi.jpg', '', 0, 1, 'Dance with Netbase Team'),
(73, 'Football', 'upload/activities/images/cover/images.jpg', '', 0, 0, 'Football with Netbase FC');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_tourproperty`
--
DROP TABLE IF EXISTS `tbpro_tourproperty`;
CREATE TABLE `tbpro_tourproperty` (
`id` int(11) NOT NULL,
`type` varchar(30) NOT NULL,
`object_id` int(11) NOT NULL,
`tour_id` int(11) NOT NULL,
`alias` varchar(200) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_tourproperty`
--
INSERT INTO `tbpro_tourproperty` (`id`, `type`, `object_id`, `tour_id`, `alias`, `description`) VALUES
(54, 'destination', 4, 4, '', ''),
(56, 'tour_type', 4, 5, '', ''),
(58, 'destination', 4, 5, '', ''),
(59, 'destination', 5, 5, '', ''),
(60, 'tour_type', 4, 9, '', ''),
(62, 'destination', 4, 9, '', ''),
(63, 'destination', 5, 9, '', ''),
(64, 'tour_type', 4, 3, '', ''),
(65, 'tour_type', 4, 3, '', ''),
(68, 'tourtype', 4, 3, '', ''),
(78, 'tourtype', 11, 14, '', ''),
(92, 'tourtype', 9, 17, '', ''),
(93, 'tourtype', 11, 17, '', ''),
(102, 'tourtype', 11, 13, '', ''),
(106, 'tourtype', 10, 19, '', ''),
(107, 'tourtype', 11, 19, '', ''),
(114, 'tourtype', 11, 13, '', ''),
(117, 'tourtype', 11, 14, '', ''),
(119, 'tourtype', 11, 20, '', ''),
(126, 'tourtype', 9, 22, '', ''),
(132, 'tourtype', 9, 23, '', ''),
(142, 'tourtype', 10, 25, '', ''),
(143, 'tourtype', 11, 25, '', ''),
(156, 'tourtype', 10, 27, '', ''),
(157, 'tourtype', 11, 27, '', ''),
(165, 'tourtype', 11, 13, '', ''),
(168, 'tourtype', 11, 13, '', ''),
(171, 'tourtype', 11, 13, '', ''),
(194, 'tourtype', 11, 13, '', ''),
(197, 'tourtype', 11, 14, '', ''),
(199, 'tourtype', 11, 14, '', ''),
(206, 'discount', 1, 12, '', ''),
(207, 'discount', 1, 15, '', ''),
(208, 'discount', 1, 17, '', ''),
(209, 'discount', 1, 21, '', ''),
(210, 'discount', 1, 23, '', ''),
(227, 'activities', 70, 12, '', ''),
(228, 'activities', 20, 12, '', ''),
(233, 'activity', 70, 12, '', ''),
(234, 'activity', 73, 12, '', ''),
(239, 'activity', 70, 12, '', ''),
(240, 'activity', 73, 12, '', ''),
(246, 'activity', 70, 12, '', ''),
(247, 'activity', 73, 12, '', ''),
(250, 'tourtype', 11, 13, '', ''),
(253, 'tourtype', 11, 14, '', ''),
(258, 'tourtype', 9, 16, '', ''),
(261, 'tourtype', 9, 17, '', ''),
(262, 'tourtype', 11, 17, '', ''),
(264, 'tourtype', 11, 18, '', ''),
(267, 'tourtype', 10, 19, '', ''),
(268, 'tourtype', 11, 19, '', ''),
(270, 'tourtype', 9, 20, '', ''),
(271, 'tourtype', 11, 20, '', ''),
(273, 'tourtype', 10, 21, '', ''),
(278, 'activity', 70, 12, '', ''),
(279, 'activity', 73, 12, '', ''),
(282, 'tourtype', 11, 13, '', ''),
(284, 'tourtype', 11, 14, '', ''),
(286, 'tourtype', 10, 15, '', ''),
(289, 'tourtype', 11, 13, '', ''),
(291, 'tourtype', 11, 14, '', ''),
(294, 'tourtype', 10, 19, '', ''),
(295, 'tourtype', 11, 19, '', ''),
(297, 'tourtype', 11, 14, '', ''),
(299, 'tourtype', 9, 16, '', ''),
(302, 'tourtype', 11, 13, '', ''),
(303, 'activity', 70, 13, '', ''),
(305, 'tourtype', 11, 13, '', ''),
(306, 'activity', 70, 13, '', ''),
(308, 'tourtype', 11, 13, '', ''),
(309, 'activity', 70, 13, '', ''),
(311, 'tourtype', 11, 13, '', ''),
(312, 'activity', 70, 13, '', ''),
(314, 'tourtype', 9, 16, '', ''),
(317, 'tourtype', 9, 16, '', ''),
(319, 'activity', 73, 16, '', ''),
(321, 'tourtype', 9, 12, '', ''),
(322, 'activity', 70, 12, '', ''),
(323, 'activity', 73, 12, '', ''),
(326, 'tourtype', 9, 12, '', ''),
(327, 'activity', 70, 12, '', ''),
(328, 'activity', 73, 12, '', ''),
(331, 'tourtype', 9, 12, '', ''),
(333, 'activity', 70, 12, '', ''),
(334, 'activity', 73, 12, '', ''),
(337, 'tourtype', 9, 32, '', ''),
(340, 'tourtype', 9, 32, '', ''),
(343, 'tourtype', 9, 32, '', ''),
(346, 'tourtype', 9, 12, '', ''),
(348, 'activity', 70, 12, '', ''),
(350, 'tourtype', 11, 14, '', ''),
(353, 'activity', 70, 12, '', ''),
(356, 'activity', 70, 12, '', ''),
(358, 'tourtype', 11, 14, '', ''),
(361, 'activity', 70, 12, '', ''),
(362, 'activity', 73, 12, '', ''),
(364, 'tourtype', 11, 14, '', ''),
(367, 'activity', 70, 12, '', ''),
(368, 'activity', 73, 12, '', ''),
(371, 'activity', 70, 12, '', ''),
(372, 'activity', 73, 12, '', ''),
(375, 'activity', 70, 12, '', ''),
(376, 'activity', 73, 12, '', ''),
(379, 'activity', 70, 12, '', ''),
(380, 'activity', 73, 12, '', ''),
(383, 'activity', 70, 12, '', ''),
(384, 'activity', 73, 12, '', ''),
(387, 'activity', 70, 12, '', ''),
(388, 'activity', 73, 12, '', ''),
(391, 'activity', 70, 12, '', ''),
(392, 'activity', 73, 12, '', ''),
(395, 'activity', 70, 12, '', ''),
(396, 'activity', 73, 12, '', ''),
(399, 'activity', 70, 12, '', ''),
(400, 'activity', 73, 12, '', ''),
(403, 'activity', 70, 12, '', ''),
(404, 'activity', 73, 12, '', ''),
(407, 'activity', 70, 12, '', ''),
(408, 'activity', 73, 12, '', ''),
(411, 'activity', 70, 12, '', ''),
(412, 'activity', 73, 12, '', ''),
(415, 'activity', 70, 12, '', ''),
(416, 'activity', 73, 12, '', ''),
(419, 'activity', 70, 12, '', ''),
(420, 'activity', 73, 12, '', ''),
(423, 'activity', 70, 12, '', ''),
(424, 'activity', 73, 12, '', ''),
(427, 'activity', 70, 12, '', ''),
(428, 'activity', 73, 12, '', ''),
(431, 'activity', 70, 12, '', ''),
(432, 'activity', 73, 12, '', ''),
(435, 'activity', 70, 12, '', ''),
(436, 'activity', 73, 12, '', ''),
(439, 'activity', 70, 12, '', ''),
(440, 'activity', 73, 12, '', ''),
(443, 'activity', 70, 12, '', ''),
(444, 'activity', 73, 12, '', ''),
(447, 'tourtype', 10, 19, '', ''),
(448, 'tourtype', 11, 19, '', ''),
(450, 'tourtype', 10, 21, '', ''),
(453, 'tourtype', 11, 17, '', ''),
(455, 'tourtype', 11, 18, '', ''),
(456, 'tourtype', 11, 14, '', ''),
(458, 'tourtype', 10, 15, '', ''),
(462, 'activity', 70, 12, '', ''),
(463, 'activity', 73, 12, '', ''),
(466, 'activity', 73, 16, '', ''),
(470, 'tourtype', 10, 19, '', ''),
(471, 'tourtype', 11, 19, '', ''),
(474, 'tourtype', 11, 14, '', ''),
(476, 'activity', 73, 16, '', ''),
(479, 'activity', 73, 16, '', ''),
(481, 'tourtype', 11, 17, '', ''),
(483, 'tourtype', 11, 18, '', ''),
(484, 'destination', 19, 19, '', ''),
(487, 'tourtype', 10, 19, '', ''),
(488, 'tourtype', 11, 19, '', ''),
(492, 'tourtype', 11, 20, '', ''),
(493, 'activity', 70, 20, '', ''),
(495, 'season', 70, 20, '', ''),
(497, 'tourtype', 11, 20, '', ''),
(498, 'activity', 70, 20, '', ''),
(500, 'season', 70, 20, '', ''),
(502, 'tourtype', 11, 20, '', ''),
(503, 'activity', 70, 20, '', ''),
(505, 'season', 70, 20, '', ''),
(507, 'tourtype', 10, 21, '', ''),
(511, 'tourtype', 10, 22, '', ''),
(518, 'activity', 73, 23, '', ''),
(521, 'tourtype', 11, 24, '', ''),
(525, 'tourtype', 10, 25, '', ''),
(526, 'tourtype', 11, 25, '', ''),
(530, 'tourtype', 11, 24, '', ''),
(542, 'tourtype', 10, 27, '', ''),
(543, 'tourtype', 11, 27, '', ''),
(544, 'activity', 70, 27, '', ''),
(547, 'tourtype', 11, 28, '', ''),
(548, 'tourtype', 13, 28, '', ''),
(549, 'activity', 73, 28, '', ''),
(554, 'activity', 70, 29, '', ''),
(555, 'season', 70, 29, '', ''),
(556, 'destination', 19, 30, '', ''),
(557, 'tourtype', 11, 30, '', ''),
(559, 'activity', 70, 30, '', ''),
(561, 'tourtype', 11, 31, '', ''),
(562, 'activity', 70, 31, '', ''),
(564, 'destination', 31, 27, '', ''),
(565, 'tourtype', 10, 27, '', ''),
(566, 'tourtype', 11, 27, '', ''),
(567, 'activity', 70, 27, '', ''),
(569, 'destination', 31, 26, '', ''),
(573, 'destination', 30, 25, '', ''),
(574, 'tourtype', 10, 25, '', ''),
(575, 'tourtype', 11, 25, '', ''),
(579, 'tourtype', 11, 24, '', ''),
(582, 'destination', 28, 23, '', ''),
(585, 'activity', 73, 23, '', ''),
(588, 'activity', 70, 12, '', ''),
(589, 'activity', 73, 12, '', ''),
(590, 'destination', 19, 14, '', ''),
(592, 'destination', 23, 14, '', ''),
(593, 'tourtype', 11, 14, '', ''),
(594, 'activity', 70, 14, '', ''),
(598, 'destination', 23, 15, '', ''),
(599, 'tourtype', 10, 15, '', ''),
(603, 'destination', 23, 16, '', ''),
(606, 'activity', 73, 16, '', ''),
(609, 'destination', 26, 17, '', ''),
(610, 'destination', 27, 17, '', ''),
(611, 'tourtype', 11, 17, '', ''),
(612, 'activity', 70, 17, '', ''),
(614, 'destination', 24, 18, '', ''),
(615, 'destination', 26, 18, '', ''),
(616, 'destination', 30, 18, '', ''),
(617, 'tourtype', 11, 18, '', ''),
(618, 'activity', 70, 18, '', ''),
(620, 'destination', 23, 20, '', ''),
(621, 'destination', 26, 20, '', ''),
(623, 'tourtype', 11, 20, '', ''),
(624, 'activity', 70, 20, '', ''),
(625, 'season', 70, 20, '', ''),
(628, 'destination', 23, 15, '', ''),
(629, 'tourtype', 10, 15, '', ''),
(633, 'destination', 26, 17, '', ''),
(634, 'destination', 27, 17, '', ''),
(635, 'tourtype', 11, 17, '', ''),
(636, 'activity', 70, 17, '', ''),
(639, 'destination', 27, 21, '', ''),
(641, 'tourtype', 10, 21, '', ''),
(642, 'activity', 73, 21, '', ''),
(643, 'season', 21, 21, '', ''),
(644, 'destination', 19, 22, '', ''),
(645, 'destination', 21, 22, '', ''),
(646, 'destination', 22, 22, '', ''),
(647, 'tourtype', 10, 22, '', ''),
(649, 'activity', 20, 22, '', ''),
(650, 'season', 20, 22, '', ''),
(652, 'destination', 19, 12, '', ''),
(653, 'destination', 22, 12, '', ''),
(654, 'tourtype', 11, 12, '', ''),
(655, 'activity', 70, 12, '', ''),
(656, 'activity', 73, 12, '', ''),
(657, 'season', 20, 12, '', ''),
(658, 'destination', 18, 29, '', ''),
(659, 'destination', 20, 29, '', ''),
(660, 'destination', 26, 29, '', ''),
(661, 'tourtype', 11, 29, '', ''),
(662, 'activity', 70, 29, '', ''),
(663, 'season', 70, 29, '', ''),
(665, 'destination', 19, 12, '', ''),
(666, 'destination', 21, 12, '', ''),
(667, 'destination', 22, 12, '', ''),
(668, 'tourtype', 11, 12, '', ''),
(669, 'activity', 70, 12, '', ''),
(670, 'activity', 73, 12, '', ''),
(671, 'season', 20, 12, '', ''),
(672, 'destination', 21, 16, '', ''),
(673, 'destination', 23, 16, '', ''),
(675, 'tourtype', 16, 16, '', ''),
(676, 'activity', 73, 16, '', ''),
(677, 'destination', 21, 17, '', ''),
(678, 'destination', 26, 17, '', ''),
(679, 'destination', 27, 17, '', ''),
(680, 'tourtype', 11, 17, '', ''),
(681, 'activity', 70, 17, '', ''),
(682, 'destination', 19, 32, '', ''),
(683, 'destination', 19, 32, '', ''),
(684, 'tourtype', 14, 32, '', ''),
(685, 'tourtype', 19, 32, '', ''),
(686, 'activity', 75, 32, '', ''),
(687, 'activity', 76, 32, '', ''),
(688, 'activity', 77, 32, '', ''),
(689, 'season', 20, 32, '', ''),
(690, 'season', 21, 32, '', ''),
(691, 'season', 22, 32, '', ''),
(692, 'season', 70, 32, '', ''),
(693, 'destination', 19, 32, '', ''),
(694, 'destination', 19, 32, '', ''),
(695, 'tourtype', 14, 32, '', ''),
(696, 'tourtype', 19, 32, '', ''),
(697, 'activity', 75, 32, '', ''),
(698, 'activity', 76, 32, '', ''),
(699, 'activity', 77, 32, '', ''),
(700, 'season', 20, 32, '', ''),
(701, 'season', 21, 32, '', ''),
(702, 'season', 22, 32, '', ''),
(703, 'season', 70, 32, '', ''),
(704, 'destination', 17, 33, '', ''),
(705, 'activity', 20, 33, '', ''),
(706, 'activity', 73, 33, '', ''),
(707, 'destination', 17, 33, '', ''),
(708, 'activity', 20, 33, '', ''),
(709, 'activity', 73, 33, '', ''),
(710, 'destination', 17, 33, '', ''),
(711, 'activity', 20, 33, '', ''),
(712, 'activity', 73, 33, '', ''),
(713, 'destination', 17, 33, '', ''),
(714, 'activity', 20, 33, '', ''),
(715, 'activity', 73, 33, '', ''),
(716, 'destination', 20, 34, '', ''),
(717, 'tourtype', 12, 34, '', ''),
(718, 'activity', 75, 34, '', ''),
(719, 'destination', 20, 34, '', ''),
(720, 'tourtype', 12, 34, '', ''),
(721, 'activity', 75, 34, '', ''),
(722, 'destination', 20, 34, '', ''),
(723, 'tourtype', 12, 34, '', ''),
(724, 'activity', 75, 34, '', ''),
(725, 'destination', 18, 35, '', ''),
(726, 'tourtype', 11, 35, '', ''),
(727, 'activity', 73, 35, '', ''),
(728, 'season', 21, 35, '', ''),
(729, 'season', 70, 35, '', ''),
(730, 'destination', 18, 35, '', ''),
(731, 'tourtype', 11, 35, '', ''),
(732, 'activity', 73, 35, '', ''),
(733, 'season', 21, 35, '', ''),
(734, 'season', 70, 35, '', ''),
(735, 'destination', 18, 35, '', ''),
(736, 'tourtype', 11, 35, '', ''),
(737, 'activity', 73, 35, '', ''),
(738, 'season', 21, 35, '', ''),
(739, 'season', 70, 35, '', ''),
(740, 'destination', 18, 35, '', ''),
(741, 'tourtype', 11, 35, '', ''),
(742, 'activity', 73, 35, '', ''),
(743, 'season', 21, 35, '', ''),
(744, 'season', 70, 35, '', ''),
(745, 'destination', 20, 36, '', ''),
(746, 'tourtype', 11, 36, '', ''),
(747, 'activity', 20, 36, '', ''),
(748, 'season', 20, 36, '', ''),
(749, 'season', 21, 36, '', ''),
(750, 'season', 22, 36, '', ''),
(751, 'season', 70, 36, '', ''),
(752, 'destination', 20, 36, '', ''),
(753, 'tourtype', 11, 36, '', ''),
(754, 'activity', 20, 36, '', ''),
(755, 'season', 20, 36, '', ''),
(756, 'season', 21, 36, '', ''),
(757, 'season', 22, 36, '', ''),
(758, 'season', 70, 36, '', ''),
(759, 'destination', 20, 36, '', ''),
(760, 'tourtype', 11, 36, '', ''),
(761, 'activity', 20, 36, '', ''),
(762, 'season', 20, 36, '', ''),
(763, 'season', 21, 36, '', ''),
(764, 'season', 22, 36, '', ''),
(765, 'season', 70, 36, '', ''),
(767, 'tourtype', 19, 37, '', ''),
(768, 'activity', 75, 37, '', ''),
(769, 'season', 21, 37, '', ''),
(771, 'tourtype', 19, 37, '', ''),
(772, 'activity', 75, 37, '', ''),
(773, 'season', 21, 37, '', ''),
(775, 'tourtype', 19, 37, '', ''),
(776, 'activity', 75, 37, '', ''),
(777, 'season', 21, 37, '', ''),
(779, 'tourtype', 14, 38, '', ''),
(780, 'activity', 75, 38, '', ''),
(781, 'season', 70, 38, '', ''),
(783, 'tourtype', 14, 38, '', ''),
(784, 'activity', 75, 38, '', ''),
(785, 'season', 70, 38, '', ''),
(787, 'tourtype', 14, 38, '', ''),
(788, 'activity', 75, 38, '', ''),
(789, 'season', 70, 38, '', ''),
(790, 'destination', 20, 39, '', ''),
(791, 'tourtype', 19, 39, '', ''),
(792, 'activity', 75, 39, '', ''),
(793, 'season', 70, 39, '', ''),
(794, 'destination', 20, 39, '', ''),
(795, 'tourtype', 19, 39, '', ''),
(796, 'activity', 75, 39, '', ''),
(797, 'season', 70, 39, '', ''),
(798, 'destination', 20, 39, '', ''),
(799, 'tourtype', 19, 39, '', ''),
(800, 'activity', 75, 39, '', ''),
(801, 'season', 70, 39, '', ''),
(802, 'destination', 29, 40, '', ''),
(803, 'tourtype', 16, 40, '', ''),
(804, 'activity', 73, 40, '', ''),
(805, 'season', 0, 40, '', ''),
(806, 'destination', 29, 40, '', ''),
(807, 'tourtype', 16, 40, '', ''),
(808, 'activity', 73, 40, '', ''),
(810, 'tourtype', 19, 41, '', ''),
(811, 'activity', 75, 41, '', ''),
(812, 'season', 0, 41, '', ''),
(814, 'tourtype', 19, 41, '', ''),
(815, 'activity', 75, 41, '', ''),
(816, 'destination', 17, 42, '', ''),
(817, 'tourtype', 0, 42, '', ''),
(818, 'tourtype', 18, 42, '', ''),
(819, 'activity', 75, 42, '', ''),
(820, 'season', 20, 42, '', ''),
(821, 'season', 21, 42, '', ''),
(822, 'season', 22, 42, '', ''),
(823, 'destination', 17, 42, '', ''),
(824, 'tourtype', 18, 42, '', ''),
(825, 'activity', 75, 42, '', ''),
(826, 'season', 20, 42, '', ''),
(827, 'season', 21, 42, '', ''),
(828, 'season', 22, 42, '', ''),
(830, 'tourtype', 19, 37, '', ''),
(831, 'activity', 75, 37, '', ''),
(832, 'season', 21, 37, '', ''),
(835, 'tourtype', 19, 37, '', ''),
(836, 'activity', 75, 37, '', ''),
(837, 'season', 21, 37, '', ''),
(838, 'destination', 22, 43, '', ''),
(839, 'destination', 22, 43, '', ''),
(840, 'tourtype', 10, 43, '', ''),
(841, 'activity', 80, 43, '', ''),
(842, 'destination', 22, 43, '', ''),
(843, 'tourtype', 10, 43, '', ''),
(844, 'activity', 80, 43, '', ''),
(845, 'destination', 22, 43, '', ''),
(846, 'tourtype', 10, 43, '', ''),
(847, 'activity', 80, 43, '', ''),
(848, 'destination', 22, 44, '', ''),
(849, 'tourtype', 19, 44, '', ''),
(850, 'activity', 78, 44, '', ''),
(851, 'destination', 22, 44, '', ''),
(852, 'tourtype', 19, 44, '', ''),
(853, 'activity', 78, 44, '', ''),
(854, 'destination', 22, 44, '', ''),
(855, 'tourtype', 19, 44, '', ''),
(856, 'activity', 78, 44, '', ''),
(857, 'destination', 22, 45, '', ''),
(858, 'tourtype', 19, 45, '', ''),
(859, 'activity', 75, 45, '', ''),
(860, 'activity', 79, 45, '', ''),
(861, 'destination', 22, 45, '', ''),
(862, 'tourtype', 19, 45, '', ''),
(863, 'activity', 75, 45, '', ''),
(864, 'activity', 79, 45, '', ''),
(865, 'destination', 23, 46, '', ''),
(866, 'tourtype', 19, 46, '', ''),
(867, 'activity', 78, 46, '', ''),
(868, 'activity', 79, 46, '', ''),
(869, 'season', 21, 46, '', ''),
(870, 'season', 22, 46, '', ''),
(871, 'destination', 23, 46, '', ''),
(872, 'tourtype', 19, 46, '', ''),
(873, 'activity', 78, 46, '', ''),
(874, 'activity', 79, 46, '', ''),
(875, 'season', 21, 46, '', ''),
(876, 'season', 22, 46, '', ''),
(877, 'destination', 23, 46, '', ''),
(878, 'tourtype', 19, 46, '', ''),
(879, 'activity', 78, 46, '', ''),
(880, 'activity', 79, 46, '', ''),
(881, 'season', 21, 46, '', ''),
(882, 'season', 22, 46, '', ''),
(883, 'destination', 22, 47, '', ''),
(884, 'tourtype', 19, 47, '', ''),
(885, 'activity', 75, 47, '', ''),
(886, 'activity', 78, 47, '', ''),
(887, 'destination', 22, 47, '', ''),
(888, 'tourtype', 19, 47, '', ''),
(889, 'activity', 75, 47, '', ''),
(890, 'activity', 78, 47, '', ''),
(892, 'tourtype', 15, 48, '', ''),
(893, 'activity', 77, 48, '', ''),
(894, 'activity', 79, 48, '', ''),
(895, 'season', 20, 48, '', ''),
(897, 'tourtype', 15, 48, '', ''),
(898, 'activity', 77, 48, '', ''),
(899, 'activity', 79, 48, '', ''),
(900, 'season', 20, 48, '', ''),
(901, 'destination', 19, 49, '', ''),
(902, 'tourtype', 19, 49, '', ''),
(903, 'activity', 78, 49, '', ''),
(904, 'activity', 80, 49, '', ''),
(905, 'season', 70, 49, '', ''),
(906, 'destination', 19, 49, '', ''),
(907, 'tourtype', 19, 49, '', ''),
(908, 'activity', 78, 49, '', ''),
(909, 'activity', 80, 49, '', ''),
(910, 'season', 70, 49, '', ''),
(911, 'destination', 19, 49, '', ''),
(912, 'tourtype', 19, 49, '', ''),
(913, 'activity', 78, 49, '', ''),
(914, 'activity', 80, 49, '', ''),
(915, 'season', 70, 49, '', ''),
(916, 'destination', 28, 50, '', ''),
(917, 'tourtype', 19, 50, '', ''),
(918, 'activity', 79, 50, '', ''),
(919, 'season', 21, 50, '', ''),
(920, 'destination', 28, 50, '', ''),
(921, 'tourtype', 19, 50, '', ''),
(922, 'activity', 79, 50, '', ''),
(923, 'season', 21, 50, '', ''),
(924, 'destination', 30, 51, '', ''),
(925, 'tourtype', 11, 51, '', ''),
(926, 'activity', 79, 51, '', ''),
(927, 'season', 22, 51, '', ''),
(928, 'destination', 30, 51, '', ''),
(929, 'tourtype', 11, 51, '', ''),
(930, 'activity', 79, 51, '', ''),
(931, 'season', 22, 51, '', ''),
(932, 'destination', 30, 51, '', ''),
(933, 'tourtype', 11, 51, '', ''),
(934, 'activity', 79, 51, '', ''),
(935, 'season', 22, 51, '', ''),
(936, 'destination', 19, 32, '', ''),
(937, 'tourtype', 14, 32, '', ''),
(938, 'tourtype', 19, 32, '', ''),
(939, 'activity', 75, 32, '', ''),
(940, 'activity', 76, 32, '', ''),
(941, 'activity', 77, 32, '', ''),
(942, 'season', 20, 32, '', ''),
(943, 'season', 21, 32, '', ''),
(944, 'season', 22, 32, '', ''),
(945, 'season', 70, 32, '', ''),
(946, 'destination', 19, 32, '', ''),
(947, 'tourtype', 14, 32, '', ''),
(948, 'tourtype', 19, 32, '', ''),
(949, 'activity', 75, 32, '', ''),
(950, 'activity', 76, 32, '', ''),
(951, 'activity', 77, 32, '', ''),
(952, 'season', 20, 32, '', ''),
(953, 'season', 21, 32, '', ''),
(954, 'season', 22, 32, '', ''),
(955, 'season', 70, 32, '', ''),
(956, 'destination', 19, 32, '', ''),
(957, 'tourtype', 14, 32, '', ''),
(958, 'tourtype', 19, 32, '', ''),
(959, 'activity', 75, 32, '', ''),
(960, 'activity', 76, 32, '', ''),
(961, 'activity', 77, 32, '', ''),
(962, 'season', 20, 32, '', ''),
(963, 'season', 21, 32, '', ''),
(964, 'season', 22, 32, '', ''),
(965, 'season', 70, 32, '', ''),
(966, 'destination', 17, 42, '', ''),
(967, 'tourtype', 18, 42, '', ''),
(968, 'activity', 75, 42, '', ''),
(969, 'season', 20, 42, '', ''),
(970, 'season', 21, 42, '', ''),
(971, 'season', 22, 42, '', ''),
(972, 'destination', 17, 42, '', ''),
(973, 'tourtype', 18, 42, '', ''),
(974, 'activity', 75, 42, '', ''),
(975, 'season', 20, 42, '', ''),
(976, 'season', 21, 42, '', ''),
(977, 'season', 22, 42, '', ''),
(978, 'destination', 17, 42, '', ''),
(979, 'tourtype', 18, 42, '', ''),
(980, 'activity', 75, 42, '', ''),
(981, 'season', 20, 42, '', ''),
(982, 'season', 21, 42, '', ''),
(983, 'season', 22, 42, '', ''),
(984, 'destination', 17, 42, '', ''),
(985, 'tourtype', 18, 42, '', ''),
(986, 'activity', 75, 42, '', ''),
(987, 'season', 20, 42, '', ''),
(988, 'season', 21, 42, '', ''),
(989, 'season', 22, 42, '', ''),
(990, 'destination', 17, 42, '', ''),
(991, 'tourtype', 18, 42, '', ''),
(992, 'activity', 75, 42, '', ''),
(993, 'season', 20, 42, '', ''),
(994, 'season', 21, 42, '', ''),
(995, 'season', 22, 42, '', ''),
(996, 'destination', 17, 42, '', ''),
(997, 'tourtype', 18, 42, '', ''),
(998, 'activity', 75, 42, '', ''),
(999, 'season', 20, 42, '', ''),
(1000, 'season', 21, 42, '', ''),
(1001, 'season', 22, 42, '', ''),
(1002, 'destination', 17, 42, '', ''),
(1003, 'tourtype', 18, 42, '', ''),
(1004, 'activity', 75, 42, '', ''),
(1005, 'season', 20, 42, '', ''),
(1006, 'season', 21, 42, '', ''),
(1007, 'season', 22, 42, '', ''),
(1008, 'destination', 17, 42, '', ''),
(1009, 'tourtype', 18, 42, '', ''),
(1010, 'activity', 75, 42, '', ''),
(1011, 'season', 20, 42, '', ''),
(1012, 'season', 21, 42, '', ''),
(1013, 'season', 22, 42, '', ''),
(1014, 'destination', 17, 42, '', ''),
(1015, 'tourtype', 18, 42, '', ''),
(1016, 'activity', 75, 42, '', ''),
(1017, 'season', 20, 42, '', ''),
(1018, 'season', 21, 42, '', ''),
(1019, 'season', 22, 42, '', ''),
(1020, 'destination', 17, 42, '', ''),
(1021, 'tourtype', 18, 42, '', ''),
(1022, 'activity', 75, 42, '', ''),
(1023, 'season', 20, 42, '', ''),
(1024, 'season', 21, 42, '', ''),
(1025, 'season', 22, 42, '', ''),
(1026, 'destination', 17, 42, '', ''),
(1027, 'tourtype', 18, 42, '', ''),
(1028, 'activity', 75, 42, '', ''),
(1029, 'season', 20, 42, '', ''),
(1030, 'season', 21, 42, '', ''),
(1031, 'season', 22, 42, '', ''),
(1032, 'destination', 17, 42, '', ''),
(1033, 'tourtype', 18, 42, '', ''),
(1034, 'activity', 75, 42, '', ''),
(1035, 'season', 20, 42, '', ''),
(1036, 'season', 21, 42, '', ''),
(1037, 'season', 22, 42, '', ''),
(1038, 'destination', 17, 42, '', ''),
(1039, 'tourtype', 18, 42, '', ''),
(1040, 'activity', 75, 42, '', ''),
(1041, 'season', 20, 42, '', ''),
(1042, 'season', 21, 42, '', ''),
(1043, 'season', 22, 42, '', ''),
(1044, 'destination', 17, 42, '', ''),
(1045, 'tourtype', 18, 42, '', ''),
(1046, 'activity', 75, 42, '', ''),
(1047, 'season', 20, 42, '', ''),
(1048, 'season', 21, 42, '', ''),
(1049, 'season', 22, 42, '', ''),
(1050, 'destination', 17, 42, '', ''),
(1051, 'tourtype', 18, 42, '', ''),
(1052, 'activity', 75, 42, '', ''),
(1053, 'season', 20, 42, '', ''),
(1054, 'season', 21, 42, '', ''),
(1055, 'season', 22, 42, '', ''),
(1056, 'destination', 17, 42, '', ''),
(1057, 'tourtype', 18, 42, '', ''),
(1058, 'activity', 75, 42, '', ''),
(1059, 'season', 20, 42, '', ''),
(1060, 'season', 21, 42, '', ''),
(1061, 'season', 22, 42, '', ''),
(1062, 'destination', 17, 42, '', ''),
(1063, 'tourtype', 18, 42, '', ''),
(1064, 'activity', 75, 42, '', ''),
(1065, 'season', 20, 42, '', ''),
(1066, 'season', 21, 42, '', ''),
(1067, 'season', 22, 42, '', ''),
(1068, 'destination', 17, 42, '', ''),
(1069, 'tourtype', 18, 42, '', ''),
(1070, 'activity', 75, 42, '', ''),
(1071, 'season', 20, 42, '', ''),
(1072, 'season', 21, 42, '', ''),
(1073, 'season', 22, 42, '', ''),
(1074, 'destination', 17, 42, '', ''),
(1075, 'tourtype', 18, 42, '', ''),
(1076, 'activity', 75, 42, '', ''),
(1077, 'season', 20, 42, '', ''),
(1078, 'season', 21, 42, '', ''),
(1079, 'season', 22, 42, '', ''),
(1080, 'destination', 17, 42, '', ''),
(1081, 'tourtype', 18, 42, '', ''),
(1082, 'activity', 75, 42, '', ''),
(1083, 'season', 20, 42, '', ''),
(1084, 'season', 21, 42, '', ''),
(1085, 'season', 22, 42, '', ''),
(1086, 'destination', 17, 42, '', ''),
(1087, 'tourtype', 18, 42, '', ''),
(1088, 'activity', 75, 42, '', ''),
(1089, 'season', 20, 42, '', ''),
(1090, 'season', 21, 42, '', ''),
(1091, 'season', 22, 42, '', ''),
(1092, 'destination', 17, 42, '', ''),
(1093, 'tourtype', 18, 42, '', ''),
(1094, 'activity', 75, 42, '', ''),
(1095, 'season', 20, 42, '', ''),
(1096, 'season', 21, 42, '', ''),
(1097, 'season', 22, 42, '', ''),
(1098, 'destination', 17, 42, '', ''),
(1099, 'tourtype', 18, 42, '', ''),
(1100, 'activity', 75, 42, '', ''),
(1101, 'season', 20, 42, '', ''),
(1102, 'season', 21, 42, '', ''),
(1103, 'season', 22, 42, '', ''),
(1104, 'destination', 30, 25, '', ''),
(1105, 'tourtype', 10, 25, '', ''),
(1106, 'tourtype', 11, 25, '', ''),
(1107, 'activity', 75, 25, '', ''),
(1108, 'activity', 79, 25, '', ''),
(1109, 'season', 20, 25, '', ''),
(1110, 'season', 21, 25, '', ''),
(1111, 'destination', 30, 25, '', ''),
(1112, 'tourtype', 10, 25, '', ''),
(1113, 'tourtype', 11, 25, '', ''),
(1114, 'activity', 75, 25, '', ''),
(1115, 'activity', 79, 25, '', ''),
(1116, 'season', 20, 25, '', ''),
(1117, 'season', 21, 25, '', ''),
(1118, 'destination', 17, 33, '', ''),
(1119, 'activity', 20, 33, '', ''),
(1120, 'activity', 73, 33, '', ''),
(1121, 'destination', 17, 33, '', ''),
(1122, 'activity', 20, 33, '', ''),
(1123, 'activity', 73, 33, '', ''),
(1124, 'destination', 32, 34, '', ''),
(1125, 'tourtype', 12, 34, '', ''),
(1126, 'activity', 75, 34, '', ''),
(1127, 'season', 22, 34, '', ''),
(1128, 'destination', 18, 35, '', ''),
(1129, 'tourtype', 11, 35, '', ''),
(1130, 'activity', 73, 35, '', ''),
(1131, 'season', 21, 35, '', ''),
(1132, 'season', 70, 35, '', ''),
(1133, 'destination', 18, 36, '', ''),
(1134, 'tourtype', 11, 36, '', ''),
(1135, 'activity', 20, 36, '', ''),
(1136, 'season', 20, 36, '', ''),
(1137, 'season', 21, 36, '', ''),
(1138, 'season', 22, 36, '', ''),
(1139, 'season', 70, 36, '', ''),
(1141, 'tourtype', 19, 37, '', ''),
(1142, 'activity', 75, 37, '', ''),
(1143, 'season', 21, 37, '', ''),
(1144, 'tourtype', 14, 38, '', ''),
(1145, 'activity', 75, 38, '', ''),
(1146, 'season', 70, 38, '', ''),
(1147, 'destination', 20, 39, '', ''),
(1148, 'tourtype', 19, 39, '', ''),
(1149, 'activity', 75, 39, '', ''),
(1150, 'season', 70, 39, '', ''),
(1151, 'destination', 29, 40, '', ''),
(1152, 'tourtype', 16, 40, '', ''),
(1153, 'activity', 73, 40, '', ''),
(1154, 'destination', 28, 41, '', ''),
(1155, 'tourtype', 19, 41, '', ''),
(1156, 'activity', 75, 41, '', ''),
(1157, 'season', 20, 41, '', ''),
(1158, 'destination', 28, 41, '', ''),
(1159, 'tourtype', 19, 41, '', ''),
(1160, 'activity', 75, 41, '', ''),
(1161, 'season', 20, 41, '', ''),
(1162, 'destination', 28, 41, '', ''),
(1163, 'tourtype', 19, 41, '', ''),
(1164, 'activity', 75, 41, '', ''),
(1165, 'season', 20, 41, '', ''),
(1166, 'destination', 22, 43, '', ''),
(1167, 'tourtype', 10, 43, '', ''),
(1168, 'activity', 80, 43, '', ''),
(1169, 'destination', 22, 44, '', ''),
(1170, 'tourtype', 19, 44, '', ''),
(1171, 'activity', 78, 44, '', ''),
(1172, 'destination', 22, 45, '', ''),
(1173, 'tourtype', 19, 45, '', ''),
(1174, 'activity', 75, 45, '', ''),
(1175, 'activity', 79, 45, '', ''),
(1176, 'destination', 23, 46, '', ''),
(1177, 'tourtype', 19, 46, '', ''),
(1178, 'activity', 78, 46, '', ''),
(1179, 'activity', 79, 46, '', ''),
(1180, 'season', 21, 46, '', ''),
(1181, 'season', 22, 46, '', ''),
(1182, 'destination', 22, 47, '', ''),
(1183, 'tourtype', 19, 47, '', ''),
(1184, 'activity', 75, 47, '', ''),
(1185, 'activity', 78, 47, '', ''),
(1186, 'destination', 28, 50, '', ''),
(1187, 'tourtype', 19, 50, '', ''),
(1188, 'activity', 79, 50, '', ''),
(1189, 'season', 21, 50, '', ''),
(1190, 'destination', 30, 51, '', ''),
(1191, 'tourtype', 11, 51, '', ''),
(1192, 'activity', 79, 51, '', ''),
(1193, 'season', 22, 51, '', ''),
(1194, 'destination', 30, 25, '', ''),
(1195, 'tourtype', 10, 25, '', ''),
(1196, 'tourtype', 11, 25, '', ''),
(1197, 'activity', 75, 25, '', ''),
(1198, 'activity', 79, 25, '', ''),
(1199, 'season', 20, 25, '', ''),
(1200, 'season', 21, 25, '', ''),
(1201, 'destination', 17, 33, '', ''),
(1202, 'activity', 20, 33, '', ''),
(1203, 'activity', 73, 33, '', ''),
(1204, 'destination', 20, 34, '', ''),
(1205, 'destination', 32, 34, '', ''),
(1206, 'tourtype', 12, 34, '', ''),
(1207, 'activity', 75, 34, '', ''),
(1208, 'season', 22, 34, '', ''),
(1209, 'destination', 30, 25, '', ''),
(1210, 'tourtype', 10, 25, '', ''),
(1211, 'tourtype', 11, 25, '', ''),
(1212, 'activity', 75, 25, '', ''),
(1213, 'activity', 79, 25, '', ''),
(1214, 'season', 20, 25, '', ''),
(1215, 'season', 21, 25, '', ''),
(1216, 'destination', 17, 33, '', ''),
(1217, 'activity', 20, 33, '', ''),
(1218, 'activity', 73, 33, '', ''),
(1219, 'destination', 18, 35, '', ''),
(1220, 'tourtype', 11, 35, '', ''),
(1221, 'activity', 73, 35, '', ''),
(1222, 'season', 21, 35, '', ''),
(1223, 'season', 70, 35, '', ''),
(1224, 'destination', 18, 36, '', ''),
(1225, 'destination', 20, 36, '', ''),
(1226, 'tourtype', 11, 36, '', ''),
(1227, 'activity', 20, 36, '', ''),
(1228, 'season', 20, 36, '', ''),
(1229, 'season', 21, 36, '', ''),
(1230, 'season', 22, 36, '', ''),
(1231, 'season', 70, 36, '', ''),
(1233, 'tourtype', 19, 37, '', ''),
(1234, 'activity', 75, 37, '', ''),
(1235, 'season', 21, 37, '', ''),
(1236, 'tourtype', 14, 38, '', ''),
(1237, 'activity', 75, 38, '', ''),
(1238, 'season', 70, 38, '', ''),
(1239, 'destination', 20, 39, '', ''),
(1240, 'tourtype', 19, 39, '', ''),
(1241, 'activity', 75, 39, '', ''),
(1242, 'season', 70, 39, '', ''),
(1243, 'destination', 29, 40, '', ''),
(1244, 'tourtype', 16, 40, '', ''),
(1245, 'activity', 73, 40, '', ''),
(1246, 'destination', 28, 41, '', ''),
(1247, 'tourtype', 19, 41, '', ''),
(1248, 'activity', 75, 41, '', ''),
(1249, 'season', 20, 41, '', ''),
(1250, 'destination', 29, 40, '', ''),
(1251, 'tourtype', 16, 40, '', ''),
(1252, 'activity', 73, 40, '', ''),
(1253, 'destination', 17, 33, '', ''),
(1254, 'activity', 20, 33, '', ''),
(1255, 'activity', 73, 33, '', ''),
(1256, 'destination', 20, 39, '', ''),
(1257, 'tourtype', 19, 39, '', ''),
(1258, 'activity', 75, 39, '', ''),
(1259, 'season', 70, 39, '', ''),
(1260, 'destination', 28, 50, '', ''),
(1261, 'tourtype', 19, 50, '', ''),
(1262, 'activity', 79, 50, '', ''),
(1263, 'season', 21, 50, '', ''),
(1264, 'destination', 23, 46, '', ''),
(1265, 'tourtype', 19, 46, '', ''),
(1266, 'activity', 78, 46, '', ''),
(1267, 'activity', 79, 46, '', ''),
(1268, 'season', 21, 46, '', ''),
(1269, 'season', 22, 46, '', ''),
(1270, 'destination', 22, 45, '', ''),
(1271, 'tourtype', 19, 45, '', ''),
(1272, 'activity', 75, 45, '', ''),
(1273, 'activity', 79, 45, '', ''),
(1274, 'destination', 22, 44, '', ''),
(1275, 'tourtype', 19, 44, '', ''),
(1276, 'activity', 78, 44, '', ''),
(1277, 'destination', 30, 25, '', ''),
(1278, 'tourtype', 10, 25, '', ''),
(1279, 'tourtype', 11, 25, '', ''),
(1280, 'activity', 75, 25, '', ''),
(1281, 'activity', 79, 25, '', ''),
(1282, 'season', 20, 25, '', ''),
(1283, 'season', 21, 25, '', ''),
(1284, 'destination', 30, 25, '', ''),
(1285, 'tourtype', 10, 25, '', ''),
(1286, 'tourtype', 11, 25, '', ''),
(1287, 'activity', 75, 25, '', ''),
(1288, 'activity', 79, 25, '', ''),
(1289, 'season', 20, 25, '', ''),
(1290, 'season', 21, 25, '', ''),
(1291, 'destination', 30, 25, '', ''),
(1292, 'tourtype', 10, 25, '', ''),
(1293, 'tourtype', 11, 25, '', ''),
(1294, 'activity', 75, 25, '', ''),
(1295, 'activity', 79, 25, '', ''),
(1296, 'season', 20, 25, '', ''),
(1297, 'season', 21, 25, '', ''),
(1298, 'destination', 30, 25, '', ''),
(1299, 'tourtype', 10, 25, '', ''),
(1300, 'tourtype', 11, 25, '', ''),
(1301, 'activity', 75, 25, '', ''),
(1302, 'activity', 79, 25, '', ''),
(1303, 'season', 20, 25, '', ''),
(1304, 'season', 21, 25, '', ''),
(1305, 'destination', 30, 25, '', ''),
(1306, 'tourtype', 10, 25, '', ''),
(1307, 'tourtype', 11, 25, '', ''),
(1308, 'activity', 75, 25, '', ''),
(1309, 'activity', 79, 25, '', ''),
(1310, 'season', 20, 25, '', ''),
(1311, 'season', 21, 25, '', ''),
(1312, 'destination', 30, 25, '', ''),
(1313, 'tourtype', 10, 25, '', ''),
(1314, 'tourtype', 11, 25, '', ''),
(1315, 'activity', 75, 25, '', ''),
(1316, 'activity', 79, 25, '', ''),
(1317, 'season', 20, 25, '', ''),
(1318, 'season', 21, 25, '', ''),
(1319, 'destination', 30, 25, '', ''),
(1320, 'tourtype', 10, 25, '', ''),
(1321, 'tourtype', 11, 25, '', ''),
(1322, 'activity', 75, 25, '', ''),
(1323, 'activity', 79, 25, '', ''),
(1324, 'season', 20, 25, '', ''),
(1325, 'season', 21, 25, '', ''),
(1326, 'destination', 30, 25, '', ''),
(1327, 'tourtype', 10, 25, '', ''),
(1328, 'tourtype', 11, 25, '', ''),
(1329, 'activity', 75, 25, '', ''),
(1330, 'activity', 79, 25, '', ''),
(1331, 'season', 20, 25, '', ''),
(1332, 'season', 21, 25, '', ''),
(1333, 'destination', 30, 25, '', ''),
(1334, 'tourtype', 10, 25, '', ''),
(1335, 'tourtype', 11, 25, '', ''),
(1336, 'activity', 75, 25, '', ''),
(1337, 'activity', 79, 25, '', ''),
(1338, 'season', 20, 25, '', ''),
(1339, 'season', 21, 25, '', ''),
(1340, 'destination', 30, 25, '', ''),
(1341, 'tourtype', 10, 25, '', ''),
(1342, 'tourtype', 11, 25, '', ''),
(1343, 'activity', 75, 25, '', ''),
(1344, 'activity', 79, 25, '', ''),
(1345, 'season', 20, 25, '', ''),
(1346, 'season', 21, 25, '', ''),
(1347, 'destination', 37, 37, '', ''),
(1348, 'tourtype', 19, 37, '', ''),
(1349, 'activity', 75, 37, '', ''),
(1350, 'season', 21, 37, '', ''),
(1351, 'discount', 2, 35, '', ''),
(1352, 'destination', 30, 25, '', ''),
(1353, 'tourtype', 10, 25, '', ''),
(1354, 'tourtype', 11, 25, '', ''),
(1355, 'activity', 75, 25, '', ''),
(1356, 'activity', 79, 25, '', ''),
(1357, 'season', 20, 25, '', ''),
(1358, 'season', 21, 25, '', ''),
(1359, 'destination', 30, 25, '', ''),
(1360, 'tourtype', 10, 25, '', ''),
(1361, 'tourtype', 11, 25, '', ''),
(1362, 'activity', 75, 25, '', ''),
(1363, 'activity', 79, 25, '', ''),
(1364, 'season', 20, 25, '', ''),
(1365, 'season', 21, 25, '', ''),
(1366, 'destination', 30, 25, '', ''),
(1367, 'tourtype', 10, 25, '', ''),
(1368, 'tourtype', 11, 25, '', ''),
(1369, 'activity', 75, 25, '', ''),
(1370, 'activity', 79, 25, '', ''),
(1371, 'season', 20, 25, '', ''),
(1372, 'season', 21, 25, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_tourtype`
--
DROP TABLE IF EXISTS `tbpro_tourtype`;
CREATE TABLE `tbpro_tourtype` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`ordering` int(11) NOT NULL,
`published` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_tourtype`
--
INSERT INTO `tbpro_tourtype` (`id`, `name`, `image`, `alias`, `ordering`, `published`, `description`) VALUES
(9, 'Adventure Tours', '', '', 0, 0, 'Take the adventure of a lifetime. If you long for adventure and excitement or just want to get out of your comfort zone we have you covered\r\n\r\n '),
(10, 'Food and Wine Tours', '', '', 0, 1, 'Food, and to a slightly lesser extent, wine are staples of everyday life, but have you ever sipped an Italian merlot poured straight from the barrel or tasted frog legs inside a Paris restaurant?\r\n\r\n '),
(11, 'Family Tours', '', '', 0, 1, 'Travelling with your family fosters strong bonds and lets you all share in the treasured experiences that world travel often delivers, so pack your bags, your camera and make memories with your children and partner that will no doubt last a lifetime\r\n\r\n '),
(12, 'Popular Extended Tours', '', '', 0, 1, 'Extended tours make it easy to fit all your travel inspirations into one trip, ensuring you return home feeling like you fulfilled everything you set out to experience.\r\n\r\n '),
(13, 'Popular Cycling Tours', '', '', 0, 1, 'Cycling through countries allows for slower and more observant travel, as well as access to roads less travelled and sights that are often missed by those more focused on reaching their destination.\r\n\r\n \r\n\r\n '),
(14, 'Outdoor Activities', '', '', 0, 1, 'Even adventure needs a little direction. Taking an adventure tour with experienced guides will ensure every moment is a highlight.\r\n\r\n '),
(15, 'Seasonal Tours', '', '', 0, 1, 'Don\'t let the festivities go on without you. With a holiday and seasonal tour you can experience first-hand the world\'s biggest and most underground celebrations, while meeting people from all over the globe\r\n\r\n '),
(16, 'Cultural Tours', '', '', 0, 1, 'Culture has a way of defining every country and person in the world, giving the places we visit and the people we meet the extra spice that makes them worth remembering.\r\n\r\n '),
(17, 'Luxury Tours', '', '', 0, 1, 'There’s no reason why travel can’t be both luxurious and adventurous. The marvels of the world like Paris’ romantic streets are best experienced with the finer comforts in life\r\n\r\n '),
(18, 'Honeymoon Tours', '', '', 0, 1, 'Romantic tours provide the perfect settings and activities to make your honeymoon special or turn your typical holiday into a beautiful love affair worth remembering.\r\n\r\n '),
(19, 'Adventure Tours', '', '', 0, 1, 'Take the adventure of a lifetime. If you long for adventure and excitement or just want to get out of your comfort zone we have you covered\r\n\r\n '),
(20, 'Food and Wine Tours', '', '', 0, 1, 'Food, and to a slightly lesser extent, wine are staples of everyday life, but have you ever sipped an Italian merlot poured straight from the barrel or tasted frog legs inside a Paris restaurant?\r\n\r\n '),
(21, 'Relaxing Tour', '', '', 0, 1, 'Help you to relax and reduce stress from your hard working life');
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_user`
--
DROP TABLE IF EXISTS `tbpro_user`;
CREATE TABLE `tbpro_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;
-- --------------------------------------------------------
--
-- Table structure for table `tbpro_view`
--
DROP TABLE IF EXISTS `tbpro_view`;
CREATE TABLE `tbpro_view` (
`id` int(11) UNSIGNED NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(200) NOT NULL,
`alias` varchar(200) NOT NULL,
`published` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbpro_view`
--
INSERT INTO `tbpro_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, '');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `tbpro_activity`
--
ALTER TABLE `tbpro_activity`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_apps`
--
ALTER TABLE `tbpro_apps`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_billing`
--
ALTER TABLE `tbpro_billing`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_block`
--
ALTER TABLE `tbpro_block`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_cart`
--
ALTER TABLE `tbpro_cart`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `id` (`id`);
--
-- Indexes for table `tbpro_category`
--
ALTER TABLE `tbpro_category`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_category_tag`
--
ALTER TABLE `tbpro_category_tag`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`category_id`),
ADD KEY `tag_id` (`tag_id`);
--
-- Indexes for table `tbpro_config`
--
ALTER TABLE `tbpro_config`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_country`
--
ALTER TABLE `tbpro_country`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_coupon`
--
ALTER TABLE `tbpro_coupon`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_currency`
--
ALTER TABLE `tbpro_currency`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_customer`
--
ALTER TABLE `tbpro_customer`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_customize`
--
ALTER TABLE `tbpro_customize`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_destination`
--
ALTER TABLE `tbpro_destination`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_discount`
--
ALTER TABLE `tbpro_discount`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_email`
--
ALTER TABLE `tbpro_email`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_employee`
--
ALTER TABLE `tbpro_employee`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_event`
--
ALTER TABLE `tbpro_event`
ADD PRIMARY KEY (`id`),
ADD KEY `service_id` (`service_id`),
ADD KEY `location_id` (`location_id`);
--
-- Indexes for table `tbpro_event_employee`
--
ALTER TABLE `tbpro_event_employee`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`event_id`),
ADD KEY `employee_id` (`employee_id`);
--
-- Indexes for table `tbpro_event_tag`
--
ALTER TABLE `tbpro_event_tag`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`event_id`),
ADD KEY `tag_id` (`tag_id`);
--
-- Indexes for table `tbpro_extra`
--
ALTER TABLE `tbpro_extra`
ADD PRIMARY KEY (`id`),
ADD KEY `object_id` (`object_id`);
--
-- Indexes for table `tbpro_facility`
--
ALTER TABLE `tbpro_facility`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_finance`
--
ALTER TABLE `tbpro_finance`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_gallery`
--
ALTER TABLE `tbpro_gallery`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_itinerary`
--
ALTER TABLE `tbpro_itinerary`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_location`
--
ALTER TABLE `tbpro_location`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_notification`
--
ALTER TABLE `tbpro_notification`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_order`
--
ALTER TABLE `tbpro_order`
ADD PRIMARY KEY (`id`),
ADD KEY `order_status_id` (`order_status_id`);
--
-- Indexes for table `tbpro_orderpackage`
--
ALTER TABLE `tbpro_orderpackage`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_order_customer`
--
ALTER TABLE `tbpro_order_customer`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_order_detail`
--
ALTER TABLE `tbpro_order_detail`
ADD PRIMARY KEY (`id`),
ADD KEY `order_id` (`order_id`),
ADD KEY `order_id_2` (`order_id`);
--
-- Indexes for table `tbpro_order_detail_rate`
--
ALTER TABLE `tbpro_order_detail_rate`
ADD PRIMARY KEY (`id`),
ADD KEY `order_detail_id` (`order_detail_id`);
--
-- Indexes for table `tbpro_order_package_rate`
--
ALTER TABLE `tbpro_order_package_rate`
ADD PRIMARY KEY (`id`),
ADD KEY `woobooking_order_package_rate_ibfk_1` (`order_package_id`);
--
-- Indexes for table `tbpro_order_status`
--
ALTER TABLE `tbpro_order_status`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`),
ADD KEY `id` (`id`);
--
-- Indexes for table `tbpro_package`
--
ALTER TABLE `tbpro_package`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_package_event`
--
ALTER TABLE `tbpro_package_event`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`event_id`),
ADD KEY `employee_id` (`package_id`);
--
-- Indexes for table `tbpro_package_tag`
--
ALTER TABLE `tbpro_package_tag`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`package_id`),
ADD KEY `tag_id` (`tag_id`);
--
-- Indexes for table `tbpro_payment`
--
ALTER TABLE `tbpro_payment`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_rate`
--
ALTER TABLE `tbpro_rate`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`object_id`);
--
-- Indexes for table `tbpro_season`
--
ALTER TABLE `tbpro_season`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_service`
--
ALTER TABLE `tbpro_service`
ADD PRIMARY KEY (`id`),
ADD KEY `category_id` (`category_id`);
--
-- Indexes for table `tbpro_service_employee`
--
ALTER TABLE `tbpro_service_employee`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `event_id` (`employee_id`,`service_id`);
--
-- Indexes for table `tbpro_shipping`
--
ALTER TABLE `tbpro_shipping`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_sms`
--
ALTER TABLE `tbpro_sms`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_smscontent`
--
ALTER TABLE `tbpro_smscontent`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_state`
--
ALTER TABLE `tbpro_state`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_tag`
--
ALTER TABLE `tbpro_tag`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `tbpro_tour`
--
ALTER TABLE `tbpro_tour`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_tourpackage`
--
ALTER TABLE `tbpro_tourpackage`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_tourproperty`
--
ALTER TABLE `tbpro_tourproperty`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_tourtype`
--
ALTER TABLE `tbpro_tourtype`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_user`
--
ALTER TABLE `tbpro_user`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tbpro_view`
--
ALTER TABLE `tbpro_view`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `tbpro_activity`
--
ALTER TABLE `tbpro_activity`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;
--
-- AUTO_INCREMENT for table `tbpro_apps`
--
ALTER TABLE `tbpro_apps`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbpro_billing`
--
ALTER TABLE `tbpro_billing`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbpro_block`
--
ALTER TABLE `tbpro_block`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=215;
--
-- AUTO_INCREMENT for table `tbpro_cart`
--
ALTER TABLE `tbpro_cart`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_category`
--
ALTER TABLE `tbpro_category`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `tbpro_category_tag`
--
ALTER TABLE `tbpro_category_tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_country`
--
ALTER TABLE `tbpro_country`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;
--
-- AUTO_INCREMENT for table `tbpro_coupon`
--
ALTER TABLE `tbpro_coupon`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_currency`
--
ALTER TABLE `tbpro_currency`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `tbpro_customer`
--
ALTER TABLE `tbpro_customer`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_customize`
--
ALTER TABLE `tbpro_customize`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_destination`
--
ALTER TABLE `tbpro_destination`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_discount`
--
ALTER TABLE `tbpro_discount`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbpro_email`
--
ALTER TABLE `tbpro_email`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbpro_employee`
--
ALTER TABLE `tbpro_employee`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_event`
--
ALTER TABLE `tbpro_event`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_event_employee`
--
ALTER TABLE `tbpro_event_employee`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_event_tag`
--
ALTER TABLE `tbpro_event_tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_extra`
--
ALTER TABLE `tbpro_extra`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_facility`
--
ALTER TABLE `tbpro_facility`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- AUTO_INCREMENT for table `tbpro_finance`
--
ALTER TABLE `tbpro_finance`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_gallery`
--
ALTER TABLE `tbpro_gallery`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=700;
--
-- AUTO_INCREMENT for table `tbpro_itinerary`
--
ALTER TABLE `tbpro_itinerary`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT for table `tbpro_location`
--
ALTER TABLE `tbpro_location`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
--
-- AUTO_INCREMENT for table `tbpro_notification`
--
ALTER TABLE `tbpro_notification`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order`
--
ALTER TABLE `tbpro_order`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_orderpackage`
--
ALTER TABLE `tbpro_orderpackage`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order_customer`
--
ALTER TABLE `tbpro_order_customer`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order_detail`
--
ALTER TABLE `tbpro_order_detail`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order_detail_rate`
--
ALTER TABLE `tbpro_order_detail_rate`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order_package_rate`
--
ALTER TABLE `tbpro_order_package_rate`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_order_status`
--
ALTER TABLE `tbpro_order_status`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tbpro_package`
--
ALTER TABLE `tbpro_package`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tbpro_package_event`
--
ALTER TABLE `tbpro_package_event`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_package_tag`
--
ALTER TABLE `tbpro_package_tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `tbpro_payment`
--
ALTER TABLE `tbpro_payment`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- AUTO_INCREMENT for table `tbpro_rate`
--
ALTER TABLE `tbpro_rate`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_season`
--
ALTER TABLE `tbpro_season`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `tbpro_service`
--
ALTER TABLE `tbpro_service`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_service_employee`
--
ALTER TABLE `tbpro_service_employee`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_shipping`
--
ALTER TABLE `tbpro_shipping`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_sms`
--
ALTER TABLE `tbpro_sms`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbpro_smscontent`
--
ALTER TABLE `tbpro_smscontent`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_state`
--
ALTER TABLE `tbpro_state`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `tbpro_tag`
--
ALTER TABLE `tbpro_tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `tbpro_tour`
--
ALTER TABLE `tbpro_tour`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
--
-- AUTO_INCREMENT for table `tbpro_tourpackage`
--
ALTER TABLE `tbpro_tourpackage`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT for table `tbpro_tourproperty`
--
ALTER TABLE `tbpro_tourproperty`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1373;
--
-- AUTO_INCREMENT for table `tbpro_tourtype`
--
ALTER TABLE `tbpro_tourtype`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `tbpro_user`
--
ALTER TABLE `tbpro_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbpro_view`
--
ALTER TABLE `tbpro_view`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
SET FOREIGN_KEY_CHECKS=1;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;