-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

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

CREATE TABLE `admin_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(255) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `click_url` text 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 `assets`
--

CREATE TABLE `assets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT 0,
  `category_id` int(10) NOT NULL DEFAULT 0,
  `quantity` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `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(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `karat` int(11) NOT NULL DEFAULT 0,
  `price` decimal(28,8) DEFAULT 0.00000000,
  `change_1h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `change_24h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `change_7d` decimal(5,2) NOT NULL DEFAULT 0.00,
  `change_30d` decimal(5,2) NOT NULL DEFAULT 0.00,
  `change_90d` decimal(5,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `charge_limits`
--

CREATE TABLE `charge_limits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(40) DEFAULT NULL,
  `min_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `max_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `fixed_charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `percent_charge` decimal(5,2) NOT NULL DEFAULT 0.00,
  `vat` decimal(5,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `charge_limits`
--

INSERT INTO `charge_limits` (`id`, `slug`, `min_amount`, `max_amount`, `fixed_charge`, `percent_charge`, `vat`, `created_at`, `updated_at`) VALUES
(1, 'buy', 10.00000000, 10000.00000000, 1.00000000, 1.00, 2.50, NULL, '2024-12-11 06:34:05'),
(2, 'sell', 10.00000000, 10000.00000000, 2.00000000, 3.00, 0.00, NULL, '2024-12-11 06:04:43'),
(3, 'gift', 10.00000000, 10000.00000000, 1.00000000, 2.00, 0.00, NULL, '2024-12-11 06:04:47'),
(4, 'redeem', 10.00000000, 10000.00000000, 1.00000000, 2.00, 0.00, NULL, '2024-12-18 07:30:50');

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

--
-- Table structure for table `cron_jobs`
--

CREATE TABLE `cron_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `alias` varchar(40) DEFAULT NULL,
  `action` text DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `cron_schedule_id` int(11) NOT NULL DEFAULT 0,
  `next_run` datetime DEFAULT NULL,
  `last_run` datetime DEFAULT NULL,
  `is_running` tinyint(1) NOT NULL DEFAULT 1,
  `is_default` 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 `cron_jobs`
--

INSERT INTO `cron_jobs` (`id`, `name`, `alias`, `action`, `url`, `cron_schedule_id`, `next_run`, `last_run`, `is_running`, `is_default`, `created_at`, `updated_at`) VALUES
(4, 'Price Update', 'price_update', '[\"App\\\\Http\\\\Controllers\\\\CronController\", \"priceUpdate\"]', 'https://facebook.com/', 1, '2025-01-20 07:32:17', '2025-01-20 06:32:17', 1, 1, '2024-05-06 04:46:06', '2025-01-20 00:32:17');

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

--
-- Table structure for table `cron_job_logs`
--

CREATE TABLE `cron_job_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cron_job_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `start_at` datetime DEFAULT NULL,
  `end_at` datetime DEFAULT NULL,
  `duration` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `error` text 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 `cron_schedules`
--

CREATE TABLE `cron_schedules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `interval` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `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 `cron_schedules`
--

INSERT INTO `cron_schedules` (`id`, `name`, `interval`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hourly', 3600, 1, '2024-03-13 23:34:09', '2024-05-06 04:45:32'),
(3, 'Daily', 86400, 1, '2024-05-06 04:46:39', '2024-05-06 04:46:39');

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `category_id` int(10) NOT NULL DEFAULT 0,
  `method_code` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `buy_info` text DEFAULT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `method_currency` varchar(40) DEFAULT NULL,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `final_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `detail` text DEFAULT NULL,
  `btc_amount` varchar(255) DEFAULT NULL,
  `btc_wallet` varchar(255) DEFAULT NULL,
  `trx` varchar(40) DEFAULT NULL,
  `payment_try` int(11) 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,
  `is_web` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'This will be 1 if the request is from NextJs application',
  `admin_feedback` varchar(255) DEFAULT NULL,
  `success_url` varchar(255) DEFAULT NULL,
  `failed_url` varchar(255) DEFAULT NULL,
  `last_cron` int(11) 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(20) UNSIGNED NOT NULL,
  `act` varchar(40) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `script` text DEFAULT NULL,
  `shortcode` text DEFAULT NULL COMMENT 'object',
  `support` text DEFAULT NULL COMMENT 'help section',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=>enable, 2=>disable',
  `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`, `created_at`, `updated_at`) VALUES
(1, 'tawk-chat', 'Tawk.to', 'Key location is shown bellow', 'tawky_big.png', '<script>\r\n                        var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n                        (function(){\r\n                        var s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\n                        s1.async=true;\r\n                        s1.src=\"https://embed.tawk.to/{{app_key}}\";\r\n                        s1.charset=\"UTF-8\";\r\n                        s1.setAttribute(\"crossorigin\",\"*\");\r\n                        s0.parentNode.insertBefore(s1,s0);\r\n                        })();\r\n                    </script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"------\"}}', 'twak.png', 0, '2019-10-18 11:16:05', '2024-05-16 06:23:02'),
(2, 'google-recaptcha2', 'Google Recaptcha 2', 'Key location is shown bellow', 'recaptcha3.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, '2019-10-18 11:16:05', '2024-12-05 06:16:54'),
(3, 'custom-captcha', 'Custom Captcha', 'Just put any random string', 'customcaptcha.png', NULL, '{\"random_key\":{\"title\":\"Random String\",\"value\":\"SecureString\"}}', 'na', 0, '2019-10-18 11:16:05', '2024-12-05 06:17:45'),
(4, 'google-analytics', 'Google Analytics', 'Key location is shown bellow', 'google_analytics.png', '<script async src=\"https://www.googletagmanager.com/gtag/js?id={{measurement_id}}\"></script>\n                <script>\n                  window.dataLayer = window.dataLayer || [];\n                  function gtag(){dataLayer.push(arguments);}\n                  gtag(\"js\", new Date());\n                \n                  gtag(\"config\", \"{{measurement_id}}\");\n                </script>', '{\"measurement_id\":{\"title\":\"Measurement ID\",\"value\":\"------\"}}', 'ganalytics.png', 0, NULL, '2021-05-03 22:19:12'),
(5, 'fb-comment', 'Facebook Comment ', 'Key location is shown bellow', 'Facebook.png', '<div id=\"fb-root\"></div><script async defer crossorigin=\"anonymous\" src=\"https://connect.facebook.net/en_GB/sdk.js#xfbml=1&version=v4.0&appId={{app_key}}&autoLogAppEvents=1\"></script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"----\"}}', 'fb_com.png', 0, NULL, '2022-03-21 17:18:36');

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

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

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

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

INSERT INTO `forms` (`id`, `act`, `form_data`, `created_at`, `updated_at`) VALUES
(7, 'kyc', '{\"full_name\":{\"name\":\"Full Name\",\"label\":\"full_name\",\"is_required\":\"required\",\"instruction\":null,\"extensions\":\"\",\"options\":[],\"type\":\"text\",\"width\":\"6\"},\"email\":{\"name\":\"Email\",\"label\":\"email\",\"is_required\":\"required\",\"instruction\":null,\"extensions\":\"\",\"options\":[],\"type\":\"email\",\"width\":\"6\"},\"gender\":{\"name\":\"Gender\",\"label\":\"gender\",\"is_required\":\"required\",\"instruction\":null,\"extensions\":null,\"options\":[\"Male\",\"Female\",\"Others\"],\"type\":\"select\",\"width\":\"6\"},\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"instruction\":null,\"extensions\":null,\"options\":[],\"type\":\"number\",\"width\":\"6\"},\"nid_photo_front\":{\"name\":\"NID Photo Front\",\"label\":\"nid_photo_front\",\"is_required\":\"required\",\"instruction\":\"Upload the front side of your NID\",\"extensions\":\"jpg,png\",\"options\":[],\"type\":\"file\",\"width\":\"6\"},\"nid_photo_back\":{\"name\":\"NID Photo Back\",\"label\":\"nid_photo_back\",\"is_required\":\"required\",\"instruction\":\"Upload the back side of your NID\",\"extensions\":\"jpg,jpeg,png\",\"options\":[],\"type\":\"file\",\"width\":\"6\"},\"you_hobby\":{\"name\":\"You Hobby\",\"label\":\"you_hobby\",\"is_required\":\"required\",\"instruction\":null,\"extensions\":null,\"options\":[\"Programming\",\"Gardening\",\"Traveling\",\"Others\"],\"type\":\"checkbox\",\"width\":\"12\"}}', '2022-03-17 02:56:14', '2024-05-08 08:27:07');

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

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

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

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

INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `seo_content`, `tempname`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'seo.data', '{\"seo_image\":\"1\",\"keywords\":[\"gold\",\"gold trade\",\"viser gold\",\"trading\",\"Golden Trading\"],\"description\":\"Online Gold Trading Platform\",\"social_title\":\"ViserGold\",\"social_description\":\"Online Gold Trading Platform\",\"image\":\"678cfbf3471be1737292787.png\"}', NULL, NULL, '', '2020-07-04 23:42:52', '2025-01-19 13:19:47'),
(27, 'contact_us.content', '{\"has_image\":\"1\",\"heading\":\"Contact Us\",\"subheading\":\"Email, call, or complete the form to learn about ViserGold and buy or selling gold in real time\",\"title\":\"Get in Touch\",\"subtitle\":\"You can reach us anytime\",\"address\":\"Level 1, 12 Sample St, Sydney NSW 2000\",\"email_address\":\"info@viserlab.com\",\"contact_number\":\"+89525249684\",\"iframe_url\":\"https:\\/\\/www.google.com\\/maps\\/embed?pb=!1m18!1m12!1m3!1d7500.6515014222705!2d-122.4237044367272!3d37.77514455263219!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x80859a6d00690021%3A0x4a501367f076adff!2sSan%20Francisco%2C%20CA%2C%20USA!5e0!3m2!1sen!2sbd!4v1732711546743!5m2!1sen!2sbd\",\"full_address\":\"<h5 class=\\\"contact-map-content__subtitle\\\">Our Location<\\/h5>\\r\\n                    <h2 class=\\\"contact-map-content__title\\\">Connecting Near and Far<\\/h2>\\r\\n                    <div class=\\\"contact-map-content__location\\\">\\r\\n                        <h5 class=\\\"contact-map-content__location-title\\\">Headquarters<\\/h5>\\r\\n                        <p class=\\\"contact-map-content__location-desc\\\">\\r\\n                            ViserGold Limited San Francisco, USA 123 Tech Boulverd suite 456 San Francisco, CA 12345 United Stated\\r\\n                        <\\/p>\\r\\n                    <\\/div>\",\"background_image\":\"6750470ec7e9f1733314318.png\"}', NULL, 'basic', '', '2020-10-28 00:59:19', '2024-12-05 08:49:31'),
(28, 'counter.content', '{\"heading\":\"Latest News\",\"subheading\":\"Lorem ipsum dolor sit, amet consectetur adipisicing elit. Doloribus necessitatibus repudiandae porro reprehenderit, beatae perferendis repellat quo ipsa omnis, vitae!\"}', NULL, 'basic', NULL, '2020-10-28 01:04:02', '2024-03-13 23:54:07'),
(31, 'social_icon.element', '{\"title\":\"Facebook\",\"social_icon\":\"<i class=\\\"fa-brands fa-facebook\\\"><\\/i>\",\"url\":\"https:\\/\\/www.facebook.com\"}', NULL, 'basic', '', '2020-11-12 04:07:30', '2024-12-05 09:06:06'),
(33, 'feature.content', '{\"has_image\":\"1\",\"heading\":\"Why Choose ViserGold?\",\"subheading\":\"Trusted, Transparent, and Tailored for Your Gold Investment Needs\",\"icon\":\"<i class=\\\"fa-solid fa-shield\\\"><\\/i>\"}', NULL, 'basic', '', '2021-01-03 23:40:54', '2024-12-22 05:35:25'),
(36, 'service.content', '{\"has_image\":\"1\",\"heading\":\"Our Services\",\"subheading\":\"From buying and selling to gifting, we offer a secure and seamless experience for all your gold needs\",\"image\":\"674ee293731bf1733223059.png\"}', NULL, 'basic', '', '2021-03-06 01:27:34', '2024-12-03 04:50:59'),
(41, 'cookie.data', '{\"short_desc\":\"We may use cookies or any other tracking technologies when you visit our website, including any other media form, mobile website, or mobile application related or connected to help customize the Site and improve your experience.\",\"description\":\"<h4>Cookie Policy<\\/h4>\\r\\n\\r\\n<p>This Cookie Policy explains how to use cookies and similar technologies to recognize you when you visit our website. It explains what these technologies are and why we use them, as well as your rights to control our use of them.<\\/p>\\r\\n<br>\\r\\n<h4>What are cookies?<\\/h4>\\r\\n\\r\\n<p>Cookies are small pieces of data stored on your computer or mobile device when you visit a website. Cookies are widely used by website owners to make their websites work, or to work more efficiently, as well as to provide reporting information.<\\/p>\\r\\n<br>\\r\\n<h4>Why do we use cookies?<\\/h4>\\r\\n\\r\\n<p>We use cookies for several reasons. Some cookies are required for technical reasons for our Website to operate, and we refer to these as \\\"essential\\\" or \\\"strictly necessary\\\" cookies. Other cookies enable us to track and target the interests of our users to enhance the experience on our Website. Third parties serve cookies through our Website for advertising, analytics, and other purposes.<\\/p>\\r\\n<br>\\r\\n<h4>What types of cookies do we use?<\\/h4>\\r\\n\\r\\n<div>\\r\\n    <ul style=\\\"list-style: unset;\\\">\\r\\n        <li>\\r\\n            <strong>Essential Website Cookies:<\\/strong> \\r\\n            These cookies are strictly necessary to provide you with services available through our Website and to use some of its features.\\r\\n        <\\/li>\\r\\n        <li>\\r\\n            <strong>Analytics and Performance Cookies:<\\/strong> \\r\\n            These cookies allow us to count visits and traffic sources to measure and improve our Website\'s performance.\\r\\n        <\\/li>\\r\\n        <li>\\r\\n            <strong>Advertising Cookies:<\\/strong> \\r\\n            These cookies make advertising messages more relevant to you and your interests. They perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.\\r\\n        <\\/li>\\r\\n    <\\/ul>\\r\\n<\\/div>\\r\\n<br>\\r\\n<h4>Data Collected by Cookies<\\/h4>\\r\\n<p>Cookies may collect various types of data, including but not limited to:<\\/p>\\r\\n<ul style=\\\"list-style: unset;\\\">\\r\\n    <li>IP addresses<\\/li>\\r\\n    <li>Browser and device information<\\/li>\\r\\n    <li>Referring website addresses<\\/li>\\r\\n    <li>Pages visited on our website<\\/li>\\r\\n    <li>Interactions with our website, such as clicks and mouse movements<\\/li>\\r\\n    <li>Time spent on our website<\\/li>\\r\\n<\\/ul>\\r\\n<br>\\r\\n<h4>How We Use Collected Data<\\/h4>\\r\\n\\r\\n<p>We may use data collected by cookies for the following purposes:<\\/p>\\r\\n<ul style=\\\"list-style: unset;\\\">\\r\\n    <li>To personalize your experience on our website<\\/li>\\r\\n    <li>To improve our website\'s functionality and performance<\\/li>\\r\\n    <li>To analyze trends and gather demographic information about our user base<\\/li>\\r\\n    <li>To deliver targeted advertising based on your interests<\\/li>\\r\\n    <li>To prevent fraudulent activity and enhance website security<\\/li>\\r\\n<\\/ul>\\r\\n<br>\\r\\n<h4>Third-party cookies<\\/h4>\\r\\n\\r\\n<p>In addition to our cookies, we may also use various third-party cookies to report usage statistics of our Website, deliver advertisements on and through our Website, and so on.<\\/p>\\r\\n<br>\\r\\n<h4>How can we control cookies?<\\/h4>\\r\\n\\r\\n<p>You have the right to decide whether to accept or reject cookies. You can exercise your cookie preferences by clicking on the \\\"Cookie Settings\\\" link in the footer of our website. You can also set or amend your web browser controls to accept or refuse cookies. If you choose to reject cookies, you may still use our Website though your access to some functionality and areas of our Website may be restricted.<\\/p>\\r\\n<br>\\r\\n<h4>Changes to our Cookie Policy<\\/h4>\\r\\n\\r\\n<p>We may update our Cookie Policy from time to time. We will notify you of any changes by posting the new Cookie Policy on this page.<\\/p>\",\"status\":1}', NULL, NULL, NULL, '2020-07-04 23:42:52', '2024-04-25 06:26:36'),
(42, 'policy_pages.element', '{\"title\":\"Privacy Policy\",\"details\":\"<h4>Introduction<\\/h4>\\r\\n        <p>\\r\\n            This Privacy Policy describes how we collects, uses, and discloses information, including personal information, in connection with your use of our website.\\r\\n        <\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Information We Collect<\\/h4>\\r\\n        <p>We collect two main types of information on the Website:<\\/p>\\r\\n        <ul>\\r\\n            <li><p><strong>Personal Information: <\\/strong>This includes data that can identify you as an individual, such as your name, email address, phone number, or mailing address. We only collect this information when you voluntarily provide it to us, like signing up for a newsletter, contacting us through a form, or making a purchase.<\\/p><\\/li>\\r\\n            <li><p><strong>Non-Personal Information: <\\/strong>This data cannot be used to identify you directly. It includes details like your browser type, device type, operating system, IP address, browsing activity, and usage statistics. We collect this information automatically through cookies and other tracking technologies.<\\/p><\\/li>\\r\\n        <\\/ul>\\r\\n        <br \\/>\\r\\n        <h4>How We Use Information<\\/h4>\\r\\n        <p>The information we collect allows us to:<\\/p>\\r\\n        <ul>\\r\\n            <li>Operate and maintain the Website effectively.<\\/li>\\r\\n            <li>Send you newsletters or marketing communications, but only with your consent.<\\/li>\\r\\n            <li>Respond to your inquiries and fulfill your requests.<\\/li>\\r\\n            <li>Improve the Website and your user experience.<\\/li>\\r\\n            <li>Personalize your experience on the Website based on your browsing habits.<\\/li>\\r\\n            <li>Analyze how the Website is used to improve our services.<\\/li>\\r\\n            <li>Comply with legal and regulatory requirements.<\\/li>\\r\\n        <\\/ul>\\r\\n        <br \\/>\\r\\n        <h4>Sharing of Information<\\/h4>\\r\\n        <p>We may share your information with trusted third-party service providers who assist us in operating the Website and delivering our services. These providers are obligated by contract to keep your information confidential and use it only for the specific purposes we disclose it for.<\\/p>\\r\\n        <p>We will never share your personal information with any third parties for marketing purposes without your explicit consent.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Data Retention<\\/h4>\\r\\n        <p>We retain your personal information only for as long as necessary to fulfill the purposes it was collected for. We may retain it for longer periods only if required or permitted by law.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Security Measures<\\/h4>\\r\\n        <p>We take reasonable precautions to protect your information from unauthorized access, disclosure, alteration, or destruction. However, complete security cannot be guaranteed for any website or internet transmission.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Changes to this Privacy Policy<\\/h4>\\r\\n        <p>We may update this Privacy Policy periodically. We will notify you of any changes by posting the revised policy on the Website. We recommend reviewing this policy regularly to stay informed of any updates.<\\/p>\\r\\n        <p><strong>Remember:<\\/strong>  This is a sample policy and may need adjustments to comply with specific laws and reflect your website\'s unique data practices. Consider consulting with a legal professional to ensure your policy is fully compliant.<\\/p>\"}', '{\"image\":null,\"description\":null,\"social_title\":null,\"social_description\":null,\"keywords\":null}', 'basic', 'privacy-policy', '2021-06-09 08:50:42', '2024-04-24 05:43:19'),
(43, 'policy_pages.element', '{\"title\":\"Terms of Service\",\"details\":\"<h4>Introduction<\\/h4>\\r\\n        <p>\\r\\n            This Privacy Policy describes how we collects, uses, and discloses information, including personal information, in connection with your use of our website.\\r\\n        <\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Information We Collect<\\/h4>\\r\\n        <p>We collect two main types of information on the Website:<\\/p>\\r\\n        <ul>\\r\\n            <li><p><strong>Personal Information: <\\/strong>This includes data that can identify you as an individual, such as your name, email address, phone number, or mailing address. We only collect this information when you voluntarily provide it to us, like signing up for a newsletter, contacting us through a form, or making a purchase.<\\/p><\\/li>\\r\\n            <li><p><strong>Non-Personal Information: <\\/strong>This data cannot be used to identify you directly. It includes details like your browser type, device type, operating system, IP address, browsing activity, and usage statistics. We collect this information automatically through cookies and other tracking technologies.<\\/p><\\/li>\\r\\n        <\\/ul>\\r\\n        <br \\/>\\r\\n        <h4>How We Use Information<\\/h4>\\r\\n        <p>The information we collect allows us to:<\\/p>\\r\\n        <ul>\\r\\n            <li>Operate and maintain the Website effectively.<\\/li>\\r\\n            <li>Send you newsletters or marketing communications, but only with your consent.<\\/li>\\r\\n            <li>Respond to your inquiries and fulfill your requests.<\\/li>\\r\\n            <li>Improve the Website and your user experience.<\\/li>\\r\\n            <li>Personalize your experience on the Website based on your browsing habits.<\\/li>\\r\\n            <li>Analyze how the Website is used to improve our services.<\\/li>\\r\\n            <li>Comply with legal and regulatory requirements.<\\/li>\\r\\n        <\\/ul>\\r\\n        <br \\/>\\r\\n        <h4>Sharing of Information<\\/h4>\\r\\n        <p>We may share your information with trusted third-party service providers who assist us in operating the Website and delivering our services. These providers are obligated by contract to keep your information confidential and use it only for the specific purposes we disclose it for.<\\/p>\\r\\n        <p>We will never share your personal information with any third parties for marketing purposes without your explicit consent.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Data Retention<\\/h4>\\r\\n        <p>We retain your personal information only for as long as necessary to fulfill the purposes it was collected for. We may retain it for longer periods only if required or permitted by law.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Security Measures<\\/h4>\\r\\n        <p>We take reasonable precautions to protect your information from unauthorized access, disclosure, alteration, or destruction. However, complete security cannot be guaranteed for any website or internet transmission.<\\/p>\\r\\n        <br \\/>\\r\\n        <h4>Changes to this Privacy Policy<\\/h4>\\r\\n        <p>We may update this Privacy Policy periodically. We will notify you of any changes by posting the revised policy on the Website. We recommend reviewing this policy regularly to stay informed of any updates.<\\/p>\\r\\n        <p><strong>Remember:<\\/strong>  This is a sample policy and may need adjustments to comply with specific laws and reflect your website\'s unique data practices. Consider consulting with a legal professional to ensure your policy is fully compliant.<\\/p>\"}', '{\"image\":\"6635d5d9618e71714804185.png\",\"description\":null,\"social_title\":null,\"social_description\":null,\"keywords\":null}', 'basic', 'terms-of-service', '2021-06-09 08:51:18', '2024-05-12 05:47:29'),
(44, 'maintenance.data', '{\"description\":\"<div class=\\\"mb-5\\\" style=\\\"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;\\\"><font color=\\\"#ff0000\\\">THE SITE IS UNDER MAINTENANCE<\\/font><\\/h3><p class=\\\"font-18\\\" style=\\\"color: rgb(111, 111, 111); text-align: center; margin-right: 0px; margin-left: 0px; font-size: 18px !important;\\\">We\'re just tuning up a few things.We apologize for the inconvenience but Front is currently undergoing planned maintenance. Thanks for your patience.<\\/p><\\/div>\",\"image\":\"6603c203472ad1711522307.png\"}', NULL, NULL, NULL, '2020-07-04 23:42:52', '2024-03-27 06:51:47'),
(52, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Digital vs. Physical Gold: Which is Right for You?\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"674fffc97f38a1733296073.png\"}', NULL, 'basic', 'digital-vs-physical-gold-which-is-right-for-you', '2024-03-24 06:52:04', '2024-12-04 01:14:08'),
(55, 'counter.content', '{\"heading\":\"Latest Newsss\",\"subheading\":\"Lorem ipsum dolor sit, amet consectetur adipisicing elit. Doloribus necessitatibus repudiandae porro reprehenderit, beatae perferendis repellat quo ipsa omnis, vitae!\"}', NULL, 'basic', '', '2024-04-21 01:13:50', '2024-04-21 01:13:50'),
(56, 'counter.content', '{\"heading\":\"Latest News\",\"subheading\":\"Lorem ipsum dolor sit, amet consectetur adipisicing elit. Doloribus necessitatibus repudiandae porro reprehenderit, beatae perferendis repellat quo ipsa omnis, vitae!\"}', NULL, 'basic', '', '2024-04-21 01:13:52', '2024-04-21 01:13:52'),
(60, 'kyc.content', '{\"required\":\"Complete KYC to unlock the full potential of our platform! KYC helps us verify your identity and keep things secure. It is quick and easy just follow the on-screen instructions. Get started with KYC verification now!\",\"pending\":\"Your KYC verification is being reviewed. We might need some additional information. You will get an email update soon. In the meantime, explore our platform with limited features.\"}', NULL, 'basic', '', '2024-04-25 06:35:35', '2024-04-25 06:35:35'),
(61, 'kyc.content', '{\"required\":\"Complete KYC to unlock the full potential of our platform! KYC helps us verify your identity and keep things secure. It is quick and easy just follow the on-screen instructions. Get started with KYC verification now!\",\"pending\":\"Your KYC verification is being reviewed. We might need some additional information. You will get an email update soon. In the meantime, explore our platform with limited features.\",\"reject\":\"We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards.\"}', NULL, 'basic', '', '2024-04-25 06:40:29', '2024-04-25 06:40:29'),
(62, 'blog.content', '{\"heading\":\"Explore Gold Investment Insights\",\"subheading\":\"Stay informed with the latest updates, expert tips, and strategies to grow your wealth with gold\"}', NULL, 'basic', '', '2024-04-30 07:31:30', '2024-12-04 01:04:33'),
(64, 'banner.content', '{\"has_image\":\"1\",\"heading\":\"Secure Your Future Invest in {{Gold}}\",\"subheading\":\"Gold is a timeless asset that protects wealth from inflation and market volatility. Diversify your portfolio with gold for long-term financial security.\",\"button_one\":\"Buy Gold Now\",\"button_one_url\":\"user\\/buy\",\"button_two\":\"Join Us\",\"button_two_url\":\"user\\/register\",\"background_image\":\"674edccd2c0a91733221581.png\"}', NULL, 'basic', '', '2024-05-01 00:06:45', '2024-12-21 07:29:17'),
(66, 'register_disable.content', '{\"has_image\":\"1\",\"heading\":\"Registration Currently Disabled\",\"subheading\":\"Page you are looking for doesn\'t exit or an other error occurred or temporarily unavailable.\",\"button_name\":\"Go to Home\",\"button_url\":\"#\",\"image\":\"663a0f20ecd0b1715080992.png\"}', NULL, 'basic', '', '2024-05-07 05:23:12', '2024-05-07 05:28:09'),
(67, 'service.element', '{\"title\":\"Buy Gold\",\"description\":\"<h5 class=\\\"service-content__title\\\">Purchase gold instantly at competitive market rates with full transparency.<\\/h5>\\r\\n                                <ul class=\\\"service-content__list\\\">\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                          <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Purchase gold instantly at live market rates.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                          <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Less minimum purchase\\u2014invest in any amount that fits your budget.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                          <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Secure online transactions with advanced encryption.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                          <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Easy storage in your ViserGold wallet for seamless management.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                <\\/ul>\"}', NULL, 'basic', '', '2024-12-03 04:53:16', '2025-01-19 12:34:05'),
(68, 'service.element', '{\"title\":\"Sell Gold\",\"description\":\"<h5 class=\\\"service-content__title\\\">Sell gold instantly at competitive market rates with full transparency.<\\/h5>\\r\\n                                <ul class=\\\"service-content__list\\\">\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                        <i class=\\\"lab la-dropbox\\\"><\\/i>  \\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Sell gold instantly at live market rates.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                        <i class=\\\"lab la-dropbox\\\"><\\/i>  \\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Less minimum sell\\u2014invest in any amount that fits your budget.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                        <i class=\\\"lab la-dropbox\\\"><\\/i>  \\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Secure online transactions with advanced encryption.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                        <i class=\\\"lab la-dropbox\\\"><\\/i>  \\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Easy storage in your ViserGold wallet for seamless management.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                <\\/ul>\"}', NULL, 'basic', '', '2024-12-03 04:56:26', '2025-01-19 12:33:39'),
(69, 'service.element', '{\"title\":\"Redeem Gold\",\"description\":\"<h5 class=\\\"service-content__title\\\">Redeem gold as bars or coins at competitive market rates with complete transparency.\\r\\n<\\/h5>\\r\\n<h5 class=\\\"service-content__title\\\"><\\/h5>\\r\\n<ul class=\\\"service-content__list\\\">\\r\\n    <li class=\\\"service-content__list-item\\\"><span class=\\\"service-content__list-icon\\\">\\r\\n        <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n    <\\/span><span class=\\\"service-content__list-text\\\">Redeem gold at live market rates.<\\/span><\\/li>\\r\\n    <li class=\\\"service-content__list-item\\\"><span class=\\\"service-content__list-icon\\\"><i class=\\\"lab la-dropbox\\\"><\\/i><\\/span>Redeem with bars or coins or\\r\\n        both.<\\/li>\\r\\n    <li class=\\\"service-content__list-item\\\"><span class=\\\"service-content__list-icon\\\"><i class=\\\"lab la-dropbox\\\"><\\/i><\\/span><span class=\\\"service-content__list-text\\\">Secure online transactions with advanced encryption.<\\/span><\\/li>\\r\\n    <li class=\\\"service-content__list-item\\\"><span class=\\\"service-content__list-icon\\\"><i class=\\\"lab la-dropbox\\\"><\\/i><\\/span><span class=\\\"service-content__list-text\\\">Easy storage in your ViserGold wallet for seamless management.<\\/span>\\r\\n    <\\/li>\\r\\n<\\/ul>\"}', NULL, 'basic', '', '2024-12-03 04:56:50', '2025-01-19 12:32:04'),
(70, 'service.element', '{\"title\":\"Gift Gold\",\"description\":\"<h5 class=\\\"service-content__title\\\">Instantly gift gold to anyone, anytime, with a minimal fee.<\\/h5>\\r\\n                                <ul class=\\\"service-content__list\\\">\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                            <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Gift gold instantly with anyone.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                            <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Less minimum amount to transfer \\u2014invest in any amount that fits your budget.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                            <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Secure online transactions with advanced encryption.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                    <li class=\\\"service-content__list-item\\\">\\r\\n                                        <span class=\\\"service-content__list-icon\\\">\\r\\n                                            <i class=\\\"lab la-dropbox\\\"><\\/i>\\r\\n                                        <\\/span>\\r\\n                                        <span class=\\\"service-content__list-text\\\">Easy storage in your ViserGold wallet for seamless management.<\\/span>\\r\\n                                    <\\/li>\\r\\n                                <\\/ul>\"}', NULL, 'basic', '', '2024-12-03 04:56:59', '2025-01-19 12:33:00'),
(71, 'why_invest.content', '{\"heading\":\"Why Invest in Gold?\",\"subheading\":\"Investing in gold offers stability and protection, especially during economic downturns and inflation. As a tangible asset with global demand, gold maintains its value over time, providing a secure way to diversify and safeguard wealth. It\\u2019s also a highly liquid asset, allowing easy access whenever financial needs arise.\"}', NULL, 'basic', '', '2024-12-03 06:32:13', '2024-12-03 06:32:13'),
(72, 'feature.content', '{\"has_image\":\"1\",\"heading\":\"Why Choose ViserGold?\",\"subheading\":\"Trusted, Transparent, and Tailored for Your Gold Investment Needs\",\"icon\":\"<i class=\\\"fa-solid fa-shield\\\"><\\/i>\",\"top_image\":\"674fe4f0320421733289200.png\",\"left_image\":\"674fe4f235f741733289202.png\",\"right_image\":\"674fe4f245e281733289202.png\"}', NULL, 'basic', '', '2024-12-03 23:13:20', '2024-12-03 23:13:22'),
(73, 'feature.element', '{\"title\":\"Competitive Pricing\",\"subtitle\":\"Benefit from real-time market rates and transparent pricing, ensuring you always get the best value.\",\"icon\":\"<i class=\\\"fa-solid fa-flag\\\"><\\/i>\"}', NULL, 'basic', '', '2024-12-03 23:26:34', '2024-12-03 23:26:34'),
(74, 'feature.element', '{\"title\":\"Secure Transactions\",\"subtitle\":\"Our platform makes it easy to set up and manage transactions, reducing the time and effort needed to complete a deal.\",\"icon\":\"<i class=\\\"fa-solid fa-shield-halved\\\"><\\/i>\"}', NULL, 'basic', '', '2024-12-03 23:27:17', '2024-12-03 23:27:17'),
(75, 'feature.element', '{\"title\":\"Easy Liquidity\",\"subtitle\":\"Enjoy the flexibility to sell or withdraw your gold value quickly, with seamless access to funds when you need them.\",\"icon\":\"<i class=\\\"fa-solid fa-sack-dollar\\\"><\\/i>\"}', NULL, 'basic', '', '2024-12-03 23:27:40', '2024-12-03 23:27:40'),
(76, 'feature.element', '{\"title\":\"User-Friendly Experience\",\"subtitle\":\"Send the gift of gold with ease, choosing from customizable options to make every gift meaningful and memorable\",\"icon\":\"<i class=\\\"fa-solid fa-id-card-clip\\\"><\\/i>\"}', NULL, 'basic', '', '2024-12-03 23:28:02', '2024-12-03 23:28:02'),
(77, 'how_it_works.content', '{\"has_image\":\"1\",\"heading\":\"How ViserGold Works\",\"subheading\":\"From signup to securing gold, we make each step simple and seamless.\",\"background_image\":\"674fed40c01d21733291328.png\"}', NULL, 'basic', '', '2024-12-03 23:41:42', '2024-12-03 23:48:50'),
(78, 'how_it_works_step_one.content', '{\"has_image\":\"1\",\"title_one\":\"Sign Up\",\"subtitle_one\":\"Create your ViserGold account in minutes with a secure and simple registration process. Complete KYC verification to access all platform features\",\"title_two\":\"Buy Gold\",\"subtitle_two\":\"Easily purchase gold at competitive rates with real-time pricing. Select your preferred amount and add it securely to your ViserGold account\",\"title_three\":\"Store Gold\",\"subtitle_three\":\"Your purchased gold is stored securely in our high-security vaults, giving you peace of mind and 24\\/7 access to your holdings\",\"image_one\":\"674febd3ca4f71733290963.png\",\"image_two\":\"674febd57f4991733290965.png\",\"image_three\":\"674febd58007f1733290965.png\"}', NULL, 'basic', '', '2024-12-03 23:42:43', '2024-12-03 23:42:45'),
(79, 'how_it_works_step_two.content', '{\"has_image\":\"1\",\"title_one\":\"Sell Gold\",\"subtitle_one\":\"Instantly sell any portion of your stored gold at current market rates and enjoy easy access to funds in your account.\",\"title_two\":\"Withdraw Gold\",\"subtitle_two\":\"Instantly sell any portion of your stored gold at current market rates and enjoy easy access to funds in your account.\",\"title_three\":\"Gift Gold\",\"subtitle_three\":\"Instantly sell any portion of your stored gold at current market rates and enjoy easy access to funds in your account.\",\"image_one\":\"674febffaac6a1733291007.png\",\"image_two\":\"674febffb05b81733291007.png\",\"image_three\":\"674febffb0dd01733291007.png\"}', NULL, 'basic', '', '2024-12-03 23:43:27', '2024-12-03 23:43:27'),
(80, 'how_it_works_step_three.content', '{\"has_image\":\"1\",\"title_one\":\"Withdraw Money\",\"subtitle_one\":\"Sell any portion of your stored gold and easily withdraw the equivalent cash value to your bank account. Enjoy fast access to your funds whenever you need them.\",\"title_two\":\"Home Delivery\",\"subtitle_two\":\"Prefer physical gold? Choose the convenient home delivery option, and have your gold securely shipped to your doorstep\",\"title_three\":\"Pickup Point\",\"subtitle_three\":\"Pick up your gold from a nearby secure location. With multiple pickup points available,\",\"image_one\":\"674fec7bca42a1733291131.png\",\"image_two\":\"674fec7bcf67d1733291131.png\",\"image_three\":\"674fec7bcfe211733291131.png\"}', NULL, 'basic', '', '2024-12-03 23:45:31', '2024-12-03 23:45:31'),
(81, 'testimonial.content', '{\"heading\":\"Hear from Our Happy Customers\",\"subheading\":\"Discover how ViserGold makes gold investing easy, safe, and rewarding\"}', NULL, 'basic', '', '2024-12-04 00:35:49', '2024-12-04 00:35:49'),
(82, 'testimonial.element', '{\"has_image\":[\"1\"],\"title\":\"\\u201cThe best Webflow Templates\\u201d\",\"subtitle\":\"Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat aute irure sint amet occaecat cupidatat non proident\",\"author\":\"Adam Smith\",\"designation\":\"CEO at Webflow Agency\",\"author_image\":\"674ff8d2466021733294290.png\"}', NULL, 'basic', '', '2024-12-04 00:38:10', '2024-12-04 00:38:10'),
(83, 'testimonial.element', '{\"has_image\":[\"1\"],\"title\":\"\\u201cThe best Webflow Templates\\u201d\",\"subtitle\":\"Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat aute irure sint amet occaecat cupidatat non proident\",\"author\":\"Adam Smith\",\"designation\":\"CEO at Webflow Agency\",\"author_image\":\"674ff8ec95c7b1733294316.png\"}', NULL, 'basic', '', '2024-12-04 00:38:36', '2024-12-04 00:38:36'),
(84, 'testimonial.element', '{\"has_image\":[\"1\"],\"title\":\"\\u201cThe best Webflow Templates\\u201d\",\"subtitle\":\"Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat aute irure sint amet occaecat cupidatat non proident\",\"author\":\"Adam Smith\",\"designation\":\"CEO at Webflow Agency\",\"author_image\":\"674ffa2eaac3a1733294638.png\"}', NULL, 'basic', '', '2024-12-04 00:43:58', '2024-12-04 00:43:58'),
(85, 'faq.content', '{\"has_image\":\"1\",\"heading\":\"Frequently Asked Questions\",\"subheading\":\"Find answers to the most common questions about ViserGold and our services\",\"title\":\"Still have a questions?\",\"subtitle\":\"Feel free to contact us with any questions.\",\"button_text\":\"Contact\",\"button_url\":\"contact\",\"image\":\"674ffbb78c88c1733295031.png\"}', NULL, 'basic', '', '2024-12-04 00:50:31', '2024-12-22 05:52:48'),
(86, 'faq.element', '{\"question\":\"How do I create an account on ViserGold?\",\"answer\":\"Secure payment is processed through the app, and both parties can rate each other, enhancing trust and service quality.\"}', NULL, 'basic', '', '2024-12-04 00:50:59', '2024-12-04 00:50:59'),
(87, 'faq.element', '{\"question\":\"Is my gold stored securely with ViserGold?\",\"answer\":\"Secure payment is processed through the app, and both parties can rate each other. Riders enter their trip details, and drivers submit competitive bids. Riders can compare offers based on price and ratings. enhancing trust and service quality.\"}', NULL, 'basic', '', '2024-12-04 00:51:10', '2024-12-04 00:51:10'),
(88, 'faq.element', '{\"question\":\"How do I buy gold, and what are the payment options?\",\"answer\":\"Riders enter their trip details, and drivers submit competitive bids. Riders can compare offers based on price and ratings. Secure payment is processed through the app, and both parties can rate each other, enhancing trust and service quality.\"}', NULL, 'basic', '', '2024-12-04 00:51:21', '2024-12-04 00:51:21'),
(89, 'faq.element', '{\"question\":\"Can I sell my gold at any time?\",\"answer\":\"Secure payment is processed through the app, and both parties can rate each other, enhancing trust and service quality.\"}', NULL, 'basic', '', '2024-12-04 00:51:32', '2024-12-04 00:51:32'),
(90, 'faq.element', '{\"question\":\"What withdrawal options are available for my gold?\",\"answer\":\"Secure payment is processed through the app, and both parties can rate each other. Riders enter their trip details, and drivers submit competitive bids. Riders can compare offers based on price and ratings. enhancing trust and service quality.\"}', NULL, 'basic', '', '2024-12-04 00:51:44', '2024-12-04 00:51:44'),
(91, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"A Look at Gold Price Trends Over the Last Decade\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"6750027a1964b1733296762.png\"}', NULL, 'basic', 'a-look-at-gold-price-trends-over-the-last-decade', '2024-12-04 01:19:22', '2024-12-04 01:21:22'),
(92, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Gifting Gold: A Unique and Lasting Present\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"67500291b0b7f1733296785.png\"}', NULL, 'basic', 'gifting-gold-a-unique-and-lasting-present', '2024-12-04 01:19:45', '2024-12-04 01:21:31'),
(93, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ab9b5f601733302969.png\"}', NULL, 'basic', '', '2024-12-04 03:02:49', '2024-12-04 03:02:51'),
(94, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ac22b8f91733302978.png\"}', NULL, 'basic', '', '2024-12-04 03:02:58', '2024-12-04 03:02:58'),
(95, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ac8286591733302984.png\"}', NULL, 'basic', '', '2024-12-04 03:03:04', '2024-12-04 03:03:04'),
(96, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ace53eee1733302990.png\"}', NULL, 'basic', '', '2024-12-04 03:03:10', '2024-12-04 03:03:10'),
(97, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ad61f9eb1733302998.png\"}', NULL, 'basic', '', '2024-12-04 03:03:18', '2024-12-04 03:03:18'),
(98, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501adbce53c1733303003.png\"}', NULL, 'basic', '', '2024-12-04 03:03:23', '2024-12-04 03:03:23'),
(99, 'payment_methods.element', '{\"has_image\":\"1\",\"image\":\"67501ae148bd41733303009.png\"}', NULL, 'basic', '', '2024-12-04 03:03:29', '2024-12-04 03:03:29'),
(100, 'subscribe.content', '{\"has_image\":\"1\",\"heading\":\"Start Your {{Gold Investment }} Journey Today\",\"subheading\":\"Sign up now to experience secure, flexible, and accessible gold trading with ViserGold.\",\"background_image\":\"67501bdf1ffc91733303263.png\"}', NULL, 'basic', '', '2024-12-04 03:05:10', '2024-12-04 03:09:58'),
(101, 'login.content', '{\"has_image\":\"1\",\"heading\":\"Your Gold, Your Control\",\"subheading\":\"Login to access your account, track your assets, and stay updated on gold market trends\",\"background_image\":\"67502395c6e191733305237.png\"}', NULL, 'basic', '', '2024-12-04 03:40:37', '2024-12-04 03:40:38'),
(102, 'register.content', '{\"has_image\":\"1\",\"heading\":\"Your Gold, Your Control\",\"subheading\":\"Register to access your account, track your assets, and stay updated on gold market trends\",\"background_image\":\"675038bd674571733310653.png\"}', NULL, 'basic', '', '2024-12-04 05:10:53', '2024-12-04 05:10:54'),
(103, 'breadcrumb.content', '{\"has_image\":\"1\",\"breadcrumb_image\":\"6751477ba80151733379963.png\"}', NULL, 'basic', '', '2024-12-05 06:26:03', '2024-12-05 06:26:04'),
(104, 'social_icon.element', '{\"title\":\"Instragram\",\"social_icon\":\"<i class=\\\"fa-brands fa-instagram\\\"><\\/i>\",\"url\":\"https:\\/\\/www.instagram.com\"}', NULL, 'basic', '', '2024-12-05 09:01:03', '2024-12-05 09:01:03'),
(105, 'social_icon.element', '{\"title\":\"Twitter\",\"social_icon\":\"<i class=\\\"fa-brands fa-x-twitter\\\"><\\/i>\",\"url\":\"https:\\/\\/www.twitter.com\"}', NULL, 'basic', '', '2024-12-05 09:01:28', '2024-12-05 09:01:28'),
(106, 'social_icon.element', '{\"title\":\"Linkedin\",\"social_icon\":\"<i class=\\\"fa-brands fa-linkedin\\\"><\\/i>\",\"url\":\"https:\\/\\/www.linkedin.com\"}', NULL, 'basic', '', '2024-12-05 09:01:56', '2024-12-05 09:01:56'),
(107, 'app_onboarding.element', '{\"has_image\":[\"1\"],\"title\":\"Test\",\"description\":\"tewstsdfsd\",\"image\":\"6762941fe48ee1734513695.png\"}', NULL, 'basic', '', '2024-12-18 09:21:35', '2024-12-18 09:21:38'),
(108, 'app_onboarding.element', '{\"has_image\":[\"1\"],\"title\":\"Test 2\",\"description\":\"testsf s\",\"image\":\"6762942d325991734513709.png\"}', NULL, 'basic', '', '2024-12-18 09:21:49', '2024-12-18 09:21:49'),
(111, 'footer.content', '{\"short_description\":\"A gold trading platform where users can buy, sell, redeem, and gift gold seamlessly, ensuring secure and efficient transactions.\"}', NULL, 'basic', '', '2025-01-11 06:03:22', '2025-01-11 06:03:23');
INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `seo_content`, `tempname`, `slug`, `created_at`, `updated_at`) VALUES
(112, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Sell Gold Easily with Trusted Platforms\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"678df64d510c41737356877.png\"}', NULL, 'basic', 'sell-gold-easily-with-trusted-platforms', '2025-01-20 01:07:57', '2025-01-20 01:07:57'),
(113, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Top Tips for Buying Gold Digitally\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"678df65c442591737356892.png\"}', NULL, 'basic', 'top-tips-for-buying-gold-digitally', '2025-01-20 01:08:12', '2025-01-20 01:08:12'),
(114, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Mastering Gold Trading Online Securely\",\"description\":\"<p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            A data-driven piece on how gold prices have fluctuated in the past ten years, with projections. Tips and ideas on gifting gold, including occasions, customization options, and the value. Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.\\r\\n                        <\\/p>\\r\\n                        <div class=\\\"quote-text\\\">\\r\\n                            <p class=\\\"quote-text__desc\\\">\\r\\n                                Aut officiis iure officia nostrum quas, molestias minus. Molestiae\\r\\n                                blanditiis doloribus dolor vel ex quibusdam, explicabo distinctio tenetur nam\\r\\n                                nostrum corrupti vero, pariatur consectetur eveniet odio aliquid quos fuga nihil deserunt!\\r\\n                                Corporis quisquam, magnam doloremque fugit quasi, quae quo totam error sunt, ab\\r\\n                                nostrum\\r\\n                            <\\/p>\\r\\n                        <\\/div>\\r\\n                        <p class=\\\"blog-details__desc\\\">Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis\\r\\n                            atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quiLorem\\r\\n                            ipsum\\r\\n                            it. Quis atque excepturi cupiditate soluta nisi aperiam illum maxime dolorum. Impedit,\\r\\n                            quibusdam. Lorem ipsum dolor sit amet consectetur adipisicing elit. Quis atque excepturi\\r\\n                            cupiditate soluta nisi aperiam illum maxime dolorum. Impedit, quibusdam.\\r\\n                        <\\/p>\\r\\n                        <p class=\\\"blog-details__desc\\\">\\r\\n                            Tips and ideas on gifting gold, including occasions, customization options, and the value. A data-driven piece on how gold prices have fluctuated in the past ten years, with projections.<\\/p><div class=\\\"blog-details__share mt-4 d-flex align-items-center flex-wrap\\\"><ul class=\\\"social-list\\\"><li class=\\\"social-list__item\\\">\\r\\n                                <\\/li>\\r\\n                            <\\/ul>\\r\\n                        <\\/div>\",\"image\":\"678df66d5ade51737356909.png\"}', NULL, 'basic', 'mastering-gold-trading-online-securely', '2025-01-20 01:08:29', '2025-01-20 01:08:29'),
(115, 'app_sliders.element', '{\"has_image\":\"1\",\"image\":\"67a09902a4e4f1738578178.png\"}', NULL, 'basic', '', '2025-01-21 18:27:58', '2025-02-02 22:22:58'),
(116, 'app_sliders.element', '{\"has_image\":\"1\",\"image\":\"67a098f9477921738578169.png\"}', NULL, 'basic', '', '2025-01-21 18:28:35', '2025-02-02 22:22:49'),
(117, 'app_sliders.element', '{\"has_image\":\"1\",\"image\":\"67a099d9a72f01738578393.png\"}', NULL, 'basic', '', '2025-01-29 23:11:12', '2025-02-02 22:26:33'),
(118, 'app_onboarding.element', '{\"has_image\":[\"1\"],\"title\":\"Trust and Security\",\"description\":\"Your gold investments are fully secure. Trade with confidence, knowing your assets are protected\",\"image\":\"679f34e56b3341738487013.png\"}', NULL, 'basic', '', '2025-01-29 23:47:01', '2025-02-01 21:03:33');

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

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

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

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

INSERT INTO `gateways` (`id`, `form_id`, `code`, `name`, `alias`, `image`, `status`, `gateway_parameters`, `supported_currencies`, `crypto`, `extra`, `description`, `created_at`, `updated_at`) VALUES
(1, 0, 101, 'Paypal', 'Paypal', '664dfd7220ea11716387186.png', 1, '{\"paypal_email\":{\"title\":\"PayPal Email\",\"global\":true,\"value\":\"sb-owud61543012@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', '2024-05-07 08:21:11'),
(2, 0, 102, 'Perfect Money', 'PerfectMoney', '664dfdbde08241716387261.png', 1, '{\"passphrase\":{\"title\":\"ALTERNATE PASSPHRASE\",\"global\":true,\"value\":\"hR26aw02Q1eEeUPSIfuwNypXX\"},\"wallet_id\":{\"title\":\"PM Wallet\",\"global\":false,\"value\":\"\"}}', '{\"USD\":\"$\",\"EUR\":\"\\u20ac\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:22:24'),
(3, 0, 103, 'Stripe Hosted', 'Stripe', '664dfe040cd961716387332.png', 1, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"}}', '{\"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, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:24:06'),
(4, 0, 104, 'Skrill', 'Skrill', '664dfde4de9ce1716387300.png', 1, '{\"pay_to_email\":{\"title\":\"Skrill Email\",\"global\":true,\"value\":\"merchant@skrill.com\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"---\"}}', '{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"MAD\":\"MAD\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"SAR\":\"SAR\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TND\":\"TND\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\",\"COP\":\"COP\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:23:05'),
(5, 0, 105, 'PayTM', 'Paytm', '664dfdab9a3541716387243.png', 1, '{\"MID\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"DIY12386817555501617\"},\"merchant_key\":{\"title\":\"Merchant Key\",\"global\":true,\"value\":\"bKMfNxPPf_QdZppa\"},\"WEBSITE\":{\"title\":\"Paytm Website\",\"global\":true,\"value\":\"DIYtestingweb\"},\"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', '2024-05-07 08:22:07'),
(6, 0, 106, 'Payeer', 'Payeer', '664dfd5e82cc51716387166.png', 1, '{\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"866989763\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"7575\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\",\"RUB\":\"RUB\"}', 0, '{\"status\":{\"title\": \"Status URL\",\"value\":\"ipn.Payeer\"}}', NULL, '2019-09-14 13:14:22', '2024-05-07 08:20:57'),
(7, 0, 107, 'PayStack', 'Paystack', '664dfd95568601716387221.png', 1, '{\"public_key\":{\"title\":\"Public key\",\"global\":true,\"value\":\"pk_test_cd330608eb47970889bca397ced55c1dd5ad3783\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"sk_test_8a0b1f199362d7acc9c390bff72c4e81f74e2ac3\"}}', '{\"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', '2024-05-07 08:21:48'),
(9, 0, 109, 'Flutterwave', 'Flutterwave', '664dfcc5090a81716387013.png', 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', '2024-05-07 08:12:18'),
(10, 0, 110, 'RazorPay', 'Razorpay', '664dfdd5dc6711716387285.png', 1, '{\"key_id\":{\"title\":\"Key Id\",\"global\":true,\"value\":\"rzp_test_kiOtejPbRZU90E\"},\"key_secret\":{\"title\":\"Key Secret \",\"global\":true,\"value\":\"osRDebzEqbsE1kbyQJ4y0re7\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:22:50'),
(11, 0, 111, 'Stripe Storefront', 'StripeJs', '664dfe135db781716387347.png', 1, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"}}', '{\"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, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:24:21'),
(12, 0, 112, 'Instamojo', 'Instamojo', '664dfcdd1400b1716387037.png', 1, '{\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"test_2241633c3bc44a3de84a3b33969\"},\"auth_token\":{\"title\":\"Auth Token\",\"global\":true,\"value\":\"test_279f083f7bebefd35217feef22d\"},\"salt\":{\"title\":\"Salt\",\"global\":true,\"value\":\"19d38908eeff4f58b2ddda2c6d86ca25\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:18:53'),
(13, 0, 501, 'Blockchain', 'Blockchain', '664dfbe83f9da1716386792.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"55529946-05ca-48ff-8710-f279d86b1cc5\"},\"xpub_code\":{\"title\":\"XPUB CODE\",\"global\":true,\"value\":\"xpub6CKQ3xxWyBoFAF83izZCSFUorptEU9AF8TezhtWeMU5oefjX3sFSBw62Lr9iHXPkXmDQJJiHZeTRtD9Vzt8grAYRhvbz4nEvBu3QKELVzFK\"}}', '{\"BTC\":\"BTC\"}', 1, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:08:47'),
(15, 0, 503, 'CoinPayments', 'Coinpayments', '664dfc7d215d21716386941.png', 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', '2024-05-07 08:11:52'),
(16, 0, 504, 'CoinPayments Fiat', 'CoinpaymentsFiat', '664dfcb43e4821716386996.png', 1, '{\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"6515561\"}}', '{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:12:07'),
(17, 0, 505, 'Coingate', 'Coingate', '664dfc56873fa1716386902.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"6354mwVCEw5kHzRJ6thbGo-N\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:11:26'),
(18, 0, 506, 'Coinbase Commerce', 'CoinbaseCommerce', '664dfc379fda91716386871.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"c47cd7df-d8e8-424b-a20a\"},\"secret\":{\"title\":\"Webhook Shared Secret\",\"global\":true,\"value\":\"55871878-2c32-4f64-ab66\"}}', '{\"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', '2024-05-07 08:11:10'),
(24, 0, 113, 'Paypal Express', 'PaypalSdk', '664dfd81a377c1716387201.png', 1, '{\"clientId\":{\"title\":\"Paypal Client ID\",\"global\":true,\"value\":\"Ae0-tixtSV7DvLwIh3Bmu7JvHrjh5EfGdXr_cEklKAVjjezRZ747BxKILiBdzlKKyp-W8W_T7CKH1Ken\"},\"clientSecret\":{\"title\":\"Client Secret\",\"global\":true,\"value\":\"EOhbvHZgFNO21soQJT1L9Q00M3rK6PIEsdiTgXRBt2gtGtxwRer5JvKnVUGNU5oE63fFnjnYY7hq3HBA\"}}', '{\"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', '2024-05-07 08:21:33'),
(25, 0, 114, 'Stripe Checkout', 'StripeV3', '664dfe21196ce1716387361.png', 1, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"},\"end_point\":{\"title\":\"End Point Secret\",\"global\":true,\"value\":\"whsec_lUmit1gtxwKTveLnSe88xCSDdnPOt8g5\"}}', '{\"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', '2024-05-07 08:24:47'),
(27, 0, 115, 'Mollie', 'Mollie', '664dfd0d48b421716387085.png', 1, '{\"mollie_email\":{\"title\":\"Mollie Email \",\"global\":true,\"value\":\"vi@gmail.com\"},\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"test_cucfwKTWfft9s337qsVfn5CC4vNkrn\"}}', '{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}', 0, NULL, NULL, '2019-09-14 13:14:22', '2024-05-07 08:19:42'),
(30, 0, 116, 'Cashmaal', 'Cashmaal', '664dfbf8bff2c1716386808.png', 1, '{\"web_id\":{\"title\":\"Web Id\",\"global\":true,\"value\":\"3748\"},\"ipn_key\":{\"title\":\"IPN Key\",\"global\":true,\"value\":\"546254628759524554647987\"}}', '{\"PKR\":\"PKR\",\"USD\":\"USD\"}', 0, '{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"ipn.Cashmaal\"}}', NULL, NULL, '2024-05-07 08:09:31'),
(36, 0, 119, 'Mercado Pago', 'MercadoPago', '664dfcf15fb551716387057.png', 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, NULL, NULL, NULL, '2024-05-07 08:19:24'),
(37, 0, 120, 'Authorize.net', 'Authorize', '664dfbac8036a1716386732.png', 1, '{\"login_id\":{\"title\":\"Login ID\",\"global\":true,\"value\":\"59e4P9DBcZv\"},\"transaction_key\":{\"title\":\"Transaction Key\",\"global\":true,\"value\":\"47x47TJyLw2E7DbR\"}}', '{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\"}', 0, NULL, NULL, NULL, '2024-05-07 08:07:53'),
(46, 0, 121, 'NMI', 'NMI', '664dfd1dd6b5b1716387101.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"2F822Rw39fx762MaV7Yy86jXGTC7sCDy\"}}', '{\"AED\":\"AED\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"RUB\":\"RUB\",\"SEC\":\"SEC\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}', 0, NULL, NULL, NULL, '2024-05-07 08:20:07'),
(50, 0, 507, 'BTCPay', 'BTCPay', '664dfbb91985a1716386745.png', 1, '{\"store_id\":{\"title\":\"Store Id\",\"global\":true,\"value\":\"HsqFVTXSeUFJu7caoYZc3CTnP8g5LErVdHhEXPVTheHf\"},\"api_key\":{\"title\":\"Api Key\",\"global\":true,\"value\":\"4436bd706f99efae69305e7c4eff4780de1335ce\"},\"server_name\":{\"title\":\"Server Name\",\"global\":true,\"value\":\"https:\\/\\/testnet.demo.btcpayserver.org\"},\"secret_code\":{\"title\":\"Secret Code\",\"global\":true,\"value\":\"SUCdqPn9CDkY7RmJHfpQVHP2Lf2\"}}', '{\"BTC\":\"Bitcoin\",\"LTC\":\"Litecoin\"}', 1, '{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"ipn.BTCPay\"}}', NULL, NULL, '2024-05-07 08:08:13'),
(51, 0, 508, 'Now payments hosted', 'NowPaymentsHosted', '664dfd47bc3b51716387143.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"--------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------------\"}}', '{\"BTG\":\"BTG\",\"ETH\":\"ETH\",\"XMR\":\"XMR\",\"ZEC\":\"ZEC\",\"XVG\":\"XVG\",\"ADA\":\"ADA\",\"LTC\":\"LTC\",\"BCH\":\"BCH\",\"QTUM\":\"QTUM\",\"DASH\":\"DASH\",\"XLM\":\"XLM\",\"XRP\":\"XRP\",\"XEM\":\"XEM\",\"DGB\":\"DGB\",\"LSK\":\"LSK\",\"DOGE\":\"DOGE\",\"TRX\":\"TRX\",\"KMD\":\"KMD\",\"REP\":\"REP\",\"BAT\":\"BAT\",\"ARK\":\"ARK\",\"WAVES\":\"WAVES\",\"BNB\":\"BNB\",\"XZC\":\"XZC\",\"NANO\":\"NANO\",\"TUSD\":\"TUSD\",\"VET\":\"VET\",\"ZEN\":\"ZEN\",\"GRS\":\"GRS\",\"FUN\":\"FUN\",\"NEO\":\"NEO\",\"GAS\":\"GAS\",\"PAX\":\"PAX\",\"USDC\":\"USDC\",\"ONT\":\"ONT\",\"XTZ\":\"XTZ\",\"LINK\":\"LINK\",\"RVN\":\"RVN\",\"BNBMAINNET\":\"BNBMAINNET\",\"ZIL\":\"ZIL\",\"BCD\":\"BCD\",\"USDT\":\"USDT\",\"USDTERC20\":\"USDTERC20\",\"CRO\":\"CRO\",\"DAI\":\"DAI\",\"HT\":\"HT\",\"WABI\":\"WABI\",\"BUSD\":\"BUSD\",\"ALGO\":\"ALGO\",\"USDTTRC20\":\"USDTTRC20\",\"GT\":\"GT\",\"STPT\":\"STPT\",\"AVA\":\"AVA\",\"SXP\":\"SXP\",\"UNI\":\"UNI\",\"OKB\":\"OKB\",\"BTC\":\"BTC\"}', 1, '', NULL, NULL, '2024-05-07 08:20:40'),
(52, 0, 509, 'Now payments checkout', 'NowPaymentsCheckout', '664dfd302a2281716387120.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"---------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\"}', 1, '', NULL, NULL, '2024-05-07 08:20:21'),
(53, 0, 122, '2Checkout', 'TwoCheckout', '664dfe3a690001716387386.png', 1, '{\"merchant_code\":{\"title\":\"Merchant Code\",\"global\":true,\"value\":\"253248016872\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"eQM)ID@&vG84u!O*g[p+\"}}', '{\"AFN\": \"AFN\",\"ALL\": \"ALL\",\"DZD\": \"DZD\",\"ARS\": \"ARS\",\"AUD\": \"AUD\",\"AZN\": \"AZN\",\"BSD\": \"BSD\",\"BDT\": \"BDT\",\"BBD\": \"BBD\",\"BZD\": \"BZD\",\"BMD\": \"BMD\",\"BOB\": \"BOB\",\"BWP\": \"BWP\",\"BRL\": \"BRL\",\"GBP\": \"GBP\",\"BND\": \"BND\",\"BGN\": \"BGN\",\"CAD\": \"CAD\",\"CLP\": \"CLP\",\"CNY\": \"CNY\",\"COP\": \"COP\",\"CRC\": \"CRC\",\"HRK\": \"HRK\",\"CZK\": \"CZK\",\"DKK\": \"DKK\",\"DOP\": \"DOP\",\"XCD\": \"XCD\",\"EGP\": \"EGP\",\"EUR\": \"EUR\",\"FJD\": \"FJD\",\"GTQ\": \"GTQ\",\"HKD\": \"HKD\",\"HNL\": \"HNL\",\"HUF\": \"HUF\",\"INR\": \"INR\",\"IDR\": \"IDR\",\"ILS\": \"ILS\",\"JMD\": \"JMD\",\"JPY\": \"JPY\",\"KZT\": \"KZT\",\"KES\": \"KES\",\"LAK\": \"LAK\",\"MMK\": \"MMK\",\"LBP\": \"LBP\",\"LRD\": \"LRD\",\"MOP\": \"MOP\",\"MYR\": \"MYR\",\"MVR\": \"MVR\",\"MRO\": \"MRO\",\"MUR\": \"MUR\",\"MXN\": \"MXN\",\"MAD\": \"MAD\",\"NPR\": \"NPR\",\"TWD\": \"TWD\",\"NZD\": \"NZD\",\"NIO\": \"NIO\",\"NOK\": \"NOK\",\"PKR\": \"PKR\",\"PGK\": \"PGK\",\"PEN\": \"PEN\",\"PHP\": \"PHP\",\"PLN\": \"PLN\",\"QAR\": \"QAR\",\"RON\": \"RON\",\"RUB\": \"RUB\",\"WST\": \"WST\",\"SAR\": \"SAR\",\"SCR\": \"SCR\",\"SGD\": \"SGD\",\"SBD\": \"SBD\",\"ZAR\": \"ZAR\",\"KRW\": \"KRW\",\"LKR\": \"LKR\",\"SEK\": \"SEK\",\"CHF\": \"CHF\",\"SYP\": \"SYP\",\"THB\": \"THB\",\"TOP\": \"TOP\",\"TTD\": \"TTD\",\"TRY\": \"TRY\",\"UAH\": \"UAH\",\"AED\": \"AED\",\"USD\": \"USD\",\"VUV\": \"VUV\",\"VND\": \"VND\",\"XOF\": \"XOF\",\"YER\": \"YER\"}', 0, '{\"approved_url\":{\"title\": \"Approved URL\",\"value\":\"ipn.TwoCheckout\"}}', NULL, NULL, '2024-05-07 08:24:56'),
(54, 0, 123, 'Checkout', 'Checkout', '664dfc212b4db1716386849.png', 1, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------\"},\"public_key\":{\"title\":\"PUBLIC KEY\",\"global\":true,\"value\":\"------\"},\"processing_channel_id\":{\"title\":\"PROCESSING CHANNEL\",\"global\":true,\"value\":\"------\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"AUD\":\"AUD\",\"CAN\":\"CAN\",\"CHF\":\"CHF\",\"SGD\":\"SGD\",\"JPY\":\"JPY\",\"NZD\":\"NZD\"}', 0, NULL, NULL, NULL, '2024-05-07 08:09:44'),
(55, 19, 1000, 'Bank Transfer', 'bank_transfer', '663b50fc3b21c1715163388.png', 1, '[]', '[]', 0, NULL, '<p style=\"margin-bottom: 10px; font-size: 17px; font-weight: bold; font-style: italic;\"><br></p><p style=\"margin-bottom: 10px; font-size: 17px; font-weight: bold; font-style: italic;\">Send the amount to the below bank information</p><p style=\"font-style: italic;\"></p><p style=\"font-style: italic;\">Bank Name:&nbsp;Bank of America</p><p style=\"font-style: italic;\">Branch:&nbsp;New York</p><p style=\"font-style: italic;\">Routing:&nbsp;1234</p><p style=\"font-style: italic;\">Account Number:&nbsp;997855xxxxxxxx6985</p>', '2024-03-13 23:11:21', '2024-12-22 05:16:11'),
(56, 0, 510, 'Binance', 'Binance', '664dfbc84638c1716386760.png', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"tsu3tjiq0oqfbtmlbevoeraxhfbp3brejnm9txhjxcp4to29ujvakvfl1ibsn3ja\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"jzngq4t04ltw8d4iqpi7admfl8tvnpehxnmi34id1zvfaenbwwvsvw7llw3zdko8\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"231129033\"}}', '{\"BTC\":\"Bitcoin\",\"USD\":\"USD\",\"BNB\":\"BNB\"}', 1, '{\"cron\":{\"title\": \"Cron Job URL\",\"value\":\"ipn.Binance\"}}', NULL, NULL, '2024-05-07 08:08:27'),
(57, 0, 124, 'SslCommerz', 'SslCommerz', '664dfdf36a9af1716387315.png', 1, '{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"---------\"},\"store_password\":{\"title\":\"Store Password\",\"global\":true,\"value\":\"----------\"}}', '{\"BDT\":\"BDT\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"SGD\":\"SGD\",\"INR\":\"INR\",\"MYR\":\"MYR\"}', 0, NULL, NULL, NULL, '2024-05-07 08:23:54'),
(58, 0, 125, 'Aamarpay', 'Aamarpay', '664dfb74187251716386676.png', 1, '{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"---------\"},\"signature_key\":{\"title\":\"Signature Key\",\"global\":true,\"value\":\"----------\"}}', '{\"BDT\":\"BDT\"}', 0, NULL, NULL, NULL, '2024-05-07 08:04:05');

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

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

CREATE TABLE `gateway_currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `currency` varchar(40) DEFAULT NULL,
  `symbol` varchar(40) DEFAULT NULL,
  `method_code` int(11) DEFAULT NULL,
  `gateway_alias` varchar(40) 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,
  `gateway_parameter` text 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 `gold_histories`
--

CREATE TABLE `gold_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT 0,
  `asset_id` int(10) NOT NULL DEFAULT 0,
  `recipient_id` int(10) NOT NULL DEFAULT 0,
  `category_id` int(10) NOT NULL DEFAULT 0,
  `quantity` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `vat` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `type` tinyint(1) NOT NULL DEFAULT 0,
  `trx` varchar(40) 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 `historical_prices`
--

CREATE TABLE `historical_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `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 `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `code` varchar(40) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: not default language, 1: default language',
  `image` varchar(40) 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 `languages`
--

INSERT INTO `languages` (`id`, `name`, `code`, `is_default`, `image`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 1, '660b94fa876ac1712035066.png', '2020-07-06 03:47:55', '2024-04-01 23:17:46');

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

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

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

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

--
-- Table structure for table `notification_logs`
--

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

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

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

CREATE TABLE `notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `act` varchar(40) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `push_title` varchar(255) DEFAULT NULL,
  `email_body` text DEFAULT NULL,
  `sms_body` text DEFAULT NULL,
  `push_body` text DEFAULT NULL,
  `shortcodes` text DEFAULT NULL,
  `email_status` tinyint(1) NOT NULL DEFAULT 1,
  `email_sent_from_name` varchar(40) DEFAULT NULL,
  `email_sent_from_address` varchar(40) DEFAULT NULL,
  `sms_status` tinyint(1) NOT NULL DEFAULT 1,
  `sms_sent_from` varchar(40) DEFAULT NULL,
  `push_status` 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 `notification_templates`
--

INSERT INTO `notification_templates` (`id`, `act`, `name`, `subject`, `push_title`, `email_body`, `sms_body`, `push_body`, `shortcodes`, `email_status`, `email_sent_from_name`, `email_sent_from_address`, `sms_status`, `sms_sent_from`, `push_status`, `created_at`, `updated_at`) VALUES
(1, 'BAL_ADD', 'Balance - Added', 'Your Account has been Credited', '{{site_name}} - Balance Added', '<div>We\'re writing to inform you that an amount of {{amount}} {{site_currency}} has been successfully added to your account.</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Transaction Number: </b>{{trx}}</div><div><b>Current Balance:</b> {{post_balance}} {{site_currency}}</div><div><b>Admin Note:</b> {{remark}}</div><div><br></div><div>If you have any questions or require further assistance, please don\'t hesitate to contact us. We\'re here to assist you.</div>', 'We\'re writing to inform you that an amount of {{amount}} {{site_currency}} has been successfully added to your account.', '{{amount}} {{site_currency}} has been successfully added to your account.', '{\"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, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-05-25 00:49:44'),
(2, 'BAL_SUB', 'Balance - Subtracted', 'Your Account has been Debited', '{{site_name}} - Balance Subtracted', '<div>We wish to inform you that an amount of {{amount}} {{site_currency}} has been successfully deducted from your account.</div><div><br></div><div>Below are the details of the transaction:</div><div><br></div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Current Balance: </b>{{post_balance}} {{site_currency}}</div><div><b>Admin Note:</b> {{remark}}</div><div><br></div><div>Should you require any further clarification or assistance, please do not hesitate to reach out to us. We are here to assist you in any way we can.</div><div><br></div><div>Thank you for your continued trust in {{site_name}}.</div>', 'We wish to inform you that an amount of {{amount}} {{site_currency}} has been successfully deducted from your account.', '{{amount}} {{site_currency}} debited from your account.', '{\"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, '{{site_name}} Finance', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:17:48'),
(3, 'DEPOSIT_COMPLETE', 'Deposit - Automated - Successful', 'Deposit Completed Successfully', '{{site_name}} - Deposit successful', '<div>We\'re delighted to inform you that your deposit of {{amount}} {{site_currency}} via {{method_name}} has been completed.</div><div><br></div><div>Below, you\'ll find the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge: </b>{{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received:</b> {{method_amount}} {{method_currency}}</div><div><b>Paid via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Your current balance stands at {{post_balance}} {{site_currency}}.</div><div><br></div><div>If you have any questions or need further assistance, feel free to reach out to our support team. We\'re here to assist you in any way we can.</div>', 'We\'re delighted to inform you that your deposit of {{amount}} {{site_currency}} via {{method_name}} has been completed.', 'Deposit Completed Successfully', '{\"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, '{{site_name}} Billing', NULL, 1, NULL, 1, '2021-11-03 12:00:00', '2024-05-08 07:20:34'),
(4, 'DEPOSIT_APPROVE', 'Deposit - Manual - Approved', 'Deposit Request Approved', '{{site_name}} - Deposit Request Approved', '<div>We are pleased to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been approved.</div><div><br></div><div>Here are the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge: </b>{{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received: </b>{{method_amount}} {{method_currency}}</div><div><b>Paid via: </b>{{method_name}}</div><div><b>Transaction Number: </b>{{trx}}</div><div><br></div><div>Your current balance now stands at {{post_balance}} {{site_currency}}.</div><div><br></div><div>Should you have any questions or require further assistance, please feel free to contact our support team. We\'re here to help.</div>', 'We are pleased to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been approved.', 'Deposit of {{amount}} {{site_currency}} via {{method_name}} has been approved.', '{\"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, '{{site_name}} Billing', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:19:49'),
(5, 'DEPOSIT_REJECT', 'Deposit - Manual - Rejected', 'Deposit Request Rejected', '{{site_name}} - Deposit Request Rejected', '<div>We regret to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.</div><div><br></div><div>Here are the details of the rejected deposit:</div><div><br></div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received:</b> {{method_amount}} {{method_currency}}</div><div><b>Paid via:</b> {{method_name}}</div><div><b>Charge:</b> {{charge}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>If you have any questions or need further clarification, please don\'t hesitate to contact us. We\'re here to assist you.</div><div><br></div><div>Rejection Reason:</div><div>{{rejection_message}}</div><div><br></div><div>Thank you for your understanding.</div>', 'We regret to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.', 'Your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.', '{\"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, '{{site_name}} Billing', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:20:13'),
(6, 'DEPOSIT_REQUEST', 'Deposit - Manual - Requested', 'Deposit Request Submitted Successfully', NULL, '<div>We are pleased to confirm that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.</div><div><br></div><div>Below are the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Payable:</b> {{method_amount}} {{method_currency}}</div><div><b>Pay via: </b>{{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Should you have any questions or require further assistance, please feel free to reach out to our support team. We\'re here to assist you.</div>', 'We are pleased to confirm that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.', 'Your deposit request of {{amount}} {{site_currency}} via {{method_name}} submitted successfully.', '{\"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, '{{site_name}} Billing', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-04-25 03:27:42'),
(7, 'PASS_RESET_CODE', 'Password - Reset - Code', 'Password Reset', '{{site_name}} Password Reset Code', '<div>We\'ve received a request to reset the password for your account on <b>{{time}}</b>. The request originated from\r\n            the following IP address: <b>{{ip}}</b>, using <b>{{browser}}</b> on <b>{{operating_system}}</b>.\r\n    </div><br>\r\n    <div><span>To proceed with the password reset, please use the following account recovery code</span>: <span><b><font size=\"6\">{{code}}</font></b></span></div><br>\r\n    <div><span>If you did not initiate this password reset request, please disregard this message. Your account security\r\n            remains our top priority, and we advise you to take appropriate action if you suspect any unauthorized\r\n            access to your account.</span></div>', 'To proceed with the password reset, please use the following account recovery code: {{code}}', 'To proceed with the password reset, please use the following account recovery code: {{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, '{{site_name}} Authentication Center', NULL, 0, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:24:57'),
(8, 'PASS_RESET_DONE', 'Password - Reset - Confirmation', 'Password Reset Successful', NULL, '<div><div><span>We are writing to inform you that the password reset for your account was successful. This action was completed at {{time}} from the following browser</span>: <span>{{browser}}</span><span>on {{operating_system}}, with the IP address</span>: <span>{{ip}}</span>.</div><br><div><span>Your account security is our utmost priority, and we are committed to ensuring the safety of your information. If you did not initiate this password reset or notice any suspicious activity on your account, please contact our support team immediately for further assistance.</span></div></div>', 'We are writing to inform you that the password reset for your account was successful.', 'We are writing to inform you that the password reset for your account was successful.', '{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, '{{site_name}} Authentication Center', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-04-25 03:27:24'),
(9, 'ADMIN_SUPPORT_REPLY', 'Support - Reply', 'Re: {{ticket_subject}} - Ticket #{{ticket_id}}', '{{site_name}} - Support Ticket Replied', '<div>\r\n    <div><span>Thank you for reaching out to us regarding your support ticket with the subject</span>:\r\n        <span>\"{{ticket_subject}}\"&nbsp;</span><span>and ticket ID</span>: {{ticket_id}}.</div><br>\r\n    <div><span>We have carefully reviewed your inquiry, and we are pleased to provide you with the following\r\n            response</span><span>:</span></div><br>\r\n    <div>{{reply}}</div><br>\r\n    <div><span>If you have any further questions or need additional assistance, please feel free to reply by clicking on\r\n            the following link</span>: <a href=\"{{link}}\" title=\"\" target=\"_blank\">{{link}}</a><span>. This link will take you to\r\n            the ticket thread where you can provide further information or ask for clarification.</span></div><br>\r\n    <div><span>Thank you for your patience and cooperation as we worked to address your concerns.</span></div>\r\n</div>', 'Thank you for reaching out to us regarding your support ticket with the subject: \"{{ticket_subject}}\" and ticket ID: {{ticket_id}}. We have carefully reviewed your inquiry. To check the response, please go to the following link: {{link}}', 'Re: {{ticket_subject}} - Ticket #{{ticket_id}}', '{\"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, '{{site_name}} Support Team', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:26:06'),
(10, 'EVER_CODE', 'Verification - Email', 'Email Verification Code', NULL, '<div>\r\n    <div><span>Thank you for taking the time to verify your email address with us. Your email verification code\r\n            is</span>: <b><font size=\"6\">{{code}}</font></b></div><br>\r\n    <div><span>Please enter this code in the designated field on our platform to complete the verification\r\n            process.</span></div><br>\r\n    <div><span>If you did not request this verification code, please disregard this email. Your account security is our\r\n            top priority, and we advise you to take appropriate measures if you suspect any unauthorized access.</span>\r\n    </div><br>\r\n    <div><span>If you have any questions or encounter any issues during the verification process, please don\'t hesitate\r\n            to contact our support team for assistance.</span></div><br>\r\n    <div><span>Thank you for choosing us.</span></div>\r\n</div>', '---', '---', '{\"code\":\"Email verification code\"}', 1, '{{site_name}} Verification Center', NULL, 0, NULL, 0, '2021-11-03 12:00:00', '2024-04-25 03:27:12'),
(11, 'SVER_CODE', 'Verification - SMS', 'Verify Your Mobile Number', NULL, '---', 'Your mobile verification code is {{code}}. Please enter this code in the appropriate field to verify your mobile number. If you did not request this code, please ignore this message.', '---', '{\"code\":\"SMS Verification Code\"}', 0, '{{site_name}} Verification Center', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-04-25 03:27:03'),
(12, 'WITHDRAW_APPROVE', 'Withdraw - Approved', 'Withdrawal Confirmation: Your Request Processed Successfully', '{{site_name}} - Withdrawal Request Approved', '<div>We are writing to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been processed successfully.</div><div><br></div><div>Below are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>You will receive:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><hr><div><br></div><div><b>Details of Processed Payment:</b></div><div>{{admin_details}}</div><div><br></div><div>Should you have any questions or require further assistance, feel free to reach out to our support team. We\'re here to help.</div>', 'We are writing to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been processed successfully.', 'Withdrawal Confirmation: Your Request Processed Successfully', '{\"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, '{{site_name}} Finance', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:26:37'),
(13, 'WITHDRAW_REJECT', 'Withdraw - Rejected', 'Withdrawal Request Rejected', '{{site_name}} - Withdrawal Request Rejected', '<div>We regret to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.</div><div><br></div><div>Here are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Expected Amount:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><hr><div><br></div><div><b>Refund Details:</b></div><div>{{amount}} {{site_currency}} has been refunded to your account, and your current balance is {{post_balance}} {{site_currency}}.</div><div><br></div><hr><div><br></div><div><b>Reason for Rejection:</b></div><div>{{admin_details}}</div><div><br></div><div>If you have any questions or concerns regarding this rejection or need further assistance, please do not hesitate to contact our support team. We apologize for any inconvenience this may have caused.</div>', 'We regret to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.', 'Withdrawal Request Rejected', '{\"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, '{{site_name}} Finance', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:26:55'),
(14, 'WITHDRAW_REQUEST', 'Withdraw - Requested', 'Withdrawal Request Confirmation', '{{site_name}} - Requested for withdrawal', '<div>We are pleased to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.</div><div><br></div><div>Here are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Expected Amount:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Your current balance is {{post_balance}} {{site_currency}}.</div><div><br></div><div>Should you have any questions or require further assistance, feel free to reach out to our support team. We\'re here to help.</div>', 'We are pleased to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.', 'Withdrawal request submitted successfully', '{\"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, '{{site_name}} Finance', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:27:20'),
(15, 'DEFAULT', 'Default Template', '{{subject}}', '{{subject}}', '{{message}}', '{{message}}', '{{message}}', '{\"subject\":\"Subject\",\"message\":\"Message\"}', 1, NULL, NULL, 1, NULL, 1, '2019-09-14 13:14:22', '2024-05-16 01:32:53'),
(16, 'KYC_APPROVE', 'KYC Approved', 'KYC Details has been approved', '{{site_name}} - KYC Approved', '<div><div><span>We are pleased to inform you that your Know Your Customer (KYC) information has been successfully reviewed and approved. This means that you are now eligible to conduct any payout operations within our system.</span></div><br><div><span>Your commitment to completing the KYC process promptly is greatly appreciated, as it helps us ensure the security and integrity of our platform for all users.</span></div><br><div><span>With your KYC verification now complete, you can proceed with confidence to carry out any payout transactions you require. Should you encounter any issues or have any questions along the way, please don\'t hesitate to reach out to our support team. We\'re here to assist you every step of the way.</span></div><br><div><span>Thank you once again for choosing {{site_name}} and for your cooperation in this matter.</span></div></div>', 'We are pleased to inform you that your Know Your Customer (KYC) information has been successfully reviewed and approved. This means that you are now eligible to conduct any payout operations within our system.', 'Your  Know Your Customer (KYC) information has been approved successfully', '[]', 1, '{{site_name}} Verification Center', NULL, 1, NULL, 0, NULL, '2024-05-08 07:23:57'),
(17, 'KYC_REJECT', 'KYC Rejected', 'KYC has been rejected', '{{site_name}} - KYC Rejected', '<div><div><span>We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards. As a result, we are unable to approve your KYC submission at this time.</span></div><br><div><span>We understand that this news may be disappointing, and we want to assure you that we take these matters seriously to maintain the security and integrity of our platform.</span></div><br><div><span>Reasons for rejection may include discrepancies or incomplete information in the documentation provided. If you believe there has been a misunderstanding or if you would like further clarification on why your KYC was rejected, please don\'t hesitate to contact our support team.</span></div><br><div><span>We encourage you to review your submitted information and ensure that all details are accurate and up-to-date. Once any necessary adjustments have been made, you are welcome to resubmit your KYC information for review.</span></div><br><div><span>We apologize for any inconvenience this may cause and appreciate your understanding and cooperation in this matter.</span></div><br><div>Rejection Reason:</div><div>{{reason}}</div><div><br></div><div><span>Thank you for your continued support and patience.</span></div></div>', 'We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards. As a result, we are unable to approve your KYC submission at this time. We encourage you to review your submitted information and ensure that all details are accurate and up-to-date. Once any necessary adjustments have been made, you are welcome to resubmit your KYC information for review.', 'Your  Know Your Customer (KYC) information has been rejected', '{\"reason\":\"Rejection Reason\"}', 1, '{{site_name}} Verification Center', NULL, 1, NULL, 0, NULL, '2024-05-08 07:24:13'),
(18, 'GIFT_GOLD', 'Gift - Gold', 'Gold Gifted Successfully', '{{site_name}} - Gold Gifted', '<div>We’re happy to confirm that your Gold Gift has been successfully sent!</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Recipient Name:</b> {{recipient_name}}</div><div><b>Gifted Amount:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Thank you for sharing the joy of gifting!</div>', 'We’re happy to confirm that your Gold Gift has been successfully sent!\r\nGifted Amount: {{quantity}} gram', 'We’re happy to confirm that your Gold Gift has been successfully sent!\r\nGifted Amount: {{quantity}} gram', '{\r\n    \"recipient_name\": \"Name of the recipient\",\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the gift gold in gram\",\r\n    \"amount\": \"The amount of the gift gold\",\r\n    \"charge\": \"Charge of the gift gold\",\r\n    \"trx\": \"Transaction number for the action\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-15 12:37:33'),
(19, 'RECEIVED_GIFT_GOLD', 'Receive Gift - Gold', 'Receive Gift Gold Successfully', '{{site_name}} - Receive Gift', '<div><div>We\'re thrilled to inform you that you have received a Gold Gift!</div></div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Gift User Name:</b> {{user_name}}</div><div><b>Gifted Amount:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Thank you for sharing the joy of gifting!</div>', 'We\'re thrilled to inform you that you have received a Gold Gift!\r\nGifted Amount: {{quantity}} gram', 'We\'re thrilled to inform you that you have received a Gold Gift!\r\nGifted Amount: {{quantity}} gram', '{\r\n    \"user_name\": \"Name of the user who gifted the gold\",\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the gift gold in gram\",\r\n    \"amount\": \"The amount of the gift gold\",\r\n    \"charge\": \"Charge of the gift gold\",\r\n    \"trx\": \"Transaction number for the action\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-15 12:47:36'),
(20, 'SELL_GOLD', 'Sell - Gold', 'Gold Sold', '{{site_name}} - Gold Sold', '<div>Your gold sold successfully</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div>', 'Your gold sold successfully\r\nQuantity: {{quantity}} gram', 'Your gold sold successfully\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the sell gold in gram\",\r\n    \"amount\": \"The amount of the sell gold\",\r\n    \"charge\": \"Charge of the sell gold\",\r\n    \"trx\": \"Transaction number for the action\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-15 12:50:43'),
(21, 'BUY_GOLD', 'Buy - Gold', 'Gold Buy Successful', '{{site_name}} - Gold Buy', '<div>Gold Buy Successful</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><span style=\"color: rgb(33, 37, 41);\"><b>Vat:</b> {{vat}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div>', 'Gold Buy Successful\r\nQuantity: {{quantity}} gram', 'Gold Buy Successful\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the buy gold in gram\",\r\n    \"amount\": \"The amount of the buy gold\",\r\n    \"charge\": \"Charge of the buy gold\",\r\n    \"vat\": \"Vat of the buy gold\",\r\n    \"trx\": \"Transaction number for the action\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-15 12:56:13'),
(22, 'REDEEM_GOLD', 'Redeem - Gold', 'Redeemed Gold Successfully', '{{site_name}} - Redeem Gold', '<div>Gold Redeemed Successfully</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><span style=\"color: rgb(33, 37, 41);\"><b>Vat:</b> {{vat}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Details: </b>{{details}}</div><div><br></div>', 'Gold Buy Successful\r\nQuantity: {{quantity}} gram', 'Gold Buy Successful\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the redeem gold in gram\",\r\n    \"amount\": \"The amount of the redeem gold\",\r\n    \"charge\": \"Charge of the redeem gold\",\r\n    \"trx\": \"Transaction number for the action\",\r\n    \"details\": \"Details of the redeem gold bar and coin\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-15 13:21:57'),
(23, 'REDEEM_DELIVERED', 'Redeem - Delivered', 'Redeemed Gold Delivered Successfully', '{{site_name}} - Redeem Gold Delivered', '<div>Redeem gold delivered&nbsp; successfully</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Details: </b>{{details}}</div><div><br></div>', 'Redeem gold delivered  successfully\r\nQuantity: {{quantity}} gram', 'Redeem gold delivered  successfully\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the redeem gold in gram\",\r\n    \"amount\": \"The amount of the redeem gold\",\r\n    \"charge\": \"Charge of the redeem gold\",\r\n    \"trx\": \"Transaction number for the action\",\r\n    \"details\": \"Details of the redeem gold bar and coin\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-16 06:59:25'),
(24, 'REDEEM_CANCELLED', 'Redeem - Cancelled', 'Redeem Request Cancelled', '{{site_name}} - Redeem Request Cancelled', '<div>Your redeem request cancelled</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Details: </b>{{details}}</div><div><br></div>', 'Redeem gold delivered  successfully\r\nQuantity: {{quantity}} gram', 'Redeem gold delivered  successfully\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the redeem gold in gram\",\r\n    \"amount\": \"The amount of the redeem gold\",\r\n    \"charge\": \"Charge of the redeem gold\",\r\n    \"trx\": \"Transaction number for the action\",\r\n    \"details\": \"Details of the redeem gold bar and coin\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-16 07:13:48'),
(25, 'REDEEM_SHIPPED', 'Redeem - Shipped', 'Redeemed Gold Shipped Successfully', '{{site_name}} - Redeem Gold Shipped', '<div>Redeem gold shipped successfully</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Quantity:</b> {{quantity}} gram</div><div><b>Amount: </b>{{amount}}</div><div><span style=\"font-weight: bolder; color: rgb(33, 37, 41);\">Charge: </span><span style=\"color: rgb(33, 37, 41);\">{{charge}}</span></div><div><b>Category:</b> {{category}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Details: </b>{{details}}</div><div><br></div>', 'Redeem gold shipped successfully\r\nQuantity: {{quantity}} gram', 'Redeem gold shipped successfully\r\nQuantity: {{quantity}} gram', '{\r\n    \"category\": \"Gold category\",\r\n    \"quantity\": \"Quantity of the redeem gold in gram\",\r\n    \"amount\": \"The amount of the redeem gold\",\r\n    \"charge\": \"Charge of the redeem gold\",\r\n    \"trx\": \"Transaction number for the action\",\r\n    \"details\": \"Details of the redeem gold bar and coin\"\r\n}', 1, '{{site_name}} Finance', NULL, 0, NULL, 1, '2021-11-03 12:00:00', '2024-12-21 11:11:56');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `slug` varchar(40) DEFAULT NULL,
  `tempname` varchar(40) DEFAULT NULL COMMENT 'template name',
  `secs` text DEFAULT NULL,
  `seo_content` text DEFAULT NULL,
  `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`, `seo_content`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'HOME', '/', 'templates.basic.', '[\"service\",\"why_invest\",\"feature\",\"how_it_works\",\"testimonial\",\"faq\",\"blog\",\"payment_methods\",\"subscribe\"]', NULL, 1, '2020-07-11 06:23:58', '2025-01-20 03:00:12'),
(4, 'Blog', 'blog', 'templates.basic.', NULL, NULL, 1, '2020-10-22 01:14:43', '2020-10-22 01:14:43'),
(5, 'Contact', 'contact', 'templates.basic.', NULL, NULL, 1, '2020-10-22 01:14:53', '2020-10-22 01:14:53'),
(26, 'Faq', 'faq', 'templates.basic.', '[\"feature\",\"payment_methods\"]', NULL, 1, '2024-12-05 09:22:55', '2024-12-07 06:46:48');

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

--
-- Table structure for table `price_apis`
--

CREATE TABLE `price_apis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(40) DEFAULT NULL,
  `configuration` text DEFAULT NULL,
  `instruction` text DEFAULT NULL,
  `image` varchar(40) DEFAULT NULL,
  `status` 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 `price_apis`
--

INSERT INTO `price_apis` (`id`, `name`, `configuration`, `instruction`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Coinmarketcap', '{\"api_key\":{\"title\":\"API Key\",\"value\":\"-----------\"}}', '<ul class=\"list-group list-group-flush\">\n <li class=\"list-group-item\">Go to the CoinMarketCap website <a href=\"https://coinmarketcap.com/api\" target=\"_blank\">https://coinmarketcap.com/api</a></li>\n <li class=\"list-group-item\">Signup this platform or login existing account</li>\n <li class=\"list-group-item\">After logging into your CoinMarketCap account, Choose an API Plan</li>\n <li class=\"list-group-item\">Generate an API Key</li>\n <li class=\"list-group-item\">Copy API key & configure here</li>\n </ul>', 'coinmarketcap.jpg', 1, NULL, '2025-01-20 00:38:20'),
(2, 'Cryptocompare', '{\"api_key\":{\"title\":\"API Key\",\"value\":\"---------------\"}}', ' <ul class=\"list-group list-group-flush\">\n                        <li class=\"list-group-item\">Go to the Cryptocompare website <a href=\"https://min-api.cryptocompare.com/\" target=\"_blank\">https://min-api.cryptocompare.com/</a></li>\n                        <li class=\"list-group-item\">Signup this platform or login to the existing account</li>\n                        <li class=\"list-group-item\">After logging into your Cryptocompare account, Choose an API Plan</li>\n                        <li class=\"list-group-item\">Generate an API Key</li>\n                        <li class=\"list-group-item\">Copy API key & configure here</li>\n                    </ul>', 'cryptocompare.jpg', 0, NULL, '2025-01-20 00:38:24');

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

--
-- Table structure for table `redeem_data`
--

CREATE TABLE `redeem_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gold_history_id` int(10) NOT NULL DEFAULT 0,
  `order_details` text DEFAULT NULL,
  `delivery_address` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `redeem_units`
--

CREATE TABLE `redeem_units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quantity` decimal(28,8) DEFAULT 0.00000000,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1: bar\r\n2: coin',
  `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 `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(40) 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(20) UNSIGNED NOT NULL,
  `support_message_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `attachment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT 0,
  `name` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `ticket` varchar(40) DEFAULT NULL,
  `subject` varchar(255) 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(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `post_balance` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `trx_type` varchar(40) DEFAULT NULL,
  `trx` varchar(40) DEFAULT NULL,
  `details` varchar(255) DEFAULT NULL,
  `remark` varchar(40) 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 `update_logs`
--

CREATE TABLE `update_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(40) DEFAULT NULL,
  `update_log` text 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(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `user_ip` varchar(40) DEFAULT NULL,
  `city` varchar(40) DEFAULT NULL,
  `country` varchar(40) DEFAULT NULL,
  `country_code` varchar(40) DEFAULT NULL,
  `longitude` varchar(40) DEFAULT NULL,
  `latitude` varchar(40) DEFAULT NULL,
  `browser` varchar(40) DEFAULT NULL,
  `os` varchar(40) 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(20) UNSIGNED NOT NULL,
  `method_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `currency` varchar(40) DEFAULT NULL,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `trx` varchar(40) 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 DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=>success, 2=>pending, 3=>cancel,  ',
  `admin_feedback` text 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 `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `form_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(40) DEFAULT NULL,
  `image` varchar(255) 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) DEFAULT NULL,
  `description` text 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;

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

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

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

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

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

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

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

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  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`),
  ADD UNIQUE KEY `code` (`code`);

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

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

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

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

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

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

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

--
-- 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 table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `charge_limits`
--
ALTER TABLE `charge_limits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cron_jobs`
--
ALTER TABLE `cron_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cron_job_logs`
--
ALTER TABLE `cron_job_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_schedules`
--
ALTER TABLE `cron_schedules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `extensions`
--
ALTER TABLE `extensions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `forms`
--
ALTER TABLE `forms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `frontends`
--
ALTER TABLE `frontends`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

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

--
-- AUTO_INCREMENT for table `gold_histories`
--
ALTER TABLE `gold_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `historical_prices`
--
ALTER TABLE `historical_prices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

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

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `price_apis`
--
ALTER TABLE `price_apis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `redeem_data`
--
ALTER TABLE `redeem_data`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `redeem_units`
--
ALTER TABLE `redeem_units`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `update_logs`
--
ALTER TABLE `update_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

