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

START TRANSACTION;



--
-- Database: `code`
--

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

--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `admin_notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:Internal 2:External',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 : Unread 1: Read',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint UNSIGNED NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` (`id`, `alias`, `position`, `size`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'head_code', 'Head Code', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-09-27 18:21:42'),
(2, 'home_page_top', 'Home Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-05-08 15:17:59'),
(3, 'home_page_center', 'Home Page (Center)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(4, 'home_page_bottom', 'Home Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(5, 'item_page_top', 'Item Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(6, 'item_page_sidebar', 'Item Page (Sidebar)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-09-27 18:31:03'),
(7, 'item_page_description_top', 'Item Page (Description Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-09-27 18:32:51'),
(8, 'item_page_description_bottom', 'Item Page (Description Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-09-27 18:32:56'),
(9, 'item_page_bottom', 'Item Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(10, 'category_page_top', 'Category Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(11, 'category_page_bottom', 'Category Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(12, 'search_page_top', 'Search Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(13, 'search_page_bottom', 'Search Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(14, 'blog_page_top', 'Blog Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(15, 'blog_page_bottom', 'Blog Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(16, 'blog_article_page_top', 'Blog Article Page (Top)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56'),
(17, 'blog_article_page_bottom', 'Blog Article Page (Bottom)', NULL, NULL, 0, '2024-04-16 21:20:58', '2024-04-16 16:30:56');

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

--
-- Table structure for table `blog_articles`
--

CREATE TABLE `blog_articles` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `blog_category_id` bigint UNSIGNED NOT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `blog_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `blog_comments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `blog_article_id` bigint UNSIGNED NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `captcha_providers`
--

CREATE TABLE `captcha_providers` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Disabled 1:Enabled',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:No 1:Yes',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `captcha_providers`
--

INSERT INTO `captcha_providers` (`id`, `name`, `alias`, `logo`, `settings`, `instructions`, `status`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'Google reCAPTCHA', 'google_recaptcha', 'images/captcha-providers/google-recaptcha.png', '{\"site_key\":null,\"secret_key\":null}', NULL, 0, 1, '2024-06-29 19:15:34', '2024-09-30 17:26:35'),
(2, 'hCaptcha', 'hcaptcha', 'images/captcha-providers/hcaptcha.png', '{\"site_key\":null,\"secret_key\":null}', NULL, 0, 0, '2024-06-29 19:15:34', '2024-06-29 17:01:25'),
(3, 'Cloudflare Turnstile', 'cloudflare_turnstile', 'images/captcha-providers/cloudflare-turnstile.png', '{\"site_key\":null,\"secret_key\":null}', NULL, 0, 0, '2024-06-29 19:15:34', '2024-07-02 19:25:39');

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

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` bigint UNSIGNED NOT NULL,
  `session_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `license_type` tinyint NOT NULL DEFAULT '1' COMMENT '1:Regular 2:Extended',
  `quantity` int UNSIGNED NOT NULL DEFAULT '1',
  `support_period_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:File With Preview Image  2:File With Video Preview  3:File With Audio Preview',
  `views` bigint NOT NULL DEFAULT '0',
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `title`, `description`, `file_type`, `views`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, 'Themes', 'themes', NULL, NULL, 1, 4, 1, '2024-05-26 08:12:08', '2024-09-29 15:05:00'),
(2, 'Code', 'code', NULL, NULL, 1, 2, 2, '2024-05-26 08:12:15', '2024-09-29 15:05:00'),
(4, 'Graphics', 'graphics', NULL, NULL, 1, 1, 6, '2024-05-26 08:12:32', '2024-09-29 15:05:00'),
(5, 'Mobile', 'mobile', NULL, NULL, 1, 1, 7, '2024-05-26 08:12:39', '2024-09-29 15:05:00'),
(6, 'Video', 'video', NULL, NULL, 2, 1, 3, '2024-09-20 23:52:51', '2024-09-29 15:05:00'),
(7, 'Audio', 'audio', NULL, NULL, 3, 1, 4, '2024-09-20 23:52:59', '2024-09-29 15:05:00');

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

--
-- Table structure for table `category_options`
--

CREATE TABLE `category_options` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `type` tinyint NOT NULL COMMENT '1:Single Select 2:Multiple Select',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT '1',
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_options`
--

INSERT INTO `category_options` (`id`, `category_id`, `type`, `name`, `options`, `is_required`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 1, '2024-06-05 17:58:08', '2024-06-05 18:01:20'),
(2, 1, 2, 'Compatible Browsers', '[\"Firefox\",\"Chrome\",\"Safari\",\"Opera\",\"Edge\"]', 1, 2, '2024-06-05 17:58:49', '2024-06-05 18:01:20'),
(3, 1, 2, 'Files Included', '[\"HTML Files\",\"JavaScript\",\"CSS\",\"XML\",\"LESS\",\"Sass\",\"PSD\",\"PHP\",\"SQL\"]', 1, 3, '2024-06-05 18:00:17', '2024-06-05 18:01:21'),
(4, 1, 2, 'Frameworks', '[\"React\",\"Vue\",\"Angular\",\"Next JS\"]', 0, 4, '2024-06-05 18:00:17', '2024-06-05 18:01:21'),
(5, 2, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 5, '2024-06-05 17:58:08', '2024-06-05 18:01:20'),
(6, 2, 2, 'Compatible Browsers', '[\"Firefox\",\"Chrome\",\"Safari\",\"Opera\",\"Edge\"]', 1, 6, '2024-06-05 17:58:49', '2024-06-05 18:01:20'),
(7, 2, 2, 'Files Included', '[\"HTML Files\",\"JavaScript\",\"CSS\",\"XML\",\"LESS\",\"Sass\",\"PSD\",\"PHP\",\"SQL\"]', 1, 6, '2024-06-05 18:00:17', '2024-06-05 18:01:21'),
(8, 2, 2, 'Frameworks', '[\"React\",\"Vue\",\"Angular\",\"Next JS\",\"Laravel\",\"Codeigniter\",\"Cake PHP\",\"Yii\"]', 0, 8, '2024-06-05 18:00:17', '2024-06-05 18:03:21'),
(11, 4, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 11, '2024-06-05 17:58:08', '2024-06-05 18:01:20'),
(12, 4, 2, 'Files Included', '[\"PSD Files\", \"PNG File\", \"JPEG Files\"]', 0, 12, '2024-06-05 18:00:17', '2024-06-05 18:01:21'),
(13, 5, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 13, '2024-06-05 17:58:08', '2024-06-05 18:01:20'),
(14, 6, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 13, '2024-06-05 17:58:08', '2024-06-05 18:01:20'),
(15, 7, 1, 'High Resolution', '[\"Yes\",\"No\"]', 1, 13, '2024-06-05 17:58:08', '2024-06-05 18:01:20');

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

--
-- Table structure for table `extensions`
--

CREATE TABLE `extensions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Disabled 1:Enabled',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `extensions`
--

INSERT INTO `extensions` (`id`, `name`, `alias`, `logo`, `settings`, `instructions`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Google Analytics 4', 'google_analytics', 'images/extensions/google-analytics.png', '{\"measurement_id\":null}', '<ul class=\"mb-0\"> \n<li>Enter google analytics 4 measurement ID, like <strong>G-12345ABC</strong></li> \n</ul>', 0, '2022-02-23 19:40:12', '2023-08-02 15:31:49'),
(3, 'Tawk.to', 'tawk_to', 'images/extensions/tawk-to.png', '{\"api_key\":null}', '<ul class=\"mb-0\"> \r\n<li>https://tawk.to/chat/<strong>API-KEY</strong></li> \r\n</ul>', 0, '2022-02-23 19:40:12', '2023-08-02 15:33:08'),
(4, 'Imgur', 'imgur', 'images/extensions/imgur.png', '{\"client_id\":null}', '<ul class=\"mb-0\"> \r\n<li class=\"mb-2\">Imgur API used to upload images from editors all over the website, this is required for the upload function to work.</li>\r\n<li>Get your client id from:\r\n<a href=\"https://api.imgur.com/oauth2/addclient\" traget=\"_blank\">https://api.imgur.com/oauth2/addclient</a>\r\n</li> \r\n</ul>', 0, '2022-02-23 19:40:12', '2024-09-30 17:26:23'),
(5, 'Trustip', 'trustip', 'images/extensions/trustip.png', '{\"api_key\":null}', '<ul class=\"mb-0\"> \r\n<li class=\"mb-2\">Trustip is used to block people who uses VPN, Proxy, etc from registering or purchasing from the marketplace.</li>\r\n<li>Get your api key from:\r\n<a href=\"https://trustip.io\" traget=\"_blank\">https://trustip.io</a>\r\n</li> \r\n</ul>', 0, '2022-02-23 19:40:12', '2024-06-14 13:34:40');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `favorites`
--

CREATE TABLE `favorites` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `footer_links`
--

CREATE TABLE `footer_links` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:Internal 2:External',
  `parent_id` bigint UNSIGNED DEFAULT NULL,
  `order` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer_links`
--

INSERT INTO `footer_links` (`id`, `name`, `link`, `link_type`, `parent_id`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Company', '/page-example', 1, NULL, 1, '2023-02-05 14:20:43', '2024-05-03 20:06:33'),
(2, 'About Us', '/page-example', 1, 1, 1, '2023-02-05 14:21:04', '2024-05-03 20:10:00'),
(3, 'Careers', '/page-example', 1, 1, 2, '2023-02-05 14:21:21', '2023-02-05 14:32:58'),
(4, 'Legal', '/page-example', 1, NULL, 2, '2023-02-05 14:21:53', '2023-02-05 14:33:43'),
(5, 'Privacy policy', '/privacy-policy', 1, 4, 1, '2023-02-05 14:22:03', '2023-02-10 17:47:39'),
(6, 'Terms of use', '/terms-of-use', 1, 4, 2, '2023-02-05 14:22:16', '2023-02-10 17:47:48'),
(7, 'Copyright Policy', '/page-example', 1, 4, 4, '2023-02-05 14:22:27', '2023-02-05 14:34:26'),
(8, 'Contact Us', '/contact-us', 1, 1, 3, '2023-02-05 14:22:53', '2024-05-26 18:12:11'),
(10, 'Press Room', '/page-example', 1, 1, 4, '2023-02-05 14:33:25', '2023-02-05 14:33:33'),
(11, 'Cookies Policy', '/page-example', 1, 4, 3, '2023-02-05 14:34:06', '2023-02-05 14:34:11'),
(12, 'Support', '/page-example', 1, NULL, 3, '2023-02-05 14:34:49', '2023-02-05 14:35:22'),
(13, 'Help Center', '/page-example', 1, 12, 1, '2023-02-05 14:35:02', '2023-02-05 14:35:22'),
(14, 'Customer Service', '/page-example', 1, 12, 2, '2023-02-05 14:35:12', '2023-02-05 14:35:22'),
(15, 'Frequently Asked Questions', '/page-example', 1, 12, 3, '2023-02-05 14:35:28', '2023-02-05 14:35:33'),
(16, 'Report a Problem', '/page-example', 1, 12, 4, '2023-02-05 14:35:49', '2023-02-05 14:35:53');

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

--
-- Table structure for table `home_categories`
--

CREATE TABLE `home_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_categories`
--

INSERT INTO `home_categories` (`id`, `name`, `icon`, `link`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, 'WordPress Themes', 'images/home-categories/s4g5e72MsulCsVZ_1727640425.png', '/categories/themes/wordpress', 1, '2024-03-06 09:34:53', '2024-09-29 15:07:05'),
(2, 'PHP Scripts', 'images/home-categories/xrbi7rzfCG8Tb2x_1727640430.png', '/categories/code/php-scripts', 2, '2024-03-06 09:35:24', '2024-09-29 15:07:10'),
(3, 'HTML5 Themes', 'images/home-categories/pXZIIP6eROIcVHH_1727640434.png', '/categories/themes/html-css', 3, '2024-03-06 09:36:11', '2024-09-29 15:07:14'),
(4, 'CSS Themes', 'images/home-categories/1meET6ZssslU1bW_1727640440.png', '/categories/themes/html-css', 4, '2024-03-06 09:36:40', '2024-09-29 15:07:20'),
(5, 'Android Apps', 'images/home-categories/5jHgGxfYcXxmk0k_1727640456.png', '/categories/mobile/android', 7, '2024-03-06 09:37:31', '2024-09-29 15:07:36'),
(6, 'IOS Apps', 'images/home-categories/2k2yVqCNx1KmCJ9_1727640461.png', '/categories/mobile/ios', 8, '2024-03-06 09:37:41', '2024-09-29 15:07:41'),
(8, 'Video Graphics', 'images/home-categories/S9Q2fOwSm92Y6BI_1727640446.png', '/categories/video', 5, '2024-09-23 00:31:12', '2024-09-29 15:07:26'),
(9, 'Sound Effects', 'images/home-categories/eVSWVkKy3YSRS2u_1727640451.png', '/categories/audio/sound-effects', 6, '2024-09-23 00:33:20', '2024-09-29 15:07:31');

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

--
-- Table structure for table `home_sections`
--

CREATE TABLE `home_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `items_number` int DEFAULT NULL,
  `cache_expiry_time` int UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `sort_id` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_sections`
--

INSERT INTO `home_sections` (`id`, `name`, `alias`, `description`, `items_number`, `cache_expiry_time`, `status`, `sort_id`) VALUES
(1, NULL, 'categories', NULL, NULL, 10, 1, 1),
(2, 'Trending Items', 'trending_items', NULL, 4, 1440, 1, 2),
(3, 'Best Selling Items', 'best_selling_items', NULL, 4, 1440, 1, 3),
(4, 'Sale Items', 'sale_items', NULL, 4, 1440, 1, 4),
(5, 'Free Items', 'free_items', NULL, 4, 1440, 1, 5),
(6, 'Our Latest Items', 'latest_items', 'Explore our latest digital offerings, including PHP scripts, templates, and plugins. Stay updated with our newest arrivals, designed to enhance your web projects with cutting-edge functionality and innovation.', 8, 60, 1, 7),
(7, 'FAQ\'s', 'faqs', 'Got questions? We\'ve got answers. Delve into our Frequently Asked Questions (FAQs) section to find comprehensive information about our items, services, and more.', NULL, 30, 1, 9),
(8, 'Testimonials', 'testimonials', 'Discover what our valued clients are saying about their experiences with us.', NULL, 1440, 1, 10),
(9, 'Latest Blog Posts', 'blog_articles', 'Stay informed and inspired with our latest blog posts. Dive into a treasure trove of articles covering a diverse range of topics, from expert insights to practical tips.', 6, 1440, 1, 11),
(12, 'Featured Items', 'featured_items', 'Each week, our team carefully selects the finest new themes, scripts, and plugins from our extensive library.', 4, 1440, 1, 8),
(13, 'Premium Items', 'premium_items', NULL, 4, 1440, 1, 6);

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `sub_category_id` bigint UNSIGNED DEFAULT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `demo_type` enum('embed','direct') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `demo_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview_type` enum('image','video','audio') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image',
  `preview_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview_audio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `main_file_source` enum('upload','external') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'upload',
  `screenshots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_price` bigint UNSIGNED DEFAULT NULL,
  `extended_price` bigint UNSIGNED DEFAULT NULL,
  `is_supported` tinyint(1) NOT NULL DEFAULT '0',
  `support_instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `purchase_method` tinyint DEFAULT '1',
  `purchase_url` text COLLATE utf8mb4_unicode_ci,
  `total_sales` bigint UNSIGNED NOT NULL DEFAULT '0',
  `total_sales_amount` double(18,2) NOT NULL DEFAULT '0.00',
  `total_reviews` bigint UNSIGNED NOT NULL DEFAULT '0',
  `avg_reviews` bigint UNSIGNED NOT NULL DEFAULT '0',
  `total_comments` bigint UNSIGNED NOT NULL DEFAULT '0',
  `total_views` bigint UNSIGNED NOT NULL DEFAULT '0',
  `current_month_views` bigint UNSIGNED NOT NULL DEFAULT '0',
  `free_downloads` bigint UNSIGNED NOT NULL DEFAULT '0',
  `is_premium` tinyint(1) NOT NULL DEFAULT '0',
  `is_free` tinyint(1) NOT NULL DEFAULT '0',
  `is_trending` tinyint(1) NOT NULL DEFAULT '0',
  `is_best_selling` tinyint(1) NOT NULL DEFAULT '0',
  `is_on_discount` tinyint(1) NOT NULL DEFAULT '0',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `last_update_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_change_logs`
--

CREATE TABLE `item_change_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_comments`
--

CREATE TABLE `item_comments` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_comment_replies`
--

CREATE TABLE `item_comment_replies` (
  `id` bigint UNSIGNED NOT NULL,
  `item_comment_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_comment_reports`
--

CREATE TABLE `item_comment_reports` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `item_comment_reply_id` bigint UNSIGNED NOT NULL,
  `reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_discounts`
--

CREATE TABLE `item_discounts` (
  `id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `regular_percentage` int UNSIGNED NOT NULL,
  `regular_price` bigint NOT NULL,
  `extended_percentage` int UNSIGNED DEFAULT NULL,
  `extended_price` bigint DEFAULT NULL,
  `starting_at` date NOT NULL,
  `ending_at` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_reviews`
--

CREATE TABLE `item_reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `stars` int NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_review_replies`
--

CREATE TABLE `item_review_replies` (
  `id` bigint UNSIGNED NOT NULL,
  `item_review_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `item_views`
--

CREATE TABLE `item_views` (
  `id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `referrer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `kyc_verifications`
--

CREATE TABLE `kyc_verifications` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `document_type` enum('national_id','passport') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `documents` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Pending 2:Approved 3:Rejected',
  `rejection_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mail_templates`
--

CREATE TABLE `mail_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shortcodes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(5, '2014_10_12_100000_create_password_resets_table', 5),
(11, '2021_10_04_213420_create_pages_table', 11),
(15, '2021_10_07_221832_create_settings_table', 15),
(17, '2022_02_23_213634_create_extensions_table', 17),
(18, '2022_04_03_220038_create_mail_templates_table', 18),
(19, '2023_07_30_152852_create_oauth_providers_table', 19),
(20, '2023_09_17_154715_create_payment_gateways_table', 20),
(21, '2023_09_26_125948_create_themes_table', 21),
(22, '2023_10_01_131610_create_addons_table', 22),
(45, '2019_12_14_000001_create_personal_access_tokens_table', 45),
(47, '2021_10_06_201713_create_blog_categories_table', 46),
(48, '2021_10_06_201752_create_blog_articles_table', 46),
(55, '2021_10_28_191044_create_storage_providers_table', 49),
(57, '2023_11_22_173153_create_faqs_table', 51),
(58, '2023_11_22_182033_create_testimonials_table', 52),
(64, '2023_12_15_151129_create_home_categories_table', 54),
(95, '2024_03_13_165718_create_home_sections_table', 60),
(126, '2024_04_16_191052_create_ads_table', 68),
(148, '2024_05_03_174916_create_jobs_table', 77),
(149, '2024_05_03_183505_create_failed_jobs_table', 78),
(160, '2024_05_15_205642_create_translates_table', 84),
(172, '2024_06_29_151017_create_captcha_providers_table', 88),
(174, '2024_07_09_110258_create_support_periods_table', 89),
(184, '2024_09_03_111407_create_plans_table', 94),
(190, '2014_10_12_000000_create_users_table', 95),
(191, '2014_10_12_300000_create_user_login_logs_table', 95),
(192, '2021_10_06_202153_create_blog_comments_table', 95),
(193, '2023_12_10_172652_create_navbar_links_table', 95),
(194, '2023_12_10_172728_create_footer_links_table', 95),
(195, '2023_12_13_172603_create_categories_table', 95),
(196, '2023_12_13_173552_create_sub_categories_table', 95),
(197, '2023_12_21_135143_create_category_options_table', 95),
(199, '2024_01_03_003738_create_items_table', 96),
(200, '2024_03_09_193935_create_item_discounts_table', 96),
(201, '2024_03_19_171106_create_cart_items_table', 96),
(202, '2024_03_21_025080_create_sales_table', 97),
(203, '2024_03_21_025090_create_purchases_table', 97),
(204, '2024_03_21_025100_create_transactions_table', 97),
(205, '2024_03_21_050420_create_transaction_items_table', 97),
(210, '2024_04_04_223335_create_item_views_table', 97),
(211, '2024_04_20_185430_create_statements_table', 97),
(212, '2024_04_23_173759_create_favorites_table', 97),
(215, '2024_05_04_210907_create_ticket_categories_table', 97),
(216, '2024_05_06_170025_create_tickets_table', 97),
(219, '2024_05_30_163150_create_taxes_table', 97),
(220, '2024_06_21_191033_create_item_change_logs_table', 97),
(221, '2024_07_10_105956_create_support_earnings_table', 97),
(223, '2024_09_09_152943_create_subscriptions_table', 97),
(224, '2024_09_12_002743_create_premium_earnings_table', 97),
(225, '2024_02_24_162334_create_kyc_verifications_table', 98),
(226, '2023_12_29_155557_create_uploaded_files_table', 99),
(227, '2024_09_23_213245_create_newsletter_subscribers_table', 100),
(228, '2024_04_01_235823_create_item_reviews_table', 101),
(230, '2024_04_04_223313_create_item_comments_table', 101),
(231, '2024_04_04_223335_create_item_comment_replies_table', 101),
(232, '2024_04_24_192449_create_refunds_table', 101),
(233, '2024_04_24_192550_create_refund_replies_table', 101),
(234, '2024_05_07_171258_create_ticket_replies_table', 101),
(235, '2024_05_07_171419_create_ticket_reply_attachments_table', 101),
(236, '2024_08_24_114518_create_item_comment_reports_table', 101),
(237, '2014_10_11_1000000_create_admin_notifications_table', 102),
(238, '2024_04_01_235824_create_item_review_replies_table', 103);

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

--
-- Table structure for table `navbar_links`
--

CREATE TABLE `navbar_links` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_type` tinyint NOT NULL DEFAULT '1',
  `parent_id` bigint UNSIGNED DEFAULT NULL,
  `order` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `navbar_links`
--

INSERT INTO `navbar_links` (`id`, `name`, `link`, `link_type`, `parent_id`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Home', '/', 1, NULL, 1, '2024-05-25 18:29:21', '2024-05-25 18:29:21'),
(2, 'WordPress', '/categories/themes/wordpress', 1, 17, 1, '2024-05-25 18:30:14', '2024-05-26 08:35:13'),
(5, 'Code', '/categories/code', 1, NULL, 3, '2024-05-25 18:31:00', '2024-09-27 18:08:16'),
(8, 'Help & Support', '/categories/php-scripts/help-support', 1, 5, 3, '2024-05-25 18:32:55', '2024-09-27 18:09:54'),
(9, 'Add-ons', '/categories/php-scripts/add-ons', 1, 5, 1, '2024-05-25 18:33:17', '2024-09-27 18:09:54'),
(11, 'Graphics', '/categories/graphics', 1, NULL, 6, '2024-05-25 18:37:06', '2024-09-27 18:08:34'),
(12, 'Icons', '/categories/graphics/icons', 1, 11, 1, '2024-05-25 18:37:15', '2024-05-26 08:38:39'),
(13, 'PSD Files', '/categories/graphics/psd-files', 1, 11, 2, '2024-05-25 18:37:28', '2024-05-26 08:38:48'),
(14, 'Mobile', '/categories/mobile', 1, NULL, 7, '2024-05-25 18:37:47', '2024-09-27 18:08:34'),
(15, 'IOS', '/categories/mobile/ios', 1, 14, 1, '2024-05-25 18:37:56', '2024-05-26 08:39:08'),
(16, 'Android', '/categories/mobile/android', 1, 14, 2, '2024-05-25 18:38:09', '2024-05-26 08:39:20'),
(17, 'Themes', '/categories/themes', 1, NULL, 2, '2024-05-25 18:38:45', '2024-05-26 08:35:02'),
(18, 'HTML & CSS', '/categories/themes/html-css', 1, 17, 2, '2024-05-25 18:39:04', '2024-05-26 08:35:22'),
(19, 'Bootstrap', '/categories/themes/bootstrap', 1, 17, 3, '2024-05-25 18:39:35', '2024-05-26 08:35:31'),
(23, 'Video', '/categories/video', 1, NULL, 4, '2024-09-20 23:57:58', '2024-09-21 00:00:03'),
(24, 'Illustrations', '/categories/video/illustrations', 1, 23, 1, '2024-09-20 23:58:29', '2024-09-20 23:58:55'),
(25, 'Effects', '/categories/video/effects', 1, 23, 2, '2024-09-20 23:58:52', '2024-09-20 23:58:57'),
(26, 'Audio', '/categories/audio', 1, NULL, 5, '2024-09-20 23:59:14', '2024-09-21 00:00:07'),
(27, 'Music', '/categories/audio/music', 1, 26, 1, '2024-09-20 23:59:40', '2024-09-20 23:59:58'),
(28, 'Sound Effects', '/categories/audio/sound-effects', 1, 26, 2, '2024-09-20 23:59:55', '2024-09-20 23:59:59'),
(29, 'PHP Scripts', '/categories/code/php-scripts', 1, 5, 2, '2024-09-27 18:08:30', '2024-09-27 18:09:54');

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

--
-- Table structure for table `newsletter_subscribers`
--

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

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

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

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `title`, `slug`, `body`, `short_description`, `views`, `created_at`, `updated_at`) VALUES
(2, 'Privacy policy', 'privacy-policy', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 59, '2024-03-05 20:19:14', '2024-09-29 15:05:00'),
(3, 'Terms of use', 'terms-of-use', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 55, '2024-03-05 20:19:38', '2024-09-29 15:05:00'),
(4, 'Refund policy', 'refund-policy', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 68, '2024-03-05 20:19:58', '2024-09-11 01:15:23'),
(5, 'Page Example', 'page-example', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 22, '2024-03-05 20:20:33', '2024-09-29 15:05:00'),
(6, 'Licenses Terms', 'licenses-terms', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 13, '2024-03-17 22:45:16', '2024-09-29 15:05:01'),
(9, 'Free Items Policy', 'free-items-policy', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 3, '2024-06-01 13:39:34', '2024-09-29 15:05:01'),
(10, 'Premium Terms', 'premium-terms', '<p><strong>What is Lorem Ipsum?</strong></p><p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Where does it come from?</strong></p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p><p><strong>Why do we use it?</strong></p><p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><strong>Where can I get some?</strong></p><p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 2, '2024-09-11 00:15:04', '2024-09-25 10:26:50');

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

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

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

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

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

CREATE TABLE `plans` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interval` enum('week','month','year','lifetime') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(18,2) DEFAULT NULL,
  `author_earning_percentage` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `downloads` bigint UNSIGNED DEFAULT NULL,
  `custom_features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `sort_id` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `premium_earnings`
--

CREATE TABLE `premium_earnings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(18,2) NOT NULL,
  `tax` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `total` double(18,2) NOT NULL,
  `subscription_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `sale_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `license_type` tinyint NOT NULL COMMENT '1:Regular 2:Extended',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `support_expiry_at` datetime DEFAULT NULL,
  `is_downloaded` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Active 2:Refunded 3:Cancelled',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refunds`
--

CREATE TABLE `refunds` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `purchase_id` bigint UNSIGNED NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Pending 2:Accepted 3:Declined',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refund_replies`
--

CREATE TABLE `refund_replies` (
  `id` bigint UNSIGNED NOT NULL,
  `refund_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED NOT NULL,
  `license_type` tinyint NOT NULL COMMENT '1:Regular 2:Extended',
  `price` double(18,2) NOT NULL,
  `tax` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `total` double(18,2) NOT NULL,
  `country` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Active 2:Refunded 3:Cancelled',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `key`, `value`) VALUES
(1, 'general', '{\"site_name\":\"Codebob\",\"site_url\":\"http:\\/\\/codebob.viro.com\",\"date_format\":\"10\",\"timezone\":\"America\\/New_York\",\"contact_email\":\""}'),
(2, 'smtp', '{\"status\":0,\"mailer\":\"smtp\",\"host\":null,\"port\":null,\"username\":null,\"password\":null,\"encryption\":\"tls\",\"from_email\":null,\"from_name\":null}'),
(3, 'actions', '{\"registration\":1,\"email_verification\":0,\"gdpr_cookie\":1,\"force_ssl\":0,\"blog\":1,\"tickets\":1,\"refunds\":1,\"contact_page\":0}'),
(4, 'currency', '{\"code\":\"USD\",\"symbol\":\"$\",\"position\":\"1\"}'),
(5, 'deposit', '{\"status\":1,\"minimum\":\"10\",\"maximum\":\"1000\"}'),
(6, 'seo', '{\"title\":\"Single-Vendor Digital Marketplace\",\"description\":\"WordPress Templates, Plugins, PHP Scripts, and Graphics Digital Marketplace\",\"keywords\":\"JavaScript, PHP Scripts, CSS, HTML5, Site Templates, WordPress Themes, Plugins, Mobile Apps, Graphics, Prints, Brochures, Flyers, Resumes,\"}'),
(7, 'system_admin', '{\"colors\":{\"primary_color\":\"#1363DF\",\"secondary_color\":\"#1d2734\",\"background_color\":\"#f9fafb\",\"sidebar_background_color\":\"#1d2734\",\"navbar_background_color\":\"#ffffff\"}}'),
(9, 'kyc', '{\"status\":1,\"selfie_verification\":1,\"required\":0,\"id_front_image\":\"images\\/kyc\\/F6uxReOavrBbRnr_1708719956.svg\",\"id_back_image\":\"images\\/kyc\\/lDNgqlaFCClbRaA_1708720002.svg\",\"passport_image\":\"images\\/kyc\\/QLEDc8sXn6h2e7E_1708729601.svg\",\"selfie_image\":\"images\\/kyc\\/5CwgvmI9gcd067i_1708720379.svg\"}'),
(10, 'item', '{\"buy_now_button\":1,\"item_total_sales\":1,\"free_item_total_downloads\":1,\"reviews_status\":1,\"comments_status\":1,\"support_status\":1,\"changelogs_status\":1,\"free_items_require_login\":0,\"trending_number\":\"20\",\"best_selling_number\":\"20\",\"convert_images_webp\":\"1\",\"file_duration\":\"24\"}'),
(13, 'language', '{\"code\":\"en\",\"direction\":\"ltr\"}'),
(14, 'links', '{\"terms_of_use_link\":\"\\/terms-of-use\",\"licenses_terms_link\":\"\\/licenses-terms\",\"free_items_policy\":\"\\/free-items-policy\"}'),
(15, 'announcement', '{\"body\":\"Unlocking Joy: 50% Off On WordPress Themes\",\"button_title\":\"Get It Now >>\",\"button_link\":\"\\/\",\"background_color\":\"#65c22b\",\"button_background_color\":\"#ffffff\",\"button_text_color\":\"#65c22b\",\"status\":1}'),
(17, 'cronjob', '{\"key\":\"\",\"last_execution\":\"\"}'),
(18, 'ticket', '{\"file_types\":\"jpeg,jpg,png,pdf\",\"max_files\":\"5\",\"max_file_size\":\"10\"}'),
(19, 'maintenance', '{\"status\":0,\"title\":\"Under Maintenance\",\"body\":\"Our site is currently undergoing scheduled maintenance to enhance your browsing experience. We apologize for any inconvenience and appreciate your patience. Please check back soon!\",\"password\":\"",\"image\":\"images\\/maintenance\\/rrKIohOTdb7fyo5_1727390834.jpg\"}'),
(21, 'social_links', '{\"facebook\":\"\\/\",\"x\":\"\\/\",\"youtube\":\"\\/\",\"linkedin\":\"\\/\",\"instagram\":\"\\/\",\"pinterest\":\"\\/\"}'),
(24, 'premium', '{\"status\":1,\"terms_link\":\"\\/premium-terms\"}'),
(25, 'newsletter', '{\"status\":1,\"popup_status\":0,\"footer_status\":1,\"register_new_users\":1,\"popup_image\":\"images\\/newsletter\\/lezCcElE6YTIcaZ_1727215505.jpg\",\"popup_reminder_time\":\"24\"}'),
(26, 'api', '{\"status\":0,\"key\":null}');

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

--
-- Table structure for table `statements`
--

CREATE TABLE `statements` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(18,2) NOT NULL,
  `type` tinyint NOT NULL COMMENT '1:credit 2:debit',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `plan_id` bigint UNSIGNED NOT NULL,
  `total_downloads` bigint UNSIGNED NOT NULL DEFAULT '0',
  `expiry_at` datetime DEFAULT NULL,
  `last_notification_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `name`, `slug`, `title`, `description`, `category_id`, `views`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, 'WordPress', 'wordpress', NULL, NULL, 1, 5, 1, '2024-05-26 08:12:57', '2024-09-29 15:04:59'),
(2, 'HTML & CSS', 'html-css', NULL, NULL, 1, 3, 2, '2024-05-26 08:13:06', '2024-09-29 15:04:59'),
(3, 'Bootstrap', 'bootstrap', NULL, NULL, 1, 1, 3, '2024-05-26 08:13:13', '2024-09-29 15:04:59'),
(4, 'Add-ons', 'add-ons', NULL, NULL, 2, 2, 4, '2024-05-26 08:13:27', '2024-09-29 15:05:01'),
(7, 'Help & Support', 'help-support', NULL, NULL, 2, 1, 6, '2024-05-26 08:13:55', '2024-09-29 15:05:01'),
(10, 'Icons', 'icons', NULL, NULL, 4, 1, 7, '2024-05-26 08:14:33', '2024-09-29 15:05:00'),
(11, 'PSD Files', 'psd-files', NULL, NULL, 4, 1, 8, '2024-05-26 08:14:40', '2024-09-29 15:05:00'),
(12, 'IOS', 'ios', NULL, NULL, 5, 3, 9, '2024-05-26 08:14:50', '2024-09-29 15:05:00'),
(13, 'Android', 'android', NULL, NULL, 5, 2, 10, '2024-05-26 08:14:57', '2024-09-29 15:05:00'),
(14, 'Effects', 'effects', NULL, NULL, 6, 1, 12, '2024-09-20 23:55:26', '2024-09-29 15:04:59'),
(15, 'Illustrations', 'illustrations', NULL, NULL, 6, 2, 11, '2024-09-20 23:55:37', '2024-09-29 15:04:59'),
(16, 'Music', 'music', NULL, NULL, 7, 1, 13, '2024-09-20 23:55:54', '2024-09-29 15:04:59'),
(17, 'Sound Effects', 'sound-effects', NULL, NULL, 7, 2, 14, '2024-09-20 23:56:03', '2024-09-29 15:05:00'),
(18, 'PHP Scripts', 'php-scripts', NULL, NULL, 2, 2, 5, '2024-09-27 18:07:32', '2024-09-29 15:04:59');

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

--
-- Table structure for table `support_earnings`
--

CREATE TABLE `support_earnings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `days` bigint UNSIGNED NOT NULL,
  `price` double(18,2) NOT NULL,
  `tax` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `total` double(18,2) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Active 2:Refunded 3:Cancelled',
  `support_expiry_at` datetime NOT NULL,
  `purchase_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_periods`
--

CREATE TABLE `support_periods` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `days` bigint UNSIGNED NOT NULL,
  `percentage` int UNSIGNED NOT NULL DEFAULT '0',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_periods`
--

INSERT INTO `support_periods` (`id`, `name`, `title`, `days`, `percentage`, `is_default`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, '6 months', '6 months of support', 182, 0, 1, 0, '2024-07-09 13:46:39', '2024-07-09 17:43:11'),
(2, '12 months', '12 months of support', 365, 11, 0, 0, '2024-07-09 13:47:00', '2024-07-09 17:43:11');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` int UNSIGNED NOT NULL,
  `countries` json NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stars` int UNSIGNED NOT NULL DEFAULT '5',
  `sort_id` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `preview_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `alias`, `version`, `preview_image`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Basic', 'basic', '1.0', 'themes/basic/images/preview.jpg', 'Basic theme offers a sleek and modern design, prioritizing user-friendly navigation and aesthetics. ', '2023-09-29 22:14:13', '2023-09-29 22:14:17');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `ticket_category_id` bigint UNSIGNED NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1:Opened 2:Closed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ticket_categories`
--

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

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

--
-- Table structure for table `ticket_replies`
--

CREATE TABLE `ticket_replies` (
  `id` bigint UNSIGNED NOT NULL,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `ticket_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ticket_reply_attachments`
--

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

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

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

CREATE TABLE `transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `amount` double(18,2) NOT NULL,
  `fees` double(18,2) NOT NULL DEFAULT '0.00',
  `tax` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `total` double(18,2) NOT NULL,
  `payment_gateway_id` bigint UNSIGNED DEFAULT NULL,
  `payment_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_proof` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('purchase','support_purchase','support_extend','deposit','subscription') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `support` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `purchase_id` bigint UNSIGNED DEFAULT NULL,
  `plan_id` bigint UNSIGNED DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0:Unpaid 1:Pending 2:Paid 3:Cancelled',
  `cancellation_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transaction_items`
--

CREATE TABLE `transaction_items` (
  `id` bigint UNSIGNED NOT NULL,
  `transaction_id` bigint UNSIGNED NOT NULL,
  `item_id` bigint UNSIGNED DEFAULT NULL,
  `license_type` tinyint NOT NULL DEFAULT '1' COMMENT '1:Regular 2:Extended',
  `price` double(18,2) NOT NULL,
  `quantity` int UNSIGNED NOT NULL DEFAULT '1',
  `total` double(8,2) NOT NULL,
  `support` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `translates`
--

CREATE TABLE `translates` (
  `id` bigint UNSIGNED NOT NULL,
  `key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `translates`
--

INSERT INTO `translates` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'The :attribute field must be accepted.', 'The :attribute field must be accepted.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(2, 'The :attribute field must be accepted when :other is :value.', 'The :attribute field must be accepted when :other is :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(3, 'The :attribute field must be a valid URL.', 'The :attribute field must be a valid URL.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(4, 'The :attribute field must be a date after :date.', 'The :attribute field must be a date after :date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(5, 'The :attribute field must be a date after or equal to :date.', 'The :attribute field must be a date after or equal to :date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(6, 'The :attribute field must only contain letters.', 'The :attribute field must only contain letters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(7, 'The :attribute field must only contain letters, numbers, dashes, and underscores.', 'The :attribute field must only contain letters, numbers, dashes, and underscores.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(8, 'The :attribute field must only contain letters and numbers.', 'The :attribute field must only contain letters and numbers.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(9, 'The :attribute field must be an array.', 'The :attribute field must be an array.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(10, 'The :attribute field must only contain single-byte alphanumeric characters and symbols.', 'The :attribute field must only contain single-byte alphanumeric characters and symbols.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(11, 'The :attribute field must be a date before :date.', 'The :attribute field must be a date before :date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(12, 'The :attribute field must be a date before or equal to :date.', 'The :attribute field must be a date before or equal to :date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(13, 'The :attribute field must have between :min and :max items.', 'The :attribute field must have between :min and :max items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(14, 'The :attribute field must be between :min and :max kilobytes.', 'The :attribute field must be between :min and :max kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(15, 'The :attribute field must be between :min and :max.', 'The :attribute field must be between :min and :max.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(16, 'The :attribute field must be between :min and :max characters.', 'The :attribute field must be between :min and :max characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(17, 'The :attribute field must be true or false.', 'The :attribute field must be true or false.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(18, 'The :attribute field contains an unauthorized value.', 'The :attribute field contains an unauthorized value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(19, 'The :attribute field confirmation does not match.', 'The :attribute field confirmation does not match.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(20, 'The password is incorrect.', 'The password is incorrect.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(21, 'The :attribute field must be a valid date.', 'The :attribute field must be a valid date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(22, 'The :attribute field must be a date equal to :date.', 'The :attribute field must be a date equal to :date.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(23, 'The :attribute field must match the format :format.', 'The :attribute field must match the format :format.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(24, 'The :attribute field must have :decimal decimal places.', 'The :attribute field must have :decimal decimal places.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(25, 'The :attribute field must be declined.', 'The :attribute field must be declined.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(26, 'The :attribute field must be declined when :other is :value.', 'The :attribute field must be declined when :other is :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(27, 'The :attribute field and :other must be different.', 'The :attribute field and :other must be different.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(28, 'The :attribute field must be :digits digits.', 'The :attribute field must be :digits digits.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(29, 'The :attribute field must be between :min and :max digits.', 'The :attribute field must be between :min and :max digits.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(30, 'The :attribute field has invalid image dimensions.', 'The :attribute field has invalid image dimensions.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(31, 'The :attribute field has a duplicate value.', 'The :attribute field has a duplicate value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(32, 'The :attribute field must not end with one of the following: :values.', 'The :attribute field must not end with one of the following: :values.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(33, 'The :attribute field must not start with one of the following: :values.', 'The :attribute field must not start with one of the following: :values.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(34, 'The :attribute field must be a valid email address.', 'The :attribute field must be a valid email address.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(35, 'The :attribute field must be a valid username.', 'The :attribute field must be a valid username.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(36, 'The :attribute field must end with one of the following: :values.', 'The :attribute field must end with one of the following: :values.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(37, 'The selected :attribute is invalid.', 'The selected :attribute is invalid.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(38, 'The :attribute field must be a file.', 'The :attribute field must be a file.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(39, 'The :attribute field must have a value.', 'The :attribute field must have a value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(40, 'The :attribute field must have more than :value items.', 'The :attribute field must have more than :value items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(41, 'The :attribute field must be greater than :value kilobytes.', 'The :attribute field must be greater than :value kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(42, 'The :attribute field must be greater than :value.', 'The :attribute field must be greater than :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(43, 'The :attribute field must be greater than :value characters.', 'The :attribute field must be greater than :value characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(44, 'The :attribute field must have :value items or more.', 'The :attribute field must have :value items or more.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(45, 'The :attribute field must be greater than or equal to :value kilobytes.', 'The :attribute field must be greater than or equal to :value kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(46, 'The :attribute field must be greater than or equal to :value.', 'The :attribute field must be greater than or equal to :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(47, 'The :attribute field must be greater than or equal to :value characters.', 'The :attribute field must be greater than or equal to :value characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(48, 'The :attribute field must be an image.', 'The :attribute field must be an image.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(49, 'The :attribute field must exist in :other.', 'The :attribute field must exist in :other.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(50, 'The :attribute field must be an integer.', 'The :attribute field must be an integer.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(51, 'The :attribute field must be a valid IP address.', 'The :attribute field must be a valid IP address.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(52, 'The :attribute field must be a valid IPv4 address.', 'The :attribute field must be a valid IPv4 address.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(53, 'The :attribute field must be a valid IPv6 address.', 'The :attribute field must be a valid IPv6 address.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(54, 'The :attribute field must be a valid JSON string.', 'The :attribute field must be a valid JSON string.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(55, 'The :attribute field must be lowercase.', 'The :attribute field must be lowercase.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(56, 'The :attribute field must have less than :value items.', 'The :attribute field must have less than :value items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(57, 'The :attribute field must be less than :value kilobytes.', 'The :attribute field must be less than :value kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(58, 'The :attribute field must be less than :value.', 'The :attribute field must be less than :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(59, 'The :attribute field must be less than :value characters.', 'The :attribute field must be less than :value characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(60, 'The :attribute field must not have more than :value items.', 'The :attribute field must not have more than :value items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(61, 'The :attribute field must be less than or equal to :value kilobytes.', 'The :attribute field must be less than or equal to :value kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(62, 'The :attribute field must be less than or equal to :value.', 'The :attribute field must be less than or equal to :value.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(63, 'The :attribute field must be less than or equal to :value characters.', 'The :attribute field must be less than or equal to :value characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(64, 'The :attribute field must be a valid MAC address.', 'The :attribute field must be a valid MAC address.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(65, 'The :attribute field must not have more than :max items.', 'The :attribute field must not have more than :max items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(66, 'The :attribute field must not be greater than :max kilobytes.', 'The :attribute field must not be greater than :max kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(67, 'The :attribute field must not be greater than :max.', 'The :attribute field must not be greater than :max.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(68, 'The :attribute field must not be greater than :max characters.', 'The :attribute field must not be greater than :max characters.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(69, 'The :attribute field must not have more than :max digits.', 'The :attribute field must not have more than :max digits.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(70, 'The :attribute field must be a file of type: :values.', 'The :attribute field must be a file of type: :values.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(71, 'The :attribute field must have at least :min items.', 'The :attribute field must have at least :min items.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(72, 'The :attribute field must be at least :min kilobytes.', 'The :attribute field must be at least :min kilobytes.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(73, 'The :attribute field must be at least :min.', 'The :attribute field must be at least :min.', '2024-05-15 19:57:40', '2024-05-15 19:57:40'),
(74, 'The :attribute field must be at least :min characters.', 'The :attribute field must be at least :min characters.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(75, 'The :attribute field must have at least :min digits.', 'The :attribute field must have at least :min digits.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(76, 'The :attribute field must be missing.', 'The :attribute field must be missing.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(77, 'The :attribute field must be missing when :other is :value.', 'The :attribute field must be missing when :other is :value.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(78, 'The :attribute field must be missing unless :other is :value.', 'The :attribute field must be missing unless :other is :value.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(79, 'The :attribute field must be missing when :values is present.', 'The :attribute field must be missing when :values is present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(80, 'The :attribute field must be missing when :values are present.', 'The :attribute field must be missing when :values are present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(81, 'The :attribute field must be a multiple of :value.', 'The :attribute field must be a multiple of :value.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(82, 'The :attribute field format is invalid.', 'The :attribute field format is invalid.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(83, 'The :attribute field must be a number.', 'The :attribute field must be a number.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(84, 'The :attribute field must contain at least one letter.', 'The :attribute field must contain at least one letter.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(85, 'The :attribute field must contain at least one uppercase and one lowercase letter.', 'The :attribute field must contain at least one uppercase and one lowercase letter.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(86, 'The :attribute field must contain at least one number.', 'The :attribute field must contain at least one number.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(87, 'The :attribute field must contain at least one symbol.', 'The :attribute field must contain at least one symbol.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(88, 'The given :attribute has appeared in a data leak. Please choose a different :attribute.', 'The given :attribute has appeared in a data leak. Please choose a different :attribute.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(89, 'The :attribute field must be present.', 'The :attribute field must be present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(90, 'The :attribute field is prohibited.', 'The :attribute field is prohibited.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(91, 'The :attribute field is prohibited when :other is :value.', 'The :attribute field is prohibited when :other is :value.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(92, 'The :attribute field is prohibited unless :other is in :values.', 'The :attribute field is prohibited unless :other is in :values.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(93, 'The :attribute field prohibits :other from being present.', 'The :attribute field prohibits :other from being present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(94, 'The :attribute field is required.', 'The :attribute field is required.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(95, 'The :attribute field must contain entries for: :values.', 'The :attribute field must contain entries for: :values.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(96, 'The :attribute field is required when :other is :value.', 'The :attribute field is required when :other is :value.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(97, 'The :attribute field is required when :other is accepted.', 'The :attribute field is required when :other is accepted.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(98, 'The :attribute field is required unless :other is in :values.', 'The :attribute field is required unless :other is in :values.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(99, 'The :attribute field is required when :values is present.', 'The :attribute field is required when :values is present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(100, 'The :attribute field is required when :values are present.', 'The :attribute field is required when :values are present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(101, 'The :attribute field is required when :values is not present.', 'The :attribute field is required when :values is not present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(102, 'The :attribute field is required when none of :values are present.', 'The :attribute field is required when none of :values are present.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(103, 'The :attribute field must match :other.', 'The :attribute field must match :other.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(104, 'The :attribute field must contain :size items.', 'The :attribute field must contain :size items.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(105, 'The :attribute field must be :size kilobytes.', 'The :attribute field must be :size kilobytes.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(106, 'The :attribute field must be :size.', 'The :attribute field must be :size.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(107, 'The :attribute field must be :size characters.', 'The :attribute field must be :size characters.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(108, 'The :attribute field must start with one of the following: :values.', 'The :attribute field must start with one of the following: :values.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(109, 'The :attribute field must be a string.', 'The :attribute field must be a string.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(110, 'The :attribute field must be a valid timezone.', 'The :attribute field must be a valid timezone.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(111, 'The :attribute has already been taken.', 'The :attribute has already been taken.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(112, 'The :attribute failed to upload.', 'The :attribute failed to upload.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(113, 'The :attribute field must be uppercase.', 'The :attribute field must be uppercase.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(114, 'The :attribute field must be a valid ULID.', 'The :attribute field must be a valid ULID.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(115, 'The :attribute field must be a valid UUID.', 'The :attribute field must be a valid UUID.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(116, 'captcha', 'captcha', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(117, 'terms of service', 'terms of service', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(118, 'Phone number must be a valid 10-digit phone number.', 'Phone number must be a valid 10-digit phone number.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(119, 'The :attribute contains blocked patterns.', 'The :attribute contains blocked patterns.', '2024-05-15 19:57:41', '2024-05-15 19:57:41'),
(120, 'These credentials do not match our records.', 'These credentials do not match our records.', '2024-05-15 19:58:09', '2024-05-16 09:16:16'),
(121, 'The provided password is incorrect.', 'The provided password is incorrect.', '2024-05-15 19:58:09', '2024-05-15 19:58:09'),
(122, 'Too many login attempts. Please try again in :seconds seconds.', 'Too many login attempts. Please try again in :seconds seconds.', '2024-05-15 19:58:09', '2024-05-15 19:58:09'),
(123, 'Your password has been reset!', 'Your password has been reset!', '2024-05-15 19:58:20', '2024-05-15 19:58:20'),
(124, 'We have emailed your password reset link!', 'We have emailed your password reset link!', '2024-05-15 19:58:20', '2024-05-15 19:58:20'),
(125, 'Please wait before retrying.', 'Please wait before retrying.', '2024-05-15 19:58:20', '2024-05-15 19:58:20'),
(126, 'This password reset token is invalid.', 'This password reset token is invalid.', '2024-05-15 19:58:20', '2024-05-15 19:58:20'),
(127, 'We can\'t find a user with that email address.', 'We can\'t find a user with that email address.', '2024-05-15 19:58:20', '2024-05-15 19:58:20'),
(128, 'Previous', 'Previous', '2024-05-15 19:58:30', '2024-05-15 19:58:30'),
(129, 'Next', 'Next', '2024-05-15 19:58:30', '2024-05-15 19:58:30'),
(130, 'Afghanistan', 'Afghanistan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(131, 'Albania', 'Albania', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(132, 'Algeria', 'Algeria', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(133, 'American Samoa', 'American Samoa', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(134, 'Andorra', 'Andorra', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(135, 'Angola', 'Angola', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(136, 'Anguilla', 'Anguilla', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(137, 'Antarctica', 'Antarctica', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(138, 'Antigua and Barbuda', 'Antigua and Barbuda', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(139, 'Argentina', 'Argentina', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(140, 'Armenia', 'Armenia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(141, 'Aruba', 'Aruba', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(142, 'Australia', 'Australia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(143, 'Austria', 'Austria', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(144, 'Azerbaijan', 'Azerbaijan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(145, 'Bahamas', 'Bahamas', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(146, 'Bahrain', 'Bahrain', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(147, 'Bangladesh', 'Bangladesh', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(148, 'Barbados', 'Barbados', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(149, 'Belarus', 'Belarus', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(150, 'Belgium', 'Belgium', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(151, 'Belize', 'Belize', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(152, 'Benin', 'Benin', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(153, 'Bermuda', 'Bermuda', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(154, 'Bhutan', 'Bhutan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(155, 'Bolivia', 'Bolivia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(156, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(157, 'Botswana', 'Botswana', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(158, 'Bouvet Island', 'Bouvet Island', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(159, 'Brazil', 'Brazil', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(160, 'British Antarctic Territory', 'British Antarctic Territory', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(161, 'British Indian Ocean Territory', 'British Indian Ocean Territory', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(162, 'British Virgin Islands', 'British Virgin Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(163, 'Brunei', 'Brunei', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(164, 'Bulgaria', 'Bulgaria', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(165, 'Burkina Faso', 'Burkina Faso', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(166, 'Burundi', 'Burundi', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(167, 'Cambodia', 'Cambodia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(168, 'Cameroon', 'Cameroon', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(169, 'Canada', 'Canada', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(170, 'Canton and Enderbury Islands', 'Canton and Enderbury Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(171, 'Cape Verde', 'Cape Verde', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(172, 'Cayman Islands', 'Cayman Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(173, 'Central African Republic', 'Central African Republic', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(174, 'Chad', 'Chad', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(175, 'Chile', 'Chile', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(176, 'China', 'China', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(177, 'Christmas Island', 'Christmas Island', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(178, 'Cocos [Keeling] Islands', 'Cocos [Keeling] Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(179, 'Colombia', 'Colombia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(180, 'Comoros', 'Comoros', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(181, 'Congo - Brazzaville', 'Congo - Brazzaville', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(182, 'Congo - Kinshasa', 'Congo - Kinshasa', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(183, 'Cook Islands', 'Cook Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(184, 'Costa Rica', 'Costa Rica', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(185, 'Croatia', 'Croatia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(186, 'Cuba', 'Cuba', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(187, 'Cyprus', 'Cyprus', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(188, 'Czech Republic', 'Czech Republic', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(189, 'Côte d’Ivoire', 'Côte d’Ivoire', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(190, 'Denmark', 'Denmark', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(191, 'Djibouti', 'Djibouti', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(192, 'Dominica', 'Dominica', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(193, 'Dominican Republic', 'Dominican Republic', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(194, 'Dronning Maud Land', 'Dronning Maud Land', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(195, 'East Germany', 'East Germany', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(196, 'Ecuador', 'Ecuador', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(197, 'Egypt', 'Egypt', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(198, 'El Salvador', 'El Salvador', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(199, 'Equatorial Guinea', 'Equatorial Guinea', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(200, 'Eritrea', 'Eritrea', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(201, 'Estonia', 'Estonia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(202, 'Ethiopia', 'Ethiopia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(203, 'Falkland Islands', 'Falkland Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(204, 'Faroe Islands', 'Faroe Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(205, 'Fiji', 'Fiji', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(206, 'Finland', 'Finland', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(207, 'France', 'France', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(208, 'French Guiana', 'French Guiana', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(209, 'French Polynesia', 'French Polynesia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(210, 'French Southern Territories', 'French Southern Territories', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(211, 'French Southern and Antarctic Territories', 'French Southern and Antarctic Territories', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(212, 'Gabon', 'Gabon', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(213, 'Gambia', 'Gambia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(214, 'Georgia', 'Georgia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(215, 'Germany', 'Germany', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(216, 'Ghana', 'Ghana', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(217, 'Gibraltar', 'Gibraltar', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(218, 'Greece', 'Greece', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(219, 'Greenland', 'Greenland', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(220, 'Grenada', 'Grenada', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(221, 'Guadeloupe', 'Guadeloupe', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(222, 'Guam', 'Guam', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(223, 'Guatemala', 'Guatemala', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(224, 'Guernsey', 'Guernsey', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(225, 'Guinea', 'Guinea', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(226, 'Guinea-Bissau', 'Guinea-Bissau', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(227, 'Guyana', 'Guyana', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(228, 'Haiti', 'Haiti', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(229, 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(230, 'Honduras', 'Honduras', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(231, 'Hong Kong SAR China', 'Hong Kong SAR China', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(232, 'Hungary', 'Hungary', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(233, 'Iceland', 'Iceland', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(234, 'India', 'India', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(235, 'Indonesia', 'Indonesia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(236, 'Iran', 'Iran', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(237, 'Iraq', 'Iraq', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(238, 'Ireland', 'Ireland', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(239, 'Isle of Man', 'Isle of Man', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(240, 'Israel', 'Israel', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(241, 'Italy', 'Italy', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(242, 'Jamaica', 'Jamaica', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(243, 'Japan', 'Japan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(244, 'Jersey', 'Jersey', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(245, 'Johnston Island', 'Johnston Island', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(246, 'Jordan', 'Jordan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(247, 'Kazakhstan', 'Kazakhstan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(248, 'Kenya', 'Kenya', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(249, 'Kiribati', 'Kiribati', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(250, 'Kuwait', 'Kuwait', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(251, 'Kyrgyzstan', 'Kyrgyzstan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(252, 'Laos', 'Laos', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(253, 'Latvia', 'Latvia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(254, 'Lebanon', 'Lebanon', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(255, 'Lesotho', 'Lesotho', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(256, 'Liberia', 'Liberia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(257, 'Libya', 'Libya', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(258, 'Liechtenstein', 'Liechtenstein', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(259, 'Lithuania', 'Lithuania', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(260, 'Luxembourg', 'Luxembourg', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(261, 'Macau SAR China', 'Macau SAR China', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(262, 'Macedonia', 'Macedonia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(263, 'Madagascar', 'Madagascar', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(264, 'Malawi', 'Malawi', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(265, 'Malaysia', 'Malaysia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(266, 'Maldives', 'Maldives', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(267, 'Mali', 'Mali', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(268, 'Malta', 'Malta', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(269, 'Marshall Islands', 'Marshall Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(270, 'Martinique', 'Martinique', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(271, 'Mauritania', 'Mauritania', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(272, 'Mauritius', 'Mauritius', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(273, 'Mayotte', 'Mayotte', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(274, 'Metropolitan France', 'Metropolitan France', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(275, 'Mexico', 'Mexico', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(276, 'Micronesia', 'Micronesia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(277, 'Midway Islands', 'Midway Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(278, 'Moldova', 'Moldova', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(279, 'Monaco', 'Monaco', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(280, 'Mongolia', 'Mongolia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(281, 'Montenegro', 'Montenegro', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(282, 'Montserrat', 'Montserrat', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(283, 'Morocco', 'Morocco', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(284, 'Mozambique', 'Mozambique', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(285, 'Myanmar [Burma]', 'Myanmar [Burma]', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(286, 'Namibia', 'Namibia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(287, 'Nauru', 'Nauru', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(288, 'Nepal', 'Nepal', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(289, 'Netherlands', 'Netherlands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(290, 'Netherlands Antilles', 'Netherlands Antilles', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(291, 'Neutral Zone', 'Neutral Zone', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(292, 'New Caledonia', 'New Caledonia', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(293, 'New Zealand', 'New Zealand', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(294, 'Nicaragua', 'Nicaragua', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(295, 'Niger', 'Niger', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(296, 'Nigeria', 'Nigeria', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(297, 'Niue', 'Niue', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(298, 'Norfolk Island', 'Norfolk Island', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(299, 'North Korea', 'North Korea', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(300, 'North Vietnam', 'North Vietnam', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(301, 'Northern Mariana Islands', 'Northern Mariana Islands', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(302, 'Norway', 'Norway', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(303, 'Oman', 'Oman', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(304, 'Pacific Islands Trust Territory', 'Pacific Islands Trust Territory', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(305, 'Pakistan', 'Pakistan', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(306, 'Palau', 'Palau', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(307, 'Palestinian Territories', 'Palestinian Territories', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(308, 'Panama', 'Panama', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(309, 'Panama Canal Zone', 'Panama Canal Zone', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(310, 'Papua New Guinea', 'Papua New Guinea', '2024-05-15 21:16:32', '2024-05-15 21:16:32'),
(311, 'Paraguay', 'Paraguay', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(312, 'People\'s Democratic Republic of Yemen', 'People\'s Democratic Republic of Yemen', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(313, 'Peru', 'Peru', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(314, 'Philippines', 'Philippines', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(315, 'Pitcairn Islands', 'Pitcairn Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(316, 'Poland', 'Poland', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(317, 'Portugal', 'Portugal', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(318, 'Puerto Rico', 'Puerto Rico', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(319, 'Qatar', 'Qatar', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(320, 'Romania', 'Romania', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(321, 'Russia', 'Russia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(322, 'Rwanda', 'Rwanda', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(323, 'Réunion', 'Réunion', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(324, 'Saint Barthélemy', 'Saint Barthélemy', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(325, 'Saint Helena', 'Saint Helena', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(326, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(327, 'Saint Lucia', 'Saint Lucia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(328, 'Saint Martin', 'Saint Martin', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(329, 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(330, 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(331, 'Samoa', 'Samoa', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(332, 'San Marino', 'San Marino', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(333, 'Saudi Arabia', 'Saudi Arabia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(334, 'Senegal', 'Senegal', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(335, 'Serbia', 'Serbia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(336, 'Serbia and Montenegro', 'Serbia and Montenegro', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(337, 'Seychelles', 'Seychelles', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(338, 'Sierra Leone', 'Sierra Leone', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(339, 'Singapore', 'Singapore', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(340, 'Slovakia', 'Slovakia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(341, 'Slovenia', 'Slovenia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(342, 'Solomon Islands', 'Solomon Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(343, 'Somalia', 'Somalia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(344, 'South Africa', 'South Africa', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(345, 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(346, 'South Korea', 'South Korea', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(347, 'Spain', 'Spain', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(348, 'Sri Lanka', 'Sri Lanka', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(349, 'Sudan', 'Sudan', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(350, 'Suriname', 'Suriname', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(351, 'Svalbard and Jan Mayen', 'Svalbard and Jan Mayen', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(352, 'Swaziland', 'Swaziland', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(353, 'Sweden', 'Sweden', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(354, 'Switzerland', 'Switzerland', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(355, 'Syria', 'Syria', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(356, 'São Tomé and Príncipe', 'São Tomé and Príncipe', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(357, 'Taiwan', 'Taiwan', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(358, 'Tajikistan', 'Tajikistan', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(359, 'Tanzania', 'Tanzania', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(360, 'Thailand', 'Thailand', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(361, 'Timor-Leste', 'Timor-Leste', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(362, 'Togo', 'Togo', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(363, 'Tokelau', 'Tokelau', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(364, 'Tonga', 'Tonga', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(365, 'Trinidad and Tobago', 'Trinidad and Tobago', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(366, 'Tunisia', 'Tunisia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(367, 'Turkey', 'Turkey', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(368, 'Turkmenistan', 'Turkmenistan', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(369, 'Turks and Caicos Islands', 'Turks and Caicos Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(370, 'Tuvalu', 'Tuvalu', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(371, 'U.S. Minor Outlying Islands', 'U.S. Minor Outlying Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(372, 'U.S. Miscellaneous Pacific Islands', 'U.S. Miscellaneous Pacific Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(373, 'U.S. Virgin Islands', 'U.S. Virgin Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(374, 'Uganda', 'Uganda', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(375, 'Ukraine', 'Ukraine', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(376, 'Union of Soviet Socialist Republics', 'Union of Soviet Socialist Republics', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(377, 'United Arab Emirates', 'United Arab Emirates', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(378, 'United Kingdom', 'United Kingdom', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(379, 'United States', 'United States', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(380, 'Unknown or Invalid Region', 'Unknown or Invalid Region', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(381, 'Uruguay', 'Uruguay', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(382, 'Uzbekistan', 'Uzbekistan', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(383, 'Vanuatu', 'Vanuatu', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(384, 'Vatican City', 'Vatican City', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(385, 'Venezuela', 'Venezuela', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(386, 'Vietnam', 'Vietnam', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(387, 'Wake Island', 'Wake Island', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(388, 'Wallis and Futuna', 'Wallis and Futuna', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(389, 'Western Sahara', 'Western Sahara', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(390, 'Yemen', 'Yemen', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(391, 'Zambia', 'Zambia', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(392, 'Zimbabwe', 'Zimbabwe', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(393, 'Åland Islands', 'Åland Islands', '2024-05-15 21:16:33', '2024-05-15 21:16:33'),
(394, 'Afar', 'Afar', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(395, 'Abkhazian', 'Abkhazian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(396, 'Avestan', 'Avestan', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(397, 'Afrikaans', 'Afrikaans', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(398, 'Akan', 'Akan', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(399, 'Amharic', 'Amharic', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(400, 'Aragonese', 'Aragonese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(401, 'Arabic', 'Arabic', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(402, 'Assamese', 'Assamese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(403, 'Avaric', 'Avaric', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(404, 'Aymara', 'Aymara', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(405, 'Azerbaijani', 'Azerbaijani', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(406, 'Bashkir', 'Bashkir', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(407, 'Belarusian', 'Belarusian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(408, 'Bulgarian', 'Bulgarian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(409, 'Bihari languages', 'Bihari languages', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(410, 'Bislama', 'Bislama', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(411, 'Bambara', 'Bambara', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(412, 'Bengali', 'Bengali', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(413, 'Tibetan', 'Tibetan', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(414, 'Breton', 'Breton', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(415, 'Bosnian', 'Bosnian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(416, 'Catalan, Valencian', 'Catalan, Valencian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(417, 'Chechen', 'Chechen', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(418, 'Chamorro', 'Chamorro', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(419, 'Corsican', 'Corsican', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(420, 'Cree', 'Cree', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(421, 'Czech', 'Czech', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(422, 'Church Slavonic, Old Bulgarian, Old Church Slavonic', 'Church Slavonic, Old Bulgarian, Old Church Slavonic', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(423, 'Chuvash', 'Chuvash', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(424, 'Welsh', 'Welsh', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(425, 'Danish', 'Danish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(426, 'German', 'German', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(427, 'Divehi, Dhivehi, Maldivian', 'Divehi, Dhivehi, Maldivian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(428, 'Dzongkha', 'Dzongkha', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(429, 'Ewe', 'Ewe', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(430, 'Greek (Modern)', 'Greek (Modern)', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(431, 'English', 'English', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(432, 'Esperanto', 'Esperanto', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(433, 'Spanish, Castilian', 'Spanish, Castilian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(434, 'Estonian', 'Estonian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(435, 'Basque', 'Basque', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(436, 'Persian', 'Persian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(437, 'Fulah', 'Fulah', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(438, 'Finnish', 'Finnish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(439, 'Fijian', 'Fijian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(440, 'Faroese', 'Faroese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(441, 'French', 'French', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(442, 'Western Frisian', 'Western Frisian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(443, 'Irish', 'Irish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(444, 'Gaelic, Scottish Gaelic', 'Gaelic, Scottish Gaelic', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(445, 'Galician', 'Galician', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(446, 'Guarani', 'Guarani', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(447, 'Gujarati', 'Gujarati', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(448, 'Manx', 'Manx', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(449, 'Hausa', 'Hausa', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(450, 'Hebrew', 'Hebrew', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(451, 'Hindi', 'Hindi', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(452, 'Hiri Motu', 'Hiri Motu', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(453, 'Croatian', 'Croatian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(454, 'Haitian, Haitian Creole', 'Haitian, Haitian Creole', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(455, 'Hungarian', 'Hungarian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(456, 'Armenian', 'Armenian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(457, 'Herero', 'Herero', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(458, 'Interlingua (International Auxiliary Language Association)', 'Interlingua (International Auxiliary Language Association)', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(459, 'Indonesian', 'Indonesian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(460, 'Interlingue', 'Interlingue', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(461, 'Igbo', 'Igbo', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(462, 'Nuosu, Sichuan Yi', 'Nuosu, Sichuan Yi', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(463, 'Inupiaq', 'Inupiaq', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(464, 'Ido', 'Ido', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(465, 'Icelandic', 'Icelandic', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(466, 'Italian', 'Italian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(467, 'Inuktitut', 'Inuktitut', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(468, 'Japanese', 'Japanese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(469, 'Javanese', 'Javanese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(470, 'Georgian', 'Georgian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(471, 'Kongo', 'Kongo', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(472, 'Gikuyu, Kikuyu', 'Gikuyu, Kikuyu', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(473, 'Kwanyama, Kuanyama', 'Kwanyama, Kuanyama', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(474, 'Kazakh', 'Kazakh', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(475, 'Greenlandic, Kalaallisut', 'Greenlandic, Kalaallisut', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(476, 'Central Khmer', 'Central Khmer', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(477, 'Kannada', 'Kannada', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(478, 'Korean', 'Korean', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(479, 'Kanuri', 'Kanuri', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(480, 'Kashmiri', 'Kashmiri', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(481, 'Kurdish', 'Kurdish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(482, 'Komi', 'Komi', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(483, 'Cornish', 'Cornish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(484, 'Kyrgyz', 'Kyrgyz', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(485, 'Latin', 'Latin', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(486, 'Letzeburgesch, Luxembourgish', 'Letzeburgesch, Luxembourgish', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(487, 'Ganda', 'Ganda', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(488, 'Limburgish, Limburgan, Limburger', 'Limburgish, Limburgan, Limburger', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(489, 'Lingala', 'Lingala', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(490, 'Lao', 'Lao', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(491, 'Lithuanian', 'Lithuanian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(492, 'Luba-Katanga', 'Luba-Katanga', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(493, 'Latvian', 'Latvian', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(494, 'Malagasy', 'Malagasy', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(495, 'Marshallese', 'Marshallese', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(496, 'Maori', 'Maori', '2024-05-15 21:26:45', '2024-05-15 21:26:45'),
(497, 'Macedonian', 'Macedonian', '2024-05-15 21:26:45', '2024-05-15 21:26:45');



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

--
-- Table structure for table `uploaded_files`
--

CREATE TABLE `uploaded_files` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` bigint UNSIGNED NOT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiry_at` datetime NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance` double(18,2) NOT NULL DEFAULT '0.00',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `microsoft_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vkontakte_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `envato_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `github_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `was_subscribed` tinyint(1) NOT NULL DEFAULT '0',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `kyc_status` tinyint(1) NOT NULL DEFAULT '0',
  `google2fa_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Disabled, 1: Active',
  `google2fa_secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: Banned, 1: Active',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_login_logs`
--

CREATE TABLE `user_login_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `ip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `os` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addons`
--
ALTER TABLE `addons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `addons_alias_unique` (`alias`);

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

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

--
-- Indexes for table `blog_articles`
--
ALTER TABLE `blog_articles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_articles_slug_unique` (`slug`),
  ADD KEY `blog_articles_blog_category_id_foreign` (`blog_category_id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_categories_slug_unique` (`slug`);

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_comments_blog_article_id_foreign` (`blog_article_id`),
  ADD KEY `blog_comments_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cart_items_item_id_foreign` (`item_id`),
  ADD KEY `cart_items_user_id_foreign` (`user_id`),
  ADD KEY `cart_items_support_period_id_foreign` (`support_period_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`);

--
-- Indexes for table `category_options`
--
ALTER TABLE `category_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_options_category_id_foreign` (`category_id`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `favorites`
--
ALTER TABLE `favorites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `favorites_user_id_foreign` (`user_id`),
  ADD KEY `favorites_item_id_foreign` (`item_id`);

--
-- Indexes for table `footer_links`
--
ALTER TABLE `footer_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `footer_links_parent_id_foreign` (`parent_id`);

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

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

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `items_name_unique` (`name`),
  ADD UNIQUE KEY `items_slug_unique` (`slug`),
  ADD KEY `items_category_id_foreign` (`category_id`),
  ADD KEY `items_sub_category_id_foreign` (`sub_category_id`);

--
-- Indexes for table `item_change_logs`
--
ALTER TABLE `item_change_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_change_logs_item_id_foreign` (`item_id`);

--
-- Indexes for table `item_comments`
--
ALTER TABLE `item_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_comments_user_id_foreign` (`user_id`),
  ADD KEY `item_comments_item_id_foreign` (`item_id`);

--
-- Indexes for table `item_comment_replies`
--
ALTER TABLE `item_comment_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_comment_replies_item_comment_id_foreign` (`item_comment_id`),
  ADD KEY `item_comment_replies_user_id_foreign` (`user_id`);

--
-- Indexes for table `item_comment_reports`
--
ALTER TABLE `item_comment_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_comment_reports_item_comment_reply_id_foreign` (`item_comment_reply_id`),
  ADD KEY `item_comment_reports_user_id_foreign` (`user_id`);

--
-- Indexes for table `item_discounts`
--
ALTER TABLE `item_discounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_discounts_item_id_foreign` (`item_id`);

--
-- Indexes for table `item_reviews`
--
ALTER TABLE `item_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_reviews_user_id_foreign` (`user_id`),
  ADD KEY `item_reviews_item_id_foreign` (`item_id`);

--
-- Indexes for table `item_review_replies`
--
ALTER TABLE `item_review_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_review_replies_item_review_id_foreign` (`item_review_id`),
  ADD KEY `item_review_replies_user_id_foreign` (`user_id`);

--
-- Indexes for table `item_views`
--
ALTER TABLE `item_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_views_item_id_foreign` (`item_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `kyc_verifications`
--
ALTER TABLE `kyc_verifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kyc_verifications_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `navbar_links`
--
ALTER TABLE `navbar_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `navbar_links_parent_id_foreign` (`parent_id`);

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indexes for table `premium_earnings`
--
ALTER TABLE `premium_earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `premium_earnings_subscription_id_foreign` (`subscription_id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `purchases_code_unique` (`code`),
  ADD KEY `purchases_user_id_foreign` (`user_id`),
  ADD KEY `purchases_sale_id_foreign` (`sale_id`),
  ADD KEY `purchases_item_id_foreign` (`item_id`);

--
-- Indexes for table `refunds`
--
ALTER TABLE `refunds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `refunds_user_id_foreign` (`user_id`),
  ADD KEY `refunds_purchase_id_foreign` (`purchase_id`);

--
-- Indexes for table `refund_replies`
--
ALTER TABLE `refund_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `refund_replies_refund_id_foreign` (`refund_id`),
  ADD KEY `refund_replies_user_id_foreign` (`user_id`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_user_id_foreign` (`user_id`),
  ADD KEY `sales_item_id_foreign` (`item_id`);

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

--
-- Indexes for table `statements`
--
ALTER TABLE `statements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `statements_user_id_foreign` (`user_id`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscriptions_user_id_foreign` (`user_id`),
  ADD KEY `subscriptions_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sub_categories_slug_unique` (`slug`),
  ADD KEY `sub_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `support_earnings`
--
ALTER TABLE `support_earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_earnings_purchase_id_foreign` (`purchase_id`);

--
-- Indexes for table `support_periods`
--
ALTER TABLE `support_periods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `support_periods_name_unique` (`name`);

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

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

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `themes_alias_unique` (`alias`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tickets_ticket_category_id_foreign` (`ticket_category_id`),
  ADD KEY `tickets_user_id_foreign` (`user_id`);

--
-- Indexes for table `ticket_categories`
--
ALTER TABLE `ticket_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ticket_categories_name_unique` (`name`);

--
-- Indexes for table `ticket_replies`
--
ALTER TABLE `ticket_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_replies_user_id_foreign` (`user_id`),
  ADD KEY `ticket_replies_ticket_id_foreign` (`ticket_id`);

--
-- Indexes for table `ticket_reply_attachments`
--
ALTER TABLE `ticket_reply_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticket_reply_attachments_ticket_reply_id_foreign` (`ticket_reply_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`),
  ADD KEY `transactions_payment_gateway_id_foreign` (`payment_gateway_id`),
  ADD KEY `transactions_purchase_id_foreign` (`purchase_id`),
  ADD KEY `transactions_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `transaction_items`
--
ALTER TABLE `transaction_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_items_item_id_foreign` (`item_id`),
  ADD KEY `transaction_items_transaction_id_foreign` (`transaction_id`);

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

--
-- Indexes for table `uploaded_files`
--
ALTER TABLE `uploaded_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uploaded_files_category_id_foreign` (`category_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_username_unique` (`username`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_facebook_id_unique` (`facebook_id`),
  ADD UNIQUE KEY `users_google_id_unique` (`google_id`),
  ADD UNIQUE KEY `users_microsoft_id_unique` (`microsoft_id`),
  ADD UNIQUE KEY `users_vkontakte_id_unique` (`vkontakte_id`),
  ADD UNIQUE KEY `users_envato_id_unique` (`envato_id`),
  ADD UNIQUE KEY `users_github_id_unique` (`github_id`);

--
-- Indexes for table `user_login_logs`
--
ALTER TABLE `user_login_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_login_logs_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_articles`
--
ALTER TABLE `blog_articles`
  ADD CONSTRAINT `blog_articles_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD CONSTRAINT `blog_comments_blog_article_id_foreign` FOREIGN KEY (`blog_article_id`) REFERENCES `blog_articles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD CONSTRAINT `cart_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_items_support_period_id_foreign` FOREIGN KEY (`support_period_id`) REFERENCES `support_periods` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `cart_items_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_options`
--
ALTER TABLE `category_options`
  ADD CONSTRAINT `category_options_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `favorites`
--
ALTER TABLE `favorites`
  ADD CONSTRAINT `favorites_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `footer_links`
--
ALTER TABLE `footer_links`
  ADD CONSTRAINT `footer_links_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `footer_links` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `items`
--
ALTER TABLE `items`
  ADD CONSTRAINT `items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `items_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_change_logs`
--
ALTER TABLE `item_change_logs`
  ADD CONSTRAINT `item_change_logs_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_comments`
--
ALTER TABLE `item_comments`
  ADD CONSTRAINT `item_comments_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_comment_replies`
--
ALTER TABLE `item_comment_replies`
  ADD CONSTRAINT `item_comment_replies_item_comment_id_foreign` FOREIGN KEY (`item_comment_id`) REFERENCES `item_comments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_comment_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_comment_reports`
--
ALTER TABLE `item_comment_reports`
  ADD CONSTRAINT `item_comment_reports_item_comment_reply_id_foreign` FOREIGN KEY (`item_comment_reply_id`) REFERENCES `item_comment_replies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_comment_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_discounts`
--
ALTER TABLE `item_discounts`
  ADD CONSTRAINT `item_discounts_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_reviews`
--
ALTER TABLE `item_reviews`
  ADD CONSTRAINT `item_reviews_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_review_replies`
--
ALTER TABLE `item_review_replies`
  ADD CONSTRAINT `item_review_replies_item_review_id_foreign` FOREIGN KEY (`item_review_id`) REFERENCES `item_reviews` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_review_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_views`
--
ALTER TABLE `item_views`
  ADD CONSTRAINT `item_views_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `kyc_verifications`
--
ALTER TABLE `kyc_verifications`
  ADD CONSTRAINT `kyc_verifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `navbar_links`
--
ALTER TABLE `navbar_links`
  ADD CONSTRAINT `navbar_links_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `navbar_links` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `premium_earnings`
--
ALTER TABLE `premium_earnings`
  ADD CONSTRAINT `premium_earnings_subscription_id_foreign` FOREIGN KEY (`subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `purchases`
--
ALTER TABLE `purchases`
  ADD CONSTRAINT `purchases_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchases_sale_id_foreign` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchases_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `refunds`
--
ALTER TABLE `refunds`
  ADD CONSTRAINT `refunds_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `refunds_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `refund_replies`
--
ALTER TABLE `refund_replies`
  ADD CONSTRAINT `refund_replies_refund_id_foreign` FOREIGN KEY (`refund_id`) REFERENCES `refunds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `refund_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sales`
--
ALTER TABLE `sales`
  ADD CONSTRAINT `sales_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sales_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `statements`
--
ALTER TABLE `statements`
  ADD CONSTRAINT `statements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `sub_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_earnings`
--
ALTER TABLE `support_earnings`
  ADD CONSTRAINT `support_earnings_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tickets`
--
ALTER TABLE `tickets`
  ADD CONSTRAINT `tickets_ticket_category_id_foreign` FOREIGN KEY (`ticket_category_id`) REFERENCES `ticket_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ticket_replies`
--
ALTER TABLE `ticket_replies`
  ADD CONSTRAINT `ticket_replies_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ticket_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ticket_reply_attachments`
--
ALTER TABLE `ticket_reply_attachments`
  ADD CONSTRAINT `ticket_reply_attachments_ticket_reply_id_foreign` FOREIGN KEY (`ticket_reply_id`) REFERENCES `ticket_replies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_payment_gateway_id_foreign` FOREIGN KEY (`payment_gateway_id`) REFERENCES `payment_gateways` (`id`),
  ADD CONSTRAINT `transactions_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transaction_items`
--
ALTER TABLE `transaction_items`
  ADD CONSTRAINT `transaction_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_items_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `uploaded_files`
--
ALTER TABLE `uploaded_files`
  ADD CONSTRAINT `uploaded_files_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_login_logs`
--
ALTER TABLE `user_login_logs`
  ADD CONSTRAINT `user_login_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

