text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 22, 2017 at 09:59 PM
  -- Server version: 10.1.21-MariaDB
  -- PHP Version: 5.6.30
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `deera`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `activations`
  --
  
  CREATE TABLE `activations` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `completed` tinyint(1) NOT NULL DEFAULT '0',
    `completed_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `activations`
  --
  
  INSERT INTO `activations` (`id`, `user_id`, `code`, `completed`, `completed_at`, `created_at`, `updated_at`) VALUES
  (1, 1, 'tPf97iNBjpypHyyhFSHE0TmgdzdcYEIw', 1, '2016-03-13 15:05:12', '2016-03-13 15:05:12', '2016-03-13 15:05:12'),
  (2, 2, '4O7HxmHdDXLLhEL21DoxY8tVs9TLZ4hX', 1, '2016-03-13 15:05:12', '2016-03-13 15:05:12', '2016-03-13 15:05:12'),
  (23, 3, 'chdb2kUrImQgiliEt5MX8tTyvMiGBLBe', 1, NULL, '2016-04-03 07:55:47', '2016-04-03 08:16:07'),
  (25, 6, '57dzZka4R03hD9jDuHuNOVX5VylRkf74', 1, NULL, '2016-04-03 08:16:49', '2016-04-03 08:16:49'),
  (26, 4, 'K89rkP0DWLxLRi3rJKS0XhRRNVX2JIwE', 1, NULL, '2016-04-03 12:41:10', '2016-04-03 12:41:10'),
  (30, 10, 'ksg4G06PGLF3NnfEVW5JJpGfm0fUZLqn', 1, NULL, '2016-04-26 13:53:03', '2016-04-26 13:55:34'),
  (31, 11, 'ZYHjAxNlKVz0e6G8KZTOXctzn9Xb6gSt', 1, NULL, '2016-04-27 12:49:08', '2016-04-27 12:49:08'),
  (32, 12, 'djXW7VAbp6KE8pqLKYjqlmc6rJwmMUTC', 1, NULL, '2016-04-27 12:55:37', '2016-04-27 12:56:07'),
  (33, 13, 'JL7avcoawOAvQ5Mr0V5lCPxSaMP17Mpl', 1, '2016-05-01 13:01:21', '2016-05-01 13:01:21', '2016-05-01 13:01:21'),
  (35, 15, 'InxZVzKaU3ISzvLlpGJGHPMqcn4YCfr8', 1, '2016-05-01 13:04:34', '2016-05-01 13:04:34', '2016-05-01 13:04:34'),
  (37, 16, 'Xo7d8vAk19k83eA2oUO76CTvQ7OtpqQh', 1, '2016-05-01 13:05:12', '2016-05-01 13:05:12', '2016-05-01 13:05:12'),
  (39, 17, 'dBtdr8fpNtuGxJcEbPuNoiBXelOOD0cu', 1, '2016-05-01 13:11:23', '2016-05-01 13:11:23', '2016-05-01 13:11:23'),
  (41, 18, 'gu5JQSd9ly0QPKu9MF2nCScxcO5uwGqw', 1, '2016-05-01 13:12:22', '2016-05-01 13:12:22', '2016-05-01 13:12:22'),
  (43, 19, 'e8s2ZTZWQlJ7m3x86Dg3S8SWQlhmyFXs', 1, '2016-05-01 13:14:07', '2016-05-01 13:14:07', '2016-05-01 13:14:07'),
  (45, 20, 'r4zLDah67AznM1zkVRhob3gNYb8XWwGj', 1, '2016-05-01 13:17:20', '2016-05-01 13:17:20', '2016-05-01 13:17:20'),
  (47, 21, 'jZeoeqMEnecZbMhH0g9EcoMzZI2w12Nx', 1, '2016-05-01 13:22:34', '2016-05-01 13:22:34', '2016-05-01 13:22:34'),
  (48, 22, 'Yd0eGosRjJYuJ9lHy4ctna7MAK39BSKP', 1, '2016-05-01 13:28:23', '2016-05-01 13:28:23', '2016-05-01 13:28:23'),
  (49, 23, 'X7qlgmI7cob0pdXqr2f1o3qFj3zEFjOr', 1, '2016-05-01 13:28:54', '2016-05-01 13:28:54', '2016-05-01 13:28:54'),
  (50, 24, 'U5FhTJHWeqZamLA4qIvinrRY0sL9mPHj', 1, '2016-05-01 13:29:13', '2016-05-01 13:29:13', '2016-05-01 13:29:13'),
  (51, 25, 'uRUR8Q3XvmqnRqvmJm69qFbBhAPdEBCP', 1, '2016-05-01 13:33:39', '2016-05-01 13:33:39', '2016-05-01 13:33:39'),
  (52, 26, 'cN1jWNfLjxDQWz9rLMkYwEtEFYp3LLeW', 1, '2016-05-01 13:35:54', '2016-05-01 13:35:54', '2016-05-01 13:35:54'),
  (53, 27, 'xgwqIvjLxKELsidSPg0uM2sNa3zw4lvw', 1, '2016-05-01 13:46:24', '2016-05-01 13:46:24', '2016-05-01 13:46:24'),
  (54, 28, 'fzq00Yn0KhGlDPWjiv7HMdm4hmVjANkV', 1, '2016-05-01 13:46:55', '2016-05-01 13:46:55', '2016-05-01 13:46:55'),
  (55, 29, 'iYF6ubSG8fyz5NniBLInUg1lF7KHXf60', 1, '2016-05-01 13:48:29', '2016-05-01 13:48:29', '2016-05-01 13:48:29'),
  (56, 30, 'l3PtmrpdwumRMeQRgaHBFF3S4YWRzJw2', 1, '2016-05-01 13:49:41', '2016-05-01 13:49:41', '2016-05-01 13:49:41'),
  (57, 31, 'iXcg1CGDz0xpI79gVLBL7Wzox7a2JTqD', 1, '2016-05-01 13:49:57', '2016-05-01 13:49:57', '2016-05-01 13:49:57'),
  (58, 33, 'DDTR4RWYbZbyofng0arphVdxtLiuCYAX', 1, '2016-05-01 13:50:38', '2016-05-01 13:50:38', '2016-05-01 13:50:38'),
  (59, 34, 'CJyqUWfRqnw8m5IvjnkHH9X184x0f23m', 1, '2016-05-01 13:50:47', '2016-05-01 13:50:47', '2016-05-01 13:50:47'),
  (60, 35, 'U3JoFYSltvlcPjSxoICUDq8539XvrDZr', 1, '2016-05-01 13:53:10', '2016-05-01 13:53:10', '2016-05-01 13:53:10'),
  (61, 36, '8y3UDBBZ9XM1mKNfDqxYnM3yWzzfqToF', 1, '2016-05-01 13:53:16', '2016-05-01 13:53:16', '2016-05-01 13:53:16'),
  (62, 37, '2uwyRggW8K149vkNmv85o4k48XpgiR7N', 1, '2016-05-01 13:53:24', '2016-05-01 13:53:24', '2016-05-01 13:53:25'),
  (63, 38, '8OF6m4azklbXjFj3urnIuQQn6DOLbiBq', 1, '2016-05-01 14:02:28', '2016-05-01 14:02:28', '2016-05-01 14:02:28'),
  (64, 39, 'EZEv82huie3moSmcqqMIax6iln5eJ8BH', 1, '2016-05-01 14:07:24', '2016-05-01 14:07:24', '2016-05-01 14:07:24'),
  (65, 40, 'TvbzBY6gqenH5UEgbWrXEG1Axk2urAIy', 1, '2016-05-01 14:10:48', '2016-05-01 14:10:48', '2016-05-01 14:10:48'),
  (66, 41, 'RtXiCeIVz09ytzStqY023by18zB6BOhb', 1, '2016-05-01 14:14:07', '2016-05-01 14:14:07', '2016-05-01 14:14:07'),
  (67, 43, 'eTA27Hi37t5mWSl3Ka3e3a31NcPe5Rl3', 1, '2016-05-01 14:14:43', '2016-05-01 14:14:43', '2016-05-01 14:14:43'),
  (68, 44, '77WN0Sh66exXZ4E54rPcRYPrr0KpG1OA', 1, '2016-05-01 14:17:26', '2016-05-01 14:17:26', '2016-05-01 14:17:26'),
  (70, 45, 'uTRb0VX8JahSgMvxWUu7fzkWoBH7Lycs', 1, NULL, '2016-05-09 13:23:05', '2016-05-09 13:27:00'),
  (71, 45, 'wrs1fyC19FkKjrpvbgCJtC0ctjiUsxO4', 1, NULL, '2016-05-09 13:23:43', '2016-05-09 13:27:00'),
  (72, 45, 'JiUXEkVNrWDJtlpjNAwQz21gbdIEQwb6', 1, NULL, '2016-05-09 13:24:05', '2016-05-09 13:27:00'),
  (73, 45, 'gWuhzk8QyEB0X8GEYf9NGbR6esvHHMjQ', 1, NULL, '2016-05-09 13:24:10', '2016-05-09 13:27:00'),
  (74, 45, 'Xv1uHKiw6b6Y6X1WBTPf73OQGubT7PU1', 1, NULL, '2016-05-09 13:26:08', '2016-05-09 13:27:00'),
  (75, 45, '0P46UgZnXMMjBfVGbfxuBxyUEEMaN5I2', 1, NULL, '2016-05-09 13:27:00', '2016-05-09 13:27:00'),
  (76, 5, 'x3heK3iakXcXlZF4Xk989NazxUZlB7Qr', 1, NULL, '2016-05-09 13:30:32', '2016-05-10 08:02:59'),
  (80, 5, 'jpnafXF4sQiWF3Yo8G8tG43WilQnoRSs', 1, NULL, '2016-05-10 07:40:20', '2016-05-10 08:02:59'),
  (81, 5, 'PH8aZpg0qdOCl6zepqnCVYJQrSxRMKHH', 1, NULL, '2016-05-10 07:40:56', '2016-05-10 08:02:59'),
  (82, 5, 'POcB9yg27dHcXxpcGRp7pGShvamZ0QC4', 1, NULL, '2016-05-10 07:42:06', '2016-05-10 08:02:59'),
  (83, 5, 'EQQQWRy6cCMj1y5SyZnGq2nO8HqkRCkg', 1, NULL, '2016-05-10 07:42:13', '2016-05-10 08:02:59'),
  (84, 5, 'sRlYuLe6tKqteVqizO1jgyXh7YePOXr3', 1, NULL, '2016-05-10 07:42:43', '2016-05-10 08:02:59'),
  (85, 5, 'uguqiwaqkHArF11sjiNBfJwVYGPnHX0A', 1, NULL, '2016-05-10 07:42:50', '2016-05-10 08:02:59'),
  (86, 5, '4dawz9kr7raOCRSGsF7YdFANR91OvJJS', 1, NULL, '2016-05-10 07:51:52', '2016-05-10 08:02:59'),
  (87, 5, '5sxywo700I4oqTaAd3iKw0E2qEjFryiV', 1, NULL, '2016-05-10 08:02:59', '2016-05-10 08:02:59'),
  (98, 56, 'XfYSBKjmBD7Ec4OFWYowrTsVrl1pfTcx', 1, '2016-05-10 11:17:02', '2016-05-10 11:16:41', '2016-05-10 11:17:02'),
  (99, 57, 'uUm4a9wADTtMtNisGzMgVQZ0V6nLL70h', 1, '2016-05-10 11:21:37', '2016-05-10 11:21:28', '2016-05-10 11:21:37'),
  (100, 58, '6ZjLlnSSJF73I4LLIQLMjYNNqSFyVMJD', 1, '2016-05-10 11:24:31', '2016-05-10 11:24:26', '2016-05-10 11:24:31'),
  (101, 59, 'x9mugFlJyzVLjhBDMKfkGXw1w1a70ZoA', 1, '2016-05-10 11:40:07', '2016-05-10 11:39:27', '2016-05-10 11:40:07'),
  (102, 60, 'ScFgUNVZynEA7BGbAd7WkwDpmjV86P1r', 1, '2016-05-10 12:00:58', '2016-05-10 11:59:33', '2016-05-10 12:00:58'),
  (103, 60, 'bOhFo8rWZ0i15ZKZzC4dDl7J6q6JrTXh', 1, '2016-05-10 12:02:03', '2016-05-10 12:01:42', '2016-05-10 12:02:03'),
  (104, 60, '1EM3JYVSW4vytTf6qKeCbRXUeXAvn6bl', 1, '2016-05-10 12:12:18', '2016-05-10 12:02:48', '2016-05-10 12:12:18'),
  (116, 60, 'eOHrp2koznt9hn7ge6NNU2BgKcvTu4m3', 1, '2016-05-10 12:14:22', '2016-05-10 12:14:10', '2016-05-10 12:14:22'),
  (118, 62, '34pbdVIYpKmxvRTMljIDwKVFwWqLM8mt', 1, '2016-05-10 12:17:35', '2016-05-10 12:17:20', '2016-05-10 12:17:35'),
  (120, 64, 'fyw73k63hp6oYd0vABNFAn0lrvJ35w9M', 1, NULL, '2016-05-24 08:38:45', '2016-05-24 08:44:09'),
  (125, 69, 'TUsfohei0PSGpv7MmPD4WES9BX120Kqq', 1, '2016-05-29 11:37:44', '2016-05-29 11:33:21', '2016-05-29 11:37:44'),
  (128, 72, '6M6iQ2QfDwEMWhPtc0QR4w4Fz1yyf82d', 1, '2016-06-12 12:37:46', '2016-06-12 12:37:46', '2016-06-12 12:37:46'),
  (129, 73, 'U5vlzNBZdYVeLw6gIiE8tkNkeqL8tU3w', 1, '2016-06-12 12:46:27', '2016-06-12 12:46:27', '2016-06-12 12:46:27'),
  (130, 74, 'iHXJ6mn79U2onVb7dmWdle8m2Zgehbnh', 1, '2016-06-12 12:53:44', '2016-06-12 12:53:44', '2016-06-12 12:53:44'),
  (131, 75, 'bc7fvcDm2DoDFfe22sp8VmOSNndjVA2F', 1, '2016-06-13 08:59:23', '2016-06-13 08:59:23', '2016-06-13 08:59:23'),
  (132, 76, 'j71eRD7aCsLqC8WSDEzPZU7em7NQeUld', 1, '2016-07-04 12:40:10', '2016-07-04 12:40:10', '2016-07-04 12:40:10'),
  (133, 77, 'dFq3fmww1UUSd2mpGsqlgb1Psv6VgrXg', 1, '2016-07-04 12:57:23', '2016-07-04 12:57:23', '2016-07-04 12:57:23'),
  (134, 76, '5uYLkdC5YVEsVWlTfvLP2HgKEQm3g3fP', 1, '2016-12-27 12:38:50', '2016-12-27 12:38:50', '2016-12-27 12:38:50'),
  (135, 71, 'dBQWDYKSVBRAQT0wo0VkDKFiud244Paz', 1, NULL, '2017-01-03 10:40:18', '2017-01-03 10:40:18'),
  (136, 70, 'Q6rTcjEEk3q56MtdZVhiYG1FfTN0giBb', 1, NULL, '2017-01-03 10:45:30', '2017-01-03 10:45:30'),
  (137, 68, 'wtcbpSv7h1zA36jrIkOuenJF5mRhxeL0', 1, NULL, '2017-01-03 11:12:01', '2017-01-03 11:12:01'),
  (138, 77, 'WJsOOtOGwC8jDmrrhMkV8M7S1ih2hjEX', 1, '2017-03-22 03:59:04', '2017-03-22 03:59:04', '2017-03-22 03:59:04'),
  (139, 78, '0Uz4S5jyRmRWYukKZsw3Yw5jblsp1cgn', 1, '2017-03-22 21:43:26', '2017-03-22 21:43:26', '2017-03-22 21:43:26'),
  (140, 79, '5Xr87r2OzNQIoiQrMwUOM5MkAsQSk1yi', 1, '2017-03-22 21:54:59', '2017-03-22 21:54:59', '2017-03-22 21:54:59'),
  (141, 80, 'RYxgasRve41DM8s6mhOS3PPCXnRgRTy2', 1, '2017-03-22 21:55:47', '2017-03-22 21:55:47', '2017-03-22 21:55:47'),
  (142, 81, 'SjBZa3jgXtrysKb3gSQbdkxD9wbmxmtW', 1, '2017-03-22 21:58:12', '2017-03-22 21:58:12', '2017-03-22 21:58:12'),
  (143, 82, 'nucioEkxUEoXR6OclmMyOhGgFclU3M5L', 1, '2017-05-20 12:18:06', '2017-05-20 12:18:06', '2017-05-20 12:18:06'),
  (144, 89, 'CFlWDVoLtA3t6IhXwVUs4qqk3yR8Mt29', 1, '2017-05-22 09:22:12', '2017-05-22 09:22:12', '2017-05-22 09:22:12');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `address`
  --
  
  CREATE TABLE `address` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `area_id` int(11) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `type` int(11) DEFAULT NULL,
    `first_name` varchar(255) DEFAULT NULL,
    `last_name` varchar(255) DEFAULT NULL,
    `paci_number` varchar(20) DEFAULT NULL,
    `block` varchar(255) DEFAULT NULL,
    `street` varchar(255) DEFAULT NULL,
    `judda` varchar(255) DEFAULT NULL,
    `avenue` varchar(255) DEFAULT NULL,
    `building` varchar(255) DEFAULT NULL,
    `floor` varchar(255) DEFAULT NULL,
    `apartment_number` varchar(255) DEFAULT NULL,
    `mobile` varchar(20) DEFAULT NULL,
    `phone` varchar(20) DEFAULT NULL,
    `long` varchar(255) DEFAULT NULL,
    `lat` varchar(255) DEFAULT NULL,
    `directions` varchar(255) DEFAULT NULL,
    `default` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `address`
  --
  
  INSERT INTO `address` (`id`, `users_id`, `area_id`, `name`, `type`, `first_name`, `last_name`, `paci_number`, `block`, `street`, `judda`, `avenue`, `building`, `floor`, `apartment_number`, `mobile`, `phone`, `long`, `lat`, `directions`, `default`, `notification`, `created_at`, `updated_at`) VALUES
  (1, 82, 3, 'home address', 1, 'taylor', 'successor', '234', '23', 'sdf', 'sdf', 'sdf', 'sdfg', 'sdfg', 'sfg', '3454353', '345345', '3453463', '345345', 'sdfg', 1, 0, '2017-05-20 15:54:17', '2017-05-20 15:54:17'),
  (2, 0, 3, 'sdfs', 0, 'asdf', 'ksjdf', 'asdf', 'lkjsdf', 'lkjdsf', NULL, 'kjldsf', 'lk', 'lkj', 'lkj', 'sdkfj', 'jksdf', NULL, NULL, '', NULL, NULL, '2017-05-22 10:50:54', '2017-05-22 10:50:54'),
  (3, 0, 3, 'ksdjf', 0, 'admin', 'adin', 'sdklfj', 'kjsdf', 'klsjdf', NULL, 'kjdfs', 'jklsdf', 'lkjsdf', 'lkjkjsdf', '234324', '234234', NULL, NULL, 'kjfsdf', NULL, NULL, '2017-05-22 11:15:58', '2017-05-22 11:15:58'),
  (4, 89, 3, 'saldkf', 0, 'aslkdfj', 'skldfj', 'skdflj', 'slkjdf', 'kljsdf', NULL, 'kjlsdf', 'kljdsf', 'kljsdf', 'lkjsdf', '23443', '234', NULL, NULL, 'slkdfj', NULL, NULL, '2017-05-22 12:22:12', '2017-05-22 12:22:12');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `area`
  --
  
  CREATE TABLE `area` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `governorate_id` int(11) NOT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `area`
  --
  
  INSERT INTO `area` (`id`, `name_en`, `name_ar`, `governorate_id`, `description_en`, `description_ar`, `created_at`, `updated_at`) VALUES
  (3, 'area 1', 'المنظقة 1', 3, 'area 1 description ', 'شرح المنطقة 1', '2017-05-19 13:39:11', '2017-05-19 13:39:11'),
  (4, 'area 2', 'منطقة 2', 4, 'description area 2', 'شرح المنطقة 2', '2017-05-19 13:40:00', '2017-05-19 13:40:00'),
  (5, 'area 3', 'منطقة 3', 4, 'description area 3', 'شرح المنطقة 3', '2017-05-19 13:41:17', '2017-05-19 13:41:17');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `banner`
  --
  
  CREATE TABLE `banner` (
    `id` int(11) NOT NULL,
    `img` varchar(255) DEFAULT NULL,
    `order` int(11) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cart`
  --
  
  CREATE TABLE `cart` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `coffee_id` int(11) NOT NULL,
    `order_id` int(11) NOT NULL,
    `deliver_charge` varchar(255) DEFAULT NULL,
    `quantity` int(11) DEFAULT NULL,
    `unit_price` varchar(255) DEFAULT NULL,
    `total_price` varchar(255) DEFAULT NULL,
    `special_request` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `cart`
  --
  
  INSERT INTO `cart` (`id`, `users_id`, `shop_id`, `coffee_id`, `order_id`, `deliver_charge`, `quantity`, `unit_price`, `total_price`, `special_request`, `created_at`, `updated_at`) VALUES
  (1, 82, 3, 3, 2, '3', 33, '4', '3232', 'sdf', '2017-05-20 20:33:18', '2017-05-20 20:33:18');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `category`
  --
  
  CREATE TABLE `category` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `min_quantity` int(11) DEFAULT NULL,
    `max_quantity` int(11) DEFAULT NULL,
    `shop_id` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `category`
  --
  
  INSERT INTO `category` (`id`, `name_en`, `name_ar`, `min_quantity`, `max_quantity`, `shop_id`, `created_at`, `updated_at`) VALUES
  (3, 'hik', 'gff', 65, 56, 4, '2017-05-19 14:42:34', '2017-05-19 14:42:34');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms`
  --
  
  CREATE TABLE `cms` (
    `id` int(11) NOT NULL,
    `title_en` varchar(255) DEFAULT NULL,
    `title_ar` varchar(255) DEFAULT NULL,
    `alias` varchar(255) DEFAULT NULL,
    `content_en` varchar(255) DEFAULT NULL,
    `content_ar` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `columns_info`
  --
  
  CREATE TABLE `columns_info` (
    `id` int(10) UNSIGNED NOT NULL,
    `users_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `columns_info` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `columns_info`
  --
  
  INSERT INTO `columns_info` (`id`, `users_id`, `columns_info`, `created_at`, `updated_at`) VALUES
  (3, '1', '{\"/admin/reports/closed-orders\":{\"0\":{\"Order#\":1,\"Login\":1,\"Live/Demo\":1,\"Symbol\":1,\"Type\":1,\"Lots\":0,\"Open Time\":0,\"Open Price\":0,\"SL\":1,\"TP\":1,\"Commission\":1,\"Swaps\":1,\"Price\":1,\"Profit\":1}},\"/admin/reports/open-orders\":{\"0\":{\"Order#\":1,\"Login\":1,\"Live/Demo\":1,\"Symbol\":0,\"Type\":0,\"Lots\":1,\"Open Time\":0,\"Open Price\":0,\"SL\":0,\"TP\":1,\"Commission\":0,\"Swaps\":0,\"Price\":1,\"Profit\":1}},\"/admin/reports/account-statement\":{\"0\":{\"Order#\":0,\"Login\":0,\"Live/Demo\":0,\"Symbol\":0,\"Type\":0,\"Lots\":0,\"Open Time\":1,\"Open Price\":0,\"SL\":0,\"TP\":1,\"Commission\":1,\"Swaps\":1,\"Price\":1,\"Profit\":1},\"1\":{\"Order#\":0,\"Login\":1,\"Live/Demo\":0,\"Symbol\":0,\"Type\":1,\"Lots\":1,\"Open Time\":1,\"Open Price\":1,\"SL\":1,\"TP\":1,\"Commission\":1,\"Swaps\":1,\"Price\":1,\"Profit\":1},\"2\":{\"Order#\":1,\"Login\":0,\"Live/Demo\":0,\"Symbol\":0,\"Type\":1,\"Lots\":1,\"Open Time\":1,\"Open Price\":1,\"SL\":1,\"TP\":1,\"Commission\":1,\"Swaps\":1,\"Price\":1,\"Profit\":1},\"3\":{\"Order#\":1,\"Login\":1,\"Live/Demo\":1,\"Symbol\":1,\"Type\":1,\"Lots\":0,\"Open Time\":0,\"Open Price\":1,\"SL\":1,\"TP\":1,\"Commission\":1,\"Swaps\":1,\"Price\":1,\"Profit\":1},\"4\":{\"Order#\":1,\"Login\":1,\"Live/Demo\":1,\"Symbol\":0,\"Type\":0,\"Lots\":0,\"Open Time\":1,\"Open Price\":0,\"SL\":0,\"TP\":0,\"Commission\":0,\"Swaps\":0,\"Price\":0,\"Profit\":1}},\"/admin/accounts/accounts-list\":{\"0\":{\"Id\":1,\"Last Name\":0,\"Email \":1,\"Last Login\":1,\"\":1}},\"/admin/mt4Configrations/groups-list\":{\"0\":{\"Name\":1,\"Company\":1,\"MC/SO\":1}},\"/admin/reports/daily-report\":{\"0\":{\"Login\":1,\"Live/Demo\":1,\"Time\":1,\"Group\":1,\"Bank\":0,\"Prev balance\":0,\"Balance\":0,\"Deposit\":0,\"Credit\":0,\"Profit Closed\":1,\"Profit\":1,\"Equity\":1,\"Margin\":1,\"Margin Free\":1}},\"/admin/settings/admins-list\":{\"0\":{\"Id\":1,\"First Name\":1,\"Last Name\":1,\"Email \":1,\"\":1}}}', '2017-01-18 10:43:53', '2017-02-06 09:16:18');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cuisine`
  --
  
  CREATE TABLE `cuisine` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `cuisine`
  --
  
  INSERT INTO `cuisine` (`id`, `name_en`, `name_ar`, `status`, `description_en`, `description_ar`, `created_at`, `updated_at`) VALUES
  (1, 'CUISINE 1', 'مطبخ 1', 1, 'description cuisine 1', 'شرح المطبخ 1', '2017-05-19 13:42:52', '2017-05-19 13:42:52'),
  (2, 'cuisine 2', 'مطبخ 2', 1, 'description cuisine 2', 'شرح المطبخ 2', '2017-05-19 13:43:48', '2017-05-19 13:43:48');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_menu`
  --
  
  CREATE TABLE `delivery_menu` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `shop_id` int(11) NOT NULL,
    `status` int(11) DEFAULT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `delivery_menu`
  --
  
  INSERT INTO `delivery_menu` (`id`, `name_en`, `name_ar`, `shop_id`, `status`, `description_en`, `description_ar`, `created_at`, `updated_at`) VALUES
  (1, 'deliver menu 1', 'قائمة التوصيل 1', 4, 1, 'deliver menu description 1', 'شرح قائمة التوصيل 1', '2017-05-19 14:45:06', '2017-05-19 14:45:06');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `coffee`
  --
  
  CREATE TABLE `coffee` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `shop_id` int(11) NOT NULL,
    `cuisine_id` int(11) NOT NULL,
    `menu_section_id` int(11) NOT NULL,
    `category_id` int(11) NOT NULL,
    `delivery_menu_id` int(11) NOT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `price` varchar(255) DEFAULT NULL,
    `quantity` int(11) DEFAULT NULL,
    `img` varchar(255) DEFAULT NULL,
    `discount` varchar(255) DEFAULT NULL,
    `available_from` varchar(20) DEFAULT NULL,
    `available_to` varchar(20) DEFAULT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `coffee`
  --
  
  INSERT INTO `coffee` (`id`, `name_en`, `name_ar`, `shop_id`, `cuisine_id`, `menu_section_id`, `category_id`, `delivery_menu_id`, `parent_id`, `price`, `quantity`, `img`, `discount`, `available_from`, `available_to`, `description_en`, `description_ar`, `status`, `created_at`, `updated_at`) VALUES
  (3, 'coffee 1', 'الطبق 1', 4, 1, 1, 3, 1, 1, '13', 200, '/assets/website/images/coffeees/coffeees1.jpg', '2', '2017-04-01', '2017-07-01', 'coffee 1 description', 'شرح الطبق 1', 0, '2017-05-20 14:06:58', '2017-05-20 14:06:58');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `coffee_rate`
  --
  
  CREATE TABLE `coffee_rate` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `rate` int(11) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_group`
  --
  
  CREATE TABLE `email_group` (
    `id` int(11) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `email_group`
  --
  
  INSERT INTO `email_group` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'desdf', '2017-03-21 11:14:09', '2017-03-21 11:14:09');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_group_users`
  --
  
  CREATE TABLE `email_group_users` (
    `id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `type` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `email_group_users`
  --
  
  INSERT INTO `email_group_users` (`id`, `group_id`, `users_id`, `type`) VALUES
  (97, 1, 3, NULL),
  (98, 1, 7, NULL),
  (99, 1, 13, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_mass_queue`
  --
  
  CREATE TABLE `email_mass_queue` (
    `id` int(11) NOT NULL,
    `subject` varchar(255) DEFAULT NULL,
    `body` varchar(255) DEFAULT NULL,
    `language` varchar(10) DEFAULT NULL,
    `last_users_id` int(11) NOT NULL,
    `status` int(11) DEFAULT NULL,
    `email_group_id` int(11) NOT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_mass_template`
  --
  
  CREATE TABLE `email_mass_template` (
    `id` int(11) NOT NULL,
    `email_group_id` int(11) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `subject` varchar(255) DEFAULT NULL,
    `body` varchar(255) DEFAULT NULL,
    `language` varchar(10) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `email_mass_template`
  --
  
  INSERT INTO `email_mass_template` (`id`, `email_group_id`, `name`, `subject`, `body`, `language`, `created_at`, `updated_at`) VALUES
  (1, 1, 'hhhhhhhhhhh', 'hhhhhhhhh', '', 'en', '2017-03-21 12:18:42', '2017-03-21 12:22:46'),
  (2, 1, 'sdfg', 'sdfg', '<p>gdgsdf</p>\r\n', 'en', '2017-03-23 08:32:02', '2017-03-23 08:32:02');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `email_template`
  --
  
  CREATE TABLE `email_template` (
    `id` int(11) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `subject` varchar(255) DEFAULT NULL,
    `body` varchar(255) DEFAULT NULL,
    `type` int(11) DEFAULT NULL,
    `to_field` varchar(255) DEFAULT NULL,
    `to_email` varchar(255) DEFAULT NULL,
    `language` varchar(10) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `email_template`
  --
  
  INSERT INTO `email_template` (`id`, `name`, `subject`, `body`, `type`, `to_field`, `to_email`, `language`, `status`, `created_at`, `updated_at`) VALUES
  (2, 'signUp', 'sssssss', '<p><img alt=\"\" src=\"http://localhost:8000/files/15697_31158business-user-group-icon-44614.png\" style=\"height:256px; width:256px\" />sssssss</p>\r\n', 0, 'sssssssssss', 'ssssss', 'en', 0, '2017-03-21 11:50:22', '2017-03-23 08:42:43'),
  (3, 'signUp', 'sdfg', 'sdfgggggggg', 2, 'gdf', 'gsdfg', 'en', 0, '2017-03-21 12:05:04', '2017-03-21 12:05:04'),
  (4, 'signUp', 'gmmmmmmm', 'mmmmmmmmmmmmm', 0, 'mmmmmm', 'm', 'en', 1, '2017-03-21 12:05:34', '2017-03-21 12:05:34');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `governorate`
  --
  
  CREATE TABLE `governorate` (
    `id` int(11) NOT NULL,
    `name_en` varchar(50) DEFAULT NULL,
    `name_ar` varchar(50) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `governorate`
  --
  
  INSERT INTO `governorate` (`id`, `name_en`, `name_ar`, `created_at`, `updated_at`) VALUES
  (3, 'governorate 1', 'المحافظة 1', '2017-05-19 12:59:05', '2017-05-19 12:59:05'),
  (4, 'GOVERNORATE 2', 'محافظة 2', '2017-05-19 13:01:24', '2017-05-19 13:01:24'),
  (5, 'GOVERNORATE 3', 'محافظة 3', '2017-05-19 13:01:48', '2017-05-19 13:01:48');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menu_section`
  --
  
  CREATE TABLE `menu_section` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `shop_id` int(11) NOT NULL,
    `status` int(11) DEFAULT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `menu_section`
  --
  
  INSERT INTO `menu_section` (`id`, `name_en`, `name_ar`, `shop_id`, `status`, `description_en`, `description_ar`, `created_at`, `updated_at`) VALUES
  (1, 'menu section 1', 'قسم القاشمة 1', 4, 0, 'description menu section 1', 'شرح القائمة 1', '2017-05-20 14:06:42', '2017-05-20 14:06:42');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `operation_hour`
  --
  
  CREATE TABLE `operation_hour` (
    `id` int(11) NOT NULL,
    `shop_area_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `day` varchar(20) DEFAULT NULL,
    `shift1_from` varchar(20) DEFAULT NULL,
    `shift1_to` varchar(20) DEFAULT NULL,
    `shift2_from` varchar(20) DEFAULT NULL,
    `shift2_to` varchar(20) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `order`
  --
  
  CREATE TABLE `order` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `area_id` int(11) NOT NULL,
    `from_id` int(11) DEFAULT NULL,
    `address_id` int(11) NOT NULL,
    `order_time` varchar(20) DEFAULT NULL,
    `deliver_time` varchar(20) DEFAULT NULL,
    `deliver_date` varchar(20) DEFAULT NULL,
    `note` varchar(255) DEFAULT NULL,
    `deliver_charge` varchar(255) DEFAULT NULL,
    `rate` int(11) DEFAULT NULL,
    `point` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `status` int(11) NOT NULL,
    `created_at` varchar(20) NOT NULL,
    `updated_at` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `order`
  --
  
  INSERT INTO `order` (`id`, `users_id`, `shop_id`, `area_id`, `from_id`, `address_id`, `order_time`, `deliver_time`, `deliver_date`, `note`, `deliver_charge`, `rate`, `point`, `notification`, `status`, `created_at`, `updated_at`) VALUES
  (1, 6, 4, 4, 1, 1, '1', '1', '1', 'sdfsd', '2', 2, 2, 0, 3, '2017-05-19 19:42:56', '2017-05-19 19:42:56'),
  (2, 82, 4, 3, 1, 1, '14:00:00', '14:00:00', '2017-06-03', 'note', '3', 2, 1, 0, 3, '2017-05-20 15:55:16', '2017-05-20 15:56:36');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `order_driver`
  --
  
  CREATE TABLE `order_driver` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `order_id` int(11) NOT NULL,
    `current_long` varchar(255) DEFAULT NULL,
    `current_lat` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `note` varchar(255) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `order_driver`
  --
  
  INSERT INTO `order_driver` (`id`, `users_id`, `order_id`, `current_long`, `current_lat`, `status`, `note`, `notification`, `created_at`, `updated_at`) VALUES
  (1, 82, 2, '242', '435345', 1, 'sdkf', 0, '2017-05-20 20:13:20', '2017-05-20 20:13:20');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment`
  --
  
  CREATE TABLE `payment` (
    `id` int(11) NOT NULL,
    `order_id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `amount` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `type` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `persistences`
  --
  
  CREATE TABLE `persistences` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `persistences`
  --
  
  INSERT INTO `persistences` (`id`, `user_id`, `code`, `created_at`, `updated_at`) VALUES
  (13, 6, 'aGBPzjGUrSTzGrFWqIqfBUYvdBcu3IKz', '2016-03-14 11:11:24', '2016-03-14 11:11:24'),
  (21, 2, '0bsTPqQffZJUYINtFELUiTwRbd6n99Mb', '2016-03-15 11:08:45', '2016-03-15 11:08:45'),
  (198, 6, 'DhP1XiaQ6ravLOhlCDmOsXc2KodsqOug', '2016-03-31 22:08:21', '2016-03-31 22:08:21'),
  (200, 2, 'G0CvO9N8A1dfs2aSRmwKs8EqPjKVLPx4', '2016-04-01 17:25:40', '2016-04-01 17:25:40'),
  (201, 2, 'tfNy8ZvSi4ZNXlG9UKnTS9YERHqpnwVq', '2016-04-01 18:27:34', '2016-04-01 18:27:34'),
  (202, 2, 'eD04LoOYTd8rd1oJORQVFG9vI8WUh1UX', '2016-04-01 22:17:05', '2016-04-01 22:17:05'),
  (213, 2, 'vlHgdDzy8cECi0MAmTf7HittgKJ2qZO2', '2016-04-04 06:38:58', '2016-04-04 06:38:58'),
  (216, 2, 'mqLb4PaaBxQSoGutmIc9nwDjB5mLSgxm', '2016-04-05 07:37:01', '2016-04-05 07:37:01'),
  (239, 2, 'DcDlJRWbi4dQbWNjQuflfOCWKlkwHbB1', '2016-04-08 17:57:23', '2016-04-08 17:57:23'),
  (240, 2, 'tJmo4912LPXUxYVNJRe9U9e4ntS79BHG', '2016-04-08 20:29:42', '2016-04-08 20:29:42'),
  (241, 2, 'REr5LXnnuyyImKiw8cmf0uTQsJovugvP', '2016-04-09 07:19:41', '2016-04-09 07:19:41'),
  (246, 2, '9FxqSqdsQeDVlAa3g9puhX8zAnasUfF8', '2016-04-10 19:52:57', '2016-04-10 19:52:57'),
  (268, 2, 'vz2qSKpx6kkUvSB6P7XcOUdOMyXAJG8p', '2016-04-13 18:39:37', '2016-04-13 18:39:37'),
  (296, 4, 'ZtQJVPkNkMUlFDI7V3XQlfFikhA9qOji', '2016-04-19 14:45:34', '2016-04-19 14:45:34'),
  (322, 4, '84sqz4XOyQVlc5RycNBPoi0ZBds01mVR', '2016-04-26 14:46:33', '2016-04-26 14:46:33'),
  (330, 4, 'GxcieRdtZ9W0ZuC9phigoiX1PClhBrLS', '2016-04-27 12:02:04', '2016-04-27 12:02:04'),
  (336, 4, 'l3Ch8sMgucWsV4FOe42faoipM9OCGjPK', '2016-04-30 15:49:09', '2016-04-30 15:49:09'),
  (339, 13, 'C5XrS339FfYcaTCgyQbusdvfvZYR1tGj', '2016-05-01 13:05:25', '2016-05-01 13:05:25'),
  (340, 13, 'KH9MMIcm1LFJDs8SJyecCUatRAj1WFQu', '2016-05-01 13:05:46', '2016-05-01 13:05:46'),
  (341, 16, 'KexTJgebprB8FpdU0FfPvcVWTCyzr5Q8', '2016-05-01 13:06:09', '2016-05-01 13:06:09'),
  (342, 13, '6vivmvHue2NHmZq64mkunAQu0vDjlR6z', '2016-05-01 13:06:59', '2016-05-01 13:06:59'),
  (343, 13, 'I9x2KiRNB5SdOaet3vHzkUjrpeRmKftQ', '2016-05-01 13:07:06', '2016-05-01 13:07:06'),
  (349, 19, 'ehmEHxRZLbhZxkHxnt8mfIP67eA73hQV', '2016-05-01 13:16:31', '2016-05-01 13:16:31'),
  (350, 20, 'WBGDzIYYWyneYLWEBgIRXcTp3JhQHMAT', '2016-05-01 13:18:01', '2016-05-01 13:18:01'),
  (352, 18, 'HgMkihmdqosW8HXQUNLRbx0W5pbZa1cZ', '2016-05-01 13:22:35', '2016-05-01 13:22:35'),
  (353, 21, 'e1Ijuw5yeXSfZApXWtSwkCOSpmEjByhe', '2016-05-01 13:23:05', '2016-05-01 13:23:05'),
  (356, 26, 'FAeE7eqvmepKMEKbxM6YnI3rM3ITQ8RX', '2016-05-01 13:36:36', '2016-05-01 13:36:36'),
  (357, 28, 'ODN81CXLx4QR1vczvFdhqzIz6Hku44Yy', '2016-05-01 13:47:29', '2016-05-01 13:47:29'),
  (358, 12, 'kW11CamqTa3noWxxN02KRF8BW80PaiUK', '2016-05-01 13:59:26', '2016-05-01 13:59:26'),
  (359, 39, '2fLMrqC2aDnVQCQ2oUv2ayglVuuQsyid', '2016-05-01 14:08:17', '2016-05-01 14:08:17'),
  (360, 40, 'fhFjD5so2K3rxjRub2g3qmmZlWu0K44k', '2016-05-01 14:11:17', '2016-05-01 14:11:17'),
  (362, 4, 'mPrmFHW16wggdaPFYcUMXBIHgiGEsvhI', '2016-05-01 14:34:04', '2016-05-01 14:34:04'),
  (378, 12, 'YToBg3sS8R3Xxp6kufW0CqcHHf7Lpc9n', '2016-05-09 07:23:07', '2016-05-09 07:23:07'),
  (385, 12, 'ksrIus9ZbV6i6URyGSgVZKCsrj3c29sq', '2016-05-10 06:53:35', '2016-05-10 06:53:35'),
  (391, 11, '1g4msvKw3JfxJtMCV7nDejsdHfXPHoXS', '2016-05-10 11:14:05', '2016-05-10 11:14:05'),
  (392, 56, 'dLPFAvR1FSGfo65vJQAyuRIVukn3VAiL', '2016-05-10 11:17:12', '2016-05-10 11:17:12'),
  (393, 57, 'Be7kBATXAOzaTEdc1tJ2KSrBsEs9FWDJ', '2016-05-10 11:21:48', '2016-05-10 11:21:48'),
  (395, 59, 'sFFhsIOII0r7zuDZEos0O2rhJO0MWkYo', '2016-05-10 11:40:16', '2016-05-10 11:40:16'),
  (396, 59, 'Fv7ySwol0SnvdXqjYIb5bw324M5URpLz', '2016-05-10 11:46:05', '2016-05-10 11:46:05'),
  (401, 59, 'FQC8mpXw0SCa1SX1xjPHYFFxvKE3uTVL', '2016-05-10 11:57:58', '2016-05-10 11:57:58'),
  (402, 60, 'X2Z91KsVmdqRFvEkjhsZdM699mk4eR9h', '2016-05-10 12:11:07', '2016-05-10 12:11:07'),
  (403, 60, 'meYifxiLMmMZ8OyCg9vXD4iMKMO66MQK', '2016-05-10 12:14:42', '2016-05-10 12:14:42'),
  (405, 62, '3p1Z95LClarupWPkwjEJalIUAIb78Q4S', '2016-05-10 12:18:08', '2016-05-10 12:18:08'),
  (462, 64, 'vttSfarMntiWYxNhMUqDzKXrx01glNA1', '2016-05-29 06:47:05', '2016-05-29 06:47:05'),
  (470, 69, 'TagiBTWWF4NiiNvPoQtyZKG47YYyTyDb', '2016-05-29 11:38:10', '2016-05-29 11:38:10'),
  (487, 4, 'AE7f2jTsLd8l4UJjAhzOu1TpAqjCHt9n', '2016-06-01 09:32:49', '2016-06-01 09:32:49'),
  (507, 4, 'UdfuXc5X2TKbLDHtSuaX2ZNOUfLvnUPH', '2016-06-09 13:30:01', '2016-06-09 13:30:01'),
  (759, 5, 'LsEf94NVFuMZ5w7hVh29tJFDbk0hEdtP', '2017-01-04 11:13:23', '2017-01-04 11:13:23'),
  (760, 5, 'CMh19Tb6fzo0HR5aLGaz7JEyjN61zaoP', '2017-01-04 11:35:03', '2017-01-04 11:35:03'),
  (762, 5, 'i6Vq9llTFN6ynkQGg5OswceRB9WbvjNU', '2017-01-04 11:46:51', '2017-01-04 11:46:51'),
  (764, 5, 'zz8ARNLcEHDRFm6S6iMSTMePVLQrv0KN', '2017-01-04 12:36:58', '2017-01-04 12:36:58'),
  (765, 5, '9MXAGm6vA1J4og4cndTAJqHXFgvlakvw', '2017-01-04 12:45:20', '2017-01-04 12:45:20'),
  (768, 5, 'MXJJnSLUAEokkbTnyHWa0Wt3cpWJv3Xv', '2017-01-04 12:52:44', '2017-01-04 12:52:44'),
  (770, 5, 'h65Fb2HIxmKm71g9uLU8ILuWxKhViu8u', '2017-01-04 13:16:34', '2017-01-04 13:16:34'),
  (772, 5, 'orF9EdXntpOtHR3uI4enUrCFN8OO3efQ', '2017-02-08 21:25:08', '2017-02-08 21:25:08'),
  (895, 82, 'Skt4reNM8LtA7ndMRb3a9Q58RopkDyGM', '2017-05-21 07:40:27', '2017-05-21 07:40:27'),
  (896, 82, 'pG6FVR51NK18DKlFflninE4aqpX9HvCV', '2017-05-21 07:41:13', '2017-05-21 07:41:13'),
  (897, 82, 'NVOEvPcisJdfBdCKa1zmaaCr8XPBO3X5', '2017-05-21 07:41:37', '2017-05-21 07:41:37'),
  (898, 82, 'NbhDPl458SuqRWMHPZdowWu3nOnECq66', '2017-05-21 07:41:56', '2017-05-21 07:41:56'),
  (899, 82, 'tLXf1yPl8acy59OA1JPJYhQU9BcQ6gTn', '2017-05-21 07:44:15', '2017-05-21 07:44:15'),
  (900, 82, 'xQvNi9WEM5QTgJKpwAQ9hP9Byg6388uM', '2017-05-21 07:45:06', '2017-05-21 07:45:06'),
  (901, 82, 'XOgSKNdCZvgNqeQYBwlza4vFxIT4xgLh', '2017-05-21 07:45:51', '2017-05-21 07:45:51'),
  (902, 82, 'fv6XeOZPIxSR1Q9HBOOYlBKPjKBYIQvL', '2017-05-21 07:46:55', '2017-05-21 07:46:55'),
  (903, 82, 'zCbiemwhosISzoVWtnWOw2nxWHsBnplA', '2017-05-21 07:49:09', '2017-05-21 07:49:09'),
  (904, 82, 'LZrWmbM4x5iigPDVR8COr3y0GXS6bdBG', '2017-05-21 07:49:44', '2017-05-21 07:49:44'),
  (905, 82, 'WHKMa84YyE1xt9txhHy7GlSZITAR2RW6', '2017-05-21 07:49:57', '2017-05-21 07:49:57'),
  (906, 82, 'MZBoDXcS59LDFvbYsUh4XL4Jf1Ci7lm3', '2017-05-21 07:50:19', '2017-05-21 07:50:19'),
  (907, 82, 'pUGhUpplGUBBfkGrvmdjNBaXL844gn5Q', '2017-05-21 07:50:59', '2017-05-21 07:50:59'),
  (908, 82, 'H3XOvlWgo31YNnaB7nbKoEnmqqs1HHoe', '2017-05-21 07:52:02', '2017-05-21 07:52:02'),
  (909, 82, 'FozzFobnTiHkPStEMZUlE0x68jHrsVG5', '2017-05-21 07:52:33', '2017-05-21 07:52:33'),
  (910, 82, 'ILvoR4NnVezX5YvcNaKHFQfzzshSIiS4', '2017-05-21 07:53:42', '2017-05-21 07:53:42'),
  (911, 82, 'MVtvIxMXEhKcIVbRtWAatmcb7Ivp9Qse', '2017-05-21 07:54:07', '2017-05-21 07:54:07'),
  (912, 82, 'MvzUeIMrkivaUwyty6aq0tTEwnqOB30G', '2017-05-21 07:54:30', '2017-05-21 07:54:30'),
  (913, 82, 'mqU3zyGATi3mpKK6ow9wp3BdZIGNG0NZ', '2017-05-21 07:55:22', '2017-05-21 07:55:22'),
  (914, 82, 'BDSot2iNnUBFYyuIsh6gCQAwUCnIH5Te', '2017-05-21 07:55:41', '2017-05-21 07:55:41'),
  (915, 82, '0gyexg4TFfcScWkcjpTbe3fDNf6QXml0', '2017-05-21 07:55:50', '2017-05-21 07:55:50'),
  (916, 82, 'KMiV44vieaWPkVfiABuDpr2wP0KaI9ul', '2017-05-21 07:57:08', '2017-05-21 07:57:08'),
  (917, 82, 'BK2gnBEOEqjiU0sXZFcvc3sF3AI8tEWv', '2017-05-21 07:57:29', '2017-05-21 07:57:29'),
  (918, 82, '136AE2hmIo1Jp7Ka8xH9hnZUa9NCbsPR', '2017-05-21 07:57:49', '2017-05-21 07:57:49'),
  (919, 82, 'tkBKuDcwQotgQO5qRAFlpQwR7MzSQRzy', '2017-05-21 07:58:00', '2017-05-21 07:58:00'),
  (920, 82, 'uaYvJsxcwLXHvIOSaYqgFEcGCmwMHs2p', '2017-05-21 07:59:36', '2017-05-21 07:59:36'),
  (921, 82, 'H3HvQjLX1nWC8Uor2n8UwkrjgWLeoZBd', '2017-05-21 07:59:56', '2017-05-21 07:59:56'),
  (922, 82, '8DZAcSiXp7YqA9EjloHbDVl7Qec0CNun', '2017-05-21 08:01:00', '2017-05-21 08:01:00'),
  (923, 82, '0r3VEayG7spkusOdlw9icggjQ20nLeoJ', '2017-05-21 08:02:33', '2017-05-21 08:02:33'),
  (924, 82, 'Y6iNLNzuKccwGueMhV55D8x52VCxxa7Y', '2017-05-21 08:02:37', '2017-05-21 08:02:37'),
  (925, 82, '3bv5O32lHfuLA5WKdJPSPq7klc9zSZSq', '2017-05-21 08:08:05', '2017-05-21 08:08:05'),
  (926, 82, 'REsTk6qIvzwQOlo1OY0UYOgL7KufausW', '2017-05-21 08:08:07', '2017-05-21 08:08:07'),
  (927, 82, 'rDVZ4cvUXRjhWjo4bl547IUnKztJIYWU', '2017-05-21 08:08:08', '2017-05-21 08:08:08'),
  (928, 82, '7xDSa0Qjl8Dj4NDLxHw9GLdexGG7zVwM', '2017-05-21 08:08:14', '2017-05-21 08:08:14'),
  (929, 82, 'haAQOEPykK9nFCBPQb13pArXvzk3mViD', '2017-05-21 08:08:15', '2017-05-21 08:08:15'),
  (930, 82, '2tfuQrikNGAPjnudbG4X3exMFuQjFYo8', '2017-05-21 08:08:16', '2017-05-21 08:08:16'),
  (931, 82, 'ulsCQhmetwEfqE6LvISzLb8yRjvcOqRu', '2017-05-21 08:08:18', '2017-05-21 08:08:18'),
  (932, 82, 'ZWaHnhN7dvVCHaH3KiOOVVkFczYKsHdK', '2017-05-21 08:08:21', '2017-05-21 08:08:21'),
  (933, 82, '4NBmXzoLiLGFJ2bMVqagjaj74Ccf0YFR', '2017-05-21 08:09:05', '2017-05-21 08:09:05'),
  (934, 82, 'B7UxzjqYooM3BoXDQJ3pyaEeYyimPUNj', '2017-05-21 10:34:10', '2017-05-21 10:34:10'),
  (935, 82, 'NzhxM7YSwA4OEjaMamSIscnm8YSYM8KY', '2017-05-21 10:44:45', '2017-05-21 10:44:45'),
  (936, 82, 'WQH1Y7EJpIl2o4ccFHJ2FdA6pphVc7Hg', '2017-05-21 10:45:29', '2017-05-21 10:45:29'),
  (937, 82, 'lxrl8E5idKrV94LCIpxO528h67wVZ35c', '2017-05-21 10:52:01', '2017-05-21 10:52:01'),
  (938, 82, 'VdZ7nEwKHbBRzck676nWAfPxE0VMfbjP', '2017-05-21 10:54:45', '2017-05-21 10:54:45'),
  (939, 82, 'J1hLA5fg9rn9cMrqgqLGkPVCittsrElV', '2017-05-21 10:55:09', '2017-05-21 10:55:09'),
  (940, 82, '6NVh3oBs5rvKilo2cGa8Lwz7YYlRGFAB', '2017-05-21 10:56:25', '2017-05-21 10:56:25'),
  (941, 82, 'QLqIjsM1ODBKqgPz9dNR5mWDgxacYtyP', '2017-05-21 14:11:45', '2017-05-21 14:11:45');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `reminders`
  --
  
  CREATE TABLE `reminders` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `completed` tinyint(1) NOT NULL DEFAULT '0',
    `completed_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `reminders`
  --
  
  INSERT INTO `reminders` (`id`, `user_id`, `code`, `completed`, `completed_at`, `created_at`, `updated_at`) VALUES
  (11, 3, 'Tf82pzBVSKQCocIl4wLAJHOYnjQmCyqc', 1, '2016-04-24 07:07:13', '2016-04-24 07:06:19', '2016-04-24 07:07:13'),
  (12, 3, 'bg8a6p52d0Y1fLdvaWjPXrTWBDIss6Tm', 1, '2016-12-27 13:31:16', '2016-12-27 12:22:15', '2016-12-27 13:31:16');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shop`
  --
  
  CREATE TABLE `shop` (
    `id` int(11) NOT NULL,
    `name_en` varchar(255) DEFAULT NULL,
    `name_ar` varchar(255) DEFAULT NULL,
    `Owner_first_name` varchar(255) DEFAULT NULL,
    `Owner_last_name` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `available_payment` varchar(25) DEFAULT NULL,
    `telephone` varchar(25) DEFAULT NULL,
    `address_en` varchar(255) DEFAULT NULL,
    `address_ar` varchar(255) DEFAULT NULL,
    `description_en` varchar(255) DEFAULT NULL,
    `description_ar` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `min_amount` varchar(255) DEFAULT NULL,
    `working_hour_from` varchar(20) DEFAULT NULL,
    `working_hour_to` varchar(20) DEFAULT NULL,
    `deliver_time_from` varchar(20) DEFAULT NULL,
    `deliver_time_to` varchar(20) DEFAULT NULL,
    `deliver_charge` varchar(255) DEFAULT NULL,
    `rating` int(11) DEFAULT NULL,
    `show_menu` int(11) DEFAULT NULL,
    `order_accept_days` int(11) DEFAULT NULL,
    `offline_order` int(11) DEFAULT NULL,
    `summary_en` varchar(255) DEFAULT NULL,
    `summary_ar` varchar(255) DEFAULT NULL,
    `url` varchar(255) DEFAULT NULL,
    `img` varchar(255) DEFAULT NULL,
    `commission_type` int(11) DEFAULT NULL,
    `discount_type` int(11) DEFAULT NULL,
    `discount` varchar(255) DEFAULT NULL,
    `area_id` int(11) NOT NULL,
    `follow_us` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) NOT NULL,
    `updated_at` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `shop`
  --
  
  INSERT INTO `shop` (`id`, `name_en`, `name_ar`, `Owner_first_name`, `Owner_last_name`, `email`, `available_payment`, `telephone`, `address_en`, `address_ar`, `description_en`, `description_ar`, `status`, `min_amount`, `working_hour_from`, `working_hour_to`, `deliver_time_from`, `deliver_time_to`, `deliver_charge`, `rating`, `show_menu`, `order_accept_days`, `offline_order`, `summary_en`, `summary_ar`, `url`, `img`, `commission_type`, `discount_type`, `discount`, `area_id`, `follow_us`, `notification`, `created_at`, `updated_at`) VALUES
  (3, 'sdfkj', 'sfdj', 'kjlskjfd', 'kjl', 'kj', 'jlkj', 'lkj', 'lkj', 'lj', 'lj', 'lk', 0, 'kj', 'lkj', 'l', 'jl', 'kjl', 'kj', 0, 0, 0, 0, 'kj', 'lkj', 'lkj', '/assets/website/images/res3.jpg', 0, 0, 'klj', 1, 0, 0, '2017-05-18 07:31:26', '2017-05-18 07:31:26'),
  (4, 'shop 1', 'المطعم 1', 'taylor', 'successor', 'taylorsuccessor@gmail.com', 'knet,visa, cash ', '0785181656', 'address shop 1', 'عنوان 1', 'description shop 1', 'شرح المطعم 1', 0, '21.32', '08:00:00', '16:00:00', '09:00:00', '15:00:00', '2.5', 3, 1, 3, 1, 'summary shop 1', 'مختصر المطعم 1', '/assets/website/images/img_order1.jpg', '/assets/website/images/img_order1.jpg', 1, 0, '10', 3, 0, 1, '2017-05-19 14:26:54', '2017-05-19 14:26:54');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shop_area`
  --
  
  CREATE TABLE `shop_area` (
    `id` int(11) NOT NULL,
    `area_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `delivery_charges` varchar(255) DEFAULT NULL,
    `deera_charge` varchar(255) DEFAULT NULL,
    `min_amount` varchar(255) DEFAULT NULL,
    `deliver_time_from` varchar(20) DEFAULT NULL,
    `deliver_time_to` varchar(20) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `governorate_id` int(11) NOT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shop_cuisine`
  --
  
  CREATE TABLE `shop_cuisine` (
    `id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `cuisine_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `shop_cuisine`
  --
  
  INSERT INTO `shop_cuisine` (`id`, `shop_id`, `cuisine_id`) VALUES
  (1, 4, 2),
  (2, 4, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shop_rate`
  --
  
  CREATE TABLE `shop_rate` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `rate` int(11) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `notification` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shop_users`
  --
  
  CREATE TABLE `shop_users` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `shop_id` int(11) NOT NULL,
    `status` int(11) DEFAULT NULL,
    `type` int(11) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `shop_users`
  --
  
  INSERT INTO `shop_users` (`id`, `users_id`, `shop_id`, `status`, `type`, `created_at`, `updated_at`) VALUES
  (1, 66, 4, 0, 0, '2017-05-19 14:40:20', '2017-05-19 14:40:20');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `permissions` text COLLATE utf8_unicode_ci,
    `deny_permissions` text COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `roles`
  --
  
  INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `deny_permissions`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'Admin', '|*.*.*.*', '|', '2016-03-28 13:25:48', '2017-03-23 02:56:17'),
  (3, 'client', 'Client', '|', '', '2017-03-22 21:52:50', '2017-03-22 21:52:50'),
  (4, 'public', 'public', '|*.*.*.*', '', '2017-03-22 22:15:21', '2017-03-22 22:15:21'),
  (7, 'role-name', 'role name', '|*.*.*.*|client.index.store.*|*.index.create.*|*.*.store.*|*.index.store.*', '|client.category.store.*|client.category.edit.*|client.email_mass_template.edit.*|*.*.*.*|dashboard.*.*.*', '2017-03-23 02:24:37', '2017-03-23 02:35:00'),
  (8, 'jh', 'jh', '|admin.address.create.*|admin.*.create.*', '|admin.service_boy.*.*', '2017-05-21 03:07:33', '2017-05-21 03:07:33');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `role_users`
  --
  
  CREATE TABLE `role_users` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `role_users`
  --
  
  INSERT INTO `role_users` (`user_id`, `role_id`, `created_at`, `updated_at`) VALUES
  (1, 1, NULL, NULL),
  (4, 3, NULL, NULL),
  (79, 1, NULL, NULL),
  (80, 1, NULL, NULL),
  (80, 3, NULL, NULL),
  (81, 3, NULL, NULL),
  (82, 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `service_company`
  --
  
  CREATE TABLE `service_company` (
    `id` int(11) NOT NULL,
    `name` varchar(100) DEFAULT NULL,
    `created_at` varchar(20) DEFAULT NULL,
    `updated_at` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `throttle`
  --
  
  CREATE TABLE `throttle` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED DEFAULT NULL,
    `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `throttle`
  --
  
  INSERT INTO `throttle` (`id`, `user_id`, `type`, `ip`, `created_at`, `updated_at`) VALUES
  (1, NULL, 'global', NULL, '2017-05-21 10:55:01', '2017-05-21 10:55:01'),
  (2, NULL, 'ip', '192.168.100.11', '2017-05-21 10:55:01', '2017-05-21 10:55:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `permissions` text COLLATE utf8_unicode_ci,
    `last_login` timestamp NULL DEFAULT NULL,
    `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `avatar` blob,
    `mobile` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
    `gender` int(11) NOT NULL,
    `occupation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `session_id` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `email`, `password`, `permissions`, `last_login`, `first_name`, `last_name`, `avatar`, `mobile`, `phone`, `gender`, `occupation`, `session_id`, `created_at`, `updated_at`) VALUES
  (13, 'admin@admin.com', '$2y$10$yWVr9dZBQlAJ73aMKQ0Q3OL0okTWO7k4fWzq6zuK08TSFnAFf98Yu', NULL, '2016-05-01 13:07:06', ': admin firstName', ': admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:01:21', '2016-05-01 13:07:06'),
  (15, 'admin@admi4n.com', '$2y$10$796MNhlzvJwwb2qA9egs5ek9mcRLFOXKizDSX9lXbbTfKwc1XOyn6', NULL, NULL, ': admin firstName', ': admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:04:34', '2016-05-01 13:04:34'),
  (16, 'admin@admin5.com', '$2y$10$9e12W1hor43yve3OPJNyt.uS5C39n0rMRkyBO.4BRSo2FE8RKWn3W', NULL, '2016-05-01 13:06:09', ': admin firstName', ': admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:05:12', '2016-05-01 13:06:09'),
  (17, 'admin@admin7.com', '$2y$10$6YDAKpvtDaQy.QcH1wdV3uOZueFCAAFqn8JeiZowDVL8hqwHW/eGK', NULL, NULL, ': admin firstName', ': admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:11:23', '2016-05-01 13:11:23'),
  (18, 'admintest@admin.com', '$2y$10$F8E6o6rlUgxh9xd49aDI..DnnsGKZ..10uFxqSYJ109ck8H0.UyWS', NULL, '2016-05-01 13:22:35', 'adminTest', 'Test', NULL, '', '', 0, '', '', '2016-05-01 13:12:22', '2016-05-01 13:22:35'),
  (19, 'admin@admin8.com', '$2y$10$E9kdJ28a887C0gDVryRoJOWU9.wHlcMHTFILI/qvhTOXh/z5DPIcq', NULL, '2016-05-01 13:16:31', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:14:07', '2016-05-01 13:16:31'),
  (20, 'admin@admin9.com', '$2y$10$33PXn.qz2Ktm48z7xgziK.8scy0wu5IMZli0/QODg1k.ntaU0PzCi', NULL, '2016-05-01 13:18:01', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:17:20', '2016-05-01 13:18:01'),
  (21, 'admin@admina.com', '$2y$10$Y3Ht/J9B5VozrTqmerM8veTjIiF0GEcegPHuRyB5c7l3RGnmyi1KG', NULL, '2016-05-01 13:23:05', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:22:34', '2016-05-01 13:23:05'),
  (22, 'admin@adminb.com', '$2y$10$WNjXQg8y8abXr4lZItJxCueIR3qHJquO3MVExTM98zz9QTqXOsFKy', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:28:23', '2016-05-01 13:28:23'),
  (23, 'admin@adminc.com', '$2y$10$KD4oByWVRd4VkcJhTHhBGOeBmDaRAE/DiyqF/XydG/BvOtQ.NlmM6', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:28:54', '2016-05-01 13:28:54'),
  (24, 'admin@admind.com', '$2y$10$fCblwhGnZfN54Vukn4hPS.g5LpCzzg8hA.c8XNHokf7id2bqTyGlu', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:29:13', '2016-05-01 13:29:13'),
  (25, 'ddd@ddd.ddd', '$2y$10$orGG6KvMrH4TO1agzzSmvupHecZgciUHbO2r6.gzrQeLZQaBEpdGK', NULL, '2016-05-01 13:33:53', 'asdf', 'sf', NULL, '', '', 0, '', '', '2016-05-01 13:33:39', '2016-05-01 13:33:53'),
  (26, 'admin@admine.com', '$2y$10$M.KIZXmo.0Ox/BwwkXnjteR8ck0uWIf0dewsRj01njcvnThiWx9s2', NULL, '2016-05-01 13:36:36', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:35:54', '2016-05-01 13:36:36'),
  (27, 'admin@adminv.com', '$2y$10$/tp9OFQq2vbsf.63/JFY5eKKDSKkmlfIiFks7TNPaTD6eL52mvs.y', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:46:24', '2016-05-01 13:46:24'),
  (28, 'admin@adminz.com', '$2y$10$z6RFdmsA.kdgpMujELpBouYMLl2/XiciDrdX1O4DkzylfMT/Zybje', NULL, '2016-05-01 13:47:29', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:46:55', '2016-05-01 13:47:29'),
  (29, 'admin@adminx.com', '$2y$10$ozdl9T7dMl.W/G64tU1cNuFJk30xj7VfZtri26QQl/s1q.W16Gsy2', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:48:29', '2016-05-01 13:48:29'),
  (30, 'admin@admink.com', '$2y$10$fPBKMa4PpH7cyb9Keby.EOU8B8Oe0hmXpwmGQLFR5EOvo1MUda57C', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:49:41', '2016-05-01 13:49:41'),
  (31, 'admin@admint.com', '$2y$10$MUZSx0j9aOmMMVplFosSE.8lVQjIdGL2m6WEt.zuuy8HFq844TV.K', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:49:57', '2016-05-01 13:49:57'),
  (33, 'admin@admintt.com', '$2y$10$TgyW12bN1zRrTLCVhOEN5.1pVKdCuMP2INgwGZ0wAF2uuiAGf4/DW', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:50:38', '2016-05-01 13:50:38'),
  (34, 'admin@admintx.com', '$2y$10$SqwIYTitU.eUORVnneZnAO/uLXnveMMUvSKQvXH2PmLuoUNkWEu1S', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:50:47', '2016-05-01 13:50:47'),
  (35, 'admin@adminthx.com', '$2y$10$KbTUhocfRRpr.TkQaBPEwu/NX0j/VLBltUyW.2QrhTCoCQ/SVkCjm', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:53:10', '2016-05-01 13:53:10'),
  (36, 'admin@admjinthx.com', '$2y$10$EpscExd4AFgDqFo44FitLu7Qen.ViLsopDvs93CFqC./ccAAk4rTS', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:53:16', '2016-05-01 13:53:16'),
  (37, 'admin@ajdmjinthx.com', '$2y$10$Hi.7Wj0bgELIKRrtUR8afeVRDvpXsKOJHSIYu3oir3YS9TE6SQwGW', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 13:53:24', '2016-05-01 13:53:24'),
  (38, 'admin@ajdmjintfhx.com', '$2y$10$tpU.G8mawQvrLAEvPsEm/u3uXKfpsu0h3tVXvsv2UWLT9Vri7wC1.', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 14:02:28', '2016-05-01 14:02:28'),
  (39, 'admin1@admin.com', '$2y$10$LWCNmqpRdS6PQA6Kq3VuOu7WIqKsSmQk6rgIGz.ICeTb8qvElTbmy', NULL, '2016-05-01 14:08:17', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 14:07:24', '2016-05-01 14:08:17'),
  (40, 'admin3@admin.com', '$2y$10$Jrnm/CmeA9oT6MGbEvRk4OIwjsZ8XnIo2/aBYyJaVLamo.3.RY/42', NULL, '2016-05-01 14:11:17', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 14:10:48', '2016-05-01 14:11:17'),
  (41, 'admin4@admin.com', '$2y$10$2HeUvzgoooi9tvSeEn3aRegPVXC4EnX4KYf0Ic8IDe/8WXSCjVZGu', NULL, NULL, ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 14:14:07', '2016-05-01 14:14:07'),
  (43, 'admin5@admin.com', '$2y$10$dTp2sKdyofdp4N.eS3scx.HRnSt6.cCkIdWysOAuDhKp5kI6SF2Ae', NULL, '2016-05-01 14:15:54', ' admin firstName', ' admin last_name', NULL, '', '', 0, '', '', '2016-05-01 14:14:43', '2016-05-01 14:15:54'),
  (44, 'admin6@admin.com', '$2y$10$zdBqpmXqpujNPalq6.W5meP0zIRuf/XYT1BkmuICJQHho1UO4BGPW', NULL, NULL, 'first', 'last', NULL, '', '', 0, '', '', '2016-05-01 14:17:26', '2016-12-26 10:00:02'),
  (64, 'abdalfattah.hammad@yahoo.com', '$2y$10$R6gGLALtsBIs7BWSkVzche5XURZ9k671XFbQ22g1Mrsmp.NW1YyGi', '', '2016-05-29 06:47:05', 'abdalfattah', 'hammad', NULL, '', '', 0, '', '', '2016-05-24 08:38:45', '2016-05-29 06:47:05'),
  (66, 'taylorsuccessor1@gmail.com', '$2y$10$FGuj819KqAmJNMIxi5qWne/qyvT8SpUhlrgGDJXkKjkYf597RgMby', '{\"user.denyLiveAccount\":true}', NULL, 'taylor', 'successor', NULL, '', '', 0, '', '', '2016-05-25 13:05:11', '2016-05-25 13:05:16'),
  (67, 'dfsa@ragf.com', '$2y$10$gMS96cK40k52LuVk7BDj2.lCjmrR.htpHH2jvZSw8Vsj/SEieeIoi', '{\"user.denyLiveAccount\":true}', NULL, 'weq', 'ewqrew', NULL, '', '', 0, '', '', '2016-05-29 11:28:02', '2016-05-29 11:28:06'),
  (68, 'sdaflh@dfs.com', '$2y$10$cE9o/HVrD0xKwQ435xf.o.FruuEBvkhtK9zzzO4wY.zAkiRRjeARG', '{\"user.denyLiveAccount\":true}', NULL, 'dfs', 'asfd', NULL, '', '', 0, '', '', '2016-05-29 11:29:44', '2016-05-29 11:29:49'),
  (70, 'taylorsuccessor2@gmail.com', '$2y$10$WOOk/daK6a37/0Z0vQStX.HmvuSJRF7jDQm3LBRPuLzKEECApIwTi', '{\"user.denyLiveAccount\":true}', NULL, 'sdf', 'sdfsdf', NULL, '', '', 0, '', '', '2016-06-12 10:40:00', '2016-06-12 10:40:05'),
  (71, 'taylorsuccessor3@gmail.com', '$2y$10$vEuPJ4u3ZzRIDaNwVTg.MObXT64Wjk840AF96e.EPbnY4nGR9H7Wq', '{\"user.denyLiveAccount\":true}', NULL, 'sdfs', 'dfgdfg', NULL, '', '', 0, '', '', '2016-06-12 10:42:49', '2016-06-12 10:42:54'),
  (72, 'taylorsuccessor4@gmail.com', '$2y$10$vyw6J2fgdFtchWsjQdV2EuhnEDmyfpX9p0Fb0SqH1LqgP6S0Uxxqu', '{\"user.denyLiveAccount\":true}', '2016-06-12 12:37:46', 'Test', '', NULL, '', '', 0, '', '', '2016-06-12 12:37:46', '2016-06-12 12:37:52'),
  (73, 'taylorsuccessor5@gmail.com', '$2y$10$aQ69hOigVigdEDLPIaJXO.KaXSkjVorqJv4hRNe1n.0cRhpF8hkT6', '{\"user.denyLiveAccount\":true}', '2016-06-12 12:46:28', 'Test', '', NULL, '', '', 0, '', '', '2016-06-12 12:46:27', '2016-06-12 12:46:33'),
  (74, 'taylorsuccessor6@gmail.com', '$2y$10$DOKqv/T4Hn6p6VCB496W8usXxtsdARnjMe/B6HsLCxcNWFmGvz9aq', '{\"user.denyLiveAccount\":true}', '2016-06-12 12:53:44', 'Test', '', NULL, '', '', 0, '', '', '2016-06-12 12:53:44', '2016-06-12 12:53:49'),
  (77, 'hbhuy', '$2y$10$SgJ2cJm/NXnCU0B.4/Ya3emRjKeBI77eHP7osCXYQfHdWNxvx7/kO', NULL, NULL, 'gfy', 'tyf', NULL, '', '', 0, '', '', '2017-03-22 03:59:03', '2017-03-22 03:59:03'),
  (78, 'vv', '$2y$10$g.bIACByPTjl.3GNq5TEm.XEdealK44IeAR8JSjcX4DZbXIshD7sm', NULL, NULL, 'vvvv', 'vvv', NULL, '', '', 0, '', '', '2017-03-22 21:43:26', '2017-03-22 21:43:26'),
  (79, 'test admin', '$2y$10$W4wwHxfeWRTX0N35zqpiru0tBjHGI6zLBsfaSmhGK3VWKoc3ieQ82', NULL, NULL, 'ffff', 'fffffff', NULL, '', '', 0, '', '', '2017-03-22 21:54:59', '2017-03-22 21:54:59'),
  (80, 'dfgsdfg', '$2y$10$vLQ5jLvll4mU0CA.6PNZM.qZzchaZ7BXdS03coY/SFEI2KlmqbUY.', NULL, NULL, 'dfgsdfg', 'gsdfg', NULL, '', '', 0, '', '', '2017-03-22 21:55:47', '2017-03-22 21:55:47'),
  (81, 'bbbbbbbbbb', '$2y$10$bBU./jpORO7jyZYlsNjeKubcu38Pv9PyDlYmQaHWaiL67Qvb5p7Fi', NULL, NULL, NULL, 'cvbcvb', NULL, '', '', 0, '', '', '2017-03-22 21:58:12', '2017-03-22 21:58:12'),
  (82, 'taylorsuccessor@gmail.com', '$2y$10$0FVcngb/PjS38n.tM6uhbORlYZI9NG6m.RdX.WJYVVhGnd6hiaEWq', NULL, '2017-05-21 14:11:45', 'taylor', 'successor', NULL, '', '', 0, '', '', '2017-05-20 12:18:06', '2017-05-21 14:11:45'),
  (83, 'asfd@sdf.sdf', 'admin', NULL, NULL, 'asdf', 'ksjdf', NULL, '', '', 0, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (85, 'asfd@sddsf.sdf', 'admin', NULL, NULL, 'asdf', 'ksjdf', NULL, '', '', 0, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (86, 'asfd@sddddsf.sdf', 'admin', NULL, NULL, 'asdf', 'ksjdf', NULL, '', '', 0, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (87, 'asfad@sddddsf.sdf', 'admin', NULL, NULL, 'asdf', 'ksjdf', NULL, '', '', 0, '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (88, 'asdf@sdf.sdf', 'admin', NULL, NULL, 'admin', 'adin', NULL, '234324', '234234', 0, '1', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (89, 'slkdfj@sdf.sdf', '$2y$10$sh.w238mR9.TxyQoQittrucX71gbfEhkdkCQRtLg2X6bBs8k1jPbK', NULL, NULL, 'aslkdfj', 'skldfj', NULL, '', '', 0, '', '', '2017-05-22 09:22:12', '2017-05-22 09:22:12');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `activations`
  --
  ALTER TABLE `activations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `address`
  --
  ALTER TABLE `address`
    ADD PRIMARY KEY (`id`),
    ADD KEY `area_id` (`area_id`);
  
  --
  -- Indexes for table `area`
  --
  ALTER TABLE `area`
    ADD PRIMARY KEY (`id`),
    ADD KEY `governorate_id` (`governorate_id`);
  
  --
  -- Indexes for table `banner`
  --
  ALTER TABLE `banner`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cart`
  --
  ALTER TABLE `cart`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`),
    ADD KEY `coffee_id` (`coffee_id`),
    ADD KEY `order_id` (`order_id`);
  
  --
  -- Indexes for table `category`
  --
  ALTER TABLE `category`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms`
  --
  ALTER TABLE `cms`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `columns_info`
  --
  ALTER TABLE `columns_info`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cuisine`
  --
  ALTER TABLE `cuisine`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `delivery_menu`
  --
  ALTER TABLE `delivery_menu`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `coffee`
  --
  ALTER TABLE `coffee`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`),
    ADD KEY `cuisine_id` (`cuisine_id`),
    ADD KEY `menu_section_id` (`menu_section_id`),
    ADD KEY `category_id` (`category_id`),
    ADD KEY `delivery_menu_id` (`delivery_menu_id`);
  
  --
  -- Indexes for table `coffee_rate`
  --
  ALTER TABLE `coffee_rate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `email_group`
  --
  ALTER TABLE `email_group`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `email_group_users`
  --
  ALTER TABLE `email_group_users`
    ADD PRIMARY KEY (`id`),
    ADD KEY `group_id` (`group_id`);
  
  --
  -- Indexes for table `email_mass_queue`
  --
  ALTER TABLE `email_mass_queue`
    ADD PRIMARY KEY (`id`),
    ADD KEY `email_group_id` (`email_group_id`);
  
  --
  -- Indexes for table `email_mass_template`
  --
  ALTER TABLE `email_mass_template`
    ADD PRIMARY KEY (`id`),
    ADD KEY `email_group_id` (`email_group_id`);
  
  --
  -- Indexes for table `email_template`
  --
  ALTER TABLE `email_template`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `governorate`
  --
  ALTER TABLE `governorate`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `menu_section`
  --
  ALTER TABLE `menu_section`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `operation_hour`
  --
  ALTER TABLE `operation_hour`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_area_id` (`shop_area_id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `order`
  --
  ALTER TABLE `order`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `order_driver`
  --
  ALTER TABLE `order_driver`
    ADD PRIMARY KEY (`id`),
    ADD KEY `order_id` (`order_id`);
  
  --
  -- Indexes for table `payment`
  --
  ALTER TABLE `payment`
    ADD PRIMARY KEY (`id`),
    ADD KEY `order_id` (`order_id`);
  
  --
  -- Indexes for table `persistences`
  --
  ALTER TABLE `persistences`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `persistences_code_unique` (`code`);
  
  --
  -- Indexes for table `reminders`
  --
  ALTER TABLE `reminders`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `shop`
  --
  ALTER TABLE `shop`
    ADD PRIMARY KEY (`id`),
    ADD KEY `area_id` (`area_id`);
  
  --
  -- Indexes for table `shop_area`
  --
  ALTER TABLE `shop_area`
    ADD PRIMARY KEY (`id`),
    ADD KEY `area_id` (`area_id`),
    ADD KEY `shop_id` (`shop_id`),
    ADD KEY `governorate_id` (`governorate_id`);
  
  --
  -- Indexes for table `shop_cuisine`
  --
  ALTER TABLE `shop_cuisine`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`),
    ADD KEY `cuisine_id` (`cuisine_id`);
  
  --
  -- Indexes for table `shop_rate`
  --
  ALTER TABLE `shop_rate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `shop_users`
  --
  ALTER TABLE `shop_users`
    ADD PRIMARY KEY (`id`),
    ADD KEY `shop_id` (`shop_id`);
  
  --
  -- Indexes for table `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `roles_slug_unique` (`slug`);
  
  --
  -- Indexes for table `role_users`
  --
  ALTER TABLE `role_users`
    ADD PRIMARY KEY (`user_id`,`role_id`);
  
  --
  -- Indexes for table `service_company`
  --
  ALTER TABLE `service_company`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `throttle`
  --
  ALTER TABLE `throttle`
    ADD PRIMARY KEY (`id`),
    ADD KEY `throttle_user_id_index` (`user_id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `activations`
  --
  ALTER TABLE `activations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;
  --
  -- AUTO_INCREMENT for table `address`
  --
  ALTER TABLE `address`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `area`
  --
  ALTER TABLE `area`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `banner`
  --
  ALTER TABLE `banner`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `cart`
  --
  ALTER TABLE `cart`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `category`
  --
  ALTER TABLE `category`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `cms`
  --
  ALTER TABLE `cms`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `columns_info`
  --
  ALTER TABLE `columns_info`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `cuisine`
  --
  ALTER TABLE `cuisine`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `delivery_menu`
  --
  ALTER TABLE `delivery_menu`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `coffee`
  --
  ALTER TABLE `coffee`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `coffee_rate`
  --
  ALTER TABLE `coffee_rate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `email_group`
  --
  ALTER TABLE `email_group`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `email_group_users`
  --
  ALTER TABLE `email_group_users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;
  --
  -- AUTO_INCREMENT for table `email_mass_queue`
  --
  ALTER TABLE `email_mass_queue`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `email_mass_template`
  --
  ALTER TABLE `email_mass_template`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `email_template`
  --
  ALTER TABLE `email_template`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `governorate`
  --
  ALTER TABLE `governorate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `menu_section`
  --
  ALTER TABLE `menu_section`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `operation_hour`
  --
  ALTER TABLE `operation_hour`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `order`
  --
  ALTER TABLE `order`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `order_driver`
  --
  ALTER TABLE `order_driver`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `payment`
  --
  ALTER TABLE `payment`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `persistences`
  --
  ALTER TABLE `persistences`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=942;
  --
  -- AUTO_INCREMENT for table `reminders`
  --
  ALTER TABLE `reminders`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  --
  -- AUTO_INCREMENT for table `shop`
  --
  ALTER TABLE `shop`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `shop_area`
  --
  ALTER TABLE `shop_area`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `shop_cuisine`
  --
  ALTER TABLE `shop_cuisine`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `shop_rate`
  --
  ALTER TABLE `shop_rate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `shop_users`
  --
  ALTER TABLE `shop_users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  --
  -- AUTO_INCREMENT for table `service_company`
  --
  ALTER TABLE `service_company`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `throttle`
  --
  ALTER TABLE `throttle`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `address`
  --
  ALTER TABLE `address`
    ADD CONSTRAINT `address_ibfk_1` FOREIGN KEY (`area_id`) REFERENCES `area` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `area`
  --
  ALTER TABLE `area`
    ADD CONSTRAINT `area_ibfk_1` FOREIGN KEY (`governorate_id`) REFERENCES `governorate` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `cart`
  --
  ALTER TABLE `cart`
    ADD CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`coffee_id`) REFERENCES `coffee` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `cart_ibfk_3` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `delivery_menu`
  --
  ALTER TABLE `delivery_menu`
    ADD CONSTRAINT `delivery_menu_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `coffee`
  --
  ALTER TABLE `coffee`
    ADD CONSTRAINT `coffee_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `coffee_ibfk_2` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisine` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `coffee_ibfk_3` FOREIGN KEY (`menu_section_id`) REFERENCES `menu_section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `coffee_ibfk_4` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `coffee_ibfk_5` FOREIGN KEY (`delivery_menu_id`) REFERENCES `delivery_menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `coffee_rate`
  --
  ALTER TABLE `coffee_rate`
    ADD CONSTRAINT `coffee_rate_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `email_group_users`
  --
  ALTER TABLE `email_group_users`
    ADD CONSTRAINT `email_group_users_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `email_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `email_mass_queue`
  --
  ALTER TABLE `email_mass_queue`
    ADD CONSTRAINT `email_mass_queue_ibfk_1` FOREIGN KEY (`email_group_id`) REFERENCES `email_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `email_mass_template`
  --
  ALTER TABLE `email_mass_template`
    ADD CONSTRAINT `email_mass_template_ibfk_1` FOREIGN KEY (`email_group_id`) REFERENCES `email_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `menu_section`
  --
  ALTER TABLE `menu_section`
    ADD CONSTRAINT `menu_section_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `operation_hour`
  --
  ALTER TABLE `operation_hour`
    ADD CONSTRAINT `operation_hour_ibfk_1` FOREIGN KEY (`shop_area_id`) REFERENCES `shop_area` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `operation_hour_ibfk_2` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `order_driver`
  --
  ALTER TABLE `order_driver`
    ADD CONSTRAINT `order_driver_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `payment`
  --
  ALTER TABLE `payment`
    ADD CONSTRAINT `payment_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `shop_area`
  --
  ALTER TABLE `shop_area`
    ADD CONSTRAINT `shop_area_ibfk_1` FOREIGN KEY (`area_id`) REFERENCES `area` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `shop_area_ibfk_2` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `shop_area_ibfk_3` FOREIGN KEY (`governorate_id`) REFERENCES `governorate` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `shop_cuisine`
  --
  ALTER TABLE `shop_cuisine`
    ADD CONSTRAINT `shop_cuisine_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `shop_cuisine_ibfk_2` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisine` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `shop_rate`
  --
  ALTER TABLE `shop_rate`
    ADD CONSTRAINT `shop_rate_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `shop_users`
  --
  ALTER TABLE `shop_users`
    ADD CONSTRAINT `shop_users_ibfk_1` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  /*!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 */;
  