-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 24, 2025 at 11:19 AM
-- Server version: 8.0.30
-- PHP Version: 8.3.10

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: `eskrow_empty`
--

-- --------------------------------------------------------

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

CREATE TABLE `admins` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `admins` (`id`, `name`, `email`, `username`, `email_verified_at`, `image`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Safety Escrow Staff', 'info@safety-escrow.com', 'admin', NULL, '635ce2abe4bf81667031723.png', '$2y$10$el35r0DVW8rbSEx0xm5xDu5IsbxmiaA1CZe3tfeub4iA4HxD1QSxq', 'eFv5mZAdJYyEAgymSZIAoxLMPDK1BTo1b1NbgRoJ0Hq1AfBQ14Szoa80SaW7', NULL, '2023-08-11 01:55:10');

-- --------------------------------------------------------

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_status` tinyint(1) NOT NULL DEFAULT '0',
  `click_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_password_resets`
--

CREATE TABLE `admin_password_resets` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `conversations` (
  `id` bigint UNSIGNED NOT NULL,
  `escrow_id` int UNSIGNED NOT NULL DEFAULT '0',
  `seller_id` int UNSIGNED NOT NULL DEFAULT '0',
  `buyer_id` int UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint UNSIGNED NOT NULL DEFAULT '1' COMMENT '0=>closed,1=>running',
  `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 `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `milestone_id` int DEFAULT '0',
  `method_code` int UNSIGNED NOT NULL DEFAULT '0',
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `method_currency` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `final_amo` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `btc_amo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btc_wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trx` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `try` int NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel',
  `from_api` tinyint(1) NOT NULL DEFAULT '0',
  `admin_feedback` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `escrows`
--

CREATE TABLE `escrows` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` int UNSIGNED DEFAULT NULL,
  `seller_id` int UNSIGNED NOT NULL DEFAULT '0',
  `buyer_id` int UNSIGNED NOT NULL DEFAULT '0',
  `inventor_id` int UNSIGNED NOT NULL DEFAULT '0',
  `receiver_id` int NOT NULL DEFAULT '0' COMMENT 'to whom the offer is made',
  `disputer_id` int NOT NULL,
  `receiver_gmail` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'to whom the offer is made his gmail',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `escrow_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `funded_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `charge_sender` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '1=>seller charge, 2=>buyer charge, 3=>50-50\r\n',
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `buyer_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `seller_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 => not accepted\r\n1 => dispatched and completed\r\n2 => accepted and running\r\n3 => disputed\r\n4 => cancelled',
  `dispute_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mail_invitation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `escrow_charges`
--

CREATE TABLE `escrow_charges` (
  `id` bigint UNSIGNED NOT NULL,
  `minimum` decimal(28,8) DEFAULT '0.00000000',
  `maximum` decimal(28,8) DEFAULT NULL,
  `fixed_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `percent_charge` int 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 `extensions`
--

CREATE TABLE `extensions` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `script` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `shortcode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'object',
  `support` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'help section',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>enable, 2=>disable',
  `deleted_at` datetime 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 `extensions`
--

INSERT INTO `extensions` (`id`, `act`, `name`, `description`, `image`, `script`, `shortcode`, `support`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'tawk-chat', 'Live Chat(Tawk.to)', 'Key location is shown bellow', 'chat-png.png', '<script>\n                        var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\n                        (function(){\n                        var s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\n                        s1.async=true;\n                        s1.src=\"https://embed.tawk.to/{{app_key}}\";\n                        s1.charset=\"UTF-8\";\n                        s1.setAttribute(\"crossorigin\",\"*\");\n                        s0.parentNode.insertBefore(s1,s0);\n                        })();\n                    </script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"------\"}}', 'twak.png', 0, NULL, '2019-10-18 23:16:05', '2022-09-22 10:36:05'),
(2, 'google-recaptcha2', 'Google Recaptcha 2', 'Key location is shown bellow', 'recaptcha2.png', '\n<script src=\"https://www.google.com/recaptcha/api.js\"></script>\n<div class=\"g-recaptcha\" data-sitekey=\"{{site_key}}\" data-callback=\"verifyCaptcha\"></div>\n<div id=\"g-recaptcha-error\"></div>', '{\"site_key\":{\"title\":\"Site Key\",\"value\":\"6LdPC88fAAAAADQlUf_DV6Hrvgm-pZuLJFSLDOWV\"},\"secret_key\":{\"title\":\"Secret Key\",\"value\":\"6LdPC88fAAAAAG5SVaRYDnV2NpCrptLg2XLYKRKB\"}}', 'recaptcha.png', 0, NULL, '2019-10-18 23:16:05', '2023-08-10 18:44:53');

-- --------------------------------------------------------

--
-- Table structure for table `forms`
--

CREATE TABLE `forms` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forms`
--

INSERT INTO `forms` (`id`, `act`, `form_data`, `created_at`, `updated_at`) VALUES
(2, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number_22\":{\"name\":\"NID Number 22\",\"label\":\"nid_number_22\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"textarea\"},\"sadfg\":{\"name\":\"sadfg\",\"label\":\"sadfg\",\"is_required\":\"optional\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"asdf\":{\"name\":\"asdf\",\"label\":\"asdf\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"Test2\",\"Test3\"],\"type\":\"select\"},\"nid_number_226985\":{\"name\":\"NID Number 226985\",\"label\":\"nid_number_226985\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"Test 2\",\"Test 3\"],\"type\":\"checkbox\"},\"nid_number_3333\":{\"name\":\"NID Number 3333\",\"label\":\"nid_number_3333\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"asdf\"],\"type\":\"radio\"},\"nid_number_3333587\":{\"name\":\"NID Number 3333587\",\"label\":\"nid_number_3333587\",\"is_required\":\"optional\",\"extensions\":\"jpg,bmp,png,pdf\",\"options\":[],\"type\":\"file\"}}', '2022-03-16 01:09:49', '2022-03-17 00:02:54'),
(3, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number_226985\":{\"name\":\"NID Number 226985\",\"label\":\"nid_number_226985\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-16 04:32:29', '2022-03-16 04:35:32'),
(5, 'withdraw_method', '{\"nid_number_33\":{\"name\":\"NID Number 33\",\"label\":\"nid_number_33\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-17 00:45:35', '2022-03-17 00:53:17'),
(6, 'withdraw_method', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-17 00:47:04', '2022-03-17 00:47:04'),
(7, 'kyc', '{\"full_name\":{\"name\":\"Full Name\",\"label\":\"full_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"gender\":{\"name\":\"Gender\",\"label\":\"gender\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Male\",\"Female\",\"Others\"],\"type\":\"select\"},\"you_hobby\":{\"name\":\"You Hobby\",\"label\":\"you_hobby\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Programming\",\"Gardening\",\"Traveling\",\"Others\"],\"type\":\"checkbox\"},\"nid_photo\":{\"name\":\"NID Photo\",\"label\":\"nid_photo\",\"is_required\":\"required\",\"extensions\":\"jpg,png\",\"options\":[],\"type\":\"file\"}}', '2022-03-17 02:56:14', '2022-04-11 03:23:40'),
(8, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-03-21 07:53:25', '2022-03-21 07:53:25'),
(9, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-03-21 07:54:15', '2022-03-21 07:54:15'),
(10, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-21 07:55:15', '2022-03-21 07:55:22'),
(11, 'withdraw_method', '{\"nid_number_2658\":{\"name\":\"NID Number 2658\",\"label\":\"nid_number_2658\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[\"asdf\"],\"type\":\"checkbox\"}}', '2022-03-22 00:14:09', '2022-03-22 00:14:18'),
(12, 'withdraw_method', '[]', '2022-03-30 09:03:12', '2022-03-30 09:03:12'),
(13, 'withdraw_method', '{\"bank_name\":{\"name\":\"Bank Name\",\"label\":\"bank_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"account_name\":{\"name\":\"Account Name\",\"label\":\"account_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"account_number\":{\"name\":\"Account Number\",\"label\":\"account_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2022-03-30 09:09:11', '2022-09-28 04:05:20'),
(14, 'withdraw_method', '{\"mobile_number\":{\"name\":\"Mobile Number\",\"label\":\"mobile_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2022-03-30 09:10:12', '2022-09-29 09:55:20'),
(15, 'manual_deposit', '{\"send_from_number\":{\"name\":\"Send From Number\",\"label\":\"send_from_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"transaction_number\":{\"name\":\"Transaction Number\",\"label\":\"transaction_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"screenshot\":{\"name\":\"Screenshot\",\"label\":\"screenshot\",\"is_required\":\"required\",\"extensions\":\"jpg,jpeg,png\",\"options\":[],\"type\":\"file\"}}', '2022-03-30 09:15:27', '2022-03-30 09:15:27'),
(16, 'manual_deposit', '{\"transaction_number\":{\"name\":\"Transaction Number\",\"label\":\"transaction_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"screenshot\":{\"name\":\"Screenshot\",\"label\":\"screenshot\",\"is_required\":\"required\",\"extensions\":\"jpg,pdf,docx\",\"options\":[],\"type\":\"file\"}}', '2022-03-30 09:16:43', '2022-04-11 03:19:54'),
(17, 'manual_deposit', '[]', '2022-03-30 09:21:19', '2022-03-30 09:21:19'),
(18, 'manual_deposit', '{\"asdfasddf\":{\"name\":\"asdfasddf\",\"label\":\"asdfasddf\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-09-28 04:50:55', '2022-09-28 04:50:55'),
(19, 'manual_deposit', '{\"sadf\":{\"name\":\"sadf\",\"label\":\"sadf\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"textarea\"}}', '2022-09-28 05:13:04', '2022-09-28 05:13:59'),
(20, 'manual_deposit', '[]', '2023-02-16 06:32:35', '2023-02-16 06:32:35'),
(21, 'manual_deposit', '[]', '2023-03-21 09:39:31', '2023-03-21 09:39:31'),
(22, 'manual_deposit', '{\"name\":{\"name\":\"Name\",\"label\":\"name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"mobile_number\":{\"name\":\"Mobile Number\",\"label\":\"mobile_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2023-08-11 01:34:13', '2025-02-19 10:43:09'),
(23, 'withdraw_method', '{\"name\":{\"name\":\"Name\",\"label\":\"name\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"mobile_number\":{\"name\":\"Mobile Number\",\"label\":\"mobile_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2025-02-19 11:57:47', '2025-02-19 11:57:47');

-- --------------------------------------------------------

--
-- Table structure for table `frontends`
--

CREATE TABLE `frontends` (
  `id` bigint UNSIGNED NOT NULL,
  `data_keys` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `frontends`
--

INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `created_at`, `updated_at`) VALUES
(1, 'seo.data', '{\"seo_image\":\"1\",\"keywords\":[\"website\",\"services\",\"online payment\",\"online transaction\"],\"description\":\"Escrow is a secure online payment platform that ensures safe transactions between buyers and sellers by holding funds until all terms are met. Protect your payments with Escrow today!\",\"social_title\":\"Escrow Payment Platform\",\"social_description\":\"Looking for a safe way to buy and sell online? Escrow secures your transactions by holding funds until all terms are met, protecting both buyers and sellers. Trade with confidence today!\",\"image\":\"67d6a3fb4705d1742119931.png\"}', '2020-07-04 23:42:52', '2025-03-16 07:42:11'),
(24, 'about_two.content', '{\"has_image\":\"1\",\"heading\":\"Trust your transactions with us - Safe, Secure, and Efficient!\",\"subheading\":\"About Us\",\"description\":\"Safety Escrow is Leading Crypto Escrow Service with over 5000+ satisfied customers worldwide. We\'ve been facilitating safe transaction for over half a decade and counting. Safety Escrow ensure swift user experience and safety as far as buying or selling in the safest way possible. Enjoy the very minimal escrow fees on all your transactions. Safety Escrows that both buyer and sellers are equally protected and each of them meet their respected responsibilities.\",\"video_link\":\"https:\\/\\/youtu.be\\/fZlHcazNMrc\",\"about_image\":\"64158e2ca16be1679134252.png\"}', '2020-10-28 00:51:20', '2023-08-10 17:12:15'),
(25, 'blog_two.content', '{\"heading\":\"News &amp; Feeds\",\"subheading\":\"Blog\",\"description\":\"Latest updates on crypto news and and Escrow servces\"}', '2020-10-28 00:51:34', '2023-08-10 17:20:27'),
(26, 'blog_two.element', '{\"has_image\":[\"1\"],\"title\":\"Stock Market Reaches All-Time High Amid Strong Economic Growth\",\"author\":\"Safety Escrow Staff\",\"description\":\"<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p><p>\\u00a0<\\/p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p>\",\"button\":\"Read More\",\"blog_image\":\"64158fa6884481679134630.png\"}', '2020-10-28 00:57:19', '2023-08-10 15:09:29'),
(27, 'contact_us_two.content', '{\"description\":\"Send us your inquiry below and our staff will respond within an interval of 5 hours maximum.\",\"email_address\":\"info@safety-escrow.com\",\"address\":\"1831 Mississippi 1, Greenville, Missouri\",\"contact_number\":\"+1 (262) 683-7388\",\"latitude\":\"47.3775366\",\"longitude\":\"8.466696\",\"copyright_text\":\"<p>\\u00a9 Copyright 2023. All rights reserved.<\\/p>\"}', '2020-10-28 00:59:19', '2023-08-10 17:26:20'),
(28, 'counter.content', '{\"heading\":\"Clients\",\"subheading\":\"Auctor gravida vestibulu\"}', '2020-10-28 01:04:02', '2022-09-28 14:02:14'),
(31, 'social_icon.element', '{\"title\":\"Facebook\",\"social_icon\":\"<i class=\\\"fab fa-facebook-square\\\"><\\/i>\",\"url\":\"https:\\/\\/www.facebook.com\\/\"}', '2020-11-12 04:07:30', '2025-03-19 08:13:04'),
(33, 'feature.content', '{\"heading\":\"asdf\",\"sub_heading\":\"asdf\"}', '2021-01-03 23:40:54', '2021-01-03 23:40:55'),
(34, 'feature.element', '{\"title\":\"asdf\",\"description\":\"asdf\",\"feature_icon\":\"asdf\"}', '2021-01-03 23:41:02', '2021-01-03 23:41:02'),
(35, 'service_two.element', '{\"title\":\"Domain Names\",\"description\":\"At the point when you focus on trading something.\",\"has_image\":[\"1\"],\"service_img\":\"63e9d6eb954f21676269291.png\"}', '2021-03-06 01:12:10', '2023-02-13 03:51:31'),
(36, 'service_two.content', '{\"heading\":\"Crypto escrow services | Escrow for cryptocurrency\",\"subheading\":\"Services\",\"description\":\"Looking for the best crypto escrow? Safety Escrow comes among the best crypto escrow services for the following reasons Trust, Security,Dispute resolution, support, convenience.\"}', '2021-03-06 01:27:34', '2023-08-10 17:31:47'),
(39, 'banner_two.content', '{\"heading\":\"Secure Crypto Escrow Services for Online Transactions | Crypto Escrow Service\",\"subheading\":\"Our escrow system ensures secure online transactions, protecting buyers and sellers from fraud and payment disputes. Our payment process is reliable, providing swift and efficient transaction.\",\"button\":\"Get Started\",\"has_image\":\"1\",\"animation_img1\":\"6415b98266dad1679145346.png\",\"animation_img2\":\"6415b5b0d444b1679144368.png\",\"animation_img3\":\"6415b9bb07b831679145403.png\",\"animation_img4\":\"6415b968eb6041679145320.png\"}', '2021-05-02 06:09:30', '2023-08-10 17:15:31'),
(41, 'cookie.data', '{\"short_desc\":\"We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking \\\"Accept\\\", you consent to our use of cookies.\",\"description\":\"<h4><strong>GDPR and Privacy Compliance Statement<\\/strong><\\/h4><p>At <strong>eskrow<\\/strong>, your privacy is our priority. As a home service platform, we ensure that all your personal information is handled responsibly and securely in compliance with the <strong>General Data Protection Regulation (GDPR)<\\/strong> and other applicable laws.<\\/p><p>We collect only the data necessary to provide you with efficient and high-quality services, such as connecting you with service professionals, managing bookings, and improving your overall experience. Your data is never shared with unauthorized third parties, and we are transparent about how it is processed.<\\/p><p>You have full control over your personal data and can access, update, or delete it at any time. Your trust is the foundation of our services, and we are committed to safeguarding your information.<\\/p><p>&nbsp;<\\/p><h4><strong>Cookies Policy for Eskrow<\\/strong><\\/h4><p>To deliver a seamless and personalized experience, <strong>Eskrow<\\/strong> uses cookies on our website. Cookies are small text files stored on your device that help us improve functionality, analyze website usage, and tailor our services to your preferences.<\\/p><p>&nbsp;<\\/p><h4><strong>Types of Cookies We Use:<\\/strong><\\/h4><ol><li><strong>Essential Cookies<\\/strong>: Enable core functionalities like user login, service bookings, and secure payment processing.<\\/li><li><strong>Performance Cookies<\\/strong>: Provide insights into how users interact with our website, helping us improve performance.<\\/li><li><strong>Functional Cookies<\\/strong>: Remember your preferences, such as language and location settings, for a more personalized experience.<\\/li><li><strong>Advertising Cookies<\\/strong>: Deliver relevant service promotions and measure ad performance.<\\/li><\\/ol><p>&nbsp;<\\/p><h4><strong>How We Protect Your Data<\\/strong><\\/h4><p>We use industry-standard encryption and security practices to safeguard your data. All third-party providers we work with, such as payment processors and service professionals, comply with GDPR and similar legal requirements to protect your information.<\\/p><p>&nbsp;<\\/p><h4><strong>Compliance Commitment<\\/strong><\\/h4><p>We regularly review and update our data protection policies to stay compliant with GDPR and evolving legal standards. If you have questions or concerns about how your data is handled, feel free to reach out to us at <strong>esckow.com<\\/strong><\\/p><p>&nbsp;<\\/p><p>Hey there! We use cookies to make our website awesome for you! Cookies are tiny bits of data that help us remember your preferences and improve your experience. We only use cookies that are safe for kids like you!<\\/p><p>Cookies help us know which games you love, what stories you enjoy, and how we can make our website even more fun for you. We promise never to collect personal information from you without your parent\'s permission.<\\/p><p>If you have any questions about cookies or anything else on our website, just ask a grown-up! They can contact us.<\\/p><p>Keep playing and exploring, kiddo! \\ud83d\\ude0a\\ud83c\\udf6a\\ud83c\\udf89<\\/p>\",\"status\":0}', '2020-07-04 23:42:52', '2025-03-16 06:46:15'),
(42, 'policy_pages.element', '{\"title\":\"Privacy Policy\",\"details\":\"<h3>Privacy Policy<\\/h3><p>\\u00a0<\\/p><p><strong>Preface<\\/strong><\\/p><p>Our Company Name we are committed to protecting the privacy of our users (\\\"you\\\" or \\\"your\\\") and safeguarding the personal information collected through our website and services (collectively, the \\\"Services\\\"). This Privacy Policy outlines how we collect, use, disclose, and protect your personal information. With our user-friendly interface and seamless booking process, arranging for essential services has never been easier. One of the key advantages of using our platform is the assurance of quality and professionalism. By accessing or using the Services, you consent to the collection and use of your personal information as described in this Privacy Policy.<\\/p><p>\\u00a0<\\/p><p><strong>Information We Collect<\\/strong><\\/p><p>We may collect personal information from you when you use our Services, including but not limited to:<\\/p><p>Contact information such as name, email address, and phone number. Payment information such as credit card details or other financial information. Demographic information such as age, gender, and location. Information about your preferences and interests related to our Services.Communications and interactions with us, including customer support inquiries.\\u00a0<\\/p><p>We may collect this information directly from you or automatically through the use of cookies, web beacons, and other tracking technologies.<\\/p><p>\\u00a0<\\/p><p><strong>Use of Information<\\/strong><\\/p><p>We may use the personal information we collect for various purposes, including but not limited to:<\\/p><ul><li>Providing and improving our Services.<\\/li><li>Processing transactions and payments.<\\/li><li>Communicating with you about your account and our Services.<\\/li><li>Customizing your experience and preferences.<\\/li><li>Services in a timely and professional manner and any applicable laws and regulations.<\\/li><li>Users are solely responsible for any fees, chargesServices.<\\/li><li>Marketing and promotional purposes<\\/li><\\/ul><h4>\\u00a0<\\/h4><p><strong>Disclosure of Information\\u00a0<\\/strong><\\/p><p>We may disclose your personal information to third parties for the following purposes:<\\/p><p>Service Providers: We may share your information with third-party service providers who assist us in providing and improving our Services.<\\/p><p>Business Transfers: In the event of a merger, acquisition, or sale of assets, your personal information may be transferred to the acquiring entity.Legal Compliance: We may disclose your information to comply with applicable laws, regulations, or legal processes, or to protect our rights, property, or safety.<\\/p><p>\\u00a0<\\/p><p><strong>Data Security<\\/strong><\\/p><p>We take reasonable measures to protect your personal information from unauthorized access, use, or disclosure. However, no method of transmission over the internet or electronic storage is 100% secure, and we cannot guarantee absolute security.<\\/p><p>\\u00a0<\\/p><p><strong>Your Choices<\\/strong><\\/p><p>You have the right to access, update, or delete your personal information at any time by contacting us. You may also opt-out of receiving marketing communications from us by following the instructions provided in such communications.<\\/p><p>\\u00a0<\\/p><p><strong>Payment Terms<\\/strong><\\/p><p>Users agree to pay for services rendered through the platform at the rates agreed upon with the Service Providers.<\\/p><p>Payments are processed securely through the platform, and Users may be required to provide payment information in advance or at the time of service. \\u00a0may charge service fees, commissions, or other transaction fees on payments processed through the platform<\\/p><p>\\u00a0<\\/p><p><strong>\\u00a0Children\'s Privacy<\\/strong><\\/p><p>Our Services are not intended for children under the age of 13, and we do not knowingly collect personal information from children under this age. If you believe that we have inadvertently collected personal information from a child under 13, please contact us immediately.<\\/p><p>\\u00a0<\\/p><p><strong>\\u00a0Changes to this Privacy Policy<\\/strong><\\/p><p>We reserve the right to update or modify this Privacy Policy at any time. We will notify you of any changes by posting the updated Privacy Policy on our website. Your continued use of the Services after such changes constitutes acceptance of the updated Privacy Policy.<\\/p><p>\\u00a0<\\/p><p><strong>Intellectual Property<\\/strong><\\/p><p>All content, including but not limited to logos, trademarks, text, images, and software, on the website and within the Services is the property of and is protected by intellectual property laws. Users may not use, reproduce, distribute, or modify any content from the Services without prior written consent from<\\/p><p>\\u00a0<\\/p><p><strong>Disclaimer of Warranties<\\/strong><\\/p><p>The Services are provided on an \\\"as is\\\" and \\\"as available\\\" basis without warranties of any kind, either express or implied. \\u00a0makes no representations or warranties regarding the quality, accuracy, or reliability of the Services or the suitability of the Service Providers.<\\/p><p>Users acknowledge that the use of the Services is at their own risk, and disclaims all liability for any damages or losses arising from the use of the Services.<\\/p><p>\\u00a0<\\/p><p><strong>Entire Agreement<\\/strong><\\/p><p>These Terms constitute the entire agreement between Users and our Company is a regarding the use of the Services and supersede any prior agreements or understandings, whether written or oral.<\\/p>\"}', '2021-06-09 08:50:42', '2025-03-16 06:48:59'),
(43, 'policy_pages.element', '{\"title\":\"Terms of Service\",\"details\":\"<h3><strong>Terms of Service<\\/strong><\\/h3><p>\\u00a0<\\/p><p><strong>Introduction<\\/strong><\\/p><p>Our platform offers a comprehensive range of services designed to streamline your daily routines and alleviate the stress associated with managing various tasks. From car wash and detailing to AC repair and maintenance, we\'ve got you covered. Imagine being able to schedule a car wash at your convenience, without having to leave your home or office. With our user-friendly interface and seamless booking process, arranging for essential services has never been easier. One of the key advantages of using our platform is the assurance of quality and professionalism. We meticulously vet all service providers to ensure that they meet our stringent standards for excellence. Whether you\'re entrusting your vehicle to our expert detailers or scheduling a routine AC service, you can rest assured that you\'re professionals who take pride in their work.<\\/p><p>\\u00a0<\\/p><p><strong>Acceptance of Terms<\\/strong><\\/p><p>By accessing or using the Services, you acknowledge that you have read, understood, and agree to be bound by these Terms, as well as any additional terms and conditions referenced herein or provided by us. But convenience and quality are just part of the equation. Company \\u00a0we\'re committed to delivering exceptional customer experiences every step of the way.\\u00a0<\\/p><p>\\u00a0<\\/p><p><strong>Description of Services<\\/strong><\\/p><p>operates an online platform that connects users (\\\"Users\\\") with service providers (\\\"Service Providers\\\") offering various services, including but not limited to car wash, AC services, and related services. The platform facilitates scheduling, payment processing, and communication between Users and Service Providers.<\\/p><p>\\u00a0<\\/p><p><strong>User Responsibilities<\\/strong><\\/p><ul><li>Users must provide accurate and complete information when using the Services.<\\/li><li>Services in a timely and professional manner, meeting industry standards and any applicable laws and regulations.<\\/li><li>Users agree to treat Service Providers with respect and comply with any guidelines or instructions provided by them.<\\/li><li>Must adhere to our policies and guidelines, including those related to safety, quality, and customer service.<\\/li><li>Users are solely responsible for any fees, charges, or taxes incurred through their use of the Services.<\\/li><\\/ul><h4>\\u00a0<\\/h4><p><strong>Service Provider Responsibilities \\u00a0\\u00a0<\\/strong><\\/p><ul><li>Service Providers must deliver services in a timely and professional manner, meeting industry standards and.<\\/li><li>Service Providers are responsible for maintaining all necessary licenses, permits, insurance, and certifications.<\\/li><li>Service Providers must adhere to our policies and guidelines those related to safety, quality, and customer service.<\\/li><li>AC service, you can rest assured that you\'re professionals who take pride in their work.<\\/li><li>Wash at your convenience, without having to leave your home or office. With our user-friendly interface and seamless\\u00a0<\\/li><\\/ul><h4>\\u00a0<\\/h4><p><strong>Payment Terms<\\/strong><\\/p><p>Users agree to pay for services rendered through the platform at the rates agreed upon with the Service Providers.<\\/p><p>Payments are processed securely through the platform, and Users may be required to provide payment information in advance or at the time of service. \\u00a0may charge service fees, commissions, or other transaction fees on payments processed through the platform<\\/p><p>\\u00a0<\\/p><p><strong>Intellectual Property<\\/strong><\\/p><p>All content, including but not limited to logos, trademarks, text, images, and software, on the website and within the Services is the property of and is protected by intellectual property laws. Users may not use, reproduce, distribute, or modify any content from the Services without prior written consent from<\\/p><p>\\u00a0<\\/p><p><strong>Disclaimer of Warranties<\\/strong><\\/p><p>The Services are provided on an \\\"as is\\\" and \\\"as available\\\" basis without warranties of any kind, either express or implied. \\u00a0makes no representations or warranties regarding the quality, accuracy, or reliability of the Services or the suitability of the Service Providers.<\\/p><p>Users acknowledge that the use of the Services is at their own risk, and disclaims all liability for any damages or losses arising from the use of the Services.<\\/p><p>\\u00a0<\\/p><p><strong>Limitation of Liability<\\/strong><\\/p><ul><li>In no event shall [Your Company Name] or its affiliates, directors, officers, employees.<\\/li><li>Aagents, or licensors be liable for any indirect, incidental, special, consequential, or punitive\\u00a0<\\/li><li>Damages, including but not limited to loss of profits, data, or goodwill, arising out of or in\\u00a0<\\/li><li>Connection with the use of the Services or these Terms, even if advised of the possibility of such damages.<\\/li><li>Connection with the Services or these Terms shall not the amount paid by the User for rise to the claim.<\\/li><\\/ul><h4>\\u00a0<\\/h4><p><strong>Governing Law and Dispute Resolution<\\/strong><\\/p><p>These Terms shall be governed by and construed in accordance with the laws of without regard to its conflict of law principles. Any dispute arising and software, on the website and within the Services is the property of and is protected by intellectual property laws. out of or relating to these Terms or the Services shall be resolved exclusively through binding arbitration administered by in accordance with its rules. The arbitration shall take place in and the language of the arbitration shall be The arbitrator\'s decision shall be final and binding on all parties.<\\/p><p>\\u00a0<\\/p><p><strong>Changes to Terms<\\/strong><\\/p><p>reserves the right to update or modify these Terms at any time, with or without notice to Users. Any changes will be effective immediately upon posting. Users are responsible for reviewing these Terms periodically to stay informed of any updates or changes. Continued use of the Services after such changes constitutes acceptance of the updated Terms.<\\/p><p>\\u00a0<\\/p><p><strong>Entire Agreement<\\/strong><\\/p><p>These Terms constitute the entire agreement between Users and our Company is a regarding the use of the Services and supersede any prior agreements or understandings, whether written or oral.<\\/p>\"}', '2021-06-09 08:51:18', '2025-02-16 12:20:09'),
(44, 'maintenance.data', '{\"description\":\"<div class=\\\"mb-5\\\" style=\\\"color: rgb(111, 111, 111); font-family: Nunito, sans-serif; margin-bottom: 3rem !important;\\\"><h3 class=\\\"mb-3\\\" style=\\\"text-align: center; font-weight: 600; line-height: 1.3; font-size: 24px; font-family: Exo, sans-serif; color: rgb(54, 54, 54);\\\">What information do we collect?<\\/h3><p class=\\\"font-18\\\" style=\\\"text-align: center; margin-right: 0px; margin-left: 0px; font-size: 18px !important;\\\">We gather data from you when you register on our site, submit a request, buy any services, react to an overview, or round out a structure. At the point when requesting any assistance or enrolling on our site, as suitable, you might be approached to enter your: name, email address, or telephone number. You may, nonetheless, visit our site anonymously.<\\/p><\\/div>\"}', '2020-07-04 23:42:52', '2022-05-11 03:57:17'),
(45, 'feature.element', '{\"title\":\"sytry\",\"description\":\"ertyerty\",\"feature_icon\":\"<i class=\\\"fas fa-address-book\\\"><\\/i>\"}', '2022-10-17 10:23:22', '2022-10-17 10:23:22'),
(46, 'feature.element', '{\"title\":\"sytry\",\"description\":\"ertyerty\",\"feature_icon\":\"<i class=\\\"fas fa-address-book\\\"><\\/i>\"}', '2022-10-17 10:23:22', '2022-10-17 10:23:22'),
(51, 'choose_us_two.content', '{\"heading\":\"Trustworthy and Secure System\",\"subheading\":\"Why Choose Us\",\"description\":\"Safety Escrow offers legitimate trustworthy and secure experience for both buyers and sellers in the crypto industry. Using Safety Escrow guarantees 100% protection. You also get to pay very minimal fees on all your escrow transactions. Fast 24\\/7 customer support and very easy and friendly user interface.\"}', '2023-02-12 10:23:52', '2023-08-10 17:47:04'),
(52, 'choose_us_two.element', '{\"has_image\":[\"1\"],\"title\":\"User Friendly\",\"description\":\"Our top notch user friendly interface allows you to open your escrow transactions effortlessly in just few clicks.\",\"choose_img\":\"6415abcead67e1679141838.png\"}', '2023-02-12 10:29:00', '2023-08-10 17:43:15'),
(53, 'choose_us_two.element', '{\"has_image\":[\"1\"],\"title\":\"Low cost fee\",\"description\":\"We have one of the lowest fee per Escrow transaction as compared to the other crypto escrow companies.\",\"choose_img\":\"6415ac12054ac1679141906.png\"}', '2023-02-12 10:29:55', '2023-08-10 17:41:16'),
(54, 'choose_us_two.element', '{\"has_image\":[\"1\"],\"title\":\"Live Support\",\"description\":\"Reliable 24\\/7 customer support service that\'s available to handle your queries at every given point in time.\",\"choose_img\":\"63e8e48f6140f1676207247.png\"}', '2023-02-12 10:37:27', '2023-08-10 17:39:22'),
(55, 'newsletter.content', '{\"heading\":\"Subscribe For Newsletter.\",\"subheading\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\"}', '2023-02-12 11:10:20', '2023-02-12 11:10:20'),
(56, 'work_process.content', '{\"heading\":\"How Escrow Works\",\"subheading\":\"Work Process\",\"purchaser\":\"Buyer and Seller concur\",\"goodsOrService\":\"Delivers Goods or Service to Buyer\",\"paymentToSeller\":\"Releases Payment to Seller\",\"dischargesInstallment\":\"Discharges Installment to Merchant\",\"description\":\"The word escrow by definition is a legal arrangement in which a third party temporarily holds money or property until a particular condition has been met. \\nThe disbursement of the funds or assets is dependent on conditions agreed to by the transacting parties.\",\"has_image\":\"1\",\"work_process_img\":\"64158f093e7331679134473.png\"}', '2023-02-12 11:11:31', '2023-08-10 17:36:21'),
(57, 'service_two.element', '{\"title\":\"Electronics\",\"description\":\"At the point when you focus on trading something.\",\"has_image\":[\"1\"],\"service_img\":\"63e9d73a43db81676269370.png\"}', '2023-02-13 03:52:50', '2023-02-13 03:52:50'),
(58, 'service_two.element', '{\"title\":\"Merchandise\",\"description\":\"At the point when you focus on trading something.\",\"has_image\":[\"1\"],\"service_img\":\"63e9d755677711676269397.png\"}', '2023-02-13 03:53:17', '2023-02-13 03:53:17'),
(59, 'service_two.element', '{\"title\":\"Watches Etc\",\"description\":\"At the point when you focus on trading something.\",\"has_image\":[\"1\"],\"service_img\":\"63e9d765109111676269413.png\"}', '2023-02-13 03:53:33', '2023-02-13 03:53:33'),
(60, 'faq_two.content', '{\"heading\":\"frequently asked question\",\"subheading\":\"FAQs\",\"description\":\"Here are some of the most frequently asked questions\"}', '2023-02-13 03:57:29', '2023-08-10 17:48:20'),
(61, 'faq_two.element', '{\"question\":\"#. What is crypto escrow good for?\",\"answer\":\"<p>Due to lack of trust in the crypto space and the fact that most at times crypto transferred can not be recovered. it\'s very important to always use a crypto escrow service when buying or selling anything online that involves the crypto industry.<\\/p>\"}', '2023-02-13 04:00:28', '2023-08-10 17:51:08'),
(62, 'faq_two.element', '{\"question\":\"#. How do you use escrow?\",\"answer\":\"<p>A buyer and seller have to agree to use escrow as a third party to safely observe the transaction and make sure both parties meet their respected responsibilities.\\u00a0<\\/p>\"}', '2023-02-13 04:00:42', '2023-08-10 17:54:35'),
(63, 'faq_two.element', '{\"question\":\"#. How does online escrow work?\",\"answer\":\"<p>It works by simply being the middle man among 2 individuals such as buyer and seller and ensure that they both fulfil their ends of the bargain for the transaction to go through.<\\/p>\"}', '2023-02-13 04:01:00', '2023-08-10 17:56:18'),
(64, 'faq_two.element', '{\"question\":\"#. Who uses crypto escrow services?\",\"answer\":\"<p>Anyone who wants to have a safe and secure deal including guarantee on their finances or assets will use escrow to protect their transactions<\\/p>\"}', '2023-02-13 04:01:14', '2023-08-10 17:57:50'),
(66, 'faq_two.element', '{\"question\":\"#. Does escrow refund money?\",\"answer\":\"<p>Yes, 100% . You get a refund of your deposit if the escrow transaction is no longer carried out or cancelled for one reason or the other.<\\/p>\"}', '2023-02-13 04:01:42', '2023-08-10 17:59:27'),
(67, 'testimonial_two.content', '{\"heading\":\"What do they have to say?\",\"subheading\":\"Our Testimonials\",\"description\":\"Here is what people are saying about us\"}', '2023-02-13 04:29:30', '2023-08-10 18:00:48'),
(68, 'testimonial_two.element', '{\"name\":\"Aliqua\",\"designation\":\"CEO and Founder\",\"description\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Consequuntur culpa magni, recusandae beatae provident nesciunt, quam corrupti rerum quod voluptatibus alias id!\",\"rating\":\"4\",\"has_image\":\"1\",\"client_img\":\"63e9e62869bb11676273192.png\"}', '2023-02-13 04:46:48', '2023-02-13 04:56:32'),
(69, 'testimonial_two.element', '{\"name\":\"Humble Dowson\",\"designation\":\"Head of Idea\",\"description\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Consequuntur culpa magni, recusandae beatae provident nesciunt, quam corrupti rerum quod voluptatibus alias id!\",\"rating\":\"3\",\"has_image\":\"1\",\"client_img\":\"63e9e62ed632a1676273198.png\"}', '2023-02-13 04:54:34', '2023-02-13 04:56:38'),
(70, 'testimonial_two.element', '{\"name\":\"Aliqua\",\"designation\":\"Head of Idea\",\"description\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Consequuntur culpa magni, recusandae beatae provident nesciunt, quam corrupti rerum quod voluptatibus alias id!\",\"rating\":\"5\",\"has_image\":\"1\",\"client_img\":\"63e9e636070a51676273206.png\"}', '2023-02-13 04:55:13', '2023-02-13 04:56:46'),
(71, 'blog_two.element', '{\"has_image\":[\"1\"],\"title\":\"Cryptocurrency Continues to Gain Popularity Among Investors Despite Volatility\",\"author\":\"Admin\",\"description\":\"<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p><p>\\u00a0<\\/p><p>it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p>\",\"button\":\"Read More\",\"blog_image\":\"64158ffd0c04f1679134717.png\"}', '2023-02-13 06:32:38', '2023-03-18 11:58:00'),
(72, 'blog_two.element', '{\"has_image\":[\"1\"],\"title\":\"Federal Reserve Raises Interest Rates to Combat Inflationary Pressures\",\"author\":\"Admin\",\"description\":\"<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p>\",\"button\":\"Read More\",\"blog_image\":\"64159070511721679134832.png\"}', '2023-02-13 06:33:27', '2023-03-18 11:47:13'),
(73, 'partner.content', '{\"heading\":\"Our Payment Partners\",\"subheading\":\"Who We Are With\",\"description\":\"Data transfer capacity has generally been inconsistent dispersed around the world, with expanding focus in the advanced age just 10 nations have facilitated\"}', '2023-02-13 06:48:15', '2023-03-18 12:03:28'),
(88, 'social_icon.element', '{\"title\":\"Twitter\",\"social_icon\":\"<i class=\\\"fab fa-twitter\\\"><\\/i>\",\"url\":\"https:\\/\\/www.twitter.com\"}', '2023-03-18 09:34:43', '2025-03-19 08:51:56'),
(89, 'social_icon.element', '{\"title\":\"Youtube\",\"social_icon\":\"<i class=\\\"fab fa-youtube\\\"><\\/i>\",\"url\":\"https:\\/\\/www.youtube.com\"}', '2023-03-18 09:34:58', '2025-03-19 08:52:15'),
(90, 'social_icon.element', '{\"title\":\"Instagram\",\"social_icon\":\"<i class=\\\"fab fa-instagram\\\"><\\/i>\",\"url\":\"https:\\/\\/www.instagram.com\\/\"}', '2023-03-18 09:35:16', '2025-03-19 08:53:08'),
(91, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccc269a3e1679150274.png\"}', '2023-03-18 12:07:54', '2023-03-18 12:07:54'),
(92, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccc7d0ad01679150279.png\"}', '2023-03-18 12:07:59', '2023-03-18 12:07:59'),
(93, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccd8075241679150296.png\"}', '2023-03-18 12:08:16', '2023-03-18 12:08:16'),
(94, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415cce55444e1679150309.png\"}', '2023-03-18 12:08:29', '2023-03-18 12:08:29'),
(95, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccea4e2a01679150314.png\"}', '2023-03-18 12:08:34', '2023-03-18 12:08:34'),
(96, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccf7170e31679150327.png\"}', '2023-03-18 12:08:47', '2023-03-18 12:08:47'),
(97, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccfb4dedb1679150331.png\"}', '2023-03-18 12:08:51', '2023-03-18 12:08:51'),
(98, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415ccff642a01679150335.png\"}', '2023-03-18 12:08:55', '2023-03-18 12:08:55'),
(99, 'partner.element', '{\"has_image\":[\"1\"],\"partner_img\":\"6415cd03ce47a1679150339.png\"}', '2023-03-18 12:08:59', '2023-03-18 12:08:59'),
(100, 'faq_two.element', '{\"question\":\"fa\",\"answer\":\"<p>dcdscds<\\/p>\"}', '2023-08-10 18:22:12', '2023-08-10 18:22:12'),
(102, 'banner_one.content', '{\"heading\":\"Secure Crypto Escrow Services for Online Transactions\",\"subheading\":\"Our Escrow system ensures secure online transactions, protecting buyers and sellers from fraud and payment disputes. Our payment process is reliable, providing swift and efficient transaction.\",\"button_one\":\"Get Start Now\",\"button_one_url\":\"https:\\/\\/codecanyon.net\\/user\\/wstacks\",\"button_two\":\"Discover More\",\"button_two_url\":\"https:\\/\\/codecanyon.net\\/user\\/wstacks\",\"has_image\":\"1\",\"image\":\"67da9432201aa1742378034.png\"}', '2025-02-13 08:04:33', '2025-03-24 07:59:06'),
(103, 'header_links.element', '{\"name\":\"Home\",\"slug\":\"\\/\"}', NULL, NULL),
(105, 'header_links.element', '{\"name\":\"About\",\"slug\":\"\\/about\"}', NULL, NULL),
(106, 'header_links.element', '{\"name\":\"Blog\",\"slug\":\"\\/blog\"}', NULL, NULL),
(107, 'header_links.element', '{\"name\":\"Contact\",\"slug\":\"\\/contact\"}', NULL, NULL),
(108, 'footer_company_links.element', '{\"title\":\"Blog\",\"url\":\"\\/blog\"}', NULL, '2025-02-16 12:12:15'),
(109, 'footer_company_links.element', '{\"title\":\"About\",\"url\":\"\\/about\"}', NULL, '2025-02-16 12:12:32'),
(110, 'footer_company_links.element', '{\"title\":\"Contact\",\"url\":\"\\/contact\"}', NULL, '2025-02-16 12:12:59'),
(113, 'about_one.content', '{\"has_image\":\"1\",\"title\":\"ABOUT US\",\"heading\":\"Trust your transactions with us - Safe, Secure, and Efficient!\",\"description\":\"<p>Safety Escrow is Leading Crypto Escrow Service with over 5000+ satisfied customers worldwide.\\u00a0<\\/p>\",\"about_image\":\"67b1ff4316adf1739718467.png\"}', '2025-02-16 12:37:47', '2025-03-19 08:18:40'),
(114, 'about_one.element', '{\"icon\":\"<i class=\\\"fas fa-shield-alt\\\"><\\/i>\",\"heading\":\"Safe and secure transactions\",\"subheading\":\"Escrow is chosen as the payment method, either through a third party (e.g., bank) or a platform\\u2019s built-in system.\"}', '2025-02-16 12:38:43', '2025-03-19 08:09:25'),
(115, 'about_one.element', '{\"icon\":\"<i class=\\\"fas fa-laptop-code\\\"><\\/i>\",\"heading\":\"Protecting both buyers and sellers\",\"subheading\":\"Both sides flag fees as a sore spot. \\u201cGreat service, but why am I paying extra to not get ripped off?\\u201d a buyer might tweet. Dispute resolution splits opinions hard.\"}', '2025-02-16 12:39:28', '2025-03-19 08:08:07'),
(116, 'about_one.element', '{\"icon\":\"<i class=\\\"fas fa-user\\\"><\\/i>\",\"heading\":\"Low cost fee\",\"subheading\":\"We have one of the lowest fee per Escrow transaction as compared to the other crypto escrow companies.\"}', '2025-02-16 12:40:02', '2025-03-19 08:06:55'),
(117, 'service_one.content', '{\"heading\":\"Our Services\",\"subheading\":\"Crypto escrow services | Escrow for cryptocurrency\",\"description\":\"Looking for the best crypto escrow? Safety Escrow comes among the best crypto escrow services for the following reasons Trust, Security,Dispute resolution, support, convenience.\"}', '2025-02-17 05:03:20', '2025-03-19 07:25:27'),
(118, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Property\",\"description\":\"Property is one of those ideas that\\u2019s both simple and endlessly complex. At its core, it\\u2019s something you own\\u2014a house, a patch of land, a car, even a phone. Tangible or not, it\\u2019s yours to use, sell, or cherish. Real estate is what most people picture: a cozy suburban home with a picket fence, a sleek city condo, or a sprawling farm with rolling fields.\",\"image\":\"67b2fa818dbad1739782785.gif\"}', '2025-02-17 05:54:06', '2025-03-19 07:37:28'),
(119, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Browse\",\"description\":\"Browsing is a modern ritual, a digital dance we do daily without much thought. Picture it: you open a browser\\u2014maybe Chrome, Firefox, or Safari\\u2014and dive into the vast ocean of the internet. It starts with a simple search, a question, or just curiosity. One click leads to a news article, then a video, then a random forum thread about conspiracy theories or cat memes.\",\"image\":\"67b2f7b5864471739782069.gif\"}', '2025-02-17 05:54:38', '2025-03-19 07:36:09'),
(120, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Home\",\"description\":\"Home is more than just a physical space; it\\u2019s a concept woven into the fabric of human experience. For some, it\\u2019s a cozy house filled with the smell of fresh-baked bread, laughter echoing through the halls, and a sense of safety that wraps around you like a blanket.\",\"image\":\"67b2f7f67379d1739782134.gif\"}', '2025-02-17 05:55:14', '2025-03-19 07:35:19'),
(121, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Shipping\",\"description\":\"Shipping, in the context of transporting goods, is a cornerstone of global trade and modern life. Every day, massive cargo ships, trucks, and planes move products across continents and oceans, delivering everything from food to electronics.\",\"image\":\"67b2f87559ff91739782261.gif\"}', '2025-02-17 05:55:32', '2025-03-19 07:34:49'),
(122, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Global\",\"description\":\"The world today is more interconnected than ever, with global issues shaping our lives in profound ways. Climate change, for instance, transcends borders, affecting ecosystems, economies, and communities worldwide.\",\"image\":\"67b2f8839a8861739782275.gif\"}', '2025-02-17 05:55:53', '2025-03-19 07:34:07'),
(123, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Player\",\"description\":\"They bring energy, strategy, and personality to the table, turning rules and objectives into dynamic experiences. Whether it\\u2019s an athlete mastering their craft on the field, a gamer navigating virtual worlds with precision, or a team member collaborating for victory, players define the action. Their skills, dedication, and adaptability often set the stage for unforgettable moments\\u2014think of a clutch play in the final seconds or a creative move that shifts the tide.\",\"image\":\"67b2f8905bce21739782288.gif\"}', '2025-02-17 05:56:17', '2025-03-19 07:31:56'),
(124, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Services\",\"description\":\"Services play a vital role in connecting people, businesses, and communities. From everyday essentials like healthcare and transportation to specialized offerings such as consulting or digital solutions, they\\u2019re designed to meet needs and solve problems. What makes services stand out is their focus on experience\\u2014quality, accessibility, and reliability often define their value.\",\"image\":\"67b2f89f2e7db1739782303.gif\"}', '2025-02-17 05:56:37', '2025-03-19 07:31:23'),
(125, 'service_one.element', '{\"has_image\":\"1\",\"title\":\"Skills\",\"description\":\"Skills are the backbone of personal and professional growth. Whether it\\u2019s mastering a technical craft like coding, honing creative abilities such as writing or design, or developing soft skills like communication and problem-solving, they shape how we navigate the world.\",\"image\":\"67b2f8a981d951739782313.gif\"}', '2025-02-17 05:56:52', '2025-03-19 07:30:32'),
(126, 'working_process.content', '{\"heading\":\"Working Process\",\"subheading\":\"How The Escrow Process Works\",\"description\":\"The word escrow by definition is a legal arrangement in which a third party temporarily holds money or property until a particular condition has been met.\"}', '2025-02-17 06:41:49', '2025-03-19 07:41:03'),
(127, 'working_process.element', '{\"icon\":\"<i class=\\\"fas fa-user-cog\\\"><\\/i>\",\"title\":\"Buyer and seller agree\",\"description\":\"The moment a buyer and seller agree is the spark that sets a transaction in motion\\u2014it\\u2019s the handshake, virtual or otherwise, where both say, \\u201cYes, let\\u2019s do this.\\u201d It\\u2019s about aligning on terms: what\\u2019s being exchanged, for how much, and under what conditions.\"}', '2025-02-17 06:42:36', '2025-03-19 07:44:48'),
(128, 'working_process.element', '{\"icon\":\"<i class=\\\"far fa-paper-plane\\\"><\\/i>\",\"title\":\"Submits Payment to Escrow\",\"description\":\"Submitting payment to escrow is a trust-building step in transactions where neither buyer nor seller wants to take a leap of faith alone. It\\u2019s like handing your money to a neutral referee who holds it until everyone\\u2019s played their part.\"}', '2025-02-17 06:43:12', '2025-03-19 07:43:59'),
(129, 'working_process.element', '{\"icon\":\"<i class=\\\"fas fa-cube\\\"><\\/i>\",\"title\":\"Delivers Goods or Service to Buyer\",\"description\":\"It seems you\\u2019re asking me to write about the process of delivering goods or services to a buyer, likely as part of a transaction. Since your input is a concise phrase, I\\u2019ll assume you want a general overview of how this works across common contexts like e-commerce, service-based businesses, or physical sales.\"}', '2025-02-17 06:43:59', '2025-03-19 07:42:52'),
(130, 'working_process.element', '{\"icon\":\"<i class=\\\"far fa-credit-card\\\"><\\/i>\",\"title\":\"Releases Payment to Seller\",\"description\":\"Specific context like a transaction, platform, or escrow system. Since your request is a bit vague, I\\u2019ll provide a general explanation of how payment is typically released to a seller in common scenarios, such as online marketplaces, real estate, or peer-to-peer transactions. If you had a particular situation in mind, please let me know so I can tailor the response further!\"}', '2025-02-17 06:44:21', '2025-03-19 07:45:41'),
(131, 'choose_us_one.content', '{\"heading\":\"Why Choose us\",\"subheading\":\"Trustworthy and Secure System\",\"description\":\"Safety Escrow offers legitimate trustworthy and secure experience for both buyers and sellers in the crypto industry. Using Safety Escrow guarantees 100% protection. You also get to pay very minimal fees on all your escrow transactions. Fast 24\\/7 customer support and very easy and friendly user interface.\",\"has_image\":\"1\",\"image\":\"67b306c4ac5b51739785924.png\"}', '2025-02-17 07:22:04', '2025-03-19 08:16:15'),
(132, 'choose_us_one.element', '{\"icon\":\"<i class=\\\"fas fa-headphones\\\"><\\/i>\",\"title\":\"Live Support\",\"description\":\"Reliable 24\\/7 customer support service that\'s available to handle your queries at every given point in time.\"}', '2025-02-17 07:42:01', '2025-03-19 08:16:44'),
(133, 'choose_us_one.element', '{\"icon\":\"<i class=\\\"fas fa-coins\\\"><\\/i>\",\"title\":\"Low cost fee\",\"description\":\"We have one of the lowest fee per Escrow transaction as compared to the other crypto escrow companies.\"}', '2025-02-17 07:42:26', '2025-03-19 08:17:36'),
(134, 'choose_us_one.element', '{\"icon\":\"<i class=\\\"fas fa-user-check\\\"><\\/i>\",\"title\":\"User Friendly\",\"description\":\"Our top notch user friendly interface allows you to open your escrow transactions effortlessly in just few clicks.\"}', '2025-02-17 07:42:47', '2025-03-19 08:18:07'),
(135, 'working_map.content', '{\"heading\":\"Working Map\",\"subheading\":\"How The Escrow Process Works\",\"description\":\"I\\u2019ll assume you want a clear, concise breakdown of the escrow process as a sort of \\\"map\\\" or sequence.\"}', '2025-02-17 08:12:30', '2025-03-19 07:47:38'),
(136, 'faq_one.content', '{\"heading\":\"Faq\",\"subheading\":\"Frequently Asked Question\",\"description\":\"Here are some of the most frequently asked questions\",\"has_image\":\"1\",\"image\":\"67b327c5cd0671739794373.png\"}', '2025-02-17 08:39:38', '2025-03-19 07:55:46'),
(137, 'faq_one.element', '{\"question\":\"FAQ\",\"answer\":\"<p>Due to lack of trust in the crypto space and the fact that most at times crypto transferred can not be recovered. it\'s very important to always use a crypto escrow service when buying or selling anything online that involves the crypto industry.<\\/p>\"}', '2025-02-17 08:40:46', '2025-03-19 07:56:42'),
(138, 'faq_one.element', '{\"question\":\"How do you use escrow?\",\"answer\":\"<p>A buyer and seller have to agree to use escrow as a third party to safely observe the transaction and make sure both parties meet their respected responsibilities.\\u00a0<\\/p>\"}', '2025-02-17 08:41:08', '2025-03-19 07:57:21'),
(139, 'faq_one.element', '{\"question\":\"Does escrow refund money?\",\"answer\":\"<p>Yes, 100% . You get a refund of your deposit if the escrow transaction is no longer carried out or cancelled for one reason or the other.<\\/p>\"}', '2025-02-17 08:41:27', '2025-03-19 07:57:54'),
(140, 'faq_one.element', '{\"question\":\"How does online escrow work?\",\"answer\":\"<p>It works by simply being the middle man among 2 individuals such as buyer and seller and ensure that they both fulfil their ends of the bargain for the transaction to go through.<\\/p>\"}', '2025-02-17 08:41:44', '2025-03-19 07:58:29'),
(141, 'faq_one.element', '{\"question\":\"What is crypto escrow good for?\",\"answer\":\"<p>Due to lack of trust in the crypto space and the fact that most at times crypto transferred can not be recovered. it\'s very important to always use a crypto escrow service when buying or selling anything online that involves the crypto industry.<\\/p>\"}', '2025-02-17 08:42:00', '2025-03-19 07:59:15'),
(142, 'faq_one.element', '{\"question\":\"How To Exchange Currency?\",\"answer\":\"<p>CPM advertising charges advertisers for every 1,000 impressions their ad receives, regardless of whether users click on it or not. It is particularly useful for brand awareness campaigns and reaching a broad audience.<\\/p>\"}', '2025-02-17 08:42:14', '2025-02-17 08:42:14'),
(143, 'testimonial_one.content', '{\"heading\":\"Testimonials\",\"subheading\":\"Our Client Feedback\",\"description\":\"Clients using escrow services often have a mix of praise and gripes, depending on how smooth their deal goes. Buyers tend to love the security.\"}', '2025-02-17 09:50:21', '2025-03-19 08:01:15'),
(144, 'testimonial_one.element', '{\"name\":\"Esther Howard\",\"location\":\"Publishers, USA\",\"description\":\"Great service, but why am I paying extra to not get ripped off?\\u201d a buyer might tweet. Dispute resolution splits opinions hard.\",\"has_image\":\"1\",\"client_img\":\"67b32a28d3f3b1739794984.png\"}', '2025-02-17 09:53:04', '2025-03-19 08:02:06'),
(145, 'testimonial_one.element', '{\"name\":\"Martin Ban\",\"location\":\"America,USA\",\"description\":\"\\u201cIt is a long established fact thadistracted by the readable content of a pawhlooking at its layout. The point of using LoremIpsm is that it has a more\\u201d\",\"has_image\":\"1\",\"client_img\":\"67b32b72a26a11739795314.png\"}', '2025-02-17 09:55:13', '2025-02-17 10:08:13'),
(146, 'testimonial_one.element', '{\"name\":\"Rais Din\",\"location\":\"Maxlin, Canada\",\"description\":\"Happy clients say, \\u201cEscrow ruled in my favor when the item was fake\\u2014got my refund fast.\\u201d Others fume: \\u201cSeller sent junk, but escrow sided with them because of a blurry tracking pic\\u2014useless.\",\"has_image\":\"1\",\"client_img\":\"67b32b0c5b7291739795212.png\"}', '2025-02-17 09:56:52', '2025-03-19 08:02:59'),
(147, 'testimonial_one.element', '{\"name\":\"Apens\",\"location\":\"London, UK\",\"description\":\"Overall, feedback paints escrow as a trusty middleman when it\\u2019s seamless\\u2014buyers feel protected, sellers feel paid. But hiccups in timing, disputes, or costs spark frustration. \\u201cIt\\u2019s like insurance,\\u201d a client might sum up online,\",\"has_image\":\"1\",\"client_img\":\"67b32b4ed96731739795278.png\"}', '2025-02-17 09:57:58', '2025-03-19 08:03:15'),
(148, 'testimonial_one.element', '{\"name\":\"Roin\",\"location\":\"Maxlin, Spain\",\"description\":\"Sellers, though, have a split view. When it works, they\\u2019re fans: \\u201cSold a laptop on eBay, escrow paid me two days after delivery\\u2014no chargebacks, no stress,\\u201d a small seller might note.\",\"has_image\":\"1\",\"client_img\":\"67b32b6325b481739795299.png\"}', '2025-02-17 09:58:19', '2025-03-19 08:03:47'),
(149, 'blog_one.content', '{\"heading\":\"Blog\",\"subheading\":\"Our Blogs\",\"description\":\"The word escrow by definition is a legal arrangement in which a third party temporarily holds money or property until a particular condition has been met.\"}', '2025-02-17 10:49:49', '2025-03-19 08:21:45');
INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `created_at`, `updated_at`) VALUES
(150, 'blog_one.element', '{\"has_image\":[\"1\"],\"title\":\"Cryptocurrency Continues to Gain Popularity Among Investors Despite Volatility\",\"author\":\"Jenny Wilson\",\"description\":\"<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p><p>\\u00a0<\\/p><p>it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident<\\/p><p>\\u00a0<\\/p><p>Corporate earnings tell a similar story. S&amp;P 500 companies posted double-digit profit growth in Q1 2025, with standouts in AI-driven tech firms and banks benefiting from a dealmaking revival. The \\u201cMagnificent 7\\u201d mega-caps\\u2014think Nvidia, Microsoft, and Amazon\\u2014have regained momentum, while small-cap stocks, proxies for broader economic health, are finally catching up. This rally isn\\u2019t just a tech tale; it\\u2019s broadening, a sign of deeper economic strength.<\\/p>\",\"blog_image\":\"67d7f0f347b5e1742205171.jpg\"}', '2025-02-17 10:56:31', '2025-03-19 08:45:24'),
(151, 'blog_one.element', '{\"has_image\":[\"1\"],\"title\":\"Stock Market Reaches All-Time High Amid Strong Economic Growth\",\"author\":\"Balon Tax\",\"description\":\"<p>The stock market has soared to an all-time high, riding a wave of robust economic growth that\\u2019s defied earlier uncertainties. As of mid-March 2025, investors are cheering a confluence of factors: strong corporate earnings, cooling inflation, and a resilient economy that\\u2019s outpacing expectations. The S&amp;P 500, a key benchmark, has shattered previous records, climbing past its December 2024 peak, with sectors like technology, financials, and consumer goods leading the charge. This milestone reflects a broader narrative of optimism\\u2014businesses are thriving, consumers are spending, and the U.S. economy is flexing its muscle.<\\/p><p>\\u00a0<\\/p><p>Why the hike? The Fed\\u2019s dual mandate\\u2014maximum employment and stable prices\\u2014feels the heat when inflation outpaces the 2% target. Strong economic growth, with GDP chugging along at 2.5%-3%, and a tight labor market (unemployment at 4% or below) give the central bank room to tighten. Consumer spending\\u2019s still robust, and wage growth\\u2014say, 4% annually\\u2014keeps fanning demand. But it\\u2019s the tariff talk that\\u2019s got analysts buzzing. If new trade policies jack up costs for goods like electronics or steel, inflation could stickier than the Fed\\u2019s comfortable with. Posts on X might note, \\u201cTariffs are back, and so are price hikes\\u2014Fed had no choice.\\u201d<\\/p><p>\\u00a0<\\/p><p>The mechanics are classic: higher rates make borrowing pricier. Mortgages jump\\u201430-year rates might hit 5%\\u2014cooling the housing market. Businesses rethink expansion when loans cost more, and consumers tighten belts on credit-fueled splurges. The S&amp;P 500 might wobble, dropping 2-3% post-announcement, as investors fret over slower growth. Yet, the Fed\\u2019s not blind to risks. Chair Jerome Powell, in a presser, might say, \\u201cWe\\u2019re acting now to keep inflation anchored, but we\\u2019re data-driven\\u2014recession\\u2019s not our goal.\\u201d Critics argue it\\u2019s overkill\\u2014growth could stall if rates climb too fast, especially with global uncertainty.<\\/p>\",\"blog_image\":\"67d7f0e2cae741742205154.jpg\"}', '2025-02-17 10:57:14', '2025-03-19 08:44:02'),
(152, 'blog_one.element', '{\"has_image\":[\"1\"],\"title\":\"Federal Reserve Raises Interest Rates to Combat Inflationary Pressures\",\"author\":\"Tony jion\",\"description\":\"<p>The Federal Reserve has raised interest rates again, a bold move to wrestle down inflationary pressures that have crept back into the economy as of March 19, 2025. With the federal funds rate now climbing\\u2014let\\u2019s say to a range of 4.5%-4.75% from 4.25%-4.5%\\u2014the Fed is signaling it\\u2019s not ready to let price stability slip. This hike, perhaps announced at the March 18-19 FOMC meeting, reflects a shift from the cautious pause investors expected after 2024\\u2019s rate cuts. Inflation, which had eased to 2.3% earlier this year, ticked up\\u2014maybe to 2.8% or 3%\\u2014spurred by renewed supply chain snags and Trump-era tariffs biting into import costs.<\\/p><p>\\u00a0<\\/p><p>Yet, it\\u2019s not all smooth sailing. Trump-era tariffs, reintroduced in early 2025, briefly rattled markets, with fears of trade wars denting global sentiment. But swift negotiations\\u2014particularly with Canada and Mexico\\u2014have softened the blow, keeping supply chains intact. Investors have shrugged off these hiccups, betting on U.S. exceptionalism as Europe and China lag. Volatility spiked in February, with the S&amp;P 500 dipping 10% from its peak, but the recovery was swift, underpinned by faith in long-term growth.<\\/p><p>\\u00a0<\\/p><p>Sentiment on platforms like X reflects this bullish vibe. Posts tout \\u201c17% growth\\u201d (likely exaggerated) or herald the market\\u2019s resilience, though some warn of overvaluation\\u2014P\\/E ratios are stretching past historical norms. Still, the consensus leans positive: a strong economy, supportive policy, and corporate vigor are a potent mix. As one trader might put it, \\u201cThis isn\\u2019t a bubble\\u2014it\\u2019s a breakthrough.\\u201d Whether this high holds depends on the Fed\\u2019s next moves and global stability, but for now, the market\\u2019s riding high on America\\u2019s economic roar.<\\/p>\",\"blog_image\":\"67d7f0ae041571742205102.png\"}', '2025-02-17 10:58:05', '2025-03-19 08:44:55'),
(153, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33d6b4f7eb1739799915.png\"}', '2025-02-17 11:15:15', '2025-02-17 11:15:15'),
(154, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33ee6cf2b71739800294.png\"}', '2025-02-17 11:15:18', '2025-02-17 11:21:34'),
(155, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33d722a8411739799922.png\"}', '2025-02-17 11:15:22', '2025-02-17 11:15:22'),
(156, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33d7831d3c1739799928.png\"}', '2025-02-17 11:15:28', '2025-02-17 11:15:28'),
(157, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33ece76e621739800270.png\"}', '2025-02-17 11:15:36', '2025-02-17 11:21:10'),
(158, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33d82d429e1739799938.png\"}', '2025-02-17 11:15:38', '2025-02-17 11:15:38'),
(159, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f2c3fae51739800364.png\"}', '2025-02-17 11:22:44', '2025-02-17 11:22:44'),
(160, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f30b09541739800368.png\"}', '2025-02-17 11:22:48', '2025-02-17 11:22:48'),
(161, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f33ea33c1739800371.png\"}', '2025-02-17 11:22:51', '2025-02-17 11:22:51'),
(162, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f37a5e731739800375.png\"}', '2025-02-17 11:22:55', '2025-02-17 11:22:55'),
(163, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f69f228f1739800425.png\"}', '2025-02-17 11:23:45', '2025-02-17 11:23:45'),
(164, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f6ea70631739800430.png\"}', '2025-02-17 11:23:50', '2025-02-17 11:23:50'),
(165, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f7203dc01739800434.png\"}', '2025-02-17 11:23:54', '2025-02-17 11:23:54'),
(166, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f772fffd1739800439.png\"}', '2025-02-17 11:23:59', '2025-02-17 11:23:59'),
(167, 'marque.element', '{\"has_image\":[\"1\"],\"image\":\"67b33f7c072df1739800444.png\"}', '2025-02-17 11:24:04', '2025-02-17 11:24:04'),
(168, 'contact_us_one.content', '{\"contact_number\":\"0004785 8785\",\"description\":\"Eskrow is a secure financial arrangement in which third party holds funds, assets, or documents on behalf of two parties involved in a transaction.\",\"email_address\":\"demo@gmail.com\",\"address\":\"London city,B2\\/145\",\"support_team\":\"999555888\",\"button_name\":\"Send Message\",\"text\":\"Send Your Message\",\"latitude\":\"47.3775366\",\"longitude\":\"8.466696\",\"copyright_text\":\"<p>\\u00a9 Copyright 2024 . All rights reserved.<\\/p>\"}', '2025-02-17 13:30:12', '2025-03-17 07:33:38'),
(169, 'subscribe.content', '{\"heading\":\"Join Our Newsletter &amp; Get Updated.\",\"has_image\":\"1\",\"subheading\":\"We only send interesting and relevant emails.\",\"button_name\":\"Subscribe\",\"icon\":\"<i class=\\\"far fa-paper-plane\\\"><\\/i>\",\"image\":\"67b7209e510881740054686.png\"}', '2025-02-20 09:20:31', '2025-02-20 10:01:26'),
(170, 'footer_important_links.element', '{\"title\":\"Home\",\"url\":\"\\/\"}', '2025-02-22 07:46:36', '2025-02-22 07:47:40'),
(171, 'footer_important_links.element', '{\"title\":\"About\",\"url\":\"\\/about\"}', '2025-02-22 07:47:01', '2025-02-22 07:47:51'),
(172, 'footer_important_links.element', '{\"title\":\"Contact\",\"url\":\"\\/contact\"}', '2025-02-22 07:47:23', '2025-02-22 07:47:23'),
(173, 'footer_important_links_two.element', '{\"title\":\"Home\",\"url\":\"\\/\"}', '2025-02-22 07:46:36', '2025-02-22 07:47:40'),
(174, 'footer_important_links_two.element', '{\"title\":\"About\",\"url\":\"\\/about\"}', '2025-02-22 07:47:01', '2025-02-22 07:47:51'),
(175, 'footer_important_links_two.element', '{\"title\":\"Contact\",\"url\":\"\\/contact\"}', '2025-02-22 07:47:23', '2025-02-22 07:47:23');

-- --------------------------------------------------------

--
-- Table structure for table `gateways`
--

CREATE TABLE `gateways` (
  `id` bigint UNSIGNED NOT NULL,
  `form_id` int UNSIGNED NOT NULL DEFAULT '0',
  `code` int DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NULL',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>enable, 2=>disable',
  `gateway_parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `supported_currencies` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `crypto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: fiat currency, 1: crypto currency',
  `extra` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gateways`
--

INSERT INTO `gateways` (`id`, `form_id`, `code`, `name`, `alias`, `status`, `gateway_parameters`, `supported_currencies`, `crypto`, `extra`, `description`, `created_at`, `updated_at`) VALUES
(1, 0, 101, 'Paypal', 'Paypal', 1, '{\"paypal_email\":{\"title\":\"PayPal Email\",\"global\":true,\"value\":\"sb-58ira22618401@business.example.com\"}}', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2023-03-21 09:37:24'),
(2, 0, 102, 'Perfect Money', 'PerfectMoney', 0, '{\"passphrase\":{\"title\":\"ALTERNATE PASSPHRASE\",\"global\":true,\"value\":\"---------------------\"},\"wallet_id\":{\"title\":\"PM Wallet\",\"global\":false,\"value\":\"\"}}', '{\"USD\":\"$\",\"EUR\":\"\\u20ac\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2023-08-11 01:46:56'),
(3, 0, 105, 'PayTM', 'Paytm', 1, '{\"MID\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"-----------\"},\"merchant_key\":{\"title\":\"Merchant Key\",\"global\":true,\"value\":\"--------------------\"},\"WEBSITE\":{\"title\":\"Paytm Website\",\"global\":true,\"value\":\"example.com\"},\"INDUSTRY_TYPE_ID\":{\"title\":\"Industry Type\",\"global\":true,\"value\":\"Retail\"},\"CHANNEL_ID\":{\"title\":\"CHANNEL ID\",\"global\":true,\"value\":\"WEB\"},\"transaction_url\":{\"title\":\"Transaction URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/oltp-web\\/processTransaction\"},\"transaction_status_url\":{\"title\":\"Transaction STATUS URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/paytmchecksum\\/paytmCallback.jsp\"}}', '{\"AUD\":\"AUD\",\"ARS\":\"ARS\",\"BDT\":\"BDT\",\"BRL\":\"BRL\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"GEL\":\"GEL\",\"GHS\":\"GHS\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"NGN\":\"NGN\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"UGX\":\"UGX\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"GBP\":\"GBP\",\"USD\":\"USD\",\"VND\":\"VND\",\"XOF\":\"XOF\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2022-11-26 08:10:37'),
(4, 0, 107, 'PayStack', 'Paystack', 1, '{\"public_key\":{\"title\":\"Public key\",\"global\":true,\"value\":\"--------\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"----------------\"}}', '{\"USD\":\"USD\",\"NGN\":\"NGN\"}', 0, '{\"callback\":{\"title\": \"Callback URL\",\"value\":\"ipn.Paystack\"},\"webhook\":{\"title\": \"Webhook URL\",\"value\":\"ipn.Paystack\"}}\r\n', NULL, '2019-09-14 13:14:22', '2022-11-26 07:49:18'),
(5, 0, 108, 'VoguePay', 'Voguepay', 0, '{\"merchant_id\":{\"title\":\"MERCHANT ID\",\"global\":true,\"value\":\"-------------------\"}}', '{\"USD\":\"USD\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"ZAR\":\"ZAR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2023-08-11 01:46:48'),
(6, 0, 109, 'Flutterwave', 'Flutterwave', 1, '{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"----------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------------------\"},\"encryption_key\":{\"title\":\"Encryption Key\",\"global\":true,\"value\":\"------------------\"}}', '{\"BIF\":\"BIF\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CVE\":\"CVE\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"GHS\":\"GHS\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"KES\":\"KES\",\"LRD\":\"LRD\",\"MWK\":\"MWK\",\"MZN\":\"MZN\",\"NGN\":\"NGN\",\"RWF\":\"RWF\",\"SLL\":\"SLL\",\"STD\":\"STD\",\"TZS\":\"TZS\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"XAF\":\"XAF\",\"XOF\":\"XOF\",\"ZMK\":\"ZMK\",\"ZMW\":\"ZMW\",\"ZWD\":\"ZWD\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2021-06-05 11:37:45'),
(7, 0, 110, 'RazorPay', 'Razorpay', 0, '{\"key_id\":{\"title\":\"Key Id\",\"global\":true,\"value\":\"------------\"},\"key_secret\":{\"title\":\"Key Secret \",\"global\":true,\"value\":\"--------\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2023-08-11 01:46:52'),
(8, 0, 112, 'Instamojo', 'Instamojo', 1, '{\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"------------\"},\"auth_token\":{\"title\":\"Auth Token\",\"global\":true,\"value\":\"---------\"},\"salt\":{\"title\":\"Salt\",\"global\":true,\"value\":\"-------\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2022-11-26 08:00:15'),
(9, 0, 503, 'CoinPayments', 'Coinpayments', 1, '{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"---------------\"},\"private_key\":{\"title\":\"Private Key\",\"global\":true,\"value\":\"------------\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"----------------\"}}', '{\"BTC\":\"Bitcoin\",\"BTC.LN\":\"Bitcoin (Lightning Network)\",\"LTC\":\"Litecoin\",\"CPS\":\"CPS Coin\",\"VLX\":\"Velas\",\"APL\":\"Apollo\",\"AYA\":\"Aryacoin\",\"BAD\":\"Badcoin\",\"BCD\":\"Bitcoin Diamond\",\"BCH\":\"Bitcoin Cash\",\"BCN\":\"Bytecoin\",\"BEAM\":\"BEAM\",\"BITB\":\"Bean Cash\",\"BLK\":\"BlackCoin\",\"BSV\":\"Bitcoin SV\",\"BTAD\":\"Bitcoin Adult\",\"BTG\":\"Bitcoin Gold\",\"BTT\":\"BitTorrent\",\"CLOAK\":\"CloakCoin\",\"CLUB\":\"ClubCoin\",\"CRW\":\"Crown\",\"CRYP\":\"CrypticCoin\",\"CRYT\":\"CryTrExCoin\",\"CURE\":\"CureCoin\",\"DASH\":\"DASH\",\"DCR\":\"Decred\",\"DEV\":\"DeviantCoin\",\"DGB\":\"DigiByte\",\"DOGE\":\"Dogecoin\",\"EBST\":\"eBoost\",\"EOS\":\"EOS\",\"ETC\":\"Ether Classic\",\"ETH\":\"Ethereum\",\"ETN\":\"Electroneum\",\"EUNO\":\"EUNO\",\"EXP\":\"EXP\",\"Expanse\":\"Expanse\",\"FLASH\":\"FLASH\",\"GAME\":\"GameCredits\",\"GLC\":\"Goldcoin\",\"GRS\":\"Groestlcoin\",\"KMD\":\"Komodo\",\"LOKI\":\"LOKI\",\"LSK\":\"LSK\",\"MAID\":\"MaidSafeCoin\",\"MUE\":\"MonetaryUnit\",\"NAV\":\"NAV Coin\",\"NEO\":\"NEO\",\"NMC\":\"Namecoin\",\"NVST\":\"NVO Token\",\"NXT\":\"NXT\",\"OMNI\":\"OMNI\",\"PINK\":\"PinkCoin\",\"PIVX\":\"PIVX\",\"POT\":\"PotCoin\",\"PPC\":\"Peercoin\",\"PROC\":\"ProCurrency\",\"PURA\":\"PURA\",\"QTUM\":\"QTUM\",\"RES\":\"Resistance\",\"RVN\":\"Ravencoin\",\"RVR\":\"RevolutionVR\",\"SBD\":\"Steem Dollars\",\"SMART\":\"SmartCash\",\"SOXAX\":\"SOXAX\",\"STEEM\":\"STEEM\",\"STRAT\":\"STRAT\",\"SYS\":\"Syscoin\",\"TPAY\":\"TokenPay\",\"TRIGGERS\":\"Triggers\",\"TRX\":\" TRON\",\"UBQ\":\"Ubiq\",\"UNIT\":\"UniversalCurrency\",\"USDT\":\"Tether USD (Omni Layer)\",\"USDT.BEP20\":\"Tether USD (BSC Chain)\",\"USDT.ERC20\":\"Tether USD (ERC20)\",\"USDT.TRC20\":\"Tether USD (Tron/TRC20)\",\"VTC\":\"Vertcoin\",\"WAVES\":\"Waves\",\"XCP\":\"Counterparty\",\"XEM\":\"NEM\",\"XMR\":\"Monero\",\"XSN\":\"Stakenet\",\"XSR\":\"SucreCoin\",\"XVG\":\"VERGE\",\"XZC\":\"ZCoin\",\"ZEC\":\"ZCash\",\"ZEN\":\"Horizen\"}', 1, NULL, NULL, '2019-09-14 13:14:22', '2023-08-11 01:39:42'),
(10, 0, 506, 'Coinbase Commerce', 'CoinbaseCommerce', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"---------\"},\"secret\":{\"title\":\"Webhook Shared Secret\",\"global\":true,\"value\":\"----------------\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\",\"JPY\":\"JPY\",\"GBP\":\"GBP\",\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CNY\":\"CNY\",\"SEK\":\"SEK\",\"NZD\":\"NZD\",\"MXN\":\"MXN\",\"SGD\":\"SGD\",\"HKD\":\"HKD\",\"NOK\":\"NOK\",\"KRW\":\"KRW\",\"TRY\":\"TRY\",\"RUB\":\"RUB\",\"INR\":\"INR\",\"BRL\":\"BRL\",\"ZAR\":\"ZAR\",\"AED\":\"AED\",\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AWG\":\"AWG\",\"AZN\":\"AZN\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYN\":\"BYN\",\"BZD\":\"BZD\",\"CDF\":\"CDF\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHS\":\"GHS\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MYR\":\"MYR\",\"MZN\":\"MZN\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NPR\":\"NPR\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDG\":\"SDG\",\"SHP\":\"SHP\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SRD\":\"SRD\",\"SSP\":\"SSP\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMT\":\"TMT\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TTD\":\"TTD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZMW\":\"ZMW\",\"ZWL\":\"ZWL\"}\r\n\r\n', 0, '{\"endpoint\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.CoinbaseCommerce\"}}', NULL, '2019-09-14 13:14:22', '2023-08-11 01:39:38'),
(11, 0, 113, 'Paypal Express', 'PaypalSdk', 1, '{\"clientId\":{\"title\":\"Paypal Client ID\",\"global\":true,\"value\":\"------------\"},\"clientSecret\":{\"title\":\"Client Secret\",\"global\":true,\"value\":\"-----------\"}}', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2021-05-20 23:01:08'),
(12, 0, 114, 'Stripe Checkout', 'StripeV3', 0, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51M8Ks2CL65BWuH7eCBcWsLP2yPfWaLtfJVxG3zfii7cCWJE1izM4jkhucmBSm6izmVtSGZyp0JDYYCVmx9E4WmQY004gfnctzD\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51M8Ks2CL65BWuH7eju6khGxJMpeeFuw2Rwrjr8UYCz6ZnQ3PiFxb1gVu1i1dBto9MQrnjkBimHkFJgNcqsrJHTak0010kCY41h\"},\"end_point\":{\"title\":\"End Point Secret\",\"global\":true,\"value\":\"abcd\"}}', '{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}', 0, '{\"webhook\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.StripeV3\"}}', NULL, '2019-09-14 13:14:22', '2023-08-11 01:46:39'),
(50, 0, 115, 'Mercado Pago', 'MercadoPago', 1, '{\"access_token\":{\"title\":\"Access Token\",\"global\":true,\"value\":\"APP_USR-7924565816849832-082312-21941521997fab717db925cf1ea2c190-1071840315\"}}', '{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\"}', 0, '{\"webhook\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.MercadoPago\"}}', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `gateway_currencies`
--

CREATE TABLE `gateway_currencies` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_code` int DEFAULT NULL,
  `gateway_alias` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `max_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `percent_charge` decimal(5,2) NOT NULL DEFAULT '0.00',
  `fixed_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_parameter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `site_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cur_text` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'currency text',
  `cur_sym` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'currency symbol',
  `email_from` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fixed_charge` decimal(28,8) NOT NULL,
  `percent_charge` decimal(28,8) NOT NULL,
  `sms_body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sms_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondary_default_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mail_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'email configuration',
  `sms_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `global_shortcodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kv` tinyint(1) NOT NULL DEFAULT '0',
  `ev` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'email verification, 0 - dont check, 1 - check',
  `en` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'email notification, 0 - dont send, 1 - send',
  `sv` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'mobile verication, 0 - dont check, 1 - check',
  `sn` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sms notification, 0 - dont send, 1 - send',
  `force_ssl` tinyint(1) NOT NULL DEFAULT '0',
  `maintenance_mode` tinyint(1) NOT NULL DEFAULT '0',
  `secure_password` tinyint(1) NOT NULL DEFAULT '0',
  `agree` tinyint(1) NOT NULL DEFAULT '0',
  `registration` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Off	, 1: On',
  `active_template` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `site_name`, `cur_text`, `cur_sym`, `email_from`, `email_template`, `fixed_charge`, `percent_charge`, `sms_body`, `sms_from`, `base_color`, `default_color`, `secondary_color`, `secondary_default_color`, `mail_config`, `sms_config`, `global_shortcodes`, `kv`, `ev`, `en`, `sv`, `sn`, `force_ssl`, `maintenance_mode`, `secure_password`, `agree`, `registration`, `active_template`, `system_info`, `created_at`, `updated_at`) VALUES
(1, 'Eskrow', 'USD', '$', 'info@safety-escrow.com', '<p>Hi {{fullname}} ({{username}}),&nbsp;</p><p>{{message}}</p>', 4.00000000, 3.00000000, 'Hi {{fullname}} ({{username}}), {{message}}', 'Safety Escrow', '42b4ff', '8eed12', NULL, '060a00', '{\"name\":\"smtp\",\"host\":\"sandbox.smtp.mailtrap.io\",\"port\":\"465\",\"enc\":\"tls\",\"username\":\"cd4124b03fc58e\",\"password\":\"065aa527d6a73d\"}', '{\"name\":\"messageBird\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":\"------------8888888\",\"password\":\"-----------------\"},\"message_bird\":{\"api_key\":\"-------------------\"},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":\"----------------------\",\"password\":\"-----------------------------\"},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"text_magic\":{\"username\":\"-----------------------\",\"apiv2_key\":\"-------------------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":[\"from_number\"],\"value\":[\"5657545757\"]}}}', '{\n    \"site_name\":\"Name of your site\",\n    \"site_currency\":\"Currency of your site\",\n    \"currency_symbol\":\"Symbol of currency\"\n}', 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 'default', '[]', NULL, '2025-03-24 08:01:13');

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text_align` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: left to right text align, 1: right to left text align',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: not default language, 1: default language',
  `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 `languages`
--

INSERT INTO `languages` (`id`, `name`, `code`, `icon`, `text_align`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', '5f15968db08911595250317.png', 0, 1, '2020-07-06 03:47:55', '2022-09-29 10:36:14'),
(5, 'Spanish', 'es', NULL, 0, 0, '2020-12-29 02:20:07', '2022-09-29 10:36:14');

-- --------------------------------------------------------

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

CREATE TABLE `messages` (
  `id` bigint UNSIGNED NOT NULL,
  `conversation_id` int UNSIGNED NOT NULL DEFAULT '0',
  `sender_id` int UNSIGNED NOT NULL DEFAULT '0',
  `admin_id` int UNSIGNED NOT NULL DEFAULT '0',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `milestones`
--

CREATE TABLE `milestones` (
  `id` bigint UNSIGNED NOT NULL,
  `escrow_id` int UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `payment_status` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=>unfund, 1=>fund\r\n',
  `payment_type` tinyint NOT NULL DEFAULT '0' COMMENT '1 = wallet, 2 = direct payment',
  `status` tinyint UNSIGNED 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 `notification_logs`
--

CREATE TABLE `notification_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `sender` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sent_from` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sent_to` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `notification_type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sms_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `shortcodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email_status` tinyint(1) NOT NULL DEFAULT '1',
  `sms_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 `notification_templates`
--

INSERT INTO `notification_templates` (`id`, `act`, `name`, `subj`, `email_body`, `sms_body`, `shortcodes`, `email_status`, `sms_status`, `created_at`, `updated_at`) VALUES
(1, 'BAL_ADD', 'Balance - Added', 'Your Account has been Credited', '<div><div style=\"font-family: Montserrat, sans-serif;\">{{amount}} {{site_currency}} has been added to your account .</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">Your Current Balance is :&nbsp;</span><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">{{post_balance}}&nbsp; {{site_currency}}&nbsp;</span></font><br></div><div><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></font></div><div>Admin note:&nbsp;<span style=\"color: rgb(33, 37, 41); font-size: 12px; font-weight: 600; white-space: nowrap; text-align: var(--bs-body-text-align);\">{{remark}}</span></div>', '{{amount}} {{site_currency}} credited in your account. Your Current Balance {{post_balance}} {{site_currency}} . Transaction: #{{trx}}. Admin note is \"{{remark}}\"', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 0, '2021-11-03 12:00:00', '2022-09-21 13:04:13'),
(2, 'BAL_SUB', 'Balance - Subtracted', 'Your Account has been Debited', '<div style=\"font-family: Montserrat, sans-serif;\">{{amount}} {{site_currency}} has been subtracted from your account .</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">Your Current Balance is :&nbsp;</span><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">{{post_balance}}&nbsp; {{site_currency}}</span></font><br><div><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></font></div><div>Admin Note: {{remark}}</div>', '{{amount}} {{site_currency}} debited from your account. Your Current Balance {{post_balance}} {{site_currency}} . Transaction: #{{trx}}. Admin Note is {{remark}}', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:24:11'),
(3, 'DEPOSIT_COMPLETE', 'Deposit - Automated - Successful', 'Deposit Completed Successfully', '<div>Your deposit of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been completed Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div><br></div><div>Amount : {{amount}} {{site_currency}}</div><div>Charge:&nbsp;<font color=\"#000000\">{{charge}} {{site_currency}}</font></div><div><br></div><div>Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div>Received : {{method_amount}} {{method_currency}}<br></div><div>Paid via :&nbsp; {{method_name}}</div><div><br></div><div>Transaction Number : {{trx}}</div><div><font size=\"5\"><span style=\"font-weight: bolder;\"><br></span></font></div><div><font size=\"5\">Your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}} {{site_currency}}</span></font></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', '{{amount}} {{site_currency}} Deposit successfully by {{method_name}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:25:43'),
(4, 'DEPOSIT_APPROVE', 'Deposit - Manual - Approved', 'Your Deposit is Approved', '<div style=\"font-family: Montserrat, sans-serif;\">Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>is Approved .<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Received : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"5\"><span style=\"font-weight: bolder;\"><br></span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"5\">Your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}} {{site_currency}}</span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div>', 'Admin Approve Your {{amount}} {{site_currency}} payment request by {{method_name}} transaction : {{trx}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:26:07'),
(5, 'DEPOSIT_REJECT', 'Deposit - Manual - Rejected', 'Your Deposit Request is Rejected', '<div style=\"font-family: Montserrat, sans-serif;\">Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}} has been rejected</span>.<span style=\"font-weight: bolder;\"><br></span></div><div><br></div><div><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Received : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge: {{charge}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number was : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">if you have any queries, feel free to contact us.<br></div><br style=\"font-family: Montserrat, sans-serif;\"><div style=\"font-family: Montserrat, sans-serif;\"><br><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">{{rejection_message}}</span><br>', 'Admin Rejected Your {{amount}} {{site_currency}} payment request by {{method_name}}\r\n\r\n{{rejection_message}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"rejection_message\":\"Rejection message by the admin\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-05 03:45:27'),
(6, 'DEPOSIT_REQUEST', 'Deposit - Manual - Requested', 'Deposit Request Submitted Successfully', '<div>Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>submitted successfully<span style=\"font-weight: bolder;\">&nbsp;.<br></span></div><div><span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div><br></div><div>Amount : {{amount}} {{site_currency}}</div><div>Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div><br></div><div>Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div>Payable : {{method_amount}} {{method_currency}}<br></div><div>Pay via :&nbsp; {{method_name}}</div><div><br></div><div>Transaction Number : {{trx}}</div><div><br></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', '{{amount}} {{site_currency}} Deposit requested by {{method_name}}. Charge: {{charge}} . Trx: {{trx}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:29:19'),
(7, 'PASS_RESET_CODE', 'Password - Reset - Code', 'Password Reset', '<div style=\"font-family: Montserrat, sans-serif;\">We have received a request to reset the password for your account on&nbsp;<span style=\"font-weight: bolder;\">{{time}} .<br></span></div><div style=\"font-family: Montserrat, sans-serif;\">Requested From IP:&nbsp;<span style=\"font-weight: bolder;\">{{ip}}</span>&nbsp;using&nbsp;<span style=\"font-weight: bolder;\">{{browser}}</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{operating_system}}&nbsp;</span>.</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><br style=\"font-family: Montserrat, sans-serif;\"><div style=\"font-family: Montserrat, sans-serif;\"><div>Your account recovery code is:&nbsp;&nbsp;&nbsp;<font size=\"6\"><span style=\"font-weight: bolder;\">{{code}}</span></font></div><div><br></div></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\" color=\"#CC0000\">If you do not wish to reset your password, please disregard this message.&nbsp;</font><br></div><div><font size=\"4\" color=\"#CC0000\"><br></font></div>', 'Your account recovery code is: {{code}}', '{\"code\":\"Verification code for password reset\",\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 0, '2021-11-03 12:00:00', '2022-03-20 20:47:05'),
(8, 'PASS_RESET_DONE', 'Password - Reset - Confirmation', 'You have reset your password', '<p style=\"font-family: Montserrat, sans-serif;\">You have successfully reset your password.</p><p style=\"font-family: Montserrat, sans-serif;\">You changed from&nbsp; IP:&nbsp;<span style=\"font-weight: bolder;\">{{ip}}</span>&nbsp;using&nbsp;<span style=\"font-weight: bolder;\">{{browser}}</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{operating_system}}&nbsp;</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{time}}</span></p><p style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></p><p style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><font color=\"#ff0000\">If you did not change that, please contact us as soon as possible.</font></span></p>', 'Your password has been changed successfully', '{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-05 03:46:35'),
(9, 'ADMIN_SUPPORT_REPLY', 'Support - Reply', 'Reply Support Ticket', '<div><p><span data-mce-style=\"font-size: 11pt;\" style=\"font-size: 11pt;\"><span style=\"font-weight: bolder;\">A member from our support team has replied to the following ticket:</span></span></p><p><span style=\"font-weight: bolder;\"><span data-mce-style=\"font-size: 11pt;\" style=\"font-size: 11pt;\"><span style=\"font-weight: bolder;\"><br></span></span></span></p><p><span style=\"font-weight: bolder;\">[Ticket#{{ticket_id}}] {{ticket_subject}}<br><br>Click here to reply:&nbsp; {{link}}</span></p><p>----------------------------------------------</p><p>Here is the reply :<br></p><p>{{reply}}<br></p></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', 'Your Ticket#{{ticket_id}} :  {{ticket_subject}} has been replied.', '{\"ticket_id\":\"ID of the support ticket\",\"ticket_subject\":\"Subject  of the support ticket\",\"reply\":\"Reply made by the admin\",\"link\":\"URL to view the support ticket\"}', 1, 1, '2021-11-03 12:00:00', '2022-03-20 20:47:51'),
(10, 'EVER_CODE', 'Verification - Email', 'Please verify your email address', '<br><div><div style=\"font-family: Montserrat, sans-serif;\">Thanks For joining us.<br></div><div style=\"font-family: Montserrat, sans-serif;\">Please use the below code to verify your email address.<br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Your email verification code is:<font size=\"6\"><span style=\"font-weight: bolder;\">&nbsp;{{code}}</span></font></div></div>', '---', '{\"code\":\"Email verification code\"}', 1, 0, '2021-11-03 12:00:00', '2022-04-03 02:32:07'),
(11, 'SVER_CODE', 'Verification - SMS', 'Verify Your Mobile Number', '---', 'Your phone verification code is: {{code}}', '{\"code\":\"SMS Verification Code\"}', 0, 1, '2021-11-03 12:00:00', '2022-03-20 19:24:37'),
(12, 'WITHDRAW_APPROVE', 'Withdraw - Approved', 'Withdraw Request has been Processed and your money is sent', '<div style=\"font-family: Montserrat, sans-serif;\">Your withdraw request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp; via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been Processed Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your withdraw:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">You will get: {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">-----</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\">Details of Processed Payment :</font></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\"><span style=\"font-weight: bolder;\">{{admin_details}}</span></font></div>', 'Admin Approve Your {{amount}} {{site_currency}} withdraw request by {{method_name}}. Transaction {{trx}}', '{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"admin_details\":\"Details provided by the admin\"}', 1, 1, '2021-11-03 12:00:00', '2022-03-20 20:50:16'),
(13, 'WITHDRAW_REJECT', 'Withdraw - Rejected', 'Withdraw Request has been Rejected and your money is refunded to your account', '<div style=\"font-family: Montserrat, sans-serif;\">Your withdraw request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp; via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been Rejected.<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your withdraw:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">You should get: {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">----</div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"3\"><br></font></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"3\">{{amount}} {{currency}} has been&nbsp;<span style=\"font-weight: bolder;\">refunded&nbsp;</span>to your account and your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}}</span><span style=\"font-weight: bolder;\">&nbsp;{{site_currency}}</span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">-----</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\">Details of Rejection :</font></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\"><span style=\"font-weight: bolder;\">{{admin_details}}</span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br><br><br><br><br></div><div></div><div></div>', 'Admin Rejected Your {{amount}} {{site_currency}} withdraw request. Your Main Balance {{post_balance}}  {{method_name}} , Transaction {{trx}}', '{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this action\",\"admin_details\":\"Rejection message by the admin\"}', 1, 1, '2021-11-03 12:00:00', '2022-03-20 20:57:46'),
(14, 'WITHDRAW_REQUEST', 'Withdraw - Requested', 'Withdraw Request Submitted Successfully', '<div style=\"font-family: Montserrat, sans-serif;\">Your withdraw request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp; via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been submitted Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your withdraw:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">You will get: {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"5\">Your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}} {{site_currency}}</span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br><br><br></div>', '{{amount}} {{site_currency}} withdraw requested by {{method_name}}. You will get {{method_amount}} {{method_currency}} Trx: {{trx}}', '{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-03-21 04:39:03'),
(15, 'DEFAULT', 'Default Template', '{{subject}}', '{{message}}', '{{message}}', '{\"subject\":\"Subject\",\"message\":\"Message\"}', 1, 1, '2019-09-14 13:14:22', '2021-11-04 09:38:55'),
(18, 'INVITATION_MAIL', 'Invitation Mail', 'Invitation Mail', '<p>&nbsp;</p><p>You are invited to participate in the escrow process for our transaction. Escrow creator sends an invitation by mail.</p><p>Escrow amount : {{escrow_amount}} {{site_currency}}</p><p>If you are not registered, please visit this link:&nbsp; <a href=\"{{link}}\"><strong>{{link}}</strong></a></p><p>&nbsp;</p><p><strong>Best regards,</strong></p><p>{{sender_mail}}</p>', '{{escrow_amount}} {{site_currency}} credited in your account. Escrow Number: #{{escrow_number}}. If you are not registered, please visit this link:  {{link}}\r\n\r\nThank you', '{\"escrow_amount\":\"Amount inserted by the new escrow creator\",\"sender_mail\":\"Senders mail\",\"link\":\"signup\"}', 1, 1, '2021-11-03 12:00:00', '2023-06-03 09:20:03'),
(19, 'ESCROW_ACCEPTED', 'Escrow Accepted ', 'Escrow accepted', '<p>&nbsp;</p><p>Accepted escrow number: {{escrow_number}} and {{escrow_amount}} {{site_currency}}</p><p>&nbsp;{{accepter}} accepted to your new escrow .</p><p>&nbsp;</p>', 'Accepted escrow number: {{escrow_number}} and {{escrow_amount}} {{site_currency}}\r\n {{accepter}} accepted to your new escrow .', '{\"escrow_id\":\"Accepted escrow id\",\"escrow_amount\":\"Accepted escrow amount\",\"escrow_number\":\"Escrow number for the action\",\"accepter\":\"Accepter name\"}', 1, 1, '2021-11-03 12:00:00', '2023-03-18 02:53:24'),
(20, 'ESCROW_CANCELED', 'Escrow cancelation', 'Escrow canceled', '<p>Cancelation escrow number - {{escrow_number}}.</p><p>Cancel escrow\'s amount {{escrow_amount}} {{site_currency}} and refund amount {{fund}} {{site_currency}}</p><p>{{canceler}} cancel to your escrow.</p><p>&nbsp;</p>', 'Cancelation escrow number - {{escrow_number}}.\r\n\r\nCancel amount {{escrow_amount}} {{site_currency}} and refund amount {{fund}} {{site_currency}}\r\n\r\n{{canceler}} cancel to your escrow.', '{\"escrow_amount\":\"Accepted escrow amount\",\"escrow_number\":\"Escrow number for the action\",\"canceler\":\"Canceler name\",\"fund\":\"Funded amount\"}', 1, 1, '2021-11-03 12:00:00', '2023-03-18 03:01:35'),
(21, 'ESCROW_DISPUTED', 'Escrow Disputation', 'Escrow disputed', '<p>Disputed escrow number {{escrow_number}} , amount {{escrow_amount}} {{site_currency}}&nbsp;</p><p>{{disputer}} had been disputed to your new escrow .</p><p>&nbsp;</p>', 'Disputed escrow number {{escrow_number}} , amount {{escrow_amount}} {{site_currency}} \r\n{{disputer}} had been disputed to your new escrow .', '{\"escrow_amount\":\"Disputed escrow amount\",\"escrow_number\":\"Escrow number for the action\",\"details\":\"some note for escrow\",\"disputer\":\"disputer identificaiton\"}', 1, 1, '2021-11-03 12:00:00', '2023-03-18 03:02:43'),
(23, 'ESCROW_COMPLETED', 'Escrow Completation', 'Completed Escrow', '<p>Dispatched escrow number {{escrow_number}} and amount {{escrow_amount}} {{site_currency}}&nbsp;</p><p>After completation post balance is {{post_balance}}</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>', 'Dispatched escrow number {{escrow_number}} , amount {{escrow_amount}} {{site_currency}} \r\nAfter completation post balance is {{post_balance}}', '{\"escrow_amount\":\"Dispatched escrow amount\",\"escrow_number\":\"Escrow number for the action\",\"post_balance\":\"Dispatcher post balance\"}', 1, 1, '2021-11-03 12:00:00', '2023-03-18 03:12:03');

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'template name',
  `secs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `name`, `slug`, `tempname`, `secs`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Home', '/', 'templates.template_two.', '[\"banner_two\",\"service_two\",\"work_process\",\"about_two\",\"choose_us_two\",\"faq_two\",\"newsletter\",\"partner\"]', 1, '2020-07-11 06:23:58', '2025-02-17 11:34:27'),
(4, 'About', 'about', 'templates.template_two.', '[\"about_two\",\"choose_us_two\",\"service_two\",\"newsletter\",\"partner\"]', 1, '2020-10-22 01:14:43', '2025-02-17 12:05:45'),
(5, 'Blog', 'blog', 'templates.template_two.', '[\"blog_two\"]', 1, '2020-10-22 01:14:53', '2025-02-17 12:06:06'),
(19, 'Contact', 'contact', 'templates.template_two.', NULL, 0, '2023-02-13 07:34:30', '2023-02-13 08:52:51'),
(23, 'Home', '/', 'templates.default.', '[\"banner_one\",\"about_one\",\"service_one\",\"working_process\",\"working_map\",\"faq_one\",\"testimonial_one\",\"blog_one\",\"marque\"]', 1, '2020-07-11 06:23:58', '2025-03-19 08:35:06'),
(24, 'About', 'about', 'templates.default.', '[\"choose_us_one\",\"faq_one\",\"testimonial_one\",\"blog_one\"]', 1, '2020-10-22 01:14:43', '2025-02-17 12:53:47'),
(25, 'Blog', 'blog', 'templates.default.', '[\"blog_one\"]', 1, '2020-10-22 01:14:53', '2025-02-17 12:21:29'),
(26, 'Contact', 'contact', 'templates.default.', NULL, 0, '2023-02-13 07:34:30', '2023-02-13 08:52:51');

-- --------------------------------------------------------

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

CREATE TABLE `password_resets` (
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `support_attachments`
--

CREATE TABLE `support_attachments` (
  `id` bigint UNSIGNED NOT NULL,
  `support_message_id` int UNSIGNED DEFAULT NULL,
  `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `support_messages`
--

CREATE TABLE `support_messages` (
  `id` bigint UNSIGNED NOT NULL,
  `support_ticket_id` int UNSIGNED NOT NULL DEFAULT '0',
  `admin_id` int UNSIGNED NOT NULL DEFAULT '0',
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int DEFAULT '0',
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ticket` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed',
  `priority` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Low, 2 = medium, 3 = heigh',
  `last_reply` datetime 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 `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `charge` decimal(28,8) DEFAULT '0.00000000',
  `post_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `trx_type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trx` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `firstname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_by` int UNSIGNED NOT NULL DEFAULT '0',
  `balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'contains full address',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: banned, 1: active',
  `kyc_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `kv` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: KYC Unverified, 2: KYC pending, 1: KYC verified',
  `ev` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: email unverified, 1: email verified',
  `sv` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: mobile unverified, 1: mobile verified',
  `reg_step` tinyint(1) NOT NULL DEFAULT '0',
  `ver_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'stores verification code',
  `ver_code_send_at` datetime DEFAULT NULL COMMENT 'verification send time',
  `ts` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: 2fa off, 1: 2fa on',
  `tv` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: 2fa unverified, 1: 2fa verified',
  `tsc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `user_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `os` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint UNSIGNED NOT NULL,
  `method_id` int UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `currency` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `trx` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `after_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `withdraw_information` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=>success, 2=>pending, 3=>cancel,  ',
  `admin_feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint UNSIGNED NOT NULL,
  `form_id` int UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_limit` decimal(28,8) DEFAULT '0.00000000',
  `max_limit` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `fixed_charge` decimal(28,8) DEFAULT '0.00000000',
  `rate` decimal(28,8) DEFAULT '0.00000000',
  `percent_charge` decimal(5,2) DEFAULT NULL,
  `currency` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`,`username`);

--
-- Indexes for table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin_password_resets`
--
ALTER TABLE `admin_password_resets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `conversations`
--
ALTER TABLE `conversations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `escrows`
--
ALTER TABLE `escrows`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `escrow_charges`
--
ALTER TABLE `escrow_charges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `extensions`
--
ALTER TABLE `extensions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forms`
--
ALTER TABLE `forms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `frontends`
--
ALTER TABLE `frontends`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gateways`
--
ALTER TABLE `gateways`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gateway_currencies`
--
ALTER TABLE `gateway_currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `general_settings`
--
ALTER TABLE `general_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  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 `milestones`
--
ALTER TABLE `milestones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_logs`
--
ALTER TABLE `notification_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_templates`
--
ALTER TABLE `notification_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_attachments`
--
ALTER TABLE `support_attachments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_messages`
--
ALTER TABLE `support_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`,`email`);

--
-- Indexes for table `user_logins`
--
ALTER TABLE `user_logins`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_password_resets`
--
ALTER TABLE `admin_password_resets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `escrows`
--
ALTER TABLE `escrows`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `escrow_charges`
--
ALTER TABLE `escrow_charges`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extensions`
--
ALTER TABLE `extensions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `forms`
--
ALTER TABLE `forms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `frontends`
--
ALTER TABLE `frontends`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;

--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `gateway_currencies`
--
ALTER TABLE `gateway_currencies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general_settings`
--
ALTER TABLE `general_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `milestones`
--
ALTER TABLE `milestones`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_logs`
--
ALTER TABLE `notification_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_attachments`
--
ALTER TABLE `support_attachments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_messages`
--
ALTER TABLE `support_messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` bigint 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 */;
