-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 20, 2024 at 02:24 PM
-- Server version: 10.11.10-MariaDB-ubu2204
-- PHP Version: 8.2.26

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 */;

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `action` varchar(250) NOT NULL,
  `details` varchar(250) NOT NULL,
  `additional` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'General'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Learn'),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Earn'),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Company');

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

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `comment` text NOT NULL,
  `post_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_comments`
--

INSERT INTO `blog_comments` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `comment`, `post_id`, `status`) VALUES
(1, '2024-12-06 13:00:00', 2, '192.168.1.1', '2024-12-06 13:00:00', 2, '192.168.1.1', 'These tips will definitely save me from making costly mistakes when choosing my next file hosting platform. Thanks for sharing!', 2, 1),
(2, '2024-12-09 13:00:00', 2, '192.168.1.1', '2024-12-09 13:00:00', 2, '192.168.1.1', 'This post really highlights everything I look for in a file hosting platform!', 5, 1),
(3, '2024-12-08 13:00:00', 2, '192.168.1.1', '2024-12-08 13:00:00', 2, '192.168.1.1', 'Cloud storage always seemed complicated to me, but this article simplifies everything!', 4, 1),
(4, '2024-12-07 13:00:00', 2, '192.168.1.1', '2024-12-07 13:00:00', 2, '192.168.1.1', 'Thanks for breaking it down so clearly—time to give it a shot.', 3, 1),
(5, '2024-12-11 13:00:00', 2, '192.168.1.1', '2024-12-11 13:00:00', 2, '192.168.1.1', 'I’ve been looking for a reliable affiliate program like this. Excited to sign up and get started!', 7, 1),
(6, '2024-12-05 13:00:00', 2, '192.168.1.1', '2024-12-05 13:00:00', 2, '192.168.1.1', 'Such an important topic! Secure file sharing keeps both personal and business data safe.', 1, 0),
(7, '2024-12-10 13:00:00', 2, '192.168.1.1', '2024-12-10 13:00:00', 2, '192.168.1.1', 'Speed and reliability are key when it comes to file hosting, and it’s great to see a platform that delivers both.', 6, 1);

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `featured_photo` varchar(250) DEFAULT NULL,
  `content` text NOT NULL,
  `category` int(11) NOT NULL,
  `seo` text NOT NULL,
  `pageview` int(11) DEFAULT 0,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `title`, `slug`, `featured_photo`, `content`, `category`, `seo`, `pageview`, `status`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Why Secure File Sharing Important', 'why-secure-file-sharing-important-cxhf6i', 'blog_featured_2i0qFoQMNe2RQ6dEM9X6Q9SQ.webp', '<p>In a world that is increasingly reliant on digital communication and data sharing, the importance of secure file sharing cannot be overstated. Whether you’re a business professional handling sensitive documents, a student collaborating on group projects, or an individual sharing personal files, ensuring the security of your data is critical. But why exactly is secure file sharing so important? Let’s explore the risks of unsecured file sharing and why investing in secure solutions is essential.</p><h4>1. The Risks of Unsecured File Sharing</h4><p>When files are shared without proper security measures, the risks can be significant:</p><p><strong>Data Breaches:</strong> Sensitive information such as financial records, personal identification, or proprietary business data can be exposed during transmission. Hackers can exploit vulnerabilities in unsecured systems to steal or manipulate this information.</p><p><strong>Unintended Access:</strong> Sharing files through public links or platforms with insufficient access controls can lead to unauthorized parties viewing, editing, or downloading your data.</p><p><strong>Malware and Viruses:</strong> Files shared via unverified or insecure methods can carry malicious software, infecting the recipient\'s device and causing damage or data loss.</p><p><strong>Loss of Trust:</strong> If clients, partners, or colleagues discover that their data has been compromised due to lax security practices, it can harm your reputation and professional relationships.</p><h4>2. Why Secure File Sharing Is Crucial</h4><p>Secure file sharing is not just about protecting files from hackers; it’s about maintaining trust, avoiding legal complications, and ensuring smooth workflows.</p><p><strong>Protects Sensitive Data: </strong>Secure file-sharing platforms encrypt your files, ensuring that only the intended recipient can access them. This prevents unauthorized access and protects data integrity during transmission.</p><p><strong>Builds Trust: </strong>Whether you\'re sharing files with clients, partners, or team members, secure file sharing demonstrates that you value their privacy and data security. This fosters trust and enhances professional relationships.</p><p><strong>Enhances Collaboration: </strong>With secure file sharing, teams can collaborate confidently, knowing that their shared documents and data are protected from unauthorized access.</p><h4>Conclusion</h4><p>In today’s interconnected world, secure file sharing is no longer optional—it’s a necessity. Protecting sensitive data, ensuring compliance, and maintaining trust are just a few reasons why secure file sharing should be a top priority. By choosing the right tools and following best practices, you can safely share files and enjoy peace of mind.</p>', 2, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(2, '2024-12-06 12:00:00', 1, '192.168.1.1', '2024-12-06 12:00:00', 1, '192.168.1.1', 'Common Mistakes When Picking a File Host', 'common-mistakes-when-picking-a-file-host-cxg5qg', 'blog_featured_gdTZPK5ToizERIPAoB7dNo6b.webp', '<p>When it comes to choosing a file hosting provider, the decision is not as simple as it seems. With so many options available, selecting the right service can be daunting. A reliable file host is crucial for storing, sharing, and managing your data effectively, but making the wrong choice can lead to frustrations, inefficiencies, and even data loss. To help you avoid pitfalls, here are some common mistakes people make when picking a file host—and how to steer clear of them.</p><h4>1. Overlooking Storage Limits</h4><p>Many users jump into a hosting service without fully understanding its storage capacity. Free plans may look enticing, but they often come with strict storage limits. Failing to evaluate your current and future needs can leave you scrambling to upgrade or switch providers when you outgrow the plan.</p><p><strong>Tip:</strong><br>Always consider the scalability of the storage plan. Choose a host that offers flexible options to expand as your needs grow.</p><h4>2. Ignoring Upload and Download Speeds</h4><p>Speed is a critical factor, especially if you’re working with large files. Slow upload or download speeds can significantly impact your workflow, leading to delays and frustration.</p><p><strong>Tip:</strong><br>Look for a file host that guarantees fast and reliable data transfers, even during peak times. Check user reviews or conduct speed tests before committing.</p><h4>3. Overlooking Security Measures</h4><p>One of the biggest mistakes is not prioritizing security. Your files may contain sensitive or private data, and a weak hosting provider can leave you vulnerable to breaches or cyberattacks.</p><p><strong>Tip:</strong><br>Ensure the host offers robust security features such as SSL encryption, password-protected sharing, and compliance with privacy regulations like GDPR.</p><h4>4. Neglecting Customer Support</h4><p>When something goes wrong, having access to reliable customer support can make all the difference. Many users overlook this aspect and find themselves stuck when issues arise.</p><p><strong>Tip:</strong><br>Opt for a host with 24/7 support, multiple contact options (chat, email, phone), and a helpful knowledge base.</p><h4>5. Not Reading User Reviews</h4><p>Skipping the research phase is another common mistake. A provider might seem perfect on paper, but real-world experiences from users can reveal potential red flags.</p><p><strong>Tip:</strong><br>Take the time to read reviews and testimonials from users with similar needs to yours. Look for feedback on speed, reliability, and customer service.</p><h4>Conclusion</h4><p>Choosing the right file hosting provider is critical to ensuring smooth and secure file storage and sharing. By avoiding these common mistakes, you can select a service that fits your needs, provides peace of mind, and grows with you over time.</p>', 1, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(3, '2024-12-07 12:00:00', 1, '192.168.1.1', '2024-12-07 12:00:00', 1, '192.168.1.1', 'Benefits of Using Cloud File Sharing System', 'benefits-of-using-cloud-file-sharing-system-ilsr3w', 'blog_featured_fYQA3nSCGvQ4HSsHmPb4fY13.webp', '<p>In today’s fast-paced digital world, managing and sharing files efficiently has become a top priority for individuals and businesses alike. Gone are the days when USB drives and email attachments were the primary methods of sharing documents. With the rise of cloud file-sharing systems, file storage and sharing have reached a whole new level of convenience, accessibility, and security. Let’s explore the key benefits of using a cloud file-sharing system and why it’s an essential tool for modern users.</p><h4>1. Access Files Anytime, Anywhere</h4><p>One of the biggest advantages of cloud file-sharing systems is accessibility. Whether you’re working from the office, at home, or halfway around the world, you can easily access your files from any device with an internet connection. Cloud storage eliminates the need to carry physical storage devices, ensuring that your important files are always at your fingertips.</p><h4>2. Enhanced Collaboration</h4><p>Cloud file-sharing systems are designed with collaboration in mind. Teams can work on the same files simultaneously, with real-time updates ensuring everyone stays on the same page. You can share files with colleagues, clients, or collaborators with just a few clicks, making it easy to streamline workflows and improve productivity.</p><h4>3. Improved Security</h4><p>Data security is a major concern when it comes to sharing files. Cloud file-sharing systems use advanced encryption and authentication protocols to protect your data from unauthorized access. Many services also offer customizable sharing permissions, allowing you to control who can view, edit, or download your files.</p><h4>4. Cost-Effective Solution</h4><p>Using a cloud file-sharing system can save you money in the long run. There’s no need to invest in expensive hardware or physical storage devices. Many cloud providers offer flexible pricing plans, allowing you to pay only for the storage you need. Plus, the improved efficiency and reduced downtime translate into significant cost savings for businesses.</p><h4>Conclusion</h4><p>The benefits of cloud file-sharing systems are undeniable. From improved accessibility and collaboration to enhanced security and cost savings, it’s the ultimate solution for modern file management. Don’t miss out on the convenience and efficiency of cloud storage—join us today and experience the future of file sharing!</p>', 2, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(4, '2024-12-08 12:00:00', 1, '192.168.1.1', '2024-12-08 12:00:00', 1, '192.168.1.1', 'What is Cloud Storage and How Does It Work', 'what-is-cloud-storage-and-how-does-it-work-ecazsc', 'blog_featured_fVUSNpT1YkPY2LD2iuYc5rh1.webp', '<p>Cloud storage is a service that allows you to save your files and data on remote servers instead of your local device. These servers are managed by third-party companies, which maintain and protect the stored data. Think of it as a virtual hard drive that you can access from anywhere with an internet connection.</p><p>Instead of relying on traditional storage devices like external hard drives or USB sticks, cloud storage provides a flexible and scalable solution. Whether you need to store personal files, collaborate with a team, or back up critical business data, cloud storage offers a seamless way to keep your files safe and accessible.</p><p>The concept of cloud storage is simple but relies on advanced technology. Here\'s how it works step-by-step:</p><h4>Step 1: Data Upload</h4><p>When you upload a file to a cloud storage service, the file is sent to a remote server using the internet. These servers are often located in data centers distributed across multiple locations.</p><h4>Step 2: Storage on Remote Servers</h4><p>Once uploaded, your data is stored on the provider’s servers. To ensure data security and redundancy, most cloud providers replicate the data across multiple servers in different locations. This means that even if one server goes down, your data remains safe and accessible from another.</p><h4>Step 3: Data Encryption</h4><p>Security is a top priority for cloud storage providers. Your files are encrypted during upload and while stored on the servers, ensuring that only you and authorized users can access the data.</p><h4>Step 4: Access Anywhere, Anytime</h4><p>Once stored, your files can be accessed from any device with an internet connection, such as a smartphone, tablet, or computer. Many cloud storage services also offer apps or software for easy file management.</p><h4>Step 5: Collaboration Features</h4><p>Most modern cloud storage platforms include collaboration tools, allowing multiple users to view, edit, or share files in real-time. This is especially beneficial for businesses and teams working on projects remotely.</p><h4>Conclusion</h4><p>Cloud storage is the future of file hosting. It’s convenient, secure, and designed to make your life easier. Whether you’re looking to back up your personal files, share documents with a team, or manage large-scale business data, Portus has the tools you need.</p><p>Sign up today and experience the benefits of fast, reliable, and secure cloud storage!</p>', 2, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(5, '2024-12-09 12:00:00', 1, '192.168.1.1', '2024-12-09 12:00:00', 1, '192.168.1.1', 'Why You Should Choose Us for File Hosting', 'why-you-should-choose-us-for-file-hosting-tv4pbp', 'blog_featured_HrkXKshucUJQO5RSicPo9mwF.webp', '<p>In a world where digital files are central to everyday life, choosing the right file hosting service is more important than ever. Whether you\'re storing documents, photos, videos, or other essential files, your hosting platform should be reliable, secure, and easy to use.</p><p>We’ve designed our platform to meet all your needs and more. Here\'s why we’re the right choice for your file hosting requirements.</p><p><strong>Blazing-Fast Uploads and Downloads</strong><br>Time is money, and we don’t believe in wasting yours. Our platform is optimized for high-speed uploads and downloads, ensuring you can manage your files without delays. Whether you\'re sharing large video files with a client or downloading important documents, you’ll enjoy lightning-fast performance every time.</p><p><strong>Secure File Storage You Can Trust</strong><br>Security is one of our top priorities. We use cutting-edge encryption and state-of-the-art data centers to protect your files from unauthorized access. With our platform, your data stays private, giving you peace of mind whether you’re storing personal photos or sensitive business documents.</p><p><strong>Simple and Intuitive Interface</strong><br>Technology should make life easier, not more complicated. That’s why we’ve created a user-friendly interface that anyone can navigate.</p><p><strong>Seamless File Sharing Options</strong><br>Sharing files has never been easier. With our platform, you can share files instantly through direct links or password-protected access. Whether you’re collaborating with a team or sending files to friends, our sharing options are quick and convenient.</p><p><strong>Flexible Plans for Every Need</strong><br>We understand that different users have different needs. That’s why we offer a range of hosting plans, from free accounts with basic features to premium plans with expanded storage and advanced tools. Whether you’re an individual user or a business, we have a plan that fits you perfectly.</p><p><strong>Dedicated Customer Support</strong><br>Have questions or run into an issue? Our dedicated support team is here to help. We pride ourselves on providing fast and friendly assistance whenever you need it.</p><h4>Conclusion</h4><p>Join the countless users who trust us for their file hosting needs and experience the difference for yourself. Sign up today and discover why we’re the best file hosting solution for you!</p>', 4, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(6, '2024-12-10 12:00:00', 1, '192.168.1.1', '2024-12-10 12:00:00', 1, '192.168.1.1', 'Fast and Reliable File Hosting for Everyone', 'fast-and-reliable-file-hosting-for-everyone-jzhmaq', 'blog_featured_GRaGdvQT40EGVZaXOf44zDwp.webp', '<p>In today\'s digital age, the demand for efficient file storage and sharing is higher than ever. Whether you\'re a business owner managing projects, a student collaborating on assignments, or simply someone looking for a reliable way to store your personal files, fast and dependable file hosting is a must.</p><p>So, what makes us the go-to platform for fast and reliable file hosting? Here are some of the top reasons:</p><p><strong>1. High-Speed Uploads and Downloads</strong><br>Say goodbye to delays. Our platform is built with advanced infrastructure to ensure lightning-fast upload and download speeds, even for large files.</p><p><strong>2. Reliable Performance</strong><br>Our servers are optimized to ensure your files are always accessible, whenever you need them. With a 99.9% uptime guarantee, you can count on us to keep your data available at all times.</p><p><strong>3. Secure Hosting</strong><br>Protect your content with our robust security measures, ensuring your files remain safe and accessible only to those you choose.</p><p><strong>4. User-Friendly Interface</strong><br>We make file hosting simple for everyone. With an intuitive interface, you can easily upload and share your files in just a few clicks—no technical expertise required.</p><h4>How to Get Started with Portus</h4><p>Getting started with Portus is easy! Simply create a free account, start uploading your files, and experience the speed and reliability firsthand. You’ll have access to unlimited storage and advanced tools to help you manage and share your content effortlessly.</p><p>Sign up today and experience hassle-free file hosting like never before. Your files, your way—always accessible, always secure.</p><h4>Conclusion</h4><p>Don’t let slow loading times or unreliable hosting hold you back. Whether you\'re a business owner managing projects, or simply someone looking for a reliable way to store your personal files, Portus is here to deliver the fast and reliable hosting you deserve.</p>', 4, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1),
(7, '2024-12-11 12:00:00', 1, '192.168.1.1', '2024-12-11 12:00:00', 1, '192.168.1.1', 'Boost Your Earnings with Our Affiliate Program', 'boost-your-earnings-with-our-affiliate-program-p00zk6', 'blog_featured_dUme1zYqRr2njYtR5UjglE7C.webp', '<p>In today’s fast-paced digital world, everyone is looking for new ways to increase their income while leveraging the power of the internet. Whether you\'re a content creator, marketer, or just someone with a knack for promoting great services, an affiliate program can be a perfect opportunity to turn your efforts into real earnings.</p><h4>How Does It Work?</h4><p>Getting started with our affiliate program is quick and simple. Here’s how it works:</p><p><strong>Sign Up</strong><br>Register for our Affiliate Program by creating an account on the website. Once approved, you\'ll receive a unique affiliate link to share with your audience.</p><p><strong>Refer Your Audience</strong><br>Share your referral link with your audience via social media, blogs, email newsletters, or even personal conversations. Highlight the features and benefits of our file hosting service to attract users.</p><p><strong>Earn Commissions</strong><br>You will earn a commission for every person who clicks on your link. The more you promote, the higher your potential earnings!</p><h4>Ready to Get Started?</h4><p>It’s never been easier to turn your online influence into a reliable income stream. By joining our Affiliate Program, you’ll be helping others discover our power while earning commissions along the way.</p><p>Don’t miss out on this fantastic opportunity to boost your earnings. Sign up for the our Affiliate Program today and start sharing your link with the world!</p><h4>Conclusion</h4><p>Whether you\'re looking for a side income or want to build a full-time affiliate business, our Affiliate Program provides the tools and opportunities you need to succeed. With generous commissions, easy tracking, and a platform that practically promotes itself, there\'s no reason not to get started.</p><p>Join the our Affiliate Program now, and start earning with every referral you make. The more you share, the more you can earn—it\'s that simple!</p>', 3, '{\"keywords\":null,\"description\":null,\"no_index\":\"1\",\"og_title\":null,\"og_description\":null,\"og_image\":null}', 0, 1);

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email_contents`
--

CREATE TABLE `email_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `variables` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_contents`
--

INSERT INTO `email_contents` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `content`, `variables`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'welcome_email', '<p>Hello {email};</p>\r\n<p>Thank you for registering on our website.</p>\r\n<p>IP address of the device that create account is {ip}</p>\r\n<p><a href=\"{verifylink}\">Click here to confirm your account.</a></p>\r\n<p>If the link is not working, you can use the url below.</p>\r\n<p>{verifylink}</p>', 'email,verifylink,ip'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'verification_email', '<p>Hello {email};</p>\r\n<p>You have received this email for account confirmation.</p>\r\n<p>IP address of the device performing this operation is {ip}</p>\r\n<p><strong><a href=\"{verifylink}\">Click here to confirm your account.</a></strong></p>\r\n<p>If the link is not working, you can use the url below.</p>\r\n<p>{verifylink}</p>', 'email,verifylink,ip'),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'password_reset', '<p>Hello {email};</p>\r\n<p>You have received this email for password changing proccess.</p>\r\n<p>IP address of the device performing this operation is {ip}</p>\r\n<p>Click <a href=\"{resetLink}\">here</a> for reset your password.</p>', 'email,resetLink,ip'),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'password_new', '<p>Hello {email};</p>\r\n<p>You have received this email for password changing proccess.</p>\r\n<p>IP address of the device performing this operation is {ip}</p>\r\n<p>Your new password is {password}</p>', 'email,password,ip'),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'contact_email', '<p>You have received a contact email. The email contains the following information:</p>\r\n<p>Sender name: {name}</p>\r\n<p>Sender email: {email}</p>\r\n<p>Sender IP: {ip}</p>\r\n<p>Sender subject: {subject}</p>\r\n<p>Sender message: {message}</p>', 'name,email,subject,message,ip'),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'newsletter_email', '<p>Hello {email};</p>\r\n<p>You have received this email for newsletter verification.</p>\r\n<p>IP address of the device performing this operation is {ip}</p>\r\n<p>Click <a href=\"{verifylink}\">here</a> to complete your registration to the newsletter list.</p>\r\n<p>If the link is not working, you can use the url below.</p>\r\n<p>{verifylink}</p>', 'email,verifylink,ip'),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_admin_pending', '<p>A plan was purchased. You must confirm or reject the payment. The information about the plan payment is as follows:</p>\n<p>User name: {name}</p>\n<p>User email: {email}</p>\n<p>User IP: {ip}</p>\n<p>Plan name: {plan}</p>\n<p>Plan period: {period}</p>\n<p>Plan gateway: {gateway}</p>\n<p>Total revenue: {revenue}</p>\n<p>Payment info: {info}</p>', 'name,email,ip,plan,period,gateway,revenue,info'),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_admin_success', '<p>A plan was purchased. The information about the plan payment is as follows:</p>\r\n<p>User name: {name}</p>\r\n<p>User email: {email}</p>\r\n<p>User IP: {ip}</p>\r\n<p>Plan name: {plan}</p>\r\n<p>Plan period: {period}</p>\r\n<p>Plan gateway: {gateway}</p>\r\n<p>Total revenue: {revenue}</p>', 'name,email,ip,plan,period,gateway,revenue'),
(9, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_user_pending', '<p>You paid for a plan. Your payment will be reviewed and if your payment is approved, your plan will start.</p>\r\n<p>Plan name: {plan}</p>\r\n<p>Plan period: {period}</p>\r\n<p>Plan gateway: {gateway}</p>\r\n<p>Total payment: {payment}</p>\r\n<p>Payment info: {info}</p>', 'plan,period,gateway,payment,info'),
(10, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_user_success', '<p>You paid for a plan, your plan has begun.</p>\n<p>Plan name: {plan}</p>\n<p>Plan period: {period}</p>\n<p>Plan gateway: {gateway}</p>\n<p>Total payment: {payment}</p>\n\n<p>Plan start date: {start}</p>\n<p>Plan end date: {end}</p>', 'plan,period,gateway,payment,start,end'),
(11, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_user_rejected', '<p>Unfortunately, your payment has been declined. You can contact us for details.</p>\r\n<p>Plan name: {plan}</p>\r\n<p>Plan period: {period}</p>\r\n<p>Plan gateway: {gateway}</p>\r\n<p>Total payment: {payment}</p>\r\n<p>Payment info: {info}</p>', 'plan,period,gateway,payment,info'),
(12, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'plan_payment_user_verified', '<p>Your plan payment has been verified, your plan has begun.</p>\r\n<p>Plan name: {plan}</p>\r\n<p>Plan period: {period}</p>\r\n<p>Plan gateway: {gateway}</p>\r\n<p>Total payment: {payment}</p>\r\n\r\n<p>Plan start date: {start}</p>\r\n<p>Plan end date: {end}</p>', 'plan,period,gateway,payment,info,start,end');

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

--
-- Table structure for table `email_logs`
--

CREATE TABLE `email_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_logs`
--

INSERT INTO `email_logs` (`id`, `created_at`, `created_by_ip`, `name`, `email`, `subject`, `message`) VALUES
(1, '2024-12-05 12:00:00', '192.168.1.1', 'Mary', 'mary@portus.com', 'Subscriber List', 'Hello, can you remove me from your subscription list?');

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

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL,
  `additional` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'email', 'admin@portus.com', NULL),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'email_noreply', 'noreply@portus.aneontech.com', NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'email_logo', 'email_logo_6dKQBNxK4HWnlPb2zgqmggkUkNP09.png', NULL),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'smtp_host', '', NULL),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'smtp_port', '', NULL),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'smtp_encryption', 'none', NULL),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'smtp_user', '', NULL),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'smtp_password', '', NULL);

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `filename` varchar(250) NOT NULL,
  `filesize` int(11) NOT NULL,
  `filetype` varchar(250) NOT NULL,
  `disk` varchar(250) NOT NULL,
  `short_key` varchar(250) NOT NULL,
  `autoremove` varchar(250) DEFAULT NULL,
  `password` varchar(250) DEFAULT NULL,
  `pageview` int(11) DEFAULT NULL,
  `unique_pageview` int(11) DEFAULT NULL,
  `download` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `file_affiliate`
--

CREATE TABLE `file_affiliate` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `file_id` int(11) NOT NULL,
  `file_name` varchar(250) NOT NULL,
  `uploader` int(11) DEFAULT NULL,
  `value` mediumtext DEFAULT NULL,
  `additional` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `file_analytics`
--

CREATE TABLE `file_analytics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `file_id` int(11) NOT NULL,
  `file_name` varchar(250) NOT NULL,
  `uploader` int(11) DEFAULT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `file_reports`
--

CREATE TABLE `file_reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `file_id` int(11) NOT NULL,
  `file_uploader` int(11) DEFAULT NULL,
  `reporter` varchar(250) NOT NULL,
  `reason` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `language_settings`
--

CREATE TABLE `language_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL,
  `additional` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `language_settings`
--

INSERT INTO `language_settings` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'base_language', 'en', NULL),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'language_switcher', '1', NULL);

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `url` varchar(250) NOT NULL,
  `settings` text DEFAULT NULL,
  `content` text NOT NULL,
  `seo` text NOT NULL,
  `page_key` varchar(250) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `custom` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `url`, `settings`, `content`, `seo`, `page_key`, `status`, `custom`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Home', '/', NULL, '{\"top_area\":{\"title\":\"[lang]lang.home_hero_title[\\/lang]\",\"text\":\"[lang]lang.home_hero_text[\\/lang]\"},\"features\":{\"feature_1_image\":\"widget_g5L4bwGLDDKC2xWFZegJpuRbdRA6uM3RM.webp\",\"feature_1_title\":\"[lang]lang.home_feature_1_title[\\/lang]\",\"feature_1_text\":\"[lang]lang.home_feature_1_text[\\/lang]\",\"feature_2_image\":\"widget_8UZaChW5vGsJETNVno9LrOP9AFmTSGXtn.webp\",\"feature_2_title\":\"[lang]lang.home_feature_2_title[\\/lang]\",\"feature_2_text\":\"[lang]lang.home_feature_2_text[\\/lang]\",\"feature_3_title\":\"[lang]lang.home_feature_3_title[\\/lang]\",\"feature_3_text\":\"[lang]lang.home_feature_3_text[\\/lang]\",\"feature_3_image\":\"widget_wWI13unR1VsIJzL98ErC778AkUGGDP8wQ.webp\"}}', '{\"title\":\"Home\",\"keywords\":\"home, key\",\"description\":\"Home description\",\"no_index\":\"1\",\"og_title\":\"Home og title\",\"og_description\":\"Home og description\",\"og_image\":null}', 'home', 1, 0),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Contact', 'contact', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.contact_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.contact_header_title[\\/lang]\",\"bg_image\":\"widget_uQYUSyirUTa2RahBaws4XCV2p3RlTrvI2.webp\"},\"boxes\":{\"box_1_icon\":\"<i class=\\\"fa-solid fa-phone\\\"><\\/i>\",\"box_1_title\":\"[lang]lang.contact_box_1_title[\\/lang]\",\"box_1_subtitle\":\"[lang]lang.contact_box_1_subtitle[\\/lang]\",\"box_1_text\":\"12345678900\",\"box_2_icon\":\"<i class=\\\"fa-solid fa-envelope\\\"><\\/i>\",\"box_2_title\":\"[lang]lang.contact_box_2_title[\\/lang]\",\"box_2_subtitle\":\"[lang]lang.contact_box_2_subtitle[\\/lang]\",\"box_2_text\":\"help@portus.com\",\"box_3_icon\":\"<i class=\\\"fa-solid fa-location-dot\\\"><\\/i>\",\"box_3_title\":\"[lang]lang.contact_box_3_title[\\/lang]\",\"box_3_subtitle\":\"[lang]lang.contact_box_3_subtitle[\\/lang]\",\"box_3_text\":\"2000 Warfield Dr, Nashville\"},\"form\":{\"upper_title\":\"[lang]lang.contact_form_upper_title[\\/lang]\",\"title\":\"[lang]lang.contact_form_title[\\/lang]\",\"text\":\"[lang]lang.contact_form_text[\\/lang]\",\"image\":\"widget_oldlFJIiqUtTesKcSEqKyPIK7hTo9rYvY.webp\"}}', '{\"title\":\"Contact\",\"keywords\":\"contact, key\",\"description\":\"contact description\",\"no_index\":\"1\",\"og_title\":\"Contact og title\",\"og_description\":\"Contact og description\",\"og_image\":null}', 'contact', 1, 0),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Pricing', 'pricing', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.pricing_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.pricing_header_title[\\/lang]\",\"bg_image\":\"widget_MkyKAYsfN5E5z1sYd2ZqggXD3niZDLuQM.webp\"},\"plans\":{\"upper_title\":\"[lang]lang.pricing_plans_upper_title[\\/lang]\",\"title\":\"[lang]lang.pricing_plans_title[\\/lang]\",\"text\":\"[lang]lang.pricing_plans_text[\\/lang]\"},\"faqs\":{\"upper_title\":\"[lang]lang.pricing_faqs_upper_title[\\/lang]\",\"title\":\"[lang]lang.pricing_faqs_title[\\/lang]\",\"text\":\"[lang]lang.pricing_faqs_text[\\/lang]\",\"question_1\":\"[lang]lang.pricing_faqs_question_1[\\/lang]\",\"answer_1\":\"[lang]lang.pricing_faqs_answer_1[\\/lang]\",\"question_2\":\"[lang]lang.pricing_faqs_question_2[\\/lang]\",\"answer_2\":\"[lang]lang.pricing_faqs_answer_2[\\/lang]\",\"question_3\":\"[lang]lang.pricing_faqs_question_3[\\/lang]\",\"answer_3\":\"[lang]lang.pricing_faqs_answer_3[\\/lang]\",\"question_4\":\"[lang]lang.pricing_faqs_question_4[\\/lang]\",\"answer_4\":\"[lang]lang.pricing_faqs_answer_4[\\/lang]\",\"question_5\":\"[lang]lang.pricing_faqs_question_5[\\/lang]\",\"answer_5\":\"[lang]lang.pricing_faqs_answer_5[\\/lang]\"}}', '{\"title\":\"Pricing\",\"keywords\":\"plan, pricing, key\",\"description\":\"Plan description\",\"no_index\":\"1\",\"og_title\":\"Plan og title\",\"og_description\":\"Plan og description\",\"og_image\":null}', 'pricing', 1, 0),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Pay', 'pay', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.pay_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.pay_header_title[\\/lang]\",\"bg_image\":\"widget_R2srhCfCwylZ1NgDFFoM1LwSBI6xs1OwB.webp\"}}', '{\"title\":\"Pay\",\"keywords\":\"pay, payment, key\",\"description\":\"Pay description\",\"no_index\":\"1\",\"og_title\":\"Pay og title\",\"og_description\":\"Pay og description\",\"og_image\":null}', 'pay', 1, 0),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Affiliate', 'affiliate', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.affiliate_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.affiliate_header_title[\\/lang]\",\"bg_image\":\"widget_RE2XZu9GRY6Vx22Ppac4w9sCd8tZ6kfWI.webp\"},\"boxes\":{\"box_1_icon\":\"<i class=\\\"fa-solid fa-user-plus\\\"><\\/i>\",\"box_1_title\":\"[lang]lang.affiliate_box_1_title[\\/lang]\",\"box_1_text\":\"[lang]lang.affiliate_box_1_text[\\/lang]\",\"box_2_icon\":\"<i class=\\\"fa-solid fa-up-right-from-square\\\"><\\/i>\",\"box_2_title\":\"[lang]lang.affiliate_box_2_title[\\/lang]\",\"box_2_text\":\"[lang]lang.affiliate_box_2_text[\\/lang]\",\"box_3_icon\":\"<i class=\\\"fa-solid fa-hand-holding-dollar\\\"><\\/i>\",\"box_3_title\":\"[lang]lang.affiliate_box_3_title[\\/lang]\",\"box_3_text\":\"[lang]lang.affiliate_box_3_text[\\/lang]\"},\"table\":{\"upper_title\":\"[lang]lang.affiliate_table_upper_title[\\/lang]\",\"title\":\"[lang]lang.affiliate_table_title[\\/lang]\",\"text\":\"[lang]lang.affiliate_table_text[\\/lang]\"},\"payments\":{\"upper_title\":\"[lang]lang.affiliate_payments_upper_title[\\/lang]\",\"title\":\"[lang]lang.affiliate_payments_title[\\/lang]\",\"text\":\"[lang]lang.affiliate_payments_text[\\/lang]\"},\"stats\":{\"upper_title\":\"[lang]lang.affiliate_stats_upper_title[\\/lang]\",\"title\":\"[lang]lang.affiliate_stats_title[\\/lang]\",\"user_stats\":\"1000+\",\"file_stats\":\"25000+\",\"payment_stats\":\"$6000\"},\"faqs\":{\"upper_title\":\"[lang]lang.affiliate_faqs_upper_title[\\/lang]\",\"title\":\"[lang]lang.affiliate_faqs_title[\\/lang]\",\"text\":\"[lang]lang.affiliate_faqs_text[\\/lang]\",\"question_1\":\"[lang]lang.affiliate_faqs_question_1[\\/lang]\",\"answer_1\":\"[lang]lang.affiliate_faqs_answer_1[\\/lang]\",\"question_2\":\"[lang]lang.affiliate_faqs_question_2[\\/lang]\",\"answer_2\":\"[lang]lang.affiliate_faqs_answer_2[\\/lang]\",\"question_3\":\"[lang]lang.affiliate_faqs_question_3[\\/lang]\",\"answer_3\":\"[lang]lang.affiliate_faqs_answer_3[\\/lang]\",\"question_4\":\"[lang]lang.affiliate_faqs_question_4[\\/lang]\",\"answer_4\":\"[lang]lang.affiliate_faqs_answer_4[\\/lang]\",\"question_5\":\"[lang]lang.affiliate_faqs_question_5[\\/lang]\",\"answer_5\":\"[lang]lang.affiliate_faqs_answer_5[\\/lang]\"}}', '{\"title\":\"Affiliate\",\"keywords\":\"affiliate, key\",\"description\":\"Affiliate description\",\"no_index\":\"1\",\"og_title\":\"Affiliate og title\",\"og_description\":\"Affiliate og description\",\"og_image\":null}', 'affiliate', 1, 0),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Blog', 'blog', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.blog_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.blog_header_title[\\/lang]\",\"bg_image\":\"widget_TAez2GJRCzB4kK5Ab4ItHhP5G6AtO2h54.webp\"}}', '{\"title\":\"Blog\",\"keywords\":\"blog, key\",\"description\":\"Blog description\",\"no_index\":\"1\",\"og_title\":\"Blog og title\",\"og_description\":\"Blog og description\",\"og_image\":null}', 'blog', 1, 0),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Blog Inner', 'post', NULL, '{\"header\":{\"bg_image\":\"widget_RvY6QgNcWSpvRWkplNWxkKMf7S6gfBhoM.webp\"}}', '{\"title\":\"Blog Inner\",\"keywords\":null,\"description\":null,\"no_index\":null,\"og_title\":null,\"og_description\":null,\"og_image\":null}', 'blog_inner', 1, 0),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Login', 'login', NULL, '{\"content\":\"\"}', '{\"title\":\"Login\",\"keywords\":\"login, key\",\"description\":\"Login description\",\"no_index\":\"1\",\"og_title\":\"Login og title\",\"og_description\":\"Login og description\",\"og_image\":null}', 'login', 1, 0),
(9, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Register', 'register', NULL, '{\"content\":\"\"}', '{\"title\":\"Register\",\"keywords\":\"register, key\",\"description\":\"Register description\",\"no_index\":\"1\",\"og_title\":\"Register og title\",\"og_description\":\"Register og description\",\"og_image\":null}', 'register', 1, 0),
(10, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Forgot Password', 'forgot-password', NULL, '{\"content\":\"\"}', '{\"title\":\"Forgot Password\",\"keywords\":\"forgot password, key\",\"description\":\"Forgot password description\",\"no_index\":\"1\",\"og_title\":\"Forgot password og title\",\"og_description\":\"Forgot password og description\",\"og_image\":null}', 'forgot_password', 1, 0),
(11, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Verify Account', 'verify-account', NULL, '{\"content\":\"\"}', '{\"title\":\"Verify Account\",\"keywords\":\"verification, key\",\"description\":\"Verification description\",\"no_index\":\"1\",\"og_title\":\"Verify Account og title\",\"og_description\":\"Verify Account og description\",\"og_image\":null}', 'verify_account', 1, 0),
(12, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Terms of Use', 'terms-of-use', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.terms_of_use_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.terms_of_use_header_title[\\/lang]\",\"bg_image\":\"widget_dkGio1tMiAJ6JISI50riIfTsKrQhDk85O.webp\"},\"content\":{\"text\":\"<p>Welcome to Portus (\\\"we,\\\" \\\"us,\\\" \\\"our\\\"). By accessing or using our website https:\\/\\/portus.aneontech.com\\/, mobile application, or other services (collectively, the \\\"Services\\\"), you agree to comply with and be bound by these Terms of Use (\\\"Terms\\\"). If you do not agree to these Terms, please do not use our Services.<\\/p><h4>1. Changes to Terms<\\/h4><p>We may update these Terms from time to time. When we make changes, we will post the revised Terms on this page and update the \\\"Effective Date\\\" at the top. Your continued use of the Services after changes have been posted constitutes your acceptance of the revised Terms.<\\/p><h4>2. Use of Services<\\/h4><p>You agree to use our Services only for lawful purposes and in accordance with these Terms. You must not use our Services:<\\/p><ul><li>In any way that violates any applicable federal, state, or local law or regulation.<\\/li><li>To engage in any conduct that restricts or inhibits anyone\\u2019s use or enjoyment of our Services, or which, as determined by us, may harm Portus or users of our Services.<\\/li><li>To transmit, or procure the sending of, any unsolicited or unauthorized advertising or promotional material.<\\/li><li>To impersonate or attempt to impersonate Portus, a Portus employee, another user, or any other person or entity.<\\/li><\\/ul><h4>3. Account Registration<\\/h4><p>To access certain features of our Services, you may be required to register for an account. You agree to provide accurate, current, and complete information during registration and to update such information to keep it accurate, current, and complete. You are responsible for safeguarding your account credentials and for all activities that occur under your account.<\\/p><h4>4. Intellectual Property<\\/h4><p>All content, trademarks, and other intellectual property on our Services are the property of Portus or its licensors. You may not use, reproduce, distribute, or create derivative works from any content without our express written permission.<\\/p><h4>5. User Content<\\/h4><p>You are solely responsible for any content you submit or transmit through our Services. By submitting content, you grant us a non-exclusive, royalty-free, perpetual, and worldwide license to use, reproduce, modify, and display such content.<\\/p><h4>6. Privacy<\\/h4><p>Your use of our Services is also governed by our Privacy Policy, which explains how we collect, use, and protect your personal information. Please review our Privacy Policy to understand our practices.<\\/p><h4>7. Disclaimers<\\/h4><p>Our Services are provided \\\"as is\\\" and \\\"as available\\\" without any warranties of any kind, either express or implied. We do not warrant that our Services will be uninterrupted or error-free.<\\/p><h4>8. Limitation of Liability<\\/h4><p>To the maximum extent permitted by law, Portus and its affiliates shall not be liable for any indirect, incidental, special, consequential, or punitive damages arising out of or in connection with your use of the Services.<\\/p><h4>9. Indemnification<\\/h4><p>You agree to indemnify, defend, and hold harmless Portus, its affiliates, and their respective officers, directors, employees, and agents from and against any claims, liabilities, damages, losses, and expenses arising out of or in connection with your use of the Services or violation of these Terms.<\\/p><h4>10. Governing Law<\\/h4><p>These Terms and any disputes arising out of or relating to them shall be governed by and construed in accordance with the laws of USA\\/Tennessee, without regard to its conflict of law principles.<\\/p><h4>11. Contact Us<\\/h4><p>If you have any questions or concerns about these Terms, please contact us at:<\\/p><p>Email: aneontech.help@gmail.com<\\/p>\"}}', '{\"title\":\"Terms of Use\",\"keywords\":\"terms of use, key\",\"description\":\"Terms of use description\",\"no_index\":\"1\",\"og_title\":\"Terms of use og title\",\"og_description\":\"Terms of use og description\",\"og_image\":null}', 'terms_of_use', 1, 0),
(13, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Privacy Policy', 'privacy-policy', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.privacy_policy_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.privacy_policy_header_title[\\/lang]\",\"bg_image\":\"widget_Hsx2F6hotvcmx5W4MLkKbnPl32CH7UiI7.webp\"},\"content\":{\"text\":\"<p>Welcome to Portus (\\\"we,\\\" \\\"us,\\\" \\\"our\\\"). We are committed to protecting your privacy and ensuring that your personal information is handled in a safe and responsible manner. This Privacy Policy explains how we collect, use, disclose, and protect your personal information when you use our website https:\\/\\/portus.aneontech.com\\/, mobile applications, and other services (collectively, the \\\"Services\\\").<\\/p><h4>1. Information We Collect<\\/h4><p>We may collect the following types of information:<\\/p><ul><li><strong>Account Information<\\/strong>: When you sign up for an account, we collect personal information such as your name, email address, username, and password.<\\/li><li><strong>Payment Information<\\/strong>: If you purchase any paid features or services, we may collect billing information, such as credit card details or PayPal information.<\\/li><li><strong>User Content<\\/strong>: Any content (such as images, videos, and comments) that you upload, share, or submit to the Service.<\\/li><li><strong>Usage Data:<\\/strong> Information about your use of our Services, including your IP address, browser type, operating system, and pages visited.<\\/li><li><strong>Cookies and Tracking Technologies:<\\/strong> We use cookies and other tracking technologies to enhance your experience, analyze usage, and gather information about your interactions with our Services.<\\/li><\\/ul><h4>2. How We Use Your Information<\\/h4><p>We use the information we collect to provide, maintain, and improve our Service. Specifically, we may use your information for the following purposes:<\\/p><ul><li>To create and manage your account.<\\/li><li>To process payments for paid services.<\\/li><li>To provide customer support and respond to your inquiries.<\\/li><li>To personalize and enhance your user experience.<\\/li><li>To send you marketing communications (only if you have opted-in).<\\/li><li>To monitor usage and performance of the Service.<\\/li><\\/ul><h4>3. How We Share Your Information<\\/h4><p>We do not sell, rent, or trade your personal information to third parties. However, we may share your data in the following circumstances:<\\/p><ul><li><strong>With Service Providers<\\/strong>: We may share your information with trusted third-party companies that help us operate our website, process payments, or provide customer support. These companies are obligated to protect your data and may only use it for the specific services they perform on our behalf.<\\/li><li><strong>For Legal Purposes<\\/strong>: We may disclose your information if required by law, or if we believe such action is necessary to comply with a legal obligation, protect our rights, or prevent fraud or illegal activities.<\\/li><li><strong>With Your Consent<\\/strong>: We may share your information with other parties if you have given explicit consent to do so.<\\/li><\\/ul><h4>4. Your Choices and Rights<\\/h4><p>You have the following rights regarding your personal information:<\\/p><ul><li><strong>Access and Correction:<\\/strong> You may access and update your personal information by logging into your account or contacting us.<\\/li><li><strong>Opt-Out:<\\/strong> You may opt-out of receiving promotional communications from us by following the instructions provided in those communications.<\\/li><li><strong>Cookies:<\\/strong> You can manage your cookie preferences through your browser settings.<\\/li><\\/ul><h4>5. Data Security<\\/h4><p>We implement reasonable security measures to protect your personal information from unauthorized access, use, or disclosure. However, no security measures are completely foolproof, and we cannot guarantee the absolute security of your information.<\\/p><h4>6. Children\\u2019s Privacy<\\/h4><p>Our Services are not intended for use by individuals under the age of 13. We do not knowingly collect personal information from children under 13. If we become aware that we have collected such information, we will take steps to delete it.<\\/p><h4>7. Changes to This Privacy Policy<\\/h4><p>We may update this Privacy Policy from time to time. Any changes will be posted on this page with an updated effective date. Your continued use of our Services after any changes constitutes your acceptance of the revised Privacy Policy.<\\/p><h4>8. Contact Us<\\/h4><p>If you have any questions or concerns about this Privacy Policy or our practices, please contact us at:<\\/p><p>Email: aneontech.help@gmail.com<\\/p>\"}}', '{\"title\":\"Privacy Policy\",\"keywords\":\"privacy policy, key\",\"description\":\"Privacy policy description\",\"no_index\":\"1\",\"og_title\":\"Privacy policy og title\",\"og_description\":\"Privacy policy og description\",\"og_image\":null}', 'privacy_policy', 1, 0),
(14, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Custom page', 'custom-page-j4sfXA', NULL, '{\"header\":{\"upper_title\":\"Custom\",\"title\":\"Lorem ipsum dolar sit amet\",\"bg_image\":\"page_header_b74hc3ZMLJbW7nmQdGq44lGMYHAp.webp\"},\"content\":\"<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris commodo tincidunt dui, non iaculis ligula ultrices at. Maecenas sed dictum nunc. Praesent facilisis vitae sapien non tempor. Fusce non sapien placerat, porttitor nunc eget, pulvinar massa. Cras sit amet turpis dapibus, iaculis ligula eget, egestas massa.&nbsp;<\\/p><p>Mauris sagittis elementum nisl, non rhoncus sapien facilisis sit amet. Proin quis metus id eros efficitur vestibulum. Aenean quis lorem rhoncus, pulvinar dui eu, congue nunc. Fusce maximus leo facilisis, luctus nisl a, iaculis erat. Curabitur pellentesque elementum elementum. Donec finibus ultrices elit nec interdum. Nunc sed ligula nec ex lobortis dictum. Suspendisse ornare, enim in varius pretium, nisl turpis hendrerit ipsum, eu venenatis justo arcu a eros. Mauris sed blandit magna. Nulla et mauris maximus, consectetur arcu ac, scelerisque libero.<\\/p><p>Donec fermentum purus orci, et efficitur neque feugiat a. Nam laoreet sollicitudin lectus quis sagittis. Phasellus ornare pharetra neque et auctor. Curabitur fermentum eleifend mattis. Nulla facilisi. Suspendisse quis sem sit amet sapien efficitur pellentesque. Etiam pellentesque justo et mollis luctus. Donec dignissim, ligula sed volutpat gravida, massa ligula consectetur lorem, condimentum volutpat neque mi quis massa. Integer maximus, tellus ut ullamcorper venenatis, turpis massa ornare quam, vel cursus odio ante a diam. Curabitur semper massa arcu, id dapibus tellus dapibus sed. Nulla facilisi. In vitae porta massa, eu tempus mi. Ut dignissim laoreet sapien, id aliquet enim faucibus ut. Vivamus tempus fringilla nunc a dictum. Donec gravida, orci non porttitor blandit, quam libero condimentum orci, non tempor nisl arcu a lorem. Donec ligula massa, suscipit nec semper nec, imperdiet faucibus neque.<\\/p>\"}', '{\"title\":\"Custom page\",\"keywords\":\"custom, key\",\"description\":\"Custom description\",\"no_index\":\"1\",\"og_title\":\"Custom og title\",\"og_description\":\"Custom og description\",\"og_image\":null}', 'custom_page', 1, 1),
(15, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'File', 'file', NULL, '{\"content\":\"\"}', '{\"title\":\"File\",\"keywords\":\"file, key\",\"description\":\"File description\",\"no_index\":\"1\",\"og_title\":\"File og title\",\"og_description\":\"File og description\",\"og_image\":null}', 'file', 1, 0),
(16, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', '403', '403', NULL, '{\"403_content\":{\"title\":\"[lang]lang.403_error_title[\\/lang]\",\"text\":\"[lang]lang.403_error_text[\\/lang]\",\"image\":\"widget_EoodA3boFfz6BWkzcev1oklctrVM2C8SE.webp\"}}', '{\"title\":\"403\",\"keywords\":\"403, error, key\",\"description\":\"403 description\",\"no_index\":\"1\",\"og_title\":\"403 og title\",\"og_description\":\"403 og description\",\"og_image\":null}', '403', 1, 0),
(17, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', '404', '404', NULL, '{\"404_content\":{\"title\":\"[lang]lang.404_error_title[\\/lang]\",\"text\":\"[lang]lang.404_error_text[\\/lang]\",\"image\":\"widget_uuoWxn7xjqKH4sLuJJBprCAigrxB3Ze5a.webp\"}}', '{\"title\":\"404\",\"keywords\":\"404, error, key\",\"description\":\"404 description\",\"no_index\":\"1\",\"og_title\":\"404 og title\",\"og_description\":\"404 og description\",\"og_image\":null}', '404', 1, 0),
(18, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', '500', '500', NULL, '{\"500_content\":{\"title\":\"[lang]lang.500_error_title[\\/lang]\",\"text\":\"[lang]lang.500_error_text[\\/lang]\",\"image\":\"widget_h8hBsxeqVzlLfvhnhDRSaW8OsIXJuWd27.webp\"}}', '{\"title\":\"500\",\"keywords\":\"500, error, key\",\"description\":\"500 description\",\"no_index\":\"1\",\"og_title\":\"500 og title\",\"og_description\":\"500 og description\",\"og_image\":null}', '500', 1, 0),
(19, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Maintenance', 'maintenance', NULL, '{\"maintenance_content\":{\"title\":\"[lang]lang.maintenance_title[\\/lang]\",\"text\":\"[lang]lang.maintenance_text[\\/lang]\",\"image\":\"widget_codmwPfjuue9MNRk3Q8cSAVDuYW3c19UT.webp\"}}', '{\"title\":\"Maintenance\",\"keywords\":\"maintenance, key\",\"description\":\"Maintenance description\",\"no_index\":\"1\",\"og_title\":\"Maintenance og title\",\"og_description\":\"Maintenance og description\",\"og_image\":null}', 'maintenance', 1, 0);

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `public` varchar(250) DEFAULT NULL,
  `secret` varchar(250) DEFAULT NULL,
  `mode` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `info` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `public`, `secret`, `mode`, `status`, `info`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Bank', NULL, NULL, 1, 1, 'Account Name: Portus Company\r\nIBAN: GB33BUKB20201555555555\r\nSWIFT/BIC: SAGCEBKAXBX\r\nBank Account Currency: $ (USD)\r\nBank Name: AneonBank'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Stripe', NULL, NULL, 1, 0, NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Razorpay', NULL, NULL, 1, 0, NULL);

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

--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `plan` int(11) NOT NULL,
  `gateway` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `transaction` varchar(250) NOT NULL,
  `info` varchar(250) DEFAULT NULL,
  `revenue` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_plans`
--

CREATE TABLE `payment_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `price_monthly` int(11) DEFAULT NULL,
  `price_yearly` int(11) DEFAULT NULL,
  `features` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  `free` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_plans`
--

INSERT INTO `payment_plans` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `price_monthly`, `price_yearly`, `features`, `status`, `free`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Free', NULL, NULL, '{\"formats\":[\"zip\",\"jpg\",\"png\",\"mp4\"],\"disk\":\"1024\",\"countdown\":\"0\",\"auto_deletion\":\"30\",\"api\":\"0\"}', 1, 1),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Business', 15, 140, '{\"formats\":[\"zip\",\"gif\",\"jpg\",\"png\",\"mp4\",\"avi\",\"webm\"],\"disk\":\"2048\",\"countdown\":\"0\",\"auto_deletion\":\"90\",\"api\":\"1\"}', 1, NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Enterprise', 20, 180, '{\"formats\":[\"zip\",\"apng\",\"avif\",\"gif\",\"ico\",\"jpe\",\"jpeg\",\"jpg\",\"png\",\"webp\",\"heic\",\"mp4\",\"avi\",\"wmv\",\"webm\"],\"disk\":\"3072\",\"countdown\":\"1\",\"auto_deletion\":\"180\",\"api\":\"1\"}', 1, NULL);

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

--
-- Table structure for table `payment_settings`
--

CREATE TABLE `payment_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL,
  `additional` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_settings`
--

INSERT INTO `payment_settings` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'currency_name', 'USD', NULL),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'currency_icon', '$', NULL);

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

--
-- Table structure for table `payout_rates`
--

CREATE TABLE `payout_rates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `country_name` varchar(250) NOT NULL,
  `country_code` varchar(250) NOT NULL,
  `rate` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payout_rates`
--

INSERT INTO `payout_rates` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `country_name`, `country_code`, `rate`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Bangladesh', 'BD', '0.05'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Turkey', 'TR', '0.25'),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Australia', 'AU', '0.75'),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'United States', 'US', '0.85'),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Canada', 'CA', '0.65'),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Spain', 'ES', '0.45'),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Belgium', 'BE', '0.35'),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'France', 'FR', '0.35'),
(9, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Germany', 'DE', '0.25'),
(10, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Romania', 'RO', '0.35');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  `additional` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'name', 'Portus', NULL),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'description', 'Portus is an advanced file hosting platform designed for users to upload, store, and share files online.', NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'keywords', 'portus, file hosting, file upload', NULL),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'og_title', 'Portus OG', NULL),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'og_image', 'og_WrvSdzRuu6brwlXpxfshqhbiCcrwyEOk1VWdJ.png', NULL),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'og_description', 'Portus is an advanced file hosting platform designed for users to upload, store, and share files online.', NULL),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'logo_light', 'logo_light_lIxot5OKv0J6D9bWhUCiBDQpzhOhu.svg', NULL),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'logo_dark', 'logo_dark_I6OkyxLg1zA8WXrvtVDt2r37fOsc7B.svg', NULL),
(9, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'favicon', 'favicon_uoMBTI7ilNQxLJF3JFpaKbI5RMW8qcAq.svg', NULL),
(10, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'time_zone', 'UTC', NULL),
(11, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'time_format', '2', NULL),
(12, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'loader', '1', NULL),
(13, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'loader_style', 'three-dots', NULL),
(14, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'lazyload', '1', NULL),
(15, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'minify', '1', NULL),
(16, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'defer', '1', NULL),
(17, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'email_verification', '0', NULL),
(18, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'fb_account', 'https://www.facebook.com/', NULL),
(19, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'x_account', 'https://www.x.com/', NULL),
(20, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'in_account', 'https://www.instagram.com/', NULL),
(21, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'li_account', 'https://www.linkedin.com/', NULL),
(22, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'go_status', '0', NULL),
(23, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'go_client', NULL, NULL),
(24, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'go_secret', NULL, NULL),
(25, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'recaptcha_status', '0', NULL),
(26, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'recaptcha_site', NULL, NULL),
(27, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'recaptcha_secret', NULL, NULL),
(28, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'additional_css', NULL, NULL),
(29, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'additional_js', NULL, NULL),
(30, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'default_color_mode', '1', NULL),
(31, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'ip2location_token', NULL, NULL);

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

--
-- Table structure for table `settings_affiliate`
--

CREATE TABLE `settings_affiliate` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings_affiliate`
--

INSERT INTO `settings_affiliate` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'status', '1'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'type', '1');

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

--
-- Table structure for table `settings_download`
--

CREATE TABLE `settings_download` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings_download`
--

INSERT INTO `settings_download` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'countdown', '15'),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'adblock_blocker', '1'),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'top_area', '<div class=\"text-center\">\r\n<img src=\"https://portus.aneontech.com/assets/image/ad-top.webp\" width=\"728\" height=\"90\" class=\"mw-100\" alt=\"Ad image\">\r\n</div>'),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'middle_area', '<div class=\"text-center\">\r\n<img src=\"https://portus.aneontech.com/assets/image/ad-middle.webp\" width=\"728\" height=\"90\" class=\"mw-100\" alt=\"Ad image\">\r\n</div>'),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'bottom_area', '<div class=\"text-center\">\r\n<img src=\"https://portus.aneontech.com/assets/image/ad-bottom.webp\" width=\"728\" height=\"90\" class=\"mw-100\" alt=\"Ad image\">\r\n</div>'),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'js_codes', NULL);

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

--
-- Table structure for table `settings_footer`
--

CREATE TABLE `settings_footer` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  `additional` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings_footer`
--

INSERT INTO `settings_footer` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'about', '[lang]lang.footer_about_text[/lang]', NULL),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_1_name', '[lang]lang.contact[/lang]', NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_1_url', 'https://portus.aneontech.com/contact', NULL),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_2_name', '[lang]lang.blog[/lang]', NULL),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_2_url', 'https://portus.aneontech.com/blog', NULL),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_3_name', '[lang]lang.pricing[/lang]', NULL),
(7, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_3_url', 'https://portus.aneontech.com/pricing', NULL),
(8, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_4_name', '[lang]lang.affiliate[/lang]', NULL),
(9, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_4_url', 'https://portus.aneontech.com/affiliate', NULL),
(10, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_5_name', '[lang]lang.terms_of_use[/lang]', NULL),
(11, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_5_url', 'https://portus.aneontech.com/terms-of-use', NULL),
(12, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_6_name', '[lang]lang.privacy_policy[/lang]', NULL),
(13, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_6_url', 'https://portus.aneontech.com/privacy-policy', NULL),
(14, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_7_name', NULL, NULL),
(15, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_7_url', NULL, NULL),
(16, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_8_name', NULL, NULL),
(17, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'link_8_url', NULL, NULL),
(18, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'email', 'email@portus.com', NULL),
(19, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'location', '672 Main St, Buffalo', NULL),
(20, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'copyright', '[lang]lang.copyright[/lang] © Portus 2025', NULL);

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

--
-- Table structure for table `settings_storage`
--

CREATE TABLE `settings_storage` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  `storage_key` varchar(250) NOT NULL,
  `default` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings_storage`
--

INSERT INTO `settings_storage` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `storage_key`, `default`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Local', NULL, 'default', 1),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Amazon S3', '{\"access_key_id\":\"\",\"secret_access_key\":\"\",\"default_region\":\"\",\"bucket\":\"\",\"url\":\"\"}', 's3', NULL),
(3, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Cloudflare R2', '{\"access_key_id\":\"\",\"secret_access_key\":\"\",\"bucket\":\"\",\"endpoint\":\"\",\"url\":\"\"}', 'r2', NULL),
(4, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Wasabi', '{\"access_key_id\":\"\",\"secret_access_key\":\"\",\"default_region\":\"\",\"bucket\":\"\",\"url\":\"\"}', 'wasabi', NULL),
(5, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Ftp', '{\"host\":\"\",\"username\":\"\",\"password\":\"\",\"port\":\"\",\"path\":\"\",\"url\":\"\"}', 'ftp', NULL),
(6, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Google Drive', '{\"client_id\":\"\",\"client_secret\":\"\",\"refresh_token\":\"\",\"folder\":null}', 'google', NULL);

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

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

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `email` varchar(250) NOT NULL,
  `verification_code` varchar(250) DEFAULT NULL,
  `verified` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`id`, `created_at`, `created_by_ip`, `updated_at`, `updated_by_ip`, `email`, `verification_code`, `verified`) VALUES
(1, '2024-12-05 12:00:00', '192.168.1.1', '2024-12-05 12:00:00', '192.168.1.1', 'mary@portus.com', 'nlBbPP2NN9NWSflGBYyEzxfy49HiGOevXM6JFr0Eimz7QjcXVGbUmW2mgkS6ssZ23spea2pZ1icZxrqQ0bRdeGiFApYP1VZACnCzUYt6ODyTxqW9PKpHPnZzjVrgu4uGxzsj8q0xRL34R1tm0XypRSj6SU3sb2vGVQur0PCxTmWIOE6RXfvgUNXKNRYjYM7tCF1YSbBjcavYu9jQEAoMc4K6stWrFOLyqQ0Rs74u7B3Bx2sN3tTphlrkBJ', 0);

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) DEFAULT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 1,
  `photo` varchar(250) DEFAULT NULL,
  `password` varchar(250) NOT NULL,
  `verified` tinyint(4) NOT NULL,
  `verification_token` varchar(250) DEFAULT NULL,
  `reset_token` varchar(250) DEFAULT NULL,
  `remember_token` varchar(250) DEFAULT NULL,
  `api_token` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `created_at`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `email`, `type`, `photo`, `password`, `verified`, `verification_token`, `reset_token`, `remember_token`, `api_token`) VALUES
(1, '2024-12-05 12:00:00', '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Admin', 'admin@portus.com', 2, 'avatar_fhnBUzJEevTLAZHAaeRO2fhGylyt1cUg9.webp', '$2y$12$GRkHP9Zw6ONbESHU5RGwje8KS6z8lPP1WKnXYslXarTDKI8Rw.4Ci', 1, NULL, NULL, '56iqrGzL5cvh9sWGSMj42MXFELHKcZ3zHLBHpRxDKEwivxqtjRIgheqW0xhQ', 'A5IA-AW36-34XI-CEZY'),
(2, '2024-12-05 12:00:00', '192.168.1.1', '2024-12-05 12:00:00', 2, '192.168.1.1', 'Jane', 'user@portus.com', 1, 'avatar_RyxlH3PBzia8DE5YH5L0yAtth1ks2GrT1.webp', '$2y$12$jYClH4CY.QyM8Zp8EArTK.Vkrm8Cf21dBFiIDE6giM1rcsnpgzJNW', 1, NULL, NULL, 'Pto3lONHIaZznWHLvpIqFh3QQe4EuqW6jlgfD6EvvoW4KWVj6CBCKkfnwAlz', 'RBTU-V7O1-KBW8-GS0A'),
(3, '2024-12-05 12:00:00', '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'John', 'john@portus.com', 1, 'avatar_fPucrw4fLQEQr9T95163uJLLlCZEJMamo.webp', '$2y$12$WCQt9tNuarxW0.B6nG4BDuRav12iCpSlOVRadoQJvEKP0gIF0BZNG', 1, NULL, NULL, NULL, '1F6C-8KVT-1VWL-SRMZ'),
(4, '2024-12-05 12:00:00', '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Mary', 'mary@portus.com', 1, 'avatar_9WitMtzYsKtpZ8oDCJUQkFSzb5kZjZXG1.webp', '$2y$12$BA.gKtR5gWVAs7JpV9UeTe5RCH023on69BRG/PYezjK2ssTHEauc.', 1, NULL, NULL, 'VM7tYMYqro8JRHlSmBNCldrrJmuzxFyP4BUiq8YEFjbXhgAPOqhjg2emSBdJ', '66RK-ZI9Q-JGQ1-QP5M');

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

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

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `details` text NOT NULL,
  `amount` varchar(250) NOT NULL,
  `payment_method` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdrawal_methods`
--

CREATE TABLE `withdrawal_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `minimum` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawal_methods`
--

INSERT INTO `withdrawal_methods` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `description`, `minimum`, `status`) VALUES
(1, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Bank', 'Please fill in your bank details as complete as possible, including: Your Address, Your bank\'s Address, The name of the account holder, Your account number and if possible IBAN, Your bank\'s SWIFT code.', 250, 1),
(2, '2024-12-05 12:00:00', 1, '192.168.1.1', '2024-12-05 12:00:00', 1, '192.168.1.1', 'Paypal', 'Enter your Paypal username.', 50, 1);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `withdrawal_methods`
--
ALTER TABLE `withdrawal_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
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 */;
