-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 28, 2024 at 09:43 AM -- Server version: 10.6.18-MariaDB -- PHP Version: 8.1.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `mimeld_mxepto` -- -- -------------------------------------------------------- -- -- Table structure for table `addon_settings` -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `addon_settings` -- INSERT INTO `addon_settings` (`id`, `key_name`, `live_values`, `test_values`, `settings_type`, `mode`, `is_active`, `created_at`, `updated_at`, `additional_data`) 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\":\"data\",\"public_key\":\"data\"}', '{\"gateway\":\"mercadopago\",\"mode\":\"test\",\"status\":\"0\",\"access_token\":\"data\",\"public_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-27 11:57:11', '{\"gateway_title\":null,\"gateway_image\":\"2023-04-12-64367be3b7b6a.png\"}'), ('0d8a9e49-d6a5-11ed-962c-0c7a158e4469', 'liqpay', '{\"gateway\":\"liqpay\",\"mode\":\"test\",\"status\":\"0\",\"private_key\":\"data\",\"public_key\":\"data\"}', '{\"gateway\":\"liqpay\",\"mode\":\"test\",\"status\":\"0\",\"private_key\":\"data\",\"public_key\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:32:31', '{\"gateway_title\":null,\"gateway_image\":\"\"}'), ('101befdf-d44b-11ed-8564-0c7a158e4469', 'paypal', '{\"gateway\":\"paypal\",\"mode\":\"live\",\"status\":\"0\",\"client_id\":null,\"client_secret\":null}', '{\"gateway\":\"paypal\",\"mode\":\"live\",\"status\":\"0\",\"client_id\":null,\"client_secret\":null}', 'payment_config', 'live', 1, NULL, '2023-08-30 03:41:32', '{\"gateway_title\":\"Paypal\",\"gateway_image\":null}'), ('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\":null,\"api_secret\":null,\"token\":null,\"from\":null,\"otp_template\":null}', '{\"gateway\":\"nexmo\",\"mode\":\"live\",\"status\":0,\"api_key\":null,\"api_secret\":null,\"token\":null,\"from\":null,\"otp_template\":null}', 'sms_config', 'live', 1, 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\":\"data\",\"merchant_id\":\"data\",\"merchant_website_link\":\"data\"}', '{\"gateway\":\"paytm\",\"mode\":\"test\",\"status\":\"0\",\"merchant_key\":\"data\",\"merchant_id\":\"data\",\"merchant_website_link\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-22 06:30:55', '{\"gateway_title\":null,\"gateway_image\":\"\"}'), ('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\":\"data\",\"server_key\":\"data\",\"base_url\":\"data\"}', '{\"gateway\":\"paytabs\",\"mode\":\"test\",\"status\":\"0\",\"profile_id\":\"data\",\"server_key\":\"data\",\"base_url\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:34:51', '{\"gateway_title\":null,\"gateway_image\":\"\"}'), ('4e9b8dfb-e7d1-11ed-a559-0c7a158e4469', 'bkash', '{\"gateway\":\"bkash\",\"mode\":\"test\",\"status\":\"0\",\"app_key\":\"data\",\"app_secret\":\"data\",\"username\":\"data\",\"password\":\"data\"}', '{\"gateway\":\"bkash\",\"mode\":\"test\",\"status\":\"0\",\"app_key\":\"data\",\"app_secret\":\"data\",\"username\":\"data\",\"password\":\"data\"}', 'payment_config', 'test', 0, NULL, '2023-08-12 06:39:42', '{\"gateway_title\":null,\"gateway_image\":\"\"}'), ('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\":\"live\",\"status\":\"0\",\"api_key\":null,\"published_key\":null}', '{\"gateway\":\"stripe\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"published_key\":null}', 'payment_config', 'live', 1, NULL, '2023-08-30 04:18:55', '{\"gateway_title\":\"Stripe\",\"gateway_image\":null}'), ('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\":\"live\",\"status\":\"0\",\"api_key\":null,\"api_secret\":null}', '{\"gateway\":\"razor_pay\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":null,\"api_secret\":null}', 'payment_config', 'live', 1, NULL, '2023-08-30 04:47:00', '{\"gateway_title\":\"Razor pay\",\"gateway_image\":null}'), ('ad5b02a0-d6a2-11ed-962c-0c7a158e4469', 'senang_pay', '{\"gateway\":\"senang_pay\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}', '{\"gateway\":\"senang_pay\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":null,\"secret_key\":null,\"merchant_id\":null}', 'payment_config', 'live', 1, NULL, '2023-08-27 09:58:57', '{\"gateway_title\":\"Senang pay\",\"gateway_image\":null}'), ('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\",\"api_key\":\"\",\"iframe_id\":\"\",\"integration_id\":\"\", \"hmac\": \"\", \"callback_url\":\"\"}', '{\"gateway\":\"paymob_accept\",\"mode\":\"live\",\"status\":\"0\",\"api_key\":\"\",\"iframe_id\":\"\",\"integration_id\":\"\", \"hmac\": \"\", \"callback_url\":\"\"}', 'payment_config', 'test', 0, NULL, NULL, NULL), ('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\":1,\"secret_key\":\"data\",\"public_key\":\"data\",\"hash\":\"data\"}', '{\"gateway\":\"flutterwave\",\"mode\":\"test\",\"status\":1,\"secret_key\":\"data\",\"public_key\":\"data\",\"hash\":\"data\"}', 'payment_config', 'test', 1, NULL, '2024-06-09 16:57:56', '{\"gateway_title\":\"Flutter Wave\",\"gateway_image\":\"2023-08-22-64e4439f95a8b.png\"}'), ('d822f1a5-c864-11ed-ac7a-0c7a158e4469', 'paystack', '{\"gateway\":\"paystack\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":\"https:\\/\\/api.paystack.co\",\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}', '{\"gateway\":\"paystack\",\"mode\":\"live\",\"status\":\"0\",\"callback_url\":\"https:\\/\\/api.paystack.co\",\"public_key\":null,\"secret_key\":null,\"merchant_email\":null}', 'payment_config', 'live', 1, NULL, '2023-08-30 04:20:45', '{\"gateway_title\":\"Paystack\",\"gateway_image\":null}'), ('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\":\"live\",\"status\":\"0\",\"store_id\":null,\"store_password\":null}', '{\"gateway\":\"ssl_commerz\",\"mode\":\"live\",\"status\":\"0\",\"store_id\":null,\"store_password\":null}', 'payment_config', 'live', 1, NULL, '2023-08-30 03:43:49', '{\"gateway_title\":\"Ssl commerz\",\"gateway_image\":null}'), ('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); -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `f_name` varchar(100) DEFAULT NULL, `l_name` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(100) NOT NULL, `identity_image` varchar(255) DEFAULT NULL, `identity_type` varchar(255) DEFAULT NULL, `identity_number` varchar(255) DEFAULT 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, `fcm_token` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `admin_role_id` bigint(20) NOT NULL DEFAULT 2 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `f_name`, `l_name`, `phone`, `email`, `identity_image`, `identity_type`, `identity_number`, `image`, `password`, `remember_token`, `created_at`, `updated_at`, `fcm_token`, `status`, `admin_role_id`) VALUES (1, 'Master', 'Demo', '449999999999', 'mira@mxepto.com', NULL, NULL, NULL, NULL, '$2y$10$b2S3Ta4N1.FH4ywQz9r5Oehdnns5ZLfCj/dw4A6NPwkYyuJZ4.7cW', NULL, '2024-06-06 16:15:41', '2024-06-27 08:29:04', NULL, 1, 1), (2, 'Admin', 'Demo', '+919903909333', 'admin@demo.com', '[\"2024-06-06-666299b152cbf.png\"]', 'passport', '123456', '2024-06-06-666299b1504a1.png', '$2y$10$dw/5igmHHsOrsizeLr/mNOT9h4wsDaZw7RXks4BMfOAcHHOaDfqpq', NULL, '2024-06-06 16:25:05', '2024-06-27 08:26:18', NULL, 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `admin_roles` -- CREATE TABLE `admin_roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `module_access` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admin_roles` -- INSERT INTO `admin_roles` (`id`, `name`, `module_access`, `status`, `created_at`, `updated_at`) VALUES (1, 'Master Admin', NULL, 1, '2022-06-17 16:45:59', '2022-06-17 16:45:59'), (2, 'admin', '[\"dashboard_management\",\"pos_management\",\"order_management\",\"promotion_management\",\"support_management\",\"report_management\",\"user_management\"]', 1, '2024-06-06 16:24:03', '2024-06-06 16:25:41'); -- -------------------------------------------------------- -- -- Table structure for table `attributes` -- CREATE TABLE `attributes` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `banners` -- CREATE TABLE `banners` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `image` varchar(100) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `category_id` bigint(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `banners` -- INSERT INTO `banners` (`id`, `title`, `image`, `product_id`, `status`, `created_at`, `updated_at`, `category_id`) VALUES (1, 'Test Banner', '2023-10-18-652fd17b82b49.png', NULL, 0, '2023-10-17 19:37:15', '2024-06-09 15:48:03', 1), (2, 'Drinks', '2024-06-09-6666857c994aa.png', 5, 1, '2024-06-09 15:47:56', '2024-06-09 15:47:56', NULL), (3, 'Bakery', '2024-06-09-666689bf7375c.png', NULL, 1, '2024-06-09 16:06:07', '2024-06-09 16:06:07', 10), (4, 'Fruits and vegetables', '2024-06-09-66668c0196291.png', NULL, 1, '2024-06-09 16:15:45', '2024-06-09 16:15:45', 4); -- -------------------------------------------------------- -- -- Table structure for table `branches` -- CREATE TABLE `branches` ( `id` bigint(20) UNSIGNED NOT NULL, `restaurant_id` bigint(20) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `latitude` varchar(255) DEFAULT NULL, `longitude` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `coverage` int(11) NOT NULL DEFAULT 1, `remember_token` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `branches` -- INSERT INTO `branches` (`id`, `restaurant_id`, `name`, `email`, `phone`, `password`, `latitude`, `longitude`, `address`, `status`, `created_at`, `updated_at`, `coverage`, `remember_token`, `image`) VALUES (1, NULL, 'Branch Demo', 'branch@demo.com', '7894561231', '$2y$10$F2JGlcq/s4w6xTkXEsQiUO02jwYAc6PcYghbsui8IN0y3BeuI4LZq', '19.068103410733578', '72.86734859079614', 'Mumbai BKC', 1, '2021-02-24 09:45:49', '2024-06-10 09:41:54', 50, NULL, '2024-06-06-66629a3924a0c.png'), (10, NULL, 'Branch Demo 2', 'branch2@demo.com', '9999996666', '$2y$10$2sMV.S3GjwmPz3aEVOggNOso/l4nbXkrz3XHyGwRJgH0quv4Tvpny', '19.06875237936922', '72.867863574927', 'BKC Mumbai', 1, '2024-06-10 09:43:37', '2024-06-10 09:52:54', 30, NULL, '2024-06-10-666699918ca02.png'); -- -------------------------------------------------------- -- -- Table structure for table `business_settings` -- CREATE TABLE `business_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) DEFAULT NULL, `value` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `business_settings` -- INSERT INTO `business_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (1, 'self_pickup', '1', '2021-01-06 05:55:51', '2021-01-06 05:55:51'), (3, 'restaurant_name', 'MXEpto', NULL, NULL), (4, 'currency', 'USD', NULL, NULL), (5, 'logo', '2024-06-07-6663143eae06e.png', NULL, NULL), (6, 'mail_config', '{\"status\":1,\"name\":\"MXEpto\",\"host\":\"mail.mimeld.com\",\"driver\":\"smtp\",\"port\":\"465\",\"username\":\"demo@mimeld.com\",\"email_id\":\"demo@mimeld.com\",\"encryption\":\"ssl\",\"password\":\"DemoEmail_$321\"}', NULL, '2024-06-06 16:20:09'), (7, 'delivery_charge', '100', NULL, NULL), (8, 'ssl_commerz_payment', '{\"status\":\"0\",\"store_id\":null,\"store_password\":null}', NULL, '2021-07-25 09:32:22'), (9, 'paypal', '{\"status\":\"0\",\"paypal_client_id\":null,\"paypal_secret\":null}', NULL, '2021-07-25 09:32:42'), (10, 'stripe', '{\"status\":\"0\",\"api_key\":null,\"published_key\":null}', NULL, '2021-07-25 09:32:50'), (11, 'phone', '+91 9830009649', NULL, NULL), (13, 'footer_text', '© MXEpto @ 2024', NULL, NULL), (14, 'address', 'Global', NULL, NULL), (15, 'email_address', 'info@miracuves.com', NULL, NULL), (16, 'cash_on_delivery', '{\"status\":\"1\"}', NULL, '2021-02-11 18:39:36'), (17, 'email_verification', '0', NULL, NULL), (18, 'digital_payment', '{\"status\":\"1\"}', '2021-01-30 19:38:54', '2021-01-30 19:38:58'), (19, 'terms_and_conditions', '

', NULL, '2021-05-30 08:51:56'), (20, 'fcm_topic', '', NULL, NULL), (21, 'fcm_project_id', '3f34f34', NULL, NULL), (22, 'push_notification_key', 'demo', NULL, NULL), (24, 'order_pending_message', '{\"status\":1,\"message\":\"Your order has been placed successfully.\"}', NULL, NULL), (25, 'order_processing_message', '{\"status\":1,\"message\":\"Your order is going to the cook\"}', NULL, NULL), (26, 'out_for_delivery_message', '{\"status\":1,\"message\":\"Order out for delivery.\"}', NULL, NULL), (27, 'order_delivered_message', '{\"status\":1,\"message\":\"delivered\"}', NULL, NULL), (28, 'delivery_boy_assign_message', '{\"status\":1,\"message\":\"boy assigned\"}', NULL, NULL), (29, 'delivery_boy_start_message', '{\"status\":1,\"message\":\"start delivery\"}', NULL, NULL), (30, 'delivery_boy_delivered_message', '{\"status\":1,\"message\":\"boy delivered\"}', NULL, NULL), (32, 'order_confirmation_msg', '{\"status\":1,\"message\":\"Your order has been confirmed.\"}', NULL, NULL), (33, 'razor_pay', '{\"status\":\"0\",\"razor_key\":null,\"razor_secret\":null}', '2021-02-14 10:15:12', '2021-07-25 09:32:32'), (34, 'location_coverage', '{\"status\":1,\"longitude\":\"91.410747\",\"latitude\":\"22.986282\",\"coverage\":\"20\"}', NULL, NULL), (35, 'minimum_order_value', '50', NULL, NULL), (36, 'software_mode', 'dev', NULL, NULL), (37, 'software_version', NULL, NULL, NULL), (38, 'paystack', '{\"status\":\"0\",\"publicKey\":null,\"secretKey\":null,\"paymentUrl\":\"https:\\/\\/api.paystack.co\",\"merchantEmail\":null}', '2021-04-24 18:40:34', '2021-07-25 09:33:19'), (39, 'senang_pay', '{\"status\":\"0\",\"secret_key\":null,\"merchant_id\":null}', '2021-04-27 14:02:18', '2021-07-25 09:33:06'), (40, 'privacy_policy', '

rjdrjf

', NULL, '2021-05-30 08:52:40'), (41, 'about_us', '

hello

', NULL, '2021-05-30 08:44:52'), (42, 'paystack', '{\"status\":\"0\",\"publicKey\":null,\"secretKey\":null,\"paymentUrl\":\"https:\\/\\/api.paystack.co\",\"merchantEmail\":null}', NULL, '2021-07-25 09:33:19'), (43, 'currency_symbol_position', 'left', NULL, NULL), (44, 'country', 'IN', NULL, NULL), (45, 'language', '[{\"id\":1,\"name\":\"en\",\"direction\":\"ltr\",\"code\":\"en\",\"status\":1,\"default\":true},{\"id\":2,\"name\":\"French\",\"direction\":\"ltr\",\"code\":\"fr\",\"status\":1,\"default\":false}]', NULL, '2024-06-09 16:21:39'), (46, 'time_zone', 'Asia/Calcutta', NULL, NULL), (47, 'phone_verification', '0', NULL, NULL), (48, 'maintenance_mode', '0', NULL, NULL), (49, 'twilio_sms', '{\"status\":0,\"sid\":null,\"token\":null,\"from\":null,\"otp_template\":null}', '2021-09-05 09:16:15', '2021-09-05 09:16:15'), (50, 'nexmo_sms', '{\"status\":0,\"api_key\":null,\"api_secret\":null,\"signature_secret\":\"\",\"private_key\":\"\",\"application_id\":\"\",\"from\":null,\"otp_template\":null}', '2021-09-05 09:16:20', '2021-09-05 09:16:20'), (51, '2factor_sms', '{\"status\":\"0\",\"api_key\":null}', '2021-09-05 09:16:25', '2021-09-05 09:16:25'), (52, 'msg91_sms', '{\"status\":0,\"template_id\":null,\"authkey\":null}', '2021-09-05 09:16:30', '2021-09-05 09:16:30'), (53, 'pagination_limit', '10', NULL, NULL), (54, 'map_api_key', '', NULL, NULL), (55, 'delivery_management', '{\"status\":\"1\",\"min_shipping_charge\":\"30\",\"shipping_per_km\":\"15\"}', NULL, NULL), (56, 'play_store_config', '{\"status\":\"\",\"link\":\"\",\"min_version\":\"1\"}', NULL, NULL), (57, 'app_store_config', '{\"status\":\"\",\"link\":\"\",\"min_version\":\"1\"}', NULL, NULL), (58, 'recaptcha', '{\"status\":\"0\",\"site_key\":\"\",\"secret_key\":\"\"}', NULL, NULL), (59, 'decimal_point_settings', '2', NULL, NULL), (60, 'time_format', '24', NULL, NULL), (61, 'minimum_stock_limit', '1', NULL, NULL), (62, 'faq', NULL, NULL, NULL), (63, 'google_social_login', '1', NULL, NULL), (64, 'facebook_social_login', '1', NULL, NULL), (65, 'wallet_status', '1', NULL, NULL), (66, 'loyalty_point_status', '1', NULL, NULL), (67, 'ref_earning_status', '1', NULL, NULL), (68, 'loyalty_point_exchange_rate', '10', NULL, NULL), (69, 'ref_earning_exchange_rate', '2', NULL, NULL), (70, 'loyalty_point_percent_on_item_purchase', '5', NULL, NULL), (71, 'loyalty_point_minimum_point', '1', NULL, NULL), (72, 'free_delivery_over_amount', '2000', NULL, NULL), (73, 'maximum_amount_for_cod_order', '1000', NULL, NULL), (74, 'cookies', '{\"status\":null,\"text\":\"We use cookies to enhance your browsing experience and provide personalized content. By clicking \\\"Accept\\\", you consent to the use of all cookies. However, you may visit \\\"Cookie Settings\\\" to provide a controlled consent.\"}', NULL, NULL), (75, 'offline_payment', '{\"status\":\"1\"}', NULL, NULL), (76, 'product_vat_tax_status', 'excluded', NULL, NULL), (77, 'whatsapp', '{\"status\":\"0\",\"number\":\"\"}', NULL, NULL), (78, 'telegram', '{\"status\":\"0\",\"user_name\":\"\"}', NULL, NULL), (79, 'messenger', '{\"status\":\"0\",\"user_name\":\"\"}', NULL, NULL), (80, 'featured_product_status', '1', NULL, NULL), (81, 'trending_product_status', '1', NULL, NULL), (82, 'most_reviewed_product_status', '1', NULL, NULL), (83, 'recommended_product_status', '1', NULL, NULL), (84, 'fav_icon', '2024-06-07-6663143eb09e3.png', NULL, NULL), (85, 'dm_self_registration', '1', NULL, NULL), (86, 'maximum_otp_hit', '5', NULL, NULL), (87, 'otp_resend_time', '60', NULL, NULL), (88, 'temporary_block_time', '600', NULL, NULL), (89, 'maximum_login_hit', '5', NULL, NULL), (90, 'temporary_login_block_time', '600', NULL, NULL), (91, 'guest_checkout', '1', NULL, NULL), (92, 'partial_payment', '1', NULL, NULL), (93, 'partial_payment_combine_with', 'all', NULL, NULL), (94, 'deliveryman_order_processing_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (95, 'add_fund_wallet_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (96, 'add_fund_wallet_bonus_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (97, 'apple_login', '{\"status\":0, \"login_medium\":\"apple\",\"client_id\":\"\",\"client_secret\":\"\",\"team_id\":\"\",\"key_id\":\"\",\"service_file\":\"\",\"redirect_url\":\"\"}', NULL, NULL), (98, 'customer_notify_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (99, 'returned_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (100, 'failed_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (101, 'canceled_message', '{\"status\":0,\"message\":\"\"}', NULL, NULL), (102, 'firebase_otp_verification', '{\"status\":0,\"web_api_key\":\"AIzaSyAKl3frFSI0VvbFP96z3Xslazi0n0gvZrM\"}', NULL, NULL), (103, 'map_api_server_key', 'AIzaSyAWbWNOIN2NVRIHbjhflvEh4JDr2ZkJ3xA', NULL, NULL), (104, 'map_api_client_key', 'AIzaSyAWbWNOIN2NVRIHbjhflvEh4JDr2ZkJ3xA', NULL, NULL), (105, 'firebase_message_config', '{\"apiKey\":\"AIzaSyB1yknK0gIk3ofWb6SlH9mlIk83tQ5Q83Q\",\"authDomain\":\"mxepto.firebaseapp.com\",\"projectId\":\"mxepto\",\"storageBucket\":\"mxepto.appspot.com\",\"messagingSenderId\":\"47276574048\",\"appId\":\"1:47276574048:web:be09aa7d47c41d68494a05\"}', '2024-06-09 15:55:06', '2024-06-09 15:55:06'), (106, 'free_delivery_over_amount_status', '1', NULL, NULL), (107, 'add_fund_to_wallet', '1', NULL, NULL), (108, 'maximum_amount_for_cod_order_status', '1', NULL, NULL), (109, 'order_image_status', '0', NULL, NULL), (110, 'order_image_label_name', NULL, NULL, NULL), (111, 'cancellation_policy', '', NULL, NULL), (112, 'cancellation_policy_status', '0', NULL, NULL), (113, 'refund_policy', '', NULL, NULL), (114, 'refund_policy_status', '0', NULL, NULL), (115, 'return_policy', '', NULL, NULL), (116, 'return_policy_status', '0', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `parent_id` bigint(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, `image` varchar(255) NOT NULL DEFAULT 'def.png', `priority` tinyint(4) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `parent_id`, `position`, `status`, `created_at`, `updated_at`, `image`, `priority`) VALUES (1, 'Test Category', 0, 0, 0, '2023-10-17 19:36:43', '2024-06-06 20:58:00', '2023-10-18-652fd15b117f7.png', 1), (2, 'Test Subcategory', 1, 1, 1, '2023-10-17 19:57:26', '2023-10-17 19:57:26', 'def.png', 1), (3, 'Daily Bread & Eggs', 0, 0, 1, '2024-06-06 19:41:53', '2024-06-06 21:08:55', '2024-06-06-6662dc37b9d24.png', 1), (4, 'Fruits & Vegetables', 0, 0, 1, '2024-06-06 19:43:01', '2024-06-06 21:09:32', '2024-06-06-6662dc5c9b5af.png', 1), (5, 'Paan Corner', 0, 0, 1, '2024-06-06 19:44:01', '2024-06-06 21:11:08', '2024-06-06-6662dcbc8b074.png', 1), (6, 'Cold Drinks & Juices', 0, 0, 1, '2024-06-06 19:44:41', '2024-06-06 21:12:13', '2024-06-06-6662dcfd44226.png', 1), (7, 'Snacks & Muniches', 0, 0, 1, '2024-06-06 19:45:20', '2024-06-06 21:12:28', '2024-06-06-6662dd0ca08fd.png', 1), (8, 'Breakfast & Instant food', 0, 0, 1, '2024-06-06 19:45:57', '2024-06-06 21:12:57', '2024-06-06-6662dd29b8761.png', 1), (9, 'Sweet Tooth', 0, 0, 1, '2024-06-06 19:46:40', '2024-06-06 21:13:14', '2024-06-06-6662dd3a12d3c.png', 1), (10, 'Bakery & Biscuits', 0, 0, 1, '2024-06-06 19:47:15', '2024-06-06 21:13:49', '2024-06-06-6662dd5d0f9b0.png', 1), (11, 'Tea, Coffee & Health Drink', 0, 0, 1, '2024-06-06 19:47:54', '2024-06-06 21:14:05', '2024-06-06-6662dd6db5617.png', 1), (12, 'Atta, Rice & Dal', 0, 0, 1, '2024-06-06 19:48:36', '2024-06-06 21:14:25', '2024-06-06-6662dd81bf99e.png', 1), (13, 'Bread & Pav', 3, 1, 1, '2024-06-06 19:49:56', '2024-06-06 19:49:56', 'def.png', 1), (14, 'Milk', 3, 1, 1, '2024-06-06 19:50:07', '2024-06-06 19:50:07', 'def.png', 1), (15, 'Fresh Fruits', 4, 1, 1, '2024-06-06 19:50:53', '2024-06-06 19:50:53', 'def.png', 1), (16, 'Fresh Vegetables', 4, 1, 1, '2024-06-06 19:51:09', '2024-06-06 19:51:09', 'def.png', 1), (17, 'Smoking & Cessation', 5, 1, 1, '2024-06-06 19:51:42', '2024-06-06 20:03:02', 'def.png', 1), (18, 'Lighter & Accessories', 5, 1, 1, '2024-06-06 19:52:35', '2024-06-06 20:04:13', 'def.png', 1), (19, 'Soft Drinks', 6, 1, 1, '2024-06-06 19:53:13', '2024-06-06 19:53:13', 'def.png', 1), (21, 'Fruit Juices', 6, 1, 1, '2024-06-06 19:54:30', '2024-06-06 19:54:30', 'def.png', 1), (22, 'Energy bars', 7, 1, 1, '2024-06-06 19:55:44', '2024-06-06 19:55:44', 'def.png', 1), (23, 'Chips & Crisps', 7, 1, 1, '2024-06-06 19:56:14', '2024-06-06 19:56:14', 'def.png', 1), (24, 'Noodles', 8, 1, 1, '2024-06-06 19:56:37', '2024-06-06 19:56:37', 'def.png', 1), (25, 'Pasta', 8, 1, 1, '2024-06-06 19:57:23', '2024-06-06 19:57:23', 'def.png', 1), (26, 'Indian Sweets', 9, 1, 1, '2024-06-06 19:57:56', '2024-06-06 19:57:56', 'def.png', 1), (27, 'Chocolate', 9, 1, 1, '2024-06-06 19:58:24', '2024-06-06 19:58:24', 'def.png', 1), (28, 'Biscuits Gifts Packs', 10, 1, 1, '2024-06-06 19:59:07', '2024-06-06 19:59:07', 'def.png', 1), (29, 'Cookies', 10, 1, 1, '2024-06-06 19:59:18', '2024-06-06 19:59:18', 'def.png', 1), (30, 'Tea', 11, 1, 1, '2024-06-06 19:59:40', '2024-06-06 19:59:40', 'def.png', 1), (31, 'Coffee', 11, 1, 1, '2024-06-06 19:59:53', '2024-06-06 19:59:53', 'def.png', 1), (32, 'Atta', 12, 1, 1, '2024-06-06 20:00:14', '2024-06-06 20:00:14', 'def.png', 1), (33, 'Rice', 12, 1, 1, '2024-06-06 20:00:22', '2024-06-06 20:00:22', 'def.png', 1); -- -------------------------------------------------------- -- -- Table structure for table `category_discounts` -- CREATE TABLE `category_discounts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `category_id` int(11) NOT NULL, `start_date` date DEFAULT NULL, `expire_date` date DEFAULT NULL, `discount_type` varchar(255) DEFAULT NULL, `discount_amount` double(8,2) NOT NULL DEFAULT 0.00, `maximum_amount` double(8,2) NOT NULL DEFAULT 0.00, `status` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_discounts` -- INSERT INTO `category_discounts` (`id`, `name`, `category_id`, `start_date`, `expire_date`, `discount_type`, `discount_amount`, `maximum_amount`, `status`, `created_at`, `updated_at`) VALUES (1, 'Cold Drinks & Juices', 6, '2024-06-10', '2024-06-12', 'percent', 2.00, 3.00, 0, '2024-06-10 10:00:06', '2024-06-10 10:00:06'); -- -------------------------------------------------------- -- -- Table structure for table `category_searched_by_user` -- CREATE TABLE `category_searched_by_user` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `category_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `conversations` -- CREATE TABLE `conversations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `message` text DEFAULT NULL, `reply` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `checked` tinyint(1) NOT NULL DEFAULT 0, `image` text DEFAULT NULL, `is_reply` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(100) DEFAULT NULL, `code` varchar(15) DEFAULT NULL, `start_date` date DEFAULT NULL, `expire_date` date DEFAULT NULL, `min_purchase` decimal(8,2) NOT NULL DEFAULT 0.00, `max_discount` decimal(8,2) NOT NULL DEFAULT 0.00, `discount` decimal(8,2) NOT NULL DEFAULT 0.00, `discount_type` varchar(15) NOT NULL DEFAULT 'percentage', `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `coupon_type` varchar(255) NOT NULL DEFAULT 'default', `limit` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` bigint(20) UNSIGNED NOT NULL, `country` varchar(255) DEFAULT NULL, `currency_code` varchar(255) DEFAULT NULL, `currency_symbol` varchar(255) DEFAULT NULL, `exchange_rate` decimal(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`id`, `country`, `currency_code`, `currency_symbol`, `exchange_rate`, `created_at`, `updated_at`) 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); -- -------------------------------------------------------- -- -- Table structure for table `customer_addresses` -- CREATE TABLE `customer_addresses` ( `id` bigint(20) UNSIGNED NOT NULL, `address_type` varchar(100) NOT NULL, `contact_person_number` varchar(20) NOT NULL, `address` varchar(250) DEFAULT NULL, `latitude` varchar(255) DEFAULT NULL, `longitude` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `is_guest` tinyint(4) NOT NULL DEFAULT 0, `contact_person_name` varchar(100) DEFAULT NULL, `road` varchar(255) DEFAULT NULL, `house` varchar(255) DEFAULT NULL, `floor` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customer_addresses` -- INSERT INTO `customer_addresses` (`id`, `address_type`, `contact_person_number`, `address`, `latitude`, `longitude`, `created_at`, `updated_at`, `user_id`, `is_guest`, `contact_person_name`, `road`, `house`, `floor`) VALUES (1, 'Home', '+919876543210', 'FC-7041/42, Bandra Kurla Complex Rd, G Block BKC, Bandra Kurla Complex, Bandra East, Mumbai, Maharashtra 400051, India', '19.068789261357825', '72.87026457488537', '2024-06-09 16:54:54', '2024-06-09 16:54:54', 1, 0, 'User Demo', NULL, NULL, NULL), (2, 'Home', '+919876543210', 'MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India', '19.069028504472136', '72.86648668348789', '2024-06-09 17:01:41', '2024-06-09 17:01:41', 1, 0, 'User Demo', NULL, NULL, NULL), (3, 'Home', '+919876543211', 'BKC Kurla, Taximens Colony Road, Ram Manohar Lohiya Nagar, Kurla West, Kurla, Mumbai, Maharashtra, India', '19.067043300000016', '72.87116449999999', '2024-06-27 09:12:56', '2024-06-27 09:12:56', 2, 0, 'User Demo 2', '11', '2', '2'); -- -------------------------------------------------------- -- -- Table structure for table `dc_conversations` -- CREATE TABLE `dc_conversations` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `dc_conversations` -- INSERT INTO `dc_conversations` (`id`, `order_id`, `created_at`, `updated_at`) VALUES (1, 100006, '2024-06-10 09:52:10', '2024-06-10 09:52:10'); -- -------------------------------------------------------- -- -- Table structure for table `delivery_histories` -- CREATE TABLE `delivery_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) DEFAULT NULL, `deliveryman_id` bigint(20) DEFAULT NULL, `time` datetime DEFAULT NULL, `longitude` varchar(255) DEFAULT NULL, `latitude` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `delivery_histories` -- INSERT INTO `delivery_histories` (`id`, `order_id`, `deliveryman_id`, `time`, `longitude`, `latitude`, `location`, `created_at`, `updated_at`) VALUES (1, 100006, 2, '2024-06-10 11:52:51', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:51', '2024-06-10 09:52:51'), (2, 100006, 2, '2024-06-10 11:52:52', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:52', '2024-06-10 09:52:52'), (3, 100006, 2, '2024-06-10 11:52:53', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:53', '2024-06-10 09:52:53'), (4, 100006, 2, '2024-06-10 11:52:57', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:57', '2024-06-10 09:52:57'), (5, 100006, 2, '2024-06-10 11:52:57', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:57', '2024-06-10 09:52:57'), (6, 100006, 2, '2024-06-10 11:52:58', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:52:58', '2024-06-10 09:52:58'), (7, 100006, 2, '2024-06-10 11:53:28', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:53:28', '2024-06-10 09:53:28'), (8, 100006, 2, '2024-06-10 11:54:08', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:54:08', '2024-06-10 09:54:08'), (9, 100006, 2, '2024-06-10 11:54:28', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:54:28', '2024-06-10 09:54:28'), (10, 100005, 2, '2024-06-10 11:55:41', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:55:41', '2024-06-10 09:55:41'), (11, 100005, 2, '2024-06-10 11:55:42', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:55:42', '2024-06-10 09:55:42'), (12, 100005, 2, '2024-06-10 11:55:58', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:55:58', '2024-06-10 09:55:58'), (13, 100005, 2, '2024-06-10 11:55:58', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:55:58', '2024-06-10 09:55:58'), (14, 100005, 2, '2024-06-10 11:56:22', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:56:22', '2024-06-10 09:56:22'), (15, 100005, 2, '2024-06-10 11:56:25', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:56:25', '2024-06-10 09:56:25'), (16, 100005, 2, '2024-06-10 11:56:26', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:56:26', '2024-06-10 09:56:26'), (17, 100005, 2, '2024-06-10 11:56:26', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:56:26', '2024-06-10 09:56:26'), (18, 100005, 2, '2024-06-10 11:56:56', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-10 09:56:56', '2024-06-10 09:56:56'), (19, 100008, 1, '2024-06-27 11:15:56', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:15:56', '2024-06-27 09:15:56'), (20, 100008, 1, '2024-06-27 11:15:57', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:15:57', '2024-06-27 09:15:57'), (21, 100008, 1, '2024-06-27 11:16:00', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:00', '2024-06-27 09:16:00'), (22, 100008, 1, '2024-06-27 11:16:03', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:03', '2024-06-27 09:16:03'), (23, 100008, 1, '2024-06-27 11:16:04', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:04', '2024-06-27 09:16:04'), (24, 100008, 1, '2024-06-27 11:16:04', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:04', '2024-06-27 09:16:04'), (25, 100009, 1, '2024-06-27 11:16:04', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:04', '2024-06-27 09:16:04'), (26, 100009, 1, '2024-06-27 11:16:06', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:06', '2024-06-27 09:16:06'), (27, 100009, 1, '2024-06-27 11:16:07', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:07', '2024-06-27 09:16:07'), (28, 100009, 1, '2024-06-27 11:16:07', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:07', '2024-06-27 09:16:07'), (29, 100009, 1, '2024-06-27 11:16:08', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:08', '2024-06-27 09:16:08'), (30, 100009, 1, '2024-06-27 11:16:09', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:09', '2024-06-27 09:16:09'), (31, 100009, 1, '2024-06-27 11:16:10', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:10', '2024-06-27 09:16:10'), (32, 100009, 1, '2024-06-27 11:16:13', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:13', '2024-06-27 09:16:13'), (33, 100009, 1, '2024-06-27 11:16:14', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:14', '2024-06-27 09:16:14'), (34, 100008, 1, '2024-06-27 11:16:15', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:15', '2024-06-27 09:16:15'), (35, 100009, 1, '2024-06-27 11:16:15', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:15', '2024-06-27 09:16:15'), (36, 100008, 1, '2024-06-27 11:16:24', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:24', '2024-06-27 09:16:24'), (37, 100008, 1, '2024-06-27 11:16:25', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:25', '2024-06-27 09:16:25'), (38, 100008, 1, '2024-06-27 11:16:25', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:25', '2024-06-27 09:16:25'), (39, 100008, 1, '2024-06-27 11:16:27', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:27', '2024-06-27 09:16:27'), (40, 100008, 1, '2024-06-27 11:16:29', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:29', '2024-06-27 09:16:29'), (41, 100008, 1, '2024-06-27 11:16:29', '72.8702647', '19.0687893', 'FC-7041/42, Konkan Division, IN', '2024-06-27 09:16:29', '2024-06-27 09:16:29'); -- -------------------------------------------------------- -- -- Table structure for table `delivery_men` -- CREATE TABLE `delivery_men` ( `id` bigint(20) UNSIGNED NOT NULL, `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` text DEFAULT NULL, `image` varchar(100) DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1, `password` varchar(100) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `auth_token` varchar(255) DEFAULT NULL, `fcm_token` varchar(255) DEFAULT NULL, `branch_id` bigint(20) NOT NULL DEFAULT 1, `application_status` varchar(255) NOT NULL DEFAULT 'approved' COMMENT 'pending, approved, denied', `login_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL, `language_code` varchar(255) NOT NULL DEFAULT 'en' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `delivery_men` -- INSERT INTO `delivery_men` (`id`, `f_name`, `l_name`, `phone`, `email`, `identity_number`, `identity_type`, `identity_image`, `image`, `is_active`, `password`, `created_at`, `updated_at`, `auth_token`, `fcm_token`, `branch_id`, `application_status`, `login_hit_count`, `is_temp_blocked`, `temp_block_time`, `language_code`) VALUES (1, 'Delivery', 'Demo', '+919876543211', 'delivery@demo.com', '123456', 'passport', '[\"2024-06-06-6662994e9b022.png\"]', '2024-06-06-6662994e98a53.png', 1, '$2y$10$F9s1DE5f0vHH6SxTvxQKTuDYSvGfz09bWSfi5qhhU0VIj9kWn1nLC', '2024-06-06 16:23:26', '2024-06-27 09:21:56', 'vtNfvYYYrgFYp9jvP2aHmNywqJ6jz1KryeZAwpJndHlGlRPiUtL7BG0nKc7mZxk5Eh7ZkVMXicZSStCQ9wpwgKKDnR5nN0kJvSagy3ACSWcsj85y0Ch9QFRT', 'dg9QwceZTDmEj6h6BF9xtU:APA91bHn0GV7Gid4IR5R3g6Cg05rPi07dLXLWY5J1yKGT8H43JazeB5WtwYX1YFn4oxmtSZ1vQJlBJXMIVvyazlJ1MtBwTg9VFIyUqzaj3OK9MhZeKRRfoEw13a1YuzXrMRKYTh86LSp', 0, 'approved', 0, 0, NULL, 'en'), (2, 'Driver', 'Demo', '+919876543212', 'driver@demo.com', '123456789', 'passport', '[\"2024-06-09-666697ffda6a8.png\"]', '2024-06-09-666697ffd785b.png', 1, '$2y$10$8UAKnTiD4BCQ8wm1JQbBkOlh5bYt9/rrKVniAnF7fYlr2XkAj3L1u', '2024-06-09 17:06:55', '2024-06-27 09:11:10', 'ZZdfWX58bf1kIEn9XcXGwxi2G9YKyt2DOIKnRZXYLyL5iDB2iyd5RGjNMPRQLAkyLQVYGXao7erJjgJKAzWtWBf6FkXBokbPEzezix70WtrKG3fvqdziN00A', 'dg9QwceZTDmEj6h6BF9xtU:APA91bHn0GV7Gid4IR5R3g6Cg05rPi07dLXLWY5J1yKGT8H43JazeB5WtwYX1YFn4oxmtSZ1vQJlBJXMIVvyazlJ1MtBwTg9VFIyUqzaj3OK9MhZeKRRfoEw13a1YuzXrMRKYTh86LSp', 10, 'approved', 0, 0, NULL, 'en'); -- -------------------------------------------------------- -- -- Table structure for table `d_m_reviews` -- CREATE TABLE `d_m_reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `delivery_man_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `order_id` bigint(20) NOT NULL, `comment` mediumtext DEFAULT NULL, `attachment` varchar(255) DEFAULT NULL, `rating` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_verifications` -- CREATE TABLE `email_verifications` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(255) DEFAULT NULL, `token` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED 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() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `favorite_products` -- CREATE TABLE `favorite_products` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `product_id` bigint(20) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `flash_deals` -- CREATE TABLE `flash_deals` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `deal_type` varchar(255) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 0, `featured` tinyint(4) NOT NULL DEFAULT 0, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `flash_deal_products` -- CREATE TABLE `flash_deal_products` ( `id` bigint(20) UNSIGNED NOT NULL, `flash_deal_id` bigint(20) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `discount` double(8,2) NOT NULL DEFAULT 0.00, `discount_type` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `guest_users` -- CREATE TABLE `guest_users` ( `id` bigint(20) UNSIGNED NOT NULL, `ip_address` varchar(255) DEFAULT NULL, `fcm_token` varchar(255) DEFAULT NULL, `language_code` varchar(255) NOT NULL DEFAULT 'en', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `guest_users` -- INSERT INTO `guest_users` (`id`, `ip_address`, `fcm_token`, `language_code`, `created_at`, `updated_at`) VALUES (1, '106.219.120.195', 'eefBTHY0RZy9uelM7o6ckZ:APA91bHbIiJqbsjFfPgM8Sncpe0SMDB3zbzOLGmMw_O10J8kEhoEZQ-hegkp4H68--tIrjvquXioR8oFOR7_hTasoghpE102X6fV_V3RejJEeuK80oo4qrc1gMzTeFZnC4aS-at86Qwc', 'en', '2024-06-09 15:19:31', '2024-06-09 15:19:31'), (2, '152.59.174.146', '@', 'en', '2024-06-09 16:07:10', '2024-06-09 16:23:01'), (3, '202.8.119.31', 'cHuzINwz40jacK8M3qymaq:APA91bEue3Xo3MTFOXpJYVl2ieirT95hpfXuBlAzpw7NueNmX3t-HMimyrV9szkWpKvgzb7JasEoQbhh0qp2Dtwv76qx8Bhu39caqa-7IG4-dqrOxge2JfPyY7lqV7IknPv9t4z2nljM', 'en', '2024-06-10 10:08:37', '2024-06-10 10:08:37'), (4, '152.59.174.146', '@', 'en', '2024-06-10 10:12:15', '2024-06-10 10:12:15'), (5, '106.219.120.195', '@', 'en', '2024-06-10 10:12:40', '2024-06-10 10:12:40'), (6, '45.141.152.77', '@', 'en', '2024-06-10 12:04:38', '2024-06-10 12:04:38'), (7, '80.82.70.198', '@', 'en', '2024-06-10 12:05:23', '2024-06-10 12:05:23'), (8, '89.248.171.23', '@', 'en', '2024-06-10 12:07:39', '2024-06-10 12:07:39'), (9, '80.255.7.108', '@', 'en', '2024-06-12 05:50:46', '2024-06-12 05:50:46'), (10, '63.246.149.170', '@', 'en', '2024-06-12 05:52:43', '2024-06-12 05:52:43'), (11, '76.31.75.8', '@', 'en', '2024-06-12 05:53:08', '2024-06-12 05:53:08'), (12, '146.190.13.187', '@', 'en', '2024-06-12 06:08:19', '2024-06-12 06:08:19'), (13, '116.206.228.181', '@', 'en', '2024-06-12 06:20:44', '2024-06-12 06:20:44'), (14, '122.161.51.58', '@', 'en', '2024-06-12 08:19:30', '2024-06-12 08:19:30'), (15, '106.219.120.185', NULL, 'en', '2024-06-20 08:39:41', '2024-06-20 08:41:49'), (16, '64.233.172.165', '@', 'en', '2024-06-20 09:34:26', '2024-06-20 09:34:26'), (17, '74.125.210.6', '@', 'en', '2024-06-20 09:35:08', '2024-06-20 09:35:08'), (18, '66.249.88.227', '@', 'en', '2024-06-20 09:37:28', '2024-06-20 09:37:28'), (19, '70.32.128.53', 'c2jqPewfTTm3gewo1Ok_dP:APA91bGbX9To47nNgM0FiqFa0D-4A77CDEOvOUsg8Fi886ubr6Sh4cgViDKfujByz-MlZNFgoMBKY17lq-MqAcQnRIumyQctg5pvaFy_VQjwidrv0_4ehEysfvzRVxZKTcJb0u3kF9MI', 'en', '2024-06-20 13:26:37', '2024-06-20 13:26:37'), (20, '74.125.215.3', '@', 'en', '2024-06-20 14:45:22', '2024-06-20 14:45:22'), (21, '66.249.88.227', '@', 'en', '2024-06-20 17:06:32', '2024-06-20 17:06:32'), (22, '34.218.159.145', '@', 'en', '2024-06-21 08:17:24', '2024-06-21 08:17:24'), (23, '103.237.158.231', '@', 'en', '2024-06-21 14:40:13', '2024-06-21 14:40:13'), (24, '103.87.65.76', 'dbg9BkwYa9rsABsHeIAiAZ:APA91bFCXM97I1URwacBbYwbRKqVOmxoaoi4PFYspddU1bxmganzHkiE-FfLXKcObKCANLi4UFm_fWRjgZQHaXej5G6245Fd55ipM9jRVqKgXn5Uiheopwgl1mkz8coWg5VY3UwnKth0', 'en', '2024-06-21 19:42:43', '2024-06-21 19:42:43'), (25, '103.87.65.76', 'dbg9BkwYa9rsABsHeIAiAZ:APA91bED8EDvW6w8Un-wCHDY2VnemKpn_acdoYKyPmWZWlM1LUKKgZY6k7ZZMPIgp4A66PCoEAjhK5qmHdcLfnsbvrhHx0Bk8AMwGEkL5_FaLYU2bt0E4tHtdbRH8-Yuv45b83V6gIQL', 'en', '2024-06-21 19:42:44', '2024-06-21 19:42:44'), (26, '74.125.210.6', '@', 'en', '2024-06-22 15:18:18', '2024-06-22 15:18:18'), (27, '103.87.65.76', 'dg7T8onkbG5QLSabsdErzt:APA91bE0jMz65LjVmHBEPY4ZsrgtV5tBwDanE01L3Ir0g-y7ZW06bkMx7eRhYM68a7R2aRVdcyifezv2bw-RUiOWY3ynqR6zWecUcdhCFk5SJ2JVtUvxyEZhIKd6Z-Spxs9OonAtyNty', 'en', '2024-06-22 20:49:30', '2024-06-22 20:49:30'), (28, '66.249.88.226', '@', 'en', '2024-06-23 03:27:40', '2024-06-23 03:27:40'), (29, '74.125.215.41', '@', 'en', '2024-06-23 03:46:59', '2024-06-23 03:46:59'), (30, '45.133.180.130', 'fvcWvd7EQiKWGbXGXVRep6:APA91bHvnTi-ZJuZ1hTLBcOREOC7C7If32ksVC6AC88FuPA40nGdD3_FuwS8VzgbM50ext-XpyAZTcZcvWbZS3BakkDm3LFVZfLuJfy9iWxsC72q4bDMoTykQTqizigYRLgqpmH6ZX2e', 'en', '2024-06-23 09:40:20', '2024-06-23 09:40:20'), (31, '34.69.234.68', 'dwZJ3ZEjQaGO6tISIauEfo:APA91bE5WldrfdGRo7rYZPvcFKWAQPDVhyi6-E0tq7l05CEIZhFJq1T9FbfOaENYLAzywe_vuWyGFANSz2KSEGbDhUavRtP0fXMS5rrOd-6I7k5nKQ2zGG_yo-klBIL9mCEzLMWCyOuz', 'en', '2024-06-24 06:28:34', '2024-06-24 06:28:34'), (32, '34.74.10.76', 'dl_4QIZwThCdRWhpeFI7F9:APA91bHY2Wktfw8gicRHAmNmWa6n09rn7_FYZjNUqVtKoSQ1NUuKvs8FUz5YNUoc8rT1dI4gRnAjtg4bXZiyL0LLJ2crzev8rf0LyCNJMSVwSXxNzxc18-2eGRoITeSXI4TVVd6gyQAJ', 'en', '2024-06-24 06:28:37', '2024-06-24 06:28:37'), (33, '152.58.156.145', '@', 'en', '2024-06-27 08:01:37', '2024-06-27 08:01:37'), (34, '49.36.144.41', '@', 'en', '2024-06-27 08:08:37', '2024-06-27 08:08:37'), (35, '106.219.121.98', '@', 'en', '2024-06-27 09:08:51', '2024-06-27 09:08:51'), (36, '152.58.156.145', '@', 'en', '2024-06-27 09:09:18', '2024-06-27 09:09:18'), (37, '106.219.121.98', 'f4bzqPEtRxqf5bk--P2VAc:APA91bGwi8t5BiO-bc3hHGLuzvVyJPYLFYve1dLIQ8xn0Ds3U7RUFdB-bDCl5oNIS2WkTNni_GGV_ZwybPX3jPBm9O6ir--pXp1PW5zPc7aFAwg7DYU6zDXwI43EtIIiPpYI9FLi0fjX', 'en', '2024-06-27 09:10:55', '2024-06-27 09:10:55'); -- -------------------------------------------------------- -- -- Table structure for table `loyalty_transactions` -- CREATE TABLE `loyalty_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `transaction_id` varchar(255) DEFAULT NULL, `credit` decimal(24,2) NOT NULL DEFAULT 0.00, `debit` decimal(24,2) NOT NULL DEFAULT 0.00, `balance` decimal(24,2) NOT NULL DEFAULT 0.00, `transaction_type` varchar(191) DEFAULT NULL, `reference` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loyalty_transactions` -- INSERT INTO `loyalty_transactions` (`id`, `user_id`, `transaction_id`, `credit`, `debit`, `balance`, `transaction_type`, `reference`, `created_at`, `updated_at`) VALUES (1, 1, 'gFbwJkDht3KkyZ2MUZGvykFRDjWCkE', 7.00, 0.00, 7.00, 'order_place', '100006', '2024-06-10 09:52:56', '2024-06-10 09:52:56'), (2, 1, 'tgsFffyq6w23U6T45kZvTEFJ1gPK3v', 4.00, 0.00, 11.00, 'order_place', '100005', '2024-06-10 09:56:25', '2024-06-10 09:56:25'), (3, 1, 'fO9OTCa6relRYNmehihkGbu9wqQXUL', 5.00, 0.00, 16.00, 'order_place', '100009', '2024-06-27 09:16:13', '2024-06-27 09:16:13'), (4, 2, 'zlMERbSocQCLB5UG01QKZL4Qc2Sw0D', 9.00, 0.00, 9.00, 'order_place', '100008', '2024-06-27 09:16:27', '2024-06-27 09:16:27'); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `id` bigint(20) UNSIGNED NOT NULL, `conversation_id` bigint(20) NOT NULL, `customer_id` bigint(20) DEFAULT NULL, `deliveryman_id` bigint(20) DEFAULT NULL, `message` text DEFAULT NULL, `attachment` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`id`, `conversation_id`, `customer_id`, `deliveryman_id`, `message`, `attachment`, `created_at`, `updated_at`) VALUES (1, 1, NULL, 2, 'Hey', 'null', '2024-06-10 09:52:10', '2024-06-10 09:52:10'), (2, 1, 1, NULL, 'Hi', 'null', '2024-06-10 09:52:32', '2024-06-10 09:52:32'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '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), (23, '2016_06_01_000001_create_oauth_auth_codes_table', 17), (24, '2016_06_01_000002_create_oauth_access_tokens_table', 17), (25, '2016_06_01_000003_create_oauth_refresh_tokens_table', 17), (26, '2016_06_01_000004_create_oauth_clients_table', 17), (27, '2016_06_01_000005_create_oauth_personal_access_clients_table', 17), (68, '2021_03_07_065637_change_product_image_clumn_type', 42), (69, '2021_03_11_061437_add_unit_column_to_products', 43), (70, '2021_03_11_070016_add_unit_to_order_details', 43), (71, '2021_04_04_153448_add_column_to_product_table', 44), (72, '2021_04_05_071507_add_stock_info_in_order_details', 44), (73, '2021_04_07_145217_update_product_price_column', 45), (74, '2021_01_10_145134_create_time_slots_table', 46), (75, '2021_03_22_164017_add_time_slot_id_to_orders_table', 46), (76, '2021_03_24_154346_add_date_to_orders_table', 46), (77, '2021_03_24_161320_add_date_to_time_slots_table', 46), (78, '2021_03_27_100851_add_delivery_date_to_orders_table', 46), (79, '2021_04_08_093406_add_capacity_to_products', 46), (80, '2021_04_15_184101_add_delivery_date_and_time_to_order_details', 46), (81, '2021_04_21_081459_add_stock_to_products', 46), (82, '2021_04_21_094959_add_stock_info_to_order_details', 46), (83, '2021_05_03_160034_add_callback_to_order', 47), (84, '2021_06_17_054551_create_soft_credentials_table', 48), (85, '2021_07_01_160828_add_col_daily_needs_products', 49), (86, '2021_07_26_170256_change_price_col_type', 50), (87, '2021_09_01_133521_create_phone_verifications_table', 51), (88, '2021_09_01_134803_create_translations_table', 51), (89, '2021_09_04_082220_rename_email_col', 51), (90, '2021_10_12_104445_add_temporary_token_to_users_table', 52), (91, '2021_11_06_113028_add_extra_discount_to_order_table', 53), (92, '2022_02_17_101623_change_conversaton_table_column_and_type', 54), (93, '2022_02_17_112013_create_dc_conversations_table', 54), (94, '2022_02_17_112101_create_messages_table', 54), (95, '2022_02_17_125728_add_fcm_token_to_admin_table', 54), (96, '2022_02_22_093732_create_social_media_table', 54), (97, '2022_02_22_103038_change_banner_title_length', 54), (98, '2022_02_22_130430_create_newsletters_table', 54), (99, '2022_02_24_085940_change_name_length_in_category_table', 54), (100, '2022_02_24_095937_change_name_length_in_attribute_table', 54), (101, '2022_02_26_150826_add_delivery_address_to_order_table', 54), (102, '2022_02_27_104337_add_image_to_branch_table', 54), (103, '2022_05_30_033052_create_favorite_products_table', 55), (104, '2022_06_06_161829_create_admin_roles_table', 55), (105, '2022_06_06_162546_add_two_column_to_admins_table', 55), (106, '2022_06_09_095348_add_popularity_count_to_products_table', 55), (107, '2022_10_27_002321_add_is_active_column_in_attributes_table', 56), (108, '2022_10_28_214644_add_is_active_column_to_reviews_table', 56), (109, '2022_10_29_194703_add_multiple_column_for_identity_in_admins_table', 56), (110, '2022_10_29_224609_add_column_is_active_in_delivery_men_table', 56), (111, '2022_10_30_190953_add_column_is_visible_in_products_table', 56), (112, '2022_11_05_043305_add_phone_to_branches_table', 56), (113, '2022_11_05_045429_add_column_is_block_to_users_table', 56), (114, '2022_11_07_064201_add_multiple_column_in_customer_addresses_table', 56), (115, '2022_11_29_160650_delete_is_active_from_attributes_table', 56), (116, '2022_11_29_165014_delete_is_visible_from_products_table', 56), (117, '2022_12_04_212159_add_login_medium_column_in_users_tables', 56), (118, '2023_02_16_170841_add_multiple_column_to_users_table', 57), (119, '2023_02_16_183440_create_wallet_transction_table', 57), (120, '2023_02_18_111449_create_loyalty_transaction_table', 57), (121, '2023_02_19_104242_create_tags_table', 57), (122, '2023_02_19_104317_create_product_tag_table', 57), (123, '2023_02_20_155814_add_customer_id_in_coupons_table', 57), (124, '2023_02_22_160007_add_column_for_offline_payment_in_orders_table', 57), (125, '2023_02_22_173354_create_table_flash_deals', 57), (126, '2023_02_22_200523_create_recent_searches_table', 57), (127, '2023_02_22_200535_create_searched_data_table', 57), (128, '2023_02_23_095712_create_table_flashdeal_products', 57), (129, '2023_02_23_150149_add_is_featured_in_products_table', 57), (130, '2023_02_26_144956_add_maximum_order_quantity_in_products_table', 57), (131, '2023_02_26_152222_create_category_discounts_table', 57), (132, '2023_02_26_184816_create_visited_products_table', 57), (133, '2023_03_11_104833_add_free_delivery_amount_to_orders_table', 57), (134, '2023_03_18_160336_create_searched_keyword_counts_table', 57), (135, '2023_03_18_160753_create_searched_category_table', 57), (136, '2023_03_18_160953_create_searched_products_table', 57), (137, '2023_03_19_130859_create_searched_keyword_users_table', 57), (138, '2023_03_20_104722_create_category_searched_by_user_table', 57), (139, '2023_03_20_110808_create_product_searched_by_user_table', 57), (140, '2023_03_21_183551_add_vat_status_column_in_order_details_table', 57), (141, '2023_05_15_041430_add_application_status_in_delivery_men_table', 58), (142, '2023_05_15_153550_add_otp_hist_counts_column_in_phone_verification_tabel', 58), (143, '2023_05_15_175430_add_otp_hits_counts_column_in_password_resets', 58), (144, '2023_05_16_000027_add_otp_hits_counts_column_in_email_verifications', 58), (145, '2023_05_17_121506_add_login_hit_count_in_users', 58), (146, '2023_05_17_145621_change_column_type_in_delivery_men', 58), (147, '2023_05_17_152928_add_login_hit_count_in_delivery_men', 58), (148, '2023_09_09_111646_create_guest_users_table', 59), (149, '2023_09_09_125334_add_guest_id_in_customer_addressess_table', 59), (150, '2023_09_09_150348_add_guest_id_in_orders_table', 59), (151, '2023_09_11_122854_create_wallet_bonuses_table', 59), (152, '2023_09_12_123515_add_priority_column_in_category_table', 59), (153, '2023_09_17_111956_create_offline_payment_methods_table', 59), (154, '2023_09_17_171307_add_language_code_to_users', 59), (155, '2023_09_17_180404_add_language_code_to_delivery_men', 59), (156, '2023_09_18_114716_create_offline_payments_table', 59), (157, '2023_09_18_115108_create_order_partial_payments_table', 59), (158, '2023_09_26_160347_create_register_devices_table', 59), (159, '2024_03_10_180329_create_order_images_table', 60); -- -------------------------------------------------------- -- -- Table structure for table `newsletters` -- CREATE TABLE `newsletters` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(100) DEFAULT NULL, `description` varchar(255) 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_access_tokens` -- 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(255) 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `oauth_access_tokens` -- INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES ('0b4cad1a2f4e82d56f334638762f0bc4d8550f4a11ae71612ac93371d8f4111033af7c92547f99c4', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-20 08:40:14', '2024-06-20 08:40:14', '2025-06-20 10:40:14'), ('1b56898e9fdf0db0f68cece41cf78ddad7aad8c894c1d94ae4b7a2c3a4457e0de03810a529451b42', 2, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 08:12:33', '2024-06-27 08:12:33', '2025-06-27 10:12:33'), ('2bdbef20723c306ef49e4d442f07562ed60f4d012698fc9577a2c3ed36d98802ff1156eeb225c0d8', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 09:11:27', '2024-06-27 09:11:27', '2025-06-27 11:11:27'), ('46a1bfab23e1bca39062595e2abe044f877b40061202e1e8a278541ed5847210c9da298c88ae8715', 2, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 08:12:31', '2024-06-27 08:12:31', '2025-06-27 10:12:31'), ('62fb771239016b172e0c27b33ac6c545fd6f7a36935e4a58977f9290f48443a9dec0d4d3edb43538', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 13:58:58', '2024-06-27 13:58:58', '2025-06-27 15:58:58'), ('b5f5a8ac3bcd42c73958b90bffb0f21d7170b04bceae8fce8ca11744b69db816f39243987b32793e', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 09:09:20', '2024-06-27 09:09:20', '2025-06-27 11:09:20'), ('b97157278960b3eeb8cdc43e94edc80daa23ee647f9041ec6a98c4b9ba552a173f78221bfbdd177e', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-09 15:20:59', '2024-06-09 15:20:59', '2025-06-09 17:20:59'), ('cb624574056e52ab79b929314569c1b44882d0dbbe6544996cb0fa12871e66d5df646460922a189a', 2, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-27 09:09:34', '2024-06-27 09:09:34', '2025-06-27 11:09:34'), ('da76112506349507ce208b2f431eaea4eda4ed48c3111f9e41b8b79d413a37871a615f64af611287', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-10 10:18:02', '2024-06-10 10:18:02', '2025-06-10 12:18:02'), ('f3e8acd32ef4886972aceeab3120b08184a5f0c67fdb6b1725e6dda04b2041e7f5f0aa9fc5c52117', 1, 3, 'RestaurantCustomerAuth', '[]', 0, '2024-06-09 15:21:00', '2024-06-09 15:21:00', '2025-06-09 17:21:00'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_auth_codes` -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_clients` -- CREATE TABLE `oauth_clients` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `name` varchar(255) NOT NULL, `secret` varchar(100) DEFAULT NULL, `provider` varchar(255) 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `oauth_clients` -- INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1, NULL, 'Laravel Personal Access Client', 'z5ky1aF18fNgAczYo0W2MdglqUxpyt0KsKdmbRIt', NULL, 'http://localhost', 1, 0, 0, '2021-01-05 18:07:29', '2021-01-05 18:07:29'), (2, NULL, 'Laravel Password Grant Client', 'clk5DEe0ANVDYwD79OUYBkLcZ6CLSykUvULubUuk', 'users', 'http://localhost', 0, 1, 0, '2021-01-05 18:07:29', '2021-01-05 18:07:29'), (3, NULL, 'Laravel Personal Access Client', 'v89pXMpj0Pv49vFb3vC0uqTZvTRPEGtso4wpvkab', NULL, 'http://localhost', 1, 0, 0, '2021-06-19 03:35:33', '2021-06-19 03:35:33'), (4, NULL, 'Laravel Password Grant Client', '07Q6Fu6riULXZnYy1yd8lApmsn45TrZZyZKPxW3T', 'users', 'http://localhost', 0, 1, 0, '2021-06-19 03:35:33', '2021-06-19 03:35:33'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_personal_access_clients` -- CREATE TABLE `oauth_personal_access_clients` ( `id` bigint(20) UNSIGNED NOT NULL, `client_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `oauth_personal_access_clients` -- INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1, 1, '2021-01-05 18:07:29', '2021-01-05 18:07:29'), (2, 3, '2021-06-19 03:35:33', '2021-06-19 03:35:33'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_refresh_tokens` -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `offline_payments` -- CREATE TABLE `offline_payments` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) NOT NULL, `payment_info` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `offline_payment_methods` -- CREATE TABLE `offline_payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `method_name` varchar(255) NOT NULL, `method_fields` text NOT NULL, `payment_note` varchar(255) DEFAULT NULL, `method_informations` text NOT NULL, `status` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `is_guest` tinyint(4) NOT NULL DEFAULT 0, `order_amount` decimal(8,2) NOT NULL DEFAULT 0.00, `coupon_discount_amount` decimal(8,2) NOT NULL DEFAULT 0.00, `coupon_discount_title` varchar(255) DEFAULT NULL, `payment_status` varchar(255) NOT NULL DEFAULT 'unpaid', `order_status` varchar(255) NOT NULL DEFAULT 'pending', `total_tax_amount` decimal(8,2) NOT NULL DEFAULT 0.00, `payment_method` varchar(30) DEFAULT NULL, `transaction_reference` varchar(30) DEFAULT NULL, `delivery_address_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `checked` tinyint(1) NOT NULL DEFAULT 0, `delivery_man_id` bigint(20) DEFAULT NULL, `delivery_charge` decimal(8,2) NOT NULL DEFAULT 0.00, `order_note` text DEFAULT NULL, `coupon_code` varchar(255) DEFAULT NULL, `order_type` varchar(255) NOT NULL DEFAULT 'delivery', `branch_id` bigint(20) NOT NULL DEFAULT 1, `time_slot_id` bigint(20) DEFAULT NULL, `date` date DEFAULT NULL, `delivery_date` date DEFAULT NULL, `callback` varchar(255) DEFAULT NULL, `extra_discount` decimal(8,2) NOT NULL DEFAULT 0.00, `delivery_address` text DEFAULT NULL, `payment_by` varchar(255) DEFAULT NULL, `payment_note` varchar(255) DEFAULT NULL, `free_delivery_amount` double(8,2) NOT NULL DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `user_id`, `is_guest`, `order_amount`, `coupon_discount_amount`, `coupon_discount_title`, `payment_status`, `order_status`, `total_tax_amount`, `payment_method`, `transaction_reference`, `delivery_address_id`, `created_at`, `updated_at`, `checked`, `delivery_man_id`, `delivery_charge`, `order_note`, `coupon_code`, `order_type`, `branch_id`, `time_slot_id`, `date`, `delivery_date`, `callback`, `extra_discount`, `delivery_address`, `payment_by`, `payment_note`, `free_delivery_amount`) VALUES (100001, 1, 0, 110.00, 0.00, NULL, 'unpaid', 'pending', 1.60, 'cash_on_delivery', NULL, 1, '2024-06-09 16:56:16', '2024-06-09 16:56:32', 1, NULL, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-09', '2024-06-10', NULL, 0.00, '{\"id\":1,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"FC-7041\\/42, Bandra Kurla Complex Rd, G Block BKC, Bandra Kurla Complex, Bandra East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.068789261357825\",\"longitude\":\"72.87026457488537\",\"created_at\":\"2024-06-10T05:54:54.000000Z\",\"updated_at\":\"2024-06-10T05:54:54.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100002, 1, 0, 120.00, 0.00, NULL, 'unpaid', 'pending', 0.00, 'cash_on_delivery', NULL, 1, '2024-06-09 16:59:26', '2024-06-09 16:59:29', 1, NULL, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-09', '2024-06-10', NULL, 0.00, '{\"id\":1,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"FC-7041\\/42, Bandra Kurla Complex Rd, G Block BKC, Bandra Kurla Complex, Bandra East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.068789261357825\",\"longitude\":\"72.87026457488537\",\"created_at\":\"2024-06-10T05:54:54.000000Z\",\"updated_at\":\"2024-06-10T05:54:54.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100003, 1, 0, 180.00, 0.00, NULL, 'unpaid', 'pending', 0.00, 'cash_on_delivery', NULL, 2, '2024-06-09 17:01:56', '2024-06-09 17:02:07', 1, NULL, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-09', '2024-06-10', NULL, 0.00, '{\"id\":2,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.069028504472136\",\"longitude\":\"72.86648668348789\",\"created_at\":\"2024-06-10T06:01:41.000000Z\",\"updated_at\":\"2024-06-10T06:01:41.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100004, 1, 0, 140.00, 0.00, NULL, 'unpaid', 'pending', 0.00, 'cash_on_delivery', NULL, 2, '2024-06-09 17:08:39', '2024-06-09 17:08:56', 1, NULL, 30.00, NULL, NULL, 'delivery', 1, 1, '2024-06-09', '2024-06-10', NULL, 0.00, '{\"id\":2,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.069028504472136\",\"longitude\":\"72.86648668348789\",\"created_at\":\"2024-06-10T06:01:41.000000Z\",\"updated_at\":\"2024-06-10T06:01:41.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100005, 1, 0, 90.60, 0.00, NULL, 'paid', 'delivered', 1.20, 'cash_on_delivery', NULL, 1, '2024-06-10 09:44:54', '2024-06-10 09:56:25', 1, 2, 30.00, NULL, NULL, 'delivery', 10, 3, '2024-06-10', '2024-06-10', NULL, 0.00, '{\"id\":1,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"FC-7041\\/42, Bandra Kurla Complex Rd, G Block BKC, Bandra Kurla Complex, Bandra East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.068789261357825\",\"longitude\":\"72.87026457488537\",\"created_at\":\"2024-06-09T13:24:54.000000Z\",\"updated_at\":\"2024-06-09T13:24:54.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100006, 1, 0, 151.20, 0.00, NULL, 'paid', 'delivered', 2.40, 'cash_on_delivery', NULL, 2, '2024-06-10 09:46:51', '2024-06-10 09:52:58', 1, 2, 30.00, NULL, NULL, 'delivery', 10, 3, '2024-06-10', '2024-06-10', NULL, 0.00, '{\"id\":2,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.069028504472136\",\"longitude\":\"72.86648668348789\",\"created_at\":\"2024-06-09T13:31:41.000000Z\",\"updated_at\":\"2024-06-09T13:31:41.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100007, 1, 0, 126.00, 0.00, NULL, 'unpaid', 'pending', 0.00, 'cash_on_delivery', NULL, 2, '2024-06-10 09:51:46', '2024-06-10 09:52:11', 1, NULL, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-10', '2024-06-10', NULL, 0.00, '{\"id\":2,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.069028504472136\",\"longitude\":\"72.86648668348789\",\"created_at\":\"2024-06-09T13:31:41.000000Z\",\"updated_at\":\"2024-06-09T13:31:41.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00), (100008, 2, 0, 191.60, 0.00, NULL, 'paid', 'delivered', 3.20, 'cash_on_delivery', NULL, 3, '2024-06-27 09:13:15', '2024-06-27 09:16:28', 1, 1, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-27', '2024-06-27', NULL, 0.00, '{\"id\":3,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543211\",\"address\":\"BKC Kurla, Taximens Colony Road, Ram Manohar Lohiya Nagar, Kurla West, Kurla, Mumbai, Maharashtra, India\",\"latitude\":\"19.067043300000016\",\"longitude\":\"72.87116449999999\",\"created_at\":\"2024-06-27T05:42:56.000000Z\",\"updated_at\":\"2024-06-27T05:42:56.000000Z\",\"user_id\":2,\"is_guest\":0,\"contact_person_name\":\"User Demo 2\",\"road\":\"11\",\"house\":\"2\",\"floor\":\"2\"}', NULL, NULL, 0.00), (100009, 1, 0, 110.00, 0.00, NULL, 'paid', 'delivered', 1.60, 'cash_on_delivery', NULL, 2, '2024-06-27 09:14:54', '2024-06-27 09:16:14', 1, 1, 30.00, NULL, NULL, 'delivery', 1, 3, '2024-06-27', '2024-06-27', NULL, 0.00, '{\"id\":2,\"address_type\":\"Home\",\"contact_person_number\":\"+919876543210\",\"address\":\"MMRDA Bulding Mumbai, Kanzul Iman Rd, Kolivery Village, MMRDA Area, Bandra Kurla Complex, Santacruz East, Mumbai, Maharashtra 400051, India\",\"latitude\":\"19.069028504472136\",\"longitude\":\"72.86648668348789\",\"created_at\":\"2024-06-09T13:31:41.000000Z\",\"updated_at\":\"2024-06-09T13:31:41.000000Z\",\"user_id\":1,\"is_guest\":0,\"contact_person_name\":\"User Demo\",\"road\":null,\"house\":null,\"floor\":null}', NULL, NULL, 0.00); -- -------------------------------------------------------- -- -- Table structure for table `order_delivery_histories` -- CREATE TABLE `order_delivery_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) DEFAULT NULL, `delivery_man_id` bigint(20) DEFAULT NULL, `start_time` datetime DEFAULT NULL, `end_time` datetime DEFAULT NULL, `start_location` varchar(255) DEFAULT NULL, `end_location` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE `order_details` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) DEFAULT NULL, `order_id` bigint(20) DEFAULT NULL, `price` decimal(8,2) NOT NULL DEFAULT 0.00, `product_details` text DEFAULT NULL, `variation` varchar(255) DEFAULT NULL, `discount_on_product` decimal(8,2) DEFAULT NULL, `discount_type` varchar(20) NOT NULL DEFAULT 'amount', `quantity` int(11) NOT NULL DEFAULT 1, `tax_amount` decimal(8,2) NOT NULL DEFAULT 1.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `variant` varchar(255) DEFAULT NULL, `unit` varchar(255) NOT NULL DEFAULT 'pc', `is_stock_decreased` tinyint(1) NOT NULL DEFAULT 1, `time_slot_id` bigint(20) DEFAULT NULL, `delivery_date` date DEFAULT NULL, `vat_status` varchar(255) NOT NULL DEFAULT 'excluded' COMMENT 'included/excluded' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_details` -- INSERT INTO `order_details` (`id`, `product_id`, `order_id`, `price`, `product_details`, `variation`, `discount_on_product`, `discount_type`, `quantity`, `tax_amount`, `created_at`, `updated_at`, `variant`, `unit`, `is_stock_decreased`, `time_slot_id`, `delivery_date`, `vat_status`) VALUES (1, 2, 100001, 40.00, '{\"id\":2,\"name\":\"Modern Sandwich Bread\",\"description\":\"

Description of Modern Sandwhich Bread<\\/p>\",\"image\":\"[\\\"2024-06-06-6662d08bb0487.png\\\"]\",\"price\":40,\"variations\":\"[]\",\"tax\":2,\"status\":1,\"created_at\":\"2024-06-07T09:19:07.000000Z\",\"updated_at\":\"2024-06-10T05:52:54.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"3\\\",\\\"position\\\":1},{\\\"id\\\":\\\"13\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":2,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"gm\",\"total_stock\":100,\"capacity\":1,\"daily_needs\":0,\"popularity_count\":0,\"is_featured\":1,\"view_count\":1,\"maximum_order_quantity\":5,\"translations\":[]}', '[{\"type\":null}]', 0.80, 'discount_on_product', 2, 0.80, '2024-06-09 16:56:16', '2024-06-09 16:56:16', 'null', 'gm', 1, 3, '2024-06-10', 'excluded'), (2, 3, 100002, 30.00, '{\"id\":3,\"name\":\"Amul Taaza Toned Fresh Milk\",\"description\":\"

Descriptio of  <\\/p>

Amul Taaza Toned Fresh Milk<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d0e495f59.png\\\"]\",\"price\":30,\"variations\":\"[]\",\"tax\":0,\"status\":1,\"created_at\":\"2024-06-07T09:20:36.000000Z\",\"updated_at\":\"2024-06-10T05:58:11.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"3\\\",\\\"position\\\":1},{\\\"id\\\":\\\"14\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":0,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"ml\",\"total_stock\":100,\"capacity\":1,\"daily_needs\":1,\"popularity_count\":0,\"is_featured\":0,\"view_count\":1,\"maximum_order_quantity\":5,\"translations\":[]}', '[{\"type\":null}]', 0.00, 'discount_on_category', 3, 0.00, '2024-06-09 16:59:26', '2024-06-09 16:59:26', 'null', 'ml', 1, 3, '2024-06-10', 'excluded'), (3, 4, 100003, 150.00, '{\"id\":4,\"name\":\"Potato\",\"description\":\"

Description of <\\/p>

Potato<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d14e0291b.png\\\"]\",\"price\":150,\"variations\":\"[]\",\"tax\":0,\"status\":1,\"created_at\":\"2024-06-07T09:22:22.000000Z\",\"updated_at\":\"2024-06-10T06:00:33.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"4\\\",\\\"position\\\":1},{\\\"id\\\":\\\"16\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":0,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"kg\",\"total_stock\":100,\"capacity\":1,\"daily_needs\":1,\"popularity_count\":0,\"is_featured\":0,\"view_count\":1,\"maximum_order_quantity\":5,\"translations\":[]}', '[{\"type\":null}]', 0.00, 'discount_on_category', 1, 0.00, '2024-06-09 17:01:56', '2024-06-09 17:01:56', 'null', 'kg', 1, 3, '2024-06-10', 'excluded'), (4, 13, 100004, 110.00, '{\"id\":13,\"name\":\"Maggi Masala - 2 Minutes Instant Noodles\",\"description\":\"

Description of <\\/p>

Maggi Masala - 2 Minutes Instant Noodles<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d52ff3116.png\\\"]\",\"price\":110,\"variations\":\"[]\",\"tax\":0,\"status\":1,\"created_at\":\"2024-06-07T09:38:56.000000Z\",\"updated_at\":\"2024-06-10T06:07:52.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"8\\\",\\\"position\\\":1},{\\\"id\\\":\\\"24\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":0,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"gm\",\"total_stock\":100,\"capacity\":280,\"daily_needs\":0,\"popularity_count\":0,\"is_featured\":1,\"view_count\":1,\"maximum_order_quantity\":5,\"translations\":[]}', '[{\"type\":null}]', 0.00, 'discount_on_category', 1, 0.00, '2024-06-09 17:08:39', '2024-06-09 17:08:39', 'null', 'gm', 1, 1, '2024-06-10', 'excluded'), (5, 16, 100005, 10.00, '{\"id\":16,\"name\":\"Cadbury Gems Duo Pack Chocolate\",\"description\":\"

Description of <\\/p>

Cadbury Gems Duo Pack Chocolate<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d6a25152f.png\\\"]\",\"price\":10,\"variations\":\"[]\",\"tax\":2,\"status\":1,\"created_at\":\"2024-06-06T17:15:06.000000Z\",\"updated_at\":\"2024-06-10T06:14:14.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"9\\\",\\\"position\\\":1},{\\\"id\\\":\\\"27\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":1,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"gm\",\"total_stock\":100,\"capacity\":20,\"daily_needs\":0,\"popularity_count\":0,\"is_featured\":1,\"view_count\":1,\"maximum_order_quantity\":10,\"translations\":[]}', '[{\"type\":null}]', 0.10, 'discount_on_product', 6, 0.20, '2024-06-10 09:44:54', '2024-06-10 09:44:54', 'null', 'gm', 1, 3, '2024-06-10', 'excluded'), (6, 10, 100006, 40.00, '{\"id\":10,\"name\":\"paper boat Swing Lush Lychee Juice\",\"description\":\"

Description of <\\/p>

paper boat Swing Lush Lychee Juice<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d3ecef91c.png\\\"]\",\"price\":40,\"variations\":\"[]\",\"tax\":2,\"status\":1,\"created_at\":\"2024-06-06T17:03:32.000000Z\",\"updated_at\":\"2024-06-10T06:16:20.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"6\\\",\\\"position\\\":1},{\\\"id\\\":\\\"21\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":1,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"ltr\",\"total_stock\":100,\"capacity\":200,\"daily_needs\":1,\"popularity_count\":0,\"is_featured\":0,\"view_count\":1,\"maximum_order_quantity\":10,\"translations\":[]}', '[{\"type\":null}]', 0.40, 'discount_on_product', 3, 0.80, '2024-06-10 09:46:51', '2024-06-10 09:46:51', 'null', 'ltr', 1, 3, '2024-06-10', 'excluded'), (7, 14, 100007, 32.00, '{\"id\":14,\"name\":\"Maggi Cheese Macaroni Instant Pasta - Buy 3 Get 1 Free\",\"description\":\"

Description of <\\/p>

Maggi Cheese Macaroni Instant Pasta - Buy 3 Get 1 Free<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d5930abca.png\\\"]\",\"price\":32,\"variations\":\"[]\",\"tax\":0,\"status\":1,\"created_at\":\"2024-06-06T17:10:35.000000Z\",\"updated_at\":\"2024-06-10T06:20:56.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"8\\\",\\\"position\\\":1},{\\\"id\\\":\\\"25\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":0,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"gm\",\"total_stock\":100,\"capacity\":70,\"daily_needs\":1,\"popularity_count\":0,\"is_featured\":0,\"view_count\":1,\"maximum_order_quantity\":10,\"translations\":[]}', '[{\"type\":null}]', 0.00, 'discount_on_category', 3, 0.00, '2024-06-10 09:51:46', '2024-06-10 09:51:46', 'null', 'gm', 1, 3, '2024-06-10', 'excluded'), (8, 10, 100008, 40.00, '{\"id\":10,\"name\":\"paper boat Swing Lush Lychee Juice\",\"description\":\"

Description of <\\/p>

paper boat Swing Lush Lychee Juice<\\/h1>\",\"image\":\"[\\\"2024-06-06-6662d3ecef91c.png\\\"]\",\"price\":40,\"variations\":\"[]\",\"tax\":2,\"status\":1,\"created_at\":\"2024-06-06T17:03:32.000000Z\",\"updated_at\":\"2024-06-27T05:40:12.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"6\\\",\\\"position\\\":1},{\\\"id\\\":\\\"21\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":1,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"ltr\",\"total_stock\":97,\"capacity\":200,\"daily_needs\":1,\"popularity_count\":1,\"is_featured\":0,\"view_count\":3,\"maximum_order_quantity\":10,\"translations\":[]}', '[{\"type\":null}]', 0.40, 'discount_on_product', 4, 0.80, '2024-06-27 09:13:15', '2024-06-27 09:13:15', 'null', 'ltr', 1, 3, '2024-06-27', 'excluded'), (9, 2, 100009, 40.00, '{\"id\":2,\"name\":\"Modern Sandwich Bread\",\"description\":\"

Description of Modern Sandwhich Bread<\\/p>\",\"image\":\"[\\\"2024-06-06-6662d08bb0487.png\\\"]\",\"price\":40,\"variations\":\"[]\",\"tax\":2,\"status\":1,\"created_at\":\"2024-06-06T16:49:07.000000Z\",\"updated_at\":\"2024-06-27T05:44:30.000000Z\",\"attributes\":\"[]\",\"category_ids\":\"[{\\\"id\\\":\\\"3\\\",\\\"position\\\":1},{\\\"id\\\":\\\"13\\\",\\\"position\\\":2}]\",\"choice_options\":\"[]\",\"discount\":2,\"discount_type\":\"percent\",\"tax_type\":\"percent\",\"unit\":\"gm\",\"total_stock\":98,\"capacity\":1,\"daily_needs\":0,\"popularity_count\":1,\"is_featured\":1,\"view_count\":4,\"maximum_order_quantity\":5,\"translations\":[]}', '[{\"type\":null}]', 0.80, 'discount_on_product', 2, 0.80, '2024-06-27 09:14:54', '2024-06-27 09:14:54', 'null', 'gm', 1, 3, '2024-06-27', 'excluded'); -- -------------------------------------------------------- -- -- Table structure for table `order_images` -- CREATE TABLE `order_images` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) NOT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_partial_payments` -- CREATE TABLE `order_partial_payments` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) NOT NULL, `paid_with` varchar(255) NOT NULL, `paid_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `due_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email_or_phone` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_requests` -- 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, `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, `external_redirect_link` varchar(255) DEFAULT NULL, `receiver_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `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; -- -------------------------------------------------------- -- -- Table structure for table `phone_verifications` -- CREATE TABLE `phone_verifications` ( `id` bigint(20) UNSIGNED NOT NULL, `phone` varchar(255) DEFAULT NULL, `token` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `image` text DEFAULT NULL, `price` double NOT NULL DEFAULT 0, `variations` text DEFAULT NULL, `tax` decimal(8,2) NOT NULL DEFAULT 0.00, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `attributes` varchar(255) DEFAULT NULL, `category_ids` varchar(255) DEFAULT NULL, `choice_options` text DEFAULT NULL, `discount` decimal(8,2) NOT NULL DEFAULT 0.00, `discount_type` varchar(20) NOT NULL DEFAULT 'percent', `tax_type` varchar(20) NOT NULL DEFAULT 'percent', `unit` varchar(255) NOT NULL DEFAULT 'pc', `total_stock` bigint(20) NOT NULL DEFAULT 0, `capacity` decimal(8,2) DEFAULT NULL, `daily_needs` tinyint(1) NOT NULL DEFAULT 0, `popularity_count` int(11) NOT NULL DEFAULT 0, `is_featured` tinyint(4) NOT NULL DEFAULT 0, `view_count` int(11) NOT NULL DEFAULT 0, `maximum_order_quantity` int(11) NOT NULL DEFAULT 10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `name`, `description`, `image`, `price`, `variations`, `tax`, `status`, `created_at`, `updated_at`, `attributes`, `category_ids`, `choice_options`, `discount`, `discount_type`, `tax_type`, `unit`, `total_stock`, `capacity`, `daily_needs`, `popularity_count`, `is_featured`, `view_count`, `maximum_order_quantity`) VALUES (1, 'Test Product', 'Test product description', '[\"2023-10-18-652fd303e4f34.png\"]', 100, '[]', 0.00, 0, '2023-10-17 19:43:47', '2024-06-10 10:16:17', '[]', '[{\"id\":\"1\",\"position\":1},{\"id\":\"2\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'kg', 50, 1.00, 0, 0, 0, 0, 10), (2, 'Modern Sandwich Bread', '

Description of Modern Sandwhich Bread

', '[\"2024-06-06-6662d08bb0487.png\"]', 40, '[]', 2.00, 1, '2024-06-06 20:19:07', '2024-06-27 09:14:54', '[]', '[{\"id\":\"3\",\"position\":1},{\"id\":\"13\",\"position\":2}]', '[]', 2.00, 'percent', 'percent', 'gm', 96, 1.00, 0, 2, 1, 4, 5), (3, 'Amul Taaza Toned Fresh Milk', '

Descriptio of  

Amul Taaza Toned Fresh Milk

', '[\"2024-06-06-6662d0e495f59.png\"]', 30, '[]', 0.00, 1, '2024-06-06 20:20:36', '2024-06-20 09:41:41', '[]', '[{\"id\":\"3\",\"position\":1},{\"id\":\"14\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'ml', 97, 1.00, 1, 1, 0, 2, 5), (4, 'Potato', '

Description of 

Potato

', '[\"2024-06-06-6662d14e0291b.png\"]', 150, '[]', 0.00, 1, '2024-06-06 20:22:22', '2024-06-09 17:01:56', '[]', '[{\"id\":\"4\",\"position\":1},{\"id\":\"16\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'kg', 99, 1.00, 1, 1, 0, 1, 5), (5, 'Alphonso Mango', '

Description of 

Alphonso Mango

', '[\"2024-06-06-6662d1c092340.png\"]', 600, '[]', 1.00, 1, '2024-06-06 20:24:16', '2024-06-27 14:44:13', '[]', '[{\"id\":\"4\",\"position\":1},{\"id\":\"15\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'kg', 100, 1.00, 1, 0, 0, 139, 50), (6, 'Nicotex Sugar Free Nicotine Gum', '

Description of 

Nicotex Sugar Free Nicotine Gum

', '[\"2024-06-06-6662d2757e5df.png\"]', 332, '[]', 2.00, 1, '2024-06-06 20:27:17', '2024-06-27 09:09:31', '[]', '[{\"id\":\"5\",\"position\":1},{\"id\":\"17\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'pc', 30, 30.00, 1, 0, 0, 2, 5), (7, 'Stash Pro', '

Description of Stash Pro

', '[\"2024-06-06-6662d2dbc2590.png\"]', 50, '[]', 0.00, 1, '2024-06-06 20:28:59', '2024-06-20 08:40:44', '[]', '[{\"id\":\"5\",\"position\":1},{\"id\":\"18\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'pc', 100, 1.00, 0, 0, 1, 1, 1), (8, 'Sprite Lime Flavored Soft Drink 750 ml - Pack of 2', '

Description of 

Sprite Lime Flavored Soft Drink 750 ml - Pack of 2

', '[\"2024-06-06-6662d3662cc08.png\"]', 40, '[]', 3.00, 1, '2024-06-06 20:31:18', '2024-06-20 08:40:58', '[]', '[{\"id\":\"6\",\"position\":1},{\"id\":\"19\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'ltr', 100, 500.00, 0, 0, 1, 1, 500), (10, 'paper boat Swing Lush Lychee Juice', '

Description of 

paper boat Swing Lush Lychee Juice

', '[\"2024-06-06-6662d3ecef91c.png\"]', 40, '[]', 2.00, 1, '2024-06-06 20:33:32', '2024-06-27 09:13:15', '[]', '[{\"id\":\"6\",\"position\":1},{\"id\":\"21\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'ltr', 93, 200.00, 1, 2, 0, 3, 10), (11, 'Lay\'s India\'s Magic Masala Potato Chips (40 g)', '

Description of 

Lay\'s India\'s Magic Masala Potato Chips (40 g)

', '[\"2024-06-06-6662d45b92e84.png\"]', 20, '[]', 0.00, 1, '2024-06-06 20:35:23', '2024-06-27 08:13:03', '[]', '[{\"id\":\"7\",\"position\":1},{\"id\":\"23\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 40.00, 1, 0, 0, 1, 10), (12, 'RiteBite Max Protein Daily Choco Almond Protein Bar - Pack of 2', '

Description of 

RiteBite Max Protein Daily Choco Almond Protein Bar - Pack of 2

', '[\"2024-06-06-6662d4b2750e8.png\"]', 30, '[]', 0.00, 1, '2024-06-06 20:36:50', '2024-06-06 21:16:23', '[]', '[{\"id\":\"7\",\"position\":1},{\"id\":\"22\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 50.00, 0, 0, 1, 0, 10), (13, 'Maggi Masala - 2 Minutes Instant Noodles', '

Description of 

Maggi Masala - 2 Minutes Instant Noodles

', '[\"2024-06-06-6662d52ff3116.png\"]', 110, '[]', 0.00, 1, '2024-06-06 20:38:56', '2024-06-20 09:38:35', '[]', '[{\"id\":\"8\",\"position\":1},{\"id\":\"24\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 99, 280.00, 0, 1, 1, 2, 5), (14, 'Maggi Cheese Macaroni Instant Pasta - Buy 3 Get 1 Free', '

Description of 

Maggi Cheese Macaroni Instant Pasta - Buy 3 Get 1 Free

', '[\"2024-06-06-6662d5930abca.png\"]', 32, '[]', 0.00, 1, '2024-06-06 20:40:35', '2024-06-20 09:39:02', '[]', '[{\"id\":\"8\",\"position\":1},{\"id\":\"25\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 97, 70.00, 1, 1, 0, 2, 10), (15, 'Indian Sweets', '

Description of Indian Sweets

', '[\"2024-06-06-6662d645e6761.png\"]', 100, '[]', 1.00, 1, '2024-06-06 20:43:33', '2024-06-06 21:15:47', '[]', '[{\"id\":\"9\",\"position\":1},{\"id\":\"26\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 200.00, 0, 0, 1, 0, 10), (16, 'Cadbury Gems Duo Pack Chocolate', '

Description of 

Cadbury Gems Duo Pack Chocolate

', '[\"2024-06-06-6662d6a25152f.png\"]', 10, '[]', 2.00, 1, '2024-06-06 20:45:06', '2024-06-27 14:04:10', '[]', '[{\"id\":\"9\",\"position\":1},{\"id\":\"27\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'gm', 94, 20.00, 0, 1, 1, 2, 10), (17, 'Hide & Seek Chocolate Chip Cookies', '

Description of 

Hide & Seek Chocolate Chip Cookies 

', '[\"2024-06-06-6662d74b8a3bc.png\"]', 40, '[]', 2.00, 1, '2024-06-06 20:47:55', '2024-06-06 21:15:32', '[]', '[{\"id\":\"10\",\"position\":1},{\"id\":\"29\",\"position\":2}]', '[]', 1.00, 'percent', 'percent', 'kg', 100, 100.00, 0, 0, 1, 0, 100), (18, 'Parle Center Filled Biscuits (Choco, Milano Collection)', '

Description of 

Parle Center Filled Biscuits (Choco, Milano Collection)

', '[\"2024-06-06-6662d7a8523cc.png\"]', 100, '[]', 0.00, 1, '2024-06-06 20:49:28', '2024-06-06 21:15:23', '[]', '[{\"id\":\"10\",\"position\":1},{\"id\":\"28\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 250.00, 0, 0, 1, 0, 10), (19, 'Brooke Bond Taaza Tea 250 g', '

Description of 

Brooke Bond Taaza Tea 250 g

', '[\"2024-06-06-6662d7fdb6467.png\"]', 250, '[]', 0.00, 1, '2024-06-06 20:50:53', '2024-06-06 21:15:20', '[]', '[{\"id\":\"11\",\"position\":1},{\"id\":\"30\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 250.00, 1, 0, 0, 0, 5), (20, 'Nescafe Classic Instant Coffee - Pack of 60 Sachet', '

Description of 

Nescafe Classic Instant Coffee - Pack of 60 Sachet

', '[\"2024-06-06-6662d8510e5c1.png\"]', 10, '[]', 0.00, 1, '2024-06-06 20:52:17', '2024-06-06 21:15:18', '[]', '[{\"id\":\"11\",\"position\":1},{\"id\":\"31\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'gm', 100, 1.00, 0, 0, 1, 0, 100), (21, 'Aashirvaad Multigrain Atta', '

Description of 

Aashirvaad Multigrain Atta

', '[\"2024-06-06-6662d8b0a3c53.png\"]', 300, '[]', 0.00, 1, '2024-06-06 20:53:52', '2024-06-06 20:58:10', '[]', '[{\"id\":\"12\",\"position\":1},{\"id\":\"32\",\"position\":2}]', '[]', 0.01, 'percent', 'percent', 'kg', 30, 5.00, 1, 0, 0, 0, 5), (22, 'Daawat Pulav Basmati Rice (Slender Grains)', '

Description of 

Daawat Pulav Basmati Rice (Slender Grains)

', '[\"2024-06-06-6662d9071f331.png\"]', 159, '[]', 0.00, 1, '2024-06-06 20:55:19', '2024-06-20 17:10:50', '[]', '[{\"id\":\"12\",\"position\":1},{\"id\":\"33\",\"position\":2}]', '[]', 0.00, 'percent', 'percent', 'kg', 30, 1.00, 1, 0, 1, 3, 5); -- -------------------------------------------------------- -- -- Table structure for table `product_searched_by_user` -- CREATE TABLE `product_searched_by_user` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_tag` -- CREATE TABLE `product_tag` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `tag_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `recent_searches` -- CREATE TABLE `recent_searches` ( `id` bigint(20) UNSIGNED NOT NULL, `keyword` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `recent_searches` -- INSERT INTO `recent_searches` (`id`, `keyword`, `created_at`, `updated_at`) VALUES (1, 'tuwpfh', '2024-06-20 17:10:15', '2024-06-20 17:10:15'); -- -------------------------------------------------------- -- -- Table structure for table `register_devices` -- CREATE TABLE `register_devices` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `user_type` varchar(255) NOT NULL, `ip_address` varchar(255) DEFAULT NULL, `browser_name` varchar(255) DEFAULT NULL, `browser_version` varchar(255) DEFAULT NULL, `device_type` varchar(255) DEFAULT NULL, `device_platform` varchar(255) DEFAULT NULL, `is_robot` varchar(255) NOT NULL DEFAULT '0', `unique_identifier` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `register_devices` -- INSERT INTO `register_devices` (`id`, `user_id`, `user_type`, `ip_address`, `browser_name`, `browser_version`, `device_type`, `device_platform`, `is_robot`, `unique_identifier`, `created_at`, `updated_at`) VALUES (1, 1, 'admin', '152.58.130.81', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', 'e5f66db0bfa0ce2ef35b0bc98f42e4cb', '2024-06-06 16:16:17', '2024-06-06 16:16:17'), (2, 1, 'branch', '152.58.130.81', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', 'e5f66db0bfa0ce2ef35b0bc98f42e4cb', '2024-06-06 16:34:18', '2024-06-06 16:34:18'), (3, 1, 'admin', '103.87.65.146', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', '7accc55e1639a3a09958ebe9c6a80dfa', '2024-06-06 19:25:29', '2024-06-06 19:25:29'), (4, 1, 'admin', '152.58.130.168', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', 'b479daa31ec7fa7be26f45befead91d1', '2024-06-07 01:07:38', '2024-06-07 01:07:38'), (5, 1, 'admin', '152.59.172.142', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', '4398cd3146dbc2aa7837016785f898dc', '2024-06-09 15:05:03', '2024-06-09 15:05:03'), (6, 10, 'branch', '152.59.174.146', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', '26a51815f21fffdc2c2660d52f4c2e4a', '2024-06-10 09:53:37', '2024-06-10 09:53:37'), (7, 2, 'admin', '122.161.51.58', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', '02feaa767dcc7790a182956caf804d99', '2024-06-12 08:16:54', '2024-06-12 08:16:54'), (8, 2, 'admin', '122.161.53.135', 'Chrome', '125.0.0.0', 'WebKit', 'Windows', '0', '72605e3d0c1d6fba2bef83d75729040d', '2024-06-13 07:51:28', '2024-06-13 07:51:28'), (9, 2, 'admin', '103.237.158.231', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', '75ea9b389c2d8c21392d5816c2ec5e76', '2024-06-21 14:39:06', '2024-06-21 14:39:06'), (10, 2, 'admin', '103.87.65.76', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', 'adaa39386fadea17bcb65d4336cddcca', '2024-06-22 20:58:30', '2024-06-22 20:58:30'), (11, 2, 'admin', '152.58.157.211', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', 'c620d891285becf12ba577061f778982', '2024-06-27 08:03:12', '2024-06-27 08:03:12'), (12, 2, 'admin', '152.58.156.145', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', '34e1eeeeca314613b875913108431f84', '2024-06-27 08:25:33', '2024-06-27 08:25:33'), (13, 2, 'admin', '103.87.65.68', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', '52f2a8d90d7f7f0d3c2b8d6354e26243', '2024-06-27 14:12:01', '2024-06-27 14:12:01'), (14, 1, 'branch', '103.87.65.68', 'Chrome', '126.0.0.0', 'WebKit', 'Windows', '0', '52f2a8d90d7f7f0d3c2b8d6354e26243', '2024-06-27 14:23:15', '2024-06-27 14:23:15'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `comment` mediumtext DEFAULT NULL, `attachment` varchar(255) DEFAULT NULL, `rating` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `order_id` bigint(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `searched_categories` -- CREATE TABLE `searched_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `recent_search_id` bigint(20) DEFAULT NULL, `category_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `searched_data` -- CREATE TABLE `searched_data` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `category_id` bigint(20) DEFAULT NULL, `attribute` varchar(255) DEFAULT NULL, `attribute_id` bigint(20) DEFAULT NULL, `response_data_count` int(11) NOT NULL DEFAULT 0, `volume` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `searched_keyword_counts` -- CREATE TABLE `searched_keyword_counts` ( `id` bigint(20) UNSIGNED NOT NULL, `recent_search_id` bigint(20) DEFAULT NULL, `keyword_count` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `searched_keyword_counts` -- INSERT INTO `searched_keyword_counts` (`id`, `recent_search_id`, `keyword_count`, `created_at`, `updated_at`) VALUES (1, 1, 1, '2024-06-20 17:10:15', '2024-06-20 17:10:15'); -- -------------------------------------------------------- -- -- Table structure for table `searched_keyword_users` -- CREATE TABLE `searched_keyword_users` ( `id` bigint(20) UNSIGNED NOT NULL, `recent_search_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `searched_keyword_users` -- INSERT INTO `searched_keyword_users` (`id`, `recent_search_id`, `user_id`, `created_at`, `updated_at`) VALUES (1, 1, NULL, '2024-06-20 17:10:15', '2024-06-20 17:10:15'); -- -------------------------------------------------------- -- -- Table structure for table `searched_products` -- CREATE TABLE `searched_products` ( `id` bigint(20) UNSIGNED NOT NULL, `recent_search_id` bigint(20) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `social_medias` -- CREATE TABLE `social_medias` ( `id` bigint(20) UNSIGNED NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `soft_credentials` -- CREATE TABLE `soft_credentials` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) DEFAULT NULL, `value` longtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` bigint(20) UNSIGNED NOT NULL, `tag` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `time_slots` -- CREATE TABLE `time_slots` ( `id` bigint(20) UNSIGNED 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, `date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `time_slots` -- INSERT INTO `time_slots` (`id`, `start_time`, `end_time`, `status`, `created_at`, `updated_at`, `date`) VALUES (1, '10:30:00', '19:30:00', 1, '2021-04-22 04:08:15', '2021-04-22 04:08:15', '2021-04-22'), (2, '01:37:00', '11:00:00', 1, '2021-04-22 04:08:33', '2021-05-08 04:41:24', '2021-05-08'), (3, '09:50:00', '23:30:00', 1, '2021-04-22 04:08:55', '2021-07-01 04:34:39', '2021-04-26'); -- -------------------------------------------------------- -- -- Table structure for table `track_deliverymen` -- CREATE TABLE `track_deliverymen` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) DEFAULT NULL, `delivery_man_id` bigint(20) DEFAULT NULL, `longitude` varchar(20) DEFAULT NULL, `latitude` varchar(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `translations` -- CREATE TABLE `translations` ( `id` bigint(20) UNSIGNED NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `f_name` varchar(100) DEFAULT NULL, `l_name` varchar(100) 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) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `email_verification_token` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `is_block` tinyint(1) NOT NULL DEFAULT 0, `cm_firebase_token` varchar(255) DEFAULT NULL, `temporary_token` varchar(255) DEFAULT NULL, `login_medium` varchar(255) NOT NULL DEFAULT 'general', `loyalty_point` double NOT NULL DEFAULT 0, `wallet_balance` double NOT NULL DEFAULT 0, `referral_code` varchar(255) DEFAULT NULL, `referred_by` varchar(255) DEFAULT NULL, `login_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL, `language_code` varchar(255) NOT NULL DEFAULT 'en' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `f_name`, `l_name`, `email`, `image`, `is_phone_verified`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `email_verification_token`, `phone`, `is_block`, `cm_firebase_token`, `temporary_token`, `login_medium`, `loyalty_point`, `wallet_balance`, `referral_code`, `referred_by`, `login_hit_count`, `is_temp_blocked`, `temp_block_time`, `language_code`) VALUES (1, 'User', 'Demo', 'user@demo.com', NULL, 0, NULL, '$2y$10$bNLFL.tRVvr/8rrAs7DQA.JVw6zGmOa.rwB4Pr7I.FqjIk.tCifbG', NULL, '2024-06-09 15:20:59', '2024-06-27 13:58:58', NULL, '+919876543210', 0, 'dkrCf3i8mvy-n3o61l7S9F:APA91bFqBHRNL8h14BjavUqqAh5A9htgNBgtVsAmBt7hFemcEUjyALAQ3w6wcORsKOk4eJfslR3F1k6oT5dgnP5fBvDqgFzSNOUxlpZ5dLPNljFo-AAo_YwU_eEcSzwfr3pZP3nJviX3', NULL, 'general', 16, 500, 'ebeiM77QuB57lV7eQhfN', NULL, 0, 0, NULL, 'en'), (2, 'User', 'Demo 2', 'user2@demo.com', NULL, 0, NULL, '$2y$10$cGwi8/2pdmS6zRdJShVWeuHjWVghlf5mLzAbDowsgb9AlEL9I.3sC', NULL, '2024-06-27 08:12:31', '2024-06-27 09:16:27', NULL, '+919876543211', 0, '@', NULL, 'general', 9, 0, 'gmLzQgeIOXVj5diQJqKx', NULL, 0, 0, NULL, 'en'); -- -------------------------------------------------------- -- -- Table structure for table `visited_products` -- CREATE TABLE `visited_products` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `product_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wallet_bonuses` -- CREATE TABLE `wallet_bonuses` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `description` varchar(255) DEFAULT NULL, `bonus_type` varchar(255) NOT NULL, `bonus_amount` double(10,2) NOT NULL DEFAULT 0.00, `minimum_add_amount` double(10,2) NOT NULL DEFAULT 0.00, `maximum_bonus_amount` double(10,2) NOT NULL DEFAULT 0.00, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wallet_bonuses` -- INSERT INTO `wallet_bonuses` (`id`, `title`, `description`, `bonus_type`, `bonus_amount`, `minimum_add_amount`, `maximum_bonus_amount`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES (1, 'MXEPTO07', 'Wallet Bonus', 'percentage', 5.00, 100.00, 1000.00, '2024-06-26', '2024-06-30', 1, '2024-06-27 08:10:43', '2024-06-27 08:10:43'); -- -------------------------------------------------------- -- -- Table structure for table `wallet_transactions` -- CREATE TABLE `wallet_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `transaction_id` varchar(255) DEFAULT NULL, `credit` decimal(24,2) NOT NULL DEFAULT 0.00, `debit` decimal(24,2) NOT NULL DEFAULT 0.00, `balance` decimal(24,2) NOT NULL DEFAULT 0.00, `transaction_type` varchar(191) DEFAULT NULL, `reference` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wallet_transactions` -- INSERT INTO `wallet_transactions` (`id`, `user_id`, `transaction_id`, `credit`, `debit`, `balance`, `transaction_type`, `reference`, `created_at`, `updated_at`) VALUES (1, 1, 'Si3954gC6uvkO1ILomODptNSPTzQsT', 500.00, 0.00, 500.00, 'add_fund_by_admin', NULL, '2024-06-27 08:09:29', '2024-06-27 08:09:29'); -- -------------------------------------------------------- -- -- Table structure for table `wishlists` -- CREATE TABLE `wishlists` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `product_id` bigint(20) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `addon_settings` -- ALTER TABLE `addon_settings` ADD PRIMARY KEY (`id`), ADD KEY `payment_settings_id_index` (`id`); -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `admin_roles` -- ALTER TABLE `admin_roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `attributes` -- ALTER TABLE `attributes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banners` -- ALTER TABLE `banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `branches` -- ALTER TABLE `branches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `business_settings` -- ALTER TABLE `business_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category_discounts` -- ALTER TABLE `category_discounts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `category_discounts_category_id_unique` (`category_id`); -- -- Indexes for table `category_searched_by_user` -- ALTER TABLE `category_searched_by_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `conversations` -- ALTER TABLE `conversations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `currencies` -- ALTER TABLE `currencies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_addresses` -- ALTER TABLE `customer_addresses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dc_conversations` -- ALTER TABLE `dc_conversations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `delivery_histories` -- ALTER TABLE `delivery_histories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `delivery_men` -- ALTER TABLE `delivery_men` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `delivery_men_phone_unique` (`phone`); -- -- Indexes for table `d_m_reviews` -- ALTER TABLE `d_m_reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `email_verifications` -- ALTER TABLE `email_verifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `favorite_products` -- ALTER TABLE `favorite_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `flash_deals` -- ALTER TABLE `flash_deals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `flash_deal_products` -- ALTER TABLE `flash_deal_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `guest_users` -- ALTER TABLE `guest_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `loyalty_transactions` -- ALTER TABLE `loyalty_transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `newsletters` -- ALTER TABLE `newsletters` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_access_tokens` -- ALTER TABLE `oauth_access_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_access_tokens_user_id_index` (`user_id`); -- -- Indexes for table `oauth_auth_codes` -- ALTER TABLE `oauth_auth_codes` ADD PRIMARY KEY (`id`), ADD KEY `oauth_auth_codes_user_id_index` (`user_id`); -- -- Indexes for table `oauth_clients` -- ALTER TABLE `oauth_clients` ADD PRIMARY KEY (`id`), ADD KEY `oauth_clients_user_id_index` (`user_id`); -- -- Indexes for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_refresh_tokens` -- ALTER TABLE `oauth_refresh_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`); -- -- Indexes for table `offline_payments` -- ALTER TABLE `offline_payments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `offline_payment_methods` -- ALTER TABLE `offline_payment_methods` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_delivery_histories` -- ALTER TABLE `order_delivery_histories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_details` -- ALTER TABLE `order_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_images` -- ALTER TABLE `order_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_partial_payments` -- ALTER TABLE `order_partial_payments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email_or_phone`); -- -- Indexes for table `phone_verifications` -- ALTER TABLE `phone_verifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_searched_by_user` -- ALTER TABLE `product_searched_by_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_tag` -- ALTER TABLE `product_tag` ADD PRIMARY KEY (`id`); -- -- Indexes for table `recent_searches` -- ALTER TABLE `recent_searches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `register_devices` -- ALTER TABLE `register_devices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `searched_categories` -- ALTER TABLE `searched_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `searched_data` -- ALTER TABLE `searched_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `searched_keyword_counts` -- ALTER TABLE `searched_keyword_counts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `searched_keyword_users` -- ALTER TABLE `searched_keyword_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `searched_products` -- ALTER TABLE `searched_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `social_medias` -- ALTER TABLE `social_medias` ADD PRIMARY KEY (`id`); -- -- Indexes for table `soft_credentials` -- ALTER TABLE `soft_credentials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`); -- -- Indexes for table `time_slots` -- ALTER TABLE `time_slots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `track_deliverymen` -- ALTER TABLE `track_deliverymen` ADD PRIMARY KEY (`id`); -- -- Indexes for table `translations` -- ALTER TABLE `translations` ADD PRIMARY KEY (`id`), ADD KEY `translations_translationable_id_index` (`translationable_id`), ADD KEY `translations_locale_index` (`locale`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `visited_products` -- ALTER TABLE `visited_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wallet_bonuses` -- ALTER TABLE `wallet_bonuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wallet_transactions` -- ALTER TABLE `wallet_transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wishlists` -- ALTER TABLE `wishlists` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `admin_roles` -- ALTER TABLE `admin_roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `attributes` -- ALTER TABLE `attributes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `banners` -- ALTER TABLE `banners` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `branches` -- ALTER TABLE `branches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `business_settings` -- ALTER TABLE `business_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `category_discounts` -- ALTER TABLE `category_discounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `category_searched_by_user` -- ALTER TABLE `category_searched_by_user` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `conversations` -- ALTER TABLE `conversations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `currencies` -- ALTER TABLE `currencies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120; -- -- AUTO_INCREMENT for table `customer_addresses` -- ALTER TABLE `customer_addresses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `dc_conversations` -- ALTER TABLE `dc_conversations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `delivery_histories` -- ALTER TABLE `delivery_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `delivery_men` -- ALTER TABLE `delivery_men` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `d_m_reviews` -- ALTER TABLE `d_m_reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_verifications` -- ALTER TABLE `email_verifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `favorite_products` -- ALTER TABLE `favorite_products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `flash_deals` -- ALTER TABLE `flash_deals` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `flash_deal_products` -- ALTER TABLE `flash_deal_products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `guest_users` -- ALTER TABLE `guest_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `loyalty_transactions` -- ALTER TABLE `loyalty_transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160; -- -- AUTO_INCREMENT for table `newsletters` -- ALTER TABLE `newsletters` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notifications` -- ALTER TABLE `notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `oauth_clients` -- ALTER TABLE `oauth_clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `offline_payments` -- ALTER TABLE `offline_payments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `offline_payment_methods` -- ALTER TABLE `offline_payment_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100010; -- -- AUTO_INCREMENT for table `order_delivery_histories` -- ALTER TABLE `order_delivery_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_details` -- ALTER TABLE `order_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `order_images` -- ALTER TABLE `order_images` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_partial_payments` -- ALTER TABLE `order_partial_payments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `phone_verifications` -- ALTER TABLE `phone_verifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `product_searched_by_user` -- ALTER TABLE `product_searched_by_user` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_tag` -- ALTER TABLE `product_tag` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `recent_searches` -- ALTER TABLE `recent_searches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `register_devices` -- ALTER TABLE `register_devices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `searched_categories` -- ALTER TABLE `searched_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `searched_data` -- ALTER TABLE `searched_data` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `searched_keyword_counts` -- ALTER TABLE `searched_keyword_counts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `searched_keyword_users` -- ALTER TABLE `searched_keyword_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `searched_products` -- ALTER TABLE `searched_products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `social_medias` -- ALTER TABLE `social_medias` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `soft_credentials` -- ALTER TABLE `soft_credentials` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tags` -- ALTER TABLE `tags` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `time_slots` -- ALTER TABLE `time_slots` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `track_deliverymen` -- ALTER TABLE `track_deliverymen` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `translations` -- ALTER TABLE `translations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `visited_products` -- ALTER TABLE `visited_products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wallet_bonuses` -- ALTER TABLE `wallet_bonuses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `wallet_transactions` -- ALTER TABLE `wallet_transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `wishlists` -- ALTER TABLE `wishlists` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;