Da

✏️ Editing: appalorg_resf.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: appalorg_resf
-- ------------------------------------------------------
-- 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_resf`
--

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

USE `appalorg_resf`;

--
-- 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','+85622220022','admin@admin.com',NULL,'$2y$10$t257FNunKzE3/4jhxSJILO60ORfflYIhBxzzwLuaspRER/91mHrTi','zkdaXoJnCowaNOrcBoFjTCsfjlUaT1SXfwBuJBG5o44Wws46FaSfdgykYq78','2024-09-30 02:02:05','2024-10-04 00:38:18',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 AUTO_INCREMENT=4 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 */;
INSERT INTO `banners` VALUES (1,'propertylaos','item_wise','2025-09-17-68ca2af7064ec.png',1,'1','2025-09-17 03:12:08','2025-09-17 03:28:55',2),(2,'AIR','restaurant_wise','2025-09-17-68ca27dc5deae.png',1,'1','2025-09-17 03:15:40','2025-09-17 03:15:40',2),(3,'Iphone','item_wise','2025-09-17-68ca2a3a8cfa2.png',1,'1','2025-09-17 03:17:05','2025-09-17 03:25:46',2);
/*!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=123 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','deepsoft',NULL,NULL),(17,'currency','USD',NULL,NULL),(18,'logo','2023-08-26-64e9ce4d87716.png',NULL,NULL),(19,'phone','+856',NULL,NULL),(20,'email_address','admin@admin.com',NULL,NULL),(21,'address','Crowne Plaza Vientiane, an IHG Hotel',NULL,NULL),(22,'footer_text','Footer Text',NULL,NULL),(23,'customer_verification',NULL,NULL,NULL),(24,'map_api_key','AIzaSyDNeVIUnwYVe4KHyJQ7UWCtKONcuxLqDlo',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','Asia/Bangkok',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','LA',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\",\"zh\",\"lo\"]',NULL,'2024-09-30 02:03:19'),(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\":true},{\"id\":2,\"direction\":\"ltr\",\"code\":\"zh\",\"status\":1,\"default\":false},{\"id\":3,\"direction\":\"ltr\",\"code\":\"lo\",\"status\":1,\"default\":false}]','2023-07-10 00:56:39','2024-10-01 08:56:38'),(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'),(119,'guest_checkout_status','0',NULL,NULL),(120,'free_delivery_distance',NULL,NULL,NULL),(121,'map_api_key_server','AIzaSyDNeVIUnwYVe4KHyJQ7UWCtKONcuxLqDlo',NULL,NULL),(122,'backgroundChange','{\"primary_1_hex\":\"#5a5edd\",\"primary_1_rgb\":\"90, 94, 221\",\"primary_2_hex\":\"#3dbd9d\",\"primary_2_rgb\":\"61, 189, 157\"}',NULL,NULL);
/*!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 AUTO_INCREMENT=8 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=10 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,'Fine Dining','2025-09-17-68cad4c7888c6.png',0,0,1,'2023-09-08 16:29:05','2025-09-17 15:33:27',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'),(3,'Bistro','2024-10-01-66fbc0b703c18.png',0,0,1,'2024-10-01 09:28:23','2024-10-01 09:28:23',0,'bistro'),(4,'Casual Dining condo','2025-09-17-68cad308e6257.png',0,0,1,'2024-10-01 09:29:55','2025-09-17 15:26:16',1,'casual-dining-restaurants'),(5,'样板房','def.png',4,1,1,'2024-10-01 09:32:05','2025-09-16 07:41:12',1,'abbys-legendary-pizza'),(6,'Land','2025-09-17-68cad2d85950e.png',0,0,1,'2025-09-16 05:22:32','2025-09-17 15:25:12',2,'land'),(7,'Apartment','2025-09-17-68cad2c7921a0.png',0,0,1,'2025-09-16 05:22:53','2025-09-17 15:24:55',2,'apartment'),(8,'Rent land & House','2025-09-17-68cad2857b34b.png',0,0,1,'2025-09-16 05:23:12','2025-09-17 15:24:28',1,'rent'),(9,'House','2025-09-17-68cad25e9a95e.png',0,0,1,'2025-09-16 05:23:19','2025-09-17 15:23:10',1,'house');
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `conversations` VALUES (1,1,'2025-09-18 01:23:14','2025-09-18 01:23:19','customer',0,'admin',2,'2025-09-18 01:23:19',2);
/*!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=6 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),(3,2,1),(4,2,2),(5,1,2);
/*!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=4 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,'Land & House','2025-09-17-68cad50e8d8f0.png',1,'demo-cuisine','2023-09-08 16:25:54','2025-09-17 15:38:24'),(2,'Garden','2025-09-17-68cad559041c5.png',1,'garden','2025-09-17 15:35:53','2025-09-17 15:35:53'),(3,'Apartment','2025-09-17-68cad5d8abdc3.png',1,'apartment','2025-09-17 15:38:00','2025-09-17 15:38:00');
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `customer_addresses` VALUES (1,'home','+8562022228888','XJ83+P4F, Vientiane, Laos','17.966878042858152','102.60279893875122',2,'Jk Keomanivong','2025-09-20 09:36:11','2025-09-20 09:36:11',2,NULL,NULL,NULL);
/*!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','LALA','admin_landing_page','2023-06-20 17:59:39','2025-09-17 11:08:28'),(6,'header_sub_title','Share Property to next','admin_landing_page','2023-06-20 17:59:39','2025-09-28 09:00:44'),(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','Share Now','admin_landing_page','2023-06-20 17:59:39','2025-09-17 11:08:28'),(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-10-01 09:36:20'),(11,'header_image_content','{\"header_content_image\":\"2025-09-17-68ca97415edb3.png\",\"header_bg_image\":null}','admin_landing_page','2023-06-20 18:01:47','2025-09-17 11:10:57'),(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','2023-09-08-64fbf699ca3ba.png','admin_landing_page','2023-06-20 18:10:05','2023-09-08 15:37:45'),(14,'about_us_title','COOK','admin_landing_page','2023-06-20 18:10:05','2024-10-01 09:36:37'),(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','COOK','react_landing_page','2023-06-21 09:41:59','2024-10-01 09:39:37'),(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-10-01-66fbc359d88b8.png','react_landing_page','2023-06-21 09:41:59','2024-10-01 09:39:38'),(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','2023-09-08-64fbe7647ba5b.png','react_landing_page','2023-06-21 09:48:57','2023-09-08 14:32:52'),(77,'react_restaurant_section_link_data','https://stackfood-admin.6amtech.com/restaurant/apply','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(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','2023-09-08-64fbe76489736.png','react_landing_page','2023-06-21 09:48:57','2023-09-08 14:32:52'),(83,'react_delivery_section_link_data','https://stackfood-admin.6amtech.com/deliveryman/apply','react_landing_page','2023-06-21 09:48:57','2023-06-21 09:48:57'),(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','2025-09-17-68ca27790e970.png','promotional_banner','2023-09-08 17:11:53','2025-09-17 03:14:01'),(96,'promotional_banner_title','VGA','promotional_banner','2023-09-08 17:11:53','2025-09-17 03:14:22');
/*!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,
  `body_2` text 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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL),(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',NULL);
/*!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,
  `is_halal` tinyint(1) NOT NULL DEFAULT 0,
  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,'double storey home','ESTFUL SPACES\r\n\r\nSavour the solitude on the first floor with three bedrooms equipped with built-in robes and a master suite that sinks into its surrounds. Journey through the extended walk-in robe (fully prepared for your next shopping trip) in this grand room to reach an ensuite that will make the day you’ve had melt away.\r\n\r\nEXTEND THE PARTY SEAMLESSLY\r\n\r\nSlide open the back doors to draw together the undercover outdoor living and open plan kitchen, living and dining. Before long, the street party will always end at your house.','2025-09-17-68ca24825598b.png',6,'[{\"id\":\"6\",\"position\":1}]','[{\"name\":\"Vatiation-1\",\"type\":\"single\",\"min\":0,\"max\":0,\"required\":\"on\",\"values\":[{\"label\":\"Meals\",\"optionPrice\":\"1\"},{\"label\":\"Bed\",\"optionPrice\":\"4\"},{\"label\":\"Home Office\",\"optionPrice\":\"1\"},{\"label\":\"Double Garage\",\"optionPrice\":\"2\"},{\"label\":\"Balcony\",\"optionPrice\":\"1\"}]},{\"name\":\"Vatiation-2\",\"type\":\"multi\",\"min\":\"1\",\"max\":\"3\",\"required\":\"off\",\"values\":[{\"label\":\"Bed 2\",\"optionPrice\":\"1\"},{\"label\":\"Bed 3\",\"optionPrice\":\"3\"},{\"label\":\"Demo Option-3\",\"optionPrice\":\"2\"}]}]','[\"1\"]','[]','[]',10000.00,0.00,'percent',0.00,'percent','00:00:00','23:59:00',0,1,1,'2023-09-08 17:05:12','2025-09-17 03:01:22',0,0.00000000000000,0,NULL,0,'demo-food',5,0);
/*!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=3 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 (2,1,4);
/*!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 AUTO_INCREMENT=12 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 */;
INSERT INTO `guests` VALUES (1,'103.43.76.16',NULL,'2024-09-30 02:02:50','2024-09-30 02:02:50'),(2,'103.43.76.16',NULL,'2024-09-30 02:02:51','2024-09-30 02:02:51'),(3,'103.43.77.70',NULL,'2024-10-29 09:03:21','2024-10-29 09:03:21'),(4,'183.182.111.246',NULL,'2025-09-16 05:29:38','2025-09-16 05:29:38'),(5,'202.136.243.101',NULL,'2025-09-16 07:51:34','2025-09-16 07:51:34'),(6,'202.136.244.97',NULL,'2025-09-17 03:09:16','2025-09-17 03:09:16'),(7,'202.136.243.101',NULL,'2025-09-19 00:25:32','2025-09-19 00:25:32'),(8,'154.222.4.146',NULL,'2025-09-19 05:13:18','2025-09-19 05:13:18'),(9,'202.136.243.101',NULL,'2025-09-19 11:14:56','2025-09-19 11:14:56'),(10,'154.222.5.94',NULL,'2025-09-22 10:35:41','2025-09-22 10:35:41'),(11,'139.5.157.82',NULL,'2025-10-01 04:56:13','2025-10-01 04:56:13');
/*!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 AUTO_INCREMENT=3 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 */;
INSERT INTO `messages` VALUES (1,1,1,'Hi',NULL,0,'2025-09-18 01:23:14','2025-09-18 01:23:14'),(2,1,1,'你好',NULL,0,'2025-09-18 01:23:19','2025-09-18 01:23:19');
/*!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=368 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),(364,'2024_03_09_094824_add_is_default_col_to_order_cancel_reasons_table',91),(365,'2024_03_19_124736_add_halal_tag_status_col_to_restaurant_configs_table',91),(366,'2024_03_19_132910_add_is_halal_col_to_food_table',91),(367,'2024_03_21_113032_add_body_2_col_to_email_templates',91);
/*!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'),('7f74b6b039bdc6f03e54ced4c1be6e53a772cd2468abc2ed2a557f05fb1a7c8b5062f46f5fcc5574',2,1,'RestaurantCustomerAuth','[]',0,'2025-09-17 03:08:29','2025-09-17 03:08:29','2026-09-17 10:08:29'),('80e6cfd9d0f52f1db28e1b3d9132d600833abb6c14c4ab9e7a402c75bbf5a564d55cd080afe3450f',1,1,'RestaurantCustomerAuth','[]',0,'2024-10-01 08:59:23','2024-10-01 08:59:23','2025-10-01 15:59:23'),('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,
  `is_default` 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 `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,
  `halal_tag_status` 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 `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 AUTO_INCREMENT=3 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 */;
INSERT INTO `restaurant_tag` VALUES (1,2,2),(2,2,3);
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `restaurant_wallets` VALUES (1,1,0.00,0.00,0.00,0.00,'2025-09-16 07:55:00','2025-09-16 07:55:00');
/*!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=3 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,'house new','01700000000','Demo@Restaurant.com','2025-09-17-68cad592324be.png','17.95924297430006','102.61738135306632','Hose new ປີ2022-2023 ເກຍໂອໂຕ້ ໂຟວີນ ຊ້າຍເດີມ ເອກະສານຄົບ ກ້ອງ360 ເຊັນເຊີ້ຮອບຄັນລາຄາ66,500$ ສົດ ຜ່ອນ ເທີນ\r\nສົນໃຈຕິດຕໍ່ 02093196329',NULL,0.00,NULL,0,'10:00:00','23:00:00',1,1,'2023-09-08 16:35:02','2025-09-17 15:36:50',0,NULL,'2025-09-16-68c917c8388e4.png',1,1,1,10.00,2,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,'[]'),(2,'ຂາຍດິນຈັດສັນ ວັງທອງ','+21322220022','Josh@gmail.com','2025-09-17-68cad57b59e67.png','17.992180030943','102.58086322396335','Simueng Vientiane Laos',NULL,0.00,NULL,0,'10:00:00','23:00:00',1,2,'2024-10-01 09:10:32','2025-09-17 15:36:27',0,NULL,'2024-10-01-66fbbc87b449e.png',1,1,1,0.00,2,1,1,' ',NULL,0,0,0.00,'10-20-min',1,1,0,0,NULL,'none',NULL,'lao-deun',0,0,NULL,NULL,NULL,0,NULL,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=5 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'),(2,'ຈຳກັດຜູ້ດຽວ 020-56259999 - ທ່ານເຄີຍສົງໄສບໍ່ວ່າເປັນຫຍັງ ເວລາຊື້-ຂາຍທີ່ດິນ ຄົນຈຶ່ງມັກເວົ້າເຖິງ ໃບຕາດິນ','2025-09-16 07:49:43','2025-09-16 07:49:43'),(3,'','2025-09-16 07:52:43','2025-09-16 07:52:43'),(4,'New House','2025-09-17 03:01:21','2025-09-17 03:01:21');
/*!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=111 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','StackFood',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','Register as seller and open shop to start your business',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','Register as delivery man and earn money',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','Stack Food',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','LAND & HOUSE',NULL,NULL),(45,'App\\Models\\Category',1,'en','name','Fine Dining Restaurants',NULL,NULL),(46,'App\\Models\\Category',2,'en','name','Demo Sub Category',NULL,NULL),(47,'App\\Models\\Restaurant',1,'en','name','House new ປີ2022-2023',NULL,NULL),(48,'App\\Models\\Restaurant',1,'en','address','House 1005, 1007, 1216 Road no: 09, Vientiane1216 Laos',NULL,NULL),(49,'App\\Models\\AddOn',1,'en','name','Water',NULL,NULL),(50,'App\\Models\\Food',1,'en','name','ເຮືອນສອງຊັ້ນ',NULL,NULL),(51,'App\\Models\\Food',1,'en','description','ESTFUL SPACES\r\n\r\nSavour the solitude on the first floor with three bedrooms equipped with built-in robes and a master suite that sinks into its surrounds. Journey through the extended walk-in robe (fully prepared for your next shopping trip) in this grand room to reach an ensuite that will make the day you’ve had melt away.\r\n\r\nEXTEND THE PARTY SEAMLESSLY\r\n\r\nSlide open the back doors to draw together the undercover outdoor living and open plan kitchen, living and dining. Before long, the street party will always end at your house.',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\\Zone',2,'zh','name','Laos',NULL,NULL),(55,'App\\Models\\Cuisine',1,'zh','cuisine_name','土地和房屋',NULL,NULL),(56,'App\\Models\\Restaurant',2,'en','name','Lao Deun',NULL,NULL),(57,'App\\Models\\Restaurant',2,'en','address','Simueng Vientiane Laos',NULL,NULL),(58,'App\\Models\\Restaurant',2,'zh','address','老挝万象西芒',NULL,NULL),(59,'App\\Models\\Restaurant',2,'lo','name','ຂາຍດິນຈັດສັນ ວັງທອງ',NULL,NULL),(60,'App\\Models\\Restaurant',2,'lo','address','ສີເມືອງ ວຽງຈັນ ລາວ',NULL,NULL),(61,'App\\Models\\Restaurant',1,'zh','name','Hose new ປີ2022-2023',NULL,NULL),(62,'App\\Models\\Restaurant',1,'zh','address','1005、1007 号，1216 路 09，万象 1216 老挝',NULL,NULL),(63,'App\\Models\\Restaurant',1,'lo','name','ເຮືອນໃໝ່ ປີ2022-2023',NULL,NULL),(64,'App\\Models\\Restaurant',1,'lo','address','TOYOTA FORTUNER LEGENDER ປີ2022-2023 ເກຍໂອໂຕ້ ໂຟວີນ ຊ້າຍເດີມ ເອກະສານຄົບ ກ້ອງ360 ເຊັນເຊີ້ຮອບຄັນລາຄາ66,500$ ສົດ ຜ່ອນ ເທີນ\r\nສົນໃຈຕິດຕໍ່ 02093196329',NULL,NULL),(65,'App\\Models\\Category',3,'en','name','Bistro',NULL,NULL),(66,'App\\Models\\Category',4,'en','name','Casual Dining condo',NULL,NULL),(67,'App\\Models\\Category',4,'zh','name','休闲',NULL,NULL),(68,'App\\Models\\Category',4,'lo','name','ຫ້ອງຮັບປະທານອາຫານແບບສະບາຍໆ',NULL,NULL),(69,'App\\Models\\Category',5,'en','name','Modern House',NULL,NULL),(70,'App\\Models\\Category',1,'zh','name','高级',NULL,NULL),(71,'App\\Models\\Category',1,'lo','name','ຄ່ຳແຊບໆ',NULL,NULL),(72,'App\\Models\\DataSetting',5,'en','header_title','Why stay Hungry !',NULL,NULL),(73,'App\\Models\\DataSetting',6,'en','header_sub_title','when you can order always form',NULL,NULL),(74,'App\\Models\\DataSetting',7,'en','header_tag_line','Start Your Business or Download the App',NULL,NULL),(75,'App\\Models\\DataSetting',8,'en','header_app_button_name','Order Now',NULL,NULL),(76,'App\\Models\\DataSetting',5,'zh','header_title','为何保持饥饿！',NULL,NULL),(77,'App\\Models\\DataSetting',6,'zh','header_sub_title','ເປັນຫຍັງຈຶ່ງຫິວ!',NULL,NULL),(78,'App\\Models\\DataSetting',20,'en','feature_title','Stunning Features',NULL,NULL),(79,'App\\Models\\DataSetting',21,'en','feature_sub_title','Remarkable Features that You Can Count!',NULL,NULL),(80,'App\\Models\\DataSetting',20,'zh','feature_title','令人惊叹的功能',NULL,NULL),(81,'App\\Models\\DataSetting',21,'lo','feature_sub_title','ຄຸນນະສົມບັດທີ່ຫນ້າປະຫລາດໃຈ',NULL,NULL),(82,'App\\Models\\Food',1,'zh','name','双层住宅',NULL,NULL),(83,'App\\Models\\Food',1,'zh','description','静谧空间\r\n\r\n一楼设有三间卧室，均配备嵌入式衣橱，主卧套房与周围环境融为一体，让您尽享宁静。穿过宽敞的步入式衣橱（为您的下一次购物之旅做好了充分准备），来到这间宽敞的房间，即可到达套间浴室，让您一整天的疲惫都烟消云散。\r\n\r\n无缝延伸派对\r\n\r\n拉开后门，将隐蔽的户外生活区与开放式厨房、客厅和餐厅连接起来。很快，街头派对就将永远在您的家中结束。',NULL,NULL),(84,'App\\Models\\Food',1,'lo','name','ປີ້ງປາແຊມມອນ Tasmanian',NULL,NULL),(85,'App\\Models\\Food',1,'lo','description','ຊ່ອງທີ່ງຽບສະຫງົບ\r\n\r\nຊັ້ນທໍາອິດມີສາມຫ້ອງນອນ, ທັງຫມົດມີຕູ້ເສື້ອຜ້າໃນຕົວ. ຊຸດແມ່ບົດປະສົມເຂົ້າກັບສິ່ງອ້ອມຂ້າງຂອງມັນຢ່າງບໍ່ຢຸດຢັ້ງ, ເຊີນເຈົ້າໃຫ້ສຳຜັດກັບຄວາມງຽບສະຫງົບ. ຍ່າງຜ່ານຕູ້ເສື້ອຜ້າທີ່ກວ້າງຂວາງ (ເຫມາະສໍາລັບການເດີນທາງຊື້ເຄື່ອງຄັ້ງຕໍ່ໄປຂອງທ່ານ) ແລະເຂົ້າໄປໃນຫ້ອງທີ່ກວ້າງຂວາງນີ້, ນໍາໄປສູ່ຫ້ອງນ້ໍາທີ່ມີນ້ໍາທີ່ທ່ານສາມາດຜ່ອນຄາຍຫຼັງຈາກມື້ດົນນານ.\r\n\r\nຂະຫຍາຍພັກຢ່າງບໍ່ຢຸດຢັ້ງ\r\n\r\nເປີດປະຕູຫລັງເພື່ອເຊື່ອມຕໍ່ພື້ນທີ່ໃຊ້ສອຍກາງແຈ້ງກັບຫ້ອງຄົວ, ຫ້ອງຮັບແຂກ ແລະຫ້ອງຮັບປະທານອາຫານ. ໃນໄວໆນີ້, ງານລ້ຽງຕາມຖະຫນົນຈະສິ້ນສຸດລົງສໍາລັບການທີ່ດີ.',NULL,NULL),(86,'App\\Models\\Category',6,'en','name','Land',NULL,NULL),(87,'App\\Models\\Category',7,'en','name','Apartment',NULL,NULL),(88,'App\\Models\\Category',8,'en','name','Rent land & House',NULL,NULL),(89,'App\\Models\\Category',9,'en','name','House',NULL,NULL),(90,'App\\Models\\Category',9,'zh','name','家',NULL,NULL),(91,'App\\Models\\Category',9,'lo','name','ເຮືອນ',NULL,NULL),(92,'App\\Models\\Category',5,'zh','name','现代住宅',NULL,NULL),(93,'App\\Models\\Category',5,'lo','name','ເຮືອນທີ່ທັນສະໄຫມ',NULL,NULL),(94,'App\\Models\\Category',8,'lo','name','ໃຫ້ເຊົ່າທີ່ດິນ & ເຮືອນ',NULL,NULL),(95,'App\\Models\\Category',7,'zh','name','公寓',NULL,NULL),(96,'App\\Models\\Category',7,'lo','name','ອາພາດເມັນ',NULL,NULL),(97,'App\\Models\\Category',6,'zh','name','土地',NULL,NULL),(98,'App\\Models\\Category',6,'lo','name','ທີ່ດິນ',NULL,NULL),(99,'App\\Models\\Restaurant',2,'zh','name','万通土地出售',NULL,NULL),(100,'App\\Models\\Cuisine',1,'lo','cuisine_name','ທີ່ດິນແລະເຮືອນ',NULL,NULL),(101,'App\\Models\\Banner',1,'en','title','propertylaos',NULL,NULL),(102,'App\\Models\\Banner',2,'en','title','AIR',NULL,NULL),(103,'App\\Models\\Banner',3,'en','title','Iphone',NULL,NULL),(104,'App\\Models\\Category',8,'zh','name','土地及房屋租赁',NULL,NULL),(105,'App\\Models\\Cuisine',2,'en','cuisine_name','Garden',NULL,NULL),(106,'App\\Models\\Cuisine',2,'zh','cuisine_name','花园洋房',NULL,NULL),(107,'App\\Models\\Cuisine',2,'lo','cuisine_name','ເຮືອນສວນ',NULL,NULL),(108,'App\\Models\\Cuisine',3,'en','cuisine_name','Apartment',NULL,NULL),(109,'App\\Models\\Cuisine',3,'zh','cuisine_name','公寓',NULL,NULL),(110,'App\\Models\\Cuisine',3,'lo','cuisine_name','ອາພາດເມັນ',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 AUTO_INCREMENT=2 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 */;
INSERT INTO `user_infos` VALUES (1,'Jk','Keomanivong','+8562022228888','soulinny2020@gmail.com',NULL,NULL,2,NULL,NULL,'2025-09-17 12:43:14','2025-09-17 12:43:14');
/*!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 AUTO_INCREMENT=3 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 */;
INSERT INTO `users` VALUES (1,'Jik','KMNV','+8562022002288','soulinny2017@gmail.com',NULL,0,NULL,'$2y$10$GgHTyTuQclBFT3xd6XJnF./OA3U5e3LG1ouPBJt0eL7ew.TGWXzjq',NULL,'2024-10-01 08:59:22','2024-10-01 09:01:37','[1]','@',1,0,NULL,NULL,2,0.000,0.000,'DQZV3HQESG',NULL,NULL,'en'),(2,'Jk','Keomanivong','+8562022228888','soulinny2020@gmail.com',NULL,0,NULL,'$2y$10$FgDCwHU/QTyYF14iXgmC/OZpXKbBpFa4w.Kd6adPQkXRnAexGRM7q',NULL,'2025-09-17 03:08:29','2025-09-17 03:08:48','[6,7,8,9,1,3,4]','@',1,0,NULL,NULL,2,0.000,0.000,'JQGGVSLJ2J',NULL,NULL,'en');
/*!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=3 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,'Great North','Restaurant','01700000000','Demo@Restaurant.com',NULL,'$2a$12$NQBXTu9.U.jS0McEJPVEZuVcC2eAorHB8vQXCPlbcXuJM/mb9RpfO',NULL,'2023-09-08 16:35:02','2024-10-01 09:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(2,'Josh','adm','+21322220022','Josh@gmail.com',NULL,'$2y$10$VziaaOHaTFsKC21KqFO9culENMmZo1tMOWFWlW7DGZIysFkMt8S6m',NULL,'2024-10-01 09:10:31','2024-10-01 09:10:31',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 AUTO_INCREMENT=13 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 */;
INSERT INTO `visitor_logs` VALUES (1,'App\\Models\\Category',3,1,11,0,'2024-10-29 09:01:01','2024-10-29 09:01:01'),(2,'App\\Models\\Category',1,1,9,0,'2024-10-29 09:00:58','2024-10-29 09:00:58'),(3,'App\\Models\\Restaurant',1,1,14,0,'2024-10-29 09:01:23','2024-10-29 09:01:23'),(4,'App\\Models\\Category',4,1,5,0,'2024-10-29 09:00:55','2024-10-29 09:00:55'),(5,'App\\Models\\Restaurant',1,2,28,0,'2025-09-29 08:19:43','2025-09-29 08:19:43'),(6,'App\\Models\\Category',6,2,8,0,'2025-09-20 12:59:23','2025-09-20 12:59:23'),(7,'App\\Models\\Restaurant',2,2,6,0,'2025-09-20 07:36:19','2025-09-20 07:36:19'),(8,'App\\Models\\Category',7,2,4,0,'2025-09-19 08:13:36','2025-09-19 08:13:36'),(9,'App\\Models\\Category',8,2,3,0,'2025-09-17 15:43:50','2025-09-17 15:43:50'),(10,'App\\Models\\Category',4,2,4,0,'2025-09-29 05:55:48','2025-09-29 05:55:48'),(11,'App\\Models\\Category',9,2,1,0,'2025-09-17 15:43:48','2025-09-17 15:43:48'),(12,'App\\Models\\Category',1,2,1,0,'2025-09-17 15:43:53','2025-09-17 15:43:53');
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `wishlists` VALUES (1,2,NULL,'2025-09-19 12:34:43','2025-09-19 12:34:43',2);
/*!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����dZ@��´,@���W�X@�£�Y�3@���bY@x�d���7@����I[@��C�\Z/@����dZ@��´,@',1,'2024-09-30 18:48:30','2024-09-30 18:48:54','zone_2_restaurant','zone_2_customer','zone_2_delivery_man',10000.000,100.000,50000.000,NULL,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