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

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `quickpost_empty`
--

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

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

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

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

INSERT INTO `admins` (`id`, `role_id`, `name`, `email`, `username`, `email_verified_at`, `image`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 0, 'Super Admin', 'admin@example.com', 'admin', NULL, '6864d156b3f2e1751437654.jpg', '$2y$12$fkIQ6EKYutA/NNQC0UdmHuu0PH.MKxerX0fGZRp5uQZKYpqJJBFHm', 'sF1WOwGHikjfk0tZjIChtBNzhocVzDHilgjSDT6M5bXPm4dQj9wWkvwN6rAN', NULL, '2025-10-20 04:17:10'),
(3, 3, 'Manager', 'manager@gmail.com', 'manager', NULL, '686a18d8e2e881751783640.jpg', '$2y$12$x8DlEz5FlUm7NpfXROifY.MoQYrUNntJs8/24lasApzSh1PZ2rIFO', NULL, '2025-07-06 00:34:02', '2025-07-06 00:34:02');

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

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

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

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

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

CREATE TABLE `admin_password_resets` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `token` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

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

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

INSERT INTO `forms` (`id`, `act`, `form_data`, `created_at`, `updated_at`) VALUES
(2, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number_22\":{\"name\":\"NID Number 22\",\"label\":\"nid_number_22\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"textarea\"},\"sadfg\":{\"name\":\"sadfg\",\"label\":\"sadfg\",\"is_required\":\"optional\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"asdf\":{\"name\":\"asdf\",\"label\":\"asdf\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"Test2\",\"Test3\"],\"type\":\"select\"},\"nid_number_226985\":{\"name\":\"NID Number 226985\",\"label\":\"nid_number_226985\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"Test 2\",\"Test 3\"],\"type\":\"checkbox\"},\"nid_number_3333\":{\"name\":\"NID Number 3333\",\"label\":\"nid_number_3333\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Test\",\"asdf\"],\"type\":\"radio\"},\"nid_number_3333587\":{\"name\":\"NID Number 3333587\",\"label\":\"nid_number_3333587\",\"is_required\":\"optional\",\"extensions\":\"jpg,bmp,png,pdf\",\"options\":[],\"type\":\"file\"}}', '2022-03-16 01:09:49', '2022-03-17 00:02:54'),
(3, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number_226985\":{\"name\":\"NID Number 226985\",\"label\":\"nid_number_226985\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-16 04:32:29', '2022-03-16 04:35:32'),
(5, 'withdraw_method', '{\"nid_number_33\":{\"name\":\"NID Number 33\",\"label\":\"nid_number_33\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-17 00:45:35', '2022-03-17 00:53:17'),
(6, 'withdraw_method', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-17 00:47:04', '2022-03-17 00:47:04'),
(7, 'kyc', '{\"full_name\":{\"name\":\"Full Name\",\"label\":\"full_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"gender\":{\"name\":\"Gender\",\"label\":\"gender\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Male\",\"Female\",\"Others\"],\"type\":\"select\"},\"you_hobby\":{\"name\":\"You Hobby\",\"label\":\"you_hobby\",\"is_required\":\"required\",\"extensions\":null,\"options\":[\"Programming\",\"Gardening\",\"Traveling\",\"Others\"],\"type\":\"checkbox\"},\"nid_photo\":{\"name\":\"NID Photo\",\"label\":\"nid_photo\",\"is_required\":\"required\",\"extensions\":\"jpg,png\",\"options\":[],\"type\":\"file\"}}', '2022-03-17 02:56:14', '2025-08-13 02:16:48'),
(8, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-03-21 07:53:25', '2022-03-21 07:53:25'),
(9, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-03-21 07:54:15', '2022-03-21 07:54:15'),
(10, 'manual_deposit', '{\"nid_number\":{\"name\":\"NID Number\",\"label\":\"nid_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"textarea\"}}', '2022-03-21 07:55:15', '2022-03-21 07:55:22'),
(11, 'withdraw_method', '{\"nid_number_2658\":{\"name\":\"NID Number 2658\",\"label\":\"nid_number_2658\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[\"asdf\"],\"type\":\"checkbox\"}}', '2022-03-22 00:14:09', '2022-03-22 00:14:18'),
(12, 'withdraw_method', '[]', '2022-03-30 09:03:12', '2022-03-30 09:03:12'),
(13, 'withdraw_method', '{\"recipient_full_name\":{\"name\":\"Recipient Full Name\",\"label\":\"recipient_full_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"bank_name\":{\"name\":\"Bank Name\",\"label\":\"bank_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"account_number\":{\"name\":\"Account Number\",\"label\":\"account_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"email_for_confirmation\":{\"name\":\"Email for Confirmation\",\"label\":\"email_for_confirmation\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2022-03-30 09:09:11', '2025-09-21 07:25:23'),
(14, 'withdraw_method', '{\"mobile_banking_provider\":{\"name\":\"Mobile Banking Provider\",\"label\":\"mobile_banking_provider\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"account_name\":{\"name\":\"Account Name\",\"label\":\"account_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"mobile_banking_number\":{\"name\":\"Mobile Banking Number\",\"label\":\"mobile_banking_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2022-03-30 09:10:12', '2025-09-21 07:25:04'),
(15, 'manual_deposit', '{\"send_from_number\":{\"name\":\"Send From Number\",\"label\":\"send_from_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"transaction_number\":{\"name\":\"Transaction Number\",\"label\":\"transaction_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"screenshot\":{\"name\":\"Screenshot\",\"label\":\"screenshot\",\"is_required\":\"required\",\"extensions\":\"jpg,jpeg,png\",\"options\":[],\"type\":\"file\"}}', '2022-03-30 09:15:27', '2022-03-30 09:15:27'),
(16, 'manual_deposit', '{\"transaction_number\":{\"name\":\"Transaction Number\",\"label\":\"transaction_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"screenshot\":{\"name\":\"Screenshot\",\"label\":\"screenshot\",\"is_required\":\"required\",\"extensions\":\"jpg,pdf,docx\",\"options\":[],\"type\":\"file\"}}', '2022-03-30 09:16:43', '2022-04-11 03:19:54'),
(17, 'manual_deposit', '[]', '2022-03-30 09:21:19', '2022-03-30 09:21:19'),
(18, 'manual_deposit', '{\"asdfasddf\":{\"name\":\"asdfasddf\",\"label\":\"asdfasddf\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2022-09-28 04:50:55', '2022-09-28 04:50:55'),
(19, 'manual_deposit', '{\"sadf\":{\"name\":\"sadf\",\"label\":\"sadf\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"textarea\"}}', '2022-09-28 05:13:04', '2022-09-28 05:13:59'),
(20, 'manual_deposit', '{\"transaction_id\":{\"name\":\"Transaction ID\",\"label\":\"transaction_id\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2023-05-27 02:50:43', '2023-05-27 02:50:43'),
(21, 'manual_deposit', '{\"depositor_full_name\":{\"name\":\"Depositor Full Name\",\"label\":\"depositor_full_name\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"bank_name\":{\"name\":\"Bank Name\",\"label\":\"bank_name\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"account_number\":{\"name\":\"Account Number\",\"label\":\"account_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"transfer_reference_code\":{\"name\":\"Transfer Reference Code\",\"label\":\"transfer_reference_code\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"deposit_amount\":{\"name\":\"Deposit Amount\",\"label\":\"deposit_amount\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2025-06-28 07:50:58', '2025-09-21 07:23:28'),
(22, 'manual_deposit', '{\"sender_name\":{\"name\":\"Sender Name\",\"label\":\"sender_name\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"mobile_money_number\":{\"name\":\"Mobile Money Number\",\"label\":\"mobile_money_number\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"transaction_reference_id\":{\"name\":\"Transaction Reference ID\",\"label\":\"transaction_reference_id\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"amount_sent\":{\"name\":\"Amount Sent\",\"label\":\"amount_sent\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"},\"email_for_notification\":{\"name\":\"Email for Notification\",\"label\":\"email_for_notification\",\"is_required\":\"required\",\"extensions\":\"\",\"options\":[],\"type\":\"text\"}}', '2025-06-29 03:30:31', '2025-09-21 07:21:49'),
(23, 'manual_deposit', '{\"payer_full_name\":{\"name\":\"Payer Full Name\",\"label\":\"payer_full_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"transaction_id\":{\"name\":\"Transaction ID\",\"label\":\"transaction_id\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"cash_amount\":{\"name\":\"Cash Amount\",\"label\":\"cash_amount\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"branch_name\":{\"name\":\"Branch Name\",\"label\":\"branch_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"email_for_notification\":{\"name\":\"Email for Notification\",\"label\":\"email_for_notification\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2025-06-29 03:32:11', '2025-09-21 07:24:06'),
(24, 'withdraw_method', '{\"account_holder_name\":{\"name\":\"Account Holder Name\",\"label\":\"account_holder_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"bank_name\":{\"name\":\"Bank Name\",\"label\":\"bank_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"branch_code\":{\"name\":\"Branch Code\",\"label\":\"branch_code\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"account_number\":{\"name\":\"Account Number\",\"label\":\"account_number\",\"is_required\":\"optional\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"email_for_confirmation\":{\"name\":\"Email for Confirmation\",\"label\":\"email_for_confirmation\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2025-06-29 04:40:12', '2025-09-21 07:24:39'),
(25, 'manual_deposit', '{\"sender_name\":{\"name\":\"Sender Name\",\"label\":\"sender_name\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"transfer_reference_number\":{\"name\":\"Transfer Reference Number\",\"label\":\"transfer_reference_number\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"amount_sent\":{\"name\":\"Amount Sent\",\"label\":\"amount_sent\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"},\"email_for_confirmation\":{\"name\":\"Email for Confirmation\",\"label\":\"email_for_confirmation\",\"is_required\":\"required\",\"extensions\":null,\"options\":[],\"type\":\"text\"}}', '2025-08-13 02:19:06', '2025-09-21 07:23:50');

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

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

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

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

INSERT INTO `frontends` (`id`, `data_keys`, `data_values`, `created_at`, `updated_at`) VALUES
(1, 'seo.data', '{\"seo_image\":\"1\",\"keywords\":[\"QuickPost\",\"social media automation\",\"AI social media tool\",\"Laravel social media script\",\"schedule social media posts\",\"multi-platform publisher\",\"TikTok scheduler\",\"Instagram scheduler\",\"YouTube automation\",\"LinkedIn post scheduler\",\"AI content generator\",\"SaaS social media tool\",\"Threads Automation\",\"Facebook Automation\",\"LinkedIn Automation\"],\"description\":\"QuickPost is an AI-driven social media scheduling and automation tool for businesses, agencies, and creators. Plan campaigns, schedule posts, and publish across Facebook, Instagram, Twitter, LinkedIn, TikTok, YouTube, and more\\u2014all from one dashboard.\",\"social_title\":\"QuickPost - Powerful Features to Boost Your Social Media Profile\",\"social_description\":\"QuickPost is an AI-driven social media scheduling and automation tool for businesses, agencies, and creators. Plan campaigns, schedule posts, and publish across Facebook, Instagram, Twitter, LinkedIn, TikTok, YouTube, and more\\u2014all from one dashboard.\",\"image\":\"68dd1cce050ad1759321294.jpg\"}', '2020-07-04 23:42:52', '2025-10-04 02:50:46'),
(24, 'about.content', '{\"has_image\":\"1\",\"heading\":\"Latest Newsddd\",\"subheading\":\"dddd\",\"description\":\"fdg sdfgsdf g gggddd\",\"about_icon\":\"<i class=\\\"fab fa-accusoft\\\"><\\/i>\",\"background_image\":\"60951a84abd141620384388.png\",\"about_image\":\"5f9914e907ace1603867881.jpg\"}', '2020-10-28 00:51:20', '2023-05-10 02:06:51'),
(25, 'blog.content', '{\"title\":\"Our Blog\",\"heading\":\"Expert Advice to Grow Your Online Presence\",\"subheading\":\"Insights from industry experts to power your content strategy and maximize engagement.\"}', '2020-10-28 00:51:34', '2025-10-06 19:31:43'),
(27, 'contact_us.content', '{\"title\":\"Need Help?\",\"heading\":\"Got Questions? We\\u2019ve Got Answers.\",\"subheading\":\"Find clear, concise answers to all your questions about our services and tools.\",\"short_details\":\"AI power mentschedule, optimize, and grow your online publishing software like Aldus\",\"latitude\":\"40.69461270785467\",\"longitude\":\"-73.94226835283084\",\"website_footer\":\"<p>Copyright \\u00a9 2025 All rights reserved.<\\/p>\"}', '2020-10-28 00:59:19', '2025-10-07 00:40:54'),
(28, 'counter.content', '{\"heading\":\"Clients\",\"subheading\":\"Auctor gravida vestibulu\"}', '2020-10-28 01:04:02', '2022-09-28 14:02:14'),
(31, 'social_icon.element', '{\"title\":\"Facebook\",\"social_icon\":\"<i class=\\\"fab fa-facebook-f\\\"><\\/i>\",\"url\":\"https:\\/\\/www.facebook.com\"}', '2020-11-12 04:07:30', '2025-10-21 05:37:04'),
(33, 'feature.content', '{\"title\":\"Key Features\",\"heading\":\"All-in-One Features to Grow Your Social Media Reach\",\"subheading\":\"Take control with AI tools ideate, create, and post seamlessly, built for creators and businesses.\"}', '2021-01-03 23:40:54', '2025-10-06 21:26:13'),
(36, 'service.content', '{\"title\":\"Key Services\",\"heading\":\"The Benefits of AI-Based Social Media Automation\",\"subheading\":\"Smart tools and expert solutions to create, schedule, and optimize social contentboosting your brand\\u2019s online presence effortlessly and efficiently.\"}', '2021-03-06 01:27:34', '2025-10-06 21:07:18'),
(39, 'banner.content', '{\"title\":\"Save Time, Boost Engagement\",\"heading\":\"Powerful Features to Boost Your Social Media Profile\",\"subheading\":\"Easily manage all your social platforms schedule, design, track, and engage from one powerful dashboard\",\"primary_button_text\":\"START FREE TRAIL\",\"primary_button_url\":\"user\\/free-plan\\/subscription\",\"secondary_button_text\":\"DISCOVER MORE\",\"secondary_button_url\":\"\\/pricing\"}', '2021-05-02 06:09:30', '2025-11-12 01:12:50'),
(41, 'cookie.data', '{\"short_desc\":\"We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking \\\"Accept\\\", you consent to our use of cookies.\",\"description\":\"<h4>GDPR, cookies and compliance\\u00a0<\\/h4><p>This Cookie Policy explains how <strong>QuickPost<\\/strong> (\\\"we\\\", \\\"our\\\", or \\\"us\\\") uses cookies and similar technologies to recognize you when you visit our website. It describes what these technologies are, why we use them, and your rights to control their use.<\\/p><h5>What Are Cookies?<\\/h5><p>Cookies are small data files that are placed 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><h5>How We Use Cookies<\\/h5><p>We use cookies for several purposes, including to:<\\/p><ul><li>Enable essential functionality such as user login and account management.<\\/li><li>Analyze site performance and usage to improve our services.<\\/li><li>Remember your preferences and settings to enhance your experience.<\\/li><li>Provide personalized content and relevant advertising.<\\/li><\\/ul><h5>Types of Cookies We Use<\\/h5><ul><li><strong>Essential Cookies:<\\/strong> Necessary for the website to function properly.<\\/li><li><strong>Performance Cookies:<\\/strong> Help us analyze how visitors use our website.<\\/li><li><strong>Functional Cookies:<\\/strong> Enable enhanced functionality and personalization.<\\/li><li><strong>Advertising Cookies:<\\/strong> Used to deliver ads relevant to your interests.<\\/li><\\/ul><h5>Managing Cookies<\\/h5><p>You can control and manage cookies in various ways. Please note that removing or blocking cookies may impact your user experience and parts of our website may no longer function properly.<\\/p><ul><li>Most browsers allow you to refuse cookies or delete them through browser settings.<\\/li><li>You can also opt out of certain third-party cookies through tools\\u00a0<\\/li><\\/ul><h5>Third-Party Cookies<\\/h5><p>Some cookies on our website are placed by third parties to deliver analytics, advertising, or other services. We do not control these cookies, and you should check the relevant third party\\u2019s website for more information.<\\/p><h5>Updates to This Policy<\\/h5><p>We may update this Cookie Policy from time to time to reflect changes in technology, legal requirements, or our practices. Any updates will be posted on this page with an updated revision date.<\\/p><h5>Contact Us<\\/h5><p>If you have any questions about our use of cookies, please contact us at:<br><a href=\\\"mailto:support@quickpost.com\\\">support@quickpost.com<\\/a><\\/p>\",\"status\":1}', '2020-07-04 23:42:52', '2025-11-20 09:50:52'),
(42, 'policy_pages.element', '{\"title\":\"Privacy Policy\",\"details\":\"<h4>Privacy Policy<\\/h4><p>At <strong>QuickPost<\\/strong>, we are committed to protecting your personal data and respecting your privacy. This Privacy Policy explains how we collect, use, disclose, and safeguard your information when you use our platform, mobile app, and related services.<\\/p><h5>1. Information We Collect<\\/h5><p>We may collect the following types of information from you:<\\/p><ul><li><strong>Personal Information:<\\/strong> Such as your name, email address, company name, and contact details.<\\/li><li><strong>Account Data:<\\/strong> Login credentials, account preferences, and subscription details.<\\/li><li><strong>Usage Data:<\\/strong> Information about how you interact with our platform, including pages visited and features used.<\\/li><li><strong>Social Media Data:<\\/strong> When you connect your social accounts, we may access content and engagement metrics per platform permissions.<\\/li><li><strong>Payment Information:<\\/strong> Processed securely via our payment partners; we do not store credit card details.<\\/li><\\/ul><h5>2. How We Use Your Information<\\/h5><p>We use your data to provide, improve, and personalize your experience with QuickPost. Specifically, we may use information to:<\\/p><ul><li>Provide and maintain our services.<\\/li><li>Process payments and manage subscriptions.<\\/li><li>Analyze platform usage and improve performance.<\\/li><li>Send important updates, notifications, and support messages.<\\/li><li>Ensure compliance with legal obligations and platform security.<\\/li><\\/ul><h5>3. Sharing Your Information<\\/h5><p>We do not sell your data. However, we may share limited information with trusted third parties to operate our services effectively, such as:<\\/p><ul><li>Service providers (e.g., cloud hosting, analytics, payment gateways).<\\/li><li>Social media networks (only when you choose to connect them).<\\/li><li>Legal or regulatory authorities, if required by law.<\\/li><\\/ul><h5>4. Data Retention<\\/h5><p>We retain your personal data only for as long as necessary to fulfill the purposes outlined in this policy or as required by law. Once the retention period expires, your data is securely deleted or anonymized.<\\/p><h5>5. Data Security<\\/h5><p>We implement industry-standard security measures to protect your data, including encryption, secure servers, and access control. While we strive to safeguard your information, no system is completely secure.<\\/p><h5>6. Your Privacy Rights<\\/h5><p>You may have certain rights depending on your jurisdiction, such as:<\\/p><ul><li>Accessing, correcting, or deleting your personal data.<\\/li><li>Withdrawing consent to certain processing activities.<\\/li><li>Requesting a copy of your data in a portable format.<\\/li><li>Opting out of marketing communications at any time.<\\/li><\\/ul><h5>7. International Data Transfers<\\/h5><p>Your data may be processed outside your country of residence. We take appropriate safeguards to ensure your data is protected in accordance with this Privacy Policy.<\\/p><h5>8. Changes to This Policy<\\/h5><p>We may update this Privacy Policy periodically to reflect changes in our practices or for legal reasons. Any updates will be posted on this page with a revised effective date.<\\/p><h5>9. Contact Us<\\/h5><p>If you have questions about this Privacy Policy or your personal data, please contact us at:<br \\/><a href=\\\"mailto:privacy@quickpost.com\\\">privacy@quickpost.com<\\/a><\\/p>\"}', '2021-06-09 08:50:42', '2025-10-21 05:59:47'),
(43, 'policy_pages.element', '{\"title\":\"Terms of Service\",\"details\":\"<h4>Terms of Service<\\/h4><p>Welcome to <strong>QuickPost<\\/strong>! These Terms of Service (\\\"Terms\\\") govern your access to and use of our website, mobile application, and related services (collectively, the \\\"Service\\\"). By using QuickPost, you agree to comply with these Terms. Please read them carefully.<\\/p><h5>1. Acceptance of Terms<\\/h5><p>By registering for or using QuickPost, you confirm that you are at least 18 years old and have the legal authority to enter into this agreement. If you do not agree to these Terms, you may not use the Service.<\\/p><h5>2. Description of Service<\\/h5><p>QuickPost provides an AI-driven platform for social media scheduling, publishing, analytics, and automation across multiple networks, including Facebook, Instagram, X (Twitter), LinkedIn, TikTok, and YouTube.<\\/p><h5>3. Account Registration<\\/h5><ul><li>You must create an account to access most features of the Service.<\\/li><li>You agree to provide accurate, complete, and current information during registration.<\\/li><li>You are responsible for maintaining the confidentiality of your login credentials.<\\/li><li>QuickPost is not liable for any loss or damage resulting from unauthorized account access.<\\/li><\\/ul><h5>4. Subscription and Payment<\\/h5><p>Some features require a paid subscription. By purchasing a plan, you agree to our billing terms.<\\/p><ul><li>Payments are processed securely through third-party providers.<\\/li><li>Subscriptions automatically renew unless canceled before the renewal date.<\\/li><li>Refunds may be granted at our sole discretion or as required by law.<\\/li><\\/ul><h5>5. Acceptable Use<\\/h5><p>You agree not to use QuickPost for any unlawful or prohibited purpose, including:<\\/p><ul><li>Posting or distributing harmful, offensive, or illegal content.<\\/li><li>Attempting to hack, disrupt, or overload the Service.<\\/li><li>Using automated bots or scripts without authorization.<\\/li><li>Violating third-party intellectual property or privacy rights.<\\/li><\\/ul><h5>6. Intellectual Property<\\/h5><p>All content, branding, and software associated with QuickPost are owned by or licensed to us and are protected by copyright and trademark laws. You may not reproduce, distribute, or modify any part of the Service without written consent.<\\/p><h5>7. Third-Party Services<\\/h5><p>QuickPost integrates with third-party platforms (e.g., social networks). Your use of these services is subject to their own terms and privacy policies. We are not responsible for third-party content or actions.<\\/p><h5>8. Termination<\\/h5><p>We may suspend or terminate your access to QuickPost at any time, with or without notice, if we believe you have violated these Terms. Upon termination, your right to use the Service will immediately cease.<\\/p><h5>9. Disclaimer of Warranties<\\/h5><p>QuickPost is provided on an \\\"as is\\\" and \\\"as available\\\" basis. We make no warranties, express or implied, regarding the reliability, accuracy, or availability of the Service.<\\/p><h5>10. Limitation of Liability<\\/h5><p>To the maximum extent permitted by law, QuickPost and its affiliates shall not be liable for any indirect, incidental, or consequential damages arising from your use of the Service.<\\/p><h5>11. Indemnification<\\/h5><p>You agree to indemnify and hold harmless QuickPost, its affiliates, and employees from any claims, losses, or damages resulting from your breach of these Terms or misuse of the Service.<\\/p><h5>12. Governing Law<\\/h5><p>These Terms are governed by and construed in accordance with the laws of your jurisdiction, without regard to its conflict of law provisions.<\\/p><h5>13. Changes to Terms<\\/h5><p>We may modify these Terms from time to time. Updated versions will be posted on this page with a revised date. Continued use of QuickPost after updates constitutes acceptance of the new Terms.<\\/p><h5>14. Contact Us<\\/h5><p>If you have questions about these Terms, please contact us at:<br \\/><a href=\\\"mailto:legal@quickpost.com\\\">legal@quickpost.com<\\/a><\\/p>\"}', '2021-06-09 08:51:18', '2025-10-21 06:00:54'),
(44, 'maintenance.data', '{\"description\":\"<h4>We\'ll Be Back Soon!<\\/h4><p>&nbsp;<\\/p><p>Thank you for visiting our website. We are currently performing scheduled maintenance to improve your experience.&nbsp;We appreciate your patience and understanding. If you need immediate assistance, please contact us at info@arsignal.com.&nbsp;Thank you for your support!<\\/p>\"}', '2020-07-04 23:42:52', '2025-06-28 02:39:26'),
(65, 'social_icon.element', '{\"title\":\"x.com\",\"social_icon\":\"<i class=\\\"fa-brands fa-x-twitter\\\"><\\/i>\",\"url\":\"https:\\/\\/x.com\"}', '2025-09-24 03:53:00', '2025-10-21 05:37:16'),
(66, 'social_icon.element', '{\"title\":\"Instagram\",\"social_icon\":\"<i class=\\\"fab fa-instagram\\\"><\\/i>\",\"url\":\"https:\\/\\/instagram.com\"}', '2025-09-24 03:53:31', '2025-10-21 05:37:28'),
(67, 'social_icon.element', '{\"title\":\"LinkedIn\",\"social_icon\":\"<i class=\\\"fab fa-linkedin-in\\\"><\\/i>\",\"url\":\"https:\\/\\/linkedin.com\"}', '2025-09-24 03:53:50', '2025-10-21 05:37:41'),
(68, 'authentication.content', '{\"sign_in\":\"Sign in your account\",\"sign_up\":\"Sign up your account\"}', '2025-10-05 22:22:17', '2025-10-05 22:22:17'),
(69, 'authentication.element', '{\"heading\":\"Smooth, smart, and super effective. I\'m hooked\",\"description\":\"From planning to publishing, everything just flows effortlessly and intelligently\"}', '2025-10-05 22:23:03', '2025-10-05 22:23:03'),
(70, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46cbca39021759800508.png\"}', '2025-10-06 19:28:28', '2025-10-06 19:28:35'),
(71, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46cd02dcc11759800528.png\"}', '2025-10-06 19:28:48', '2025-10-06 19:28:48'),
(72, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46cdb9dff51759800539.png\"}', '2025-10-06 19:28:59', '2025-10-06 19:28:59'),
(73, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46ce71932c1759800551.png\"}', '2025-10-06 19:29:11', '2025-10-06 19:29:11'),
(74, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46cf7a7ecf1759800567.png\"}', '2025-10-06 19:29:27', '2025-10-06 19:29:27'),
(75, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46d0b46e571759800587.png\"}', '2025-10-06 19:29:47', '2025-10-06 19:29:47'),
(76, 'banner.element', '{\"has_image\":\"1\",\"image\":\"68e46d15c38f61759800597.png\"}', '2025-10-06 19:29:57', '2025-10-06 19:29:57'),
(77, 'banner_image.element', '{\"has_image\":\"1\",\"image\":\"68e46d41d380d1759800641.png\"}', '2025-10-06 19:30:41', '2025-10-06 19:30:42'),
(78, 'banner_image.element', '{\"has_image\":\"1\",\"image\":\"68e46d4c3605e1759800652.png\"}', '2025-10-06 19:30:52', '2025-10-06 19:30:52'),
(79, 'banner_image.element', '{\"has_image\":\"1\",\"image\":\"68e46d583308a1759800664.png\"}', '2025-10-06 19:31:04', '2025-10-06 19:31:04'),
(80, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"How AI is Changing Social Media Content Creation Forever\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914465113c941762936401.png\"}', '2025-10-06 19:42:05', '2025-11-12 02:33:21'),
(81, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Crafting the Perfect Caption: AI vs Human Creativity\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914465a71dd21762936410.png\"}', '2025-10-06 19:44:01', '2025-11-12 02:33:30'),
(82, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Social Media Analytics: What Metrics Really Matter\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"69144662245c51762936418.png\"}', '2025-10-06 19:45:17', '2025-11-12 02:33:38'),
(83, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Mastering Engagement: Key Insights from Analytics\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914466a357d61762936426.png\"}', '2025-10-06 19:52:05', '2025-11-12 02:33:46'),
(84, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Content Strategy: Data That Drives Real Results\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"69144672c4edf1762936434.png\"}', '2025-10-06 19:52:53', '2025-11-12 02:33:55'),
(85, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Social Growth Metrics: What to Track in 2025\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914467bb171d1762936443.png\"}', '2025-10-06 20:01:09', '2025-11-12 02:34:04'),
(86, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"Unlocking Reach: Analytics Secrets for Creators\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914468349bfa1762936451.png\"}', '2025-10-06 20:01:42', '2025-11-12 02:34:11'),
(87, 'blog.element', '{\"has_image\":[\"1\"],\"title\":\"From Likes to Leads: Measuring True Performance\",\"description\":\"<h5>How to Master Multi-Platform Social Media Posting<\\/h5><p>Creating and managing content across multiple social networks can be a challenge. With a unified strategy, you can save time and increase engagement across all your accounts.<\\/p><h5>Plan Your Posting Strategy<\\/h5><p>Before posting, decide what type of content works best for each platform. Different audiences engage differently \\u2014 LinkedIn favors long-form content, while Twitter works better for quick insights.<\\/p><ul><li>LinkedIn: Share thought leadership and professional updates.<\\/li><li>Twitter\\/X: Post short, engaging threads with links.<\\/li><li>Instagram: Focus on visuals and storytelling.<\\/li><li>Threads: Use for casual conversations and quick updates.<\\/li><\\/ul><h5>Automate and Schedule<\\/h5><p>Use automation tools to schedule posts ahead of time. This ensures that your content goes live when your audience is most active \\u2014 even if you\\u2019re offline.<\\/p><ul><li>Set predefined posting times per platform.<\\/li><li>Batch-create content for a week or month ahead.<\\/li><li>Analyze engagement data to optimize future posts.<\\/li><\\/ul><h5>Final Thoughts<\\/h5><p>Cross-platform posting doesn\\u2019t have to be stressful. With a clear plan and automation, you can maintain a strong online presence everywhere your audience is active.<\\/p><p>Work smarter, not harder \\u2014 let scheduling and analytics tools amplify your reach.<\\/p>\",\"blockquote\":\"Your content should be consistent, but not identical \\u2014 tailor your message for each platform.\",\"blog_image\":\"6914468a5ee181762936458.png\"}', '2025-10-06 20:02:23', '2025-11-12 02:34:18'),
(88, 'contact_us.element', '{\"title\":\"Phone\",\"value\":\"123456789\",\"icon\":\"<i class=\\\"fas fa-phone-volume\\\"><\\/i>\"}', '2025-10-06 20:05:30', '2025-10-06 20:05:31'),
(89, 'contact_us.element', '{\"title\":\"Email\",\"value\":\"quickpost@gmail.com\",\"icon\":\"<i class=\\\"fas fa-envelope-open\\\"><\\/i>\"}', '2025-10-06 20:06:10', '2025-10-06 20:06:10'),
(90, 'contact_us.element', '{\"title\":\"Location\",\"value\":\"6391 Elgin St. Celina, Delaware\",\"icon\":\"<i class=\\\"fas fa-map-marker-alt\\\"><\\/i>\"}', '2025-10-06 20:06:58', '2025-10-06 20:06:58'),
(91, 'contact_us.element', '{\"title\":\"Support\",\"value\":\"24\\/7 Expert Support Team\",\"icon\":\"<i class=\\\"fas fa-headset\\\"><\\/i>\"}', '2025-10-06 20:07:29', '2025-10-06 20:07:29'),
(92, 'cta.content', '{\"title\":\"Boot Your business\",\"heading\":\"AI-Powered Social Media Management\",\"subheading\":\"Manage, schedule, and optimize all your social channels with smart automation\",\"button_text\":\"GET STARTED\",\"button_url\":\"pricing\"}', '2025-10-06 20:58:26', '2025-11-12 01:20:40'),
(93, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e48264d91df1759806052.png\"}', '2025-10-06 21:00:52', '2025-10-06 21:00:53'),
(94, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e482722b3f41759806066.png\"}', '2025-10-06 21:01:06', '2025-10-06 21:01:06'),
(95, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e4827d207881759806077.png\"}', '2025-10-06 21:01:17', '2025-10-06 21:01:17'),
(96, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e4828b0d8d01759806091.png\"}', '2025-10-06 21:01:30', '2025-10-06 21:01:31'),
(97, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e48299e29651759806105.png\"}', '2025-10-06 21:01:45', '2025-10-06 21:01:46'),
(98, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e482a6a856c1759806118.png\"}', '2025-10-06 21:01:58', '2025-10-06 21:01:58'),
(99, 'cta.element', '{\"has_image\":\"1\",\"image\":\"68e482b3e21fe1759806131.png\"}', '2025-10-06 21:02:11', '2025-10-06 21:02:11'),
(100, 'faq.content', '{\"title\":\"Need Help?\",\"heading\":\"Got Questions? We\\u2019ve Got Answers.\",\"subheading\":\"Find clear, concise answers to all your questions about our services and tools.\",\"button_text\":\"GET STARTED\",\"button_url\":\"contact\"}', '2025-10-06 21:02:56', '2025-11-12 01:23:33'),
(101, 'faq.element', '{\"question\":\"How does the AI Post Generator work?\",\"answer\":\"Our Analytics Dashboard provides detailed insights including reach, engagement, and  follower growth, helping you optimize your social strategy.\"}', '2025-10-06 21:04:19', '2025-10-06 21:04:19'),
(102, 'faq.element', '{\"question\":\"Is there a free trail available?\",\"answer\":\"Our Analytics Dashboard provides detailed insights including reach, engagement, and  follower growth, helping you optimize your social strategy.\"}', '2025-10-06 21:04:41', '2025-10-06 21:04:41'),
(103, 'faq.element', '{\"question\":\"Can I customize the templates?\",\"answer\":\"Our Analytics Dashboard provides detailed insights including reach, engagement, and  follower growth, helping you optimize your social strategy.\"}', '2025-10-06 21:04:58', '2025-10-06 21:04:58'),
(104, 'faq.element', '{\"question\":\"How do I schedule posts?\",\"answer\":\"Our Analytics Dashboard provides detailed insights including reach, engagement, and  follower growth, helping you optimize your social strategy.\"}', '2025-10-06 21:05:13', '2025-10-06 21:05:13'),
(105, 'faq.element', '{\"question\":\"How do I track the performance of my posts?\",\"answer\":\"Our Analytics Dashboard provides detailed insights including reach, engagement, and  follower growth, helping you optimize your social strategy.\"}', '2025-10-06 21:05:31', '2025-10-06 21:05:31'),
(106, 'service.element', '{\"title\":\"Audience growth\",\"description\":\"Accelerate audience growth with smart tools that optimize content, reach, and engagement across social platforms.\",\"icon\":\"<i class=\\\"fas fa-file-pdf\\\"><\\/i>\"}', '2025-10-06 21:07:52', '2025-10-06 21:07:52'),
(107, 'service.element', '{\"title\":\"PDF report export\",\"description\":\"Easily export detailed performance insights as professional PDF reports to share results and track growth over time.\",\"icon\":\"<i class=\\\"far fa-file-pdf\\\"><\\/i>\"}', '2025-10-06 21:08:36', '2025-10-06 21:08:36'),
(108, 'service.element', '{\"title\":\"Better Analytics\",\"description\":\"Gain deeper insights with powerful analytics tools that track performance and optimize your social media strategy.\",\"icon\":\"<i class=\\\"fas fa-chart-line\\\"><\\/i>\"}', '2025-10-06 21:09:44', '2025-10-06 21:09:45'),
(109, 'service.element', '{\"title\":\"Improved Engagement\",\"description\":\"Boost audience interaction with AI-driven strategies tailored to increase engagement across all platforms.\",\"icon\":\"<i class=\\\"fas fa-ring\\\"><\\/i>\"}', '2025-10-06 21:10:36', '2025-10-06 21:10:37'),
(110, 'service.element', '{\"title\":\"Cost-Effectiveness\",\"description\":\"Reduce marketing costs with affordable AI tools that deliver high-quality content and efficient social media management.\",\"icon\":\"<i class=\\\"fas fa-coins\\\"><\\/i>\"}', '2025-10-06 21:11:30', '2025-10-06 21:11:31'),
(111, 'service.element', '{\"title\":\"Time Efficiency\",\"description\":\"Save time and boost productivity with AI tools that streamline content creation, scheduling, and engagement.\",\"icon\":\"<i class=\\\"fas fa-clock\\\"><\\/i>\"}', '2025-10-06 21:11:55', '2025-10-06 21:11:55'),
(112, 'pricing.content', '{\"title\":\"Pricing\",\"heading\":\"Choose the right plan that fits your business needs\",\"subheading\":\"Flexible pricing for creators, teams, and growing businesses.\"}', '2025-10-06 21:12:21', '2025-10-06 21:12:21'),
(113, 'why_us.content', '{\"title\":\"Why Choose Us\",\"heading\":\"Why Our Clients Stick With Us\",\"subheading\":\"Smart tools and expert solutions to create, schedule, and your brand\\u2019s online presence\"}', '2025-10-06 21:13:11', '2025-10-06 21:13:11'),
(114, 'why_us.element', '{\"title\":\"Secure &amp; Reliable\",\"description\":\"Your data stays safe with us; your reputation stays strong.\",\"icon\":\"<i class=\\\"fas fa-shield-alt\\\"><\\/i>\"}', '2025-10-06 21:13:41', '2025-10-06 21:13:41'),
(115, 'why_us.element', '{\"title\":\"24\\/7 Content Engine\",\"description\":\"Keep your social profiles active even while you sleep.\",\"icon\":\"<i class=\\\"fas fa-headset\\\"><\\/i>\"}', '2025-10-06 21:14:09', '2025-10-06 21:14:09'),
(116, 'why_us.element', '{\"title\":\"All-in-One Dashboard\",\"description\":\"Manage multiple platforms (Facebook, Instagram, X, LinkedIn, etc.) from one place.\",\"icon\":\"<i class=\\\"fas fa-laptop\\\"><\\/i>\"}', '2025-10-06 21:14:48', '2025-10-06 21:14:48'),
(117, 'subscribe.content', '{\"subheading\":\"Get the latest account offers and hot deals \\u2014 subscribe today!\"}', '2025-10-06 21:17:15', '2025-10-06 21:17:15'),
(118, 'testimonial.element', '{\"has_image\":\"1\",\"review\":\"Scheduling posts from one dashboard simplifies social media management across platforms\\u2014efficient, time-saving, and effective. A true game-changer  I highly recommend.\",\"name\":\"Leslie Alexander\",\"designation\":\"Business Owner\",\"image\":\"68e486f8723b91759807224.jpg\"}', '2025-10-06 21:20:24', '2025-10-06 21:20:24'),
(119, 'testimonial.element', '{\"has_image\":\"1\",\"review\":\"This platform made it effortless to organize and track my campaigns. The  analytics are clear and easy to understand\\u2014helping me make smarter decisions  every day.\",\"name\":\"Michael Johnson\",\"designation\":\"Marketing Specialist\",\"image\":\"68e4873036e031759807280.jpg\"}', '2025-10-06 21:21:19', '2025-10-06 21:21:20'),
(120, 'testimonial.element', '{\"has_image\":\"1\",\"review\":\"What used to take me hours now takes just minutes. The automation tools are  a lifesaver\\u2014I can finally focus on growing my business instead of manual  tasks.\",\"name\":\"Sophia Martinez\",\"designation\":\"Entrepreneur\",\"image\":\"68e48765428981759807333.jpg\"}', '2025-10-06 21:22:12', '2025-10-06 21:22:13'),
(121, 'testimonial.element', '{\"has_image\":\"1\",\"review\":\"This platform made it effortless to organize and track my campaigns. The  analytics are clear and easy to understand\\u2014helping me make smarter decisions every day.\",\"name\":\"Michael Johnson\",\"designation\":\"Marketing Specialist\",\"image\":\"68e48795407f61759807381.jpg\"}', '2025-10-06 21:23:00', '2025-10-06 21:23:01'),
(122, 'feature.element', '{\"has_image\":\"1\",\"title\":\"AI Post Generator\",\"description\":\"Generate engaging social media posts instantly with our AI-powered tool.\",\"image\":\"68e488855f9431759807621.jpg\"}', '2025-10-06 21:27:01', '2025-10-06 21:27:01'),
(123, 'feature.element', '{\"has_image\":\"1\",\"title\":\"Social Media Scheduler\",\"description\":\"Plan, schedule, and automate your posts across all platforms from one dashboard.\",\"image\":\"68e4889f846061759807647.jpg\"}', '2025-10-06 21:27:27', '2025-10-06 21:27:27'),
(124, 'feature.element', '{\"has_image\":\"1\",\"title\":\"Performance Analytics\",\"description\":\"Track and analyze your social media performance with real-time analytics tools\",\"image\":\"68e488be7a9781759807678.jpg\"}', '2025-10-06 21:27:58', '2025-10-06 21:27:58'),
(125, 'feature.element', '{\"has_image\":\"1\",\"title\":\"Ready-to-Use Templates\",\"description\":\"Choose from hundreds of professionally designed templates for Instagram, Facebook, LinkedIn\",\"image\":\"68e488e3be1bc1759807715.jpg\"}', '2025-10-06 21:28:35', '2025-10-06 21:28:36'),
(126, 'feature.element', '{\"has_image\":\"1\",\"title\":\"Content categories\",\"description\":\"Categorize posts into folders by topic after uploading your blog\\u2019s RSS feed or bulk imports.\",\"image\":\"68e488f6c83031759807734.jpg\"}', '2025-10-06 21:28:54', '2025-10-06 21:28:55'),
(127, 'feature.element', '{\"has_image\":\"1\",\"title\":\"Multi-Platform Support\",\"description\":\"Create content tailored for different platforms facebook, Twitter (X), LinkedIn, TikTok\",\"image\":\"68e4890bd11921759807755.jpg\"}', '2025-10-06 21:29:15', '2025-10-06 21:29:16'),
(128, 'authentication.element', '{\"heading\":\"Plan once, post everywhere. Instantly.\",\"description\":\"QuickPost makes content scheduling effortless \\u2014 connect all your social media platforms like Facebook, Instagram, LinkedIn, YouTube, TikTok, and Twitter, and publish in one click. Smart, fast, and beautifully simple.\"}', '2025-10-20 04:38:22', '2025-10-20 04:38:22'),
(129, 'authentication.element', '{\"heading\":\"Your entire social media strategy \\u2014 simplified.\",\"description\":\"From planning to publishing, QuickPost streamlines your workflow. Schedule posts, manage campaigns, and stay consistent across every platform without breaking a sweat.\"}', '2025-10-20 04:38:37', '2025-10-20 04:38:37'),
(130, 'authentication.element', '{\"heading\":\"Create. Schedule. Grow. Effortlessly.\",\"description\":\"With QuickPost, managing multiple social networks feels natural. Automate your content calendar, publish everywhere at once, and focus on what really matters \\u2014 your creativity.\"}', '2025-10-20 04:38:52', '2025-10-20 04:38:52'),
(131, 'authentication.element', '{\"heading\":\"Meet your new social media control center.\",\"description\":\"QuickPost gives you full control over LinkedIn, Twitter, Facebook, Instagram, YouTube, and TikTok \\u2014 schedule, post, and track everything from one smart dashboard.\"}', '2025-10-20 04:39:04', '2025-10-20 04:39:04');

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

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

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

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

INSERT INTO `gateways` (`id`, `form_id`, `code`, `name`, `alias`, `status`, `gateway_parameters`, `supported_currencies`, `crypto`, `extra`, `description`, `image`, `created_at`, `updated_at`) VALUES
(1, 0, 101, 'Paypal', 'Paypal', 1, '{\"paypal_email\":{\"title\":\"PayPal Email\",\"global\":true,\"value\":\"sb-58ira22618401@business.example.com\"}}', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}', 0, NULL, NULL, '68ad6c4a8e06b1756195914.png', '2019-09-14 13:14:22', '2025-08-26 02:11:54'),
(2, 0, 102, 'Perfect Money', 'PerfectMoney', 1, '{\"passphrase\":{\"title\":\"ALTERNATE PASSPHRASE\",\"global\":true,\"value\":\"---------------------\"},\"wallet_id\":{\"title\":\"PM Wallet\",\"global\":false,\"value\":\"\"}}', '{\"USD\":\"$\",\"EUR\":\"\\u20ac\"}', 0, NULL, NULL, '68ad6bf7d53731756195831.png', '2019-09-14 13:14:22', '2025-08-26 02:10:31'),
(3, 0, 105, 'PayTM', 'Paytm', 1, '{\"MID\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"-----------\"},\"merchant_key\":{\"title\":\"Merchant Key\",\"global\":true,\"value\":\"--------------------\"},\"WEBSITE\":{\"title\":\"Paytm Website\",\"global\":true,\"value\":\"example.com\"},\"INDUSTRY_TYPE_ID\":{\"title\":\"Industry Type\",\"global\":true,\"value\":\"Retail\"},\"CHANNEL_ID\":{\"title\":\"CHANNEL ID\",\"global\":true,\"value\":\"WEB\"},\"transaction_url\":{\"title\":\"Transaction URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/oltp-web\\/processTransaction\"},\"transaction_status_url\":{\"title\":\"Transaction STATUS URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/paytmchecksum\\/paytmCallback.jsp\"}}', '{\"AUD\":\"AUD\",\"ARS\":\"ARS\",\"BDT\":\"BDT\",\"BRL\":\"BRL\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"GEL\":\"GEL\",\"GHS\":\"GHS\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"NGN\":\"NGN\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"UGX\":\"UGX\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"GBP\":\"GBP\",\"USD\":\"USD\",\"VND\":\"VND\",\"XOF\":\"XOF\"}', 0, NULL, NULL, '68ad6c1ac3b1d1756195866.png', '2019-09-14 13:14:22', '2025-08-26 02:11:06'),
(4, 0, 107, 'PayStack', 'Paystack', 1, '{\"public_key\":{\"title\":\"Public key\",\"global\":true,\"value\":\"--------\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"----------------\"}}', '{\"USD\":\"USD\",\"NGN\":\"NGN\"}', 0, '{\"callback\":{\"title\": \"Callback URL\",\"value\":\"ipn.Paystack\"},\"webhook\":{\"title\": \"Webhook URL\",\"value\":\"ipn.Paystack\"}}\r\n', NULL, '68ad6c289ed011756195880.png', '2019-09-14 13:14:22', '2025-08-26 02:11:20'),
(5, 0, 108, 'VoguePay', 'Voguepay', 1, '{\"merchant_id\":{\"title\":\"MERCHANT ID\",\"global\":true,\"value\":\"-------------------\"}}', '{\"USD\":\"USD\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"ZAR\":\"ZAR\"}', 0, NULL, NULL, '68ad6bba02fe21756195770.png', '2019-09-14 13:14:22', '2025-08-26 02:09:30'),
(6, 0, 109, 'Flutterwave', 'Flutterwave', 1, '{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"----------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------------------\"},\"encryption_key\":{\"title\":\"Encryption Key\",\"global\":true,\"value\":\"------------------\"}}', '{\"BIF\":\"BIF\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CVE\":\"CVE\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"GHS\":\"GHS\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"KES\":\"KES\",\"LRD\":\"LRD\",\"MWK\":\"MWK\",\"MZN\":\"MZN\",\"NGN\":\"NGN\",\"RWF\":\"RWF\",\"SLL\":\"SLL\",\"STD\":\"STD\",\"TZS\":\"TZS\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"XAF\":\"XAF\",\"XOF\":\"XOF\",\"ZMK\":\"ZMK\",\"ZMW\":\"ZMW\",\"ZWD\":\"ZWD\"}', 0, NULL, NULL, '68ad6c83913901756195971.png', '2019-09-14 13:14:22', '2025-11-13 06:39:33'),
(7, 0, 110, 'RazorPay', 'Razorpay', 1, '{\"key_id\":{\"title\":\"Key Id\",\"global\":true,\"value\":\"------------\"},\"key_secret\":{\"title\":\"Key Secret \",\"global\":true,\"value\":\"--------\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '68ad6beb086241756195819.png', '2019-09-14 13:14:22', '2025-08-26 02:10:19'),
(8, 0, 112, 'Instamojo', 'Instamojo', 1, '{\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"------------\"},\"auth_token\":{\"title\":\"Auth Token\",\"global\":true,\"value\":\"---------\"},\"salt\":{\"title\":\"Salt\",\"global\":true,\"value\":\"-------\"}}', '{\"INR\":\"INR\"}', 0, NULL, NULL, '68ad6c7c20a921756195964.png', '2019-09-14 13:14:22', '2025-08-26 02:12:44'),
(9, 0, 503, 'CoinPayments', 'Coinpayments', 1, '{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"---------------\"},\"private_key\":{\"title\":\"Private Key\",\"global\":true,\"value\":\"------------\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"----------------\"}}', '{\"BTC\":\"Bitcoin\",\"BTC.LN\":\"Bitcoin (Lightning Network)\",\"LTC\":\"Litecoin\",\"CPS\":\"CPS Coin\",\"VLX\":\"Velas\",\"APL\":\"Apollo\",\"AYA\":\"Aryacoin\",\"BAD\":\"Badcoin\",\"BCD\":\"Bitcoin Diamond\",\"BCH\":\"Bitcoin Cash\",\"BCN\":\"Bytecoin\",\"BEAM\":\"BEAM\",\"BITB\":\"Bean Cash\",\"BLK\":\"BlackCoin\",\"BSV\":\"Bitcoin SV\",\"BTAD\":\"Bitcoin Adult\",\"BTG\":\"Bitcoin Gold\",\"BTT\":\"BitTorrent\",\"CLOAK\":\"CloakCoin\",\"CLUB\":\"ClubCoin\",\"CRW\":\"Crown\",\"CRYP\":\"CrypticCoin\",\"CRYT\":\"CryTrExCoin\",\"CURE\":\"CureCoin\",\"DASH\":\"DASH\",\"DCR\":\"Decred\",\"DEV\":\"DeviantCoin\",\"DGB\":\"DigiByte\",\"DOGE\":\"Dogecoin\",\"EBST\":\"eBoost\",\"EOS\":\"EOS\",\"ETC\":\"Ether Classic\",\"ETH\":\"Ethereum\",\"ETN\":\"Electroneum\",\"EUNO\":\"EUNO\",\"EXP\":\"EXP\",\"Expanse\":\"Expanse\",\"FLASH\":\"FLASH\",\"GAME\":\"GameCredits\",\"GLC\":\"Goldcoin\",\"GRS\":\"Groestlcoin\",\"KMD\":\"Komodo\",\"LOKI\":\"LOKI\",\"LSK\":\"LSK\",\"MAID\":\"MaidSafeCoin\",\"MUE\":\"MonetaryUnit\",\"NAV\":\"NAV Coin\",\"NEO\":\"NEO\",\"NMC\":\"Namecoin\",\"NVST\":\"NVO Token\",\"NXT\":\"NXT\",\"OMNI\":\"OMNI\",\"PINK\":\"PinkCoin\",\"PIVX\":\"PIVX\",\"POT\":\"PotCoin\",\"PPC\":\"Peercoin\",\"PROC\":\"ProCurrency\",\"PURA\":\"PURA\",\"QTUM\":\"QTUM\",\"RES\":\"Resistance\",\"RVN\":\"Ravencoin\",\"RVR\":\"RevolutionVR\",\"SBD\":\"Steem Dollars\",\"SMART\":\"SmartCash\",\"SOXAX\":\"SOXAX\",\"STEEM\":\"STEEM\",\"STRAT\":\"STRAT\",\"SYS\":\"Syscoin\",\"TPAY\":\"TokenPay\",\"TRIGGERS\":\"Triggers\",\"TRX\":\" TRON\",\"UBQ\":\"Ubiq\",\"UNIT\":\"UniversalCurrency\",\"USDT\":\"Tether USD (Omni Layer)\",\"USDT.BEP20\":\"Tether USD (BSC Chain)\",\"USDT.ERC20\":\"Tether USD (ERC20)\",\"USDT.TRC20\":\"Tether USD (Tron/TRC20)\",\"VTC\":\"Vertcoin\",\"WAVES\":\"Waves\",\"XCP\":\"Counterparty\",\"XEM\":\"NEM\",\"XMR\":\"Monero\",\"XSN\":\"Stakenet\",\"XSR\":\"SucreCoin\",\"XVG\":\"VERGE\",\"XZC\":\"ZCoin\",\"ZEC\":\"ZCash\",\"ZEN\":\"Horizen\"}', 1, NULL, NULL, '68ad6cc15eb401756196033.png', '2019-09-14 13:14:22', '2025-11-13 06:39:31'),
(10, 0, 506, 'Coinbase Commerce', 'CoinbaseCommerce', 1, '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"---------\"},\"secret\":{\"title\":\"Webhook Shared Secret\",\"global\":true,\"value\":\"----------------\"}}', '{\"USD\":\"USD\",\"EUR\":\"EUR\",\"JPY\":\"JPY\",\"GBP\":\"GBP\",\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CNY\":\"CNY\",\"SEK\":\"SEK\",\"NZD\":\"NZD\",\"MXN\":\"MXN\",\"SGD\":\"SGD\",\"HKD\":\"HKD\",\"NOK\":\"NOK\",\"KRW\":\"KRW\",\"TRY\":\"TRY\",\"RUB\":\"RUB\",\"INR\":\"INR\",\"BRL\":\"BRL\",\"ZAR\":\"ZAR\",\"AED\":\"AED\",\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AWG\":\"AWG\",\"AZN\":\"AZN\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYN\":\"BYN\",\"BZD\":\"BZD\",\"CDF\":\"CDF\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHS\":\"GHS\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MYR\":\"MYR\",\"MZN\":\"MZN\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NPR\":\"NPR\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDG\":\"SDG\",\"SHP\":\"SHP\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SRD\":\"SRD\",\"SSP\":\"SSP\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMT\":\"TMT\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TTD\":\"TTD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZMW\":\"ZMW\",\"ZWL\":\"ZWL\"}\r\n\r\n', 0, '{\"endpoint\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.CoinbaseCommerce\"}}', NULL, '68ad6af1dab631756195569.png', '2019-09-14 13:14:22', '2025-11-13 06:39:29'),
(11, 0, 113, 'Paypal Express', 'PaypalSdk', 1, '{\"clientId\":{\"title\":\"Paypal Client ID\",\"global\":true,\"value\":\"------------\"},\"clientSecret\":{\"title\":\"Client Secret\",\"global\":true,\"value\":\"-----------\"}}', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}', 0, NULL, NULL, '68ad6c40c252c1756195904.png', '2019-09-14 13:14:22', '2025-08-26 02:11:44'),
(12, 0, 114, 'Stripe Checkout', 'StripeV3', 1, '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51M8Ks2CL65BWuH7eCBcWsLP2yPfWaLtfJVxG3zfii7cCWJE1izM4jkhucmBSm6izmVtSGZyp0JDYYCVmx9E4WmQY004gfnctzD\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51M8Ks2CL65BWuH7eju6khGxJMpeeFuw2Rwrjr8UYCz6ZnQ3PiFxb1gVu1i1dBto9MQrnjkBimHkFJgNcqsrJHTak0010kCY41h\"},\"end_point\":{\"title\":\"End Point Secret\",\"global\":true,\"value\":\"abcd\"}}', '{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}', 0, '{\"webhook\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.StripeV3\"}}', NULL, '68ad6baf71dc81756195759.png', '2019-09-14 13:14:22', '2025-08-26 02:09:19'),
(49, 21, 1000, 'Bank Transfer', 'bank_transfer', 1, '[]', '[]', 0, NULL, '<p>Transfer funds to our official bank account. Enter the details exactly as shown on your transfer receipt. Bank deposits may take 1–3 business days to appear depending on your bank.</p>', '68ad62d32cb781756193491.png', '2025-06-28 07:50:58', '2025-09-21 07:23:28'),
(50, 22, 1001, 'Mobile Money', 'mobile_money', 1, '[]', '[]', 0, NULL, '<p>Please send the deposit to our official mobile money number. Make sure to include the correct transaction reference for quick approval. Mobile money deposits are usually processed within a few hours.</p>', '68ad62c6cdb141756193478.png', '2025-06-29 03:30:33', '2025-09-21 07:21:49'),
(51, 23, 1002, 'Cash Pay', 'cash_pay', 1, '[]', '[]', 0, NULL, '<p><i>Deposit cash directly at our office or approved agent location. Provide the agent name or receipt number for verification. Funds will be credited to your account after confirmation.</i></p>', '68ad62b3590361756193459.png', '2025-06-29 03:32:11', '2025-09-21 07:24:06'),
(52, 0, 115, 'Mercado Pago', 'MercadoPago', 1, '{\"access_token\":{\"title\":\"Access Token\",\"global\":true,\"value\":\"APP_USR-7924565816849832-082312-21941521997fab717db925cf1ea2c190-1071840315\"}}', '{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\",\"BRL\":\"BRL\"}', 0, '{\"webhook\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.MercadoPago\"}}', NULL, '68ad6c58c0d201756195928.png', '2019-09-14 13:14:22', '2025-08-26 02:12:08'),
(53, 25, 1003, 'Manual Transfer', 'manual_transfer', 1, '[]', '[]', 0, NULL, '<p><i>Please transfer the deposit amount to the provided account manually. After transferring, submit the details and upload the reference number for quick verification. Processing may take 1–2 business days after admin approval.</i></p>', '68ad62a1206e81756193441.png', '2025-08-13 02:19:07', '2025-09-21 07:23:50');

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

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

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

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

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

CREATE TABLE `general_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cur_text` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'currency text',
  `cur_sym` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'currency symbol',
  `email_from` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `sms_body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sms_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `base_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `secondary_color` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mail_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'email configuration',
  `sms_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `global_shortcodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `kv` tinyint(1) NOT NULL DEFAULT '0',
  `ev` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'email verification, 0 - dont check, 1 - check',
  `en` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'email notification, 0 - dont send, 1 - send',
  `sv` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'mobile verication, 0 - dont check, 1 - check',
  `sn` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'sms notification, 0 - dont send, 1 - send',
  `force_ssl` tinyint(1) NOT NULL DEFAULT '0',
  `maintenance_mode` tinyint(1) NOT NULL DEFAULT '0',
  `secure_password` tinyint(1) NOT NULL DEFAULT '0',
  `agree` tinyint(1) NOT NULL DEFAULT '0',
  `registration` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Off	, 1: On',
  `active_template` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `system_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `socialite_credentials` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `social_app_credential` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `free_post_status` tinyint(1) NOT NULL DEFAULT '0',
  `trail_days` int NOT NULL DEFAULT '0',
  `plan_contents` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `connected_profile` tinyint NOT NULL DEFAULT '0',
  `schedule_post_count` tinyint NOT NULL DEFAULT '0',
  `featured_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `api_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `gpt_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gpt_max_result_length` int NOT NULL DEFAULT '0',
  `last_cron` timestamp NULL DEFAULT NULL,
  `image_generate_status` tinyint(1) NOT NULL DEFAULT '0',
  `per_image_credit` decimal(14,4) NOT NULL DEFAULT '0.0000',
  `per_credit_price` decimal(14,4) NOT NULL DEFAULT '0.0000',
  `per_hashtag_credit` decimal(14,4) NOT NULL DEFAULT '0.0000',
  `per_content_credit` decimal(14,4) NOT NULL DEFAULT '0.0000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `general_settings` (`id`, `site_name`, `cur_text`, `cur_sym`, `email_from`, `email_template`, `sms_body`, `sms_from`, `base_color`, `secondary_color`, `mail_config`, `sms_config`, `global_shortcodes`, `kv`, `ev`, `en`, `sv`, `sn`, `force_ssl`, `maintenance_mode`, `secure_password`, `agree`, `registration`, `active_template`, `system_info`, `socialite_credentials`, `social_app_credential`, `free_post_status`, `trail_days`, `plan_contents`, `connected_profile`, `schedule_post_count`, `featured_text`, `api_key`, `gpt_model`, `gpt_max_result_length`, `last_cron`, `image_generate_status`, `per_image_credit`, `per_credit_price`, `per_hashtag_credit`, `per_content_credit`, `created_at`, `updated_at`) VALUES
(1, 'QuickPost', 'USD', '$', 'quickpost@gmail.com', '<p>Hi {{fullname}} ({{username}}),&nbsp;</p><p>{{message}}</p>', 'Hi {{fullname}} ({{username}}), \r\n{{message}}', 'QuickPost', '8a42ff', '2b2b36', '{\"name\":\"php\"}', '{\"name\":\"custom\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":null,\"password\":null},\"message_bird\":{\"api_key\":null},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":null,\"password\":null},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":[\"from_number\"],\"value\":[\"5657545757\"]}}}', '{\n    \"site_name\":\"Name of your site\",\n    \"site_currency\":\"Currency of your site\",\n    \"currency_symbol\":\"Symbol of currency\"\n}', 0, 1, 1, 1, 1, 0, 0, 0, 1, 1, 'default', '[]', '{\"google\":{\"client_id\":\"959894800111-743odo92gdre71v9vt1u6pqkc5vo9v3g.apps.googleusercontent.com\",\"client_secret\":\"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\",\"status\":1},\"facebook\":{\"client_id\":\"================\",\"client_secret\":\"==============\",\"status\":0}}', '{\"facebook\":{\"client_id\":\"793801346967014\",\"client_secret\":\"c76f3d152983d33b10ac9f3aa8b2ab4b\",\"status\":1},\"youtube\":{\"client_id\":\"150880694660-07533fjog5tqiqaig00n4od19tmtpi7m.apps.googleusercontent.com\",\"client_secret\":\"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\",\"api_key\":\"AQ.Ab8RN6LBwjXXR4G_VZqOT_JA_OE7kVY3-pD1N0lXXoYX_QGcqg\",\"status\":1},\"twitter\":{\"client_id\":\"Wm9BUzNmbDN4X2dOcXZtbDliU0o6MTpjaQ\",\"client_secret\":\"RYpsgW5e1QTT1WHCM7VOeKLgSbyjGSeO73p5fmmhvouq2ahDZF\",\"status\":1},\"linkedin\":{\"client_id\":\"780tarzxwxgi2i\",\"client_secret\":\"WPL_AP1.Ci8COc6AilhodUEa.4dvpjg==\",\"status\":1},\"tiktok\":{\"client_id\":\"sbaw7ooup26hd51q43\",\"client_secret\":\"ZChwpn5Jw8aRFao87ErO1lG3A1Pf6HVS\",\"status\":1},\"instagram\":{\"app_id\":\"awtw0oylgj47wwex\",\"app_secret\":\"a25f4639c515dd348766e25d0a3d0bc0\",\"status\":1,\"client_id\":\"793801346967014\",\"client_secret\":\"c76f3d152983d33b10ac9f3aa8b2ab4b\"}}', 1, 14, '[\"Basic analytics dashboard\",\"Manual post scheduling\",\"Priority email support\",\"AI caption generation\",\"24\\/7 premium support\",\"AI Image Generation\"]', 3, 10, 'Free Trail for 14 days', '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', 'gpt-3.5-turbo-16k', 500, '2025-11-28 12:21:02', 1, 1.8000, 2.0000, 0.4000, 0.9000, NULL, '2025-12-08 04:57:34');

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

--
-- Table structure for table `gpt_models`
--

CREATE TABLE `gpt_models` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gpt_models`
--

INSERT INTO `gpt_models` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'gpt-4o', 'model', NULL, NULL),
(2, 'gpt-4o-mini', 'model', NULL, NULL),
(3, 'gpt-4-turbo', 'Older GPT-4 turbo model – large context', NULL, NULL),
(4, 'gpt-3.5-turbo', 'model', NULL, NULL),
(5, 'gpt-3.5-turbo-16k', 'model', NULL, NULL),
(6, 'gpt-3.5-turbo-instruct', 'model', NULL, NULL),
(7, 'gpt-3.5-turbo-instruct-0914', 'model', NULL, NULL),
(8, 'gpt-3.5-turbo-1106', 'model', NULL, NULL),
(9, 'gpt-3.5-turbo-0125', 'model', NULL, NULL),
(10, 'davinci-002', 'model', NULL, NULL),
(11, 'babbage-002', 'model', NULL, NULL),
(12, 'o1-preview', 'model', NULL, NULL),
(13, 'o1-preview-2024-09-12', 'model', NULL, NULL),
(14, 'o1-mini', 'model', NULL, NULL),
(15, 'o1-mini-2024-09-12', 'model', NULL, NULL),
(16, 'gpt-4.1', 'model', NULL, NULL),
(17, 'gpt-4.1-2025-04-14', 'model', NULL, NULL),
(18, 'gpt-4.1-mini', 'model', NULL, NULL),
(19, 'gpt-4.1-mini-2025-04-14', 'model', NULL, NULL),
(20, 'gpt-4.1-nano', 'model', NULL, NULL),
(21, 'gpt-4.1-nano-2025-04-14', 'model', NULL, NULL),
(22, 'o3', 'Reasoning Model', NULL, NULL),
(23, 'o3-mini', 'Reasoning Model', NULL, NULL),
(24, 'gpt-oss-120b', 'Open-Weight Model', NULL, NULL),
(25, 'gpt-oss-20b', 'Open-Weight Model', NULL, NULL);

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

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

CREATE TABLE `languages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_align` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: left to right text align, 1: right to left text align',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: not default language, 1: default language',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `name`, `code`, `image`, `text_align`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', '68cfe345448ad1758454597.png', 0, 1, '2020-07-06 03:47:55', '2025-09-21 05:36:37'),
(16, 'Spanish', 'es', '68cfe376103511758454646.jpg', 0, 0, '2025-06-26 00:14:07', '2025-09-21 05:37:26');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 'Header Menu', 'header_menu', '2025-09-16 02:39:26', '2025-09-16 02:39:26'),
(2, 'Useful Links', 'useful_links', '2025-09-16 02:39:37', '2025-09-20 03:03:58'),
(3, 'Quick Links', 'quick_links', '2025-10-07 00:00:04', '2025-10-07 00:00:04');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `link_type` tinyint(1) NOT NULL DEFAULT '1',
  `page_id` bigint NOT NULL DEFAULT '0',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `title`, `link_type`, `page_id`, `url`, `created_at`, `updated_at`) VALUES
(6, 'Privacy Policy', 1, 0, 'policy/privacy-policy/42', '2025-09-20 03:05:05', '2025-09-20 03:05:05'),
(7, 'Terms of Service', 1, 0, 'policy/terms-of-service/43', '2025-09-20 03:05:23', '2025-09-20 03:05:23'),
(8, 'Cookie Policy', 1, 0, 'cookie-policy', '2025-09-20 03:05:37', '2025-09-20 03:05:37'),
(9, 'Home', 3, 1, '/', '2025-10-07 00:00:23', '2025-10-07 00:00:23'),
(11, 'Pricing', 3, 5, 'pricing', '2025-10-07 00:00:48', '2025-10-07 00:00:48'),
(12, 'Features', 3, 4, 'features', '2025-10-07 00:01:02', '2025-10-07 00:01:02'),
(13, 'Blogs', 3, 2, 'blog', '2025-10-07 00:01:13', '2025-10-07 00:01:13'),
(14, 'Contact', 3, 3, 'contact', '2025-10-07 00:01:20', '2025-10-07 00:01:20'),
(16, 'About', 3, 22, 'about-us', '2025-11-13 02:28:25', '2025-11-13 02:28:25');

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

--
-- Table structure for table `menu_menu_items`
--

CREATE TABLE `menu_menu_items` (
  `id` bigint NOT NULL,
  `menu_id` bigint NOT NULL,
  `menu_item_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu_menu_items`
--

INSERT INTO `menu_menu_items` (`id`, `menu_id`, `menu_item_id`, `created_at`, `updated_at`) VALUES
(26, 4, 12, '2025-10-07 00:02:38', '2025-10-07 00:02:38'),
(27, 4, 11, '2025-10-07 00:02:38', '2025-10-07 00:02:38'),
(28, 4, 13, '2025-10-07 00:02:38', '2025-10-07 00:02:38'),
(29, 4, 14, '2025-10-07 00:02:38', '2025-10-07 00:02:38'),
(31, 2, 6, '2025-10-07 00:03:23', '2025-10-07 00:03:23'),
(32, 2, 7, '2025-10-07 00:03:23', '2025-10-07 00:03:23'),
(33, 2, 8, '2025-10-07 00:03:23', '2025-10-07 00:03:23'),
(45, 3, 11, '2025-11-12 03:20:40', '2025-11-12 03:20:40'),
(46, 3, 13, '2025-11-12 03:20:40', '2025-11-12 03:20:40'),
(47, 3, 14, '2025-11-12 03:20:40', '2025-11-12 03:20:40'),
(49, 1, 9, '2025-11-13 02:28:39', '2025-11-13 02:28:39'),
(50, 1, 16, '2025-11-13 02:28:39', '2025-11-13 02:28:39'),
(51, 1, 11, '2025-11-13 02:28:39', '2025-11-13 02:28:39'),
(52, 1, 12, '2025-11-13 02:28:39', '2025-11-13 02:28:39'),
(53, 1, 13, '2025-11-13 02:28:39', '2025-11-13 02:28:39'),
(54, 1, 14, '2025-11-13 02:28:39', '2025-11-13 02:28:39');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(2, '2025_07_19_024836_create_menus_table', 1),
(3, '2025_07_19_024852_create_menu_items_table', 2),
(4, '2025_07_19_024918_create_menu_menu_items_table', 3);

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

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

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

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

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

CREATE TABLE `notification_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `sms_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `shortcodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email_status` tinyint(1) NOT NULL DEFAULT '1',
  `sms_status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` (`id`, `act`, `name`, `subj`, `email_body`, `sms_body`, `shortcodes`, `email_status`, `sms_status`, `created_at`, `updated_at`) VALUES
(1, 'BAL_ADD', 'Balance - Added', 'Your Account has been Credited', '<div><div style=\"font-family: Montserrat, sans-serif;\">{{amount}} {{site_currency}} has been added to your account .</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">Your Current Balance is :&nbsp;</span><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">{{post_balance}}&nbsp; {{site_currency}}&nbsp;</span></font><br></div><div><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></font></div><div>Admin note:&nbsp;<span style=\"color: rgb(33, 37, 41); font-size: 12px; font-weight: 600; white-space: nowrap; text-align: var(--bs-body-text-align);\">{{remark}}</span></div>', '{{amount}} {{site_currency}} credited in your account. Your Current Balance {{post_balance}} {{site_currency}} . Transaction: #{{trx}}. Admin note is \"{{remark}}\"', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 0, '2021-11-03 12:00:00', '2022-09-21 13:04:13'),
(2, 'BAL_SUB', 'Balance - Subtracted', 'Your Account has been Debited', '<div style=\"font-family: Montserrat, sans-serif;\">{{amount}} {{site_currency}} has been subtracted from your account .</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">Your Current Balance is :&nbsp;</span><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">{{post_balance}}&nbsp; {{site_currency}}</span></font><br><div><font style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></font></div><div>Admin Note: {{remark}}</div>', '{{amount}} {{site_currency}} debited from your account. Your Current Balance {{post_balance}} {{site_currency}} . Transaction: #{{trx}}. Admin Note is {{remark}}', '{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:24:11'),
(3, 'DEPOSIT_COMPLETE', 'Deposit - Automated - Successful', 'Deposit Completed Successfully', '<div>Your deposit of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been completed Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div><br></div><div>Amount : {{amount}} {{site_currency}}</div><div>Charge:&nbsp;<font color=\"#000000\">{{charge}} {{site_currency}}</font></div><div><br></div><div>Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div>Received : {{method_amount}} {{method_currency}}<br></div><div>Paid via :&nbsp; {{method_name}}</div><div><br></div><div>Transaction Number : {{trx}}</div><div><font size=\"5\"><span style=\"font-weight: bolder;\"><br></span></font></div><div><font size=\"5\">Your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}} {{site_currency}}</span></font></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', '{{amount}} {{site_currency}} Deposit successfully by {{method_name}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:25:43'),
(4, 'DEPOSIT_APPROVE', 'Deposit - Manual - Approved', 'Your Deposit is Approved', '<div style=\"font-family: Montserrat, sans-serif;\">Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>is Approved .<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Received : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"5\"><span style=\"font-weight: bolder;\"><br></span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"5\">Your current Balance is&nbsp;<span style=\"font-weight: bolder;\">{{post_balance}} {{site_currency}}</span></font></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div>', 'Admin Approve Your {{amount}} {{site_currency}} payment request by {{method_name}} transaction : {{trx}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:26:07'),
(5, 'DEPOSIT_REJECT', 'Deposit - Manual - Rejected', 'Your Deposit Request is Rejected', '<div style=\"font-family: Montserrat, sans-serif;\">Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}} has been rejected</span>.<span style=\"font-weight: bolder;\"><br></span></div><div><br></div><div><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Received : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\">Charge: {{charge}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number was : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">if you have any queries, feel free to contact us.<br></div><br style=\"font-family: Montserrat, sans-serif;\"><div style=\"font-family: Montserrat, sans-serif;\"><br><br></div><span style=\"color: rgb(33, 37, 41); font-family: Montserrat, sans-serif;\">{{rejection_message}}</span><br>', 'Admin Rejected Your {{amount}} {{site_currency}} payment request by {{method_name}}\r\n\r\n{{rejection_message}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"rejection_message\":\"Rejection message by the admin\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-05 03:45:27'),
(6, 'DEPOSIT_REQUEST', 'Deposit - Manual - Requested', 'Deposit Request Submitted Successfully', '<div>Your deposit request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>submitted successfully<span style=\"font-weight: bolder;\">&nbsp;.<br></span></div><div><span style=\"font-weight: bolder;\"><br></span></div><div><span style=\"font-weight: bolder;\">Details of your Deposit :<br></span></div><div><br></div><div>Amount : {{amount}} {{site_currency}}</div><div>Charge:&nbsp;<font color=\"#FF0000\">{{charge}} {{site_currency}}</font></div><div><br></div><div>Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div>Payable : {{method_amount}} {{method_currency}}<br></div><div>Pay via :&nbsp; {{method_name}}</div><div><br></div><div>Transaction Number : {{trx}}</div><div><br></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', '{{amount}} {{site_currency}} Deposit requested by {{method_name}}. Charge: {{charge}} . Trx: {{trx}}', '{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-03 02:29:19'),
(7, 'PASS_RESET_CODE', 'Password - Reset - Code', 'Password Reset', '<div style=\"font-family: Montserrat, sans-serif;\">We have received a request to reset the password for your account on&nbsp;<span style=\"font-weight: bolder;\">{{time}} .<br></span></div><div style=\"font-family: Montserrat, sans-serif;\">Requested From IP:&nbsp;<span style=\"font-weight: bolder;\">{{ip}}</span>&nbsp;using&nbsp;<span style=\"font-weight: bolder;\">{{browser}}</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{operating_system}}&nbsp;</span>.</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><br style=\"font-family: Montserrat, sans-serif;\"><div style=\"font-family: Montserrat, sans-serif;\"><div>Your account recovery code is:&nbsp;&nbsp;&nbsp;<font size=\"6\"><span style=\"font-weight: bolder;\">{{code}}</span></font></div><div><br></div></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><font size=\"4\" color=\"#CC0000\">If you do not wish to reset your password, please disregard this message.&nbsp;</font><br></div><div><font size=\"4\" color=\"#CC0000\"><br></font></div>', 'Your account recovery code is: {{code}}', '{\"code\":\"Verification code for password reset\",\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 0, '2021-11-03 12:00:00', '2022-03-20 20:47:05'),
(8, 'PASS_RESET_DONE', 'Password - Reset - Confirmation', 'You have reset your password', '<p style=\"font-family: Montserrat, sans-serif;\">You have successfully reset your password.</p><p style=\"font-family: Montserrat, sans-serif;\">You changed from&nbsp; IP:&nbsp;<span style=\"font-weight: bolder;\">{{ip}}</span>&nbsp;using&nbsp;<span style=\"font-weight: bolder;\">{{browser}}</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{operating_system}}&nbsp;</span>&nbsp;on&nbsp;<span style=\"font-weight: bolder;\">{{time}}</span></p><p style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></p><p style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><font color=\"#ff0000\">If you did not change that, please contact us as soon as possible.</font></span></p>', 'Your password has been changed successfully', '{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, 1, '2021-11-03 12:00:00', '2022-04-05 03:46:35'),
(9, 'ADMIN_SUPPORT_REPLY', 'Support - Reply', 'Reply Support Ticket', '<div><p><span data-mce-style=\"font-size: 11pt;\" style=\"font-size: 11pt;\"><span style=\"font-weight: bolder;\">A member from our support team has replied to the following ticket:</span></span></p><p><span style=\"font-weight: bolder;\"><span data-mce-style=\"font-size: 11pt;\" style=\"font-size: 11pt;\"><span style=\"font-weight: bolder;\"><br></span></span></span></p><p><span style=\"font-weight: bolder;\">[Ticket#{{ticket_id}}] {{ticket_subject}}<br><br>Click here to reply:&nbsp; {{link}}</span></p><p>----------------------------------------------</p><p>Here is the reply :<br></p><p>{{reply}}<br></p></div><div><br style=\"font-family: Montserrat, sans-serif;\"></div>', 'Your Ticket#{{ticket_id}} :  {{ticket_subject}} has been replied.', '{\"ticket_id\":\"ID of the support ticket\",\"ticket_subject\":\"Subject  of the support ticket\",\"reply\":\"Reply made by the admin\",\"link\":\"URL to view the support ticket\"}', 1, 1, '2021-11-03 12:00:00', '2022-03-20 20:47:51'),
(10, 'EVER_CODE', 'Verification - Email', 'Please verify your email address', '<br><div><div style=\"font-family: Montserrat, sans-serif;\">Thanks For joining us.<br></div><div style=\"font-family: Montserrat, sans-serif;\">Please use the below code to verify your email address.<br></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Your email verification code is:<font size=\"6\"><span style=\"font-weight: bolder;\">&nbsp;{{code}}</span></font></div></div>', '---', '{\"code\":\"Email verification code\"}', 1, 0, '2021-11-03 12:00:00', '2022-04-03 02:32:07'),
(11, 'SVER_CODE', 'Verification - SMS', 'Verify Your Mobile Number', '---', 'Your phone verification code is: {{code}}', '{\"code\":\"SMS Verification Code\"}', 0, 1, '2021-11-03 12:00:00', '2022-03-20 19:24:37'),
(15, 'DEFAULT', 'Default Template', '{{subject}}', '{{message}}', '{{message}}', '{\"subject\":\"Subject\",\"message\":\"Message\"}', 1, 1, '2019-09-14 13:14:22', '2021-11-04 09:38:55'),
(16, 'PLAN_SUBSCRIBE', 'Subscribed Plan', 'You\'ve subscribed successfully', '<p>You\'ve subscribed to <strong>{{plan_name}}</strong> plan. The price <strong>{{amount}} {{site_currency}}</strong>. The transaction number is #<strong>{{trx}}</strong>. Your current is<strong> {{post_balance}} {{site_currency}}</strong></p>', 'You\'ve subscribed to {{plan_name}} plan. The price {{amount}} {{site_currency}}. The transaction number is #{{trx}}. Your current is {{post_balance}} {{site_currency}}', '{\"amount\":\"Price of the plan\",\"plan_name\":\"Name of plan\",\"trx\":\"Transaction number\",\"post_balance\":\"Balance after transactions\"}', 1, 1, '2025-10-14 06:51:16', '2025-11-12 11:49:49'),
(17, 'SCHEDULE_POST', 'Schedule Post', 'Your scheduled post has been published successfully', 'Your scheduled post titled \"{{post_title}}\" has been successfully published on {{platform}} using your profile \"{{profile_name}}\" at {{publish_time}}.\r\n\r\nThank you for using our platform to manage your social posts!', 'Your scheduled post \"{{post_title}}\" has been published on {{platform}} via {{profile_name}} at {{publish_time}}.\r\n', '{\"post_title\":\"Post title\",\"platform\":\"Posted Platform\",\"profile_name\":\"Posted profile name\",\"publish_time\":\"Post publish date time\"}', 1, 1, '2025-10-14 07:02:35', '2025-10-14 07:02:35');

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

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

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

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

INSERT INTO `pages` (`id`, `name`, `slug`, `secs`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Home', '/', '[\"feature\",\"service\",\"pricing\",\"cta\",\"testimonial\",\"faq\",\"blog\"]', 1, '2020-07-11 06:23:58', '2025-10-08 04:10:52'),
(2, 'Blogs', 'blog', NULL, 1, '2020-10-22 01:14:43', '2025-07-20 06:01:31'),
(3, 'Contact', 'contact', NULL, 1, '2020-10-22 01:14:53', '2025-07-20 06:01:31'),
(4, 'Features', 'features', '[\"cta\",\"testimonial\"]', 1, '2020-10-22 01:14:43', '2025-10-08 04:12:12'),
(5, 'Pricing', 'pricing', '[\"faq\",\"testimonial\"]', 1, '2025-06-28 02:53:47', '2025-10-08 04:12:40'),
(22, 'About', 'about-us', '[\"why_us\",\"feature\",\"pricing\",\"testimonial\"]', 0, '2025-10-08 04:20:46', '2025-11-13 01:32:13');

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

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

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

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint NOT NULL,
  `groupby` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 => admin 2 => user',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `permission_roles`
--

CREATE TABLE `permission_roles` (
  `id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `permission_id` bigint NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '1 => admin 2 => user',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(28,8) DEFAULT '0.00000000',
  `connected_profile` int NOT NULL DEFAULT '0',
  `schedule_post` int NOT NULL DEFAULT '0',
  `platform_access` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contents` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 => Monthly, 2 => Yearly',
  `schedule_status` tinyint(1) NOT NULL DEFAULT '0',
  `feature_status` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint DEFAULT '1' COMMENT '0 => Disable 1 => Enable',
  `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 `plans`
--

INSERT INTO `plans` (`id`, `name`, `price`, `connected_profile`, `schedule_post`, `platform_access`, `contents`, `short_description`, `type`, `schedule_status`, `feature_status`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Agency', 59.00000000, 30, 500, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]', '[\"AI content planner\",\"White-label reporting\",\"Client workspace management\"]', 'Built for agencies managing multiple client accounts.', 2, 0, 0, 1, '2025-07-30 05:21:24', '2025-11-12 00:46:44'),
(4, 'Business', 199.00000000, 15, 1200, '[\"1\",\"2\",\"3\",\"4\",\"6\"]', '[\"AI caption generation\",\"Team collaboration tools\",\"Advanced insights\"]', 'Ideal for small businesses growing online presence.', 2, 1, 0, 1, '2025-07-30 05:22:15', '2025-11-12 00:57:15'),
(5, 'Pro', 25.00000000, 8, 300, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]', '[\"AI-assisted post suggestions\",\"Bulk upload scheduler\"]', 'Designed for professionals managing multiple brands.', 1, 1, 0, 1, '2025-10-03 11:11:07', '2025-11-13 06:18:45'),
(6, 'Starter', 9.00000000, 3, 60, '[\"1\",\"2\",\"4\",\"5\"]', '[\"Basic analytics dashboard\",\"Manual post scheduling\",\"Email support\"]', 'Perfect for individuals starting social media management.', 1, 0, 0, 1, '2025-10-06 01:12:01', '2025-11-12 11:24:15'),
(7, 'Enterprise', 499.00000000, 40, 15000, '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]', '[\"Dedicated AI content strategist\",\"Custom API access\",\"24\\/7 premium support\"]', 'Enterprise-grade solution with full automation and analytics.', 2, 1, 0, 0, '2025-10-21 23:53:17', '2025-12-08 03:14:49');

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

--
-- Table structure for table `platforms`
--

CREATE TABLE `platforms` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint 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 `platforms`
--

INSERT INTO `platforms` (`id`, `name`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Facebook', '68e772e96075f1759998697.png', 1, '2025-01-28 09:37:34', '2025-12-06 03:14:53'),
(2, 'Instagram', '68e772f253cc91759998706.png', 1, '2025-01-28 09:37:34', '2025-10-09 02:31:46'),
(3, 'Linkedin', '68e772faa30c31759998714.png', 1, '2025-01-28 09:37:34', '2025-10-09 02:31:54'),
(4, 'Twitter', '68e7730186ff01759998721.png', 1, '2025-01-28 09:37:34', '2025-10-09 02:32:01'),
(5, 'Tiktok', '68e79e7356eef1760009843.png', 1, '2025-01-28 09:37:34', '2025-10-09 05:37:23'),
(6, 'Youtube', '68e79f9a1000c1760010138.png', 1, '2025-01-28 09:37:34', '2025-10-09 05:42:18');

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

--
-- Table structure for table `plugins`
--

CREATE TABLE `plugins` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `script` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `shortcode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'object',
  `support` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'help section',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>enable, 2=>disable',
  `deleted_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `plugins`
--

INSERT INTO `plugins` (`id`, `act`, `name`, `description`, `image`, `script`, `shortcode`, `support`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'tawk-chat', 'Live Chat(Tawk.to)', 'Key location is shown bellow', 'chat-png.png', '<script>\n                        var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\n                        (function(){\n                        var s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\n                        s1.async=true;\n                        s1.src=\"https://embed.tawk.to/{{app_key}}\";\n                        s1.charset=\"UTF-8\";\n                        s1.setAttribute(\"crossorigin\",\"*\");\n                        s0.parentNode.insertBefore(s1,s0);\n                        })();\n                    </script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"dddddddddddd\"}}', 'twak.png', 0, NULL, '2019-10-18 23:16:05', '2025-08-24 00:56:53'),
(2, 'google-recaptcha2', 'Google Recaptcha 2', 'Key location is shown bellow', 'recaptcha2.png', '\n<script src=\"https://www.google.com/recaptcha/api.js\"></script>\n<div class=\"g-recaptcha\" data-sitekey=\"{{site_key}}\" data-callback=\"verifyCaptcha\"></div>\n<div id=\"g-recaptcha-error\"></div>', '{\"site_key\":{\"title\":\"Site Key\",\"value\":\"6LdPC88fAAAAADQlUf_DV6Hrvgm-pZuLJFSLDOWV\"},\"secret_key\":{\"title\":\"Secret Key\",\"value\":\"6LdPC88fAAAAAG5SVaRYDnV2NpCrptLg2XLYKRKB\"}}', 'recaptcha.png', 0, NULL, '2019-10-18 23:16:05', '2025-07-01 23:58:26'),
(3, 'google-analytics', 'Google Analytics', 'Key location is shown bellow', 'google_analytics.png', '<script async src=\"https://www.googletagmanager.com/gtag/js?id={{app_key}}\"></script>\r\n                <script>\r\n                  window.dataLayer = window.dataLayer || [];\r\n                  function gtag(){dataLayer.push(arguments);}\r\n                  gtag(\"js\", new Date());\r\n                \r\n                  gtag(\"config\", \"{{app_key}}\");\r\n                </script>', '{\"app_key\":{\"title\":\"App Key\",\"value\":\"G-JGB5GZ3G69\"}}', 'ganalytics.png', 0, '2025-07-20 19:47:55', '2025-07-20 13:47:55', '2025-08-12 05:22:56');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int NOT NULL,
  `user_id` bigint NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_schedule` tinyint(1) NOT NULL DEFAULT '0',
  `schedule_time` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 => Draft, 1 => Published, 2 => Schedule',
  `publish_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `post_media`
--

CREATE TABLE `post_media` (
  `id` bigint NOT NULL,
  `post_id` bigint NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '1 => Image, 2 => Video',
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `post_social_account`
--

CREATE TABLE `post_social_account` (
  `id` bigint NOT NULL,
  `post_id` bigint NOT NULL,
  `social_account_id` bigint NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `post_social_account`
--

INSERT INTO `post_social_account` (`id`, `post_id`, `social_account_id`, `status`, `message`, `created_at`, `updated_at`) VALUES
(1, 45, 1, 0, NULL, '2025-12-06 06:49:25', '2025-12-06 06:49:25'),
(2, 45, 2, 0, NULL, '2025-12-06 06:49:25', '2025-12-06 06:49:25'),
(3, 45, 8, 0, NULL, '2025-12-06 06:50:25', '2025-12-06 06:50:25'),
(4, 45, 7, 0, NULL, '2025-12-06 06:51:34', '2025-12-06 06:51:34'),
(5, 45, 6, 0, NULL, '2025-12-06 06:52:14', '2025-12-06 06:52:14'),
(6, 45, 5, 0, NULL, '2025-12-06 06:52:40', '2025-12-06 06:52:40'),
(7, 46, 1, 1, NULL, '2025-12-06 03:54:26', '2025-12-06 03:54:26'),
(8, 46, 2, 1, NULL, '2025-12-06 03:54:26', '2025-12-06 03:54:26'),
(12, 46, 3, 0, NULL, '2025-12-08 04:33:30', '2025-12-08 04:33:30'),
(18, 48, 1, 0, NULL, '2025-12-08 05:14:42', '2025-12-08 05:14:42'),
(19, 48, 2, 0, NULL, '2025-12-08 05:14:42', '2025-12-08 05:14:42'),
(20, 48, 3, 0, NULL, '2025-12-08 05:14:42', '2025-12-08 05:14:42'),
(21, 49, 3, 0, NULL, '2025-12-08 05:50:14', '2025-12-08 05:50:14'),
(22, 49, 8, 0, NULL, '2025-12-08 05:50:14', '2025-12-08 05:50:14');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 => admin, 2 => user',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 => enable, 0 => disable',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `user_id`, `name`, `type`, `status`, `created_at`, `updated_at`) VALUES
(2, 0, 'Contributor', 1, 1, '2025-07-05 05:21:11', '2025-07-24 05:08:37'),
(3, 0, 'Editor', 1, 1, '2025-07-05 05:22:34', '2025-07-24 05:08:13'),
(4, 0, 'Member', 1, 1, '2025-07-07 00:16:17', '2025-07-24 05:08:03'),
(8, 0, 'Moderator', 1, 0, '2025-07-07 01:49:59', '2025-08-23 01:42:32');

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

--
-- Table structure for table `social_accounts`
--

CREATE TABLE `social_accounts` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `platform_id` bigint NOT NULL,
  `meta_profile_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `profile_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `profile_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `access_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `refresh_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `expired_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL COMMENT '1 => Yes, 0 => No',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `social_accounts`
--

INSERT INTO `social_accounts` (`id`, `user_id`, `platform_id`, `meta_profile_id`, `profile_name`, `profile_image`, `access_token`, `refresh_token`, `expired_at`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '541640325706372', 'Post Flow Test', 'https://graph.facebook.com/541640325706372/picture?width=200&height=200', 'EAALR9UdO5eYBPZClNyZBuEol1J1MSxZCI71uID8QsZCpDezZCvMEK5xZBZCTXz9C8vkbrYgjAtRkyUg3mkZAwVplW0VxZA5dJTyTW0xAjmOhjNZA73cBxkRb2jc2wftCecO25fhIZBqIMIQdA4rON3BoELANbOVpKGEanqbczCwny3mmzZCrCWjGDAVZCKFTZC1u8caZCZCKobcv', NULL, '2025-12-12 12:14:05', 1, '2025-11-12 12:14:05', '2025-11-12 12:14:05'),
(2, 1, 2, '17841465961046513', 'rakibulhasan2944', NULL, 'EAALR9UdO5eYBP1If0aS0LR7mpuXHC3m03N7rShl9H5AKtZB4xLtlFXO3bY0XqG6Bu8goOhRvzlvq1ZA1jgBvZBNsouiGAOZA9JllcnStvKPUl0KHKZAaM99ZCXN07fscgD3f8ZBSmIdyrke7U3swZC38HlmvuZAFHu81ajoTTNXwZB3YpIhkFar1ICy1SoCzhbjtdII18a', NULL, '2026-01-11 12:14:05', 1, '2025-11-12 12:14:05', '2025-11-12 12:14:05'),
(3, 1, 3, 'hBKq4Cqct_', 'Rayhan Kobir', 'https://media.licdn.com/dms/image/v2/D4E03AQGrKDLmYyfBRg/profile-displayphoto-shrink_100_100/profile-displayphoto-shrink_100_100/0/1725440701579?e=1764806400&v=beta&t=HCobhOVcLrGB5uiw7xL6hYDRBkbX2boM4SFyjcccBfs', 'AQU2SSCbupN5ebS2KyWBX5178KwWBDmsrFy4l6w-ODUUrb51sJuXrnrLXyyoK2B2JpXdVRD7oG-BAajkwlNJK-nrM8JWqhuGt8Jm4ku7knhfwe4DayDkZWHtNudpiTlGhLDWcf5FxfYOZf9wWO_3mi_ZbFIfKpP7zubw_MPCE1KpDY5hKdncT7I1foXRBORJRjc2vgBC6dExjzgXfe47S2j7ArkOlHZdnkEf6h-AS_aOy8RPf9mVvKP3AVg6dfwbopro4BeNLoa5UiY2abXSsUOtct1ojJaYD_UwKwK3uafg4C5mL1sC8PwX3Z6omndc12snuaRokleaCfGhvJLt35U0CQLxXbIP0_LTflPfvT9MjoHfQOLvX9RrcMKnrfCphLg1WkLRWZipx8GD8Us', 'AQV1gNPlUW4zu9AwjqkZm-wu-fPjXBMHblnMrWu-s-pe5Pqrsl-lBa4hyhUbELUX9eFwZQFGoZMrNTkSSPqhI8WA7hVWhkIheaQMVkoXygRZjnHHrn3c9C7rL1hG8joApy5Ia-y7zUytzGbKxJWOvuf__FJXDryK13nKM5sFdUMgSERcMlXtxARk5sH1X5L1dcOYm-uB9fxErIwH1p25JhSSLLQiGZpBWBPJ7_B-wikSyRZUZ8crF2p0rkRG4fhuWTfRKGph0DF9gw12AFzO_gVxYJcZTGL_voHMh9oG1k3LHDcSPyj1rQoiMbmU9ev_DuHHpN01wW2wIP-laOt-EKl0sR5NOg', '2026-01-13 10:12:01', 1, '2025-11-12 12:17:02', '2025-11-14 10:12:02'),
(4, 1, 6, '114121113050121142940', 'Md. Rajib Hossain', 'https://lh3.googleusercontent.com/a/ACg8ocLSRWeN4yCvznxyTgaxpaXuM78mP4tO528Srj80fH5JWk4TJw=s96-c', 'ya29.a0ATi6K2s-G-Ypy11ToFGHjutTFUAEhjPfwdA2cOFWlwBKzhra8FupJLh54SUnG-8S_Qtj5p0ECU8Zjayz7nXKl2S-vSJU2gZKPWwrzS2jnh7zaBzlZaYtK9hjg6GYeYur5wVQlPrW8lXG5Wh5Jp0otAlo5CORbMn-_4REe_cRi-UA62ZlgiNDjr-KC8bBmVSD5zLYnW6yaCgYKAR0SARcSFQHGX2MiLyi2vUNDdW5FFG1YyjOeDA0207', '1//04ncROpSpkKluCgYIARAAGAQSNwF-L9IrlBngmi9qjGGK8hIVxl2jSZhotlFhvg8uIFQb01eHZiZsYtRpo6jQEg8_eWMZRzMfME4', '2025-11-14 09:29:01', 0, '2025-11-12 12:18:33', '2025-11-14 09:29:01'),
(5, 1, 5, '-0001Q3MGsTN4OnwEPUXlhg_fvmgdZYszun3', 'rajibdev771', 'https://p16-sign-sg.tiktokcdn.com/tos-alisg-avt-0068/86a93e13253d99afc43c583aaa930199~tplv-tiktokx-cropcenter:1080:1080.jpeg?dr=14579&refresh_token=f43a5df6&x-expires=1763121600&x-signature=6Qz91SQ5PkLyDyyLi2VOb14G9WM%3D&t=4d5b0474&ps=13740610&shp=a5d48078&shcp=8aecc5ac&idc=maliva', 'act.UibQgQgmqPJUgMMzDlS5CuoyJ6QchlD4PVVIzKIpKWSNs9oSJ0XYCwZGojD1!4472.va', 'rft.IBMOuA5wf9XRdcbr9NVUlWsPaZNZnz3G1P3kZxH2PUSy480xwNl4mF2ozCqB!4526.va', '2025-11-14 09:29:01', 0, '2025-11-12 12:22:25', '2025-11-14 09:29:01'),
(6, 1, 4, '1881264555458019328', 'Md. Rajib Hossain', 'https://pbs.twimg.com/profile_images/1881264632750604288/6FRusu0u_normal.png', 'cnFSTEtlSFNlV0ZOV1hTd2pYQzRZYkliR2RpYi11cGotSUtVVi1USnlkdjlSOjE3NjA5MzIwNzcwNTQ6MToxOmF0OjE', 'NDRqb0lMYWx2c2NoOThfcnhGMm5tZjNYUnYxdjROeDZhQUJoa05GU0lsYXNkOjE3NjA5MzIwNzcwNTQ6MTowOnJ0OjE', '2025-11-13 06:07:01', 0, '2025-11-13 12:04:57', '2025-11-13 06:07:01'),
(7, 1, 6, '100548805805766252632', 'Md. Rajib Hossain', 'https://lh3.googleusercontent.com/a/ACg8ocJndHdyNqyr5xzadiIMzS2rZqAwSoR-au8d5mGYC3tRoOklwtwk=s96-c', 'ya29.a0ATi6K2tJl1i7uuISEvn0QOjVR65rQpJI-nvQcaklZSN9clj-JqG5dQ19Unrieu6LJ6pk5Bm256RDyB1FvtWbq3WbdC62aiky8kjGII98Nt3Pwiuxt-hEdH1QcTnUh0uKjOhAd4d-H1hE626Ui9W1J0ueIYsDlJs9oozyO7EezIv0gRojjeDNe7xdROiRG1lGXeBeiyWSaCgYKAd4SARYSFQHGX2MiyiE9NW_D6Ow9hTMxN5QvQQ0207', '1//04v3rWcwOFVBkCgYIARAAGAQSNwF-L9IrApifeEv4G4rBucvsqNnxD0TWTLS1H6UuexGwdMVtCxidOYqbD8UBnaFWbXUgFKGVY5k', '2025-11-21 09:18:02', 0, '2025-11-14 09:17:31', '2025-11-21 09:18:02'),
(8, 1, 3, 'p_Q9pi3OZZ', 'Md. Rajib Hossain', 'https://media.licdn.com/dms/image/v2/C5603AQEQdiXxKjBTJw/profile-displayphoto-shrink_100_100/profile-displayphoto-shrink_100_100/0/1663121523782?e=1764806400&v=beta&t=V6dY1gZ8W-4FR3-7bty7nethym8QeyICR0R359rz24U', 'AQUS6E1lYCWdLLP0v1Xf84helfqV3aJZAT2ZQ3AVFnoF6fL_8xVybjigT_8CzNIgmeoIriqwRLwK6eiiOxH8RIbEZ61jKd0Q4kp62XiwfS6jANaQz2v9T98YOMvCUPdvEhOw-d_nuSiSc7IVn9E0LunQ1q2BjuJ0z1eFtc7brPtfC7Eb4EaroZRSnaXrlW3Xm7_N-A3fIgKbnNa1_HUzqUDQQ3zOiPZcWBM5PVMN1zCvS11hYmABl1N0csrxG1p6j5ihc0ojRFsX6orKkJY4n0b-6iKHPGeW1qbm8lUJCZ2eRlB4SVf1cwOf4XsaLpkFGbe50L5UcLope6xd5dJld1jD581mhg', NULL, '2026-01-13 10:13:02', 1, '2025-11-14 10:13:03', '2025-11-14 10:13:03'),
(9, 1, 5, '-000V36zTVupuqwJ6-SJREWDgEhWPhR_qWzD', 'rajibraju7711', 'https://p16-sign-va.tiktokcdn.com/musically-maliva-obj/1594805258216454~tplv-tiktokx-cropcenter:1080:1080.jpeg?dr=14579&refresh_token=8db56b28&x-expires=1763301600&x-signature=QP3tcQPqe%2FlNHA3Rv1QwZDrjyiY%3D&t=4d5b0474&ps=13740610&shp=a5d48078&shcp=8aecc5ac&idc=maliva', 'act.6jFWtf8JIBNLbUFDRUCOWKj0WjU6aJm6qiI8XgypahzVUvb5uGmRa3nYvxD0!4469.va', 'rft.WEjBJDFdIrERXbM0Q1NB1kIyS13yA4Zy0ZyYQYjHzjsSpjnH0VyysWCciD3I!4497.va', '2025-11-29 12:21:03', 1, '2025-11-14 14:04:00', '2025-11-28 12:21:03');

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

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

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

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

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

CREATE TABLE `subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `plan_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0 => Expired, 1 => Running',
  `expired_at` timestamp NULL DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

CREATE TABLE `support_tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int DEFAULT '0',
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticket` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed',
  `priority` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Low, 2 = medium, 3 = heigh',
  `last_reply` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transactions`
--

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

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `firstname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `country_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ref_by` int UNSIGNED NOT NULL DEFAULT '0',
  `balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'contains full address',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: banned, 1: active',
  `kyc_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `kv` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: KYC Unverified, 2: KYC pending, 1: KYC verified',
  `ev` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: email unverified, 1: email verified',
  `sv` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: mobile unverified, 1: mobile verified',
  `reg_step` tinyint(1) NOT NULL DEFAULT '0',
  `ver_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'stores verification code',
  `ver_code_send_at` datetime DEFAULT NULL COMMENT 'verification send time',
  `ts` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: 2fa off, 1: 2fa on',
  `tv` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: 2fa unverified, 1: 2fa verified',
  `tsc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ban_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remember_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `plan_id` bigint DEFAULT '0',
  `connected_profile` tinyint(1) NOT NULL DEFAULT '0',
  `post_count` int NOT NULL DEFAULT '0',
  `free_plan_used` tinyint(1) NOT NULL DEFAULT '0',
  `schedule_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 => Yes, 0 => No',
  `started_at` timestamp NULL DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `content_credit` 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_general_ci;

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

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

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

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

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

CREATE TABLE `user_notifications` (
  `id` int NOT NULL,
  `user_id` bigint NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 => Yes, 0 => No',
  `click_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_slug_unique` (`code`);

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

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

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

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

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

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

--
-- Indexes for table `platforms`
--
ALTER TABLE `platforms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `social_platforms_name_index` (`name`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `menu_menu_items`
--
ALTER TABLE `menu_menu_items`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `post_social_account`
--
ALTER TABLE `post_social_account`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `social_accounts`
--
ALTER TABLE `social_accounts`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `user_notifications`
--
ALTER TABLE `user_notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;