text: -- phpMyAdmin SQL Dump
  -- version 4.8.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: May 04, 2019 at 04:52 PM
  -- Server version: 10.1.33-MariaDB
  -- PHP Version: 7.2.6
  
  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: `chefqu_structure`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `addresses`
  --
  
  CREATE TABLE `addresses` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000',
    `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000',
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `bank_details`
  --
  
  CREATE TABLE `bank_details` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `account_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ifsc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `coupons`
  --
  
  CREATE TABLE `coupons` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `reward` int(11) NOT NULL,
    `type` enum('fixed','percent') COLLATE utf8mb4_unicode_ci NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci,
    `expires_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `coupons_users`
  --
  
  CREATE TABLE `coupons_users` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `coupon_id` int(10) UNSIGNED NOT NULL,
    `used_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_order_requests`
  --
  
  CREATE TABLE `delivery_order_requests` (
    `id` int(10) UNSIGNED NOT NULL,
    `delivery_profile_id` int(10) UNSIGNED NOT NULL,
    `order_id` int(10) UNSIGNED NOT NULL,
    `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_profiles`
  --
  
  CREATE TABLE `delivery_profiles` (
    `id` int(10) UNSIGNED NOT NULL,
    `is_online` tinyint(1) NOT NULL DEFAULT '0',
    `longitude` decimal(15,7) DEFAULT NULL,
    `latitude` decimal(15,7) DEFAULT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `assigned` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_by` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `earnings`
  --
  
  CREATE TABLE `earnings` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(10) UNSIGNED NOT NULL,
    `amount` double(8,2) NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `paid` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `favourites`
  --
  
  CREATE TABLE `favourites` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `store_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `favourite_drivers`
  --
  
  CREATE TABLE `favourite_drivers` (
    `id` int(10) UNSIGNED NOT NULL,
    `delivery_profile_id` int(10) UNSIGNED NOT NULL,
    `store_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `jobs`
  --
  
  CREATE TABLE `jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `attempts` tinyint(3) UNSIGNED NOT NULL,
    `reserved_at` int(10) UNSIGNED DEFAULT NULL,
    `available_at` int(10) UNSIGNED NOT NULL,
    `created_at` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menu_items`
  --
  
  CREATE TABLE `menu_items` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `detail` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `specification` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` double(8,2) NOT NULL,
    `is_available` tinyint(1) NOT NULL DEFAULT '1',
    `is_non_veg` tinyint(1) NOT NULL,
    `status` enum('pending','rejected','approved') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'approved',
    `store_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menu_items_categories`
  --
  
  CREATE TABLE `menu_items_categories` (
    `menu_item_id` int(10) UNSIGNED NOT NULL,
    `category_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menu_item_choices`
  --
  
  CREATE TABLE `menu_item_choices` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` double(8,2) NOT NULL,
    `menu_item_group_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `menu_item_groups`
  --
  
  CREATE TABLE `menu_item_groups` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `max_choices` int(10) UNSIGNED NOT NULL,
    `min_choices` int(10) UNSIGNED NOT NULL,
    `menu_item_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
  (2, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
  (3, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
  (4, '2016_06_01_000004_create_oauth_clients_table', 1),
  (5, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
  (6, '2017_04_10_000000_create_users_table', 1),
  (7, '2017_04_10_000001_create_password_resets_table', 1),
  (8, '2017_04_10_000002_create_social_accounts_table', 1),
  (9, '2017_04_10_000003_create_roles_table', 1),
  (10, '2017_04_10_000004_create_users_roles_table', 1),
  (11, '2018_02_20_113000_create_wallets_table', 1),
  (12, '2018_02_20_113500_create_wallet_transactions_table', 1),
  (13, '2018_02_22_063651_create_delivery_profiles_table', 1),
  (14, '2018_02_22_110052_create_categories_table', 1),
  (15, '2018_02_23_022539_create_payment_methods_table', 1),
  (16, '2018_02_23_032249_create_stores_table', 1),
  (17, '2018_02_24_114833_create_ratings_table', 1),
  (18, '2018_02_24_115600_create_menu_items_table', 1),
  (19, '2018_02_24_120748_create_addresses_table', 1),
  (20, '2018_02_24_120947_create_orders_table', 1),
  (21, '2018_02_24_121440_create_order_items_table', 1),
  (22, '2018_02_24_123301_create_bank_details_table', 1),
  (23, '2018_02_24_123956_create_supports_table', 1),
  (24, '2018_02_25_000004_create_menu_items_categories_table', 1),
  (25, '2018_02_25_000004_create_stores_categories_table', 1),
  (26, '2018_03_18_000004_create_favourites_table', 1),
  (27, '2018_03_22_183956_create_earnings_table', 1),
  (28, '2018_03_22_183956_create_settings_table', 1),
  (29, '2018_03_25_183956_create_order_status_logs_table', 1),
  (30, '2018_06_07_123211_plans', 1),
  (31, '2018_06_20_103955_create_coupons_table', 1),
  (32, '2018_07_05_103955_alter_orders_add_scheduling', 1),
  (33, '2018_07_17_215919_create_notifications_table', 1),
  (34, '2018_07_18_141022_create_jobs_table', 1),
  (35, '2018_07_27_064511_create_menu_item_groups_table', 1),
  (36, '2018_07_27_065511_create_menu_item_choices_table', 1),
  (37, '2018_07_27_066440_create_order_item_choices_table', 1),
  (38, '2018_07_27_075511_create_delivery_order_requests_table', 1),
  (39, '2018_07_28_103955_alter_delivery_profiles_add_created_by', 1),
  (40, '2018_07_28_103955_alter_orders_add_reject_reason', 1),
  (41, '2018_07_28_104955_alter_stores_add_delivery_preference', 1),
  (42, '2018_07_28_105955_create_favourite_drivers_table', 1),
  (43, '2018_07_28_106955_create_transactions_table', 1),
  (44, '2018_07_28_107955_alter_users_refer_code_table', 1),
  (45, '2018_07_28_108955_alter_transactions_table', 1),
  (46, '2018_07_28_109901_create_refer_table', 1),
  (47, '2019_06_07_123211_plans_metadata', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notifications`
  --
  
  CREATE TABLE `notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` bigint(20) UNSIGNED NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_access_tokens`
  --
  
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `client_id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_auth_codes`
  --
  
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `client_id` int(10) UNSIGNED NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_clients`
  --
  
  CREATE TABLE `oauth_clients` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `oauth_clients`
  --
  
  INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  (1, NULL, 'FoodMall Personal Access Client', 'MEjRSZlQkq8sN84Fme00GUghmtXlZVT1UDv02Igv', 'http://localhost', 1, 0, 0, '2019-05-04 09:21:51', '2019-05-04 09:21:51'),
  (2, NULL, 'FoodMall Password Grant Client', 'BNncKk9A45QWYCZPK1cdEdaBxnrBmfVAjciIZl98', 'http://localhost', 0, 1, 0, '2019-05-04 09:21:51', '2019-05-04 09:21:51');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_personal_access_clients`
  --
  
  CREATE TABLE `oauth_personal_access_clients` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `oauth_personal_access_clients`
  --
  
  INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
  (1, 1, '2019-05-04 09:21:51', '2019-05-04 09:21:51');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_refresh_tokens`
  --
  
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `orders`
  --
  
  CREATE TABLE `orders` (
    `id` int(10) UNSIGNED NOT NULL,
    `subtotal` double(8,2) NOT NULL,
    `taxes` double(8,2) NOT NULL,
    `delivery_fee` double(8,2) NOT NULL,
    `total` double(8,2) NOT NULL,
    `discount` double(8,2) NOT NULL,
    `status` enum('new','pending','cancelled','accepted','rejected','preparing','dispatched','intransit','complete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
    `delivery_status` enum('pending','allotted','started','cancelled','complete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
    `payment_status` enum('unpaid','paid') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
    `payment_method_id` int(10) UNSIGNED NOT NULL,
    `special_instructions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address_id` int(10) UNSIGNED NOT NULL,
    `store_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `delivery_profile_id` int(10) UNSIGNED DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `type` enum('ASAP','LATER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ASAP',
    `scheduled_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `reject_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `order_items`
  --
  
  CREATE TABLE `order_items` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(10) UNSIGNED NOT NULL,
    `menu_item_id` int(10) UNSIGNED NOT NULL,
    `quantity` int(10) UNSIGNED NOT NULL,
    `total` double(8,2) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `order_item_choices`
  --
  
  CREATE TABLE `order_item_choices` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(10) UNSIGNED NOT NULL,
    `menu_item_id` int(10) UNSIGNED NOT NULL,
    `menu_item_choice_id` int(10) UNSIGNED NOT NULL,
    `total` double(8,2) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `order_status_logs`
  --
  
  CREATE TABLE `order_status_logs` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(10) UNSIGNED NOT NULL,
    `status` enum('new','pending','cancelled','accepted','rejected','preparing','dispatched','intransit','complete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment_methods`
  --
  
  CREATE TABLE `payment_methods` (
    `id` int(10) UNSIGNED NOT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `payment_methods`
  --
  
  INSERT INTO `payment_methods` (`id`, `slug`, `title`, `created_at`, `updated_at`) VALUES
  (1, 'cod', 'COD', NULL, NULL),
  (2, 'stripe', 'Credit/Debit Card', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `plans`
  --
  
  CREATE TABLE `plans` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `price` double(8,2) NOT NULL,
    `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `duration` int(11) NOT NULL DEFAULT '30',
    `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `plans`
  --
  
  INSERT INTO `plans` (`id`, `name`, `description`, `price`, `currency`, `duration`, `metadata`, `created_at`, `updated_at`) VALUES
  (1, 'Super Saver', 'Super Saver', 1200.00, 'INR', 365, NULL, '2019-05-04 09:21:40', '2019-05-04 09:21:40'),
  (2, 'Popular', 'Popular', 450.00, 'INR', 90, NULL, '2019-05-04 09:21:40', '2019-05-04 09:21:40'),
  (3, 'Standard', 'Standard', 200.00, 'INR', 30, NULL, '2019-05-04 09:21:40', '2019-05-04 09:21:40');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `plans_features`
  --
  
  CREATE TABLE `plans_features` (
    `id` int(10) UNSIGNED NOT NULL,
    `plan_id` int(11) NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci,
    `type` enum('feature','limit') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'feature',
    `limit` int(11) NOT NULL DEFAULT '0',
    `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `plans_subscriptions`
  --
  
  CREATE TABLE `plans_subscriptions` (
    `id` int(10) UNSIGNED NOT NULL,
    `plan_id` int(11) NOT NULL,
    `model_id` int(11) NOT NULL,
    `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_method` enum('stripe') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_paid` tinyint(1) NOT NULL DEFAULT '0',
    `charging_price` double(8,2) DEFAULT NULL,
    `charging_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_recurring` tinyint(1) NOT NULL DEFAULT '1',
    `recurring_each_days` int(11) NOT NULL DEFAULT '30',
    `starts_on` timestamp NULL DEFAULT NULL,
    `expires_on` timestamp NULL DEFAULT NULL,
    `cancelled_on` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `plans_usages`
  --
  
  CREATE TABLE `plans_usages` (
    `id` int(10) UNSIGNED NOT NULL,
    `subscription_id` int(11) NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `used` double(9,2) NOT NULL DEFAULT '0.00',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `ratings`
  --
  
  CREATE TABLE `ratings` (
    `id` int(10) UNSIGNED NOT NULL,
    `rating` int(10) UNSIGNED NOT NULL,
    `review` varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
    `store_id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `refer`
  --
  
  CREATE TABLE `refer` (
    `id` int(10) UNSIGNED NOT NULL,
    `referrer` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `weight` smallint(5) UNSIGNED NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `weight`) VALUES
  (1, 'administrator', 0),
  (2, 'authenticated', 0),
  (3, 'owner', 0),
  (4, 'delivery', 0),
  (5, 'customer', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` text COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `settings`
  --
  
  INSERT INTO `settings` (`id`, `key`, `value`) VALUES
  (1, 'currency', 'INR'),
  (2, 'delivery_fee', '25'),
  (3, 'admin_fee_subscription_or_per_order', 'per_order'),
  (4, 'admin_fee_for_order_in_percent', '10'),
  (5, 'tax_in_percent', '10'),
  (6, 'support_email', 'admin@example.com'),
  (7, 'support_phone', '8181818118'),
  (8, 'send_welcome_email', '1'),
  (9, 'send_order_placed_email', '1'),
  (10, 'send_order_complete_email', '1'),
  (11, 'cod_enabled', '1'),
  (12, 'refer_amount', '50'),
  (13, 'delivery_fee_set_by', 'admin'),
  (14, 'delivery_fee_per_km_charge', '5'),
  (15, 'admin_fee_for_order_in_packet', '10'),;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `social_accounts`
  --
  
  CREATE TABLE `social_accounts` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `provider` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
    `provider_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stores`
  --
  
  CREATE TABLE `stores` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `tagline` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `delivery_time` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `minimum_order` int(10) UNSIGNED NOT NULL DEFAULT '200',
    `delivery_fee` int(10) UNSIGNED NOT NULL DEFAULT '25',
    `details` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `delivery_limit` int(11) NOT NULL DEFAULT '8000',
    `area` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `longitude` decimal(15,7) NOT NULL DEFAULT '0.0000000',
    `latitude` decimal(15,7) NOT NULL DEFAULT '0.0000000',
    `preorder` tinyint(1) NOT NULL DEFAULT '1',
    `serves_non_veg` tinyint(1) NOT NULL DEFAULT '1',
    `cost_for_two` int(11) NOT NULL DEFAULT '250',
    `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
    `opens_at` time NOT NULL DEFAULT '12:00:00',
    `closes_at` time NOT NULL DEFAULT '23:00:00',
    `owner_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `delivery_preference` enum('any','favourite','owner') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'any'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stores_categories`
  --
  
  CREATE TABLE `stores_categories` (
    `store_id` int(10) UNSIGNED NOT NULL,
    `category_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stripe_customers`
  --
  
  CREATE TABLE `stripe_customers` (
    `id` int(10) UNSIGNED NOT NULL,
    `model_id` int(11) NOT NULL,
    `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `customer_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `supports`
  --
  
  CREATE TABLE `supports` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transactions`
  --
  
  CREATE TABLE `transactions` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` enum('debit','credit') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `amount` double DEFAULT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `is_paid` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `order_id` int(10) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `mobile_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `otp_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mobile_verified` tinyint(1) NOT NULL DEFAULT '0',
    `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
    `confirmation_code` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `confirmed` tinyint(1) NOT NULL DEFAULT '1',
    `fcm_registration_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    `refer_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `mobile_number`, `otp_code`, `mobile_verified`, `active`, `confirmation_code`, `confirmed`, `fcm_registration_id`, `remember_token`, `created_at`, `updated_at`, `deleted_at`, `refer_code`) VALUES
  (1, 'Admin', 'admin@example.com', '$2y$10$zl4EKGhsrgsCXjRHj6Zv6.YZU9hdS71WeRMa6JTYk3X1TsmC2XUMW', '8888888888', NULL, 1, 1, '69712aaf-c8ac-43df-bfc8-b014075a1d23', 1, NULL, NULL, '2019-05-04 09:21:39', '2019-05-04 09:21:39', NULL, NULL),
  (2, 'Demo', 'demo.laravel@labs64.com', '$2y$10$19WWseoki5gXT4s7SxCRE.UGghVwTlu1uvFa.kz/1TE2UGacsS/Gm', '9999999999', NULL, 1, 1, '0ad191fa-fad8-492a-b3c4-281fdb9a4f0c', 1, NULL, NULL, '2019-05-04 09:21:39', '2019-05-04 09:21:39', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_roles`
  --
  
  CREATE TABLE `users_roles` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users_roles`
  --
  
  INSERT INTO `users_roles` (`user_id`, `role_id`) VALUES
  (1, 1),
  (1, 2),
  (2, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `wallets`
  --
  
  CREATE TABLE `wallets` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED DEFAULT NULL,
    `balance` bigint(20) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `wallet_transactions`
  --
  
  CREATE TABLE `wallet_transactions` (
    `id` int(10) UNSIGNED NOT NULL,
    `wallet_id` int(10) UNSIGNED NOT NULL,
    `amount` int(11) NOT NULL,
    `hash` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
    `accepted` tinyint(1) NOT NULL,
    `meta` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `addresses`
  --
  ALTER TABLE `addresses`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_address_user` (`user_id`);
  
  --
  -- Indexes for table `bank_details`
  --
  ALTER TABLE `bank_details`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_bank_user` (`user_id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `coupons`
  --
  ALTER TABLE `coupons`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `coupons_code_unique` (`code`);
  
  --
  -- Indexes for table `coupons_users`
  --
  ALTER TABLE `coupons_users`
    ADD PRIMARY KEY (`user_id`,`coupon_id`),
    ADD KEY `foreign_coupons_users_coupon` (`coupon_id`);
  
  --
  -- Indexes for table `delivery_order_requests`
  --
  ALTER TABLE `delivery_order_requests`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `delivery_order_requests_delivery_profile_id_order_id_unique` (`delivery_profile_id`,`order_id`),
    ADD KEY `order_request_foreign_order` (`order_id`);
  
  --
  -- Indexes for table `delivery_profiles`
  --
  ALTER TABLE `delivery_profiles`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_delivery_user` (`user_id`),
    ADD KEY `foreign_delivery_profiles_created_by` (`created_by`);
  
  --
  -- Indexes for table `earnings`
  --
  ALTER TABLE `earnings`
    ADD PRIMARY KEY (`id`),
    ADD KEY `earnings_foreign_order` (`order_id`),
    ADD KEY `earnings_foreign_user` (`user_id`);
  
  --
  -- Indexes for table `favourites`
  --
  ALTER TABLE `favourites`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `favourites_user_id_store_id_unique` (`user_id`,`store_id`),
    ADD KEY `foreign_favourite_store` (`store_id`);
  
  --
  -- Indexes for table `favourite_drivers`
  --
  ALTER TABLE `favourite_drivers`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `favourite_drivers_delivery_profile_id_store_id_unique` (`delivery_profile_id`,`store_id`),
    ADD KEY `foreign_favourite_drivers_store` (`store_id`);
  
  --
  -- Indexes for table `jobs`
  --
  ALTER TABLE `jobs`
    ADD PRIMARY KEY (`id`),
    ADD KEY `jobs_queue_index` (`queue`);
  
  --
  -- Indexes for table `menu_items`
  --
  ALTER TABLE `menu_items`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_item_store` (`store_id`);
  
  --
  -- Indexes for table `menu_items_categories`
  --
  ALTER TABLE `menu_items_categories`
    ADD UNIQUE KEY `menu_items_categories_menu_item_id_category_id_unique` (`menu_item_id`,`category_id`),
    ADD KEY `foreign_pivot_category_menu_item` (`category_id`);
  
  --
  -- Indexes for table `menu_item_choices`
  --
  ALTER TABLE `menu_item_choices`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_choice_group` (`menu_item_group_id`);
  
  --
  -- Indexes for table `menu_item_groups`
  --
  ALTER TABLE `menu_item_groups`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_group_menu_item` (`menu_item_id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notifications`
  --
  ALTER TABLE `notifications`
    ADD PRIMARY KEY (`id`),
    ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);
  
  --
  -- Indexes for table `oauth_access_tokens`
  --
  ALTER TABLE `oauth_access_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
  
  --
  -- Indexes for table `oauth_auth_codes`
  --
  ALTER TABLE `oauth_auth_codes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_clients_user_id_index` (`user_id`);
  
  --
  -- Indexes for table `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);
  
  --
  -- Indexes for table `oauth_refresh_tokens`
  --
  ALTER TABLE `oauth_refresh_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
  
  --
  -- Indexes for table `orders`
  --
  ALTER TABLE `orders`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_orders_payment_method` (`payment_method_id`),
    ADD KEY `foreign_orders_store` (`store_id`),
    ADD KEY `foreign_orders_user` (`user_id`),
    ADD KEY `foreign_orders_delivery` (`delivery_profile_id`),
    ADD KEY `foreign_orders_address` (`address_id`);
  
  --
  -- Indexes for table `order_items`
  --
  ALTER TABLE `order_items`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_order` (`order_id`),
    ADD KEY `foreign_menu_item` (`menu_item_id`);
  
  --
  -- Indexes for table `order_item_choices`
  --
  ALTER TABLE `order_item_choices`
    ADD PRIMARY KEY (`id`),
    ADD KEY `order_item_choices_foreign_order` (`order_id`),
    ADD KEY `order_item_choices_foreign_menu_item` (`menu_item_id`);
  
  --
  -- Indexes for table `order_status_logs`
  --
  ALTER TABLE `order_status_logs`
    ADD PRIMARY KEY (`id`),
    ADD KEY `order_status_logs_foreign_order` (`order_id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `payment_methods`
  --
  ALTER TABLE `payment_methods`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `payment_methods_slug_unique` (`slug`);
  
  --
  -- Indexes for table `plans`
  --
  ALTER TABLE `plans`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `plans_features`
  --
  ALTER TABLE `plans_features`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `plans_subscriptions`
  --
  ALTER TABLE `plans_subscriptions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `plans_usages`
  --
  ALTER TABLE `plans_usages`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `ratings`
  --
  ALTER TABLE `ratings`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_ratings_store` (`store_id`),
    ADD KEY `foreign_ratings_user` (`user_id`);
  
  --
  -- Indexes for table `refer`
  --
  ALTER TABLE `refer`
    ADD PRIMARY KEY (`id`),
    ADD KEY `refer_foreign_referrer` (`referrer`),
    ADD KEY `refer_foreign_user` (`user_id`);
  
  --
  -- Indexes for table `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `unique_name` (`name`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `settings_key_unique` (`key`);
  
  --
  -- Indexes for table `social_accounts`
  --
  ALTER TABLE `social_accounts`
    ADD PRIMARY KEY (`id`),
    ADD KEY `social_accounts_user_id_provider_provider_id_index` (`user_id`,`provider`,`provider_id`);
  
  --
  -- Indexes for table `stores`
  --
  ALTER TABLE `stores`
    ADD PRIMARY KEY (`id`),
    ADD KEY `foreign_stores_user` (`owner_id`);
  
  --
  -- Indexes for table `stores_categories`
  --
  ALTER TABLE `stores_categories`
    ADD UNIQUE KEY `stores_categories_store_id_category_id_unique` (`store_id`,`category_id`),
    ADD KEY `foreign_pivot_category_store` (`category_id`);
  
  --
  -- Indexes for table `stripe_customers`
  --
  ALTER TABLE `stripe_customers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `supports`
  --
  ALTER TABLE `supports`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `transactions`
  --
  ALTER TABLE `transactions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `transactions_foreign_user` (`user_id`),
    ADD KEY `transactions_foreign_order` (`order_id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`),
    ADD UNIQUE KEY `users_mobile_number_unique` (`mobile_number`);
  
  --
  -- Indexes for table `users_roles`
  --
  ALTER TABLE `users_roles`
    ADD UNIQUE KEY `users_roles_user_id_role_id_unique` (`user_id`,`role_id`),
    ADD KEY `foreign_role` (`role_id`);
  
  --
  -- Indexes for table `wallets`
  --
  ALTER TABLE `wallets`
    ADD PRIMARY KEY (`id`),
    ADD KEY `wallets_user_id_foreign` (`user_id`);
  
  --
  -- Indexes for table `wallet_transactions`
  --
  ALTER TABLE `wallet_transactions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `wallet_transactions_wallet_id_foreign` (`wallet_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `addresses`
  --
  ALTER TABLE `addresses`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `bank_details`
  --
  ALTER TABLE `bank_details`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `coupons`
  --
  ALTER TABLE `coupons`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `delivery_order_requests`
  --
  ALTER TABLE `delivery_order_requests`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `delivery_profiles`
  --
  ALTER TABLE `delivery_profiles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `earnings`
  --
  ALTER TABLE `earnings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `favourites`
  --
  ALTER TABLE `favourites`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `favourite_drivers`
  --
  ALTER TABLE `favourite_drivers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `jobs`
  --
  ALTER TABLE `jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `menu_items`
  --
  ALTER TABLE `menu_items`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `menu_item_choices`
  --
  ALTER TABLE `menu_item_choices`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `menu_item_groups`
  --
  ALTER TABLE `menu_item_groups`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;
  
  --
  -- AUTO_INCREMENT for table `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `orders`
  --
  ALTER TABLE `orders`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `order_items`
  --
  ALTER TABLE `order_items`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `order_item_choices`
  --
  ALTER TABLE `order_item_choices`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `order_status_logs`
  --
  ALTER TABLE `order_status_logs`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `payment_methods`
  --
  ALTER TABLE `payment_methods`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `plans`
  --
  ALTER TABLE `plans`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `plans_features`
  --
  ALTER TABLE `plans_features`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `plans_subscriptions`
  --
  ALTER TABLE `plans_subscriptions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `plans_usages`
  --
  ALTER TABLE `plans_usages`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `ratings`
  --
  ALTER TABLE `ratings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `refer`
  --
  ALTER TABLE `refer`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- AUTO_INCREMENT for table `social_accounts`
  --
  ALTER TABLE `social_accounts`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `stores`
  --
  ALTER TABLE `stores`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `stripe_customers`
  --
  ALTER TABLE `stripe_customers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `supports`
  --
  ALTER TABLE `supports`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `transactions`
  --
  ALTER TABLE `transactions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `wallets`
  --
  ALTER TABLE `wallets`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `wallet_transactions`
  --
  ALTER TABLE `wallet_transactions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `addresses`
  --
  ALTER TABLE `addresses`
    ADD CONSTRAINT `foreign_address_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `bank_details`
  --
  ALTER TABLE `bank_details`
    ADD CONSTRAINT `foreign_bank_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `coupons_users`
  --
  ALTER TABLE `coupons_users`
    ADD CONSTRAINT `foreign_coupons_users_coupon` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`),
    ADD CONSTRAINT `foreign_coupons_users_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
  
  --
  -- Constraints for table `delivery_order_requests`
  --
  ALTER TABLE `delivery_order_requests`
    ADD CONSTRAINT `order_request_foreign_delivery_profile` FOREIGN KEY (`delivery_profile_id`) REFERENCES `delivery_profiles` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `order_request_foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `delivery_profiles`
  --
  ALTER TABLE `delivery_profiles`
    ADD CONSTRAINT `foreign_delivery_profiles_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_delivery_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `earnings`
  --
  ALTER TABLE `earnings`
    ADD CONSTRAINT `earnings_foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `earnings_foreign_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `favourites`
  --
  ALTER TABLE `favourites`
    ADD CONSTRAINT `foreign_favourite_store` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_favourite_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `favourite_drivers`
  --
  ALTER TABLE `favourite_drivers`
    ADD CONSTRAINT `foreign_favourite_drivers_delivery` FOREIGN KEY (`delivery_profile_id`) REFERENCES `delivery_profiles` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_favourite_drivers_store` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `menu_items`
  --
  ALTER TABLE `menu_items`
    ADD CONSTRAINT `foreign_item_store` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `menu_items_categories`
  --
  ALTER TABLE `menu_items_categories`
    ADD CONSTRAINT `foreign_pivot_category_menu_item` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_pivot_menu_item_category` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `menu_item_choices`
  --
  ALTER TABLE `menu_item_choices`
    ADD CONSTRAINT `foreign_choice_group` FOREIGN KEY (`menu_item_group_id`) REFERENCES `menu_item_groups` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `menu_item_groups`
  --
  ALTER TABLE `menu_item_groups`
    ADD CONSTRAINT `foreign_group_menu_item` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `orders`
  --
  ALTER TABLE `orders`
    ADD CONSTRAINT `foreign_orders_address` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_orders_delivery` FOREIGN KEY (`delivery_profile_id`) REFERENCES `delivery_profiles` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_orders_payment_method` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_orders_store` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_orders_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `order_items`
  --
  ALTER TABLE `order_items`
    ADD CONSTRAINT `foreign_menu_item` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `order_item_choices`
  --
  ALTER TABLE `order_item_choices`
    ADD CONSTRAINT `order_item_choices_foreign_menu_item` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `order_item_choices_foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `order_status_logs`
  --
  ALTER TABLE `order_status_logs`
    ADD CONSTRAINT `order_status_logs_foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `ratings`
  --
  ALTER TABLE `ratings`
    ADD CONSTRAINT `foreign_ratings_store` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_ratings_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `refer`
  --
  ALTER TABLE `refer`
    ADD CONSTRAINT `refer_foreign_referrer` FOREIGN KEY (`referrer`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `refer_foreign_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `social_accounts`
  --
  ALTER TABLE `social_accounts`
    ADD CONSTRAINT `social_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `stores`
  --
  ALTER TABLE `stores`
    ADD CONSTRAINT `foreign_stores_user` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `stores_categories`
  --
  ALTER TABLE `stores_categories`
    ADD CONSTRAINT `foreign_pivot_category_store` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_pivot_store_category` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `transactions`
  --
  ALTER TABLE `transactions`
    ADD CONSTRAINT `transactions_foreign_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `transactions_foreign_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `users_roles`
  --
  ALTER TABLE `users_roles`
    ADD CONSTRAINT `foreign_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `foreign_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `wallets`
  --
  ALTER TABLE `wallets`
    ADD CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
  
  --
  -- Constraints for table `wallet_transactions`
  --
  ALTER TABLE `wallet_transactions`
    ADD CONSTRAINT `wallet_transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;
  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 */;
  