-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Mar 24, 2019 at 07:25 PM
-- Server version: 5.7.21
-- PHP Version: 5.6.35

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

DROP TABLE IF EXISTS `booking`;
CREATE TABLE IF NOT EXISTS `booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `status` int(11) DEFAULT '1' COMMENT '0 - Cancelled, 1 - Booked, 2 - Completed, 3 - Pending, 4 - Deleted',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 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`, `status`) VALUES
(1, 17, 3, 'TO1903085247', 196, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 1110, 3, NULL, 1),
(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, NULL, 1),
(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, NULL, 1),
(4, 17, 3, 'TO1903085474', 999, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 1110, 3, NULL, 1),
(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, NULL, 1),
(6, 17, 3, 'TO1903082181', 999, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '\"\"', 555, 3, NULL, 1),
(7, 17, 3, 'TO1903081950', 1002, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 1, '\"\"', 555, 3, NULL, 1),
(8, 23, 3, 'TO1903082372', 4214, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 4, '\"\"', 400, 3, NULL, 1),
(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, NULL, 1),
(10, 23, 20, 'TO1903081123', 4214, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 4, '\"\"', 400, 3, NULL, 1),
(11, 25, 21, 'TO1903085371', 4469, 'https://www.barcodefaq.com/wp-content/uploads/2018/08/gs1-qrcode-fnc1.png', 2, '\"\"', 22, 3, NULL, 1),
(12, 33, 3, 'TO1903216180', 4469, 'assets/uploads/qrcode/bookCode_1553142599.png', 5, '[{\"color\":\"Red\",\"price\":\"11\",\"no_ticket\":\"2\",\"total_price\":\"22\"}]', 250, 3, NULL, 1);

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

--
-- Table structure for table `commission_payment`
--

DROP TABLE IF EXISTS `commission_payment`;
CREATE TABLE IF NOT EXISTS `commission_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provider_id` int(11) DEFAULT NULL,
  `last_payment_date` varchar(150) DEFAULT NULL,
  `total_booking` double DEFAULT NULL,
  `tickets_sold` int(11) DEFAULT NULL,
  `last_payed` double DEFAULT NULL,
  `total_payed` double DEFAULT NULL,
  `status` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
CREATE TABLE IF NOT EXISTS `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 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);

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

--
-- Table structure for table `customer_auth`
--

DROP TABLE IF EXISTS `customer_auth`;
CREATE TABLE IF NOT EXISTS `customer_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `auth_token` varchar(255) NOT NULL,
  `sync_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 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');

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

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
CREATE TABLE IF NOT EXISTS `events` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 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, 1, '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 &quot;de Finibus Bonorum et Malorum&quot; (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, &quot;Lorem ipsum dolor sit amet..&quot;, 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, 1, '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 &quot;de Finibus Bonorum et Malorum&quot; (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, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.</p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 2),
(19, 18, 5, 1, 'PVR Movie Show', '<p><strong>PVR Cinemas</strong></p>\r\n', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(20, 18, 5, 1, 'PVR Movie House ', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n	<li>&nbsp;is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Lorem Ipsum has been the industry&#39;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),
(21, 16, 6, 1, 'Hotel Mubeena', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n	<li>&nbsp;is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Lorem Ipsum has been the industry&#39;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, '', 1),
(22, 18, 5, 1, 'iMax 3D Movie Show', '<p><strong>Lorem Ipsum</strong></p>\r\n\r\n<ul>\r\n	<li>&nbsp;is simply dummy text of the printing and typesetting industry.</li>\r\n	<li>Lorem Ipsum has been the industry&#39;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, 1, '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&#39;s Best St. Patrick&#39;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&#39;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&rsquo;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&#39;s best St. Patrick&#39;s Bar Crawl, so break out your green gear and get ready to enjoy awesome beer &amp; shot specials at 10 of NYC&#39;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&nbsp;</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, 1, '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>&nbsp;</p>\r\n', 14, '{\"price\":\"011\",\"price_details\":\"Free Entrance\"}', 1, 0, '', 1),
(26, 21, 3, 1, 'KAFD Test', '<p>Test</p>\r\n', 14, '{\"price\":\"100\",\"price_details\":\"Test\"}', 1, 0, '', 1),
(27, 20, 3, 1, 'PVR Movie Show', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(28, 21, 6, 1, 'PVR Movie Show', '<p>erferf</p>\r\n', 14, '{\"price\":\"555\",\"price_details\":\"ert\"}', 1, 0, '', 1),
(29, 18, 6, 1, 'df', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(30, 21, 6, 1, 'sdf', '', 14, '{\"price\":\"45\",\"price_details\":\"fdgvdxf\"}', 1, 0, '', 1),
(31, 18, 5, 1, 'sdrefg', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(32, 18, 4, 1, 'lkjio', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1),
(33, 18, 13, 1, 'l[pok', '', 14, '{\"price\":null,\"price_details\":null}', 1, 0, '', 1);

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

--
-- Table structure for table `event_category`
--

DROP TABLE IF EXISTS `event_category`;
CREATE TABLE IF NOT EXISTS `event_category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(250) DEFAULT NULL,
  `category_description` longtext,
  `category_image` varchar(250) DEFAULT NULL,
  `status` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 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/1552049223_m1.png', 1),
(4, 'This Weekend ', 'Test Description For Add Category Page.', 'assets/uploads/services/1552049246_m2.png', 1),
(5, 'Time Out Original ', 'Test Description For Add Category Page.', 'assets/uploads/services/1552049271_m3.png', 1),
(6, 'Dining', 'Test Description For Add Category Page.', 'assets/uploads/services/1552049291_m4.png', 1),
(7, 'Film Night ', 'Test Description For Add Category Page.', 'assets/uploads/services/1552049320_m5.png', 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`
--

DROP TABLE IF EXISTS `event_date_time`;
CREATE TABLE IF NOT EXISTS `event_date_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `date` varchar(150) DEFAULT NULL,
  `time` varchar(150) DEFAULT NULL,
  `status` tinyint(3) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=4662 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),
(1981, 21, '2019-03-08', '14:00', 1),
(1982, 21, '2019-03-09', '14:00', 1),
(1983, 21, '2019-03-10', '14:00', 1),
(1984, 21, '2019-03-11', '14:00', 1),
(1985, 21, '2019-03-12', '14:00', 1),
(1986, 21, '2019-03-13', '14:00', 1),
(1987, 21, '2019-03-14', '14:00', 1),
(1988, 21, '2019-03-15', '14:00', 1),
(1989, 21, '2019-03-16', '14:00', 1),
(1990, 21, '2019-03-17', '14:00', 1),
(1991, 21, '2019-03-18', '14:00', 1),
(1992, 21, '2019-03-19', '14:00', 1),
(1993, 21, '2019-03-20', '14:00', 1),
(1994, 21, '2019-03-21', '14:00', 1),
(1995, 21, '2019-03-22', '14:00', 1),
(1996, 21, '2019-03-23', '14:00', 1),
(1997, 21, '2019-03-24', '14:00', 1),
(1998, 21, '2019-03-25', '14:00', 1),
(1999, 21, '2019-03-26', '14:00', 1),
(2000, 21, '2019-03-27', '14:00', 1),
(2001, 21, '2019-03-28', '14:00', 1),
(2002, 21, '2019-03-29', '14:00', 1),
(2003, 21, '2019-03-30', '14:00', 1),
(2004, 21, '2019-03-31', '14:00', 1),
(2005, 21, '2019-04-01', '14:00', 1),
(2006, 21, '2019-04-02', '14:00', 1),
(2007, 21, '2019-04-03', '14:00', 1),
(2008, 21, '2019-04-04', '14:00', 1),
(2009, 21, '2019-04-05', '14:00', 1),
(2010, 21, '2019-04-06', '14:00', 1),
(2011, 21, '2019-04-07', '14:00', 1),
(2012, 21, '2019-04-08', '14:00', 1),
(2013, 21, '2019-04-09', '14:00', 1),
(2014, 21, '2019-04-10', '14:00', 1),
(2015, 21, '2019-04-11', '14:00', 1),
(2016, 21, '2019-04-12', '14:00', 1),
(2017, 21, '2019-04-13', '14:00', 1),
(2018, 21, '2019-04-14', '14:00', 1),
(2019, 21, '2019-04-15', '14:00', 1),
(2020, 21, '2019-04-16', '14:00', 1),
(2021, 21, '2019-04-17', '14:00', 1),
(2022, 21, '2019-04-18', '14:00', 1),
(2023, 21, '2019-04-19', '14:00', 1),
(2024, 21, '2019-04-20', '14:00', 1),
(2025, 21, '2019-04-21', '14:00', 1),
(2026, 21, '2019-04-22', '14:00', 1),
(2027, 21, '2019-04-23', '14:00', 1),
(2028, 21, '2019-04-24', '14:00', 1),
(2029, 21, '2019-04-25', '14:00', 1),
(2030, 21, '2019-04-26', '14:00', 1),
(2031, 21, '2019-04-27', '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),
(4468, 25, '2019-03-21', '01:15', 1),
(4469, 25, '2019-03-21', '03:15', 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);

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

--
-- Table structure for table `event_gallery`
--

DROP TABLE IF EXISTS `event_gallery`;
CREATE TABLE IF NOT EXISTS `event_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `event_id` (`event_id`,`media_type`)
) ENGINE=InnoDB AUTO_INCREMENT=107 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);

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

--
-- Table structure for table `event_tags`
--

DROP TABLE IF EXISTS `event_tags`;
CREATE TABLE IF NOT EXISTS `event_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=374 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),
(233, 21, 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),
(282, 25, 11, 1),
(283, 25, 12, 1),
(284, 25, 17, 1),
(285, 25, 13, 1),
(286, 25, 15, 1),
(287, 25, 14, 1),
(288, 25, 18, 1),
(289, 25, 16, 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);

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

--
-- Table structure for table `favourite`
--

DROP TABLE IF EXISTS `favourite`;
CREATE TABLE IF NOT EXISTS `favourite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `host_categories`
--

DROP TABLE IF EXISTS `host_categories`;
CREATE TABLE IF NOT EXISTS `host_categories` (
  `host_cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`host_cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 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);

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

--
-- Table structure for table `locality`
--

DROP TABLE IF EXISTS `locality`;
CREATE TABLE IF NOT EXISTS `locality` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `venue_id` int(11) NOT NULL,
  `region_id` int(11) DEFAULT NULL,
  `locality` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 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);

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

--
-- Table structure for table `privacy_policy`
--

DROP TABLE IF EXISTS `privacy_policy`;
CREATE TABLE IF NOT EXISTS `privacy_policy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `faq_en` longtext,
  `faq_ar` longtext,
  `privacy_policy_en` longtext,
  `privacy_policy_ar` longtext,
  `terms_and_conditions_en` longtext,
  `terms_and_conditions_ar` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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`) VALUES
(1, '<p>en 1</p>\r\n', '<p>ar 1</p>\r\n', '<p>en 2</p>\r\n', '<p>ar 2</p>\r\n', '<p>en 3</p>\r\n', '<p>ar 3</p>\r\n');

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

--
-- Table structure for table `provider`
--

DROP TABLE IF EXISTS `provider`;
CREATE TABLE IF NOT EXISTS `provider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `provider`
--

INSERT INTO `provider` (`id`, `provider_id`, `name`, `email`, `phone`, `profile_image`) VALUES
(1, 22, 'rgt', 'tobin.ertger@gmail.com', '4829236233', 'assets/uploads/services/1553453170_OCB-Football-Seating-Map-FINAL.jpg'),
(2, 23, 'rdfg', 'tobzsdgf@gmail.com', '54829236233', 'assets/uploads/services/1553453196_OCB-Football-Seating-Map-FINAL.jpg');

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

--
-- Table structure for table `region`
--

DROP TABLE IF EXISTS `region`;
CREATE TABLE IF NOT EXISTS `region` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `region_icon` varchar(250) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1 - Active, 0 - Inactive, 2 - Deleted',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`id`, `name`, `region_icon`, `status`) VALUES
(7, 'Jeddah', 'assets/uploads/services/1552049063_asset_location1.png', 1),
(8, 'Badr', 'assets/uploads/services/1552049078_asset_location2.png', 1),
(9, 'Al Bahah', 'assets/uploads/services/1552049091_asset_location3.png', 1),
(10, 'Dammam', 'assets/uploads/services/1552049107_asset_location1.png', 1),
(11, 'Duba', 'assets/uploads/services/1552049121_asset_location2.png', 1),
(12, 'Jalajil', 'assets/uploads/services/1552049133_asset_location3.png', 1),
(13, 'Najran', 'assets/uploads/services/1552049147_asset_location3.png', 1),
(14, 'Qatif', 'assets/uploads/services/1552049160_asset_location2.png', 1),
(15, 'Riyadh', 'assets/uploads/services/1552075619_RiyadhIcon.png', 1),
(16, 'Riyadh', 'assets/uploads/services/1552075638_RiyadhIcon.png', 1);

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

--
-- Table structure for table `reservation`
--

DROP TABLE IF EXISTS `reservation`;
CREATE TABLE IF NOT EXISTS `reservation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`,`restaurant_id`,`customer_id`),
  KEY `fk_reservation_restaurant1_idx` (`restaurant_id`),
  KEY `fk_reservation_customer1_idx` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `review`
--

DROP TABLE IF EXISTS `review`;
CREATE TABLE IF NOT EXISTS `review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `rate` int(11) DEFAULT NULL COMMENT '1 - 5',
  `feedback` longtext,
  PRIMARY KEY (`id`,`event_id`,`customer_id`),
  KEY `fk_review_event1_idx` (`event_id`),
  KEY `fk_review_customer1_idx` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `setting`
--

DROP TABLE IF EXISTS `setting`;
CREATE TABLE IF NOT EXISTS `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,
  PRIMARY KEY (`id`)
) 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`) VALUES
(1, 'Event - Time Out', 'TimeOut', 'assets/uploads/services/1549257477_Twitch_KingpinSkin_old2_HD.jpg', 'assets/uploads/services/1549257477_sniper.jpg', 'IN', 'INR', 0, 'info@techlabz.in', 'AIzaSyC9JX3BZZfx2S6GQieC_PqjuJdUbZ7_wyM1', 'Golden_1234', 'AIzaSyCcc-YDSJyDpehNE6qfntfWpEQ4uS4aq6A');

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

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE IF NOT EXISTS `tags` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(150) DEFAULT NULL,
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 - Active, 0 - Inactive, 2 - Deleted',
  PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 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`
--

DROP TABLE IF EXISTS `transaction`;
CREATE TABLE IF NOT EXISTS `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `booking_id` int(11) 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 ',
  PRIMARY KEY (`id`,`customer_id`,`booking_id`),
  KEY `fk_transaction_customer1_idx` (`customer_id`),
  KEY `fk_transaction_booking1_idx` (`booking_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `display_name` varchar(100) DEFAULT NULL,
  `profile_image` varchar(250) DEFAULT NULL,
  `user_type` tinyint(3) DEFAULT '3' COMMENT '1 - SuperAdmin 2 - Provider 3 - Customer ',
  `status` int(11) DEFAULT '1' COMMENT '0- Inactive 1-Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `display_name`, `profile_image`, `user_type`, `status`) VALUES
(1, 'admin', '202cb962ac59075b964b07152d234b70', 'Super Admin', 'assets/uploads/services/1549281365_car_ac.jpg', 1, 1),
(2, 'provider', '202cb962ac59075b964b07152d234b70', 'Provide', 'assets/uploads/services/1549342442_Audi-r8.jpg', 2, 1),
(3, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, 'assets/uploads/services/1552060103_Screenshot_2019-03-08_at_9.18.08_PM.png', 3, 1),
(10, 'xdcfg', '69879a49afe2a510237c11d0aa05a3fc', 'cdfgh', 'assets/uploads/services/1550152192_image_(1).png', 2, 1),
(11, 'sedrftg', '38d7355701b6f3760ee49852904319c1', 'dfrgdr', 'assets/uploads/services/1550152924_giphy.gif', 2, 1),
(12, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 3, 1),
(13, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 3, 1),
(14, NULL, NULL, NULL, 'assets/uploads/services/1550658267_234858854male.jpg', 3, 1),
(15, 'tobin.tecffhware@gmail.com', NULL, 'tdgh', 'assets/uploads/services/1550658421_car1.jpg', 3, 1),
(16, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 3, 1),
(17, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 3, 1),
(18, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 3, 1),
(19, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 3, 1),
(20, NULL, '52ae655aa0e359979fdb68d9b3baa2dc', 'Customer', NULL, 3, 1),
(21, NULL, '25d55ad283aa400af464c76d713c07ad', 'Customer', NULL, 3, 1),
(22, 'adminr', '202cb962ac59075b964b07152d234b70', 'ergt', 'assets/uploads/services/1553453170_OCB-Football-Seating-Map-FINAL.jpg', 2, 1),
(23, 'adminf', '202cb962ac59075b964b07152d234b70', 'dfg', 'assets/uploads/services/1553453196_OCB-Football-Seating-Map-FINAL.jpg', 2, 1);

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

--
-- Table structure for table `venue`
--

DROP TABLE IF EXISTS `venue`;
CREATE TABLE IF NOT EXISTS `venue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 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, 'Abha, saudi Arabia', '18.2464685', '42.5117238', '', '', 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', 15, 13, 14, 'King Abdullah Financial District ', '43.6482981', '-79.3833793', '', '', 1);
COMMIT;

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