-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: db
-- Generation Time: Mar 30, 2019 at 12:21 PM
-- Server version: 5.6.41
-- PHP Version: 7.2.8
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: `tobin_eventTimeOut`
--
-- --------------------------------------------------------
--
-- Table structure for table `booking`
--
CREATE TABLE `booking` (
`id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL COMMENT 'Guest - 0',
`bookId` varchar(45) DEFAULT NULL,
`event_date_id` int(11) NOT NULL,
`qrcode` varchar(100) DEFAULT NULL,
`no_of_ticket` int(11) DEFAULT NULL,
`ticket_details` varchar(255) NOT NULL,
`amount` double DEFAULT NULL,
`reserved_by` int(11) DEFAULT '3' COMMENT '1 - SuperAdmin\n2 - Provider\n3 - Customer',
`booking_date` varchar(50) DEFAULT NULL,
`payment_status` tinyint(3) NOT NULL COMMENT '0=>Pending, 1=>Complete',
`status` int(11) DEFAULT '1' COMMENT '0 - Cancelled, 1 - Booked, 2 - Completed, 3 - Pending, 4 - Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `booking`
--
INSERT INTO `booking` (`id`, `event_id`, `customer_id`, `bookId`, `event_date_id`, `qrcode`, `no_of_ticket`, `ticket_details`, `amount`, `reserved_by`, `booking_date`, `payment_status`, `status`) VALUES
(1, 17, 3, 'TO1903085247', 196, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 1110, 3, '2019-02-01 10:15:20', 0, 0),
(2, 19, 3, 'TO1903085925', 1040, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '{\"color\":\"Yellow\",\"price\":\"100\",\"no_ticket\":1,\"total_price\":100}', 100, 3, '2019-02-01 10:15:20', 0, 2),
(3, 20, 3, 'TO1903088198', 1242, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '{\"color\":\"Yellow\",\"price\":\"100\",\"no_ticket\":1,\"total_price\":100}', 100, 3, '2019-02-01 10:15:20', 0, 2),
(4, 17, 3, 'TO1903085474', 999, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 1110, 3, '2019-02-01 10:15:20', 0, 2),
(5, 20, 3, 'TO1903085090', 1239, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '{\"color\":\"Yellow\",\"price\":\"100\",\"no_ticket\":1,\"total_price\":100}', 100, 3, '2019-02-01 10:15:20', 0, 2),
(6, 17, 3, 'TO1903082181', 999, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '\"\"', 555, 3, '2019-02-01 10:15:20', 0, 2),
(7, 17, 3, 'TO1903081950', 1002, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '\"\"', 555, 3, '2019-02-01 10:15:20', 0, 2),
(8, 23, 3, 'TO1903082372', 4214, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 4, '\"\"', 400, 3, '2019-02-30 10:15:20', 0, 2),
(9, 24, 3, 'TO1903087064', 4215, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 3, '{\"color\":\"Red\",\"price\":\"100\",\"no_ticket\":3,\"total_price\":300}', 300, 3, '2019-02-30 10:15:20', 0, 2),
(10, 23, 20, 'TO1903081123', 4214, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 4, '\"\"', 400, 3, '2019-02-30 10:15:20', 0, 2),
(11, 25, 21, 'TO1903085371', 4469, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 22, 3, '2019-02-30 10:15:20', 0, 2),
(12, 33, 3, 'TO1903216180', 4469, 'assets/uploads/qrcode/bookCode_1553142599.png', 5, '[{\"color\":\"Red\",\"price\":\"11\",\"no_ticket\":\"2\",\"total_price\":\"22\"}]', 250, 3, '2019-02-30 10:15:20', 0, 2),
(13, 21, 3, 'TO1903267113', 2000, 'assets/uploads/qrcode/bookCode_1553602852.png', 1, '\"\"', 555, 3, '2019-03-26 12:20:52', 0, 3),
(14, 21, 3, 'TO1903268715', 2000, 'assets/uploads/qrcode/bookCode_1553602877.png', 1, '\"\"', 555, 3, '2019-03-26 12:21:17', 0, 3),
(15, 21, 3, 'TO1903262823', 2000, 'assets/uploads/qrcode/bookCode_1553602891.png', 1, '\"\"', 555, 3, '2019-03-26 12:21:31', 0, 3),
(16, 21, 3, 'TO1903264199', 2000, 'assets/uploads/qrcode/bookCode_1553602902.png', 1, '\"\"', 555, 3, '2019-03-26 12:21:42', 0, 3),
(17, 21, 3, 'TO1903268104', 2000, 'assets/uploads/qrcode/bookCode_1553602915.png', 1, '\"\"', 555, 3, '2019-03-26 12:21:55', 0, 3),
(18, 21, 3, 'TO1903262792', 2000, 'assets/uploads/qrcode/bookCode_1553602933.png', 1, '\"\"', 555, 3, '2019-03-26 12:22:13', 0, 3),
(19, 17, 20, 'TO1903266268', 4360, 'assets/uploads/qrcode/bookCode_1553603090.png', 4, '\"\"', 2220, 3, '2019-03-26 12:24:50', 0, 3),
(20, 23, 20, 'TO1903267405', 4214, 'assets/uploads/qrcode/bookCode_1553603118.png', 1, '[{\"color\":\"Red\",\"price\":\"11\",\"no_ticket\":\"2\",\"total_price\":\"22\"}]', 100, 3, '2019-03-26 12:25:18', 0, 3),
(21, 21, 3, 'TO1903266901', 2000, 'assets/uploads/qrcode/bookCode_1553603285.png', 1, '\"\"', 555, 3, '2019-03-26 12:28:05', 0, 3),
(22, 21, 3, 'TO1903264379', 2000, 'assets/uploads/qrcode/bookCode_1553603297.png', 1, '\"\"', 555, 3, '2019-03-26 12:28:17', 0, 3),
(23, 21, 3, 'TO1903265275', 2000, 'assets/uploads/qrcode/bookCode_1553603311.png', 1, '\"\"', 555, 3, '2019-03-26 12:28:32', 0, 3),
(24, 21, 3, 'TO1903267795', 2000, 'assets/uploads/qrcode/bookCode_1553603340.png', 1, '\"\"', 555, 3, '2019-03-26 12:29:00', 0, 3),
(25, 21, 3, 'TO1903264476', 2000, 'assets/uploads/qrcode/bookCode_1553603633.png', 1, '\"\"', 555, 3, '2019-03-26 12:33:53', 0, 3),
(26, 21, 3, 'TO1903269137', 2000, 'assets/uploads/qrcode/bookCode_1553603777.png', 1, '\"\"', 555, 3, '2019-03-26 12:36:17', 0, 3),
(27, 17, 3, 'TO1903268980', 4355, 'assets/uploads/qrcode/bookCode_1553604011.png', 1, '\"\"', 555, 3, '2019-03-26 12:40:11', 0, 3),
(28, 17, 3, 'TO1903268895', 4355, 'assets/uploads/qrcode/bookCode_1553604049.png', 1, '\"\"', 555, 3, '2019-03-26 12:40:49', 0, 3),
(29, 17, 3, 'TO1903265311', 4356, 'assets/uploads/qrcode/bookCode_1553604123.png', 1, '\"\"', 555, 3, '2019-03-26 12:42:03', 0, 3),
(30, 17, 3, 'TO1903267519', 4356, 'assets/uploads/qrcode/bookCode_1553604241.png', 1, '\"\"', 555, 3, '2019-03-26 12:44:01', 0, 3),
(31, 17, 3, 'TO1903263754', 4356, 'assets/uploads/qrcode/bookCode_1553604697.png', 1, '\"\"', 555, 3, '2019-03-26 12:51:37', 0, 3),
(32, 17, 3, 'TO1903264404', 4356, 'assets/uploads/qrcode/bookCode_1553606543.png', 1, '\"\"', 555, 3, '2019-03-26 13:22:23', 0, 1),
(33, 17, 3, 'TO1903275812', 4359, 'assets/uploads/qrcode/bookCode_1553684862.png', 1, '\"\"', 555, 3, '2019-03-27 11:07:42', 0, 3),
(34, 34, 3, 'TO1903274660', 4724, 'assets/uploads/qrcode/bookCode_1553691137.png', 1, '\"\"', 49, 3, '2019-03-27 12:52:17', 0, 1),
(35, 34, 3, 'TO1903273159', 4726, 'assets/uploads/qrcode/bookCode_1553691355.png', 1, '\"\"', 49, 3, '2019-03-27 12:55:55', 0, 1),
(36, 17, 3, 'TO1903271343', 4360, 'assets/uploads/qrcode/bookCode_1553691401.png', 1, '\"\"', 555, 3, '2019-03-27 12:56:41', 0, 3),
(37, 17, 3, 'TO1903276659', 4359, 'assets/uploads/qrcode/bookCode_1553691426.png', 1, '\"\"', 555, 3, '2019-03-27 12:57:06', 0, 1),
(38, 41, 3, 'TO1903277067', 4920, 'assets/uploads/qrcode/bookCode_1553691725.png', 2, '\"\"', 2000, 3, '2019-03-27 13:02:05', 0, 3),
(39, 41, 3, 'TO1903272547', 4919, 'assets/uploads/qrcode/bookCode_1553691782.png', 1, '\"\"', 1000, 3, '2019-03-27 13:03:02', 0, 1),
(40, 34, 3, 'TO1903279794', 4724, 'assets/uploads/qrcode/bookCode_1553691860.png', 1, '\"\"', 49, 3, '2019-03-27 13:04:21', 0, 3),
(41, 34, 3, 'TO1903275984', 4725, 'assets/uploads/qrcode/bookCode_1553691909.png', 1, '\"\"', 49, 3, '2019-03-27 13:05:09', 0, 3),
(42, 34, 3, 'TO1903279748', 4724, 'assets/uploads/qrcode/bookCode_1553691949.png', 1, '\"\"', 49, 3, '2019-03-27 13:05:49', 0, 1),
(43, 41, 3, 'TO1903277408', 4917, 'assets/uploads/qrcode/bookCode_1553692067.png', 1, '\"\"', 1000, 3, '2019-03-27 13:07:47', 0, 1),
(44, 41, 3, 'TO1903276264', 4917, 'assets/uploads/qrcode/bookCode_1553692183.png', 1, '\"\"', 1000, 3, '2019-03-27 13:09:43', 0, 3),
(45, 41, 3, 'TO1903282880', 4917, 'assets/uploads/qrcode/bookCode_1553749895.png', 1, '\"\"', 1000, 3, '2019-03-28 05:11:35', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `checker`
--
CREATE TABLE `checker` (
`id` int(11) NOT NULL,
`provider_id` int(11) DEFAULT NULL,
`username` varchar(50) DEFAULT NULL,
`password` varchar(150) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `checker`
--
INSERT INTO `checker` (`id`, `provider_id`, `username`, `password`, `status`) VALUES
(1, 1, 'anu@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 1);
-- --------------------------------------------------------
--
-- Table structure for table `commission_payment`
--
CREATE TABLE `commission_payment` (
`id` int(11) NOT NULL,
`provider_id` int(11) DEFAULT NULL,
`last_payment_date` varchar(150) DEFAULT NULL,
`total_booking` double DEFAULT NULL,
`tickets_sold` int(11) DEFAULT NULL,
`total_payed` double DEFAULT NULL,
`last_commission_payed` double DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `commission_payment`
--
INSERT INTO `commission_payment` (`id`, `provider_id`, `last_payment_date`, `total_booking`, `tickets_sold`, `total_payed`, `last_commission_payed`, `status`) VALUES
(1, 23, '2019-02-15 00:00:00', 15, 36, 2560, 800, 2),
(4, 23, '2019-03-07 00:00:00', 12, 27, 5002, 1500.6, 1);
-- --------------------------------------------------------
--
-- Table structure for table `customer`
--
CREATE TABLE `customer` (
`id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`phone` varchar(25) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`gender` varchar(15) NOT NULL COMMENT '1 => Male 2 => Female 3 => Others',
`dob` varchar(50) NOT NULL,
`city` varchar(255) NOT NULL,
`reset_key` varchar(255) DEFAULT NULL,
`social_id` varchar(250) DEFAULT NULL,
`profile_image` varchar(250) DEFAULT NULL,
`phone_verified` int(11) DEFAULT '0' COMMENT '1= Verified, 0=>Not'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` (`id`, `customer_id`, `name`, `phone`, `email`, `gender`, `dob`, `city`, `reset_key`, `social_id`, `profile_image`, `phone_verified`) VALUES
(1, 3, 'Tester', '9995559194', 'customer@gmail.com', '2', '03/14/2019', 'Tester City', NULL, NULL, 'assets/uploads/services/1552060103_Screenshot_2019-03-08_at_9.18.08_PM.png', 0),
(12, 16, NULL, '1234567899', 'test@gmail.com', '', '', '', NULL, NULL, NULL, 0),
(13, 17, NULL, '9562481145', 'geethu@nuvento.com', '', '', '', NULL, NULL, NULL, 0),
(14, 18, NULL, '1234567890', 'test1@gmail.com', '', '', '', NULL, NULL, NULL, 0),
(15, 19, NULL, '1234567893', 'test2@gmail.com', '', '', '', NULL, NULL, NULL, 0),
(16, 20, NULL, '0987654321', 'geethumariamathew@gmail.com', '', '', '', NULL, NULL, NULL, 0),
(17, 21, NULL, '0568813262', 'ibrahimtimes@gmail.com', '', '', '', NULL, NULL, NULL, 0),
(18, 24, NULL, '9020839391', 'test@gamil.com', '', '', '', NULL, NULL, NULL, 0),
(19, 25, NULL, '+919840357236', 'tester@gmail.com', '', '', '', NULL, NULL, NULL, 0);
-- --------------------------------------------------------
--
-- Table structure for table `customer_auth`
--
CREATE TABLE `customer_auth` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`auth_token` varchar(255) NOT NULL,
`sync_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customer_auth`
--
INSERT INTO `customer_auth` (`id`, `user_id`, `auth_token`, `sync_time`) VALUES
(1, 3, 'ba436bc1b7881e14ee892b03210d5b54', '2019-02-12 13:44:16'),
(2, 4, '75d49c8766fd4901491055086d1d8243', '2019-02-13 09:22:42'),
(3, 4, '211d5241f4dec6974803ed373c935c2d', '2019-02-13 09:23:53'),
(4, 3, '2591e63438bc954dfcd34931b363d455', '2019-02-13 09:24:27'),
(5, 5, '7295010bd3934cb61acd8b44ec98da41', '2019-02-13 09:25:32'),
(6, 6, '94ddb63001d2500d156c313488ae1562', '2019-02-13 09:26:15'),
(7, 7, '34abdc1d3faad3ff72f907084ba53dbb', '2019-02-13 09:43:51'),
(8, 8, '85ac1894e482c039cbc7bc102c01b869', '2019-02-13 09:44:42'),
(9, 9, '1e914ac0f56d95fbe3c3d7e1151b7fd0', '2019-02-13 10:08:29'),
(10, 3, 'fd7b647d239e59e7090e7b7e95877c34', '2019-02-13 10:54:23'),
(11, 3, 'd4668b818afba5d6dee3dceed9fecafb', '2019-02-13 15:54:02'),
(12, 3, 'cb6ca5d535652207197800979e3ddd4a', '2019-02-13 15:54:57'),
(13, 3, '536b281d6ad31931818cc2b552dc2010', '2019-02-13 15:55:11'),
(14, 3, '7591c952051a7b910ab75f56822191f2', '2019-02-14 14:20:10'),
(15, 3, '33f6dc286585395be2c405cfb9674c07', '2019-02-14 14:22:46'),
(16, 3, '11866cec9dc42a8be5fdac02a464bfe5', '2019-02-14 15:18:29'),
(17, 3, '83e3a796715f3dc4038bc769a2f3f2a0', '2019-02-15 09:20:24'),
(18, 12, '967846009ab638e86e6e2ded48ef174b', '2019-02-15 09:42:37'),
(19, 13, 'efb9b927d1328de531f2b65e6ac8cb35', '2019-02-15 09:53:28'),
(20, 16, 'df91fb9f04394294d7d1e354bd374058', '2019-03-08 12:52:00'),
(21, 16, '595d75e0d90c660d763d29360d17d0a5', '2019-03-08 12:52:14'),
(22, 16, 'c964ec68baa4353e81cbb41a4bc30dbd', '2019-03-08 12:54:34'),
(23, 16, 'dc0d582d28193bb91c7baa2850f3080a', '2019-03-08 12:56:17'),
(24, 16, 'fa711fcf480c7bab7afba95a09950191', '2019-03-08 12:59:38'),
(25, 16, 'c2af64cf88c337fce5aecea59765c995', '2019-03-08 13:03:13'),
(26, 17, 'e92e458a741979031723dda4ab7d32db', '2019-03-08 13:05:11'),
(27, 16, '41e76d96b73dfc26958119082340e9e4', '2019-03-08 13:06:58'),
(28, 16, 'b171be0f785dc7b2a4a1d4fdbf30808d', '2019-03-08 13:08:41'),
(29, 16, '0c183d964a381ee18318046d0d8e1e79', '2019-03-08 13:11:23'),
(30, 18, '87e928c366820b3011d7daf76d414fe4', '2019-03-08 13:14:29'),
(31, 19, '1d8e54369e6bb0948947437e5596a544', '2019-03-08 13:17:14'),
(32, 16, '4de93f685ddb564fdacf6342bbc3c7c0', '2019-03-08 13:17:50'),
(33, 16, 'e132a5666e8af75137859f4ac253e316', '2019-03-08 13:18:58'),
(34, 17, '54cd152f61326b4375076208bfac6409', '2019-03-08 13:21:07'),
(35, 16, '20b440d9aea1701904515d422aefa01e', '2019-03-08 13:26:38'),
(36, 16, '113be253e8f406f3fe41dd51c5ac188b', '2019-03-08 13:29:34'),
(37, 16, 'adfd04b63fc47f308e80f5c621f0a34d', '2019-03-08 13:32:51'),
(38, 16, 'f19a571a8d0dd389a2401e3674be08b9', '2019-03-08 13:35:38'),
(39, 16, 'faadd39ec135b80b64471b80d1e0f423', '2019-03-08 13:36:46'),
(40, 3, '2ffcd9413caf74e250e9ff23893ac598', '2019-03-08 13:38:28'),
(41, 16, 'f3df5aeebb7bd325b505330025efbe0b', '2019-03-08 13:40:00'),
(42, 3, '305262fbce4ac56b358dd82b8589ac80', '2019-03-08 13:59:52'),
(43, 3, '7b8f3db8111b3af942f356478b6fb45f', '2019-03-08 13:59:52'),
(44, 3, 'eff5886f70784a3c27958a8e4caa72d1', '2019-03-08 14:21:05'),
(45, 3, 'cfd9609dfbf3ad7f2cb16729422bd6ea', '2019-03-08 15:18:43'),
(46, 3, 'd4e5fd0db0c715dbd5016ef269ff7fc5', '2019-03-08 15:36:36'),
(47, 3, 'd39dc91d0cc6cda32c21c864ae066a41', '2019-03-08 15:51:56'),
(48, 3, 'ee9f69df889ac89f7d5f4b1ee10f2fa8', '2019-03-08 17:47:38'),
(49, 20, 'd0f1b38da1c0886a4d0121c51ef73aef', '2019-03-08 18:36:57'),
(50, 20, 'c47521afd9cc666eeb8cac03b3f18ed0', '2019-03-08 18:37:16'),
(51, 3, '820758d847a2a334504407a03213b952', '2019-03-08 18:46:09'),
(52, 21, '5010791591687a087531bbe8015254be', '2019-03-08 19:58:31'),
(53, 21, 'a11aec4209bce0e42907790e20cf49ce', '2019-03-08 20:38:42'),
(54, 21, 'b64f84349a342be31b4996c26a02a0b4', '2019-03-08 21:03:39'),
(55, 21, 'fed276ef63537a60089c6e28799a54b2', '2019-03-08 21:35:45'),
(56, 21, 'a1e84ab80b3f71dd4bf79b74d355847d', '2019-03-08 21:39:35'),
(57, 21, 'a977897aebe5c41a81daf7eadb1c6421', '2019-03-08 21:56:18'),
(58, 21, 'a47d5725da350a69e0d9479644d702ba', '2019-03-08 22:08:27'),
(59, 21, '3ab7a0c68066895896efbb691db1832f', '2019-03-08 22:15:57'),
(60, 21, 'da00849c2979971a7e549aa2bb9e3e65', '2019-03-08 22:24:01'),
(61, 21, '0d12f9e7d52e18fe774d850f229724c3', '2019-03-09 13:51:01'),
(62, 3, 'b44276bf80a784d9163193e42bef95b2', '2019-03-11 05:10:48'),
(63, 24, '78ccb5403f419ee95d4bbee1be228645', '2019-03-26 11:51:44'),
(64, 16, 'e7328e3f8a43821902c96a10969a9e54', '2019-03-26 11:52:25'),
(65, 3, '0715e5ed8c598de8c1e314d73cba1c99', '2019-03-26 12:38:12'),
(66, 16, 'ad84e4d3a747aeb94d93de8e0b4dc84a', '2019-03-26 13:31:25'),
(67, 3, 'e6723984b05c3a7500a1dacb8321477b', '2019-03-27 11:07:38'),
(68, 3, '591201aea6a6365a551fd3f391d6c983', '2019-03-27 12:56:28'),
(69, 3, 'aae929d350208b29c2c5ca1d51fdfcf7', '2019-03-27 13:02:00'),
(70, 16, '259f191056844b47701cfb9b475dea44', '2019-03-28 04:50:55'),
(71, 25, '27406e4670b097fd29ec481504742067', '2019-03-28 05:05:04'),
(72, 3, 'f9b26905a7aa6564d6dd9591314f8894', '2019-03-28 05:10:40'),
(73, 3, '46bb3452c641c9e5235268628503b0a1', '2019-03-29 20:01:18');
-- --------------------------------------------------------
--
-- Table structure for table `events`
--
CREATE TABLE `events` (
`event_id` int(11) NOT NULL,
`venue_id` int(11) DEFAULT NULL,
`category_id` int(11) DEFAULT NULL,
`provider_id` int(11) DEFAULT NULL,
`event_name` varchar(250) DEFAULT NULL,
`event_discription` longtext,
`max_booking` int(10) NOT NULL COMMENT '=> maximum bookings per customer',
`seat_pricing` longtext,
`has_payment` tinyint(3) NOT NULL DEFAULT '1',
`avg_price` double NOT NULL,
`custom_seat_layout` longtext,
`status` tinyint(3) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive, 2 - Deleted 3 - Waiting For Approval'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `events`
--
INSERT INTO `events` (`event_id`, `venue_id`, `category_id`, `provider_id`, `event_name`, `event_discription`, `max_booking`, `seat_pricing`, `has_payment`, `avg_price`, `custom_seat_layout`, `status`) VALUES
(17, 15, 3, 23, 'Hotel - The Blooms ', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n', 14, '{\"price\":\"555\",\"price_details\":\"For a table in roof top (1 Hour)\"}', 1, 0, '', 1),
(18, 17, 5, 23, 'Movie - LULU PVR Movies', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.</p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(19, 18, 5, 23, 'PVR Movie Show', '<p><strong>PVR Cinemas</strong></p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(20, 18, 5, 23, 'PVR Movie House ', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n <li> is simply dummy text of the printing and typesetting industry.</li>\r\n <li>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s,</li>\r\n <li>when an unknown printer took a galley of type and scrambled it to make a type specimen book.</li>\r\n</ul>\r\n\r\n<p><strong>It has survived not only five centuries,</strong></p>\r\n\r\n<p>but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(21, 16, 6, 1, 'Hotel Mubeena', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n <li> is simply dummy text of the printing and typesetting industry.</li>\r\n <li>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s,</li>\r\n <li>when an unknown printer took a galley of type and scrambled it to make a type specimen book.</li>\r\n</ul>\r\n\r\n<p><strong>It has survived not only five centuries,</strong></p>\r\n\r\n<p>but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 14, '{\"price\":\"555\",\"price_details\":\"Far a Table\"}', 1, 0, '', 2),
(22, 18, 5, 23, 'iMax 3D Movie Show', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n <li> is simply dummy text of the printing and typesetting industry.</li>\r\n <li>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s,</li>\r\n <li>when an unknown printer took a galley of type and scrambled it to make a type specimen book.</li>\r\n</ul>\r\n\r\n<p><strong>It has survived not only five centuries,</strong></p>\r\n\r\n<p>but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(23, 15, 3, 23, 'Leprecrawl: NYC\'s Best St. Patrick\'s Bar Crawl', '<p>#party #charity #bars</p>\r\n\r\n<p><strong>What you get</strong></p>\r\n\r\n<ul>\r\n <li>Ticket for 1 or 2 to Leprecrawl: NYC's Best St. Patrick's Bar Crawl From 1:00 pm - 10:00 pm</li>\r\n <li>Free Lucky Shot at registration to get the party started!</li>\r\n <li>Discounted $4 beers and $5 shots at all the bars</li>\r\n <li>$100 Cash Prize for the Best Outfit</li>\r\n <li>Professional photographer at the event</li>\r\n <li>NYC Leprecrawl Map to help guide you from bar to bar</li>\r\n</ul>\r\n\r\n<p><br />\r\nSome of the participating bars</p>\r\n\r\n<ul>\r\n <li>Shades of Green</li>\r\n <li>Keybar</li>\r\n <li>Lucky on B</li>\r\n <li>The Ainsworth East Village</li>\r\n <li>Coyote Ugly</li>\r\n <li>Mama's Bar</li>\r\n</ul>\r\n\r\n<p><br />\r\n<strong>Why this event is for you</strong><br />\r\nGrab your all-access VIP Leprecrawl wrist-band and lets get this party started! Your wristband is going to grant you access to all bars and their drinks specials so all you have to worry about is partying like there’s no tomorrow! All crawlers can follow the detailed map that will direct them to the featured bars at the right time and your lovely guide will, of course, be there to show you the ropes. The Leprecrawl is NYC's best St. Patrick's Bar Crawl, so break out your green gear and get ready to enjoy awesome beer & shot specials at 10 of NYC's best bars during this all day event. Are you ready to explore the best bar scenes with your fellow leprechauns? Smother yourself with some green and test out your luck! Who will be the luckiest one to survive and end up on top?<br />\r\n </p>\r\n\r\n<ul>\r\n <li>Age requirement: 21+ with valid ID</li>\r\n</ul>\r\n', 14, '{\"price\":\"100\",\"price_details\":\"Test\"}', 1, 0, '', 1),
(24, 20, 7, 23, 'Cinema Build', '<p><strong>As part of the MENA Cinema Forum</strong></p>\r\n\r\n<p>series which has gained great reputation and foothold in the region and internationally as the leading cinema event, the Cinema Build KSA will bring in all the regional stakeholders and international service providers to discuss best practices to design and build world class cinemas in Saudi Arabia.</p>\r\n\r\n<ul>\r\n <li>The Kingdom has ambitious plans of opening over 2,500 screens in the next five years and its regulators are inviting global and local providers to participate in these business opportunities.</li>\r\n <li>With the licenses being issued to the first set of exhibitors, the authorities are setting up a clear road map to achieve their plan in becoming leaders in developing world class cinemas.</li>\r\n</ul>\r\n\r\n<p>The Cinema Build <em>KSA</em> Forum will also unveil a wide range of new building solutions and equipment used in developing future Cinemas, Multiplexes and Malls and will serve as a key contributor to the industry.</p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(25, 21, 3, 1, 'KAFD - 303', '<p>KAFD - 303 Popups</p>\r\n\r\n<p>Beef Bar</p>\r\n\r\n<p>Beef Bar Deli</p>\r\n\r\n<p>Harrys Pizza</p>\r\n\r\n<p> </p>\r\n', 14, '{\"price\":\"11\",\"price_details\":\"Free Entrance\"}', 1, 0, '', 1),
(26, 21, 3, 23, 'KAFD Test', '<p>Test</p>\r\n', 14, '{\"price\":\"100\",\"price_details\":\"Test\"}', 1, 0, '', 2),
(27, 20, 3, 23, 'PVR Movie Show', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(28, 21, 6, 23, 'PVR Movie Show', '<p>erferf</p>\r\n', 14, '{\"price\":\"555\",\"price_details\":\"ert\"}', 1, 0, '', 2),
(29, 18, 6, 23, 'df', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(30, 21, 6, 23, 'sdf', '', 14, '{\"price\":\"45\",\"price_details\":\"fdgvdxf\"}', 1, 0, '', 2),
(31, 18, 5, 23, 'sdrefg', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(32, 18, 4, 23, 'lkjio', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(33, 18, 13, 23, 'l[pok', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(34, 22, 3, 1, 'Shreya Ghoshal Live', '<p>Shreya Ghoshal, Bollywood’s reigning playback queen, is performing her repertoire of globally loved, award-winning tracks at Bollywood Parks, the only Bollywood-themed amusement park in the world.</p>\r\n\r\n<p>Trained in classical singing from a young age, Ghoshal made her Bollywood debut in Sanjay Leela Bhansali’s award-winning 2002 tragedy, Devdas. Since then, her career has catapulted to the high ranks of international stardom with credits in countless Indian blockbusters and a slew of accolades. Her impressive versatility covers a range of musical genres, from pop hits like ‘Radha’ to ballads like ‘Teri Meri’. Wrap up the month with Ghoshal’s top hits live at Dubai Parks and Resorts on 29 March.</p>\r\n\r\n<p>Buy a half-day ticket (AED49) to see the concert and enjoy the park from 6 pm onwards or make a day of it with the full-day pass (AED99). Bollywood Parks is home to a range of thrilling movie-themed rides, a spread of delicious food and live entertainment all day long.</p>\r\n', 1500, '{\"price\":\"49.00\",\"price_details\":\"half-day\"}', 1, 0, '', 1),
(35, 15, 3, 1, 'Hotel Blooms Test', '<h2>Websites & Domains</h2>\r\n\r\n<p>This is where you set up and manage websites.</p>\r\n', 14, '{\"price\":\"555\",\"price_details\":\"This is where you set up and manage websites.\"}', 1, 0, '', 2),
(36, 21, 4, 1, 'Test', '<p>Test</p>\r\n', 14, '{\"price\":\"10\",\"price_details\":\"free\"}', 1, 0, '', 2),
(37, 23, 4, 1, 'Standard Safari Desert SALE', '<p>After an afternoon pickup at your Dubai hotel, head into the desert wilds in a comfortable, air-conditioned 4WD vehicle. Take in the empty sands and go off-road for a roller-coaster ride around the high dunes. Hold tight as your driver takes you over the slopes, pausing at the top before slipping back down the shifting sands. Stop at the highest dune to view the sunset before continuing to a Bedouin-style campsite. Hop out here for an afternoon and evening of desert activities and entertainments. Go sandboarding, ride a camel, get a henna tattoo, don Arabian robes for a souvenir photo, and try an optional puff on a shisha (Arabic water pipe). Stay refreshed with sodas, water, tea, and coffee; and later, feast on a barbecue buffet dinner. As you relax, enjoy belly dancing and tanoura (whirling dervish) shows under the stars before a convenient return transfer to your hotel.</p>\r\n\r\n<p>Included</p>\r\n\r\n<ul>\r\n <li>Quad Bikes</li>\r\n <li>Sand boarding</li>\r\n <li>Professional Guide</li>\r\n <li>Camp Fire</li>\r\n <li>Historical tour in the around places</li>\r\n <li>Rope tugging</li>\r\n <li>Volleyball</li>\r\n <li>Mountaineering</li>\r\n <li>Desert Camp</li>\r\n <li>karaoke</li>\r\n <li>Snacks with cold and hot drinks</li>\r\n <li>Dinner Meals</li>\r\n <li>Alcoholic drinks</li>\r\n <li>Gratuities</li>\r\n</ul>\r\n\r\n<p>Not Included</p>\r\n\r\n<ul>\r\n <li>4X4 Dune Bashing</li>\r\n <li>Camels</li>\r\n <li>Horses</li>\r\n <li>BBQ</li>\r\n</ul>\r\n', 50, '{\"price\":\"249\",\"price_details\":\"single person\\/ per head basis\"}', 1, 0, '', 1),
(38, 24, 5, 1, 'Italian, Mediterranean, European Cuisine Fest', '<p>The palatial Waldorf Astoria Jeddah - Qasr al Sharq is the ideal destination for relaxation and rejuvenation. Service focused entirely on your personal needs ensures your stay in this luxury Jeddah hotel is unforgettable. Experience the ultimate in refined luxury at Waldorf Astoria Jeddah - Qasr Al Sharq with personalized butler service.</p>\r\n\r\n<p>Dine in outstanding hotel restaurants, featuring exceptional local and international cuisine. Incomparable menus reveal the unique Qasr Al Sharq experience. Special touches include private dining facilities for intimate parties and corporate dinners.</p>\r\n\r\n<p>Escape to an oasis of calm in the ladies-only Waldorf Astoria Jeddah Spa. Experience the tranquility and peace of this secluded retreat. Revitalize in the unique aquamedic pool – an indoor pool with retractable roof featuring massage jets to stimulate all body senses. Let worries drift away in the whirlpool and treat yourself to a full body aromassage.</p>\r\n\r\n<p>Male guests at Waldorf Astoria Jeddah - Qasr al Sharq have full use of fitness and recreation facilities at Hilton Fitness in adjoining Jeddah Hilton. Swim laps in the indoor and outdoor pools. Relax in the whirlpool spa, and keep up your fitness routine in the fully equipped fitness center.</p>\r\n', 50, '{\"price\":\"188.00\",\"price_details\":\"3,452 - \\u20b9 10,356 INR\"}', 1, 0, '', 1),
(39, 25, 7, 1, 'Lucifer Movie', '<p>Lucifer is a 2019 Indian Malayalam-language film directed by Prithviraj Sukumaran and written by Murali Gopy. Produced by Antony Perumbavoor through the production house Aashirvad Cinemas, the film marks Prithviraj's directorial debut and features Mohanlal in the lead role as Stephen Nedumpally, alongside a supporting cast including Prithviraj Sukumaran, Vivek Oberoi, Manju Warrier, Tovino Thomas, Indrajith Sukumaran, Saniya Iyappan, Saikumar, Kalabhavan Shajohn, and Nyla Usha. Deepak Dev composed the music for the film, and the cinematography was by Sujith Vaassudev.</p>\r\n\r\n<p>Discussion of the film began in 2016 when Murali pitched the story to Prithviraj at the sets of Tiyaan in Ramoji Film City, it was when he decided to make it his directorial debut. Murali had the story for some years. He had prepared two stories both under the working title Lucifer. The second story was used for Lucifer, which again underwent changes as part of their discussions. Initially, a film based on the first story was in development since 2012 by director Rajesh Pillai, but it did not materialise and was shelved after his death. Pre-production of Lucifer began in 2017 and Murali completed the final draft of the screenplay in February 2018. Principal photography began in mid-July that year and lasted till January 2019, with filming carried out at locations in Idukki, Thiruvananthapuram, Ernakulam, and Kollam districts, and Mumbai, Bangalore, Lakshadweep, and Russia.</p>\r\n\r\n<p>Lucifer is scheduled to be released in theatres worldwide on 28 March 2019.</p>\r\n', 100, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(40, 26, 8, 1, 'Fun @ Legoland Dubai', '<p>'LEGOLAND® Dubai and LEGOLAND® Water Park are the ultimate year-round theme park destination in the Middle East for families with children from 2-12. LEGOLAND® Dubai and LEGOLAND® Water Park are hands-on experiences allowing families to take part in a full day LEGO® themed adventures through interactive rides, water slides, models and building experiences. Just 20 minutes from the Dubai Marina'</p>\r\n', 500, '{\"price\":\"235.00\",\"price_details\":\"10:00 AM - 6:00 PM\\u00b7, tickets applicable for all adults and children above 3 years \"}', 1, 0, '', 1),
(41, 27, 9, 2, 'Fly Dubai(indoor sky-diving)', '<p>Defy gravity with skill, style and courage at iFLY Dubai! Dreamt of flying since you were young? Live your dreams with the world's first double skydiving simulator, bringing you the state of the art technologies; flying has never been this easy! iFLY Dubai offers you an unforgettable and once in a lifetime experience. Our experienced flight instructors will give you one-on-one instruction on how different body positions control how you fly inside the tunnel. You will receive free complimentary actual skydive gear rental and the actual flight experience at one-tenth of the cost of a tandem jump but with much longer freefall time! iFLY Dubai is safe for kids, challenging for adults, exciting for teens and realistic for Skydivers. We guarantee that you'll be smiling from cheek to cheek after you experience the thrill of indoor bodyflight! Come fly with us today! Book Online for great savings at the iFly website!</p>\r\n', 100, '{\"price\":\"1000.00\",\"price_details\":\"equal\"}', 1, 0, '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `event_category`
--
CREATE TABLE `event_category` (
`cat_id` int(11) NOT NULL,
`category` varchar(250) DEFAULT NULL,
`category_description` longtext,
`category_image` varchar(250) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `event_category`
--
INSERT INTO `event_category` (`cat_id`, `category`, `category_description`, `category_image`, `status`) VALUES
(3, 'Fresh on Time Out', 'Test Description For Add Category Page.', 'assets/uploads/services/1553682089_1.jpg', 1),
(4, 'This Weekend ', 'Test Description For Add Category Page.', 'assets/uploads/services/1553682113_3.jpg', 1),
(5, 'Time Out Original ', 'Test Description For Add Category Page.', 'assets/uploads/services/1553682138_5.jpg', 1),
(6, 'Dining', 'Test Description For Add Category Page.', 'assets/uploads/services/1553682163_2.jpg', 1),
(7, 'Film Night ', 'Test Description For Add Category Page.', 'assets/uploads/services/1553682174_7.jpg', 1),
(8, 'Family First', 'Family First', 'assets/uploads/services/1552059743_Screenshot_2019-03-08_at_9.10.52_PM.png', 1),
(9, 'Games', 'Games', 'assets/uploads/services/1552059955_Screenshot_2019-03-08_at_9.15.37_PM.png', 1),
(10, 'Night Out', 'Night Out', 'assets/uploads/services/1552059785_Screenshot_2019-03-08_at_9.11.17_PM.png', 1),
(11, 'On a budget ', 'On a budget ', 'assets/uploads/services/1552059802_Screenshot_2019-03-08_at_9.10.41_PM.png', 1),
(12, 'Morning Bites ', 'Morning Bites ', 'assets/uploads/services/1552059924_Screenshot_2019-03-08_at_9.15.13_PM.png', 1),
(13, 'Sport and Wellness', 'Sport and Wellness', 'assets/uploads/services/1552059981_Screenshot_2019-03-08_at_9.11.05_PM.png', 1),
(14, 'Food Truck', 'Food Truck', 'assets/uploads/services/1552060061_Screenshot_2019-03-08_at_9.11.11_PM.png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `event_date_time`
--
CREATE TABLE `event_date_time` (
`id` int(11) NOT NULL,
`event_id` int(11) DEFAULT NULL,
`date` varchar(150) DEFAULT NULL,
`time` varchar(150) DEFAULT NULL,
`status` tinyint(3) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `event_date_time`
--
INSERT INTO `event_date_time` (`id`, `event_id`, `date`, `time`, `status`) VALUES
(709, 18, '2019-03-01', '13:00', 1),
(710, 18, '2019-03-01', '14:00', 1),
(711, 18, '2019-03-02', '13:00', 1),
(712, 18, '2019-03-02', '14:00', 1),
(713, 18, '2019-03-03', '13:00', 1),
(714, 18, '2019-03-03', '14:00', 1),
(715, 18, '2019-03-04', '13:00', 1),
(716, 18, '2019-03-04', '14:00', 1),
(717, 18, '2019-03-05', '13:00', 1),
(718, 18, '2019-03-05', '14:00', 1),
(719, 18, '2019-03-06', '13:00', 1),
(720, 18, '2019-03-06', '14:00', 1),
(721, 18, '2019-03-07', '13:00', 1),
(722, 18, '2019-03-07', '14:00', 1),
(723, 18, '2019-03-08', '13:00', 1),
(724, 18, '2019-03-08', '14:00', 1),
(725, 18, '2019-03-09', '13:00', 1),
(726, 18, '2019-03-09', '14:00', 1),
(727, 18, '2019-03-10', '13:00', 1),
(728, 18, '2019-03-10', '14:00', 1),
(729, 18, '2019-03-11', '13:00', 1),
(730, 18, '2019-03-11', '14:00', 1),
(731, 18, '2019-03-12', '13:00', 1),
(732, 18, '2019-03-12', '14:00', 1),
(733, 18, '2019-03-13', '13:00', 1),
(734, 18, '2019-03-13', '14:00', 1),
(735, 18, '2019-03-14', '13:00', 1),
(736, 18, '2019-03-14', '14:00', 1),
(737, 18, '2019-03-15', '13:00', 1),
(738, 18, '2019-03-15', '14:00', 1),
(739, 18, '2019-03-16', '13:00', 1),
(740, 18, '2019-03-16', '14:00', 1),
(741, 18, '2019-03-17', '13:00', 1),
(742, 18, '2019-03-17', '14:00', 1),
(743, 18, '2019-03-18', '13:00', 1),
(744, 18, '2019-03-18', '14:00', 1),
(745, 18, '2019-03-19', '13:00', 1),
(746, 18, '2019-03-19', '14:00', 1),
(747, 18, '2019-03-20', '13:00', 1),
(748, 18, '2019-03-20', '14:00', 1),
(749, 18, '2019-03-21', '13:00', 1),
(750, 18, '2019-03-21', '14:00', 1),
(751, 18, '2019-03-22', '13:00', 1),
(752, 18, '2019-03-22', '14:00', 1),
(753, 18, '2019-03-23', '13:00', 1),
(754, 18, '2019-03-23', '14:00', 1),
(755, 18, '2019-03-24', '13:00', 1),
(756, 18, '2019-03-24', '14:00', 1),
(757, 18, '2019-03-25', '13:00', 1),
(758, 18, '2019-03-25', '14:00', 1),
(759, 18, '2019-03-26', '13:00', 1),
(760, 18, '2019-03-26', '14:00', 1),
(761, 18, '2019-03-27', '13:00', 1),
(762, 18, '2019-03-27', '14:00', 1),
(763, 18, '2019-03-28', '13:00', 1),
(764, 18, '2019-03-28', '14:00', 1),
(765, 18, '2019-03-29', '13:00', 1),
(766, 18, '2019-03-29', '14:00', 1),
(767, 18, '2019-03-30', '13:00', 1),
(768, 18, '2019-03-30', '14:00', 1),
(769, 18, '2019-03-31', '13:00', 1),
(770, 18, '2019-03-31', '14:00', 1),
(771, 18, '2019-04-01', '13:00', 1),
(772, 18, '2019-04-01', '14:00', 1),
(773, 18, '2019-04-02', '13:00', 1),
(774, 18, '2019-04-02', '14:00', 1),
(775, 18, '2019-04-03', '13:00', 1),
(776, 18, '2019-04-03', '14:00', 1),
(777, 18, '2019-04-04', '13:00', 1),
(778, 18, '2019-04-04', '14:00', 1),
(779, 18, '2019-04-05', '13:00', 1),
(780, 18, '2019-04-05', '14:00', 1),
(781, 18, '2019-04-06', '13:00', 1),
(782, 18, '2019-04-06', '14:00', 1),
(783, 18, '2019-04-07', '13:00', 1),
(784, 18, '2019-04-07', '14:00', 1),
(785, 18, '2019-04-08', '13:00', 1),
(786, 18, '2019-04-08', '14:00', 1),
(787, 18, '2019-04-09', '13:00', 1),
(788, 18, '2019-04-09', '14:00', 1),
(789, 18, '2019-04-10', '13:00', 1),
(790, 18, '2019-04-10', '14:00', 1),
(791, 18, '2019-04-11', '13:00', 1),
(792, 18, '2019-04-11', '14:00', 1),
(793, 18, '2019-04-12', '13:00', 1),
(794, 18, '2019-04-12', '14:00', 1),
(795, 18, '2019-04-13', '13:00', 1),
(796, 18, '2019-04-13', '14:00', 1),
(797, 18, '2019-04-14', '13:00', 1),
(798, 18, '2019-04-14', '14:00', 1),
(799, 18, '2019-04-15', '13:00', 1),
(800, 18, '2019-04-15', '14:00', 1),
(801, 18, '2019-04-16', '13:00', 1),
(802, 18, '2019-04-16', '14:00', 1),
(803, 18, '2019-04-17', '13:00', 1),
(804, 18, '2019-04-17', '14:00', 1),
(805, 18, '2019-04-18', '13:00', 1),
(806, 18, '2019-04-18', '14:00', 1),
(807, 18, '2019-04-19', '13:00', 1),
(808, 18, '2019-04-19', '14:00', 1),
(809, 18, '2019-04-20', '13:00', 1),
(810, 18, '2019-04-20', '14:00', 1),
(811, 18, '2019-04-21', '13:00', 1),
(812, 18, '2019-04-21', '14:00', 1),
(813, 18, '2019-04-22', '13:00', 1),
(814, 18, '2019-04-22', '14:00', 1),
(815, 18, '2019-04-23', '13:00', 1),
(816, 18, '2019-04-23', '14:00', 1),
(817, 18, '2019-04-24', '13:00', 1),
(818, 18, '2019-04-24', '14:00', 1),
(819, 18, '2019-04-25', '13:00', 1),
(820, 18, '2019-04-25', '14:00', 1),
(821, 18, '2019-04-26', '13:00', 1),
(822, 18, '2019-04-26', '14:00', 1),
(823, 18, '2019-04-27', '13:00', 1),
(824, 18, '2019-04-27', '14:00', 1),
(825, 18, '2019-04-28', '13:00', 1),
(826, 18, '2019-04-28', '14:00', 1),
(827, 18, '2019-04-29', '13:00', 1),
(828, 18, '2019-04-29', '14:00', 1),
(829, 18, '2019-04-30', '13:00', 1),
(830, 18, '2019-04-30', '14:00', 1),
(831, 18, '2019-05-01', '13:00', 1),
(832, 18, '2019-05-01', '14:00', 1),
(833, 18, '2019-05-02', '13:00', 1),
(834, 18, '2019-05-02', '14:00', 1),
(835, 18, '2019-05-03', '13:00', 1),
(836, 18, '2019-05-03', '14:00', 1),
(837, 18, '2019-05-04', '13:00', 1),
(838, 18, '2019-05-04', '14:00', 1),
(839, 18, '2019-05-05', '13:00', 1),
(840, 18, '2019-05-05', '14:00', 1),
(841, 18, '2019-05-06', '13:00', 1),
(842, 18, '2019-05-06', '14:00', 1),
(843, 18, '2019-05-07', '13:00', 1),
(844, 18, '2019-05-07', '14:00', 1),
(845, 18, '2019-05-08', '13:00', 1),
(846, 18, '2019-05-08', '14:00', 1),
(847, 18, '2019-05-09', '13:00', 1),
(848, 18, '2019-05-09', '14:00', 1),
(849, 18, '2019-05-10', '13:00', 1),
(850, 18, '2019-05-10', '14:00', 1),
(2962, 22, '2019-03-01', '13:00', 1),
(2963, 22, '2019-03-01', '14:00', 1),
(2964, 22, '2019-03-01', '15:00', 1),
(2965, 22, '2019-03-02', '13:00', 1),
(2966, 22, '2019-03-02', '14:00', 1),
(2967, 22, '2019-03-02', '15:00', 1),
(2968, 22, '2019-03-03', '13:00', 1),
(2969, 22, '2019-03-03', '14:00', 1),
(2970, 22, '2019-03-03', '15:00', 1),
(2971, 22, '2019-03-04', '13:00', 1),
(2972, 22, '2019-03-04', '14:00', 1),
(2973, 22, '2019-03-04', '15:00', 1),
(2974, 22, '2019-03-05', '13:00', 1),
(2975, 22, '2019-03-05', '14:00', 1),
(2976, 22, '2019-03-05', '15:00', 1),
(2977, 22, '2019-03-06', '13:00', 1),
(2978, 22, '2019-03-06', '14:00', 1),
(2979, 22, '2019-03-06', '15:00', 1),
(2980, 22, '2019-03-07', '13:00', 1),
(2981, 22, '2019-03-07', '14:00', 1),
(2982, 22, '2019-03-07', '15:00', 1),
(2983, 22, '2019-03-08', '13:00', 1),
(2984, 22, '2019-03-08', '14:00', 1),
(2985, 22, '2019-03-08', '15:00', 1),
(2986, 22, '2019-03-09', '13:00', 1),
(2987, 22, '2019-03-09', '14:00', 1),
(2988, 22, '2019-03-09', '15:00', 1),
(2989, 22, '2019-03-10', '13:00', 1),
(2990, 22, '2019-03-10', '14:00', 1),
(2991, 22, '2019-03-10', '15:00', 1),
(2992, 22, '2019-03-11', '13:00', 1),
(2993, 22, '2019-03-11', '14:00', 1),
(2994, 22, '2019-03-11', '15:00', 1),
(2995, 22, '2019-03-12', '13:00', 1),
(2996, 22, '2019-03-12', '14:00', 1),
(2997, 22, '2019-03-12', '15:00', 1),
(2998, 22, '2019-03-13', '13:00', 1),
(2999, 22, '2019-03-13', '14:00', 1),
(3000, 22, '2019-03-13', '15:00', 1),
(3001, 22, '2019-03-14', '13:00', 1),
(3002, 22, '2019-03-14', '14:00', 1),
(3003, 22, '2019-03-14', '15:00', 1),
(3004, 22, '2019-03-15', '13:00', 1),
(3005, 22, '2019-03-15', '14:00', 1),
(3006, 22, '2019-03-15', '15:00', 1),
(3007, 22, '2019-03-16', '13:00', 1),
(3008, 22, '2019-03-16', '14:00', 1),
(3009, 22, '2019-03-16', '15:00', 1),
(3010, 22, '2019-03-17', '13:00', 1),
(3011, 22, '2019-03-17', '14:00', 1),
(3012, 22, '2019-03-17', '15:00', 1),
(3013, 22, '2019-03-18', '13:00', 1),
(3014, 22, '2019-03-18', '14:00', 1),
(3015, 22, '2019-03-18', '15:00', 1),
(3016, 22, '2019-03-19', '13:00', 1),
(3017, 22, '2019-03-19', '14:00', 1),
(3018, 22, '2019-03-19', '15:00', 1),
(3019, 22, '2019-03-20', '13:00', 1),
(3020, 22, '2019-03-20', '14:00', 1),
(3021, 22, '2019-03-20', '15:00', 1),
(3022, 22, '2019-03-21', '13:00', 1),
(3023, 22, '2019-03-21', '14:00', 1),
(3024, 22, '2019-03-21', '15:00', 1),
(3025, 22, '2019-03-22', '13:00', 1),
(3026, 22, '2019-03-22', '14:00', 1),
(3027, 22, '2019-03-22', '15:00', 1),
(3028, 22, '2019-03-23', '13:00', 1),
(3029, 22, '2019-03-23', '14:00', 1),
(3030, 22, '2019-03-23', '15:00', 1),
(3031, 22, '2019-03-24', '13:00', 1),
(3032, 22, '2019-03-24', '14:00', 1),
(3033, 22, '2019-03-24', '15:00', 1),
(3034, 22, '2019-03-25', '13:00', 1),
(3035, 22, '2019-03-25', '14:00', 1),
(3036, 22, '2019-03-25', '15:00', 1),
(3037, 22, '2019-03-26', '13:00', 1),
(3038, 22, '2019-03-26', '14:00', 1),
(3039, 22, '2019-03-26', '15:00', 1),
(3040, 22, '2019-03-27', '13:00', 1),
(3041, 22, '2019-03-27', '14:00', 1),
(3042, 22, '2019-03-27', '15:00', 1),
(3043, 22, '2019-03-28', '13:00', 1),
(3044, 22, '2019-03-28', '14:00', 1),
(3045, 22, '2019-03-28', '15:00', 1),
(3046, 22, '2019-03-29', '13:00', 1),
(3047, 22, '2019-03-29', '14:00', 1),
(3048, 22, '2019-03-29', '15:00', 1),
(3049, 22, '2019-03-30', '13:00', 1),
(3050, 22, '2019-03-30', '14:00', 1),
(3051, 22, '2019-03-30', '15:00', 1),
(3052, 22, '2019-03-31', '13:00', 1),
(3053, 22, '2019-03-31', '14:00', 1),
(3054, 22, '2019-03-31', '15:00', 1),
(3055, 22, '2019-04-01', '13:00', 1),
(3056, 22, '2019-04-01', '14:00', 1),
(3057, 22, '2019-04-01', '15:00', 1),
(3058, 22, '2019-04-02', '13:00', 1),
(3059, 22, '2019-04-02', '14:00', 1),
(3060, 22, '2019-04-02', '15:00', 1),
(3061, 22, '2019-04-03', '13:00', 1),
(3062, 22, '2019-04-03', '14:00', 1),
(3063, 22, '2019-04-03', '15:00', 1),
(3064, 22, '2019-04-04', '13:00', 1),
(3065, 22, '2019-04-04', '14:00', 1),
(3066, 22, '2019-04-04', '15:00', 1),
(3067, 22, '2019-04-05', '13:00', 1),
(3068, 22, '2019-04-05', '14:00', 1),
(3069, 22, '2019-04-05', '15:00', 1),
(3070, 22, '2019-04-06', '13:00', 1),
(3071, 22, '2019-04-06', '14:00', 1),
(3072, 22, '2019-04-06', '15:00', 1),
(3073, 22, '2019-04-07', '13:00', 1),
(3074, 22, '2019-04-07', '14:00', 1),
(3075, 22, '2019-04-07', '15:00', 1),
(3076, 22, '2019-04-08', '13:00', 1),
(3077, 22, '2019-04-08', '14:00', 1),
(3078, 22, '2019-04-08', '15:00', 1),
(3079, 22, '2019-04-09', '13:00', 1),
(3080, 22, '2019-04-09', '14:00', 1),
(3081, 22, '2019-04-09', '15:00', 1),
(3082, 22, '2019-04-10', '13:00', 1),
(3083, 22, '2019-04-10', '14:00', 1),
(3084, 22, '2019-04-10', '15:00', 1),
(3085, 22, '2019-04-11', '13:00', 1),
(3086, 22, '2019-04-11', '14:00', 1),
(3087, 22, '2019-04-11', '15:00', 1),
(3088, 22, '2019-04-12', '13:00', 1),
(3089, 22, '2019-04-12', '14:00', 1),
(3090, 22, '2019-04-12', '15:00', 1),
(3091, 22, '2019-04-13', '13:00', 1),
(3092, 22, '2019-04-13', '14:00', 1),
(3093, 22, '2019-04-13', '15:00', 1),
(3094, 22, '2019-04-14', '13:00', 1),
(3095, 22, '2019-04-14', '14:00', 1),
(3096, 22, '2019-04-14', '15:00', 1),
(3097, 22, '2019-04-15', '13:00', 1),
(3098, 22, '2019-04-15', '14:00', 1),
(3099, 22, '2019-04-15', '15:00', 1),
(3100, 22, '2019-04-16', '13:00', 1),
(3101, 22, '2019-04-16', '14:00', 1),
(3102, 22, '2019-04-16', '15:00', 1),
(3103, 22, '2019-04-17', '13:00', 1),
(3104, 22, '2019-04-17', '14:00', 1),
(3105, 22, '2019-04-17', '15:00', 1),
(3106, 22, '2019-04-18', '13:00', 1),
(3107, 22, '2019-04-18', '14:00', 1),
(3108, 22, '2019-04-18', '15:00', 1),
(3109, 22, '2019-04-19', '13:00', 1),
(3110, 22, '2019-04-19', '14:00', 1),
(3111, 22, '2019-04-19', '15:00', 1),
(3112, 22, '2019-04-20', '13:00', 1),
(3113, 22, '2019-04-20', '14:00', 1),
(3114, 22, '2019-04-20', '15:00', 1),
(3115, 22, '2019-04-21', '13:00', 1),
(3116, 22, '2019-04-21', '14:00', 1),
(3117, 22, '2019-04-21', '15:00', 1),
(3118, 22, '2019-04-22', '13:00', 1),
(3119, 22, '2019-04-22', '14:00', 1),
(3120, 22, '2019-04-22', '15:00', 1),
(3121, 22, '2019-04-23', '13:00', 1),
(3122, 22, '2019-04-23', '14:00', 1),
(3123, 22, '2019-04-23', '15:00', 1),
(3124, 22, '2019-04-24', '13:00', 1),
(3125, 22, '2019-04-24', '14:00', 1),
(3126, 22, '2019-04-24', '15:00', 1),
(3127, 22, '2019-04-25', '13:00', 1),
(3128, 22, '2019-04-25', '14:00', 1),
(3129, 22, '2019-04-25', '15:00', 1),
(3130, 22, '2019-04-26', '13:00', 1),
(3131, 22, '2019-04-26', '14:00', 1),
(3132, 22, '2019-04-26', '15:00', 1),
(3133, 22, '2019-04-27', '13:00', 1),
(3134, 22, '2019-04-27', '14:00', 1),
(3135, 22, '2019-04-27', '15:00', 1),
(3136, 22, '2019-04-28', '13:00', 1),
(3137, 22, '2019-04-28', '14:00', 1),
(3138, 22, '2019-04-28', '15:00', 1),
(3139, 22, '2019-04-29', '13:00', 1),
(3140, 22, '2019-04-29', '14:00', 1),
(3141, 22, '2019-04-29', '15:00', 1),
(3142, 22, '2019-04-30', '13:00', 1),
(3143, 22, '2019-04-30', '14:00', 1),
(3144, 22, '2019-04-30', '15:00', 1),
(3145, 22, '2019-05-01', '13:00', 1),
(3146, 22, '2019-05-01', '14:00', 1),
(3147, 22, '2019-05-01', '15:00', 1),
(3148, 22, '2019-05-02', '13:00', 1),
(3149, 22, '2019-05-02', '14:00', 1),
(3150, 22, '2019-05-02', '15:00', 1),
(3151, 22, '2019-05-03', '13:00', 1),
(3152, 22, '2019-05-03', '14:00', 1),
(3153, 22, '2019-05-03', '15:00', 1),
(3154, 22, '2019-05-04', '13:00', 1),
(3155, 22, '2019-05-04', '14:00', 1),
(3156, 22, '2019-05-04', '15:00', 1),
(3157, 22, '2019-05-05', '13:00', 1),
(3158, 22, '2019-05-05', '14:00', 1),
(3159, 22, '2019-05-05', '15:00', 1),
(3160, 22, '2019-05-06', '13:00', 1),
(3161, 22, '2019-05-06', '14:00', 1),
(3162, 22, '2019-05-06', '15:00', 1),
(3163, 22, '2019-05-07', '13:00', 1),
(3164, 22, '2019-05-07', '14:00', 1),
(3165, 22, '2019-05-07', '15:00', 1),
(3166, 22, '2019-05-08', '13:00', 1),
(3167, 22, '2019-05-08', '14:00', 1),
(3168, 22, '2019-05-08', '15:00', 1),
(3169, 22, '2019-05-09', '13:00', 1),
(3170, 22, '2019-05-09', '14:00', 1),
(3171, 22, '2019-05-09', '15:00', 1),
(3172, 22, '2019-05-10', '13:00', 1),
(3173, 22, '2019-05-10', '14:00', 1),
(3174, 22, '2019-05-10', '15:00', 1),
(3175, 22, '2019-05-11', '13:00', 1),
(3176, 22, '2019-05-11', '14:00', 1),
(3177, 22, '2019-05-11', '15:00', 1),
(3178, 22, '2019-05-12', '13:00', 1),
(3179, 22, '2019-05-12', '14:00', 1),
(3180, 22, '2019-05-12', '15:00', 1),
(3181, 22, '2019-05-13', '13:00', 1),
(3182, 22, '2019-05-13', '14:00', 1),
(3183, 22, '2019-05-13', '15:00', 1),
(3184, 22, '2019-05-14', '13:00', 1),
(3185, 22, '2019-05-14', '14:00', 1),
(3186, 22, '2019-05-14', '15:00', 1),
(3187, 22, '2019-05-15', '13:00', 1),
(3188, 22, '2019-05-15', '14:00', 1),
(3189, 22, '2019-05-15', '15:00', 1),
(3190, 22, '2019-05-16', '13:00', 1),
(3191, 22, '2019-05-16', '14:00', 1),
(3192, 22, '2019-05-16', '15:00', 1),
(3193, 22, '2019-05-17', '13:00', 1),
(3194, 22, '2019-05-17', '14:00', 1),
(3195, 22, '2019-05-17', '15:00', 1),
(3382, 19, '2019-03-01', '13:05', 1),
(3383, 19, '2019-03-01', '14:00', 1),
(3384, 19, '2019-03-02', '13:05', 1),
(3385, 19, '2019-03-02', '14:00', 1),
(3386, 19, '2019-03-03', '13:05', 1),
(3387, 19, '2019-03-03', '14:00', 1),
(3388, 19, '2019-03-04', '13:05', 1),
(3389, 19, '2019-03-04', '14:00', 1),
(3390, 19, '2019-03-05', '13:05', 1),
(3391, 19, '2019-03-05', '14:00', 1),
(3392, 19, '2019-03-06', '13:05', 1),
(3393, 19, '2019-03-06', '14:00', 1),
(3394, 19, '2019-03-07', '13:05', 1),
(3395, 19, '2019-03-07', '14:00', 1),
(3396, 19, '2019-03-08', '13:05', 1),
(3397, 19, '2019-03-08', '14:00', 1),
(3398, 19, '2019-03-09', '13:05', 1),
(3399, 19, '2019-03-09', '14:00', 1),
(3400, 19, '2019-03-10', '13:05', 1),
(3401, 19, '2019-03-10', '14:00', 1),
(3402, 19, '2019-03-11', '13:05', 1),
(3403, 19, '2019-03-11', '14:00', 1),
(3404, 19, '2019-03-12', '13:05', 1),
(3405, 19, '2019-03-12', '14:00', 1),
(3406, 19, '2019-03-13', '13:05', 1),
(3407, 19, '2019-03-13', '14:00', 1),
(3408, 19, '2019-03-14', '13:05', 1),
(3409, 19, '2019-03-14', '14:00', 1),
(3410, 19, '2019-03-15', '13:05', 1),
(3411, 19, '2019-03-15', '14:00', 1),
(3412, 19, '2019-03-16', '13:05', 1),
(3413, 19, '2019-03-16', '14:00', 1),
(3414, 19, '2019-03-17', '13:05', 1),
(3415, 19, '2019-03-17', '14:00', 1),
(3416, 19, '2019-03-18', '13:05', 1),
(3417, 19, '2019-03-18', '14:00', 1),
(3418, 19, '2019-03-19', '13:05', 1),
(3419, 19, '2019-03-19', '14:00', 1),
(3420, 19, '2019-03-20', '13:05', 1),
(3421, 19, '2019-03-20', '14:00', 1),
(3422, 19, '2019-03-21', '13:05', 1),
(3423, 19, '2019-03-21', '14:00', 1),
(3424, 19, '2019-03-22', '13:05', 1),
(3425, 19, '2019-03-22', '14:00', 1),
(3426, 19, '2019-03-23', '13:05', 1),
(3427, 19, '2019-03-23', '14:00', 1),
(3428, 19, '2019-03-24', '13:05', 1),
(3429, 19, '2019-03-24', '14:00', 1),
(3430, 19, '2019-03-25', '13:05', 1),
(3431, 19, '2019-03-25', '14:00', 1),
(3432, 19, '2019-03-26', '13:05', 1),
(3433, 19, '2019-03-26', '14:00', 1),
(3434, 19, '2019-03-27', '13:05', 1),
(3435, 19, '2019-03-27', '14:00', 1),
(3436, 19, '2019-03-28', '13:05', 1),
(3437, 19, '2019-03-28', '14:00', 1),
(3438, 19, '2019-03-29', '13:05', 1),
(3439, 19, '2019-03-29', '14:00', 1),
(3440, 19, '2019-03-30', '13:05', 1),
(3441, 19, '2019-03-30', '14:00', 1),
(3442, 19, '2019-03-31', '13:05', 1),
(3443, 19, '2019-03-31', '14:00', 1),
(3444, 19, '2019-04-01', '13:05', 1),
(3445, 19, '2019-04-01', '14:00', 1),
(3446, 19, '2019-04-02', '13:05', 1),
(3447, 19, '2019-04-02', '14:00', 1),
(3448, 19, '2019-04-03', '13:05', 1),
(3449, 19, '2019-04-03', '14:00', 1),
(3450, 19, '2019-04-04', '13:05', 1),
(3451, 19, '2019-04-04', '14:00', 1),
(3452, 19, '2019-04-05', '13:05', 1),
(3453, 19, '2019-04-05', '14:00', 1),
(3454, 19, '2019-04-06', '13:05', 1),
(3455, 19, '2019-04-06', '14:00', 1),
(3456, 19, '2019-04-07', '13:05', 1),
(3457, 19, '2019-04-07', '14:00', 1),
(3458, 19, '2019-04-08', '13:05', 1),
(3459, 19, '2019-04-08', '14:00', 1),
(3460, 19, '2019-04-09', '13:05', 1),
(3461, 19, '2019-04-09', '14:00', 1),
(3462, 19, '2019-04-10', '13:05', 1),
(3463, 19, '2019-04-10', '14:00', 1),
(3464, 19, '2019-04-11', '13:05', 1),
(3465, 19, '2019-04-11', '14:00', 1),
(3466, 19, '2019-04-12', '13:05', 1),
(3467, 19, '2019-04-12', '14:00', 1),
(3468, 19, '2019-04-13', '13:05', 1),
(3469, 19, '2019-04-13', '14:00', 1),
(3470, 19, '2019-04-14', '13:05', 1),
(3471, 19, '2019-04-14', '14:00', 1),
(3472, 19, '2019-04-15', '13:05', 1),
(3473, 19, '2019-04-15', '14:00', 1),
(3474, 19, '2019-04-16', '13:05', 1),
(3475, 19, '2019-04-16', '14:00', 1),
(3476, 19, '2019-04-17', '13:05', 1),
(3477, 19, '2019-04-17', '14:00', 1),
(3478, 19, '2019-04-18', '13:05', 1),
(3479, 19, '2019-04-18', '14:00', 1),
(3480, 19, '2019-04-19', '13:05', 1),
(3481, 19, '2019-04-19', '14:00', 1),
(3482, 20, '2019-03-01', '14:09', 1),
(3483, 20, '2019-03-01', '16:20', 1),
(3484, 20, '2019-03-01', '15:00', 1),
(3485, 20, '2019-03-02', '14:09', 1),
(3486, 20, '2019-03-02', '16:20', 1),
(3487, 20, '2019-03-02', '15:00', 1),
(3488, 20, '2019-03-03', '14:09', 1),
(3489, 20, '2019-03-03', '16:20', 1),
(3490, 20, '2019-03-03', '15:00', 1),
(3491, 20, '2019-03-04', '14:09', 1),
(3492, 20, '2019-03-04', '16:20', 1),
(3493, 20, '2019-03-04', '15:00', 1),
(3494, 20, '2019-03-05', '14:09', 1),
(3495, 20, '2019-03-05', '16:20', 1),
(3496, 20, '2019-03-05', '15:00', 1),
(3497, 20, '2019-03-06', '14:09', 1),
(3498, 20, '2019-03-06', '16:20', 1),
(3499, 20, '2019-03-06', '15:00', 1),
(3500, 20, '2019-03-07', '14:09', 1),
(3501, 20, '2019-03-07', '16:20', 1),
(3502, 20, '2019-03-07', '15:00', 1),
(3503, 20, '2019-03-08', '14:09', 1),
(3504, 20, '2019-03-08', '16:20', 1),
(3505, 20, '2019-03-08', '15:00', 1),
(3506, 20, '2019-03-09', '14:09', 1),
(3507, 20, '2019-03-09', '16:20', 1),
(3508, 20, '2019-03-09', '15:00', 1),
(3509, 20, '2019-03-10', '14:09', 1),
(3510, 20, '2019-03-10', '16:20', 1),
(3511, 20, '2019-03-10', '15:00', 1),
(3512, 20, '2019-03-11', '14:09', 1),
(3513, 20, '2019-03-11', '16:20', 1),
(3514, 20, '2019-03-11', '15:00', 1),
(3515, 20, '2019-03-12', '14:09', 1),
(3516, 20, '2019-03-12', '16:20', 1),
(3517, 20, '2019-03-12', '15:00', 1),
(3518, 20, '2019-03-13', '14:09', 1),
(3519, 20, '2019-03-13', '16:20', 1),
(3520, 20, '2019-03-13', '15:00', 1),
(3521, 20, '2019-03-14', '14:09', 1),
(3522, 20, '2019-03-14', '16:20', 1),
(3523, 20, '2019-03-14', '15:00', 1),
(3524, 20, '2019-03-15', '14:09', 1),
(3525, 20, '2019-03-15', '16:20', 1),
(3526, 20, '2019-03-15', '15:00', 1),
(3527, 20, '2019-03-16', '14:09', 1),
(3528, 20, '2019-03-16', '16:20', 1),
(3529, 20, '2019-03-16', '15:00', 1),
(3530, 20, '2019-03-17', '14:09', 1),
(3531, 20, '2019-03-17', '16:20', 1),
(3532, 20, '2019-03-17', '15:00', 1),
(3533, 20, '2019-03-18', '14:09', 1),
(3534, 20, '2019-03-18', '16:20', 1),
(3535, 20, '2019-03-18', '15:00', 1),
(3536, 20, '2019-03-19', '14:09', 1),
(3537, 20, '2019-03-19', '16:20', 1),
(3538, 20, '2019-03-19', '15:00', 1),
(3539, 20, '2019-03-20', '14:09', 1),
(3540, 20, '2019-03-20', '16:20', 1),
(3541, 20, '2019-03-20', '15:00', 1),
(3542, 20, '2019-03-21', '14:09', 1),
(3543, 20, '2019-03-21', '16:20', 1),
(3544, 20, '2019-03-21', '15:00', 1),
(3545, 20, '2019-03-22', '14:09', 1),
(3546, 20, '2019-03-22', '16:20', 1),
(3547, 20, '2019-03-22', '15:00', 1),
(3548, 20, '2019-03-23', '14:09', 1),
(3549, 20, '2019-03-23', '16:20', 1),
(3550, 20, '2019-03-23', '15:00', 1),
(3551, 20, '2019-03-24', '14:09', 1),
(3552, 20, '2019-03-24', '16:20', 1),
(3553, 20, '2019-03-24', '15:00', 1),
(3554, 20, '2019-03-25', '14:09', 1),
(3555, 20, '2019-03-25', '16:20', 1),
(3556, 20, '2019-03-25', '15:00', 1),
(3557, 20, '2019-03-26', '14:09', 1),
(3558, 20, '2019-03-26', '16:20', 1),
(3559, 20, '2019-03-26', '15:00', 1),
(3560, 20, '2019-03-27', '14:09', 1),
(3561, 20, '2019-03-27', '16:20', 1),
(3562, 20, '2019-03-27', '15:00', 1),
(3563, 20, '2019-03-28', '14:09', 1),
(3564, 20, '2019-03-28', '16:20', 1),
(3565, 20, '2019-03-28', '15:00', 1),
(3566, 20, '2019-03-29', '14:09', 1),
(3567, 20, '2019-03-29', '16:20', 1),
(3568, 20, '2019-03-29', '15:00', 1),
(3569, 20, '2019-03-30', '14:09', 1),
(3570, 20, '2019-03-30', '16:20', 1),
(3571, 20, '2019-03-30', '15:00', 1),
(3572, 20, '2019-03-31', '14:09', 1),
(3573, 20, '2019-03-31', '16:20', 1),
(3574, 20, '2019-03-31', '15:00', 1),
(3575, 20, '2019-04-01', '14:09', 1),
(3576, 20, '2019-04-01', '16:20', 1),
(3577, 20, '2019-04-01', '15:00', 1),
(3578, 20, '2019-04-02', '14:09', 1),
(3579, 20, '2019-04-02', '16:20', 1),
(3580, 20, '2019-04-02', '15:00', 1),
(3581, 20, '2019-04-03', '14:09', 1),
(3582, 20, '2019-04-03', '16:20', 1),
(3583, 20, '2019-04-03', '15:00', 1),
(3584, 20, '2019-04-04', '14:09', 1),
(3585, 20, '2019-04-04', '16:20', 1),
(3586, 20, '2019-04-04', '15:00', 1),
(3587, 20, '2019-04-05', '14:09', 1),
(3588, 20, '2019-04-05', '16:20', 1),
(3589, 20, '2019-04-05', '15:00', 1),
(3590, 20, '2019-04-06', '14:09', 1),
(3591, 20, '2019-04-06', '16:20', 1),
(3592, 20, '2019-04-06', '15:00', 1),
(3593, 20, '2019-04-07', '14:09', 1),
(3594, 20, '2019-04-07', '16:20', 1),
(3595, 20, '2019-04-07', '15:00', 1),
(3596, 20, '2019-04-08', '14:09', 1),
(3597, 20, '2019-04-08', '16:20', 1),
(3598, 20, '2019-04-08', '15:00', 1),
(3599, 20, '2019-04-09', '14:09', 1),
(3600, 20, '2019-04-09', '16:20', 1),
(3601, 20, '2019-04-09', '15:00', 1),
(3602, 20, '2019-04-10', '14:09', 1),
(3603, 20, '2019-04-10', '16:20', 1),
(3604, 20, '2019-04-10', '15:00', 1),
(3605, 20, '2019-04-11', '14:09', 1),
(3606, 20, '2019-04-11', '16:20', 1),
(3607, 20, '2019-04-11', '15:00', 1),
(3608, 20, '2019-04-12', '14:09', 1),
(3609, 20, '2019-04-12', '16:20', 1),
(3610, 20, '2019-04-12', '15:00', 1),
(3611, 20, '2019-04-13', '14:09', 1),
(3612, 20, '2019-04-13', '16:20', 1),
(3613, 20, '2019-04-13', '15:00', 1),
(3614, 20, '2019-04-14', '14:09', 1),
(3615, 20, '2019-04-14', '16:20', 1),
(3616, 20, '2019-04-14', '15:00', 1),
(3617, 20, '2019-04-15', '14:09', 1),
(3618, 20, '2019-04-15', '16:20', 1),
(3619, 20, '2019-04-15', '15:00', 1),
(3620, 20, '2019-04-16', '14:09', 1),
(3621, 20, '2019-04-16', '16:20', 1),
(3622, 20, '2019-04-16', '15:00', 1),
(3623, 20, '2019-04-17', '14:09', 1),
(3624, 20, '2019-04-17', '16:20', 1),
(3625, 20, '2019-04-17', '15:00', 1),
(3626, 20, '2019-04-18', '14:09', 1),
(3627, 20, '2019-04-18', '16:20', 1),
(3628, 20, '2019-04-18', '15:00', 1),
(3629, 20, '2019-04-19', '14:09', 1),
(3630, 20, '2019-04-19', '16:20', 1),
(3631, 20, '2019-04-19', '15:00', 1),
(3632, 20, '2019-04-20', '14:09', 1),
(3633, 20, '2019-04-20', '16:20', 1),
(3634, 20, '2019-04-20', '15:00', 1),
(3635, 20, '2019-04-21', '14:09', 1),
(3636, 20, '2019-04-21', '16:20', 1),
(3637, 20, '2019-04-21', '15:00', 1),
(3638, 20, '2019-04-22', '14:09', 1),
(3639, 20, '2019-04-22', '16:20', 1),
(3640, 20, '2019-04-22', '15:00', 1),
(3641, 20, '2019-04-23', '14:09', 1),
(3642, 20, '2019-04-23', '16:20', 1),
(3643, 20, '2019-04-23', '15:00', 1),
(3644, 20, '2019-04-24', '14:09', 1),
(3645, 20, '2019-04-24', '16:20', 1),
(3646, 20, '2019-04-24', '15:00', 1),
(3647, 20, '2019-04-25', '14:09', 1),
(3648, 20, '2019-04-25', '16:20', 1),
(3649, 20, '2019-04-25', '15:00', 1),
(3650, 20, '2019-04-26', '14:09', 1),
(3651, 20, '2019-04-26', '16:20', 1),
(3652, 20, '2019-04-26', '15:00', 1),
(3653, 20, '2019-04-27', '14:09', 1),
(3654, 20, '2019-04-27', '16:20', 1),
(3655, 20, '2019-04-27', '15:00', 1),
(4214, 23, '2019-03-27', '01:15', 1),
(4277, 17, '2019-03-01', '13:05', 1),
(4278, 17, '2019-03-01', '14:05', 1),
(4279, 17, '2019-03-01', '14:10', 1),
(4280, 17, '2019-03-02', '13:05', 1),
(4281, 17, '2019-03-02', '14:05', 1),
(4282, 17, '2019-03-02', '14:10', 1),
(4283, 17, '2019-03-03', '13:05', 1),
(4284, 17, '2019-03-03', '14:05', 1),
(4285, 17, '2019-03-03', '14:10', 1),
(4286, 17, '2019-03-04', '13:05', 1),
(4287, 17, '2019-03-04', '14:05', 1),
(4288, 17, '2019-03-04', '14:10', 1),
(4289, 17, '2019-03-05', '13:05', 1),
(4290, 17, '2019-03-05', '14:05', 1),
(4291, 17, '2019-03-05', '14:10', 1),
(4292, 17, '2019-03-06', '13:05', 1),
(4293, 17, '2019-03-06', '14:05', 1),
(4294, 17, '2019-03-06', '14:10', 1),
(4295, 17, '2019-03-07', '13:05', 1),
(4296, 17, '2019-03-07', '14:05', 1),
(4297, 17, '2019-03-07', '14:10', 1),
(4298, 17, '2019-03-08', '13:05', 1),
(4299, 17, '2019-03-08', '14:05', 1),
(4300, 17, '2019-03-08', '14:10', 1),
(4301, 17, '2019-03-09', '13:05', 1),
(4302, 17, '2019-03-09', '14:05', 1),
(4303, 17, '2019-03-09', '14:10', 1),
(4304, 17, '2019-03-10', '13:05', 1),
(4305, 17, '2019-03-10', '14:05', 1),
(4306, 17, '2019-03-10', '14:10', 1),
(4307, 17, '2019-03-11', '13:05', 1),
(4308, 17, '2019-03-11', '14:05', 1),
(4309, 17, '2019-03-11', '14:10', 1),
(4310, 17, '2019-03-12', '13:05', 1),
(4311, 17, '2019-03-12', '14:05', 1),
(4312, 17, '2019-03-12', '14:10', 1),
(4313, 17, '2019-03-13', '13:05', 1),
(4314, 17, '2019-03-13', '14:05', 1),
(4315, 17, '2019-03-13', '14:10', 1),
(4316, 17, '2019-03-14', '13:05', 1),
(4317, 17, '2019-03-14', '14:05', 1),
(4318, 17, '2019-03-14', '14:10', 1),
(4319, 17, '2019-03-15', '13:05', 1),
(4320, 17, '2019-03-15', '14:05', 1),
(4321, 17, '2019-03-15', '14:10', 1),
(4322, 17, '2019-03-16', '13:05', 1),
(4323, 17, '2019-03-16', '14:05', 1),
(4324, 17, '2019-03-16', '14:10', 1),
(4325, 17, '2019-03-17', '13:05', 1),
(4326, 17, '2019-03-17', '14:05', 1),
(4327, 17, '2019-03-17', '14:10', 1),
(4328, 17, '2019-03-18', '13:05', 1),
(4329, 17, '2019-03-18', '14:05', 1),
(4330, 17, '2019-03-18', '14:10', 1),
(4331, 17, '2019-03-19', '13:05', 1),
(4332, 17, '2019-03-19', '14:05', 1),
(4333, 17, '2019-03-19', '14:10', 1),
(4334, 17, '2019-03-20', '13:05', 1),
(4335, 17, '2019-03-20', '14:05', 1),
(4336, 17, '2019-03-20', '14:10', 1),
(4337, 17, '2019-03-21', '13:05', 1),
(4338, 17, '2019-03-21', '14:05', 1),
(4339, 17, '2019-03-21', '14:10', 1),
(4340, 17, '2019-03-22', '13:05', 1),
(4341, 17, '2019-03-22', '14:05', 1),
(4342, 17, '2019-03-22', '14:10', 1),
(4343, 17, '2019-03-23', '13:05', 1),
(4344, 17, '2019-03-23', '14:05', 1),
(4345, 17, '2019-03-23', '14:10', 1),
(4346, 17, '2019-03-24', '13:05', 1),
(4347, 17, '2019-03-24', '14:05', 1),
(4348, 17, '2019-03-24', '14:10', 1),
(4349, 17, '2019-03-25', '13:05', 1),
(4350, 17, '2019-03-25', '14:05', 1),
(4351, 17, '2019-03-25', '14:10', 1),
(4352, 17, '2019-03-26', '13:05', 1),
(4353, 17, '2019-03-26', '14:05', 1),
(4354, 17, '2019-03-26', '14:10', 1),
(4355, 17, '2019-03-27', '13:05', 1),
(4356, 17, '2019-03-27', '14:05', 1),
(4357, 17, '2019-03-27', '14:10', 1),
(4358, 17, '2019-03-28', '13:05', 1),
(4359, 17, '2019-03-28', '14:05', 1),
(4360, 17, '2019-03-28', '14:10', 1),
(4361, 17, '2019-03-29', '13:05', 1),
(4362, 17, '2019-03-29', '14:05', 1),
(4363, 17, '2019-03-29', '14:10', 1),
(4364, 17, '2019-03-30', '13:05', 1),
(4365, 17, '2019-03-30', '14:05', 1),
(4366, 17, '2019-03-30', '14:10', 1),
(4367, 17, '2019-03-31', '13:05', 1),
(4368, 17, '2019-03-31', '14:05', 1),
(4369, 17, '2019-03-31', '14:10', 1),
(4370, 17, '2019-04-01', '13:05', 1),
(4371, 17, '2019-04-01', '14:05', 1),
(4372, 17, '2019-04-01', '14:10', 1),
(4373, 17, '2019-04-02', '13:05', 1),
(4374, 17, '2019-04-02', '14:05', 1),
(4375, 17, '2019-04-02', '14:10', 1),
(4376, 17, '2019-04-03', '13:05', 1),
(4377, 17, '2019-04-03', '14:05', 1),
(4378, 17, '2019-04-03', '14:10', 1),
(4379, 17, '2019-04-04', '13:05', 1),
(4380, 17, '2019-04-04', '14:05', 1),
(4381, 17, '2019-04-04', '14:10', 1),
(4382, 17, '2019-04-05', '13:05', 1),
(4383, 17, '2019-04-05', '14:05', 1),
(4384, 17, '2019-04-05', '14:10', 1),
(4385, 17, '2019-04-06', '13:05', 1),
(4386, 17, '2019-04-06', '14:05', 1),
(4387, 17, '2019-04-06', '14:10', 1),
(4388, 17, '2019-04-07', '13:05', 1),
(4389, 17, '2019-04-07', '14:05', 1),
(4390, 17, '2019-04-07', '14:10', 1),
(4391, 17, '2019-04-08', '13:05', 1),
(4392, 17, '2019-04-08', '14:05', 1),
(4393, 17, '2019-04-08', '14:10', 1),
(4394, 17, '2019-04-09', '13:05', 1),
(4395, 17, '2019-04-09', '14:05', 1),
(4396, 17, '2019-04-09', '14:10', 1),
(4397, 17, '2019-04-10', '13:05', 1),
(4398, 17, '2019-04-10', '14:05', 1),
(4399, 17, '2019-04-10', '14:10', 1),
(4400, 17, '2019-04-11', '13:05', 1),
(4401, 17, '2019-04-11', '14:05', 1),
(4402, 17, '2019-04-11', '14:10', 1),
(4403, 17, '2019-04-12', '13:05', 1),
(4404, 17, '2019-04-12', '14:05', 1),
(4405, 17, '2019-04-12', '14:10', 1),
(4406, 17, '2019-04-13', '13:05', 1),
(4407, 17, '2019-04-13', '14:05', 1),
(4408, 17, '2019-04-13', '14:10', 1),
(4409, 17, '2019-04-14', '13:05', 1),
(4410, 17, '2019-04-14', '14:05', 1),
(4411, 17, '2019-04-14', '14:10', 1),
(4412, 17, '2019-04-15', '13:05', 1),
(4413, 17, '2019-04-15', '14:05', 1),
(4414, 17, '2019-04-15', '14:10', 1),
(4415, 17, '2019-04-16', '13:05', 1),
(4416, 17, '2019-04-16', '14:05', 1),
(4417, 17, '2019-04-16', '14:10', 1),
(4418, 17, '2019-04-17', '13:05', 1),
(4419, 17, '2019-04-17', '14:05', 1),
(4420, 17, '2019-04-17', '14:10', 1),
(4421, 17, '2019-04-18', '13:05', 1),
(4422, 17, '2019-04-18', '14:05', 1),
(4423, 17, '2019-04-18', '14:10', 1),
(4424, 17, '2019-04-19', '13:05', 1),
(4425, 17, '2019-04-19', '14:05', 1),
(4426, 17, '2019-04-19', '14:10', 1),
(4427, 17, '2019-04-20', '13:05', 1),
(4428, 17, '2019-04-20', '14:05', 1),
(4429, 17, '2019-04-20', '14:10', 1),
(4430, 17, '2019-04-21', '13:05', 1),
(4431, 17, '2019-04-21', '14:05', 1),
(4432, 17, '2019-04-21', '14:10', 1),
(4433, 17, '2019-04-22', '13:05', 1),
(4434, 17, '2019-04-22', '14:05', 1),
(4435, 17, '2019-04-22', '14:10', 1),
(4436, 17, '2019-04-23', '13:05', 1),
(4437, 17, '2019-04-23', '14:05', 1),
(4438, 17, '2019-04-23', '14:10', 1),
(4439, 17, '2019-04-24', '13:05', 1),
(4440, 17, '2019-04-24', '14:05', 1),
(4441, 17, '2019-04-24', '14:10', 1),
(4442, 17, '2019-04-25', '13:05', 1),
(4443, 17, '2019-04-25', '14:05', 1),
(4444, 17, '2019-04-25', '14:10', 1),
(4445, 17, '2019-04-26', '13:05', 1),
(4446, 17, '2019-04-26', '14:05', 1),
(4447, 17, '2019-04-26', '14:10', 1),
(4448, 17, '2019-04-27', '13:05', 1),
(4449, 17, '2019-04-27', '14:05', 1),
(4450, 17, '2019-04-27', '14:10', 1),
(4451, 17, '2019-04-28', '13:05', 1),
(4452, 17, '2019-04-28', '14:05', 1),
(4453, 17, '2019-04-28', '14:10', 1),
(4454, 17, '2019-04-29', '13:05', 1),
(4455, 17, '2019-04-29', '14:05', 1),
(4456, 17, '2019-04-29', '14:10', 1),
(4457, 17, '2019-04-30', '13:05', 1),
(4458, 17, '2019-04-30', '14:05', 1),
(4459, 17, '2019-04-30', '14:10', 1),
(4460, 17, '2019-05-01', '13:05', 1),
(4461, 17, '2019-05-01', '14:05', 1),
(4462, 17, '2019-05-01', '14:10', 1),
(4532, 24, '2019-03-01', '01:05', 1),
(4533, 24, '2019-03-01', '09:15', 1),
(4534, 24, '2019-03-02', '01:05', 1),
(4535, 24, '2019-03-02', '09:15', 1),
(4536, 24, '2019-03-03', '01:05', 1),
(4537, 24, '2019-03-03', '09:15', 1),
(4538, 24, '2019-03-04', '01:05', 1),
(4539, 24, '2019-03-04', '09:15', 1),
(4540, 24, '2019-03-05', '01:05', 1),
(4541, 24, '2019-03-05', '09:15', 1),
(4542, 24, '2019-03-06', '01:05', 1),
(4543, 24, '2019-03-06', '09:15', 1),
(4544, 24, '2019-03-07', '01:05', 1),
(4545, 24, '2019-03-07', '09:15', 1),
(4546, 24, '2019-03-08', '01:05', 1),
(4547, 24, '2019-03-08', '09:15', 1),
(4548, 24, '2019-03-09', '01:05', 1),
(4549, 24, '2019-03-09', '09:15', 1),
(4550, 24, '2019-03-10', '01:05', 1),
(4551, 24, '2019-03-10', '09:15', 1),
(4552, 24, '2019-03-11', '01:05', 1),
(4553, 24, '2019-03-11', '09:15', 1),
(4554, 24, '2019-03-12', '01:05', 1),
(4555, 24, '2019-03-12', '09:15', 1),
(4556, 24, '2019-03-13', '01:05', 1),
(4557, 24, '2019-03-13', '09:15', 1),
(4558, 24, '2019-03-14', '01:05', 1),
(4559, 24, '2019-03-14', '09:15', 1),
(4560, 24, '2019-03-15', '01:05', 1),
(4561, 24, '2019-03-15', '09:15', 1),
(4562, 24, '2019-03-16', '01:05', 1),
(4563, 24, '2019-03-16', '09:15', 1),
(4564, 24, '2019-03-17', '01:05', 1),
(4565, 24, '2019-03-17', '09:15', 1),
(4566, 24, '2019-03-18', '01:05', 1),
(4567, 24, '2019-03-18', '09:15', 1),
(4568, 24, '2019-03-19', '01:05', 1),
(4569, 24, '2019-03-19', '09:15', 1),
(4570, 24, '2019-03-20', '01:05', 1),
(4571, 24, '2019-03-20', '09:15', 1),
(4572, 24, '2019-03-21', '01:05', 1),
(4573, 24, '2019-03-21', '09:15', 1),
(4574, 24, '2019-03-22', '01:05', 1),
(4575, 24, '2019-03-22', '09:15', 1),
(4576, 24, '2019-03-23', '01:05', 1),
(4577, 24, '2019-03-23', '09:15', 1),
(4578, 24, '2019-03-24', '01:05', 1),
(4579, 24, '2019-03-24', '09:15', 1),
(4580, 24, '2019-03-25', '01:05', 1),
(4581, 24, '2019-03-25', '09:15', 1),
(4582, 24, '2019-03-26', '01:05', 1),
(4583, 24, '2019-03-26', '09:15', 1),
(4584, 24, '2019-03-27', '01:05', 1),
(4585, 24, '2019-03-27', '09:15', 1),
(4586, 24, '2019-03-28', '01:05', 1),
(4587, 24, '2019-03-28', '09:15', 1),
(4588, 24, '2019-03-29', '01:05', 1),
(4589, 24, '2019-03-29', '09:15', 1),
(4590, 24, '2019-03-30', '01:05', 1),
(4591, 24, '2019-03-30', '09:15', 1),
(4592, 24, '2019-03-31', '01:05', 1),
(4593, 24, '2019-03-31', '09:15', 1),
(4651, 27, '2019-05-24', '14:00', 1),
(4655, 26, '2019-03-26', '12:00', 1),
(4656, 28, '2019-03-19', '14:00', 1),
(4657, 29, '2019-05-29', '14:00', 1),
(4658, 30, '2019-03-09', '13:00', 1),
(4659, 31, '2019-03-18', '14:00', 1),
(4660, 32, '2019-03-14', '13:00', 1),
(4661, 33, '2019-03-20', '14:00', 1),
(4679, 21, '2019-03-08', '14:00', 1),
(4680, 21, '2019-03-09', '14:00', 1),
(4681, 21, '2019-03-10', '14:00', 1),
(4682, 21, '2019-03-11', '14:00', 1),
(4683, 21, '2019-03-12', '14:00', 1),
(4684, 21, '2019-03-13', '14:00', 1),
(4685, 21, '2019-03-14', '14:00', 1),
(4686, 21, '2019-03-15', '14:00', 1),
(4687, 21, '2019-03-16', '14:00', 1),
(4688, 21, '2019-03-17', '14:00', 1),
(4689, 21, '2019-03-18', '14:00', 1),
(4690, 21, '2019-03-19', '14:00', 1),
(4691, 21, '2019-03-20', '14:00', 1),
(4692, 21, '2019-03-21', '14:00', 1),
(4693, 21, '2019-03-22', '14:00', 1),
(4694, 21, '2019-03-23', '14:00', 1),
(4695, 21, '2019-03-24', '14:00', 1),
(4696, 21, '2019-03-25', '14:00', 1),
(4697, 21, '2019-03-26', '14:00', 1),
(4698, 21, '2019-03-27', '14:00', 1),
(4699, 21, '2019-03-28', '14:00', 1),
(4700, 21, '2019-03-29', '14:00', 1),
(4701, 21, '2019-03-30', '14:00', 1),
(4702, 21, '2019-03-31', '14:00', 1),
(4703, 21, '2019-04-01', '14:00', 1),
(4704, 21, '2019-04-02', '14:00', 1),
(4705, 21, '2019-04-03', '14:00', 1),
(4706, 21, '2019-04-04', '14:00', 1),
(4707, 21, '2019-04-05', '14:00', 1),
(4708, 21, '2019-04-06', '14:00', 1),
(4709, 21, '2019-04-07', '14:00', 1),
(4710, 21, '2019-04-08', '14:00', 1),
(4711, 21, '2019-04-09', '14:00', 1),
(4712, 21, '2019-04-10', '14:00', 1),
(4713, 25, '2019-09-04', '01:15', 1),
(4714, 25, '2019-09-04', '03:15', 1),
(4715, 25, '2019-09-04', '02:15', 1),
(4724, 34, '2019-03-29', '09:45', 1),
(4725, 34, '2019-03-30', '09:45', 1),
(4726, 34, '2019-03-31', '09:45', 1),
(4727, 34, '2019-04-01', '09:45', 1),
(4728, 34, '2019-04-02', '09:45', 1),
(4729, 34, '2019-04-03', '09:45', 1),
(4730, 34, '2019-04-04', '09:45', 1),
(4731, 34, '2019-04-05', '09:45', 1),
(4733, 35, '2019-07-19', '14:10', 1),
(4734, 36, '2019-03-28', '01:10', 1),
(4735, 36, '2019-03-28', '02:15', 1),
(4736, 37, '2019-04-05', '01:30', 1),
(4737, 37, '2019-04-06', '01:30', 1),
(4738, 39, '2019-03-28', '09:30', 1),
(4739, 39, '2019-03-28', '13:30', 1),
(4740, 39, '2019-03-28', '16:15', 1),
(4741, 39, '2019-03-28', '20:00', 1),
(4742, 39, '2019-03-29', '09:30', 1),
(4743, 39, '2019-03-29', '13:30', 1),
(4744, 39, '2019-03-29', '16:15', 1),
(4745, 39, '2019-03-29', '20:00', 1),
(4746, 39, '2019-03-30', '09:30', 1),
(4747, 39, '2019-03-30', '13:30', 1),
(4748, 39, '2019-03-30', '16:15', 1),
(4749, 39, '2019-03-30', '20:00', 1),
(4750, 39, '2019-03-31', '09:30', 1),
(4751, 39, '2019-03-31', '13:30', 1),
(4752, 39, '2019-03-31', '16:15', 1),
(4753, 39, '2019-03-31', '20:00', 1),
(4754, 39, '2019-04-01', '09:30', 1),
(4755, 39, '2019-04-01', '13:30', 1),
(4756, 39, '2019-04-01', '16:15', 1),
(4757, 39, '2019-04-01', '20:00', 1),
(4758, 39, '2019-04-02', '09:30', 1),
(4759, 39, '2019-04-02', '13:30', 1),
(4760, 39, '2019-04-02', '16:15', 1),
(4761, 39, '2019-04-02', '20:00', 1),
(4762, 39, '2019-04-03', '09:30', 1),
(4763, 39, '2019-04-03', '13:30', 1),
(4764, 39, '2019-04-03', '16:15', 1),
(4765, 39, '2019-04-03', '20:00', 1),
(4766, 39, '2019-04-04', '09:30', 1),
(4767, 39, '2019-04-04', '13:30', 1),
(4768, 39, '2019-04-04', '16:15', 1),
(4769, 39, '2019-04-04', '20:00', 1),
(4770, 39, '2019-04-05', '09:30', 1),
(4771, 39, '2019-04-05', '13:30', 1),
(4772, 39, '2019-04-05', '16:15', 1),
(4773, 39, '2019-04-05', '20:00', 1),
(4774, 39, '2019-04-06', '09:30', 1),
(4775, 39, '2019-04-06', '13:30', 1),
(4776, 39, '2019-04-06', '16:15', 1),
(4777, 39, '2019-04-06', '20:00', 1),
(4778, 39, '2019-04-07', '09:30', 1),
(4779, 39, '2019-04-07', '13:30', 1),
(4780, 39, '2019-04-07', '16:15', 1),
(4781, 39, '2019-04-07', '20:00', 1),
(4782, 39, '2019-04-08', '09:30', 1),
(4783, 39, '2019-04-08', '13:30', 1),
(4784, 39, '2019-04-08', '16:15', 1),
(4785, 39, '2019-04-08', '20:00', 1),
(4786, 39, '2019-04-09', '09:30', 1),
(4787, 39, '2019-04-09', '13:30', 1),
(4788, 39, '2019-04-09', '16:15', 1),
(4789, 39, '2019-04-09', '20:00', 1),
(4790, 39, '2019-04-10', '09:30', 1),
(4791, 39, '2019-04-10', '13:30', 1),
(4792, 39, '2019-04-10', '16:15', 1),
(4793, 39, '2019-04-10', '20:00', 1),
(4794, 39, '2019-04-11', '09:30', 1),
(4795, 39, '2019-04-11', '13:30', 1),
(4796, 39, '2019-04-11', '16:15', 1),
(4797, 39, '2019-04-11', '20:00', 1),
(4798, 39, '2019-04-12', '09:30', 1),
(4799, 39, '2019-04-12', '13:30', 1),
(4800, 39, '2019-04-12', '16:15', 1),
(4801, 39, '2019-04-12', '20:00', 1),
(4802, 39, '2019-04-13', '09:30', 1),
(4803, 39, '2019-04-13', '13:30', 1),
(4804, 39, '2019-04-13', '16:15', 1),
(4805, 39, '2019-04-13', '20:00', 1),
(4806, 39, '2019-04-14', '09:30', 1),
(4807, 39, '2019-04-14', '13:30', 1),
(4808, 39, '2019-04-14', '16:15', 1),
(4809, 39, '2019-04-14', '20:00', 1),
(4810, 39, '2019-04-15', '09:30', 1),
(4811, 39, '2019-04-15', '13:30', 1),
(4812, 39, '2019-04-15', '16:15', 1),
(4813, 39, '2019-04-15', '20:00', 1),
(4814, 39, '2019-04-16', '09:30', 1),
(4815, 39, '2019-04-16', '13:30', 1),
(4816, 39, '2019-04-16', '16:15', 1),
(4817, 39, '2019-04-16', '20:00', 1),
(4818, 39, '2019-04-17', '09:30', 1),
(4819, 39, '2019-04-17', '13:30', 1),
(4820, 39, '2019-04-17', '16:15', 1),
(4821, 39, '2019-04-17', '20:00', 1),
(4822, 39, '2019-04-18', '09:30', 1),
(4823, 39, '2019-04-18', '13:30', 1),
(4824, 39, '2019-04-18', '16:15', 1),
(4825, 39, '2019-04-18', '20:00', 1),
(4826, 39, '2019-04-19', '09:30', 1),
(4827, 39, '2019-04-19', '13:30', 1),
(4828, 39, '2019-04-19', '16:15', 1),
(4829, 39, '2019-04-19', '20:00', 1),
(4830, 39, '2019-04-20', '09:30', 1),
(4831, 39, '2019-04-20', '13:30', 1),
(4832, 39, '2019-04-20', '16:15', 1),
(4833, 39, '2019-04-20', '20:00', 1),
(4834, 39, '2019-04-21', '09:30', 1),
(4835, 39, '2019-04-21', '13:30', 1),
(4836, 39, '2019-04-21', '16:15', 1),
(4837, 39, '2019-04-21', '20:00', 1),
(4838, 39, '2019-04-22', '09:30', 1),
(4839, 39, '2019-04-22', '13:30', 1),
(4840, 39, '2019-04-22', '16:15', 1),
(4841, 39, '2019-04-22', '20:00', 1),
(4842, 39, '2019-04-23', '09:30', 1),
(4843, 39, '2019-04-23', '13:30', 1),
(4844, 39, '2019-04-23', '16:15', 1),
(4845, 39, '2019-04-23', '20:00', 1),
(4846, 40, '2019-04-03', '10:00', 1),
(4847, 40, '2019-04-04', '10:00', 1),
(4848, 40, '2019-04-05', '10:00', 1),
(4849, 40, '2019-04-06', '10:00', 1),
(4850, 40, '2019-04-07', '10:00', 1),
(4851, 40, '2019-04-08', '10:00', 1),
(4852, 40, '2019-04-09', '10:00', 1),
(4853, 40, '2019-04-10', '10:00', 1),
(4854, 40, '2019-04-11', '10:00', 1),
(4855, 40, '2019-04-12', '10:00', 1),
(4856, 40, '2019-04-13', '10:00', 1),
(4857, 40, '2019-04-14', '10:00', 1),
(4858, 40, '2019-04-15', '10:00', 1),
(4859, 40, '2019-04-16', '10:00', 1),
(4860, 40, '2019-04-17', '10:00', 1),
(4861, 40, '2019-04-18', '10:00', 1),
(4862, 40, '2019-04-19', '10:00', 1),
(4863, 40, '2019-04-20', '10:00', 1),
(4864, 40, '2019-04-21', '10:00', 1),
(4865, 40, '2019-04-22', '10:00', 1),
(4866, 40, '2019-04-23', '10:00', 1),
(4867, 40, '2019-04-24', '10:00', 1),
(4868, 40, '2019-04-25', '10:00', 1),
(4869, 40, '2019-04-26', '10:00', 1),
(4870, 40, '2019-04-27', '10:00', 1),
(4871, 40, '2019-04-28', '10:00', 1),
(4872, 40, '2019-04-29', '10:00', 1),
(4873, 40, '2019-04-30', '10:00', 1),
(4917, 41, '2019-03-29', '10:00', 1),
(4918, 41, '2019-03-30', '10:00', 1),
(4919, 41, '2019-03-31', '10:00', 1),
(4920, 41, '2019-04-01', '10:00', 1),
(4921, 41, '2019-04-02', '10:00', 1),
(4922, 41, '2019-04-03', '10:00', 1),
(4923, 41, '2019-04-04', '10:00', 1),
(4924, 41, '2019-04-05', '10:00', 1),
(4925, 41, '2019-04-06', '10:00', 1),
(4926, 41, '2019-04-07', '10:00', 1),
(4927, 41, '2019-04-08', '10:00', 1),
(4928, 41, '2019-04-09', '10:00', 1),
(4929, 41, '2019-04-10', '10:00', 1),
(4930, 41, '2019-04-11', '10:00', 1),
(4931, 41, '2019-04-12', '10:00', 1),
(4932, 41, '2019-04-13', '10:00', 1),
(4933, 41, '2019-04-14', '10:00', 1),
(4934, 41, '2019-04-15', '10:00', 1),
(4935, 41, '2019-04-16', '10:00', 1),
(4936, 41, '2019-04-17', '10:00', 1),
(4937, 41, '2019-04-18', '10:00', 1),
(4938, 41, '2019-04-19', '10:00', 1),
(4939, 41, '2019-04-20', '10:00', 1),
(4940, 41, '2019-04-21', '10:00', 1),
(4941, 41, '2019-04-22', '10:00', 1),
(4942, 41, '2019-04-23', '10:00', 1),
(4943, 41, '2019-04-24', '10:00', 1),
(4944, 41, '2019-04-25', '10:00', 1),
(4945, 41, '2019-04-26', '10:00', 1),
(4946, 41, '2019-04-27', '10:00', 1),
(4947, 41, '2019-04-28', '10:00', 1),
(4948, 41, '2019-04-29', '10:00', 1),
(4949, 41, '2019-04-30', '10:00', 1),
(4950, 41, '2019-05-01', '10:00', 1),
(4951, 41, '2019-05-02', '10:00', 1),
(4952, 41, '2019-05-03', '10:00', 1),
(4953, 41, '2019-05-04', '10:00', 1),
(4954, 41, '2019-05-05', '10:00', 1),
(4955, 41, '2019-05-06', '10:00', 1),
(4956, 41, '2019-05-07', '10:00', 1),
(4957, 41, '2019-05-08', '10:00', 1),
(4958, 41, '2019-05-09', '10:00', 1),
(4959, 41, '2019-05-10', '10:00', 1);
-- --------------------------------------------------------
--
-- Table structure for table `event_gallery`
--
CREATE TABLE `event_gallery` (
`id` int(11) NOT NULL,
`event_id` int(11) DEFAULT NULL,
`media_type` tinyint(3) DEFAULT NULL COMMENT '0=>Primary, 1 => Photos, 2 => Videos, 3 => Youtube Link',
`media_url` varchar(100) DEFAULT NULL,
`status` int(11) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `event_gallery`
--
INSERT INTO `event_gallery` (`id`, `event_id`, `media_type`, `media_url`, `status`) VALUES
(26, 18, 0, 'assets/uploads/services/asset_image1.png', 1),
(30, 19, 1, 'assets/uploads/services/asset_image3.png', 1),
(32, 19, 1, 'assets/uploads/services/asset_image21.png', 1),
(37, 22, 1, 'assets/uploads/services/asset_image13.png', 1),
(38, 22, 0, 'assets/uploads/services/asset_image23.png', 1),
(39, 22, 1, 'assets/uploads/services/giphy3.gif', 1),
(41, 21, 1, 'assets/uploads/services/sniper.jpg', 1),
(42, 21, 0, 'assets/uploads/services/Audi-r81.jpg', 1),
(46, 20, 1, 'assets/uploads/services/giphy5.gif', 1),
(48, 23, 0, 'assets/uploads/services/190121131326.jpg', 1),
(50, 17, 0, 'assets/uploads/services/117384125.jpg', 1),
(51, 17, 1, 'assets/uploads/services/web_zuerich_home_topevents_1600x900.jpg', 1),
(53, 25, 0, 'assets/uploads/services/WhatsApp_Image_2019-03-02_at_4.25.26_PM.jpeg', 1),
(54, 25, 1, 'assets/uploads/services/WhatsApp_Image_2019-03-02_at_4.25.27_PM_(1).jpeg', 1),
(55, 25, 1, 'assets/uploads/services/WhatsApp_Image_2019-03-02_at_4.25.27_PM_(2).jpeg', 1),
(56, 25, 1, 'assets/uploads/services/WhatsApp_Image_2019-03-02_at_4.25.27_PM_(3)1.jpeg', 1),
(57, 25, 1, 'assets/uploads/services/WhatsApp_Image_2019-03-02_at_4.25.27_PM.jpeg', 1),
(98, 26, 0, 'assets/uploads/services/1552385027_orig.jpg', 1),
(99, 26, 1, 'assets/uploads/services/1552385033_car1.jpg', 1),
(100, 28, 0, 'assets/uploads/services/1552385090_car.jpg', 1),
(101, 28, 1, 'assets/uploads/services/1552385090_car1.jpg', 1),
(102, 29, 0, 'assets/uploads/services/1552652612_media-froala-description-0-2018-9-5-t-14-14-32.jpeg', 1),
(103, 30, 0, 'assets/uploads/services/1552971877_media-froala-description-0-2018-9-5-t-14-14-32.jpeg', 1),
(104, 31, 0, 'assets/uploads/services/1552971921_car.jpg', 1),
(105, 32, 0, 'assets/uploads/services/1552972020_car1.jpg', 1),
(106, 33, 0, 'assets/uploads/services/1552972046_car1.jpg', 1),
(107, 34, 0, 'assets/uploads/services/1553673749_36911527671_f790ee9685_b.jpg', 1),
(108, 34, 1, 'assets/uploads/services/1553673749_shreya-2015-slider-01.jpg', 1),
(109, 34, 1, 'assets/uploads/services/1553673749_shreya-2015-slider-02.jpg', 1),
(110, 34, 1, 'assets/uploads/services/1553673749_ShreyaGhoshalAtBPD-hero-desktop-events-spotlight-1200x400.jpg', 1),
(111, 34, 1, 'assets/uploads/services/1553673749_Shreya-Ghoshal-Show-Sydney-160-1024x606.jpg', 1),
(112, 35, 0, 'assets/uploads/services/1553677772_sniper.jpg', 1),
(113, 36, 0, 'assets/uploads/services/1553678031_beirut.png', 1),
(114, 36, 1, 'assets/uploads/services/1553678031_Cairo.png', 1),
(115, 37, 0, 'assets/uploads/services/1553679547_1540376881_Dubai_Evening_Desert_Safari.jpeg.jpg', 1),
(116, 37, 1, 'assets/uploads/services/1553679547_Desert_Quad_Biking_Jeddah.jpg', 1),
(117, 37, 1, 'assets/uploads/services/1553679547_Safari-Desert-Jeddah.jpeg', 1),
(118, 37, 1, 'assets/uploads/services/1553679547_Standard-Safari-Desert-.jpeg', 1),
(119, 38, 0, 'assets/uploads/services/1553681129_1040036-548014143.jpg', 1),
(120, 38, 1, 'assets/uploads/services/1553681129_1040046-655378738.jpg', 1),
(121, 38, 1, 'assets/uploads/services/1553681129_images.jpg', 1),
(122, 38, 1, 'assets/uploads/services/1553681129_DuD85FvW4AAOoov.jpg', 1),
(123, 38, 1, 'assets/uploads/services/1553681129_DSprzsDX0AExOWg.jpg', 1),
(124, 38, 1, 'assets/uploads/services/1553681129_DpPQLX6WwAAiqkT.jpg', 1),
(125, 38, 1, 'assets/uploads/services/1553681129_true-waldorf-service.jpg', 1),
(126, 39, 0, 'assets/uploads/services/1553687286_1493898416-thakur.posttt.jpg', 1),
(127, 39, 1, 'assets/uploads/services/1553687286_big-cinemas-mattewada-warangal-multiplex-cinema-halls-qkpo8wy.png', 1),
(128, 39, 1, 'assets/uploads/services/1553687286_maxresdefault.jpg', 1),
(129, 40, 0, 'assets/uploads/services/1553688875_55ecdc_f2e243ca818b411b97c24056219aab37_mv2.jpg', 1),
(130, 40, 1, 'assets/uploads/services/1553688875_Atlantis-Activity-Pool.jpg', 1),
(131, 40, 1, 'assets/uploads/services/1553688875_LEGOLAND__Beach_Retreat_(79218).jpg', 1),
(132, 40, 1, 'assets/uploads/services/1553688875_legolandandreg-california-in-san-diego-763975.jpg', 1),
(133, 40, 1, 'assets/uploads/services/1553688875_legoland-florida-resort.jpg', 1),
(134, 40, 1, 'assets/uploads/services/1553688875_c700x420.jpg', 1),
(135, 40, 1, 'assets/uploads/services/1553688875_maxresdefault_(1).jpg', 1),
(137, 41, 1, 'assets/uploads/services/1553690754_cff3d1d8afd045a788194ac88d6906fb.jpg', 1),
(138, 41, 1, 'assets/uploads/services/1553690754_filename-1-jpg-thumbnail0.jpg', 1),
(139, 41, 1, 'assets/uploads/services/1553690754_ifly-dubai-indoor-skydiving.jpg', 1),
(140, 41, 1, 'assets/uploads/services/1553690754_event_banner_5646_1516166843.jpg', 1);
-- --------------------------------------------------------
--
-- Table structure for table `event_tags`
--
CREATE TABLE `event_tags` (
`id` int(11) NOT NULL,
`event_id` int(11) DEFAULT NULL,
`tag_id` int(11) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0 => Inactive 1 => Active 2 => Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `event_tags`
--
INSERT INTO `event_tags` (`id`, `event_id`, `tag_id`, `status`) VALUES
(189, 14, 3, 1),
(190, 2, 6, 1),
(191, 2, 2, 1),
(210, 15, 3, 1),
(211, 15, 2, 1),
(212, 16, 2, 1),
(219, 18, 11, 1),
(220, 18, 12, 1),
(243, 22, 12, 1),
(246, 19, 11, 1),
(247, 19, 12, 1),
(248, 20, 11, 1),
(249, 20, 12, 1),
(258, 23, 11, 1),
(259, 23, 13, 1),
(262, 17, 12, 1),
(263, 17, 13, 1),
(264, 17, 15, 1),
(292, 24, 16, 1),
(293, 24, 11, 1),
(362, 27, 11, 1),
(363, 27, 16, 1),
(367, 26, 11, 1),
(368, 28, 11, 1),
(369, 29, 16, 1),
(370, 30, 11, 1),
(371, 31, 11, 1),
(372, 32, 11, 1),
(373, 33, 11, 1),
(423, 21, 12, 1),
(424, 25, 11, 1),
(425, 25, 12, 1),
(426, 25, 17, 1),
(427, 25, 13, 1),
(428, 25, 15, 1),
(429, 25, 14, 1),
(430, 25, 18, 1),
(431, 25, 16, 1),
(433, 34, 11, 1),
(435, 35, 11, 1),
(436, 36, 11, 1),
(437, 37, 12, 1),
(438, 38, 13, 1),
(439, 39, 16, 1),
(440, 40, 17, 1),
(442, 41, 14, 1);
-- --------------------------------------------------------
--
-- Table structure for table `favourite`
--
CREATE TABLE `favourite` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `host_categories`
--
CREATE TABLE `host_categories` (
`host_cat_id` int(11) NOT NULL,
`host_category` varchar(150) DEFAULT NULL,
`show_layout` tinyint(3) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0 => Inactive 1 => Active 2 => Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `host_categories`
--
INSERT INTO `host_categories` (`host_cat_id`, `host_category`, `show_layout`, `status`) VALUES
(10, 'Restaurant', 0, 1),
(11, 'Movie Theater', 1, 1),
(12, 'Drama House', 1, 1),
(13, 'Hotel', 0, 1),
(14, 'KAFD', 0, 1),
(15, 'Desert Safari', 0, 1),
(16, 'Theme Parks', 0, 1),
(17, 'Indoor Sky diving', 0, 1),
(18, 'Tours', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `locality`
--
CREATE TABLE `locality` (
`id` int(11) NOT NULL,
`venue_id` int(11) NOT NULL,
`region_id` int(11) DEFAULT NULL,
`locality` varchar(255) NOT NULL,
`status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `locality`
--
INSERT INTO `locality` (`id`, `venue_id`, `region_id`, `locality`, `status`) VALUES
(7, 0, 7, 'Kakkanad', 1),
(8, 0, 8, 'Thalayolaparambu', 1),
(9, 0, 7, 'Edapally', 1),
(10, 0, 7, 'Edapally', 1),
(11, 0, 9, 'eart', 1),
(12, 0, 7, 'Jeddah', 1),
(13, 0, 15, 'Riyadh', 1),
(14, 0, 7, 'https://www.tripadvisor.in/Hotel_Review-g295419-d8487442-Reviews-Radisson_Blu_Plaza_Hotel_Jeddah-Jeddah_Makkah_Province.html#MAPVIEW', 1),
(15, 0, 7, 'https://www.tripadvisor.in/AttractionProductReview-g295424-d12112329-Dubai_Afternoon_Desert_Safari_and_BBQ_Dinner-Dubai_Emirate_of_Dubai.html#MAPVIEW', 1),
(16, 0, 7, 'https://www.tripadvisor.in/Restaurant_Review-g295419-d2523975-Reviews-Aromi-Jeddah_Makkah_Province.html#MAPVIEW', 1),
(17, 0, 7, 'https://www.google.com/maps/place/Dhahran+Movie+Theatre/@26.30374,50.12943,15z/data=!4m5!3m4!1s0x0:0x61a21ffb51693d34!8m2!3d26.3037403!4d50.1294297?hl=en-US', 1),
(18, 0, 7, 'https://www.google.com/maps/place/Legoland®+Dubai/@24.9187813,55.0100319,15z/data=!4m5!3m4!1s0x0:0xbed5f66b1ec7e315!8m2!3d24.9187813!4d55.0100319', 1),
(19, 0, 7, 'https://www.tripadvisor.in/Attraction_Review-g295424-d2148489-Reviews-IFly_Dubai_Indoor_Skydiving-Dubai_Emirate_of_Dubai.html#MAPVIEW', 1),
(20, 0, 7, 'Dubai', 1);
-- --------------------------------------------------------
--
-- Table structure for table `privacy_policy`
--
CREATE TABLE `privacy_policy` (
`id` int(11) NOT NULL,
`faq_en` longtext,
`faq_ar` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`privacy_policy_en` longtext,
`privacy_policy_ar` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`terms_and_conditions_en` longtext,
`terms_and_conditions_ar` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`contact_number` int(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `privacy_policy`
--
INSERT INTO `privacy_policy` (`id`, `faq_en`, `faq_ar`, `privacy_policy_en`, `privacy_policy_ar`, `terms_and_conditions_en`, `terms_and_conditions_ar`, `contact_number`) VALUES
(1, '<p>FAQ:- TBD</p>\r\n', '<p>FAQ: TBD</p>\r\n', '<p><strong>Privacy Policy; Personal Data</strong></p>\r\n\r\n<p>Timeout values its users’ privacy and will take particular care and follow security measures in order to protect their Personal Data from unauthorized third parties and accidental disclosures to the extent it can control the same. Personal Data means data about a customer, including, without limitation, name, address, e-mail address, past event attendance, event interests, credit card type, credit card digits and phone numbers, but excluding the payment data.</p>\r\n\r\n<p>Although we endeavor to protect your Personal Data, we cannot guarantee, because of the nature of the Internet, the security of your data transmitted to the website and any inward transmission of data is carried out at your own risk.</p>\r\n\r\n<p>By accepting these Terms and Conditions, you explicitly agree to the present privacy policy and the disclosures of Personal Data described herein.</p>\r\n\r\n<p>In case you have any request to access your Personal Data, amend it, update it or delete it or if you have a question, you can contact us hello@the3o3.com for assistance.</p>\r\n\r\n<p>We reserve the right, from time to time, with or without notice to you, to change our privacy policy at our entire and sole discretion. If we make changes, you will know either by revising the date at the bottom of the privacy policy or, in some cases, we may provide a notice of the change (by adding a statement to our homepage or sending an email notification to our customers).</p>\r\n\r\n<p>Our privacy policy applicable to you will be the version that is accessible at each date you access the website; hence, your use of the website after changes are made shall be deemed an approval by you to be bound by such changes. If you do not wish to accept any new or amended privacy policy, you should not continue to use the website.</p>\r\n\r\n<p>Please note that any websites that may be linked to our website are subject to their own privacy policy.</p>\r\n\r\n<p><strong>Access to Personal Data by the event organizers and Personal Data processing</strong></p>\r\n\r\n<p>All Personal Data disclosed by customers on event pages posted by an event organizer will be shared with the relevant organizer and/or used by Timeout and its affiliates in accordance with the present privacy policy. Nevertheless, payment data will not be shared with event organizers.</p>\r\n\r\n<p>Each event organizer:</p>\r\n\r\n<p>(a) will at all times comply with all applicable local, provincial, national and other laws, rules and regulations with respect to customers’ Personal Data; and</p>\r\n\r\n<p>(b) will at all times comply with any applicable policies posted herein with respect to said Personal Data; and</p>\r\n\r\n<p>(c) upon a customer’s request or as permitted, Timeout may at its discretion delete or anonymize Personal Data from the Services, at which time it will no longer be available to the event organizer through the Services or will no longer be linked to a specific customer.</p>\r\n\r\n<p>Without prejudice to the above-mentioned disclosure of Personal Data to event organizers, we will only process your Personal Data for the following purposes:</p>\r\n\r\n<p>a) <strong>creating and maintaining your user account,</strong> if you become a registered user on our website;</p>\r\n\r\n<p>b) <strong>Offering our content and providing our Services to you in a personalized way</strong>, e.g., by providing suggestions based on your previous searches or bookings to enable you to identify suitable content or Services that interest you quicker. This may also include, where legally permitted, processing data related to your location;</p>\r\n\r\n<p>c) <strong>Handling and fulfilling your requests for Services.</strong> This may also include processing of information that we receive from third parties, for example, address data to verify your correct address;</p>\r\n\r\n<p>d) <strong>Obtaining payment from you,</strong> if you purchase any of our Services;</p>\r\n\r\n<p>e) <strong>Enabling our service providers,</strong> whether or not for outsourced services, to carry out certain functions on our behalf, including payment processing, verification, technical, logistical or other functions, as may be required, in order to fulfill your bookings;</p>\r\n\r\n<p>f) <strong>Resolving any returns, refunds or disputes</strong>, if you lawfully exercise your rights;</p>\r\n\r\n<p>g) <strong>Ensuring the security of your account and our business, preventing or detecting fraud or abuses of our website,</strong> for example, by requesting verification information in order to reset your account password;</p>\r\n\r\n<p>h) <strong>Developing and improving our products and Services,</strong> for example, by reviewing visits to our website, demand for specific content and services and user comments;</p>\r\n\r\n<p>i) <strong>Serving personalized advertising to your devices; </strong>i.e. by delivering ads based on your interests ascertained from your past searches and purchases on our website, and other data obtained through the use of "cookies" placed on your devices. Please see our Cookies statement below; and</p>\r\n\r\n<p>j) <strong>To comply with applicable law,</strong> for example, in response to a request from a court or regulatory body, where such request is made in accordance with the law.</p>\r\n\r\n<p><strong>Liability disclaimer</strong></p>\r\n\r\n<p>You agree that your use of the website is entirely at your own risk.</p>\r\n\r\n<p>To the fullest extent possible, we expressly disclaim all warranties, terms, conditions and representations that might otherwise be implied by law in relation to the website, including, without limitation, warranties of technical efficiency, satisfactory quality, availability, non-infringement, completeness and fitness for a particular purpose. The website may contain inaccuracies and typographical errors.</p>\r\n\r\n<p>The content on the website is provided for general information only and is not intended to be relied upon as advice.</p>\r\n\r\n<p>The website may contain advertisements. Timeout does not endorse the content of such advertisements and does not accept any responsibility for any errors or inaccuracies in such advertising material.</p>\r\n\r\n<p>We shall not be liable for any damages arising from the use or performance of the website, the provision of or failure to provide the Services, or for any information obtained through the website, or otherwise arising out of the use of the website, whether based on contract, tort, or otherwise, even if Timeout has been advised of the possibility of damage. </p>\r\n\r\n<p>Timeout may suspend or withdraw or restrict the availability of all or any part of our website for whatever reason.</p>\r\n\r\n<p>In case of dissatisfaction with any portion of the website, or with any of these Terms, your sole remedy, except as specifically provided in these terms, is to stop using the website.</p>\r\n\r\n<p><strong>Cookies</strong></p>\r\n\r\n<p>By using this website, navigating around it and using our Services, you agree to the use of cookies.</p>\r\n\r\n<p>You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can modify your browser settings to decline cookies if you prefer. This may prevent you from taking full advantage of the website.</p>\r\n\r\n<p>A cookie is a small file which asks permission to be placed on your computer’s hard drive. Once you agree to that, the file is added and the cookie helps analyze web traffic and allows web applications to respond to you as an individual: such web application can then tailor its operations to your needs, likes and dislikes, by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyze data and improve our website in accordance with customer needs.</p>\r\n\r\n<p>Cookies help us improve our website, by enabling us to monitor the pages you find useful. However, a cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us.</p>\r\n\r\n<p><strong>Miscellaneous</strong></p>\r\n\r\n<p>These Terms and Conditions shall be governed by Saudi law and any dispute related thereto shall be exclusively resolved by Riyadh courts.</p>\r\n\r\n<p>Any section or provision of these terms and conditions that are found to be illegal or unenforceable shall not affect the rest of these terms and conditions.</p>\r\n\r\n<p>We may terminate your right to use the Services at any time in case you breach these Terms and conditions or misuse the Services.</p>\r\n\r\n<p> </p>\r\n', '<p><strong>سياسة الخصوصية: البيانات الشخصية</strong></p>\r\n\r\n<p>تقدّر تايم أوت خصوصية مستخدميها وستهتم بشكل خاص وتتبع تدابير الأمان من أجل حماية بياناتهم الشخصية من أطراف ثالثة غير مصرح لها والإفصاح العرضي إلى الحد الذي يمكن التحكم فيه. البيانات الشخصية تعني البيانات المتعلقة بالعميل، بما في ذلك، على سبيل المثال لا الحصر، الاسم، والعنوان، وعنوان البريد الإلكتروني، وحضور سابق للمناسبة، المناسبات التي يهتم بها، نوع بطاقة الائتمان، وأرقام بطاقة الائتمان وأرقام الهواتف، ولكن باستثناء بيانات الدفع.</p>\r\n\r\n<p>على الرغم من أنّنا نسعى لحماية بياناتك الشخصية، إلّا أنّنا لا نستطيع أن نضمن، نظرًا لطبيعة الإنترنت، أمن بياناتك المنقولة إلى الموقع الإلكتروني وأي نقل للبيانات داخليًا يتم على مسؤوليتك الخاصة.</p>\r\n\r\n<p>بقبولك لهذه الشروط والأحكام، أنت توافق صراحة على سياسة الخصوصية الحالية والإفصاح عن البيانات الشخصية المذكورة هنا.</p>\r\n\r\n<p>في حال كان لديك أي طلب للوصول إلى بياناتك الشخصية، أو تعديلها، أو تحديثها أو حذفها أو إذا كان لديك سؤال، فيمكنك التواصل معنا على hello@the3o3.com للمساعدة.</p>\r\n\r\n<p>نحن نحتفظ بالحق، من وقت لآخر، مع أو بدون إشعارك، في تغيير سياسة الخصوصية الخاصة بنا وفقًا لتقديرنا المطلق. إذا قمنا بإجراء تغييرات، فستعرف إمّا عن طريق مراجعة التاريخ أسفل سياسة الخصوصية، أو في بعض الحالات، قد نقدم إشعارًا بالتغيير (عن طريق إضافة بيان على صفحتنا الرئيسية أو إرسال إشعار عبر البريد الإلكتروني إلى عملائنا).</p>\r\n\r\n<p>ستكون سياسة الخصوصية المطبقة عليك هي الإصدار الذي يمكن الوصول إليه في كل تاريخ تدخل فيه إلى الموقع الإلكتروني؛ وبالتالي، يعتبر استخدامك للموقع بعد إجراء التغييرات موافقة منك على الالتزام بهذه التغييرات. إذا كنت لا ترغب في قبول أي سياسة خصوصية جديدة أو معدلة، يجب ألا تستمر في استخدام الموقع الإلكتروني.</p>\r\n\r\n<p>يرجى ملاحظة أن أي مواقع إلكترونية قد تكون مرتبطة بموقعنا تخضع لسياسة الخصوصية الخاصة بها.</p>\r\n\r\n<p><strong>الوصول إلى البيانات الشخصية من قبل منظمي المناسبة ومعالجة البيانات الشخصية.</strong></p>\r\n\r\n<p>سوف يتم مشاركة جميع البيانات الشخصية التي يكشف عنها العملاء على صفحات المناسبة المنشورة بواسطة منظم المناسبة ذو الصلة و/أو المستخدمة من تايم أوت والشركات التابعة لها وفقًا لسياسة الخصوصية الحالية. ومع ذلك، لن تتم مشاركة بيانات الدفع مع منظمي المناسبة.</p>\r\n\r\n<p>كل منظم مناسبة:</p>\r\n\r\n<p>أ) سوف يلتزم في جميع الأوقات بجميع الأنظمة، والقواعد، واللوائح المحلية، والإقليمية، والوطنية المعمول بها فيما</p>\r\n\r\n<p>يتعلق بالبيانات الشخصية للعملاء؛ و</p>\r\n\r\n<p>ب) سوف يلتزم في جميع الأوقات بالسياسات المعمول بها المنشورة هنا فيما يتعلق بالبيانات الشخصية المذكورة؛ و</p>\r\n\r\n<p>ج) بناءً على طلب العميل أو على النحو المسموح به، يجوز لتايم أوت وفقًا لتقديرها حذف البيانات الشخصية من الخدمات أو إخفائها، عند ذلك الوقت لن تكون متاحًة لمنظم المناسبة عبر الخدمات أو لن تكون مربوطة بعميل معين.</p>\r\n\r\n<p>دون المساس بالإفصاح المذكور أعلاه عن البيانات الشخصية لمنظمي المناسبة، سنقوم بمعالجة بياناتك الشخصية فقط للأغراض التالية:</p>\r\n\r\n<p>أ) <strong>إنشاء حساب المستخدم الخاص بك والمحافظة عليه</strong>، إذا أصبحت مستخدمًا مسجلاً على موقعنا؛</p>\r\n\r\n<p>ب) <strong>تقديم المحتوى الخاص بنا وتقديم خدماتنا لك بطريقة مخصصة،</strong> على سبيل المثال، من خلال تقديم اقتراحات بناءً على عمليات البحث أو الحجوزات السابقة الخاصة بك لتمكينك من تحديد المحتوى المناسب أو الخدمات التي تهمك بشكل أسرع. وقد يشمل ذلك أيضًا، حيثما يكون ذلك مسموحًا به قانونًا، معالجة البيانات المتعلقة بموقعك؛</p>\r\n\r\n<p>ج) <strong>معالجة وتلبية طلباتك للخدمات.</strong> قد يشمل ذلك أيضًا معالجة المعلومات التي نتلقاها من أطراف ثالثين، على سبيل المثال، بيانات العنوان للتحقق من عنوانك الصحيح؛</p>\r\n\r\n<p>د) <strong>الحصول على الدفع منك</strong>، إذا قمت بشراء أي من خدماتنا؛</p>\r\n\r\n<p>ه) <strong>تمكين مزودي الخدمة لدينا</strong>، سواء كان للخدمات الخارجية أم لا، من أداء وظائف معينة نيابة عنا، بما في ذلك معالجة الدفع، أو التحقق، أو الوظائف التقنية، أو اللوجيستية أو غيرها من الوظائف، حسب الاقتضاء، من أجل الوفاء بحجوزاتك ؛</p>\r\n\r\n<p>و) <strong>معالجة أي عوائد، أو استردادات، أو نزاعات،</strong> إذا كنت تمارس حقوقك بشكل قانوني؛</p>\r\n\r\n<p>ز) <strong>التأكد من أمان حسابك وأعمالنا، منع أو اكتشاف الاحتيال أو إساءة استخدام موقعنا،</strong> على سبيل المثال، من خلال طلب معلومات التحقق لإعادة تعيين كلمة المرور الخاصة بحسابك؛</p>\r\n\r\n<p>ح) <strong>تطوير وتحسين منتجاتنا وخدماتنا</strong>، على سبيل المثال، من خلال مراجعة زيارات موقعنا، والطلب على محتوى وخدمات محددة وتعليقات المستخدمين؛</p>\r\n\r\n<p>ط) <strong>تقديم إعلانات مخصصة لأجهزتك؛</strong> أي عن طريق تقديم الإعلانات بناءً على اهتماماتك التي تم التحقق منها من عمليات البحث والشراء السابقة على موقعنا، والبيانات الأخرى التي تم الحصول عليها من خلال استخدام "ملفات تعريف الارتباط" الموضوعة على أجهزتك. يرجى الاطلاع على بيان ملفات تعريف الارتباط أدناه؛ و</p>\r\n\r\n<p>ي) <strong>الامتثال للنظام المعمول به</strong>، على سبيل المثال، استجابة لطلب مقدم من محكمة أو هيئة تنظيمية، حيث يتم تقديم هذا الطلب وفقًا للنظام.</p>\r\n\r\n<p><strong>إخلاء المسؤولية</strong></p>\r\n\r\n<p>أنت توافق على أنّ استخدامك للموقع الإلكتروني يقع على مسؤوليتك الخاصة.</p>\r\n\r\n<p>إلى أقصى حد ممكن، نحن نخلي المسؤولية صراحة من جميع الضمانات، والشروط، والأحكام والتمثيلات التي قد تكون ضمنية بموجب النظام فيما يتعلق بالموقع الإلكتروني، بما في ذلك، على سبيل المثال لا الحصر، ضمانات الكفاءة التقنية، والجودة المرضية، والإتاحة، وعدم الانتهاك، والكمال والتوافق لغرض معين. قد يحتوي الموقع الإلكتروني على أخطاء ناتجة عن عدم الدقة وأخطاء مطبعية.</p>\r\n\r\n<p>يتم توفير المحتوى على الموقع الإلكتروني للحصول على معلومات عامة فقط وليس المقصود منه الاعتماد عليه كنصيحة.</p>\r\n\r\n<p>قد يحتوي الموقع على إعلانات. لا تؤيد تايم أوت محتوى هذه الإعلانات ولا تقبل أي مسؤولية عن أي أخطاء أو عدم دقة في هذه المواد الإعلانية.</p>\r\n\r\n<p>لن نتحمل مسؤولية أي أضرار تنشأ عن استخدام أو أداء الموقع الإلكتروني، أو عن تقديم أو فشل في تقديم الخدمات، أو عن أي معلومات تم الحصول عليها من خلال الموقع الإلكتروني، أو الناشئة بطريقة أخرى عن استخدام الموقع الإلكتروني، سواءً كان ذلك استنادًا على العقد، أو الضرر، أو غير ذلك، حتى إذا تم إعلام تايم أوت بإمكانية حدوث ضرر.</p>\r\n\r\n<p>يجوز لتايم أوت إيقاف، سحب أو تقييد توفر كل أو جزء من موقعنا الإلكتروني لأي سبب من الأسباب.</p>\r\n\r\n<p>في حالة عدم الرضا عن أي جزء من الموقع الإلكتروني، أو مع أي من هذه الشروط، فإنّ الحل الوحيد، باستثناء ما هو منصوص عليه تحديداً في هذه الشروط، هو التوقف عن استخدام الموقع الإلكتروني.</p>\r\n\r\n<p><strong>ملفات تعريف الارتباط</strong></p>\r\n\r\n<p>باستخدام هذا الموقع الإلكتروني، وتصفحه واستخدام خدماتنا ، فإنّك توافق على استخدام ملفات تعريف الارتباط.</p>\r\n\r\n<p>يمكنك اختيار قبول أو رفض ملفات تعريف الارتباط. إنّ معظم متصفحات الويب تقبل ملفات تعريف الارتباط تلقائيًا، ولكن يمكنك تعديل إعدادات المتصفح لرفض ملفات تعريف الارتباط إذا كنت تفضل ذلك. هذا قد يمنعك من الاستفادة الكاملة من الموقع.</p>\r\n\r\n<p>ملف تعريف الارتباط هو ملف صغير يطلب الإذن بوضعه على القرص الصلب لجهاز الكمبيوتر الخاص بك. بمجرد موافقتك على ذلك، تتم إضافة الملف ويساعد ملف تعريف الارتباط على تحليل حركة مرور الويب ويسمح لتطبيقات الويب بالرد عليك كفرد: يمكن لتطبيق الويب هذا أن يخصص عملياته على حسب احتياجاتك، وما تحب وتكره، من خلال جمع المعلومات عن تفضيلاتك وتذكرها. نحن نستخدم ملفات تعريف الارتباط بسجل حركة المرور لتحديد الصفحات التي يتم استخدامها. هذا يساعدنا على تحليل البيانات وتحسين موقعنا على شبكة الإنترنت وفقاً لاحتياجات العملاء.</p>\r\n\r\n<p>تساعدنا ملفات تعريف الارتباط على تحسين موقعنا الإلكتروني، من خلال تمكيننا من مراقبة الصفحات التي تجدها مفيدة. ومع ذلك، لا يتيح لنا ملف تعريف الارتباط بأي حال من الأحوال الوصول إلى جهاز الكمبيوتر الخاص بك أو أي معلومات عنك، بخلاف البيانات التي تختار مشاركتها معنا.</p>\r\n\r\n<p><strong>مختلف</strong></p>\r\n\r\n<p>يجب أن تخضع هذه الشروط والأحكام للنظام السعودي وأي نزاع يتعلق بها يتم حله حصريًا من قبل محاكم الرياض.</p>\r\n\r\n<p>أي قسم أو بند من هذه الشروط والأحكام التي ثبت أنها غير نظامية أو غير قابلة للتنفيذ لن تؤثر على بقية هذه الشروط والأحكام.</p>\r\n\r\n<p>يجوز لنا إنهاء حقك في استخدام الخدمات في أي وقت في حالة خرقك لهذه الشروط والأحكام أو إساءة استخدام الخدمات.</p>\r\n', '<p><strong>Terms & Conditions</strong></p>\r\n\r\n<p><strong>About Us: Services and Users.</strong></p>\r\n\r\n<p>Timeout is an online platform publishing, promoting and selling events that are either created by Timeout and exclusive to its users, or created by external organizers. It is operated by Timeout Company for Electronic Marketing Timeout’s online platform also publishes restaurant details. Our core events focus on the Kingdom of Saudi Arabia, but with Timeout’s international expansion shall soon cover several other countries.</p>\r\n\r\n<p>Our platform is available on the internet, or through our IOS and Android Apps.</p>\r\n\r\n<p>All events published on our platform are identified by their name, description, images, their terms and conditions and price of the ticket giving access to the event, if any, since the event may be free or not.</p>\r\n\r\n<p>The payment of the price of the event, where applicable, is done on our platform itself when booking the event, through the secure Bayan Pay payment gateway. The price of the events created by external organizers shall include the commission of Timeout on the tickets sold for such events.</p>\r\n\r\n<p>Our page is available in Arabic, English, and soon in additional languages.</p>\r\n\r\n<p><strong>Terms of Use.</strong></p>\r\n\r\n<p>The following sets forth the terms of use on the basis of which you may use the above-described Services (the <strong>“Terms of Use”</strong>).</p>\r\n\r\n<p>f you use the Services in any way, these Terms of Use apply to you. <strong>Please read them carefully as they clarify your rights and liabilities.</strong></p>\r\n\r\n<p>By accepting the Terms and Conditions and using the Services in any manner, you agree to these Terms of Use without modification and enter into a binding contract with Timeout. If you do not agree with the Terms and Conditions as they apply to this website, then please refrain from accessing or using the site. </p>\r\n\r\n<p>These Terms of Use and the rights and obligations it contains are incorporated into the Terms and Conditions by reference.</p>\r\n\r\n<p><strong>Refunds.</strong></p>\r\n\r\n<p>The varying exchange and refund policies of our event organizers prevent Timeout from issuing exchanges or refunds initiated by a customer after he/she places a booking. Therefore, in case a customer wants a refund after booking but prior to the event, he/she should contact the event organizer of his/her event with any refund requests.</p>\r\n\r\n<p>If you receive a refund, you should discard your ticket, delivered by us or the event organizer, and you will not use it or copy it to attend the event. Violation of the foregoing would constitute fraud.</p>\r\n\r\n<p>However, in case of events’ cancellation, a customer can request a refund or exchange, and such request will be fully processed by us with the event organizer. In case of a refund, its value upon execution (which equals the value of the ticket sold plus any other additional cost as set forth within these Terms of Use or within the terms and conditions of the event it relates to; e.g.: a penalty equal to x% of the value of the ticket sold in case the event is cancelled within 24 hours before the starting time) will be deducted from the amount owed by us to the event organizer.<br />\r\n </p>\r\n\r\n<p>We therefore ask that all customers contact us with any refund/exchange request for event cancellation. You can find help with getting a refund contacting our Customer Service. Organizers agree to post and maintain a refund policy in accordance with the terms and conditions of the event.</p>\r\n\r\n<p>In case of a postponed event, a change of venue or a significant change in an event, customers are required to contact Timeout no later than (2) days following the postponement/change, but in any case, prior to the event taking place, in order to request refunds due.</p>\r\n\r\n<p><strong>Taxes</strong></p>\r\n\r\n<p>The price set to book a ticket for an event is inclusive of all taxes payable for the ticket’s purchase, in addition to the commission due to Timeout in case of tickets of external event organizers.</p>\r\n\r\n<p>Each external event organizer shall ensure to pay such taxes due to the relevant authorities, and in no event this tax payment shall be Timeout’s responsibility.</p>\r\n\r\n<p>If Timeout is required to pay such tax at any time and for any reason whatsoever, it will deduct the amounts so paid as taxes from the amounts it owes to the external event organizer(s).</p>\r\n\r\n<p><strong>Trademarks</strong></p>\r\n\r\n<p>Timeout, the website, the apps and design are registered trademarks of Timeout Company for Electronic Marketing. All rights reserved.</p>\r\n\r\n<p>A number of issued patents and patents pending may apply to the Services.</p>\r\n\r\n<p>The information, graphic representations or images on the website are also protected by copyrights owned by Timeout and/or third parties.</p>\r\n\r\n<p>Please be warned that if you copy all or part of the Services, you are violating these patent rights and copyrights. You are only granted a limited license to access and use the website solely for your personal, non-commercial use. You therefore agree not to store or use the website (or any part of it) in any way other than their intended use.</p>\r\n\r\n<p>Without Timeout’s prior written consent, you may not use, transfer, copy, reproduce, alter, modify or create derivative works of any part of the website or its contents or its source HTML code in whole or in part, in any form or by any means, electronic, mechanical or otherwise, except for the sole purpose of viewing the site and its content. This includes electronic reproduction by uploading or downloading.</p>\r\n', '<p><strong>الشروط والأحكام</strong></p>\r\n\r\n<p><strong>بخصوصنا: الخدمات والمستخدمين</strong></p>\r\n\r\n<p>تايم أوت هي عبارة عن منصة إلكترونية تقوم بنشر، وترويج وبيع المناسبات التي إمّا أنّها أنشئت من قبل تايم أوت وحصرياً لعملائها، أو أنّها أنشئت من قبل منظمين خارجيين. يتم تشغيل هذه المنصة من شركة الوقت المستقطع للتسويق الالكتروني. تقوم أيضاً منصة تايم أوت الإلكترونية بنشر تفاصيل المطاعم. تركز مناسباتنا الأساسية على المملكة العربية السعودية، ولكن مع توسع تايم أوت الدولي فإنّها ستغطي قريباً العديد من البلدان الأخرى.</p>\r\n\r\n<p>إنّ منصتنا متاحة على شبكة الإنترنت، أو من خلال تطبيقاتنا على جهاز الآيفون أو الأندرويد.</p>\r\n\r\n<p>جميع المناسبات التي تنشر على منصتنا معرّفة بأسمائها، وصفها، صورها، شروطها وأحكامها وأسعار التذاكر التي تتيح الدخول إلى المناسبة، إن وجدت، حيث يمكن أن تكون المناسبة مجانية أو مدفوعة.</p>\r\n\r\n<p>يتم دفع قيمة المناسبة، عندما تطبق، على منصتنا الأساسية عند حجز المناسبة، من خلال بوابة مدفوعات بيان للدفع الآمن. إنّ سعر المناسبات التي أنشأها منظمون خارجيون سوف يشمل عمولات تايم أوت على التذاكر المباعة لمثل هذه المناسبات.</p>\r\n\r\n<p>صفحتنا متوفرة باللغات العربية والإنجليزية وقريباً بلغات إضافية.</p>\r\n\r\n<p><strong>شروط الاستخدام</strong></p>\r\n\r\n<p>يبيّن ما يلي شروط الاستخدام التي يمكنك على أساسها استخدام الخدمات الموضحة أعلاه <strong>("شروط الاستخدام").</strong></p>\r\n\r\n<p>إذا كنت تقوم باستخدام الخدمات بأي شكل كان، فإنّ شروط الاستخدام هذه تنطبق عليك. <strong>يرجى قراءتها بعناية لأنّها توضح حقوقك وواجباتك.</strong></p>\r\n\r\n<p>بقبولك للشروط والأحكام واستخدام الخدمات بأي شكل كان، فأنت توافق على شروط الاستخدام هذه دون تعديل وتُبرم عقداً ملزماً مع تايم أوت. إذا كنت لا توافق على الشروط والأحكام المطبقة على هذا الموقع الإلكتروني، فالرجاء الإمتناع عن الدخول إلى الموقع أو استخدامه.</p>\r\n\r\n<p>إنّ شروط الاستخدام هذه والحقوق والالتزامات التي تتضمنها هي مدمجة بالشروط والأحكام.</p>\r\n\r\n<p><strong>استرداد الأموال</strong></p>\r\n\r\n<p>تمنع سياسات التبادل والاسترداد المتغيرة لمنظمي المناسبات تايم أوت من القيام بعمليات التبادل أو استرداد الأموال التي يقوم بها العميل بعد إجراء الحجز. بالتالي، في حال رغب العميل باسترداد الأموال بعد القيام بالحجز ولكن قبل المناسبة، فيجب عليه التواصل مع منظّم المناسبة الخاصة به بخصوص أي طلبات استرداد.</p>\r\n\r\n<p>إذا قمت باستلام الأموال المستردة، يجب عليك التخلص من التذكرة، التي قمنا نحن أو منظم المناسبة بتقديمها، ولن تقوم باستخدامها أو نسخها لحضور المناسبة. إنّ انتهاك ما تقدم سوف يشكل احتيالًا.</p>\r\n\r\n<p>مع ذلك، في حال إلغاء المناسبة، يمكن للعميل طلب استرداد للمبلغ أو استبداله، وسيتم معالجة مثل هذا الطلب بالكامل من قبلنا مع منظم المناسبة. في حال استرداد المبلغ، فإنّ قيمته عند التنفيذ (والذي يعادل قيمة التذكرة المباعة بالإضافة إلى أية تكاليف إضافية أخرى كما هو مذكور في شروط الاستخدام هذه أو في شروط وأحكام المناسبة المتعلقة بها، مثلاً: غرامة تساوي x٪ من قيمة التذكرة المباعة في حال إلغاء الحدث خلال 24 ساعة قبل وقت البدء) سيتم خصمها من المبلغ المتوجب لنا من منظم الحدث.</p>\r\n\r\n<p>ذلك نطلب من جميع العملاء الاتصال بنا مع أي طلب استرداد/ استبدال بسبب إلغاء الحدث. يمكنك العثور على المساعدة حول كيفية استرجاع الأموال من خلال التواصل مع خدمة العملاء الخاصة بنا. يوافق المنظمون على نشر سياسة استرداد الأموال والمحافظة عليها وفقًا لشروط وأحكام المناسبة.</p>\r\n\r\n<p>في حال تأجيل المناسبة، أو تغيير في المكان أو تغيير هام في مناسبة، يتعيّن على العملاء الاتصال بـتايم أوت في موعد لا يتجاوز (2) يومين بعد التأجيل/ التغيير، ولكن على أي حال، قبل إجراء المناسبة، من أجل إسترداد المبالغ المستحقة.</p>\r\n\r\n<p><strong>الضرائب</strong></p>\r\n\r\n<p>يشمل السعر المحدد لحجز تذكرة مناسبة ما جميع الضرائب المستحقة عند شراء التذكرة، بالإضافة إلى العمولة المستحقة لتايم أوت في حالة تذاكر عائدة لمنظمي المناسبات الخارجية.</p>\r\n\r\n<p>سوف يضمن كل منظم مناسبة خارجي دفع هذه الضرائب المستحقة للجهات المختصة، ولن يكون دفع هذه الضرائب بأي حال من الأحوال مسؤولية تايم أوت.</p>\r\n\r\n<p>إذا كانت تايم أوت ملزمة بدفع مثل هذه الضرائب في أي وقت ولأي سبب كان، سوف يخصم المبلغ المدفوع كضريبة من المبلغ المتوجب لمنظّم المناسبة الخارجية.</p>\r\n\r\n<p><strong>العلامة التجارية</strong></p>\r\n\r\n<p>إنّ تايم أوت، الموقع الإلكتروني، التطبيقات والتصميم جميعها علامات تجارية مسجلة لـ شركة الوقت المستقطع للتسويق الالكتروني. جميع الحقوق محفوظة.</p>\r\n\r\n<p>قد يتم تطبيق عدد من براءات الإختراع الصادرة و براءات الإختراع المعلقة على الخدمات.</p>\r\n\r\n<p>إنّ المعلومات، الرسوم البيانية أو الصور الموجودة على الموقع الإلكتروني جميعها أيضاً محمية بحقوق النشر التي تملكها تايم أوت و/أو الأطراف الثالثين.</p>\r\n\r\n<p>يرجى الحذر بأنّه إذا قمت بنسخ كل الخدمات أو جزء منها، فإنّك تنتهك براءات الإختراع وحقوق النشر هذه. يتم منحك ترخيصًا محدودًا فقط للوصول إلى الموقع واستخدامه فقط لاستخدامك الشخصي، غير التجاري. لذلك، أنت توافق على عدم تخزين أو استخدام الموقع الإلكتروني (أو أي جزء منه) بأي طريقة غير الاستخدام المقصود منه.</p>\r\n\r\n<p>بدون موافقة كتابية مسبقة من تايم أوت، لا يجوز لك استخدام، أو نقل، أو نسخ، أو إعادة إنتاج، أو تغيير، أو تعديل أو إنشاء أعمال مشتقة لأي جزء من الموقع أو محتوياته أو مصدر كود الـ HTML الخاص به كليًا أو جزئيًا، بأي شكل أو بأي وسيلة ، إلكترونية أو ميكانيكية أو غير ذلك، باستثناء الغرض الوحيد من عرض الموقع ومحتواه. ويشمل ذلك الاستنساخ الإلكتروني عن طريق التحميل أو التنزيل.</p>\r\n', 1234567890);
-- --------------------------------------------------------
--
-- Table structure for table `provider`
--
CREATE TABLE `provider` (
`id` int(11) NOT NULL,
`provider_id` int(11) DEFAULT NULL,
`name` varchar(55) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`phone` varchar(25) DEFAULT NULL,
`profile_image` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `provider`
--
INSERT INTO `provider` (`id`, `provider_id`, `name`, `email`, `phone`, `profile_image`) VALUES
(1, 22, 'rgt', 'tobin.errtger@gmail.com', '4829236233', 'assets/uploads/services/1553453170_OCB-Football-Seating-Map-FINAL.jpg'),
(2, 23, 'rdfg', 'tobzsdrgf@gmail.com', '54829235623', 'assets/uploads/services/1553453196_OCB-Football-Seating-Map-FINAL.jpg'),
(3, 2, 'rdfg', 'tobzsdgf@gmail.com', '54829236233', 'assets/uploads/services/1553453196_OCB-Football-Seating-Map-FINAL.jpg'),
(4, 26, 'anu', 'anu@gmail.com', '9865321458', NULL),
(5, 27, 'anu', 'anu@gmail.com', '9865321458', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `region`
--
CREATE TABLE `region` (
`id` int(11) NOT NULL,
`name` varchar(100) DEFAULT NULL,
`region_icon` varchar(250) DEFAULT NULL,
`region_lat` varchar(100) NOT NULL,
`region_lng` varchar(100) NOT NULL,
`status` int(11) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive, 2 - Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `region`
--
INSERT INTO `region` (`id`, `name`, `region_icon`, `region_lat`, `region_lng`, `status`) VALUES
(7, 'Jeddah', 'assets/uploads/services/1553669816_Jeddah1.png', '21.485811', '39.1925048', 1),
(8, 'Badr', 'assets/uploads/services/1552049078_asset_location2.png', '', '', 2),
(9, 'Beirut', 'assets/uploads/services/1553669949_beirut1.png', '', '', 1),
(10, 'Cairo', 'assets/uploads/services/1553669967_Cairo1.png', '', '', 1),
(11, 'Khobar', 'assets/uploads/services/1553669988_khobar1.png', '', '', 1),
(12, 'Jalajil', 'assets/uploads/services/1552049133_asset_location3.png', '', '', 2),
(13, 'Najran', 'assets/uploads/services/1552049147_asset_location3.png', '', '', 2),
(14, 'Qatif', 'assets/uploads/services/1552049160_asset_location2.png', '', '', 2),
(15, 'Riyadh', 'assets/uploads/services/1553669901_Riyadh1.png', '', '', 1),
(16, 'Riyadh', 'assets/uploads/services/1552075638_RiyadhIcon.png', '', '', 2),
(17, 'Mecca', 'assets/uploads/services/1553670007_Mecca.png', '', '', 1),
(18, 'London', 'assets/uploads/services/1553670023_London.png', '', '', 1),
(19, 'kochi', 'assets/uploads/services/1553784223_Welcome_Scan.jpg', '9.9312328', '76.2673041', 1);
-- --------------------------------------------------------
--
-- Table structure for table `reservation`
--
CREATE TABLE `reservation` (
`id` int(11) NOT NULL,
`restaurant_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`date` date DEFAULT NULL,
`time` varchar(45) DEFAULT NULL,
`seats` int(11) DEFAULT NULL,
`status` int(11) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `review`
--
CREATE TABLE `review` (
`id` int(11) NOT NULL,
`event_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`rate` int(11) DEFAULT NULL COMMENT '1 - 5',
`feedback` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `setting`
--
CREATE TABLE `setting` (
`id` int(11) NOT NULL,
`title` varchar(250) NOT NULL,
`title_short` varchar(250) NOT NULL,
`site_logo` varchar(150) NOT NULL,
`fav_icon` varchar(150) NOT NULL,
`country_flag` varchar(10) NOT NULL DEFAULT 'US',
`currency` varchar(10) NOT NULL,
`service_charge` double NOT NULL DEFAULT '0',
`smtp_host` varchar(150) NOT NULL,
`smtp_username` varchar(150) NOT NULL,
`smtp_password` varchar(150) NOT NULL,
`google_api_key` varchar(500) DEFAULT NULL,
`merchant_key` varchar(300) DEFAULT NULL,
`merchant_id` varchar(300) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `setting`
--
INSERT INTO `setting` (`id`, `title`, `title_short`, `site_logo`, `fav_icon`, `country_flag`, `currency`, `service_charge`, `smtp_host`, `smtp_username`, `smtp_password`, `google_api_key`, `merchant_key`, `merchant_id`) VALUES
(1, 'Event - Time Out', 'TimeOut', 'assets/uploads/services/1553688925_asset_logo.png', 'assets/uploads/services/1549257477_sniper.jpg', 'SA', 'SAR', 30, 'info@mail.in', 'AIzaSyC9JX3BZZfx2S6GQieC_PqjuJdUbZ7_wyM1', 'Golden_1234', 'AIzaSyCcc-YDSJyDpehNE6qfntfWpEQ4uS4aq6A', '+Hu4bL6iVk943JmFAvGtWEYMODFry4fad2I+iM0X2m0=', '201901291000002');
-- --------------------------------------------------------
--
-- Table structure for table `tags`
--
CREATE TABLE `tags` (
`tag_id` int(11) NOT NULL,
`tag_name` varchar(150) DEFAULT NULL,
`status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 - Active, 0 - Inactive, 2 - Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tags`
--
INSERT INTO `tags` (`tag_id`, `tag_name`, `status`) VALUES
(11, 'Fresh on Time Out', 1),
(12, 'This Weekend', 1),
(13, 'Time Out Original ', 1),
(14, 'Games', 1),
(15, 'Dining', 1),
(16, 'Film Night', 1),
(17, 'Family First', 1),
(18, 'Night Out ', 1);
-- --------------------------------------------------------
--
-- Table structure for table `transaction`
--
CREATE TABLE `transaction` (
`id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`booking_id` varchar(150) NOT NULL,
`datetime` datetime DEFAULT NULL,
`transaction_id` varchar(45) DEFAULT NULL,
`transaction_response` longtext,
`amount` double DEFAULT NULL,
`status` int(11) DEFAULT '2' COMMENT '1 - Completed, 0 - Failed, 2 - Processing '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `transaction`
--
INSERT INTO `transaction` (`id`, `customer_id`, `booking_id`, `datetime`, `transaction_id`, `transaction_response`, `amount`, `status`) VALUES
(1, 3, 'TO1903267519', '2019-03-26 12:44:01', '2026122768502412', '{\"text\":\"201901291000002||1111010||111111|1553604241|SAR|557.1|CC|MASTERCARD|01||1110000|2026122768502412|26-Mar-2019 03:44:24 PM|NOT ENROLLED||111|FAILURE|20021|Server Timeout.||1110000000|1|17|TO1903267519||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553604241|SAR|557.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1110000|2026122768502412|26-Mar-2019 03:44:24 PM|NOT ENROLLED\",\"Transaction_Status_information\":\"111|FAILURE|20021|Server Timeout.\",\"Merchant_Information\":\"1110000000|1|17|TO1903267519\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 555, 0),
(2, 3, 'TO1903263754', '2019-03-26 12:51:38', '2028555386361162', '{\"text\":\"201901291000002||1111010||111111|1553604698|SAR|557.1|CC|MASTERCARD|01||1110000|2028555386361162|26-Mar-2019 03:52:14 PM|NOT ENROLLED||111|FAILURE|20021|Server Timeout.||1110000000|2|17|TO1903263754||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553604698|SAR|557.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1110000|2028555386361162|26-Mar-2019 03:52:14 PM|NOT ENROLLED\",\"Transaction_Status_information\":\"111|FAILURE|20021|Server Timeout.\",\"Merchant_Information\":\"1110000000|2|17|TO1903263754\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 555, 0),
(3, 3, 'TO1903264404', '2019-03-26 01:22:25', '2022525406023444', '{\"text\":\"201901291000002||1111010||111111|1553606545|SAR|557.1|CC|MASTERCARD|01||1111101|2022525406023444|26-Mar-2019 04:22:45 PM|ENROLLED|Fully Secure|525406023444020001|015649||111|SUCCESS|00000|No Error.||1110000000|3|17|TO1903264404||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553606545|SAR|557.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2022525406023444|26-Mar-2019 04:22:45 PM|ENROLLED|Fully Secure|525406023444020001|015649\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|3|17|TO1903264404\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 555, 1),
(4, 3, 'TO1903275812', '2019-03-27 11:07:43', NULL, NULL, 555, 2),
(5, 3, 'TO1903274660', '2019-03-27 12:52:17', '2021102405129309', '{\"text\":\"201901291000002||1111010||111111|1553691137|SAR|51.1|CC|MASTERCARD|01||1111101|2021102405129309|27-Mar-2019 03:52:47 PM|ENROLLED|Fully Secure|102405129309020001|023806||111|SUCCESS|00000|No Error.||1110000000|5|34|TO1903274660||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691137|SAR|51.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2021102405129309|27-Mar-2019 03:52:47 PM|ENROLLED|Fully Secure|102405129309020001|023806\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|5|34|TO1903274660\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 49, 1),
(6, 3, 'TO1903273159', '2019-03-27 12:55:56', '2029379106077929', '{\"text\":\"201901291000002||1111010||111111|1553691356|SAR|51.1|CC|MASTERCARD|01||1111101|2029379106077929|27-Mar-2019 03:57:06 PM|ENROLLED|Fully Secure|379106077929020001|023813||111|SUCCESS|00000|No Error.||1110000000|6|34|TO1903273159||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691356|SAR|51.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2029379106077929|27-Mar-2019 03:57:06 PM|ENROLLED|Fully Secure|379106077929020001|023813\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|6|34|TO1903273159\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 49, 1),
(7, 3, 'TO1903271343', '2019-03-27 12:56:42', NULL, NULL, 555, 2),
(8, 3, 'TO1903276659', '2019-03-27 12:57:07', '2021132292826039', '{\"text\":\"201901291000002||1111010||111111|1553691427|SAR|557.1|CC|MASTERCARD|01||1111101|2021132292826039|27-Mar-2019 03:57:14 PM|ENROLLED|Fully Secure|132292826039020001|016055||111|SUCCESS|00000|No Error.||1110000000|8|17|TO1903276659||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691427|SAR|557.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2021132292826039|27-Mar-2019 03:57:14 PM|ENROLLED|Fully Secure|132292826039020001|016055\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|8|17|TO1903276659\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 555, 1),
(9, 3, 'TO1903277067', '2019-03-27 01:02:05', '2028214714971169', '{\"text\":\"201901291000002||1111010||111111|1553691725|SAR|2002.1|CC|VISA|01||1111000|2028214714971169|27-Mar-2019 04:02:20 PM|ENROLLED|Fully Secure||111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.||1110000000|9|41|TO1903277067||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691725|SAR|2002.1|CC|VISA|01\",\"Transaction_related_information\":\"1111000|2028214714971169|27-Mar-2019 04:02:20 PM|ENROLLED|Fully Secure\",\"Transaction_Status_information\":\"111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.\",\"Merchant_Information\":\"1110000000|9|41|TO1903277067\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 2000, 0),
(10, 3, 'TO1903272547', '2019-03-27 01:03:03', '2024470797095669', '{\"text\":\"201901291000002||1111010||111111|1553691783|SAR|1002.1|CC|MASTERCARD|01||1111101|2024470797095669|27-Mar-2019 04:03:14 PM|ENROLLED|Fully Secure|470797095669020001|016091||111|SUCCESS|00000|No Error.||1110000000|10|41|TO1903272547||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691783|SAR|1002.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2024470797095669|27-Mar-2019 04:03:14 PM|ENROLLED|Fully Secure|470797095669020001|016091\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|10|41|TO1903272547\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 1000, 1),
(11, 3, 'TO1903279794', '2019-03-27 01:04:21', '2029255894650579', '{\"text\":\"201901291000002||1111010||111111|1553691861|SAR|51.1|CC|MASTERCARD|01||1111000|2029255894650579|27-Mar-2019 04:04:38 PM|ENROLLED|Fully Secure||111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.||1110000000|11|34|TO1903279794||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691861|SAR|51.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111000|2029255894650579|27-Mar-2019 04:04:38 PM|ENROLLED|Fully Secure\",\"Transaction_Status_information\":\"111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.\",\"Merchant_Information\":\"1110000000|11|34|TO1903279794\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 49, 0),
(12, 3, 'TO1903275984', '2019-03-27 01:05:10', '2025692740838879', '{\"text\":\"201901291000002||1111010||111111|1553691910|SAR|51.1|CC|MASTERCARD|01||1111000|2025692740838879|27-Mar-2019 04:05:16 PM|ENROLLED|Fully Secure||111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.||1110000000|12|34|TO1903275984||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691910|SAR|51.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111000|2025692740838879|27-Mar-2019 04:05:16 PM|ENROLLED|Fully Secure\",\"Transaction_Status_information\":\"111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.\",\"Merchant_Information\":\"1110000000|12|34|TO1903275984\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 49, 0),
(13, 3, 'TO1903279748', '2019-03-27 01:05:50', '2026856441402489', '{\"text\":\"201901291000002||1111010||111111|1553691950|SAR|51.1|CC|MASTERCARD|01||1111101|2026856441402489|27-Mar-2019 04:06:10 PM|ENROLLED|Fully Secure|856441402489020001|007538||111|SUCCESS|00000|No Error.||1110000000|13|34|TO1903279748||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553691950|SAR|51.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2026856441402489|27-Mar-2019 04:06:10 PM|ENROLLED|Fully Secure|856441402489020001|007538\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|13|34|TO1903279748\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 49, 1),
(14, 3, 'TO1903277408', '2019-03-27 01:07:47', '2025394700436599', '{\"text\":\"201901291000002||1111010||111111|1553692067|SAR|1002.1|CC|MASTERCARD|01||1111101|2025394700436599|27-Mar-2019 04:08:04 PM|ENROLLED|Fully Secure|394700436599020001|016069||111|SUCCESS|00000|No Error.||1110000000|14|41|TO1903277408||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553692067|SAR|1002.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2025394700436599|27-Mar-2019 04:08:04 PM|ENROLLED|Fully Secure|394700436599020001|016069\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|14|41|TO1903277408\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 1000, 1),
(15, 3, 'TO1903276264', '2019-03-27 01:09:44', '2026772523499700', '{\"text\":\"201901291000002||1111010||111111|1553692184|SAR|1002.1|CC|MASTERCARD|01||1110000|2026772523499700|27-Mar-2019 04:10:08 PM|ENROLLED||111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.||1110000000|15|41|TO1903276264||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553692184|SAR|1002.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1110000|2026772523499700|27-Mar-2019 04:10:08 PM|ENROLLED\",\"Transaction_Status_information\":\"111|FAILURE|20002|General decline of the card. No other information was provided by the issuing bank.\",\"Merchant_Information\":\"1110000000|15|41|TO1903276264\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 1000, 0),
(16, 3, 'TO1903282880', '2019-03-28 05:11:36', '2020966540569977', '{\"text\":\"201901291000002||1111010||111111|1553749896|SAR|1002.1|CC|MASTERCARD|01||1111101|2020966540569977|28-Mar-2019 08:12:12 AM|ENROLLED|Fully Secure|966540569977020001|024107||111|SUCCESS|00000|No Error.||1110000000|16|41|TO1903282880||10000|NO\",\"merchantId\":\"201901291000002\",\"DataBlockBitmap\":\"1111010\",\"Transaction_Response\":\"111111|1553749896|SAR|1002.1|CC|MASTERCARD|01\",\"Transaction_related_information\":\"1111101|2020966540569977|28-Mar-2019 08:12:12 AM|ENROLLED|Fully Secure|966540569977020001|024107\",\"Transaction_Status_information\":\"111|SUCCESS|00000|No Error.\",\"Merchant_Information\":\"1110000000|16|41|TO1903282880\",\"Fraud_Block\":\"NULL\",\"DCC_Block\":\"10000|NO\",\"Additional\":\"NULL\"}', 1000, 1);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`username` varchar(50) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`display_name` varchar(100) DEFAULT NULL,
`profile_image` varchar(250) DEFAULT NULL,
`notification_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0=>On,1=>Off',
`email_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0=>On,1=>Off',
`user_type` tinyint(3) DEFAULT '3' COMMENT '1 - SuperAdmin 2 - Provider 3 - Customer ',
`status` int(11) DEFAULT '1' COMMENT '0- Inactive 1-Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `display_name`, `profile_image`, `notification_status`, `email_status`, `user_type`, `status`) VALUES
(1, 'admin', '202cb962ac59075b964b07152d234b70', 'Super Admin 2', 'assets/uploads/services/1553760674_giphy.gif', 0, 0, 1, 1),
(2, 'provider', '202cb962ac59075b964b07152d234b70', 'Provide1', 'assets/uploads/services/1553762212_media-froala-description-0-2018-9-5-t-14-14-32.jpeg', 0, 0, 2, 1),
(3, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 'assets/uploads/services/1552060103_Screenshot_2019-03-08_at_9.18.08_PM.png', 0, 0, 3, 1),
(10, 'xdcfg', '69879a49afe2a510237c11d0aa05a3fc', 'cdfgh', 'assets/uploads/services/1550152192_image_(1).png', 0, 0, 2, 1),
(11, 'sedrftg', '38d7355701b6f3760ee49852904319c1', 'dfrgdr', 'assets/uploads/services/1550152924_giphy.gif', 0, 0, 2, 1),
(12, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 0, 0, 3, 1),
(13, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 0, 0, 3, 1),
(14, NULL, NULL, NULL, 'assets/uploads/services/1550658267_234858854male.jpg', 0, 0, 3, 1),
(15, 'tobin.tecffhware@gmail.com', NULL, 'tdgh', 'assets/uploads/services/1550658421_car1.jpg', 0, 0, 3, 1),
(16, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(17, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(18, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(19, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(20, NULL, '52ae655aa0e359979fdb68d9b3baa2dc', 'Customer', NULL, 0, 0, 3, 1),
(21, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(22, 'adminr', '202cb962ac59075b964b07152d234b70', 'ergt', 'assets/uploads/services/1553453170_OCB-Football-Seating-Map-FINAL.jpg', 0, 0, 2, 1),
(23, 'adminf', '202cb962ac59075b964b07152d234b70', 'dfg', 'assets/uploads/services/1553453196_OCB-Football-Seating-Map-FINAL.jpg', 0, 0, 2, 1),
(24, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(25, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 0, 0, 3, 1),
(26, 'anu123456', 'e10adc3949ba59abbe56e057f20f883e', 'anu', NULL, 0, 0, 3, 1),
(27, 'anu@gmail.com', 'aacf0056edbb958e0e9fd73a5d38575b', 'anu', NULL, 0, 0, 3, 0),
(28, NULL, 'aabc0dd9d941dbd8ccdb3418bf07c8b3', 'Customer', NULL, 0, 0, 3, 1),
(29, NULL, 'aabc0dd9d941dbd8ccdb3418bf07c8b3', 'Customer', NULL, 0, 0, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `venue`
--
CREATE TABLE `venue` (
`id` int(11) NOT NULL,
`venue_name` varchar(100) DEFAULT NULL,
`venue_details` longtext,
`region_id` int(11) DEFAULT NULL,
`locality_id` int(11) DEFAULT NULL,
`host_cat_id` int(11) DEFAULT NULL,
`location` varchar(100) DEFAULT NULL,
`location_lat` varchar(45) DEFAULT NULL,
`location_lng` varchar(45) DEFAULT NULL,
`layout` varchar(100) DEFAULT NULL COMMENT 'Layout Image',
`layout_details` longtext COMMENT 'Layout Details (JSON data)',
`status` int(11) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `venue`
--
INSERT INTO `venue` (`id`, `venue_name`, `venue_details`, `region_id`, `locality_id`, `host_cat_id`, `location`, `location_lat`, `location_lng`, `layout`, `layout_details`, `status`) VALUES
(15, 'The Blooms ', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 7, 7, 10, 'Abhanpur, Chhattisgarh, India', '21.0541622', '81.7513551', '', '', 1),
(16, 'Hotel Mubeena', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 14, 8, 10, 'Qatif, Saudi Arabia', '26.5764917', '49.998236', '', '', 1),
(17, 'LULU PVR Movies', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 14, 9, 11, 'Edapally, Kochi, Kerala, India', '10.0236761', '76.3116235', '', '', 2),
(18, 'PVR Cinemas', 'PVR Cinemas', 10, 10, 11, 'Dammam, Saudi Arabia', '26.4206828', '50.0887943', 'assets/uploads/services/1552054270_media-froala-description-0-2018-9-5-t-14-14-32.jpeg', '[{\"color\":\"Yellow\",\"price\":\"100\",\"capacity\":\"122\",\"weekend_price\":\"100\"},{\"color\":\"Green\",\"price\":\"200\",\"capacity\":\"100\",\"weekend_price\":\"200\"}]', 1),
(19, 'King kilafat', 'qweatrsytuyuilo', 9, 11, 10, 'Al Bahah, Saudi Arabia', '20.0217407', '41.4712733', '', '', 2),
(20, 'The Cinema Build', 'Apex Atrium Motor City - Dubai', 7, 12, 11, 'Apex Atrium Motor City - Dubai', '25.0460738', '55.2355018', 'assets/uploads/services/1552069245_tyui.png', '[{\"color\":\"Red\",\"price\":\"100\",\"capacity\":\"120\",\"weekend_price\":\"100\"},{\"color\":\"Brown\",\"price\":\"200\",\"capacity\":\"50\",\"weekend_price\":\"200\"}]', 1),
(21, 'KAFD', 'KAFD', 7, 13, 13, 'KAFD, King Fahd Rd, Riyadh Saudi Arabia', '24.761956', '46.6404337', '', '', 1),
(22, 'Radisson Blu Plaza Hotel', 'Located on King Abdullah Road in one of the city\'s most vibrant districts, the Radisson Blu Plaza Hotel, Jeddah lies close to many businesses and 2 popular shopping malls, Al Andalus and Al Salam. Guests can choose from a variety of room types, including spacious suites and apartments. The on-site restaurant at this Jeddah hotel serves fresh, flavorful cuisine all day, and the Lounge provides a tempting selection of hot and cold drinks. Relax by the swimming pool or keep up with an exercise routine at the gym.', 7, 14, 13, 'KAFD, King Fahd Rd, Riyadh Saudi Arabia', '24.761956', '46.6404337', '', '', 1),
(23, 'Saudi Safari (Desert Camp)', 'Inexperienced drivers heading into Dubai’s desert without a guide (not recommended) will probably miss out on activities such as camel rides and dune bashes. Get the very best of the desert all rolled into one on this single, afternoon-and-evening experience. After a dune bash, try sandboarding, camel riding, and more before dinner and live entertainment at a Bedouin-inspired camp. Round-trip transport is included for maximum comfort and convenience.', 7, 15, 15, 'Desert Gate Tourism L.L.C.', '25.0971801', '55.1805412', '', '', 1),
(24, 'Aromi', 'Indulge in panoramic Red Sea vistas as you experience a contemporary Italian menu with a Rome twist at Aromi restaurant. Watch sunsets over dinner in this elegant restaurant tastefully furnished in fresh modern décor. Treat yourself to a leisurely lunch with friends and family as you sample traditional Italian favorites with a Venetian flavor in this Qasr Al Sharq restaurant.', 7, 16, 10, 'North Corniche Road | in Qasr Al Sharq Hotel, Jeddah 21462, Saudi Arabia +966 9200 09565', '21.6033435', '39.1092294', '', '', 1),
(25, 'Dhahran Movie Theatre', 'Dhahran (Arabic ??????? a?-?ahr?n) is a city located in Eastern Province, Saudi Arabia. It is a major administrative center for the Saudi oil industry. Together with the nearby cities of Dammam and Khobar, Dhahran forms part of the Dammam Metropolitan Area, which is commonly known as greater Dammam and has an estimated population of 4,140,000 as of 2012.\r\n\r\nLarge oil reserves were first identified in the Dhahran area in 1931, and in 1935, Standard Oil drilled the first commercially viable oil well. Standard Oil later established a subsidiary in Saudi Arabia called the Arabian American Oil Company (ARAMCO), now fully owned by the Saudi government and known as Saudi Aramco. Dhahran has been the home of Saudi Aramco\'s headquarters for 80 years and is its first and largest gated compound with more than 50,000 residents. Employees and dependents of Aramco, known as Aramcons, have a tendency to use Dhahran to solely refer to the Aramco camp while using Khobar and/or Dammam to refer to the area outside the camp. The Saudi Aramco Residential Camp makes up much of the city of Dhahran today. Home to Mall of Dhahran one of the biggest shopping complexes in the Eastern Province.', 7, 17, 11, 'Dhahran Saudi Arabia', '26.2361248', '50.0393017', 'assets/uploads/services/1553682852_sendbinary.jpg', '[{\"color\":\"King\",\"price\":\"100\",\"capacity\":\"50\",\"weekend_price\":\"100\"},{\"color\":\"Queen\",\"price\":\"60\",\"capacity\":\"50\",\"weekend_price\":\"60\"}]', 1),
(26, 'Legoland Dubai', 'Legoland Dubai Resort (stylized as LEGOLAND Dubai) is a family theme park in Dubai. It opened on October 31, 2016. It is the first Legoland park in the Middle East and was the seventh worldwide. The park was originally scheduled to open in 2011 in Dubailand as Legoland Dubailand, but was then delayed until October 2016 and is now located at Dubai Parks and Resorts as Legoland Dubai.\r\n\r\nThe park is designed for families with children from ages two to 12 years old. The park also provides a variety of rides and activities. Like many other Legoland theme parks, Dubai\'s includes a Miniland where over 20 million Lego bricks are used to create 15,000 miniature models of different landmarks and structures around the world.', 7, 18, 16, 'Opposite Palm - Sheikh Zayed Rd - Dubai - United Arab Emirates', '24.920333', '55.0045443', '', '', 1),
(27, 'Mirdif City Center', 'City Centre Mirdif is a shopping mall in the residential area of Mirdif, in Dubai, United Arab Emirates. It opened on March 26, 2010, and is developed and managed by Majid Al Futtaim Properties. City Centre Mirdif has a gross leasable area of 196,000 m2 and houses 465 retail stores.', 7, 19, 17, 'South Entrance 1st Flr Sheikh Mohammed Bin Zayed Rd | Mirdif City Center, Dubai, United Arab Emirate', '25.2166296', '55.4077949', '', '', 1),
(28, 'Downtown Dubai', 'See Dubai light up at night on this private 3-hour walking tour of the city with a flexible departure time between 5:30 and 9 p.m. Curate your tour to include a mix of the city’s top attractions and popular nightlife while learning about the area from your private guide.', 7, 20, 18, 'Dubai Opera, Downtown Dubai, Dubai', '25.195617', '55.271879', '', '', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
ADD PRIMARY KEY (`id`) USING BTREE;
--
-- Indexes for table `checker`
--
ALTER TABLE `checker`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `commission_payment`
--
ALTER TABLE `commission_payment`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `customer_auth`
--
ALTER TABLE `customer_auth`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `events`
--
ALTER TABLE `events`
ADD PRIMARY KEY (`event_id`);
--
-- Indexes for table `event_category`
--
ALTER TABLE `event_category`
ADD PRIMARY KEY (`cat_id`);
--
-- Indexes for table `event_date_time`
--
ALTER TABLE `event_date_time`
ADD PRIMARY KEY (`id`),
ADD KEY `event_id` (`event_id`,`date`);
--
-- Indexes for table `event_gallery`
--
ALTER TABLE `event_gallery`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD KEY `event_id` (`event_id`,`media_type`);
--
-- Indexes for table `event_tags`
--
ALTER TABLE `event_tags`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `favourite`
--
ALTER TABLE `favourite`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `host_categories`
--
ALTER TABLE `host_categories`
ADD PRIMARY KEY (`host_cat_id`);
--
-- Indexes for table `locality`
--
ALTER TABLE `locality`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `privacy_policy`
--
ALTER TABLE `privacy_policy`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider`
--
ALTER TABLE `provider`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `region`
--
ALTER TABLE `region`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `reservation`
--
ALTER TABLE `reservation`
ADD PRIMARY KEY (`id`,`restaurant_id`,`customer_id`),
ADD KEY `fk_reservation_restaurant1_idx` (`restaurant_id`),
ADD KEY `fk_reservation_customer1_idx` (`customer_id`);
--
-- Indexes for table `review`
--
ALTER TABLE `review`
ADD PRIMARY KEY (`id`,`event_id`,`customer_id`),
ADD KEY `fk_review_event1_idx` (`event_id`),
ADD KEY `fk_review_customer1_idx` (`customer_id`);
--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
ADD PRIMARY KEY (`tag_id`);
--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
ADD PRIMARY KEY (`id`,`customer_id`,`booking_id`),
ADD KEY `fk_transaction_customer1_idx` (`customer_id`),
ADD KEY `fk_transaction_booking1_idx` (`booking_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `venue`
--
ALTER TABLE `venue`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `checker`
--
ALTER TABLE `checker`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `commission_payment`
--
ALTER TABLE `commission_payment`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `customer_auth`
--
ALTER TABLE `customer_auth`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
--
-- AUTO_INCREMENT for table `event_category`
--
ALTER TABLE `event_category`
MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `event_date_time`
--
ALTER TABLE `event_date_time`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4960;
--
-- AUTO_INCREMENT for table `event_gallery`
--
ALTER TABLE `event_gallery`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
--
-- AUTO_INCREMENT for table `event_tags`
--
ALTER TABLE `event_tags`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=443;
--
-- AUTO_INCREMENT for table `favourite`
--
ALTER TABLE `favourite`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `host_categories`
--
ALTER TABLE `host_categories`
MODIFY `host_cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `locality`
--
ALTER TABLE `locality`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `privacy_policy`
--
ALTER TABLE `privacy_policy`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `provider`
--
ALTER TABLE `provider`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `region`
--
ALTER TABLE `region`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `reservation`
--
ALTER TABLE `reservation`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `venue`
--
ALTER TABLE `venue`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
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 */;