Da

✏️ Editing: appalorg_rest.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: appalorg_rest
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `appalorg_rest`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `appalorg_rest` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `appalorg_rest`;

--
-- Table structure for table `account_transactions`
--

DROP TABLE IF EXISTS `account_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_type` varchar(191) NOT NULL,
  `from_id` bigint(20) NOT NULL,
  `current_balance` decimal(24,2) NOT NULL,
  `amount` decimal(24,2) NOT NULL,
  `method` varchar(191) NOT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'collected',
  `created_by` varchar(20) NOT NULL DEFAULT 'admin',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account_transactions`
--

LOCK TABLES `account_transactions` WRITE;
/*!40000 ALTER TABLE `account_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `add_ons`
--

DROP TABLE IF EXISTS `add_ons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `add_ons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `price` decimal(24,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `add_ons`
--

LOCK TABLES `add_ons` WRITE;
/*!40000 ALTER TABLE `add_ons` DISABLE KEYS */;
INSERT INTO `add_ons` VALUES (1,'Water',10.00,'2023-09-08 16:47:03','2023-09-08 16:47:03',1,1);
/*!40000 ALTER TABLE `add_ons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `addon_settings`
--

DROP TABLE IF EXISTS `addon_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addon_settings` (
  `id` char(36) NOT NULL,
  `key_name` varchar(191) DEFAULT NULL,
  `live_values` longtext DEFAULT NULL,
  `test_values` longtext DEFAULT NULL,
  `settings_type` varchar(255) DEFAULT NULL,
  `mode` varchar(20) NOT NULL DEFAULT 'live',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_settings_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `addon_settings`
--

LOCK TABLES `addon_settings` WRITE;
/*!40000 ALTER TABLE `addon_settings` DISABLE KEYS */;
INSERT INTO `addon_settings` VALUES ('070c6bbd-d777-11ed-96f4-0c7a158e4469','twilio','{\"gateway\":\"twilio\",\"mode\":\"live\",\"status\":\"0\",\"sid\":null,\"messaging_service_sid\":null,\"token\":null,\"from\":null,\"otp_template\":null}','{\"gateway\":\"twilio\",\"mode\":\"live\",\"status\":\"0\",\"sid\":null,\"messaging_service_sid\":null,\"token\":null,\"from\":null,\"otp_template\":null}','sms_config','live',1,NULL,'2023-08-12 07:01:29',NULL),('070c766c-d777-11ed-96f4-0c7a158e4469','2factor','{\"gateway\":\"2factor\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null}','{\"gateway\":\"2factor\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null}','sms_config','live',1,NULL,'2023-08-12 07:01:36',NULL),('0d8a9308-d6a5-11ed-962c-0c7a158e4469','mercadopago','{\"gateway\":\"mercadopago\",\"mode\":\"test\",\"status\":0,\"access_token\":null,\"public_key\":null}','{\"gateway\":\"mercadopago\",\"mode\":\"test\",\"status\":0,\"access_token\":null,\"public_key\":null}','payment_config','test',0,NULL,'2023-09-08 18:07:21','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc19a924305.png\"}'),('0d8a9e49-d6a5-11ed-962c-0c7a158e4469','liqpay','{\"gateway\":\"liqpay\",\"mode\":\"test\",\"status\":0,\"private_key\":null,\"public_key\":null}','{\"gateway\":\"liqpay\",\"mode\":\"test\",\"status\":0,\"private_key\":null,\"public_key\":null}','payment_config','test',0,NULL,'2023-09-08 18:07:47','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc19c308041.png\"}'),('101befdf-d44b-11ed-8564-0c7a158e4469','paypal','{\"gateway\":\"paypal\",\"mode\":\"test\",\"status\":0,\"client_id\":null,\"client_secret\":null}','{\"gateway\":\"paypal\",\"mode\":\"test\",\"status\":0,\"client_id\":null,\"client_secret\":null}','payment_config','test',0,NULL,'2023-09-08 18:08:04','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc19d453744.png\"}'),('133d9647-cabb-11ed-8fec-0c7a158e4469','hyper_pay','{\"gateway\":\"hyper_pay\",\"mode\":\"test\",\"status\":\"0\",\"entity_id\":\"data\",\"access_code\":\"data\"}','{\"gateway\":\"hyper_pay\",\"mode\":\"test\",\"status\":\"0\",\"entity_id\":\"data\",\"access_code\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:32:42','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('1821029f-d776-11ed-96f4-0c7a158e4469','msg91','{\"gateway\":\"msg91\",\"mode\":\"live\",\"status\":\"0\",\"template_id\":null,\"auth_key\":null}','{\"gateway\":\"msg91\",\"mode\":\"live\",\"status\":\"0\",\"template_id\":null,\"auth_key\":null}','sms_config','live',1,NULL,'2023-08-12 07:01:48',NULL),('18210f2b-d776-11ed-96f4-0c7a158e4469','nexmo','{\"gateway\":\"nexmo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"api_secret\":\"\",\"token\":\"\",\"from\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"nexmo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"api_secret\":\"\",\"token\":\"\",\"from\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,'2023-04-10 02:14:44',NULL),('18fbb21f-d6ad-11ed-962c-0c7a158e4469','foloosi','{\"gateway\":\"foloosi\",\"mode\":\"test\",\"status\":\"0\",\"merchant_key\":\"data\"}','{\"gateway\":\"foloosi\",\"mode\":\"test\",\"status\":\"0\",\"merchant_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:34:33','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('2767d142-d6a1-11ed-962c-0c7a158e4469','paytm','{\"gateway\":\"paytm\",\"mode\":\"test\",\"status\":0,\"merchant_key\":null,\"merchant_id\":null,\"merchant_website_link\":null}','{\"gateway\":\"paytm\",\"mode\":\"test\",\"status\":0,\"merchant_key\":null,\"merchant_id\":null,\"merchant_website_link\":null}','payment_config','test',0,NULL,'2023-09-08 18:08:21','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc19e5542b7.png\"}'),('3201d2e6-c937-11ed-a424-0c7a158e4469','amazon_pay','{\"gateway\":\"amazon_pay\",\"mode\":\"test\",\"status\":\"0\",\"pass_phrase\":\"data\",\"access_code\":\"data\",\"merchant_identifier\":\"data\"}','{\"gateway\":\"amazon_pay\",\"mode\":\"test\",\"status\":\"0\",\"pass_phrase\":\"data\",\"access_code\":\"data\",\"merchant_identifier\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:36:07','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('4593b25c-d6a1-11ed-962c-0c7a158e4469','paytabs','{\"gateway\":\"paytabs\",\"mode\":\"test\",\"status\":0,\"profile_id\":null,\"server_key\":null,\"base_url\":null}','{\"gateway\":\"paytabs\",\"mode\":\"test\",\"status\":0,\"profile_id\":null,\"server_key\":null,\"base_url\":null}','payment_config','test',0,NULL,'2023-09-08 18:08:41','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc19f90bf16.png\"}'),('4e9b8dfb-e7d1-11ed-a559-0c7a158e4469','bkash','{\"gateway\":\"bkash\",\"mode\":\"test\",\"status\":0,\"app_key\":null,\"app_secret\":null,\"username\":null,\"password\":null}','{\"gateway\":\"bkash\",\"mode\":\"test\",\"status\":0,\"app_key\":null,\"app_secret\":null,\"username\":null,\"password\":null}','payment_config','test',0,NULL,'2023-09-08 18:08:55','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a06f2df1.png\"}'),('544a24a4-c872-11ed-ac7a-0c7a158e4469','fatoorah','{\"gateway\":\"fatoorah\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}','{\"gateway\":\"fatoorah\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:36:24','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('58c1bc8a-d6ac-11ed-962c-0c7a158e4469','ccavenue','{\"gateway\":\"ccavenue\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"working_key\":\"data\",\"access_code\":\"data\"}','{\"gateway\":\"ccavenue\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"working_key\":\"data\",\"access_code\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 03:42:38','{\"gateway_title\":null,\"gateway_image\":\"2023-04-13-643783f01d386.png\"}'),('5e2d2ef9-d6ab-11ed-962c-0c7a158e4469','thawani','{\"gateway\":\"thawani\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"private_key\":\"data\"}','{\"gateway\":\"thawani\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"private_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:50:40','{\"gateway_title\":null,\"gateway_image\":\"2023-04-13-64378f9856f29.png\"}'),('60cc83cc-d5b9-11ed-b56f-0c7a158e4469','sixcash','{\"gateway\":\"sixcash\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"secret_key\":\"data\",\"merchant_number\":\"data\",\"base_url\":\"data\"}','{\"gateway\":\"sixcash\",\"mode\":\"test\",\"status\":\"0\",\"public_key\":\"data\",\"secret_key\":\"data\",\"merchant_number\":\"data\",\"base_url\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:16:17','{\"gateway_title\":null,\"gateway_image\":\"2023-04-12-6436774e77ff9.png\"}'),('68579846-d8e8-11ed-8249-0c7a158e4469','alphanet_sms','{\"gateway\":\"alphanet_sms\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"alphanet_sms\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('6857a2e8-d8e8-11ed-8249-0c7a158e4469','sms_to','{\"gateway\":\"sms_to\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"sms_to\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('74c30c00-d6a6-11ed-962c-0c7a158e4469','hubtel','{\"gateway\":\"hubtel\",\"mode\":\"test\",\"status\":\"0\",\"account_number\":\"data\",\"api_id\":\"data\",\"api_key\":\"data\"}','{\"gateway\":\"hubtel\",\"mode\":\"test\",\"status\":\"0\",\"account_number\":\"data\",\"api_id\":\"data\",\"api_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:37:43','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('74e46b0a-d6aa-11ed-962c-0c7a158e4469','tap','{\"gateway\":\"tap\",\"mode\":\"test\",\"status\":\"0\",\"secret_key\":\"data\"}','{\"gateway\":\"tap\",\"mode\":\"test\",\"status\":\"0\",\"secret_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:50:09','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('761ca96c-d1eb-11ed-87ca-0c7a158e4469','swish','{\"gateway\":\"swish\",\"mode\":\"test\",\"status\":\"0\",\"number\":\"data\"}','{\"gateway\":\"swish\",\"mode\":\"test\",\"status\":\"0\",\"number\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:17:02','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('7b1c3c5f-d2bd-11ed-b485-0c7a158e4469','payfast','{\"gateway\":\"payfast\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"secured_key\":\"data\"}','{\"gateway\":\"payfast\",\"mode\":\"test\",\"status\":\"0\",\"merchant_id\":\"data\",\"secured_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:18:13','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('8592417b-d1d1-11ed-a984-0c7a158e4469','esewa','{\"gateway\":\"esewa\",\"mode\":\"test\",\"status\":\"0\",\"merchantCode\":\"data\"}','{\"gateway\":\"esewa\",\"mode\":\"test\",\"status\":\"0\",\"merchantCode\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:17:38','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('9162a1dc-cdf1-11ed-affe-0c7a158e4469','viva_wallet','{\"gateway\":\"viva_wallet\",\"mode\":\"test\",\"status\":\"0\",\"client_id\": \"\",\"client_secret\": \"\", \"source_code\":\"\"}\n','{\"gateway\":\"viva_wallet\",\"mode\":\"test\",\"status\":\"0\",\"client_id\": \"\",\"client_secret\": \"\", \"source_code\":\"\"}\n','payment_config','test',0,NULL,NULL,NULL),('998ccc62-d6a0-11ed-962c-0c7a158e4469','stripe','{\"gateway\":\"stripe\",\"mode\":\"test\",\"status\":0,\"api_key\":null,\"published_key\":null}','{\"gateway\":\"stripe\",\"mode\":\"test\",\"status\":0,\"api_key\":null,\"published_key\":null}','payment_config','test',0,NULL,'2023-09-08 18:09:18','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a1ebd052.png\"}'),('a3313755-c95d-11ed-b1db-0c7a158e4469','iyzi_pay','{\"gateway\":\"iyzi_pay\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\",\"secret_key\":\"data\",\"base_url\":\"data\"}','{\"gateway\":\"iyzi_pay\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\",\"secret_key\":\"data\",\"base_url\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:20:02','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('a76c8993-d299-11ed-b485-0c7a158e4469','momo','{\"gateway\":\"momo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\",\"api_user\":\"data\",\"subscription_key\":\"data\"}','{\"gateway\":\"momo\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"data\",\"api_user\":\"data\",\"subscription_key\":\"data\"}','payment_config','live',0,NULL,'2023-08-30 04:19:28','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('a8608119-cc76-11ed-9bca-0c7a158e4469','moncash','{\"gateway\":\"moncash\",\"mode\":\"test\",\"status\":\"0\",\"client_id\":\"data\",\"secret_key\":\"data\"}','{\"gateway\":\"moncash\",\"mode\":\"test\",\"status\":\"0\",\"client_id\":\"data\",\"secret_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:47:34','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('ad5af1c1-d6a2-11ed-962c-0c7a158e4469','razor_pay','{\"gateway\":\"razor_pay\",\"mode\":\"test\",\"status\":0,\"api_key\":null,\"api_secret\":null}','{\"gateway\":\"razor_pay\",\"mode\":\"test\",\"status\":0,\"api_key\":null,\"api_secret\":null}','payment_config','test',0,NULL,'2023-09-08 18:09:33','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a2d3b25a.png\"}'),('ad5b02a0-d6a2-11ed-962c-0c7a158e4469','senang_pay','{\"gateway\":\"senang_pay\",\"mode\":\"test\",\"status\":0,\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}','{\"gateway\":\"senang_pay\",\"mode\":\"test\",\"status\":0,\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}','payment_config','test',0,NULL,'2023-09-08 18:09:51','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a3fef9ea.png\"}'),('b6c333f6-d8e9-11ed-8249-0c7a158e4469','akandit_sms','{\"gateway\":\"akandit_sms\",\"mode\":\"live\",\"status\":0,\"username\":\"\",\"password\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"akandit_sms\",\"mode\":\"live\",\"status\":0,\"username\":\"\",\"password\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('b6c33c87-d8e9-11ed-8249-0c7a158e4469','global_sms','{\"gateway\":\"global_sms\",\"mode\":\"live\",\"status\":0,\"user_name\":\"\",\"password\":\"\",\"from\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"global_sms\",\"mode\":\"live\",\"status\":0,\"user_name\":\"\",\"password\":\"\",\"from\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('b8992bd4-d6a0-11ed-962c-0c7a158e4469','paymob_accept','{\"gateway\":\"paymob_accept\",\"mode\":\"live\",\"status\":0,\"callback_url\":null,\"api_key\":null,\"iframe_id\":null,\"integration_id\":null,\"hmac\":null}','{\"gateway\":\"paymob_accept\",\"mode\":\"live\",\"status\":0,\"callback_url\":null,\"api_key\":null,\"iframe_id\":null,\"integration_id\":null,\"hmac\":null}','payment_config','live',0,NULL,'2023-09-08 18:10:19','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a5bb7958.png\"}'),('c41c0dcd-d119-11ed-9f67-0c7a158e4469','maxicash','{\"gateway\":\"maxicash\",\"mode\":\"test\",\"status\":\"0\",\"merchantId\":\"data\",\"merchantPassword\":\"data\"}','{\"gateway\":\"maxicash\",\"mode\":\"test\",\"status\":\"0\",\"merchantId\":\"data\",\"merchantPassword\":\"data\"}','payment_config','test',0,NULL,'2023-08-30 04:49:15','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('c9249d17-cd60-11ed-b879-0c7a158e4469','pvit','{\"gateway\":\"pvit\",\"mode\":\"test\",\"status\":\"0\",\"mc_tel_merchant\": \"\",\"access_token\": \"\", \"mc_merchant_code\": \"\"}','{\"gateway\":\"pvit\",\"mode\":\"test\",\"status\":\"0\",\"mc_tel_merchant\": \"\",\"access_token\": \"\", \"mc_merchant_code\": \"\"}','payment_config','test',0,NULL,NULL,NULL),('cb0081ce-d775-11ed-96f4-0c7a158e4469','releans','{\"gateway\":\"releans\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"from\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"releans\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\",\"from\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,'2023-04-10 02:14:44',NULL),('d4f3f5f1-d6a0-11ed-962c-0c7a158e4469','flutterwave','{\"gateway\":\"flutterwave\",\"mode\":\"test\",\"status\":0,\"secret_key\":null,\"public_key\":null,\"hash\":null}','{\"gateway\":\"flutterwave\",\"mode\":\"test\",\"status\":0,\"secret_key\":null,\"public_key\":null,\"hash\":null}','payment_config','test',0,NULL,'2023-09-08 18:10:44','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a74e1c4a.png\"}'),('d822f1a5-c864-11ed-ac7a-0c7a158e4469','paystack','{\"gateway\":\"paystack\",\"mode\":\"test\",\"status\":0,\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}','{\"gateway\":\"paystack\",\"mode\":\"test\",\"status\":0,\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}','payment_config','test',0,NULL,'2023-09-08 18:11:02','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a8629213.png\"}'),('daec8d59-c893-11ed-ac7a-0c7a158e4469','xendit','{\"gateway\":\"xendit\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}','{\"gateway\":\"xendit\",\"mode\":\"test\",\"status\":\"0\",\"api_key\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:35:46','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('dc0f5fc9-d6a5-11ed-962c-0c7a158e4469','worldpay','{\"gateway\":\"worldpay\",\"mode\":\"test\",\"status\":\"0\",\"OrgUnitId\":\"data\",\"jwt_issuer\":\"data\",\"mac\":\"data\",\"merchantCode\":\"data\",\"xml_password\":\"data\"}','{\"gateway\":\"worldpay\",\"mode\":\"test\",\"status\":\"0\",\"OrgUnitId\":\"data\",\"jwt_issuer\":\"data\",\"mac\":\"data\",\"merchantCode\":\"data\",\"xml_password\":\"data\"}','payment_config','test',0,NULL,'2023-08-12 06:35:26','{\"gateway_title\":null,\"gateway_image\":\"\"}'),('e0450278-d8eb-11ed-8249-0c7a158e4469','signal_wire','{\"gateway\":\"signal_wire\",\"mode\":\"live\",\"status\":0,\"project_id\":\"\",\"token\":\"\",\"space_url\":\"\",\"from\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"signal_wire\",\"mode\":\"live\",\"status\":0,\"project_id\":\"\",\"token\":\"\",\"space_url\":\"\",\"from\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('e0450b40-d8eb-11ed-8249-0c7a158e4469','paradox','{\"gateway\":\"paradox\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\"}','{\"gateway\":\"paradox\",\"mode\":\"live\",\"status\":0,\"api_key\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('ea346efe-cdda-11ed-affe-0c7a158e4469','ssl_commerz','{\"gateway\":\"ssl_commerz\",\"mode\":\"test\",\"status\":0,\"store_id\":null,\"store_password\":null}','{\"gateway\":\"ssl_commerz\",\"mode\":\"test\",\"status\":0,\"store_id\":null,\"store_password\":null}','payment_config','test',0,NULL,'2023-09-08 18:11:22','{\"gateway_title\":null,\"gateway_image\":\"2023-09-09-64fc1a9a82fad.png\"}'),('eed88336-d8ec-11ed-8249-0c7a158e4469','hubtel','{\"gateway\":\"hubtel\",\"mode\":\"live\",\"status\":0,\"sender_id\":\"\",\"client_id\":\"\",\"client_secret\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"hubtel\",\"mode\":\"live\",\"status\":0,\"sender_id\":\"\",\"client_id\":\"\",\"client_secret\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('f149c546-d8ea-11ed-8249-0c7a158e4469','viatech','{\"gateway\":\"viatech\",\"mode\":\"live\",\"status\":0,\"api_url\":\"\",\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"viatech\",\"mode\":\"live\",\"status\":0,\"api_url\":\"\",\"api_key\":\"\",\"sender_id\":\"\",\"otp_template\":\"\"}','sms_config','live',0,NULL,NULL,NULL),('f149cd9c-d8ea-11ed-8249-0c7a158e4469','019_sms','{\"gateway\":\"019_sms\",\"mode\":\"live\",\"status\":0,\"password\":\"\",\"username\":\"\",\"username_for_token\":\"\",\"sender\":\"\",\"otp_template\":\"\"}','{\"gateway\":\"019_sms\",\"mode\":\"live\",\"status\":0,\"password\":\"\",\"username\":\"\",\"username_for_token\":\"\",\"sender\":\"\",\"otp_template\":\"\"}','sms_config','live',1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `addon_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_features`
--

DROP TABLE IF EXISTS `admin_features`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `sub_title` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_features`
--

LOCK TABLES `admin_features` WRITE;
/*!40000 ALTER TABLE `admin_features` DISABLE KEYS */;
INSERT INTO `admin_features` VALUES (1,'24h Support',NULL,'24/7 customer support service to support you.','2023-09-08-64fc024bc54d2.png',1,'2023-09-08 15:29:24','2023-09-08 16:27:39'),(2,'Easy Payment',NULL,'Smart and easy payment system to maintain your business.','2023-09-08-64fc02451b503.png',1,'2023-09-08 15:41:25','2023-09-08 16:27:33'),(3,'Fast Delivery',NULL,'Fastest delivery system to reach your customer.','2023-09-08-64fc023ed0117.png',1,'2023-09-08 15:42:02','2023-09-08 16:27:26'),(4,'Resonable Price',NULL,'Start your business in cheap cost. In your budget','2023-09-08-64fc02384e21a.png',1,'2023-09-08 15:42:46','2023-09-08 16:27:20');
/*!40000 ALTER TABLE `admin_features` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_roles`
--

DROP TABLE IF EXISTS `admin_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `modules` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_roles`
--

LOCK TABLES `admin_roles` WRITE;
/*!40000 ALTER TABLE `admin_roles` DISABLE KEYS */;
INSERT INTO `admin_roles` VALUES (1,'Master Admin',NULL,1,NULL,NULL);
/*!40000 ALTER TABLE `admin_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_special_criterias`
--

DROP TABLE IF EXISTS `admin_special_criterias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_special_criterias` (
  `title` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_special_criterias`
--

LOCK TABLES `admin_special_criterias` WRITE;
/*!40000 ALTER TABLE `admin_special_criterias` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_special_criterias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_testimonials`
--

DROP TABLE IF EXISTS `admin_testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `designation` varchar(100) DEFAULT NULL,
  `review` text DEFAULT NULL,
  `reviewer_image` varchar(255) DEFAULT NULL,
  `company_image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_testimonials`
--

LOCK TABLES `admin_testimonials` WRITE;
/*!40000 ALTER TABLE `admin_testimonials` DISABLE KEYS */;
INSERT INTO `admin_testimonials` VALUES (1,'Jhon Doe','President of Sales','Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!','2023-09-08-64fc02123f537.png',NULL,1,'2023-09-08 16:20:42','2023-09-08 16:26:42');
/*!40000 ALTER TABLE `admin_testimonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_wallets`
--

DROP TABLE IF EXISTS `admin_wallets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_wallets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` bigint(20) unsigned NOT NULL,
  `total_commission_earning` decimal(24,2) NOT NULL DEFAULT 0.00,
  `digital_received` decimal(24,2) NOT NULL DEFAULT 0.00,
  `manual_received` decimal(24,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_wallets`
--

LOCK TABLES `admin_wallets` WRITE;
/*!40000 ALTER TABLE `admin_wallets` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_wallets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) DEFAULT NULL,
  `l_name` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admins_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admins`
--

LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
INSERT INTO `admins` VALUES (1,'admin','admin','+4422220022','admin@admin.com',NULL,'$2y$10$Yle/vcVWsCqCrXg/97IADOEfqyen21U4VdxBVz8pQfxi5HThl6fXK','FnJaZntmRmvAn6rQdZVkQDfnhiG58pXKz2Gb9rrVUXzZc2UYl4FjKGGv2Hcx','2024-09-28 01:59:57','2024-09-28 01:59:57',1,NULL);
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attributes`
--

DROP TABLE IF EXISTS `attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attributes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attributes`
--

LOCK TABLES `attributes` WRITE;
/*!40000 ALTER TABLE `attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banners`
--

DROP TABLE IF EXISTS `banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `data` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zone_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banners`
--

LOCK TABLES `banners` WRITE;
/*!40000 ALTER TABLE `banners` DISABLE KEYS */;
/*!40000 ALTER TABLE `banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `business_settings`
--

DROP TABLE IF EXISTS `business_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business_settings`
--

LOCK TABLES `business_settings` WRITE;
/*!40000 ALTER TABLE `business_settings` DISABLE KEYS */;
INSERT INTO `business_settings` VALUES (1,'cash_on_delivery','{\"status\":\"1\"}','2021-05-11 03:56:38','2021-09-09 22:27:34'),(2,'stripe','{\"status\":\"0\",\"api_key\":null,\"published_key\":null}','2021-05-11 03:57:02','2021-09-09 22:28:18'),(4,'mail_config','{\"status\":0,\"name\":\"\",\"host\":\"\",\"driver\":\"\",\"port\":\"\",\"username\":\"\",\"email_id\":\"\",\"encryption\":\"\",\"password\":\"\"}',NULL,'2023-09-06 23:04:39'),(5,'fcm_project_id',NULL,NULL,NULL),(6,'push_notification_key',NULL,NULL,NULL),(7,'order_pending_message','{\"status\":0,\"message\":null}',NULL,NULL),(8,'order_confirmation_msg','{\"status\":0,\"message\":null}',NULL,NULL),(9,'order_processing_message','{\"status\":0,\"message\":null}',NULL,NULL),(10,'out_for_delivery_message','{\"status\":0,\"message\":null}',NULL,NULL),(11,'order_delivered_message','{\"status\":0,\"message\":null}',NULL,NULL),(12,'delivery_boy_assign_message','{\"status\":0,\"message\":null}',NULL,NULL),(13,'delivery_boy_start_message','{\"status\":0,\"message\":null}',NULL,NULL),(14,'delivery_boy_delivered_message','{\"status\":0,\"message\":null}',NULL,NULL),(15,'terms_and_conditions',NULL,NULL,'2021-06-29 06:44:49'),(16,'business_name',NULL,NULL,NULL),(17,'currency','USD',NULL,NULL),(18,'logo','2023-08-26-64e9ce4d87716.png',NULL,NULL),(19,'phone','0123456789',NULL,NULL),(20,'email_address','admin@admin.com',NULL,NULL),(21,'address','307 AVENUE, BERTHELOT, 69008 LYON',NULL,NULL),(22,'footer_text','Footer Text',NULL,NULL),(23,'customer_verification',NULL,NULL,NULL),(24,'map_api_key','',NULL,NULL),(25,'privacy_policy',NULL,NULL,'2021-06-28 09:46:55'),(26,'about_us',NULL,NULL,'2021-06-29 06:43:25'),(27,'minimum_shipping_charge','0',NULL,NULL),(28,'per_km_shipping_charge','0',NULL,NULL),(29,'ssl_commerz_payment','{\"status\":\"0\",\"store_id\":null,\"store_password\":null}','2021-07-04 08:52:20','2021-09-09 22:28:30'),(30,'razor_pay','{\"status\":\"0\",\"razor_key\":null,\"razor_secret\":null}','2021-07-04 08:53:04','2021-09-09 22:28:25'),(31,'digital_payment','{\"status\":\"1\"}','2021-07-04 08:53:10','2021-10-16 03:11:55'),(32,'paypal','{\"status\":\"0\",\"paypal_client_id\":null,\"paypal_secret\":null}','2021-07-04 08:53:18','2021-09-09 22:28:36'),(33,'paystack','{\"status\":\"0\",\"publicKey\":null,\"secretKey\":null,\"paymentUrl\":null,\"merchantEmail\":null}','2021-07-04 09:14:07','2021-10-16 03:12:17'),(34,'senang_pay','{\"status\":null,\"secret_key\":null,\"published_key\":null,\"merchant_id\":null}','2021-07-04 09:14:13','2021-09-09 22:28:04'),(35,'order_handover_message','{\"status\":0,\"message\":null}',NULL,NULL),(36,'order_cancled_message','{\"status\":0,\"message\":null}',NULL,NULL),(37,'timezone','America/Los_Angeles',NULL,NULL),(38,'order_delivery_verification','1',NULL,NULL),(39,'currency_symbol_position','right',NULL,NULL),(40,'schedule_order','1',NULL,NULL),(41,'app_minimum_version','0',NULL,NULL),(42,'tax',NULL,NULL,NULL),(43,'admin_commission','0',NULL,NULL),(44,'country','AF',NULL,NULL),(45,'app_url','up_comming',NULL,NULL),(46,'default_location','{\"lat\":\"0\",\"lng\":\"0\"}',NULL,NULL),(47,'twilio_sms','{\"status\":\"0\",\"sid\":null,\"messaging_service_id\":null,\"token\":null,\"from\":null,\"otp_template\":\"Your otp is #OTP#.\"}','2021-10-16 03:10:30','2021-10-16 03:10:30'),(48,'nexmo_sms','{\"status\":\"0\",\"api_key\":null,\"api_secret\":null,\"signature_secret\":\"\",\"private_key\":\"\",\"application_id\":\"\",\"from\":null,\"otp_template\":\"Your otp is #OTP#.\"}','2021-10-16 03:10:22','2021-10-16 03:10:22'),(49,'2factor_sms','{\"status\":\"0\",\"api_key\":\"Your otp is #OTP#.\"}','2021-10-16 03:10:36','2021-10-16 03:10:36'),(50,'msg91_sms','{\"status\":\"0\",\"template_id\":null,\"authkey\":null}','2021-10-16 03:09:59','2021-10-16 03:09:59'),(51,'admin_order_notification','1',NULL,NULL),(52,'free_delivery_over',NULL,NULL,NULL),(53,'maintenance_mode','0','2021-09-09 21:33:55','2021-09-09 21:33:58'),(54,'app_minimum_version_android',NULL,NULL,NULL),(55,'app_minimum_version_ios',NULL,NULL,NULL),(56,'app_url_android',NULL,NULL,NULL),(57,'app_url_ios',NULL,NULL,NULL),(58,'dm_maximum_orders','5',NULL,NULL),(59,'flutterwave','{\"status\":\"1\",\"public_key\":null,\"secret_key\":null,\"hash\":null}','2021-09-23 06:51:28','2021-10-16 03:12:01'),(60,'order_confirmation_model','deliveryman',NULL,NULL),(61,'mercadopago','{\"status\":null,\"public_key\":null,\"access_token\":null}',NULL,'2021-10-16 03:12:09'),(62,'popular_food','1',NULL,NULL),(63,'popular_restaurant','1',NULL,NULL),(64,'new_restaurant','1',NULL,NULL),(65,'landing_page_text','{\"header_title_1\":\"Food App\",\"header_title_2\":\"Why stay hungry when you can order from StackFood\",\"header_title_3\":\"Get 10% OFF on your first order\",\"about_title\":\"StackFood is Best Delivery Service Near You\",\"why_choose_us\":\"Why Choose Us?\",\"why_choose_us_title\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit.\",\"testimonial_title\":\"Trusted by Customer & Restaurant Owner\",\"footer_article\":\"Suspendisse ultrices at diam lectus nullam. Nisl, sagittis viverra enim erat tortor ultricies massa turpis. Arcu pulvinar.\"}','2021-10-31 15:21:57','2021-10-31 15:21:57'),(66,'landing_page_links','{\"app_url_android_status\":\"1\",\"app_url_android\":\"https:\\/\\/play.google.com\",\"app_url_ios_status\":\"1\",\"app_url_ios\":\"https:\\/\\/www.apple.com\\/app-store\",\"web_app_url_status\":\"1\",\"web_app_url\":\"https:\\/\\/stackfood.6amtech.com\\/\"}','2021-10-31 15:21:57','2021-10-31 15:21:57'),(67,'speciality','[{\"img\":\"clean_&_cheap_icon.png\",\"title\":\"Clean & Cheap Price\"},{\"img\":\"best_dishes_icon.png\",\"title\":\"Best Dishes Near You\"},{\"img\":\"virtual_restaurant_icon.png\",\"title\":\"Your Own Virtual Restaurant\"}]','2021-10-31 15:21:57','2021-10-31 15:21:57'),(68,'testimonial','[{\"img\":\"2021-10-28-617aa5a9e4b4a.png\",\"name\":\"Barry Allen\",\"position\":\"Web Designer\",\"detail\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit. A\\r\\n                    aliquam amet animi blanditiis consequatur debitis dicta\\r\\n                    distinctio, enim error eum iste libero modi nam natus\\r\\n                    perferendis possimus quasi sint sit tempora voluptatem. Est,\\r\\n                    exercitationem id ipsa ipsum laboriosam perferendis temporibus!\"},{\"img\":\"2021-10-28-617aa9b13c57b.png\",\"name\":\"Sophia Martino\",\"position\":\"Web Designer\",\"detail\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!\"},{\"img\":\"2021-10-28-617aa9db9752d.png\",\"name\":\"Alan Turing\",\"position\":\"Web Designer\",\"detail\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!\"},{\"img\":\"2021-10-28-617aa9faa8c78.png\",\"name\":\"Ann Marie\",\"position\":\"Web Designer\",\"detail\":\"Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!\"}]','2021-10-31 15:21:57','2021-10-31 15:21:57'),(69,'most_reviewed_foods','1',NULL,NULL),(70,'paymob_accept','{\"status\":\"0\",\"api_key\":null,\"iframe_id\":null,\"integration_id\":null,\"hmac\":null}',NULL,'2021-11-12 21:02:39'),(71,'timeformat','24',NULL,NULL),(72,'canceled_by_restaurant','0',NULL,NULL),(73,'canceled_by_deliveryman','0',NULL,NULL),(74,'show_dm_earning',NULL,NULL,NULL),(75,'toggle_veg_non_veg','1',NULL,NULL),(76,'toggle_dm_registration',NULL,NULL,NULL),(77,'toggle_restaurant_registration',NULL,NULL,NULL),(78,'recaptcha','{\"status\":\"0\",\"site_key\":null,\"secret_key\":null}','2022-01-09 20:03:59','2022-01-09 20:03:59'),(79,'language','[\"en\",\"lo\"]',NULL,'2024-09-28 02:53:08'),(80,'schedule_order_slot_duration','0',NULL,NULL),(81,'digit_after_decimal_point','0',NULL,NULL),(82,'icon','2023-08-26-64e9cd6eeb087.png',NULL,NULL),(83,'delivery_charge_comission','0','2022-07-03 17:07:00','2022-07-03 17:07:00'),(84,'dm_max_cash_in_hand','10000','2022-07-03 17:07:00','2022-07-03 17:07:00'),(85,'theme','1','2022-07-03 17:37:00','2022-07-03 17:37:00'),(86,'dm_tips_status',NULL,NULL,NULL),(87,'wallet_status','0',NULL,NULL),(88,'loyalty_point_status','0',NULL,NULL),(89,'ref_earning_status','0',NULL,NULL),(90,'wallet_add_refund','0',NULL,NULL),(91,'loyalty_point_exchange_rate','0',NULL,NULL),(92,'ref_earning_exchange_rate','0',NULL,NULL),(93,'loyalty_point_item_purchase_point','0',NULL,NULL),(94,'loyalty_point_minimum_point','0',NULL,NULL),(95,'order_refunded_message','{\"status\":0,\"message\":null}',NULL,NULL),(96,'fcm_credentials','{\"apiKey\":\"\",\"authDomain\":\"\",\"projectId\":\"\",\"storageBucket\":\"\",\"messagingSenderId\":\"\",\"appId\":\"\",\"measurementId\":\"\"}',NULL,NULL),(97,'feature','[]',NULL,NULL),(98,'tax_included',NULL,'2023-03-20 04:07:28','2023-03-20 04:07:28'),(99,'site_direction','ltr','2023-03-20 04:07:28','2023-03-20 04:07:28'),(100,'system_language','[{\"id\":1,\"direction\":\"ltr\",\"code\":\"en\",\"status\":1,\"default\":false},{\"id\":2,\"direction\":\"ltr\",\"code\":\"lo\",\"status\":1,\"default\":true}]','2023-07-10 00:56:39','2024-09-28 15:18:21'),(101,'take_away','1','2023-07-10 00:56:39','2023-07-10 00:56:39'),(102,'repeat_order_option','1','2023-07-10 00:56:39','2023-07-10 00:56:39'),(103,'home_delivery','1','2023-07-10 00:56:39','2023-07-10 00:56:39'),(104,'refund_active_status','1','2023-07-10 00:56:58','2023-07-10 00:56:58'),(105,'business_model','{\"commission\":1,\"subscription\":0}','2023-07-10 00:56:58','2023-07-10 00:56:58'),(106,'cookies_text','Cookies',NULL,NULL),(107,'social_login','[{\"login_medium\":\"google\",\"client_id\":\"\",\"client_secret\":\"\",\"status\":\"0\"},{\"login_medium\":\"facebook\",\"client_id\":\"\",\"client_secret\":\"\",\"status\":\"\"}]','2023-09-06 23:04:50','2023-09-06 23:04:50'),(108,'apple_login','[{\"login_medium\":\"apple\",\"client_id\":\"\",\"client_secret\":\"\",\"team_id\":\"\",\"key_id\":\"\",\"service_file\":\"\",\"redirect_url\":\"\",\"status\":\"\"}]','2023-09-06 23:04:50','2023-09-06 23:04:50'),(109,'order_notification_type','manual',NULL,NULL),(110,'additional_charge_status',NULL,NULL,NULL),(111,'additional_charge_name','Additional Charge',NULL,NULL),(112,'additional_charge',NULL,NULL,NULL),(113,'partial_payment_status','1',NULL,NULL),(114,'partial_payment_method','both',NULL,NULL),(115,'dm_picture_upload_status',NULL,NULL,NULL),(116,'add_fund_status','0',NULL,NULL),(117,'landing_page','1','2023-09-08 15:23:08','2023-09-08 15:23:08'),(118,'check_subscription_validity_on','2023-09-08','2023-09-08 16:46:14','2023-09-08 16:46:14');
/*!40000 ALTER TABLE `business_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `campaign_restaurant`
--

DROP TABLE IF EXISTS `campaign_restaurant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign_restaurant` (
  `campaign_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `campaign_status` varchar(10) DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `campaign_restaurant`
--

LOCK TABLES `campaign_restaurant` WRITE;
/*!40000 ALTER TABLE `campaign_restaurant` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign_restaurant` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `campaigns`
--

DROP TABLE IF EXISTS `campaigns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaigns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `admin_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `campaigns`
--

LOCK TABLES `campaigns` WRITE;
/*!40000 ALTER TABLE `campaigns` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaigns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `carts`
--

DROP TABLE IF EXISTS `carts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `carts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `item_id` bigint(20) unsigned NOT NULL,
  `is_guest` tinyint(1) NOT NULL DEFAULT 0,
  `add_on_ids` text DEFAULT NULL,
  `add_on_qtys` text DEFAULT NULL,
  `item_type` varchar(255) NOT NULL,
  `price` double(24,3) NOT NULL,
  `quantity` int(11) NOT NULL,
  `variations` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carts`
--

LOCK TABLES `carts` WRITE;
/*!40000 ALTER TABLE `carts` DISABLE KEYS */;
/*!40000 ALTER TABLE `carts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) NOT NULL DEFAULT 'def.png',
  `parent_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `priority` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Demo Category','2023-09-08-64fc02a1514ff.png',0,0,1,'2023-09-08 16:29:05','2023-09-08 16:29:05',0,'demo-category'),(2,'Demo Sub Category','def.png',1,1,1,'2023-09-08 16:29:46','2023-09-08 16:29:46',0,'demo-sub-category');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_messages`
--

DROP TABLE IF EXISTS `contact_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile_number` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `reply` text DEFAULT NULL,
  `feedback` varchar(255) DEFAULT '0',
  `seen` tinyint(1) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_messages`
--

LOCK TABLES `contact_messages` WRITE;
/*!40000 ALTER TABLE `contact_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `contact_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conversations`
--

DROP TABLE IF EXISTS `conversations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conversations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sender_type` varchar(255) NOT NULL,
  `receiver_id` bigint(20) unsigned NOT NULL,
  `receiver_type` varchar(255) NOT NULL,
  `last_message_id` bigint(20) unsigned DEFAULT NULL,
  `last_message_time` timestamp NULL DEFAULT NULL,
  `unread_message_count` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conversations`
--

LOCK TABLES `conversations` WRITE;
/*!40000 ALTER TABLE `conversations` DISABLE KEYS */;
/*!40000 ALTER TABLE `conversations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `coupons`
--

DROP TABLE IF EXISTS `coupons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coupons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `min_purchase` decimal(24,2) NOT NULL DEFAULT 0.00,
  `max_discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(15) NOT NULL DEFAULT 'percentage',
  `coupon_type` varchar(191) NOT NULL DEFAULT 'default',
  `limit` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `data` varchar(191) DEFAULT NULL,
  `total_uses` bigint(20) DEFAULT 0,
  `created_by` varchar(50) DEFAULT 'admin',
  `customer_id` varchar(255) DEFAULT '["all"]',
  `slug` varchar(255) DEFAULT NULL,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupons_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `coupons`
--

LOCK TABLES `coupons` WRITE;
/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuisine_restaurant`
--

DROP TABLE IF EXISTS `cuisine_restaurant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuisine_restaurant` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `cuisine_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuisine_restaurant`
--

LOCK TABLES `cuisine_restaurant` WRITE;
/*!40000 ALTER TABLE `cuisine_restaurant` DISABLE KEYS */;
INSERT INTO `cuisine_restaurant` VALUES (1,1,1);
/*!40000 ALTER TABLE `cuisine_restaurant` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuisines`
--

DROP TABLE IF EXISTS `cuisines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuisines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuisines`
--

LOCK TABLES `cuisines` WRITE;
/*!40000 ALTER TABLE `cuisines` DISABLE KEYS */;
INSERT INTO `cuisines` VALUES (1,'Demo Cuisine','2023-09-08-64fc01e29d648.png',1,'demo-cuisine','2023-09-08 16:25:54','2023-09-08 16:25:54');
/*!40000 ALTER TABLE `cuisines` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currencies`
--

DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(191) DEFAULT NULL,
  `currency_code` varchar(191) DEFAULT NULL,
  `currency_symbol` varchar(191) DEFAULT NULL,
  `exchange_rate` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currencies`
--

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES (1,'US Dollar','USD','$',1.00,NULL,NULL),(2,'Canadian Dollar','CAD','CA$',1.00,NULL,NULL),(3,'Euro','EUR','€',1.00,NULL,NULL),(4,'United Arab Emirates Dirham','AED','د.إ.‏',1.00,NULL,NULL),(5,'Afghan Afghani','AFN','؋',1.00,NULL,NULL),(6,'Albanian Lek','ALL','L',1.00,NULL,NULL),(7,'Armenian Dram','AMD','֏',1.00,NULL,NULL),(8,'Argentine Peso','ARS','$',1.00,NULL,NULL),(9,'Australian Dollar','AUD','$',1.00,NULL,NULL),(10,'Azerbaijani Manat','AZN','₼',1.00,NULL,NULL),(11,'Bosnia-Herzegovina Convertible Mark','BAM','KM',1.00,NULL,NULL),(12,'Bangladeshi Taka','BDT','৳',1.00,NULL,NULL),(13,'Bulgarian Lev','BGN','лв.',1.00,NULL,NULL),(14,'Bahraini Dinar','BHD','د.ب.‏',1.00,NULL,NULL),(15,'Burundian Franc','BIF','FBu',1.00,NULL,NULL),(16,'Brunei Dollar','BND','B$',1.00,NULL,NULL),(17,'Bolivian Boliviano','BOB','Bs',1.00,NULL,NULL),(18,'Brazilian Real','BRL','R$',1.00,NULL,NULL),(19,'Botswanan Pula','BWP','P',1.00,NULL,NULL),(20,'Belarusian Ruble','BYN','Br',1.00,NULL,NULL),(21,'Belize Dollar','BZD','$',1.00,NULL,NULL),(22,'Congolese Franc','CDF','FC',1.00,NULL,NULL),(23,'Swiss Franc','CHF','CHf',1.00,NULL,NULL),(24,'Chilean Peso','CLP','$',1.00,NULL,NULL),(25,'Chinese Yuan','CNY','¥',1.00,NULL,NULL),(26,'Colombian Peso','COP','$',1.00,NULL,NULL),(27,'Costa Rican Colón','CRC','₡',1.00,NULL,NULL),(28,'Cape Verdean Escudo','CVE','$',1.00,NULL,NULL),(29,'Czech Republic Koruna','CZK','Kč',1.00,NULL,NULL),(30,'Djiboutian Franc','DJF','Fdj',1.00,NULL,NULL),(31,'Danish Krone','DKK','Kr.',1.00,NULL,NULL),(32,'Dominican Peso','DOP','RD$',1.00,NULL,NULL),(33,'Algerian Dinar','DZD','د.ج.‏',1.00,NULL,NULL),(34,'Estonian Kroon','EEK','kr',1.00,NULL,NULL),(35,'Egyptian Pound','EGP','E£‏',1.00,NULL,NULL),(36,'Eritrean Nakfa','ERN','Nfk',1.00,NULL,NULL),(37,'Ethiopian Birr','ETB','Br',1.00,NULL,NULL),(38,'British Pound Sterling','GBP','£',1.00,NULL,NULL),(39,'Georgian Lari','GEL','GEL',1.00,NULL,NULL),(40,'Ghanaian Cedi','GHS','GH¢',1.00,NULL,NULL),(41,'Guinean Franc','GNF','FG',1.00,NULL,NULL),(42,'Guatemalan Quetzal','GTQ','Q',1.00,NULL,NULL),(43,'Hong Kong Dollar','HKD','HK$',1.00,NULL,NULL),(44,'Honduran Lempira','HNL','L',1.00,NULL,NULL),(45,'Croatian Kuna','HRK','kn',1.00,NULL,NULL),(46,'Hungarian Forint','HUF','Ft',1.00,NULL,NULL),(47,'Indonesian Rupiah','IDR','Rp',1.00,NULL,NULL),(48,'Israeli New Sheqel','ILS','₪',1.00,NULL,NULL),(49,'Indian Rupee','INR','₹',1.00,NULL,NULL),(50,'Iraqi Dinar','IQD','ع.د',1.00,NULL,NULL),(51,'Iranian Rial','IRR','﷼',1.00,NULL,NULL),(52,'Icelandic Króna','ISK','kr',1.00,NULL,NULL),(53,'Jamaican Dollar','JMD','$',1.00,NULL,NULL),(54,'Jordanian Dinar','JOD','د.ا‏',1.00,NULL,NULL),(55,'Japanese Yen','JPY','¥',1.00,NULL,NULL),(56,'Kenyan Shilling','KES','Ksh',1.00,NULL,NULL),(57,'Cambodian Riel','KHR','៛',1.00,NULL,NULL),(58,'Comorian Franc','KMF','FC',1.00,NULL,NULL),(59,'South Korean Won','KRW','CF',1.00,NULL,NULL),(60,'Kuwaiti Dinar','KWD','د.ك.‏',1.00,NULL,NULL),(61,'Kazakhstani Tenge','KZT','₸.',1.00,NULL,NULL),(62,'Lebanese Pound','LBP','ل.ل.‏',1.00,NULL,NULL),(63,'Sri Lankan Rupee','LKR','Rs',1.00,NULL,NULL),(64,'Lithuanian Litas','LTL','Lt',1.00,NULL,NULL),(65,'Latvian Lats','LVL','Ls',1.00,NULL,NULL),(66,'Libyan Dinar','LYD','د.ل.‏',1.00,NULL,NULL),(67,'Moroccan Dirham','MAD','د.م.‏',1.00,NULL,NULL),(68,'Moldovan Leu','MDL','L',1.00,NULL,NULL),(69,'Malagasy Ariary','MGA','Ar',1.00,NULL,NULL),(70,'Macedonian Denar','MKD','Ден',1.00,NULL,NULL),(71,'Myanma Kyat','MMK','K',1.00,NULL,NULL),(72,'Macanese Pataca','MOP','MOP$',1.00,NULL,NULL),(73,'Mauritian Rupee','MUR','Rs',1.00,NULL,NULL),(74,'Mexican Peso','MXN','$',1.00,NULL,NULL),(75,'Malaysian Ringgit','MYR','RM',1.00,NULL,NULL),(76,'Mozambican Metical','MZN','MT',1.00,NULL,NULL),(77,'Namibian Dollar','NAD','N$',1.00,NULL,NULL),(78,'Nigerian Naira','NGN','₦',1.00,NULL,NULL),(79,'Nicaraguan Córdoba','NIO','C$',1.00,NULL,NULL),(80,'Norwegian Krone','NOK','kr',1.00,NULL,NULL),(81,'Nepalese Rupee','NPR','Re.',1.00,NULL,NULL),(82,'New Zealand Dollar','NZD','$',1.00,NULL,NULL),(83,'Omani Rial','OMR','ر.ع.‏',1.00,NULL,NULL),(84,'Panamanian Balboa','PAB','B/.',1.00,NULL,NULL),(85,'Peruvian Nuevo Sol','PEN','S/',1.00,NULL,NULL),(86,'Philippine Peso','PHP','₱',1.00,NULL,NULL),(87,'Pakistani Rupee','PKR','Rs',1.00,NULL,NULL),(88,'Polish Zloty','PLN','zł',1.00,NULL,NULL),(89,'Paraguayan Guarani','PYG','₲',1.00,NULL,NULL),(90,'Qatari Rial','QAR','ر.ق.‏',1.00,NULL,NULL),(91,'Romanian Leu','RON','lei',1.00,NULL,NULL),(92,'Serbian Dinar','RSD','din.',1.00,NULL,NULL),(93,'Russian Ruble','RUB','₽.',1.00,NULL,NULL),(94,'Rwandan Franc','RWF','FRw',1.00,NULL,NULL),(95,'Saudi Riyal','SAR','ر.س.‏',1.00,NULL,NULL),(96,'Sudanese Pound','SDG','ج.س.',1.00,NULL,NULL),(97,'Swedish Krona','SEK','kr',1.00,NULL,NULL),(98,'Singapore Dollar','SGD','$',1.00,NULL,NULL),(99,'Somali Shilling','SOS','Sh.so.',1.00,NULL,NULL),(100,'Syrian Pound','SYP','LS‏',1.00,NULL,NULL),(101,'Thai Baht','THB','฿',1.00,NULL,NULL),(102,'Tunisian Dinar','TND','د.ت‏',1.00,NULL,NULL),(103,'Tongan Paʻanga','TOP','T$',1.00,NULL,NULL),(104,'Turkish Lira','TRY','₺',1.00,NULL,NULL),(105,'Trinidad and Tobago Dollar','TTD','$',1.00,NULL,NULL),(106,'New Taiwan Dollar','TWD','NT$',1.00,NULL,NULL),(107,'Tanzanian Shilling','TZS','TSh',1.00,NULL,NULL),(108,'Ukrainian Hryvnia','UAH','₴',1.00,NULL,NULL),(109,'Ugandan Shilling','UGX','USh',1.00,NULL,NULL),(110,'Uruguayan Peso','UYU','$',1.00,NULL,NULL),(111,'Uzbekistan Som','UZS','so\'m',1.00,NULL,NULL),(112,'Venezuelan Bolívar','VEF','Bs.F.',1.00,NULL,NULL),(113,'Vietnamese Dong','VND','₫',1.00,NULL,NULL),(114,'CFA Franc BEAC','XAF','FCFA',1.00,NULL,NULL),(115,'CFA Franc BCEAO','XOF','CFA',1.00,NULL,NULL),(116,'Yemeni Rial','YER','﷼‏',1.00,NULL,NULL),(117,'South African Rand','ZAR','R',1.00,NULL,NULL),(118,'Zambian Kwacha','ZMK','ZK',1.00,NULL,NULL),(119,'Zimbabwean Dollar','ZWL','Z$',1.00,NULL,NULL);
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer_addresses`
--

DROP TABLE IF EXISTS `customer_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `address_type` varchar(100) NOT NULL,
  `contact_person_number` varchar(20) NOT NULL,
  `address` text DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `contact_person_name` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zone_id` bigint(20) unsigned NOT NULL,
  `floor` varchar(255) DEFAULT NULL,
  `road` varchar(255) DEFAULT NULL,
  `house` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer_addresses`
--

LOCK TABLES `customer_addresses` WRITE;
/*!40000 ALTER TABLE `customer_addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `customer_addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `d_m_reviews`
--

DROP TABLE IF EXISTS `d_m_reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `d_m_reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_man_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `comment` mediumtext DEFAULT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `d_m_reviews`
--

LOCK TABLES `d_m_reviews` WRITE;
/*!40000 ALTER TABLE `d_m_reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `d_m_reviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_settings`
--

DROP TABLE IF EXISTS `data_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_settings`
--

LOCK TABLES `data_settings` WRITE;
/*!40000 ALTER TABLE `data_settings` DISABLE KEYS */;
INSERT INTO `data_settings` VALUES (1,'admin_login_url','admin','login_admin','2023-06-20 16:55:51','2023-06-20 16:55:51'),(2,'admin_employee_login_url','admin-employee','login_admin_employee','2023-06-20 16:55:51','2023-06-20 16:55:51'),(3,'restaurant_login_url','restaurant','login_restaurant','2023-06-20 16:55:51','2023-06-20 16:55:51'),(4,'restaurant_employee_login_url','restaurant-employee','login_restaurant_employee','2023-06-20 16:55:51','2023-06-20 16:55:51'),(5,'header_title','Why stay Hungry !','admin_landing_page','2023-06-20 17:59:39','2023-06-20 17:59:39'),(6,'header_sub_title','when you can order always form','admin_landing_page','2023-06-20 17:59:39','2023-06-20 17:59:39'),(7,'header_tag_line','Start Your Business or Download the App','admin_landing_page','2023-06-20 17:59:39','2023-06-20 17:59:39'),(8,'header_app_button_name','Order Now','admin_landing_page','2023-06-20 17:59:39','2023-06-20 17:59:39'),(9,'header_app_button_status','1','admin_landing_page','2023-06-20 17:59:39','2023-06-20 17:59:39'),(10,'header_button_content','https://restaurant.deepsoft.biz/','admin_landing_page','2023-06-20 17:59:39','2024-09-28 14:28:17'),(11,'header_image_content','{\"header_content_image\":null,\"header_bg_image\":null}','admin_landing_page','2023-06-20 18:01:47','2023-09-08 15:31:26'),(12,'header_floating_content','{\"header_floating_total_order\":\"5000\",\"header_floating_total_user\":\"999\",\"header_floating_total_reviews\":\"2330\"}','admin_landing_page','2023-06-20 18:04:04','2023-06-20 18:04:04'),(13,'about_us_image_content','2024-09-28-66f8de40d40e6.png','admin_landing_page','2023-06-20 18:10:05','2024-09-28 14:57:36'),(14,'about_us_title','restaurant','admin_landing_page','2023-06-20 18:10:05','2024-09-28 14:57:36'),(15,'about_us_sub_title','is Best Delivery Service Near You','admin_landing_page','2023-06-20 18:10:05','2023-06-20 18:10:05'),(16,'about_us_text','We make food delivery more interesting.\r\nFind the greatest deals from the restaurants near you.\r\nTesty & healthy dishes. Bring a restaurant into your home.','admin_landing_page','2023-06-20 18:10:06','2023-06-20 18:12:42'),(17,'about_us_app_button_name','Download Now','admin_landing_page','2023-06-20 18:10:06','2023-06-20 18:10:06'),(18,'about_us_app_button_status','1','admin_landing_page','2023-06-20 18:10:06','2023-06-20 18:10:06'),(19,'about_us_button_content','https://play.google.com/store/','admin_landing_page','2023-06-20 18:10:06','2023-06-20 18:10:06'),(20,'feature_title','Stunning Features','admin_landing_page','2023-06-20 18:13:41','2023-06-20 18:13:41'),(21,'feature_sub_title','Remarkable Features that You Can Count!','admin_landing_page','2023-06-20 18:13:41','2023-06-20 18:13:41'),(22,'services_title','Our Platform','admin_landing_page','2023-06-20 18:29:43','2023-06-20 18:29:43'),(23,'services_sub_title','Lorem ipsum dolor sit amet, consectetur adipiscing elit.','admin_landing_page','2023-06-20 18:29:43','2023-06-20 18:44:11'),(24,'services_order_title_1','Order your food','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(25,'services_order_title_2','Use stackfood app','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(26,'services_order_description_1','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam ex odio,  turpis accumsan congue. Quisque blandit dui P','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(27,'services_order_description_2','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam ex odio,  turpis accumsan congue. Quisque blandit dui P','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(28,'services_order_button_name','Download Now','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(29,'services_order_button_status','1','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(30,'services_order_button_link','https://play.google.com/store/','admin_landing_page','2023-06-20 18:45:36','2023-06-20 18:45:36'),(31,'services_manage_restaurant_title_1','Manage your order','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(32,'services_manage_restaurant_title_2','Manage your wallet','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(33,'services_manage_restaurant_description_1','Manage customer order very easily by using StackFood Restaurant Panel & Restaurant APP','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(34,'services_manage_restaurant_description_2','Manage restaurant wallet and monitor restaurant earnings and transactions.','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(35,'services_manage_restaurant_button_name','Download Now','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(36,'services_manage_restaurant_button_status','1','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(37,'services_manage_restaurant_button_link','https://play.google.com/','admin_landing_page','2023-06-20 18:47:13','2023-06-20 18:47:13'),(38,'services_manage_delivery_title_1','Deliver your food','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(39,'services_manage_delivery_title_2','Earn by delivery','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(40,'services_manage_delivery_description_1','Download Delivery Man App from Play store & App Store and Register as Delivery Man to provide food all over the area.','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(41,'services_manage_delivery_description_2','Become a delivery man and earn from every food delivery','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(42,'services_manage_delivery_button_name','Download Now','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(43,'services_manage_delivery_button_status','1','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(44,'services_manage_delivery_button_link','https://play.google.com/','admin_landing_page','2023-06-20 18:47:57','2023-06-20 18:47:57'),(45,'earn_money_title','Why Choose Us?','admin_landing_page','2023-06-20 18:48:17','2023-06-20 18:48:17'),(46,'earn_money_sub_title','Lorem ipsum dolor sit amet, consectetur adipiscing elit.','admin_landing_page','2023-06-20 18:48:17','2023-06-20 18:48:17'),(47,'earn_money_reg_title','Earn Money From StackFood','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(48,'earn_money_restaurant_req_button_name','Be a Seller','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(49,'earn_money_restaurant_req_button_status','1','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(50,'earn_money_restaurant_req_button_link','https://play.google.com/','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(51,'earn_money_delivety_man_req_button_name','Be Deliveryman','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(52,'earn_money_delivery_man_req_button_status','1','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(53,'earn_money_delivery_man_req_button_link','https://play.google.com/','admin_landing_page','2023-06-20 18:51:41','2023-06-20 18:51:41'),(54,'earn_money_reg_image','2023-09-08-64fbfbce08c86.png','admin_landing_page','2023-06-20 18:51:41','2023-09-08 15:59:58'),(55,'why_choose_us_title','Why Choose Us?','admin_landing_page','2023-06-20 18:51:57','2023-06-20 18:51:57'),(56,'why_choose_us_sub_title','Lorem ipsum dolor sit amet, consectetur adipiscing elit.','admin_landing_page','2023-06-20 18:51:57','2023-06-20 18:51:57'),(57,'why_choose_us_title_1','Find your daily meal','admin_landing_page','2023-06-20 18:53:32','2023-06-20 18:53:32'),(58,'why_choose_us_image_1','2023-09-08-64fbfcbb1ded2.png','admin_landing_page','2023-06-20 18:53:32','2023-09-08 16:03:55'),(59,'why_choose_us_title_2','Easy to food ordering system','admin_landing_page','2023-06-20 18:53:46','2023-06-20 18:53:46'),(60,'why_choose_us_image_2','2023-09-08-64fbfcc98c136.png','admin_landing_page','2023-06-20 18:53:46','2023-09-08 16:04:09'),(61,'why_choose_us_title_3','Fastest food delivery service','admin_landing_page','2023-06-20 18:54:02','2023-06-20 18:54:02'),(62,'why_choose_us_image_3','2023-09-08-64fbfcd9f04cd.png','admin_landing_page','2023-06-20 18:54:02','2023-09-08 16:04:25'),(63,'why_choose_us_title_4','Track your food order','admin_landing_page','2023-06-20 18:54:19','2023-06-20 18:54:19'),(64,'why_choose_us_image_4','2023-09-08-64fbfde2928e5.png','admin_landing_page','2023-06-20 18:54:19','2023-09-08 16:08:50'),(65,'testimonial_title','We satisfied some Customer & Restaurant Owners','admin_landing_page','2023-06-21 09:24:53','2023-06-21 09:24:53'),(66,'news_letter_title','Sign Up to Our Newsletter','admin_landing_page','2023-06-21 09:25:14','2023-06-21 09:25:14'),(67,'news_letter_sub_title','Receive Latest News, Updates and Many Other News Every Week','admin_landing_page','2023-06-21 09:25:14','2023-06-21 09:25:14'),(68,'footer_data','Stackfood is a complete package! It\'s time to empower your online food business with powerful features!','admin_landing_page','2023-06-21 09:26:16','2023-06-21 09:26:16'),(69,'react_header_title','Cooking','react_landing_page','2023-06-21 09:41:59','2024-09-28 15:13:16'),(70,'react_header_sub_title','Find Restaurants Near You','react_landing_page','2023-06-21 09:41:59','2023-06-21 09:41:59'),(71,'react_header_image','2024-09-28-66f8e1eced346.png','react_landing_page','2023-06-21 09:41:59','2024-09-28 15:13:16'),(72,'react_restaurant_section_title','Open your own restaurant','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(73,'react_restaurant_section_sub_title','Register as seller and open shop to start your business','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(74,'react_restaurant_section_button_name','Register','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(75,'react_restaurant_section_button_status','1','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(76,'react_restaurant_section_image','2024-09-28-66f8e24ed8ebf.png','react_landing_page','2023-06-21 09:48:57','2024-09-28 15:14:54'),(77,'react_restaurant_section_link_data','https://restaurant.deepsoft.biz/restaurant/apply','react_landing_page','2023-06-21 09:48:57','2024-09-28 15:14:54'),(78,'react_delivery_section_title','Become a Delivery Man','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(79,'react_delivery_section_sub_title','Register as delivery man and earn money','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(80,'react_delivery_section_button_name','Register','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(81,'react_delivery_section_button_status','1','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(82,'react_delivery_section_image','2024-09-28-66f8e24edb62a.png','react_landing_page','2023-06-21 09:48:57','2024-09-28 15:14:54'),(83,'react_delivery_section_link_data','https://restaurant.deepsoft.biz/deliveryman/apply','react_landing_page','2023-06-21 09:48:57','2024-09-28 15:14:54'),(84,'react_download_apps_banner_image','2023-09-08-64fbecbd82cdc.png','react_landing_page','2023-06-21 09:50:18','2023-09-08 14:55:41'),(85,'react_download_apps_title','Download app to enjoy more!','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(86,'react_download_apps_sub_title','All the best restaurants are one click away','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(87,'react_download_apps_tag','Download our app from google play store & app store.','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(88,'react_download_apps_button_name','https://play.google.com/','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(89,'react_download_apps_button_status','1','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(90,'react_download_apps_image','2023-09-08-64fbe8bfa9da1.png','react_landing_page','2023-06-21 09:52:39','2023-09-08 14:38:39'),(91,'react_download_apps_link_data','{\"react_download_apps_link_status\":\"1\",\"react_download_apps_link\":\"https:\\/\\/www.apple.com\\/app-store\\/\"}','react_landing_page','2023-06-21 09:52:39','2023-06-21 09:52:39'),(92,'news_letter_title','Lets Connect !','react_landing_page','2023-06-21 09:53:57','2023-06-21 09:53:57'),(93,'news_letter_sub_title','Stay upto date with restaurants around you. Subscribe with email.','react_landing_page','2023-06-21 09:53:57','2023-06-21 09:53:57'),(94,'footer_data','is Best Delivery Service Near You','react_landing_page','2023-06-21 09:55:11','2023-06-21 09:55:11'),(95,'promotional_banner_image','2023-09-08-64fc0ca9e4310.png','promotional_banner','2023-09-08 17:11:53','2023-09-08 17:11:53'),(96,'promotional_banner_title','Demo Banner','promotional_banner','2023-09-08 17:11:53','2023-09-08 17:11:53');
/*!40000 ALTER TABLE `data_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery_histories`
--

DROP TABLE IF EXISTS `delivery_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delivery_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery_histories`
--

LOCK TABLES `delivery_histories` WRITE;
/*!40000 ALTER TABLE `delivery_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `delivery_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery_man_wallets`
--

DROP TABLE IF EXISTS `delivery_man_wallets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delivery_man_wallets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_man_id` bigint(20) unsigned NOT NULL,
  `collected_cash` decimal(24,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_earning` decimal(24,2) NOT NULL DEFAULT 0.00,
  `total_withdrawn` decimal(24,2) NOT NULL DEFAULT 0.00,
  `pending_withdraw` decimal(24,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery_man_wallets`
--

LOCK TABLES `delivery_man_wallets` WRITE;
/*!40000 ALTER TABLE `delivery_man_wallets` DISABLE KEYS */;
/*!40000 ALTER TABLE `delivery_man_wallets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery_men`
--

DROP TABLE IF EXISTS `delivery_men`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delivery_men` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) DEFAULT NULL,
  `l_name` varchar(100) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `identity_number` varchar(30) DEFAULT NULL,
  `identity_type` varchar(50) DEFAULT NULL,
  `identity_image` varchar(191) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `auth_token` varchar(191) DEFAULT NULL,
  `fcm_token` varchar(191) DEFAULT NULL,
  `zone_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `earning` tinyint(1) NOT NULL DEFAULT 1,
  `current_orders` int(11) NOT NULL DEFAULT 0,
  `type` varchar(191) NOT NULL DEFAULT 'zone_wise',
  `restaurant_id` bigint(20) DEFAULT NULL,
  `application_status` enum('approved','denied','pending') NOT NULL DEFAULT 'approved',
  `order_count` int(10) unsigned NOT NULL DEFAULT 0,
  `assigned_order_count` int(10) unsigned NOT NULL DEFAULT 0,
  `vehicle_id` bigint(20) unsigned DEFAULT NULL,
  `shift_id` bigint(20) unsigned DEFAULT NULL,
  `additional_data` text DEFAULT NULL,
  `additional_documents` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `delivery_men_phone_unique` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery_men`
--

LOCK TABLES `delivery_men` WRITE;
/*!40000 ALTER TABLE `delivery_men` DISABLE KEYS */;
/*!40000 ALTER TABLE `delivery_men` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disbursement_details`
--

DROP TABLE IF EXISTS `disbursement_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disbursement_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `disbursement_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `disbursement_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `payment_method` bigint(20) unsigned NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disbursement_details`
--

LOCK TABLES `disbursement_details` WRITE;
/*!40000 ALTER TABLE `disbursement_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `disbursement_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disbursement_withdrawal_methods`
--

DROP TABLE IF EXISTS `disbursement_withdrawal_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disbursement_withdrawal_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `withdrawal_method_id` bigint(20) unsigned NOT NULL,
  `method_name` varchar(255) NOT NULL,
  `method_fields` text NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disbursement_withdrawal_methods`
--

LOCK TABLES `disbursement_withdrawal_methods` WRITE;
/*!40000 ALTER TABLE `disbursement_withdrawal_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `disbursement_withdrawal_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disbursements`
--

DROP TABLE IF EXISTS `disbursements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disbursements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `total_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_for` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disbursements`
--

LOCK TABLES `disbursements` WRITE;
/*!40000 ALTER TABLE `disbursements` DISABLE KEYS */;
/*!40000 ALTER TABLE `disbursements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discounts`
--

DROP TABLE IF EXISTS `discounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `min_purchase` decimal(24,2) NOT NULL DEFAULT 0.00,
  `max_discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(15) NOT NULL DEFAULT 'percentage',
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discounts`
--

LOCK TABLES `discounts` WRITE;
/*!40000 ALTER TABLE `discounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `discounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `background_image` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `button_name` varchar(100) DEFAULT NULL,
  `button_url` varchar(255) DEFAULT NULL,
  `footer_text` varchar(255) DEFAULT NULL,
  `copyright_text` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `email_type` varchar(255) DEFAULT NULL,
  `email_template` varchar(255) DEFAULT NULL,
  `privacy` tinyint(1) NOT NULL DEFAULT 0,
  `refund` tinyint(1) NOT NULL DEFAULT 0,
  `cancelation` tinyint(1) NOT NULL DEFAULT 0,
  `contact` tinyint(1) NOT NULL DEFAULT 0,
  `facebook` tinyint(1) NOT NULL DEFAULT 0,
  `instagram` tinyint(1) NOT NULL DEFAULT 0,
  `twitter` tinyint(1) NOT NULL DEFAULT 0,
  `linkedin` tinyint(1) NOT NULL DEFAULT 0,
  `pinterest` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_templates`
--

LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` VALUES (1,'Change Password Request','The following user has forgotten his password &amp; requested to change/reset their password.&nbsp;\r\n\r\n&nbsp;\r\n\r\nUser Name: {userName}',NULL,NULL,NULL,'2023-06-21-64928742ceb74.png','','','Footer Text Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','admin','forget_password','5',1,1,1,1,1,1,1,1,1,1,'2023-06-20 18:19:43','2023-06-21 00:14:42'),(2,'New Restaurant Registration Request','Please find below the details of the new Restaurant registration:\r\n\r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Restaurant from the respective Module, go to:&nbsp;\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;',NULL,'2023-06-21-649287b247980.png','2023-06-21-649287b247c83.png',NULL,'Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','admin','restaurant_registration','1',1,1,1,1,1,1,1,1,1,1,'2023-06-20 18:26:41','2023-06-21 00:16:34'),(3,'New Deliveryman Registration Request','Please find below the details of the new Deliveryman registration:\r\n\r\n&nbsp;\r\n\r\nDeliveryman Name: {deliveryManName}\r\n\r\nTo review the Restaurant from the respective Module, go to:&nbsp;\r\n\r\nDeliveryman Management&rarr;New Deliveryman\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;',NULL,'2023-06-21-649287e9b49f8.png','2023-06-21-649287e9b4d4a.png',NULL,'Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','admin','dm_registration','1',1,1,1,1,1,1,1,1,1,1,'2023-06-20 18:35:57','2023-06-21 00:18:47'),(4,'New Withdraw Request','Please find below the details of the new Withdraw Request:\r\n\r\n \r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Refund Request, go to:&nbsp; \r\nTransactions &amp; Reports&rarr;Withdraw Requests\r\n\r\nOr you can directly review the Restaurant here &rarr;',NULL,NULL,NULL,'2023-06-21-6492898f6f2aa.png','Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','admin','withdraw_request','6',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:24:31','2023-06-21 00:24:31'),(5,'“BUY ONE GET ONE” Campaign Join Request','Please find below the details of the new Campaign Join Request:\r\n\r\n&nbsp;\r\n\r\nRestaurant Name: {restaurantName}\r\n\r\nTo review the Refund Request, go to:&nbsp;\r\n\r\nCampaigns&rarr;Basic Campaigns&rarr;Buy One Get One\r\n\r\n&nbsp;\r\n\r\nOr you can directly review the Restaurant here &rarr;\r\n\r\n&nbsp;',NULL,'2023-06-21-64928a71d990e.png','2023-06-21-64928a71d9bca.png',NULL,'Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','admin','campaign_request','1',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:28:17','2023-06-21 00:28:17'),(6,'You Have A Refund Request.','Please find below the details of the new Refund Request:\r\n\r\n&nbsp;\r\n\r\nCustomer Name: {userName}\r\n\r\nOrder ID: {orderId}\r\n\r\nReview the Restaurant here &rarr;\r\n\r\n&nbsp;',NULL,NULL,'2023-06-21-64928b0c3415a.png',NULL,'Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','admin','refund_request','2',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:30:52','2023-06-21 00:30:52'),(7,'Your Registration has been Submitted Success','Dear {userName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Restaurant Registration Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your Restaurant registration is accepted or declined by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-64928c23e1ee1.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','restaurant','registration','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:35:31','2023-06-21 00:36:15'),(8,'Congratulations! Your Registration is Approve','Dear {userName},\r\n\r\nYour registration is approved by the Admin.&nbsp;\r\n\r\nFirst, you need to log in to your Restaurant panel.&nbsp;\r\n\r\nAfter that, please set up your Restaurant and start selling!&nbsp;\r\n\r\n \r\nClick here &rarr; <a href=\"https://stackfood-admin.6amtech.com/restaurant-panel/business-settings/restaurant-setup\">https://stackfood-admin.6amtech.com/restaurant-panel/business-settings/restaurant-setup</a>',NULL,NULL,NULL,'2023-06-21-64928ccce5098.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 ستاكفود. كل الحقوق محفوظة.','restaurant','approve','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:38:20','2023-06-21 00:38:20'),(9,'Your Registration has been Rejected','Dear {userName} ,&nbsp;\r\n\r\nWe&rsquo;re sorry to announce that your Restaurant registration was rejected by the Admin.&nbsp;\r\n\r\nTo find out more, please contact us.&nbsp;',NULL,NULL,NULL,'2023-06-21-64928d568a579.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','restaurant','deny','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:40:38','2023-06-21 00:40:38'),(10,'Congratulations! Your Withdrawal is Approved!','Dear {userName},\r\n\r\n&nbsp;\r\n\r\nThe amount you requested to withdraw is approved by the Admin and transferred to your bank account.\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-64928df27058a.png','Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','restaurant','withdraw_approve','6',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:43:14','2023-06-21 00:43:14'),(11,'Your Withdraw Request was Rejected.','Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nThe amount you requested to withdraw was rejected by the Admin.\r\n\r\nReason: Insufficient Balance.\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-64928ead57d52.png','Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','restaurant','withdraw_deny','6',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:46:21','2023-06-21 00:46:21'),(12,'Your Request is Completed!','Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Campaign Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your request is approved or rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;',NULL,'2023-06-21-64928f57d4793.png','2023-06-21-64928f57d4a3e.png',NULL,'See Status','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','restaurant','campaign_request','1',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:49:11','2023-06-21 00:50:03'),(13,'Congratulations! Your Request is Approved!','Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nYour request to join &lsquo;&rsquo;BUY ONE GET ONE&rdquo; campaign is approved by the Admin.\r\n\r\n&nbsp;',NULL,'2023-06-21-649290d86eb06.png','2023-06-21-649290d86ede0.png',NULL,'View Status','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','restaurant','campaign_approve','1',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:55:36','2023-06-21 00:55:36'),(14,'Your Campaign Join Request Was Rejected.','Dear {userName},\r\n\r\n&nbsp;\r\n\r\nYour request to join the &ldquo;Buy One Get One&rdquo; campaign was rejected by the admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nReason: Irrelevant Foods.\r\n\r\n&nbsp;',NULL,'2023-06-21-6492918e7d5f6.png','2023-06-21-6492918e7da37.png',NULL,'','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','restaurant','campaign_deny','7',1,1,1,1,1,1,1,1,1,1,'2023-06-21 00:58:38','2023-06-21 00:58:57'),(15,'Your Registration is Completed!','Dear {userName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;ve received your Deliveryman Registration Request.&nbsp;\r\n\r\n&nbsp;\r\n\r\nSoon you&rsquo;ll know if your Deliveryman registration is accepted or declined by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nStay Tuned!\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-649292352bbb1.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','dm','registration','5',1,1,1,0,1,1,1,1,1,1,'2023-06-21 01:01:25','2023-06-21 01:01:25'),(16,'Congratulations! Your Registration is Approve','Dear {deliveryManName} ,\r\n\r\n&nbsp;\r\n\r\nYour registration is approved by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nHere&rsquo;s what to do next:&nbsp;\r\n\r\n<ol>\r\n	<li>Download the Deliveryman app</li>\r\n	<li>Login with the below credentials.</li>\r\n</ol>\r\n\r\nAfter that, please set up your account and start delivery!&nbsp;\r\n\r\n \r\nClick here to download the app&rarr; Download link to the StackFood Deliveryman app',NULL,NULL,NULL,'2023-06-21-649292f1aa096.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','dm','approve','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:04:33','2023-06-21 01:04:47'),(17,'Your Registration has been Rejected','Dear {deliveryManName},\r\n\r\n&nbsp;\r\n\r\nWe&rsquo;re sorry to announce that your Deliveryman registration was rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nTo find out more, please contact us.\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-649293646ff54.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','dm','deny','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:06:28','2023-06-21 01:06:28'),(18,'Your Account is Suspended.','Dear {deliveryManName},\r\n\r\n&nbsp;\r\n\r\nYour Deliveryman account has been suspended by the Admin/Restaurant.&nbsp;\r\n\r\n&nbsp;\r\n\r\nPlease contact the related person to know more.\r\n\r\n&nbsp;',NULL,'2023-06-21-649293fa34204.png','2023-06-21-6492941da37bc.png',NULL,'','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','dm','suspend','7',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:08:58','2023-06-21 01:09:33'),(19,'Cash Collected.','Dear User,\r\n\r\n{transactionId}\r\n\r\nThe Admin has collected cash from you.&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-64929477319d2.png','See Details','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','dm','cash_collect','6',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:11:03','2023-06-21 01:11:03'),(20,'Reset Your Password','Please click on this link to reset your Password&nbsp;&rarr;',NULL,NULL,NULL,'2023-06-21-649294c9ca03d.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','dm','forget_password','4',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:12:25','2023-06-21 01:12:25'),(21,'Your Registration is Successful!','Congratulations!\r\n\r\n&nbsp;\r\n\r\nYou&rsquo;ve successfully registered.\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-6492959c850ac.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','user','registration','5',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:15:56','2023-06-21 01:15:56'),(22,'Please Register with The OTP','ONE MORE STEP:&nbsp;\r\n\r\n&nbsp;\r\n\r\nPlease copy the following OTP &amp; paste it on your sign-up page to complete your registration.\r\n\r\n&nbsp;\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-6492967f1bfac.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','user','registration_otp','4',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:19:43','2023-06-21 01:19:43'),(23,'Confirm Your Login with OTP.','Please copy the following OTP &amp; paste it on your Log in page to confirm your account.\r\n\r\n&nbsp;\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-64929700e4548.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 ستاكفود. كل الحقوق محفوظة.','user','login_otp','4',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:21:13','2023-06-21 01:21:52'),(24,'Please Verify Your Delivery.','Please give the following OTP to your Deliveryman to ensure your order.',NULL,NULL,NULL,'2023-06-21-64929767a486d.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','user','order_verification','4',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:23:35','2023-06-21 01:23:35'),(25,'Your Order is Successful','Hi {userName},\r\n\r\nYour order is successful. Please find your invoice below.\r\n\r\n&nbsp;',NULL,NULL,NULL,NULL,'Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','user','new_order','3',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:25:02','2023-06-21 01:25:02'),(26,'Refund Order','Hi {userName},\r\n\r\nWe&rsquo;ve refunded your requested amount. Please find your refund invoice below.\r\n\r\n&nbsp;',NULL,NULL,NULL,NULL,'','','Please contact us for any queries; we’re always happy to help.','© 2023 Stack Food. All rights reserved.','user','refund_order','9',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:26:53','2023-06-21 01:27:32'),(27,'Your Refund Request was Rejected.','Dear {userName} ,\r\n\r\n&nbsp;\r\n\r\nThe amount you requested for a refund was rejected by the Admin.&nbsp;\r\n\r\n&nbsp;\r\n\r\nTo know more, please contact us.\r\n\r\n&nbsp;',NULL,NULL,'2023-06-21-649298c0949c3.png',NULL,'','','Please contact us for any queries; we’re always happy to help.','© 2023 Stackfood. All rights reserved.','user','refund_request_deny','8',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:29:20','2023-06-21 01:29:20'),(28,'Reset Your Password','Please click on this link to reset your Password&nbsp;&rarr;',NULL,NULL,NULL,'2023-06-21-64929958a6442.png','','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','user','forget_password','4',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:31:52','2023-06-21 01:31:52'),(29,'Fund Added to your Wallet.','Dear {userName}\r\n\r\n&nbsp;\r\n\r\nThe Admin has sent funds to your Wallet.&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;',NULL,NULL,NULL,'2023-06-21-649299ada7670.png','Review Request','','Please contact us for any queries; we’re always happy to help.','© 2023 StackFood. All rights reserved.','user','add_fund','6',1,1,1,1,1,1,1,1,1,1,'2023-06-21 01:33:17','2023-06-21 01:33:17');
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_verifications`
--

DROP TABLE IF EXISTS `email_verifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_verifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) DEFAULT NULL,
  `token` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_verifications`
--

LOCK TABLES `email_verifications` WRITE;
/*!40000 ALTER TABLE `email_verifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `email_verifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_roles`
--

DROP TABLE IF EXISTS `employee_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `modules` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_roles`
--

LOCK TABLES `employee_roles` WRITE;
/*!40000 ALTER TABLE `employee_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `employee_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL DEFAULT 'custom',
  `amount` decimal(23,3) NOT NULL DEFAULT 0.000,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(50) DEFAULT 'admin',
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `food`
--

DROP TABLE IF EXISTS `food`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `food` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(30) DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `category_ids` varchar(191) DEFAULT NULL,
  `variations` text DEFAULT NULL,
  `add_ons` varchar(191) DEFAULT NULL,
  `attributes` varchar(191) DEFAULT NULL,
  `choice_options` text DEFAULT NULL,
  `price` decimal(24,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(24,2) NOT NULL DEFAULT 0.00,
  `tax_type` varchar(20) NOT NULL DEFAULT 'percent',
  `discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(20) NOT NULL DEFAULT 'percent',
  `available_time_starts` time DEFAULT NULL,
  `available_time_ends` time DEFAULT NULL,
  `veg` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_count` int(11) NOT NULL DEFAULT 0,
  `avg_rating` double(16,14) NOT NULL DEFAULT 0.00000000000000,
  `rating_count` int(11) NOT NULL DEFAULT 0,
  `rating` varchar(255) DEFAULT NULL,
  `recommended` tinyint(1) NOT NULL DEFAULT 0,
  `slug` varchar(255) DEFAULT NULL,
  `maximum_cart_quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `food`
--

LOCK TABLES `food` WRITE;
/*!40000 ALTER TABLE `food` DISABLE KEYS */;
INSERT INTO `food` VALUES (1,'Demo Food','Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!','2023-09-08-64fc0b1842f31.png',2,'[{\"id\":\"1\",\"position\":1},{\"id\":\"2\",\"position\":2}]','[{\"name\":\"Vatiation-1\",\"type\":\"single\",\"min\":0,\"max\":0,\"required\":\"on\",\"values\":[{\"label\":\"Small\",\"optionPrice\":\"10\"},{\"label\":\"Large\",\"optionPrice\":\"20\"}]},{\"name\":\"Vatiation-2\",\"type\":\"multi\",\"min\":\"1\",\"max\":\"3\",\"required\":\"off\",\"values\":[{\"label\":\"Demo Option-1\",\"optionPrice\":\"2\"},{\"label\":\"Demo Option-2\",\"optionPrice\":\"3\"},{\"label\":\"Demo Option-3\",\"optionPrice\":\"2\"}]}]','[\"1\"]','[]','[]',100.00,0.00,'percent',10.00,'percent','00:00:00','23:59:00',0,1,1,'2023-09-08 17:05:12','2023-09-08 17:05:12',0,0.00000000000000,0,NULL,0,'demo-food',5);
/*!40000 ALTER TABLE `food` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `food_tag`
--

DROP TABLE IF EXISTS `food_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `food_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `food_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `food_tag`
--

LOCK TABLES `food_tag` WRITE;
/*!40000 ALTER TABLE `food_tag` DISABLE KEYS */;
INSERT INTO `food_tag` VALUES (1,1,1);
/*!40000 ALTER TABLE `food_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `guests`
--

DROP TABLE IF EXISTS `guests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(255) DEFAULT NULL,
  `fcm_token` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `guests`
--

LOCK TABLES `guests` WRITE;
/*!40000 ALTER TABLE `guests` DISABLE KEYS */;
/*!40000 ALTER TABLE `guests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `incentive_logs`
--

DROP TABLE IF EXISTS `incentive_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `incentive_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_man_id` bigint(20) unsigned NOT NULL,
  `zone_id` bigint(20) unsigned NOT NULL,
  `earning` decimal(23,3) NOT NULL DEFAULT 0.000,
  `incentive` decimal(23,3) NOT NULL DEFAULT 0.000,
  `date` date DEFAULT NULL,
  `today_earning` decimal(23,3) NOT NULL DEFAULT 0.000,
  `working_hours` decimal(23,3) NOT NULL DEFAULT 0.000,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `incentive_logs`
--

LOCK TABLES `incentive_logs` WRITE;
/*!40000 ALTER TABLE `incentive_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `incentive_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `incentives`
--

DROP TABLE IF EXISTS `incentives`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `incentives` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint(20) unsigned NOT NULL,
  `earning` decimal(23,3) NOT NULL,
  `incentive` decimal(23,3) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `incentives`
--

LOCK TABLES `incentives` WRITE;
/*!40000 ALTER TABLE `incentives` DISABLE KEYS */;
/*!40000 ALTER TABLE `incentives` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item_campaigns`
--

DROP TABLE IF EXISTS `item_campaigns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_campaigns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `admin_id` bigint(20) unsigned NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `category_ids` varchar(191) DEFAULT NULL,
  `variations` text DEFAULT NULL,
  `add_ons` varchar(191) DEFAULT NULL,
  `attributes` varchar(191) DEFAULT NULL,
  `choice_options` text DEFAULT NULL,
  `price` decimal(24,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(24,2) NOT NULL DEFAULT 0.00,
  `tax_type` varchar(20) NOT NULL DEFAULT 'percent',
  `discount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `discount_type` varchar(20) NOT NULL DEFAULT 'percent',
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `veg` tinyint(1) NOT NULL DEFAULT 0,
  `slug` varchar(255) DEFAULT NULL,
  `maximum_cart_quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item_campaigns`
--

LOCK TABLES `item_campaigns` WRITE;
/*!40000 ALTER TABLE `item_campaigns` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_campaigns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `logable_id` bigint(20) unsigned NOT NULL,
  `logable_type` varchar(255) NOT NULL,
  `action_type` varchar(50) NOT NULL,
  `model` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `action_details` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `before_state` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`before_state`)),
  `after_state` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`after_state`)),
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logs`
--

LOCK TABLES `logs` WRITE;
/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loyalty_point_transactions`
--

DROP TABLE IF EXISTS `loyalty_point_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `loyalty_point_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_id` char(36) NOT NULL,
  `credit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `debit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `balance` decimal(24,3) NOT NULL DEFAULT 0.000,
  `reference` varchar(191) DEFAULT NULL,
  `transaction_type` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loyalty_point_transactions`
--

LOCK TABLES `loyalty_point_transactions` WRITE;
/*!40000 ALTER TABLE `loyalty_point_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `loyalty_point_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mail_configs`
--

DROP TABLE IF EXISTS `mail_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mail_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `host` varchar(191) NOT NULL,
  `driver` varchar(191) NOT NULL,
  `port` varchar(191) NOT NULL,
  `username` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `encryption` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_configs`
--

LOCK TABLES `mail_configs` WRITE;
/*!40000 ALTER TABLE `mail_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `mail_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `conversation_id` bigint(20) unsigned DEFAULT NULL,
  `sender_id` bigint(20) unsigned DEFAULT NULL,
  `message` text DEFAULT NULL,
  `file` varchar(100) DEFAULT NULL,
  `is_seen` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=364 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2021_05_05_081114_create_admins_table',1),(5,'2021_05_05_102600_create_attributes_table',1),(6,'2021_05_05_102742_create_categories_table',1),(7,'2021_05_06_102004_create_vendors_table',1),(8,'2021_05_06_153204_create_restaurants_table',1),(9,'2021_05_08_113436_create_add_ons_table',2),(47,'2021_05_08_123446_create_food_table',10),(48,'2021_05_08_141209_create_currencies_table',10),(49,'2021_05_09_050232_create_orders_table',10),(50,'2021_05_09_051907_create_reviews_table',10),(51,'2021_05_09_054237_create_order_details_table',10),(52,'2021_05_10_105324_create_mail_configs_table',10),(53,'2021_05_10_152713_create_business_settings_table',10),(54,'2021_05_11_111722_create_banners_table',11),(55,'2021_05_11_134442_create_coupons_table',11),(56,'2021_05_12_053344_create_conversations_table',11),(57,'2021_05_12_055454_create_delivery_men_table',12),(58,'2021_05_12_060138_create_d_m_reviews_table',12),(59,'2021_05_12_060527_create_track_deliverymen_table',12),(60,'2021_05_12_061345_create_email_verifications_table',12),(61,'2021_05_12_061454_create_delivery_histories_table',12),(62,'2021_05_12_061718_create_wishlists_table',12),(63,'2021_05_12_061924_create_notifications_table',12),(64,'2021_05_12_062152_create_customer_addresses_table',12),(68,'2021_05_12_062412_create_order_delivery_histories_table',13),(69,'2021_05_19_115112_create_zones_table',13),(70,'2021_05_19_120612_create_restaurant_zone_table',13),(71,'2021_06_07_103835_add_column_to_vendor_table',14),(73,'2021_06_07_112335_add_column_to_vendors_table',15),(74,'2021_06_08_162354_add_column_to_restaurants_table',16),(77,'2021_06_09_115719_add_column_to_add_ons_table',17),(78,'2021_06_10_091547_add_column_to_coupons_table',18),(79,'2021_06_12_070530_rename_banners_table',19),(80,'2021_06_12_091154_add_column_on_campaigns_table',20),(87,'2021_06_12_091848_create_item_campaigns_table',21),(92,'2021_06_13_155531_create_campaign_restaurant_table',22),(93,'2021_06_14_090520_add_item_campaign_id_column_to_reviews_table',23),(94,'2021_06_14_091735_add_item_campaign_id_column_to_order_details_table',24),(95,'2021_06_14_120713_create_new_banners_table',25),(96,'2021_06_15_103656_add_zone_id_column_to_banners_table',26),(97,'2021_06_16_110322_create_discounts_table',27),(100,'2021_06_17_150243_create_withdraw_requests_table',28),(103,'2016_06_01_000001_create_oauth_auth_codes_table',30),(104,'2016_06_01_000002_create_oauth_access_tokens_table',30),(105,'2016_06_01_000003_create_oauth_refresh_tokens_table',30),(106,'2016_06_01_000004_create_oauth_clients_table',30),(107,'2016_06_01_000005_create_oauth_personal_access_clients_table',30),(108,'2021_06_21_051135_add_delivery_charge_to_orders_table',31),(110,'2021_06_23_080009_add_role_id_to_admins_table',32),(111,'2021_06_27_140224_add_interest_column_to_users_table',33),(113,'2021_06_27_142558_change_column_to_restaurants_table',34),(114,'2021_06_27_152139_add_restaurant_id_column_to_wishlists_table',35),(115,'2021_06_28_142443_add_restaurant_id_column_to_customer_addresses_table',36),(118,'2021_06_29_134119_add_schedule_column_to_orders_table',37),(122,'2021_06_30_084854_add_cm_firebase_token_column_to_users_table',38),(123,'2021_06_30_133932_add_code_column_to_coupons_table',39),(127,'2021_07_01_151103_change_column_food_id_from_admin_wallet_histories_table',40),(129,'2021_07_04_142159_add_callback_column_to_orders_table',41),(131,'2021_07_05_155506_add_cm_firebase_token_to_vendors_table',42),(133,'2021_07_05_162404_add_otp_to_orders_table',43),(134,'2021_07_13_133941_create_admin_roles_table',44),(135,'2021_07_14_074431_add_status_to_delivery_men_table',45),(136,'2021_07_14_104102_create_vendor_employees_table',46),(137,'2021_07_14_110011_create_employee_roles_table',46),(138,'2021_07_15_124141_add_cover_photo_to_restaurants_table',47),(143,'2021_06_17_145949_create_wallets_table',48),(144,'2021_06_19_052600_create_admin_wallets_table',48),(145,'2021_07_19_103748_create_delivery_man_wallets_table',48),(146,'2021_07_19_105442_create_account_transactions_table',48),(147,'2021_07_19_110152_create_order_transactions_table',48),(148,'2021_07_19_134356_add_column_to_notifications_table',49),(149,'2021_07_25_125316_add_available_to_delivery_men_table',50),(150,'2021_07_25_154722_add_columns_to_restaurants_table',51),(151,'2021_07_29_162336_add_schedule_order_column_to_restaurants_table',52),(152,'2021_07_31_140756_create_phone_verifications_table',53),(153,'2021_08_01_151717_add_column_to_order_transactions_table',54),(154,'2021_08_01_163520_add_column_to_admin_wallets_table',54),(155,'2021_08_02_141909_change_time_column_to_restaurants_table',55),(157,'2021_08_02_183356_add_tax_column_to_restaurants_table',56),(158,'2021_08_04_215618_add_zone_id_column_to_restaurants_table',57),(159,'2021_08_06_123001_add_address_column_to_orders_table',58),(160,'2021_08_06_123326_add_zone_wise_topic_column_to_zones_table',58),(161,'2021_08_08_112127_add_scheduled_column_on_orders_table',59),(162,'2021_08_08_203108_add_status_column_to_users_table',60),(163,'2021_08_11_193805_add_product_discount_ammount_column_to_orders_table',61),(165,'2021_08_12_112511_add_addons_column_to_order_details_table',62),(166,'2021_08_12_195346_add_zone_id_to_notifications_table',63),(167,'2021_08_14_110131_create_user_notifications_table',64),(168,'2021_08_14_175657_add_order_count_column_to_foods_table',65),(169,'2021_08_14_180044_add_order_count_column_to_users_table',65),(170,'2021_08_19_051055_add_earnign_column_to_deliverymen_table',66),(171,'2021_08_19_051721_add_original_delivery_charge_column_to_orders_table',66),(172,'2021_08_19_055839_create_provide_d_m_earnings_table',67),(173,'2021_08_19_112810_add_original_delivery_charge_column_to_order_transactions_table',67),(174,'2021_08_19_114851_add_columns_to_delivery_man_wallets_table',67),(175,'2021_08_21_162616_change_comission_column_to_restaurants_table',68),(176,'2021_06_17_054551_create_soft_credentials_table',69),(177,'2021_08_22_232507_add_failed_column_to_orders_table',69),(178,'2021_09_04_172723_add_column_reviews_section_to_restaurants_table',69),(179,'2021_09_11_164936_change_delivery_address_column_to_orders_table',70),(180,'2021_09_11_165426_change_address_column_to_customer_addresses_table',70),(181,'2021_09_23_120332_change_available_column_to_delivery_men_table',71),(182,'2021_10_03_214536_add_active_column_to_restaurants_table',72),(183,'2021_10_04_123739_add_priority_column_to_categories_table',72),(184,'2021_10_06_200730_add_restaurant_id_column_to_demiverymen_table',72),(185,'2021_10_07_223332_add_self_delivery_column_to_restaurants_table',72),(186,'2021_10_11_214123_change_add_ons_column_to_order_details_table',72),(187,'2021_10_11_215352_add_adjustment_column_to_orders_table',72),(188,'2021_10_24_184553_change_column_to_account_transactions_table',73),(189,'2021_10_24_185143_change_column_to_add_ons_table',73),(190,'2021_10_24_185525_change_column_to_admin_roles_table',73),(191,'2021_10_24_185831_change_column_to_admin_wallets_table',73),(192,'2021_10_24_190550_change_column_to_coupons_table',73),(193,'2021_10_24_190826_change_column_to_delivery_man_wallets_table',73),(194,'2021_10_24_191018_change_column_to_discounts_table',73),(195,'2021_10_24_191209_change_column_to_employee_roles_table',73),(196,'2021_10_24_191343_change_column_to_food_table',73),(197,'2021_10_24_191514_change_column_to_item_campaigns_table',73),(198,'2021_10_24_191626_change_column_to_orders_table',73),(199,'2021_10_24_191938_change_column_to_order_details_table',73),(200,'2021_10_24_192341_change_column_to_order_transactions_table',73),(201,'2021_10_24_192621_change_column_to_provide_d_m_earnings_table',73),(202,'2021_10_24_192820_change_column_type_to_restaurants_table',73),(203,'2021_10_24_192959_change_column_type_to_restaurant_wallets_table',73),(204,'2021_11_02_123115_add_delivery_time_column_to_restaurants_table',74),(205,'2021_11_02_170217_add_total_uses_column_to_coupons_table',74),(206,'2021_12_01_131746_add_status_column_to_reviews_table',75),(207,'2021_12_01_135115_add_status_column_to_d_m_reviews_table',75),(208,'2021_12_13_125126_rename_comlumn_set_menu_to_food_table',75),(209,'2021_12_13_132438_add_zone_id_column_to_admins_table',75),(210,'2021_12_18_174714_add_application_status_column_to_delivery_men_table',75),(211,'2021_12_20_185736_change_status_column_to_vendors_table',75),(212,'2021_12_22_114414_create_translations_table',75),(213,'2022_01_05_133920_add_sosial_data_column_to_users_table',75),(214,'2022_01_05_172441_add_veg_non_veg_column_to_restaurants_table',75),(215,'2022_01_20_151449_add_restaurant_id_column_on_employee_roles_table',76),(216,'2022_01_31_124517_add_veg_column_to_item_campaigns_table',76),(217,'2022_02_01_101248_change_coupon_code_column_length_to_coupons_table',76),(218,'2022_02_01_104336_change_column_length_to_notifications_table',76),(219,'2022_02_06_160701_change_column_length_to_item_campaigns_table',76),(220,'2022_02_06_161110_change_column_length_to_campaigns_table',76),(221,'2022_02_07_091359_add_zone_id_column_on_orders_table',76),(222,'2022_02_07_101547_change_name_column_to_categories_table',76),(223,'2022_02_07_152844_add_zone_id_column_to_order_transactions_table',76),(224,'2022_02_07_162330_add_zone_id_column_to_users_table',76),(225,'2022_02_07_173644_add_column_to_food_table',76),(226,'2022_02_07_181314_add_column_to_delivery_men_table',76),(227,'2022_02_07_183001_add_total_order_count_column_to_restaurants_table',76),(228,'2022_01_19_060356_create_restaurant_schedule_table',77),(229,'2022_03_31_103418_create_wallet_transactions_table',78),(230,'2022_03_31_103827_create_loyalty_point_transactions_table',78),(231,'2022_04_09_161150_add_wallet_point_columns_to_users_table',78),(232,'2022_04_12_121040_create_social_media_table',78),(233,'2022_04_17_140353_change_column_transaction_referance_to_orders_table',78),(234,'2022_04_10_030533_create_newsletters_table',79),(235,'2022_05_14_122133_add_dm_tips_column_to_orders_table',80),(236,'2022_05_14_122603_add_dm_tips_column_to_order_transactions_table',80),(237,'2022_05_14_131338_add_processing_time_column_to_orders_table',80),(238,'2022_05_17_153333_add_ref_code_to_users_table',80),(239,'2022_05_22_162129_add_new_columns_to_customer_addresses_table',80),(240,'2022_06_26_170341_add_delivery_fee_comission_to_ordertransactions',80),(241,'2022_06_29_112637_add_delivery_fee_column_to_zones_table',80),(242,'2022_06_29_125553_add_rename_delivery_charge_column_to_restaurants_table',80),(243,'2022_06_29_151416_create_time_logs_table',80),(244,'2022_07_31_103626_add_free_delivery_by_column_to_orders_table',81),(245,'2022_08_06_122044_create_user_infos_table',82),(246,'2022_08_06_124645_create_messages_table',82),(247,'2022_08_16_095504_update_converstions_table',82),(248,'2022_09_13_113428_change_data_column_to_user_notifications_table',83),(249,'2022_09_20_002050_create_refunds_table',84),(250,'2022_09_20_050949_add_refund_request_cancel_column_to_orders_table',84),(251,'2022_09_20_233442_create_refund_reasons_table',84),(252,'2022_09_29_095242_create_subscription_packages_table',84),(253,'2022_09_29_101701_create_restaurant_subscriptions_table',84),(254,'2022_09_29_102521_create_subscription_transactions_table',84),(255,'2022_10_04_094314_add_restaurant_model_column_to_restaurants_table',84),(256,'2022_11_05_105722_alter_table_order_details_change_variation',84),(257,'2022_11_13_144443_create_contact_messages_table',84),(258,'2022_11_16_091912_create_expenses_table',84),(259,'2022_11_16_092235_add_expense_column_to_order_transactions_table',84),(260,'2023_01_05_153438_add_status_col_to_campaign_restaurant_table',85),(261,'2023_01_07_162303_add_maximum_delivery_charge_col_to_zones_table',85),(262,'2023_01_07_162740_add_maximum_delivery_charge_col_to_restaurants_table',85),(263,'2023_01_08_104102_create_vehicles_table',85),(264,'2023_01_08_124859_add_vehicle_id_col_to_delivery_men_table',85),(265,'2023_01_08_152910_create_tags_table',85),(266,'2023_01_08_153321_create_food_tags_table',85),(267,'2023_01_09_115851_add_max_cod_order_amount_col_to_zones_table',85),(268,'2023_01_09_132704_create_order_cancel_reasons_table',85),(269,'2023_01_09_132841_add_cancellation_reason_col_to_orders_table',85),(270,'2023_01_09_173540_add_recommended_col_to_foods_table',85),(271,'2023_01_09_180114_create_cuisines_table',85),(272,'2023_01_09_180928_add_cuisine_id_col_to_restaurants_table',85),(273,'2023_01_10_112851_alter_refund_amount_col_to_refunds_table',85),(274,'2023_01_10_175439_add_tax_status_col_to_orders_table',85),(275,'2023_01_11_142252_add_customer_id_col_to_coupons_table',85),(276,'2023_01_12_142420_add_restaurant_id_col_to_expenses_table',85),(277,'2023_01_12_143506_add_restaurant_expense_col_to_order_transactions_table',85),(278,'2023_01_12_145658_add_coupon_created_by_col_to_orders_table',85),(279,'2023_01_14_103226_add_slug_by_col_to_campaigns_table',85),(280,'2023_01_14_105544_add_slug_col_to_categories_table',85),(281,'2023_01_14_105607_add_slug_by_col_to_restaurants_table',85),(282,'2023_01_24_152947_add_vehicle_id_col_to_orders_table',85),(283,'2023_01_25_133959_add_slug_col_to_food_table',85),(284,'2023_01_25_145750_add_slug_col_to_item_campaigns_table',85),(285,'2023_01_28_100238_remane_discription_col_to__order_id_to_expenses_table',85),(286,'2023_01_28_100425_add_description_col_to_expenses_table',85),(287,'2023_01_28_161813_create_cuisine_restaurants_table',85),(288,'2023_01_28_185144_remove_col_cuisine_id_from_restaurant_table',85),(289,'2023_01_30_121227_add_col_to_discount_on_product_by_order_table',85),(290,'2023_02_01_114155_add_distance_col_to_orders_table',85),(291,'2023_02_01_151408_add_commission_percentage_col_to_order_transactions_table',85),(292,'2023_02_01_182929_add_discount_amount_by_restaurant_col_to_order_transactions_table',85),(293,'2023_02_06_121643_add_fcm_token_web_to_vendors_table',85),(294,'2023_02_08_113749_add_ref_by_col_to_users_table',86),(295,'2023_02_08_163747_create_withdrawal_methods_table',86),(296,'2023_02_08_165109_add_cols_to_withdraw_requests_table',86),(297,'2023_02_14_112313_create_incentive_logs_table',86),(298,'2023_02_14_112417_create_incentives_table',86),(299,'2023_02_14_165851_add_delivery_man_id_col_to_wallet_transactions_table',86),(300,'2023_02_14_172250_change_amount_col_to_expenses_table',86),(301,'2023_02_15_131107_add_otp_hit_count_cols_in_phone_verifications_table',86),(302,'2023_02_16_104809_add_hit_count_at_col_in_password_resets_table',86),(303,'2023_02_16_123420_add_increased_delivery_fee_in_zones_table',86),(304,'2023_02_16_145350_create_shifts_table',86),(305,'2023_02_16_145830_add_shift_id_col_to_time_logs_table',86),(306,'2023_02_16_145934_add_shift_id_col_to_delivery_men_table',86),(307,'2023_02_18_070327_create_subscriptions_table',86),(308,'2023_02_18_070628_create_subscription_logs_table',86),(309,'2023_02_18_070757_create_subscription_pauses_table',86),(310,'2023_02_18_070826_create_subscription_schedules_table',86),(311,'2023_02_18_071042_add_subscription_id_col_to_order_table',86),(312,'2023_02_18_071609_add_is_subscription_order_col_to_order_transactions_table',86),(313,'2023_02_19_164536_create_visitor_logs_table',86),(314,'2023_03_11_120645_add_temp_block_time_col_to_phone_verifications_table',86),(315,'2023_03_11_121000_add_temp_block_time_col_to_password_resets_table',86),(316,'2023_03_16_163907_add_order_subscription_col_in_restaurant_table',86),(317,'2023_03_18_121906_add_order_cancel_note_col_in_orders_table',86),(318,'2023_03_18_144849_add_temp_token_col_in_users_table',86),(319,'2023_03_19_153620_add_increase_delivery_charge_message_col_in_zones_table',86),(320,'2023_03_13_144714_create_logs_table',87),(321,'2023_04_08_132653_add_created_by_col_to_password_resets_table',87),(322,'2023_04_17_112228_create_notification_messages_table',87),(323,'2023_05_07_155839_change_delivery_charge_col_in_admin_wallets_table',87),(324,'2023_05_10_162452_create_admin_testimonials_table',87),(325,'2023_05_10_184114_create_data_settings_table',87),(326,'2023_05_13_115610_create_admin_features_table',87),(327,'2023_05_14_092428_create_react_services_table',87),(328,'2023_05_14_104308_create_react_promotional_banners_table',87),(329,'2023_05_18_161133_create_email_templates_table',87),(330,'2023_05_31_154309_create_admin_special_criterias_table',87),(331,'2023_06_11_040112_add_cutlery_col_in_orders_table',87),(332,'2023_06_11_171524_change_delivery_time_col_in_restaurants_table',87),(333,'2023_06_13_112622_add_cutlery_on_restaurants_table',87),(334,'2023_07_05_135741_add_service_charge_col_to_orders_table',88),(335,'2023_07_05_145800_add_service_charge_col_to_order_transactions_table',88),(336,'2023_07_25_130949_create_wallet_payments_table',88),(337,'2023_07_25_131036_create_wallet_bonuses_table',88),(338,'2023_07_25_131958_add_user_id_col_expenses_table',88),(339,'2023_07_26_171058_create_order_payments_table',88),(340,'2023_07_31_235517_add_maximum_cart_quantity_col_to_food',88),(341,'2023_07_31_235555_add_maximum_cart_quantity_col_to_item_campaigns',88),(342,'2023_08_02_043239_add_meta_data_to_restaurants_table',88),(343,'2023_08_05_232205_add_payment_status_to_subscription_transactions_table',88),(344,'0000_00_00_000000_create_websockets_statistics_entries_table',89),(345,'2023_08_30_130431_create_offline_payment_methods_table',89),(346,'2023_08_30_130446_create_offline_payments_table',89),(347,'2023_08_30_162632_add_announcement_cols_to_restaurants_table',89),(348,'2023_08_30_171559_create_guests_table',89),(349,'2023_08_30_181336_add_is_guest_col_to_orders_table',89),(350,'2023_09_03_174650_add_qr_code_col_to_restaurants_table',89),(351,'2023_10_02_114519_create_carts_table',89),(352,'2023_10_04_142129_add_free_delivery_distance_col_to_restaurants_table',89),(353,'2023_10_18_124954_create_restaurant_configs_table',89),(354,'2023_10_19_093057_create_restaurant_tags_table',89),(355,'2023_10_22_183705_add_additional_data_col_in_restaurants_table',89),(356,'2023_10_25_173519_add_additional_data_col_to_delivery_men_table',89),(357,'2023_10_26_105254_change_name_col_on_user_infos',89),(358,'2023_10_29_114625_add_created_by_col_to_account_transactions_table',89),(359,'2023_10_29_161701_create_disbursements_table',89),(360,'2023_10_29_161757_create_disbursement_details_table',89),(361,'2023_10_29_183055_create_disbursement_withdrawal_methods_table',89),(362,'2023_10_30_093234_add_type_col_to_withdraw_requests_table',89),(363,'2023_11_21_132325_add_current_language_key_col_to_users_table',90);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `newsletters`
--

DROP TABLE IF EXISTS `newsletters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `newsletters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL COMMENT 'Subscribers email',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `newsletters_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `newsletters`
--

LOCK TABLES `newsletters` WRITE;
/*!40000 ALTER TABLE `newsletters` DISABLE KEYS */;
/*!40000 ALTER TABLE `newsletters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_messages`
--

DROP TABLE IF EXISTS `notification_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_messages`
--

LOCK TABLES `notification_messages` WRITE;
/*!40000 ALTER TABLE `notification_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tergat` varchar(191) DEFAULT NULL,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_tokens`
--

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
INSERT INTO `oauth_access_tokens` VALUES ('02c187400441f53687a30af580361503d21ab9e30fc263f729536e3e6fb8e013c5f10f170df66154',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-14 07:26:44','2021-08-14 07:26:44','2022-08-14 13:26:44'),('03652f98734cb46633be656afd61eb9d6bef93da6cb3f97e5d862e758bc8a7458f4271c9fc525a03',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-04 04:56:56','2021-07-04 04:56:56','2022-07-04 10:56:56'),('0c0698d04088cdad39a6551a639e02242373bd8cb6e115ff58d9ab11357d3295c6ba0edc08176abb',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 23:08:38','2022-07-03 23:08:38','2023-07-04 05:08:38'),('0ce77d214106aa7d2691f22e57a52d61e83c4a74e232b6cf6409728c337a731412d5f011c265abf9',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-08 14:51:24','2021-08-08 14:51:24','2022-08-08 20:51:24'),('1796645666d7dd6ef53186e095fb9c39d2128e5cca19f2e1ac8e7e7da82d6174fe98b14e94925188',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-04 07:35:29','2021-08-04 07:35:29','2022-08-04 13:35:29'),('2919672ecc1e3dd9f2759d15f8cc54882d1d9f780cfda82fb83c8359de8654492ea6703956a7c50d',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-15 08:22:28','2021-07-15 08:22:28','2022-07-15 14:22:28'),('2f49586a4ac33179f846e60afba15e655ceef494cd64f6812d4ab109336f5fb008cb3005137f700c',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-03 13:21:13','2021-08-03 13:21:13','2022-08-03 19:21:13'),('3115e428f22908fa2d94bf2804d1ed2d9929cb27da233aedf24c8bc71dc8066f91b0c63a795c26e9',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-31 08:33:37','2021-07-31 08:33:37','2022-07-31 14:33:37'),('36217e984b8904eb4dfd30ed62eef9d725c1e8e63a6c1485bb084ef323ad5eea852c84e17560bd54',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-14 00:51:51','2021-07-14 00:51:51','2022-07-14 06:51:51'),('3abfb4980fdf3c858e1c371352db40dae9e1e40f095b00dcd09c84ff7c8189a305f1be985e4274b3',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-19 03:50:53','2021-06-19 03:50:53','2022-06-19 09:50:53'),('3cd3269423e543961a7b64e8169875725eb47f8d0f309c69a4a770258de65e9c02057ed9000942da',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-04 07:35:04','2021-08-04 07:35:04','2022-08-04 13:35:04'),('3e923b1f4084faba1a2e5448bd8b72e09b74db6ed25fbe14f6960a5f005107496cc507c1ba15c6e1',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-22 01:32:58','2021-06-22 01:32:58','2022-06-22 07:32:58'),('4140d5b9b3d16e4bbef1b676b01f13f75d9c3fb2cada6548e50b0b2679562aace3b9b44f82f15f30',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-19 17:10:26','2021-08-19 17:10:26','2022-08-19 23:10:26'),('42ee059b49880163a34848cfc528e347915f9b9358c4b69c8d98fb1dd17492e4917198a77a6d81b6',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 22:59:58','2022-07-03 22:59:58','2023-07-04 04:59:58'),('4cfad08796e4a1eecfe8bbdc20e512e0954570168990fa60442ad41b5ecf05e4005cadcae08fbddd',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-19 03:29:52','2021-06-19 03:29:52','2022-06-19 09:29:52'),('53afc11b36d08435d8ec82c42305f7aa4397d10b2d296f6e7d819e091d0d7c6d48e14cdc5e66e6c9',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-23 23:08:01','2021-06-23 23:08:01','2022-06-24 05:08:01'),('5646d6337aaed0e662c059ed368372e2da241ff97a42df56310667ec321fdbf2252d92771988640a',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-04 07:37:55','2021-08-04 07:37:55','2022-08-04 13:37:55'),('57cc3fb7ede5d1b60a4fb23218a28d0e49daee4ded226e584f03adb4c87547860e99eb18d0f28def',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 23:09:37','2022-07-03 23:09:37','2023-07-04 05:09:37'),('59551e481bc1fb037bee07e1501d81dad38d4ff34fdca68a49c40d0cf423176ca111940acd359aeb',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-08 14:50:59','2021-08-08 14:50:59','2022-08-08 20:50:59'),('68b06321c4bbbea81e7dfcbd8d5fae1a94a2fa0500041ee5774be2d9300c1ff7590d03604b77514a',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-28 02:33:54','2021-07-28 02:33:54','2022-07-28 08:33:54'),('723ceee668cd1a7fc2e977be48cab3f31aed1ace0883692711b5cc2ddf42c2f23c6d75461172105f',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-01 05:46:27','2021-07-01 05:46:27','2022-07-01 11:46:27'),('74e2dd27429bb92c12e33f891ccff32f48c22463166666705d145cfd8968d96ec992fa2cc3a36e76',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-23 23:08:23','2021-06-23 23:08:23','2022-06-24 05:08:23'),('77c9389b2ab3031e09005a7e7be90d00496ff073dbbefeb57229cee5d0a240376c1f7c3c8a94faff',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-19 03:38:22','2021-06-19 03:38:22','2022-06-19 09:38:22'),('7cf10043f8e537bf9b773fb421598ef009714321483c7e542c4ceeb69b374cd81a9f6167ec271826',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 23:04:52','2022-07-03 23:04:52','2023-07-04 05:04:52'),('8a20c4f8656e404615f9abc15a95f6754dd87e4e894677647dd17236b95d8a5d7cc243c38457b048',56,1,'RestaurantCustomerAuth','[]',0,'2021-07-04 02:36:57','2021-07-04 02:36:57','2022-07-04 08:36:57'),('8b46ab5b929aa6097229e3606d70d25ed30993640f567aa79dd002d9f55527bc6144af164aee97a2',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 23:11:21','2022-07-03 23:11:21','2023-07-04 05:11:21'),('8ffc458ddbcbbbec17035dc2153c4baeebb5c54796b3a9008f24c8699197a8a2fc1111c36cc1d7da',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-14 07:27:12','2021-08-14 07:27:12','2022-08-14 13:27:12'),('a092dc4a49ec27a06d8c9c335446de3d90e03363c6059cdf6fbf2113edaab5fe752053a794ac9236',56,1,'RestaurantCustomerAuth','[]',0,'2021-08-08 10:12:49','2021-08-08 10:12:49','2022-08-08 16:12:49'),('b4651c7e8bbe8a68b4959504c3a7e3705208cbdb79fcc2498b9b3d0efa9c7cadc77699590cf8f2d4',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-20 03:59:46','2021-06-20 03:59:46','2022-06-20 09:59:46'),('bf24e16194d82c4e2982724df0fef68f7923d6d01ce8c5e1b64e2716d2412db6e62891f0f8dae8a6',57,1,'RestaurantCustomerAuth','[]',0,'2021-07-31 08:34:19','2021-07-31 08:34:19','2022-07-31 14:34:19'),('c1b7df78e7373f5eca5f64083ac9bbc6c9bd582adf6c143f520c8a65420d3ee050044e6f65f0a033',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-24 03:40:43','2021-06-24 03:40:43','2022-06-24 09:40:43'),('dd6578c99fc90f666b9433871d28f9913fefc860d9a60427388cfcf727be6f5c10eb8b764b39c557',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-28 10:20:50','2021-06-28 10:20:50','2022-06-28 16:20:50'),('ea3ca170bd7935fe3f2a9c80c74d1e8e6eda8cc197ce2066305a286d175ad250475a4657e498779b',56,1,'RestaurantCustomerAuth','[]',0,'2021-06-21 01:24:25','2021-06-21 01:24:25','2022-06-21 07:24:25'),('f0e9bba3e6ba5a0dd39acea36fc1b4f278349e61af71fe79a1b88539e88b631122e4364bb59f0634',1,1,'RestaurantCustomerAuth','[]',0,'2022-07-03 23:07:01','2022-07-03 23:07:01','2023-07-04 05:07:01');
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_codes`
--

DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_codes`
--

LOCK TABLES `oauth_auth_codes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `redirect` text 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,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_clients`
--

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
INSERT INTO `oauth_clients` VALUES (1,NULL,'Laravel Personal Access Client','qFAwGhxq8A6SDmolyxZunXyQ4mxOH0jEezXsgaxP',NULL,'http://localhost',1,0,0,'2021-06-19 03:27:59','2021-06-19 03:27:59'),(2,NULL,'Laravel Password Grant Client','qdV021R3MGGAwRxvvqG0mWgnypwzolzusBq1L5W6','users','http://localhost',0,1,0,'2021-06-19 03:27:59','2021-06-19 03:27:59');
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_personal_access_clients`
--

DROP TABLE IF EXISTS `oauth_personal_access_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_personal_access_clients`
--

LOCK TABLES `oauth_personal_access_clients` WRITE;
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2021-06-19 03:27:59','2021-06-19 03:27:59');
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_refresh_tokens`
--

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offline_payment_methods`
--

DROP TABLE IF EXISTS `offline_payment_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offline_payment_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_name` varchar(255) NOT NULL,
  `method_fields` text NOT NULL,
  `method_informations` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offline_payment_methods`
--

LOCK TABLES `offline_payment_methods` WRITE;
/*!40000 ALTER TABLE `offline_payment_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `offline_payment_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offline_payments`
--

DROP TABLE IF EXISTS `offline_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offline_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `payment_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_info`)),
  `status` varchar(10) NOT NULL DEFAULT 'pending',
  `note` text DEFAULT NULL,
  `customer_note` text DEFAULT NULL,
  `method_fields` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offline_payments`
--

LOCK TABLES `offline_payments` WRITE;
/*!40000 ALTER TABLE `offline_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `offline_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_cancel_reasons`
--

DROP TABLE IF EXISTS `order_cancel_reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_cancel_reasons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reason` varchar(255) NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_cancel_reasons`
--

LOCK TABLES `order_cancel_reasons` WRITE;
/*!40000 ALTER TABLE `order_cancel_reasons` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_cancel_reasons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_delivery_histories`
--

DROP TABLE IF EXISTS `order_delivery_histories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_delivery_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `start_location` varchar(191) DEFAULT NULL,
  `end_location` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_delivery_histories`
--

LOCK TABLES `order_delivery_histories` WRITE;
/*!40000 ALTER TABLE `order_delivery_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_delivery_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_details`
--

DROP TABLE IF EXISTS `order_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `food_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `price` decimal(24,2) NOT NULL DEFAULT 0.00,
  `food_details` text DEFAULT NULL,
  `variation` text DEFAULT NULL,
  `add_ons` text DEFAULT NULL,
  `discount_on_food` decimal(24,2) DEFAULT NULL,
  `discount_type` varchar(20) NOT NULL DEFAULT 'amount',
  `quantity` int(11) NOT NULL DEFAULT 1,
  `tax_amount` decimal(24,2) NOT NULL DEFAULT 1.00,
  `variant` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `item_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `total_add_on_price` decimal(24,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_details`
--

LOCK TABLES `order_details` WRITE;
/*!40000 ALTER TABLE `order_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_payments`
--

DROP TABLE IF EXISTS `order_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `transaction_ref` varchar(255) DEFAULT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `payment_status` varchar(50) NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_payments`
--

LOCK TABLES `order_payments` WRITE;
/*!40000 ALTER TABLE `order_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_transactions`
--

DROP TABLE IF EXISTS `order_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` bigint(20) unsigned NOT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `order_amount` decimal(24,2) NOT NULL,
  `restaurant_amount` decimal(24,2) NOT NULL,
  `admin_commission` decimal(24,2) NOT NULL,
  `received_by` varchar(191) NOT NULL,
  `status` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  `original_delivery_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(24,2) NOT NULL DEFAULT 0.00,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  `dm_tips` double(24,2) NOT NULL DEFAULT 0.00,
  `delivery_fee_comission` double(24,2) NOT NULL DEFAULT 0.00,
  `admin_expense` decimal(23,3) DEFAULT 0.000,
  `restaurant_expense` double(23,3) DEFAULT 0.000,
  `commission_percentage` double(16,3) DEFAULT 0.000,
  `is_subscribed` tinyint(1) NOT NULL DEFAULT 0,
  `discount_amount_by_restaurant` double(23,3) DEFAULT 0.000,
  `is_subscription` tinyint(1) DEFAULT 0,
  `additional_charge` double(23,3) NOT NULL DEFAULT 0.000,
  PRIMARY KEY (`id`),
  KEY `order_transactions_zone_id_index` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_transactions`
--

LOCK TABLES `order_transactions` WRITE;
/*!40000 ALTER TABLE `order_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `order_amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `coupon_discount_amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `coupon_discount_title` varchar(191) DEFAULT NULL,
  `payment_status` varchar(191) NOT NULL DEFAULT 'unpaid',
  `order_status` varchar(191) NOT NULL DEFAULT 'pending',
  `total_tax_amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(30) DEFAULT NULL,
  `transaction_reference` varchar(191) DEFAULT NULL,
  `delivery_address_id` bigint(20) DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `coupon_code` varchar(191) DEFAULT NULL,
  `order_note` text DEFAULT NULL,
  `order_type` varchar(191) NOT NULL DEFAULT 'delivery',
  `checked` tinyint(1) NOT NULL DEFAULT 0,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  `schedule_at` timestamp NULL DEFAULT NULL,
  `callback` varchar(191) DEFAULT NULL,
  `otp` varchar(191) DEFAULT NULL,
  `pending` timestamp NULL DEFAULT NULL,
  `accepted` timestamp NULL DEFAULT NULL,
  `confirmed` timestamp NULL DEFAULT NULL,
  `processing` timestamp NULL DEFAULT NULL,
  `handover` timestamp NULL DEFAULT NULL,
  `picked_up` timestamp NULL DEFAULT NULL,
  `delivered` timestamp NULL DEFAULT NULL,
  `canceled` timestamp NULL DEFAULT NULL,
  `refund_requested` timestamp NULL DEFAULT NULL,
  `refunded` timestamp NULL DEFAULT NULL,
  `delivery_address` text DEFAULT NULL,
  `scheduled` tinyint(1) NOT NULL DEFAULT 0,
  `restaurant_discount_amount` decimal(24,2) NOT NULL,
  `original_delivery_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  `failed` timestamp NULL DEFAULT NULL,
  `adjusment` decimal(24,2) NOT NULL DEFAULT 0.00,
  `edited` tinyint(1) NOT NULL DEFAULT 0,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  `dm_tips` double(24,2) NOT NULL DEFAULT 0.00,
  `processing_time` varchar(10) DEFAULT NULL,
  `free_delivery_by` varchar(255) DEFAULT NULL,
  `refund_request_canceled` timestamp NULL DEFAULT NULL,
  `cancellation_reason` varchar(255) DEFAULT NULL,
  `canceled_by` varchar(50) DEFAULT NULL,
  `tax_status` varchar(50) DEFAULT NULL,
  `coupon_created_by` varchar(50) DEFAULT NULL,
  `vehicle_id` bigint(20) unsigned DEFAULT NULL,
  `discount_on_product_by` varchar(50) NOT NULL DEFAULT 'vendor',
  `distance` double(23,3) DEFAULT 0.000,
  `subscription_id` bigint(20) unsigned DEFAULT NULL,
  `cancellation_note` text DEFAULT NULL,
  `tax_percentage` double(24,3) DEFAULT NULL,
  `delivery_instruction` text DEFAULT NULL,
  `unavailable_item_note` varchar(255) DEFAULT NULL,
  `cutlery` tinyint(1) NOT NULL DEFAULT 0,
  `additional_charge` double(23,3) NOT NULL DEFAULT 0.000,
  `partially_paid_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `order_proof` varchar(255) DEFAULT NULL,
  `is_guest` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0,
  `is_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `temp_block_time` timestamp NULL DEFAULT NULL,
  `created_by` varchar(50) DEFAULT 'user',
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_requests`
--

DROP TABLE IF EXISTS `payment_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_requests` (
  `id` char(36) NOT NULL,
  `payer_id` varchar(64) DEFAULT NULL,
  `receiver_id` varchar(64) DEFAULT NULL,
  `payment_amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `gateway_callback_url` varchar(191) DEFAULT NULL,
  `success_hook` varchar(100) DEFAULT NULL,
  `failure_hook` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `currency_code` varchar(20) NOT NULL DEFAULT 'USD',
  `payment_method` varchar(50) DEFAULT NULL,
  `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)),
  `is_paid` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payer_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payer_information`)),
  `external_redirect_link` varchar(255) DEFAULT NULL,
  `receiver_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`receiver_information`)),
  `attribute_id` varchar(64) DEFAULT NULL,
  `attribute` varchar(255) DEFAULT NULL,
  `payment_platform` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_requests`
--

LOCK TABLES `payment_requests` WRITE;
/*!40000 ALTER TABLE `payment_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phone_verifications`
--

DROP TABLE IF EXISTS `phone_verifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phone_verifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0,
  `is_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `temp_block_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_verifications_phone_unique` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phone_verifications`
--

LOCK TABLES `phone_verifications` WRITE;
/*!40000 ALTER TABLE `phone_verifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_verifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `provide_d_m_earnings`
--

DROP TABLE IF EXISTS `provide_d_m_earnings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provide_d_m_earnings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_man_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(24,2) NOT NULL DEFAULT 0.00,
  `method` varchar(191) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provide_d_m_earnings`
--

LOCK TABLES `provide_d_m_earnings` WRITE;
/*!40000 ALTER TABLE `provide_d_m_earnings` DISABLE KEYS */;
/*!40000 ALTER TABLE `provide_d_m_earnings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `react_promotional_banners`
--

DROP TABLE IF EXISTS `react_promotional_banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `react_promotional_banners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `react_promotional_banners`
--

LOCK TABLES `react_promotional_banners` WRITE;
/*!40000 ALTER TABLE `react_promotional_banners` DISABLE KEYS */;
INSERT INTO `react_promotional_banners` VALUES (1,NULL,NULL,'2023-09-08-64fbeb729093c.png',1,'2023-09-08 14:50:10','2023-09-08 14:50:10'),(2,NULL,NULL,'2023-09-08-64fbf13a51f31.png',1,'2023-09-08 15:14:50','2023-09-08 15:14:50'),(3,NULL,NULL,'2023-09-08-64fbf1458ea9b.png',1,'2023-09-08 15:15:01','2023-09-08 15:15:01');
/*!40000 ALTER TABLE `react_promotional_banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `react_services`
--

DROP TABLE IF EXISTS `react_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `react_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `sub_title` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `react_services`
--

LOCK TABLES `react_services` WRITE;
/*!40000 ALTER TABLE `react_services` DISABLE KEYS */;
INSERT INTO `react_services` VALUES (1,'Order Online','Order in for yourself or for the group, with no restrictions on order value','2023-09-08-64fbf0925f6da.png',1,'2023-09-08 15:12:02','2023-09-08 15:12:02'),(2,'Fast Delivery','Order in for yourself or for the group, with no restrictions on order value','2023-09-08-64fbf0d1dc201.png',1,'2023-09-08 15:13:05','2023-09-08 15:13:05'),(3,'Enjoy Fresh Food','Order in for yourself or for the group, with no restrictions on order value','2023-09-08-64fbf0f56a9bd.png',1,'2023-09-08 15:13:41','2023-09-08 15:13:41');
/*!40000 ALTER TABLE `react_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `refund_reasons`
--

DROP TABLE IF EXISTS `refund_reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `refund_reasons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reason` varchar(255) NOT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `refund_reasons`
--

LOCK TABLES `refund_reasons` WRITE;
/*!40000 ALTER TABLE `refund_reasons` DISABLE KEYS */;
/*!40000 ALTER TABLE `refund_reasons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `refunds`
--

DROP TABLE IF EXISTS `refunds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `refunds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `order_status` varchar(50) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `customer_reason` varchar(255) DEFAULT NULL,
  `customer_note` text DEFAULT NULL,
  `admin_note` text DEFAULT NULL,
  `refund_amount` decimal(24,3) NOT NULL DEFAULT 0.000,
  `refund_status` varchar(50) NOT NULL,
  `refund_method` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `refunds`
--

LOCK TABLES `refunds` WRITE;
/*!40000 ALTER TABLE `refunds` DISABLE KEYS */;
/*!40000 ALTER TABLE `refunds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_configs`
--

DROP TABLE IF EXISTS `restaurant_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_configs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `instant_order` tinyint(1) NOT NULL DEFAULT 0,
  `customer_date_order_sratus` tinyint(1) NOT NULL DEFAULT 0,
  `customer_order_date` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_configs`
--

LOCK TABLES `restaurant_configs` WRITE;
/*!40000 ALTER TABLE `restaurant_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_schedule`
--

DROP TABLE IF EXISTS `restaurant_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_schedule` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `day` int(11) NOT NULL,
  `opening_time` time DEFAULT NULL,
  `closing_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_schedule`
--

LOCK TABLES `restaurant_schedule` WRITE;
/*!40000 ALTER TABLE `restaurant_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_subscriptions`
--

DROP TABLE IF EXISTS `restaurant_subscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `expiry_date` date NOT NULL,
  `max_order` varchar(255) NOT NULL,
  `max_product` varchar(255) NOT NULL,
  `pos` tinyint(1) NOT NULL DEFAULT 0,
  `mobile_app` tinyint(1) NOT NULL DEFAULT 0,
  `chat` tinyint(1) NOT NULL DEFAULT 0,
  `review` tinyint(1) NOT NULL DEFAULT 0,
  `self_delivery` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `total_package_renewed` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_subscriptions`
--

LOCK TABLES `restaurant_subscriptions` WRITE;
/*!40000 ALTER TABLE `restaurant_subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_tag`
--

DROP TABLE IF EXISTS `restaurant_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_tag`
--

LOCK TABLES `restaurant_tag` WRITE;
/*!40000 ALTER TABLE `restaurant_tag` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_wallets`
--

DROP TABLE IF EXISTS `restaurant_wallets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_wallets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` bigint(20) unsigned NOT NULL,
  `total_earning` decimal(24,2) NOT NULL DEFAULT 0.00,
  `total_withdrawn` decimal(24,2) NOT NULL DEFAULT 0.00,
  `pending_withdraw` decimal(24,2) NOT NULL DEFAULT 0.00,
  `collected_cash` decimal(24,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_wallets`
--

LOCK TABLES `restaurant_wallets` WRITE;
/*!40000 ALTER TABLE `restaurant_wallets` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_wallets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurant_zone`
--

DROP TABLE IF EXISTS `restaurant_zone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurant_zone` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `zone_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurant_zone`
--

LOCK TABLES `restaurant_zone` WRITE;
/*!40000 ALTER TABLE `restaurant_zone` DISABLE KEYS */;
/*!40000 ALTER TABLE `restaurant_zone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restaurants`
--

DROP TABLE IF EXISTS `restaurants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restaurants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `footer_text` text DEFAULT NULL,
  `minimum_order` decimal(24,2) NOT NULL DEFAULT 0.00,
  `comission` decimal(24,2) DEFAULT NULL,
  `schedule_order` tinyint(1) NOT NULL DEFAULT 0,
  `opening_time` time DEFAULT '10:00:00',
  `closeing_time` time DEFAULT '23:00:00',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `vendor_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `free_delivery` tinyint(1) NOT NULL DEFAULT 0,
  `rating` varchar(191) DEFAULT NULL,
  `cover_photo` varchar(191) DEFAULT NULL,
  `delivery` tinyint(1) NOT NULL DEFAULT 1,
  `take_away` tinyint(1) NOT NULL DEFAULT 1,
  `food_section` tinyint(1) NOT NULL DEFAULT 1,
  `tax` decimal(24,2) NOT NULL DEFAULT 0.00,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  `reviews_section` tinyint(1) NOT NULL DEFAULT 1,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `off_day` varchar(191) NOT NULL DEFAULT ' ',
  `gst` varchar(191) DEFAULT NULL,
  `self_delivery_system` tinyint(1) NOT NULL DEFAULT 0,
  `pos_system` tinyint(1) NOT NULL DEFAULT 0,
  `minimum_shipping_charge` decimal(24,2) NOT NULL DEFAULT 0.00,
  `delivery_time` varchar(191) DEFAULT '30-40',
  `veg` tinyint(1) NOT NULL DEFAULT 1,
  `non_veg` tinyint(1) NOT NULL DEFAULT 1,
  `order_count` int(10) unsigned NOT NULL DEFAULT 0,
  `total_order` int(10) unsigned NOT NULL DEFAULT 0,
  `per_km_shipping_charge` double(16,3) unsigned DEFAULT NULL,
  `restaurant_model` varchar(50) DEFAULT 'commission',
  `maximum_shipping_charge` double(23,3) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `order_subscription_active` tinyint(1) DEFAULT 0,
  `cutlery` tinyint(1) NOT NULL DEFAULT 0,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_image` varchar(100) DEFAULT NULL,
  `announcement` tinyint(1) NOT NULL DEFAULT 0,
  `announcement_message` varchar(255) DEFAULT NULL,
  `qr_code` text DEFAULT NULL,
  `free_delivery_distance` varchar(255) DEFAULT NULL,
  `additional_data` text DEFAULT NULL,
  `additional_documents` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `restaurants_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restaurants`
--

LOCK TABLES `restaurants` WRITE;
/*!40000 ALTER TABLE `restaurants` DISABLE KEYS */;
INSERT INTO `restaurants` VALUES (1,'Demo Restaurant','01700000000','Demo@Restaurant.com','2023-09-08-64fc04066bce7.png','24.16883944018075','90.30561873693928','House 1005, 1007, 1216 Road no: 09, Dhaka 1216',NULL,0.00,NULL,0,'10:00:00','23:00:00',1,1,'2023-09-08 16:35:02','2023-09-08 16:45:54',0,NULL,'2023-09-08-64fc0406702e9.png',1,1,1,10.00,1,1,1,' ',NULL,0,0,0.00,'15-20-min',1,1,0,0,NULL,'commission',NULL,'demo-restaurant',0,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'[]');
/*!40000 ALTER TABLE `restaurants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reviews`
--

DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `food_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `comment` mediumtext DEFAULT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 0,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `item_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reviews`
--

LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shifts`
--

DROP TABLE IF EXISTS `shifts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shifts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shifts`
--

LOCK TABLES `shifts` WRITE;
/*!40000 ALTER TABLE `shifts` DISABLE KEYS */;
/*!40000 ALTER TABLE `shifts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_media`
--

DROP TABLE IF EXISTS `social_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `social_media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_media`
--

LOCK TABLES `social_media` WRITE;
/*!40000 ALTER TABLE `social_media` DISABLE KEYS */;
/*!40000 ALTER TABLE `social_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `soft_credentials`
--

DROP TABLE IF EXISTS `soft_credentials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `soft_credentials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `soft_credentials`
--

LOCK TABLES `soft_credentials` WRITE;
/*!40000 ALTER TABLE `soft_credentials` DISABLE KEYS */;
/*!40000 ALTER TABLE `soft_credentials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_logs`
--

DROP TABLE IF EXISTS `subscription_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `order_status` varchar(255) DEFAULT NULL,
  `schedule_at` timestamp NULL DEFAULT NULL,
  `accepted` timestamp NULL DEFAULT NULL,
  `confirmed` timestamp NULL DEFAULT NULL,
  `processing` timestamp NULL DEFAULT NULL,
  `handover` timestamp NULL DEFAULT NULL,
  `picked_up` timestamp NULL DEFAULT NULL,
  `delivered` timestamp NULL DEFAULT NULL,
  `canceled` timestamp NULL DEFAULT NULL,
  `failed` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_logs`
--

LOCK TABLES `subscription_logs` WRITE;
/*!40000 ALTER TABLE `subscription_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_packages`
--

DROP TABLE IF EXISTS `subscription_packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `package_name` varchar(191) NOT NULL,
  `price` double(24,3) NOT NULL,
  `validity` int(11) NOT NULL,
  `max_order` varchar(255) NOT NULL DEFAULT 'unlimited',
  `max_product` varchar(255) NOT NULL DEFAULT 'unlimited',
  `pos` tinyint(1) NOT NULL DEFAULT 0,
  `mobile_app` tinyint(1) NOT NULL DEFAULT 0,
  `chat` tinyint(1) NOT NULL DEFAULT 0,
  `review` tinyint(1) NOT NULL DEFAULT 0,
  `self_delivery` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `default` tinyint(1) NOT NULL DEFAULT 0,
  `colour` varchar(50) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_packages`
--

LOCK TABLES `subscription_packages` WRITE;
/*!40000 ALTER TABLE `subscription_packages` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_pauses`
--

DROP TABLE IF EXISTS `subscription_pauses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_pauses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `from` date DEFAULT NULL,
  `to` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_pauses`
--

LOCK TABLES `subscription_pauses` WRITE;
/*!40000 ALTER TABLE `subscription_pauses` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_pauses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_schedules`
--

DROP TABLE IF EXISTS `subscription_schedules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_schedules` (
  `subscription_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_schedules`
--

LOCK TABLES `subscription_schedules` WRITE;
/*!40000 ALTER TABLE `subscription_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_schedules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_transactions`
--

DROP TABLE IF EXISTS `subscription_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_transactions` (
  `id` char(36) NOT NULL,
  `package_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `price` double(24,3) NOT NULL DEFAULT 0.000,
  `validity` int(11) NOT NULL DEFAULT 0,
  `payment_method` varchar(191) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `paid_amount` double(24,2) NOT NULL,
  `discount` int(11) NOT NULL DEFAULT 0,
  `package_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`package_details`)),
  `created_by` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_status` varchar(50) NOT NULL DEFAULT 'success',
  `transaction_status` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_transactions`
--

LOCK TABLES `subscription_transactions` WRITE;
/*!40000 ALTER TABLE `subscription_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscriptions`
--

DROP TABLE IF EXISTS `subscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(255) DEFAULT NULL,
  `start_at` date DEFAULT NULL,
  `end_at` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `billing_amount` decimal(23,3) NOT NULL DEFAULT 0.000,
  `paid_amount` decimal(23,3) NOT NULL DEFAULT 0.000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscriptions`
--

LOCK TABLES `subscriptions` WRITE;
/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags`
--

LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` VALUES (1,'Food','2023-09-08 17:05:12','2023-09-08 17:05:12');
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `time_logs`
--

DROP TABLE IF EXISTS `time_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `time_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `online` time DEFAULT NULL,
  `offline` time DEFAULT NULL,
  `working_hour` decimal(23,3) NOT NULL DEFAULT 0.000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shift_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `time_logs`
--

LOCK TABLES `time_logs` WRITE;
/*!40000 ALTER TABLE `time_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `track_deliverymen`
--

DROP TABLE IF EXISTS `track_deliverymen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `track_deliverymen` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `longitude` varchar(20) DEFAULT NULL,
  `latitude` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `track_deliverymen`
--

LOCK TABLES `track_deliverymen` WRITE;
/*!40000 ALTER TABLE `track_deliverymen` DISABLE KEYS */;
/*!40000 ALTER TABLE `track_deliverymen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `translations`
--

DROP TABLE IF EXISTS `translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `translationable_type` varchar(255) NOT NULL,
  `translationable_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `key` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `translations_translationable_id_index` (`translationable_id`),
  KEY `translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `translations`
--

LOCK TABLES `translations` WRITE;
/*!40000 ALTER TABLE `translations` DISABLE KEYS */;
INSERT INTO `translations` VALUES (1,'App\\Models\\DataSetting',69,'en','react_header_title','COOKING',NULL,NULL),(2,'App\\Models\\DataSetting',70,'en','react_header_sub_title','Find Restaurants Near You',NULL,NULL),(3,'App\\Models\\DataSetting',72,'en','react_restaurant_section_title','Open your own restaurant',NULL,NULL),(4,'App\\Models\\DataSetting',73,'en','react_restaurant_section_sub_title','Open your own restaurant',NULL,NULL),(5,'App\\Models\\DataSetting',74,'en','react_restaurant_section_button_name','Register',NULL,NULL),(6,'App\\Models\\DataSetting',78,'en','react_delivery_section_title','Become a Delivery Man',NULL,NULL),(7,'App\\Models\\DataSetting',79,'en','react_delivery_section_sub_title','Become a Delivery Man',NULL,NULL),(8,'App\\Models\\DataSetting',80,'en','react_delivery_section_button_name','Register',NULL,NULL),(9,'App\\Models\\DataSetting',85,'en','react_download_apps_title','Download app to enjoy more!',NULL,NULL),(10,'App\\Models\\DataSetting',86,'en','react_download_apps_sub_title','All the best restaurants are one click away',NULL,NULL),(11,'App\\Models\\DataSetting',87,'en','react_download_apps_tag','Download our app from google play store & app store.',NULL,NULL),(12,'App\\Models\\ReactPromotionalBanner',1,'en','react_promotional_banner_title',NULL,NULL,NULL),(13,'App\\Models\\ReactPromotionalBanner',1,'en','react_promotional_banner_description',NULL,NULL,NULL),(14,'App\\Models\\ReactService',1,'en','react_service_title','Order Online',NULL,NULL),(15,'App\\Models\\ReactService',1,'en','react_service_sub_title','Order in for yourself or for the group, with no restrictions on order value',NULL,NULL),(16,'App\\Models\\ReactService',2,'en','react_service_title','Fast Delivery',NULL,NULL),(17,'App\\Models\\ReactService',2,'en','react_service_sub_title','Order in for yourself or for the group, with no restrictions on order value',NULL,NULL),(18,'App\\Models\\ReactService',3,'en','react_service_title','Enjoy Fresh Food',NULL,NULL),(19,'App\\Models\\ReactService',3,'en','react_service_sub_title','Order in for yourself or for the group, with no restrictions on order value',NULL,NULL),(20,'App\\Models\\ReactPromotionalBanner',2,'en','react_promotional_banner_title',NULL,NULL,NULL),(21,'App\\Models\\ReactPromotionalBanner',2,'en','react_promotional_banner_description',NULL,NULL,NULL),(22,'App\\Models\\ReactPromotionalBanner',3,'en','react_promotional_banner_title',NULL,NULL,NULL),(23,'App\\Models\\ReactPromotionalBanner',3,'en','react_promotional_banner_description',NULL,NULL,NULL),(24,'App\\Models\\DataSetting',14,'en','about_us_title','restaurant',NULL,NULL),(25,'App\\Models\\DataSetting',15,'en','about_us_sub_title','is Best Delivery Service Near You',NULL,NULL),(26,'App\\Models\\DataSetting',16,'en','about_us_text','We make food delivery more interesting.\r\nFind the greatest deals from the restaurants near you.\r\nTesty & healthy dishes. Bring a restaurant into your home.',NULL,NULL),(27,'App\\Models\\DataSetting',17,'en','about_us_app_button_name','Download Now',NULL,NULL),(28,'App\\Models\\AdminFeature',1,'en','feature_name','24h Support',NULL,NULL),(29,'App\\Models\\AdminFeature',1,'en','feature_description','24/7 customer support service to support you.',NULL,NULL),(30,'App\\Models\\AdminFeature',2,'en','feature_name','Easy Payment',NULL,NULL),(31,'App\\Models\\AdminFeature',2,'en','feature_description','Smart and easy payment system to maintain your business.',NULL,NULL),(32,'App\\Models\\AdminFeature',3,'en','feature_name','Fast Delivery',NULL,NULL),(33,'App\\Models\\AdminFeature',3,'en','feature_description','Fastest delivery system to reach your customer.',NULL,NULL),(34,'App\\Models\\AdminFeature',4,'en','feature_name','Resonable Price',NULL,NULL),(35,'App\\Models\\AdminFeature',4,'en','feature_description','Start your business in cheap cost. In your budget',NULL,NULL),(36,'App\\Models\\DataSetting',47,'en','earn_money_reg_title','Earn Money From StackFood',NULL,NULL),(37,'App\\Models\\DataSetting',48,'en','earn_money_restaurant_req_button_name','Be a Seller',NULL,NULL),(38,'App\\Models\\DataSetting',51,'en','earn_money_delivety_man_req_button_name','Be Deliveryman',NULL,NULL),(39,'App\\Models\\DataSetting',57,'en','why_choose_us_title_1','Find your daily meal',NULL,NULL),(40,'App\\Models\\DataSetting',59,'en','why_choose_us_title_2','Easy to food ordering system',NULL,NULL),(41,'App\\Models\\DataSetting',61,'en','why_choose_us_title_3','Fastest food delivery service',NULL,NULL),(42,'App\\Models\\DataSetting',63,'en','why_choose_us_title_4','Track your food order',NULL,NULL),(43,'App\\Models\\Zone',1,'en','name','Demo Zone',NULL,NULL),(44,'App\\Models\\Cuisine',1,'en','cuisine_name','Demo Cuisine',NULL,NULL),(45,'App\\Models\\Category',1,'en','name','Demo Category',NULL,NULL),(46,'App\\Models\\Category',2,'en','name','Demo Sub Category',NULL,NULL),(47,'App\\Models\\Restaurant',1,'en','name','Demo Restaurant',NULL,NULL),(48,'App\\Models\\Restaurant',1,'en','address','House 1005, 1007, 1216 Road no: 09, Dhaka 1216',NULL,NULL),(49,'App\\Models\\AddOn',1,'en','name','Water',NULL,NULL),(50,'App\\Models\\Food',1,'en','name','Demo Food',NULL,NULL),(51,'App\\Models\\Food',1,'en','description','Lorem ipsum dolor sit amet, consectetur adipisicing elit. A aliquam amet animi blanditiis consequatur debitis dicta distinctio, enim error eum iste libero modi nam natus perferendis possimus quasi sint sit tempora voluptatem. Est, exercitationem id ipsa ipsum laboriosam perferendis temporibus!',NULL,NULL),(52,'App\\Models\\Vehicle',1,'en','type','Cycle',NULL,NULL),(53,'App\\Models\\DataSetting',96,'en','promotional_banner_title','Demo Banner',NULL,NULL),(54,'App\\Models\\DataSetting',5,'en','header_title','Why stay Hungry !',NULL,NULL),(55,'App\\Models\\DataSetting',6,'en','header_sub_title','when you can order always form',NULL,NULL),(56,'App\\Models\\DataSetting',7,'en','header_tag_line','Start Your Business or Download the App',NULL,NULL),(57,'App\\Models\\DataSetting',8,'en','header_app_button_name','Order Now',NULL,NULL),(58,'App\\Models\\DataSetting',5,'lo','header_title','LA',NULL,NULL),(59,'App\\Models\\DataSetting',6,'lo','header_sub_title','Lao',NULL,NULL),(60,'App\\Models\\DataSetting',7,'lo','header_tag_line','LA',NULL,NULL),(61,'App\\Models\\DataSetting',14,'lo','about_us_title','ຮ້ານອາຫານ',NULL,NULL),(62,'App\\Models\\DataSetting',15,'lo','about_us_sub_title','ຮ້ານອາຫານ',NULL,NULL),(63,'App\\Models\\DataSetting',16,'lo','about_us_text','ຮ້ານອາຫານລາວ',NULL,NULL),(64,'App\\Models\\Zone',2,'en','name','Laos',NULL,NULL);
/*!40000 ALTER TABLE `translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_infos`
--

DROP TABLE IF EXISTS `user_infos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(255) DEFAULT NULL,
  `l_name` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `admin_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `vendor_id` bigint(20) unsigned DEFAULT NULL,
  `deliveryman_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_infos`
--

LOCK TABLES `user_infos` WRITE;
/*!40000 ALTER TABLE `user_infos` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_infos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_notifications`
--

DROP TABLE IF EXISTS `user_notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `data` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `vendor_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_notifications`
--

LOCK TABLES `user_notifications` WRITE;
/*!40000 ALTER TABLE `user_notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_notifications` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) DEFAULT NULL,
  `l_name` varchar(100) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `is_phone_verified` tinyint(1) NOT NULL DEFAULT 0,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `interest` varchar(191) DEFAULT NULL,
  `cm_firebase_token` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `order_count` int(11) NOT NULL DEFAULT 0,
  `login_medium` varchar(191) DEFAULT NULL,
  `social_id` varchar(191) DEFAULT NULL,
  `zone_id` bigint(20) unsigned DEFAULT NULL,
  `wallet_balance` decimal(24,3) NOT NULL DEFAULT 0.000,
  `loyalty_point` decimal(24,3) NOT NULL DEFAULT 0.000,
  `ref_code` varchar(191) DEFAULT NULL,
  `ref_by` bigint(20) unsigned DEFAULT NULL,
  `temp_token` varchar(255) DEFAULT NULL,
  `current_language_key` varchar(255) DEFAULT 'en',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_phone_unique` (`phone`),
  UNIQUE KEY `users_ref_code_unique` (`ref_code`),
  KEY `users_zone_id_index` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicles`
--

DROP TABLE IF EXISTS `vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `starting_coverage_area` double(16,2) NOT NULL,
  `maximum_coverage_area` double(16,2) NOT NULL,
  `extra_charges` double(16,2) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicles`
--

LOCK TABLES `vehicles` WRITE;
/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
INSERT INTO `vehicles` VALUES (1,'Cycle',0.00,1000.00,0.00,1,'2023-09-08 17:07:33','2023-09-08 17:07:33');
/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_employees`
--

DROP TABLE IF EXISTS `vendor_employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendor_employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) DEFAULT NULL,
  `l_name` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `employee_role_id` bigint(20) unsigned NOT NULL,
  `vendor_id` bigint(20) unsigned NOT NULL,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `password` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `remember_token` varchar(100) DEFAULT NULL,
  `firebase_token` varchar(191) DEFAULT NULL,
  `auth_token` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendor_employees_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_employees`
--

LOCK TABLES `vendor_employees` WRITE;
/*!40000 ALTER TABLE `vendor_employees` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendor_employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) NOT NULL,
  `l_name` varchar(100) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bank_name` varchar(191) DEFAULT NULL,
  `branch` varchar(191) DEFAULT NULL,
  `holder_name` varchar(191) DEFAULT NULL,
  `account_no` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `firebase_token` varchar(191) DEFAULT NULL,
  `auth_token` varchar(191) DEFAULT NULL,
  `fcm_token_web` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendors_phone_unique` (`phone`),
  UNIQUE KEY `vendors_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
INSERT INTO `vendors` VALUES (1,'Demo','Restaurant','01700000000','Demo@Restaurant.com',NULL,'$2a$12$NQBXTu9.U.jS0McEJPVEZuVcC2eAorHB8vQXCPlbcXuJM/mb9RpfO',NULL,'2023-09-08 16:35:02','2023-09-08 16:35:02',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visitor_logs`
--

DROP TABLE IF EXISTS `visitor_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitor_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `visitor_log_type` varchar(255) NOT NULL,
  `visitor_log_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `visit_count` int(11) NOT NULL DEFAULT 0,
  `order_count` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitor_logs`
--

LOCK TABLES `visitor_logs` WRITE;
/*!40000 ALTER TABLE `visitor_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `visitor_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet_bonuses`
--

DROP TABLE IF EXISTS `wallet_bonuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet_bonuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `bonus_type` varchar(255) NOT NULL,
  `bonus_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `minimum_add_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `maximum_bonus_amount` double(23,3) NOT NULL DEFAULT 0.000,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet_bonuses`
--

LOCK TABLES `wallet_bonuses` WRITE;
/*!40000 ALTER TABLE `wallet_bonuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `wallet_bonuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet_payments`
--

DROP TABLE IF EXISTS `wallet_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `transaction_ref` varchar(255) DEFAULT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `payment_status` varchar(50) NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet_payments`
--

LOCK TABLES `wallet_payments` WRITE;
/*!40000 ALTER TABLE `wallet_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `wallet_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet_transactions`
--

DROP TABLE IF EXISTS `wallet_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_id` char(36) NOT NULL,
  `credit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `debit` decimal(24,3) NOT NULL DEFAULT 0.000,
  `admin_bonus` decimal(24,3) NOT NULL DEFAULT 0.000,
  `balance` decimal(24,3) NOT NULL DEFAULT 0.000,
  `transaction_type` varchar(191) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet_transactions`
--

LOCK TABLES `wallet_transactions` WRITE;
/*!40000 ALTER TABLE `wallet_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `wallet_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `websockets_statistics_entries`
--

DROP TABLE IF EXISTS `websockets_statistics_entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `websockets_statistics_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` varchar(255) NOT NULL,
  `peak_connection_count` int(11) NOT NULL,
  `websocket_message_count` int(11) NOT NULL,
  `api_message_count` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `websockets_statistics_entries`
--

LOCK TABLES `websockets_statistics_entries` WRITE;
/*!40000 ALTER TABLE `websockets_statistics_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `websockets_statistics_entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wishlists`
--

DROP TABLE IF EXISTS `wishlists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wishlists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `food_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wishlists`
--

LOCK TABLES `wishlists` WRITE;
/*!40000 ALTER TABLE `wishlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `wishlists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdraw_requests`
--

DROP TABLE IF EXISTS `withdraw_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdraw_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` bigint(20) unsigned DEFAULT NULL,
  `admin_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_note` varchar(191) DEFAULT NULL,
  `amount` decimal(23,3) NOT NULL DEFAULT 0.000,
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_man_id` bigint(20) unsigned DEFAULT NULL,
  `withdrawal_method_id` bigint(20) unsigned DEFAULT NULL,
  `withdrawal_method_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`withdrawal_method_fields`)),
  `type` varchar(20) NOT NULL DEFAULT 'manual',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdraw_requests`
--

LOCK TABLES `withdraw_requests` WRITE;
/*!40000 ALTER TABLE `withdraw_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `withdraw_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `withdrawal_methods`
--

DROP TABLE IF EXISTS `withdrawal_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `withdrawal_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_name` varchar(255) NOT NULL,
  `method_fields` text NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `withdrawal_methods`
--

LOCK TABLES `withdrawal_methods` WRITE;
/*!40000 ALTER TABLE `withdrawal_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `withdrawal_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zones`
--

DROP TABLE IF EXISTS `zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zones` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `coordinates` polygon NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restaurant_wise_topic` varchar(191) DEFAULT NULL,
  `customer_wise_topic` varchar(191) DEFAULT NULL,
  `deliveryman_wise_topic` varchar(191) DEFAULT NULL,
  `minimum_shipping_charge` double(16,3) unsigned DEFAULT NULL,
  `per_km_shipping_charge` double(16,3) unsigned DEFAULT NULL,
  `maximum_shipping_charge` double(23,3) DEFAULT NULL,
  `max_cod_order_amount` double(23,3) DEFAULT NULL,
  `increased_delivery_fee` double(8,2) NOT NULL DEFAULT 0.00,
  `increased_delivery_fee_status` tinyint(1) NOT NULL DEFAULT 0,
  `increase_delivery_charge_message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `zones_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zones`
--

LOCK TABLES `zones` WRITE;
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
INSERT INTO `zones` VALUES (1,'Demo Zone','\0\0\0\0\0\0\0\0\0\0	\0\0\0����	V@���R:@���ʂV@��k��f:@�����V@:��_9@����!W@1�~܅9@���b5W@H��(c\\5@���BW@���uz4@����@V@O��C��5@���b�U@s؅>[�8@����	V@���R:@',1,'2023-09-08 16:23:28','2023-09-08 16:24:00','zone_1_restaurant','zone_1_customer','zone_1_delivery_man',10.000,5.000,NULL,NULL,0.00,0,NULL),(2,'Laos','\0\0\0\0\0\0\0\0\0\0\0\0\0���=��Y@��1@�;�x4�Y@p�ڱ�1@��Y@)� W�1@\0�PI�Y@gG�>��1@��@W�Y@�,�%��1@z���Y@\'���1@��`8�Y@�J�x;�1@���=��Y@��1@',1,'2024-09-28 15:08:18','2024-09-28 15:09:38','zone_2_restaurant','zone_2_customer','zone_2_delivery_man',1000.000,20.000,100000.000,100000.000,0.00,0,NULL);
/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 16:47:14

📁 Sid Gifari File Manager