-- phpMyAdmin SQL Dump -- version 4.9.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Aug 28, 2024 at 12:51 PM -- Server version: 5.7.40-log -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `neofiles` -- -- -------------------------------------------------------- -- -- Table structure for table `addons` -- CREATE TABLE `addons` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `action` varchar(255) 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 `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `google2fa_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Disabled, 1: Active ', `google2fa_secret` text COLLATE utf8mb4_unicode_ci, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `name`, `firstname`, `lastname`, `email`, `avatar`, `password`, `google2fa_status`, `google2fa_secret`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin Admin', 'Admin', 'Admin', 'admin@admin.com', 'images/avatars/default.png', '$2y$10$28GRIugM8JA87sINL8yeAOiiU6jlkhSGexc7X9lrXza1pUAV58roS', 0, 'eyJpdiI6Ik51aTlxaWRzRkEvQ0RtNEpHVDdleXc9PSIsInZhbHVlIjoiM1RVeG91QllxM09kbDM4cXd5eEZJTHU3NklXd3JleTl2OStWNVNCNjdNQT0iLCJtYWMiOiJmNTQ1ODg2NmY4OWU5ZTMwZjJlZjE0ZWJlNmUxYmIwYjE5ZDYyMjFkZTI5NTgzOGYzMmU3ZWQ2YmI5ZWQxZDA1IiwidGFnIjoiIn0=', 'gLNs2qz8lM7oyiIPdypxb9n1OmFKOYZfMFebLXG6TcIYNFmCmbsgixLzTRtS', '2023-12-07 23:24:24', '2024-08-27 22:51:18'); -- -------------------------------------------------------- -- -- Table structure for table `admin_notifications` -- CREATE TABLE `admin_notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) 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; -- -- Dumping data for table `admin_notifications` -- INSERT INTO `admin_notifications` (`id`, `title`, `link`, `image`, `status`, `created_at`, `updated_at`) VALUES (1, 'rehan56 has registered', 'https://neofiles.codenine.biz.id/admin/members/users/2/edit', 'https://neofiles.codenine.biz.id/images/avatars/default.png', 1, '2023-12-09 23:53:47', '2023-12-12 10:17:09'), (2, 'zhenisme has registered', 'https://neofiles.codenine.biz.id/admin/members/users/3/edit', 'https://neofiles.codenine.biz.id/images/avatars/default.png', 1, '2023-12-12 11:10:12', '2023-12-16 06:30:31'), (3, 'foantom00 has registered', 'https://neofiles.codenine.biz.id/admin/members/users/4/edit', 'https://neofiles.codenine.biz.id/images/avatars/default.png', 1, '2023-12-20 20:18:15', '2023-12-20 20:59:32'), (4, 'codenine has registered', 'https://neofile.maxgame.cloud/admin/members/users/5/edit', 'https://neofile.maxgame.cloud/images/avatars/default.png', 1, '2024-08-27 21:40:54', '2024-08-27 21:57:02'); -- -------------------------------------------------------- -- -- Table structure for table `admin_password_resets` -- CREATE TABLE `admin_password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) 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 `advertisements` -- CREATE TABLE `advertisements` ( `id` bigint(20) UNSIGNED NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` longtext 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 `advertisements` -- INSERT INTO `advertisements` (`id`, `alias`, `position`, `size`, `code`, `status`, `created_at`, `updated_at`) VALUES (1, 'head_code', 'Head Code', NULL, '', 1, '2023-05-24 17:45:33', '2023-12-23 00:23:26'), (2, 'home_page_top', 'Home Page (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 13:22:10'), (3, 'home_page_center', 'Home Page (Center)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (4, 'home_page_bottom', 'Home Page (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (5, 'blog_page_top', 'Blog Page (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (6, 'blog_page_bottom', 'Blog Page (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (7, 'blog_sidebar', 'Blog (Sidebar)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (8, 'blog_article_top', 'Blog Article (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (9, 'blog_article_bottom', 'Blog Article (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (10, 'download_page_1_top', 'Download Page 1 (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (11, 'download_page_1_center_top', 'Download Page 1 Center (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (12, 'download_page_1_center_bottom', 'Download Page 1 Center (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (13, 'download_page_1_bottom', 'Download Page 1 (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (14, 'download_page_2_top', 'Download Page 2 (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (15, 'download_page_2_center_top', 'Download Page 2 Center (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (16, 'download_page_2_center_bottom', 'Download Page 2 Center (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (17, 'download_page_2_bottom', 'Download Page 2 (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (18, 'download_page_3_top', 'Download Page 3 (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (19, 'download_page_3_center_top', 'Download Page 3 Center (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (20, 'download_page_3_center_bottom', 'Download Page 3 Center (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (21, 'download_page_3_bottom', 'Download Page 3 (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (22, 'folder_page_top', 'Folder Page (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (23, 'folder_page_bottom', 'Folder Page (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (24, 'other_pages_top', 'Other Pages (Top)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'), (25, 'other_pages_bottom', 'Other Pages (Bottom)', 'Responsive', '', 1, '2023-05-24 17:45:33', '2023-05-24 17:45:33'); -- -------------------------------------------------------- -- -- Table structure for table `announcements` -- CREATE TABLE `announcements` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog_articles` -- CREATE TABLE `blog_articles` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `admin_id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `views` bigint(20) 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(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `views` bigint(20) 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(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `article_id` bigint(20) UNSIGNED NOT NULL, `comment` text 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 `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `capital` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `continent` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `continent_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `alpha_3` varchar(10) 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 `countries` -- INSERT INTO `countries` (`id`, `code`, `name`, `capital`, `continent`, `continent_code`, `phone`, `currency`, `symbol`, `alpha_3`, `created_at`, `updated_at`) VALUES (1, 'AF', 'Afghanistan', 'Kabul', 'Asia', 'AS', '+93', 'AFN', '؋', 'AFG', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (2, 'AX', 'Aland Islands', 'Mariehamn', 'Europe', 'EU', '+358', 'EUR', '€', 'ALA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (3, 'AL', 'Albania', 'Tirana', 'Europe', 'EU', '+355', 'ALL', 'Lek', 'ALB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (4, 'DZ', 'Algeria', 'Algiers', 'Africa', 'AF', '+213', 'DZD', 'دج', 'DZA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (5, 'AS', 'American Samoa', 'Pago Pago', 'Oceania', 'OC', '+1684', 'USD', '$', 'ASM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (6, 'AD', 'Andorra', 'Andorra la Vella', 'Europe', 'EU', '+376', 'EUR', '€', 'AND', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (7, 'AO', 'Angola', 'Luanda', 'Africa', 'AF', '+244', 'AOA', 'Kz', 'AGO', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (8, 'AI', 'Anguilla', 'The Valley', 'North America', 'NA', '+1264', 'XCD', '$', 'AIA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (9, 'AQ', 'Antarctica', 'Antarctica', 'Antarctica', 'AN', '+672', 'AAD', '$', 'ATA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (10, 'AG', 'Antigua and Barbuda', 'St. John\'s', 'North America', 'NA', '+1268', 'XCD', '$', 'ATG', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (11, 'AR', 'Argentina', 'Buenos Aires', 'South America', 'SA', '+54', 'ARS', '$', 'ARG', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (12, 'AM', 'Armenia', 'Yerevan', 'Asia', 'AS', '+374', 'AMD', '֏', 'ARM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (13, 'AW', 'Aruba', 'Oranjestad', 'North America', 'NA', '+297', 'AWG', 'ƒ', 'ABW', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (14, 'AU', 'Australia', 'Canberra', 'Oceania', 'OC', '+61', 'AUD', '$', 'AUS', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (15, 'AT', 'Austria', 'Vienna', 'Europe', 'EU', '+43', 'EUR', '€', 'AUT', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (16, 'AZ', 'Azerbaijan', 'Baku', 'Asia', 'AS', '+994', 'AZN', 'm', 'AZE', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (17, 'BS', 'Bahamas', 'Nassau', 'North America', 'NA', '+1242', 'BSD', 'B$', 'BHS', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (18, 'BH', 'Bahrain', 'Manama', 'Asia', 'AS', '+973', 'BHD', '.د.ب', 'BHR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (19, 'BD', 'Bangladesh', 'Dhaka', 'Asia', 'AS', '+880', 'BDT', '৳', 'BGD', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (20, 'BB', 'Barbados', 'Bridgetown', 'North America', 'NA', '+1246', 'BBD', 'Bds$', 'BRB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (21, 'BY', 'Belarus', 'Minsk', 'Europe', 'EU', '+375', 'BYN', 'Br', 'BLR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (22, 'BE', 'Belgium', 'Brussels', 'Europe', 'EU', '+32', 'EUR', '€', 'BEL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (23, 'BZ', 'Belize', 'Belmopan', 'North America', 'NA', '+501', 'BZD', '$', 'BLZ', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (24, 'BJ', 'Benin', 'Porto-Novo', 'Africa', 'AF', '+229', 'XOF', 'CFA', 'BEN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (25, 'BM', 'Bermuda', 'Hamilton', 'North America', 'NA', '+1441', 'BMD', '$', 'BMU', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (26, 'BT', 'Bhutan', 'Thimphu', 'Asia', 'AS', '+975', 'BTN', 'Nu.', 'BTN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (27, 'BO', 'Bolivia', 'Sucre', 'South America', 'SA', '+591', 'BOB', 'Bs.', 'BOL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (28, 'BQ', 'Bonaire, Sint Eustatius and Saba', 'Kralendijk', 'North America', 'NA', '+599', 'USD', '$', 'BES', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (29, 'BA', 'Bosnia and Herzegovina', 'Sarajevo', 'Europe', 'EU', '+387', 'BAM', 'KM', 'BIH', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (30, 'BW', 'Botswana', 'Gaborone', 'Africa', 'AF', '+267', 'BWP', 'P', 'BWA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (31, 'BV', 'Bouvet Island', NULL, 'Antarctica', 'AN', '+55', 'NOK', 'kr', 'BVT', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (32, 'BR', 'Brazil', 'Brasilia', 'South America', 'SA', '+55', 'BRL', 'R$', 'BRA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (33, 'IO', 'British Indian Ocean Territory', 'Diego Garcia', 'Asia', 'AS', '+246', 'USD', '$', 'IOT', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (34, 'BN', 'Brunei Darussalam', 'Bandar Seri Begawan', 'Asia', 'AS', '+673', 'BND', 'B$', 'BRN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (35, 'BG', 'Bulgaria', 'Sofia', 'Europe', 'EU', '+359', 'BGN', 'Лв.', 'BGR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (36, 'BF', 'Burkina Faso', 'Ouagadougou', 'Africa', 'AF', '+226', 'XOF', 'CFA', 'BFA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (37, 'BI', 'Burundi', 'Bujumbura', 'Africa', 'AF', '+257', 'BIF', 'FBu', 'BDI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (38, 'KH', 'Cambodia', 'Phnom Penh', 'Asia', 'AS', '+855', 'KHR', 'KHR', 'KHM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (39, 'CM', 'Cameroon', 'Yaounde', 'Africa', 'AF', '+237', 'XAF', 'FCFA', 'CMR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (40, 'CA', 'Canada', 'Ottawa', 'North America', 'NA', '+1', 'CAD', '$', 'CAN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (41, 'CV', 'Cape Verde', 'Praia', 'Africa', 'AF', '+238', 'CVE', '$', 'CPV', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (42, 'KY', 'Cayman Islands', 'George Town', 'North America', 'NA', '+1345', 'KYD', '$', 'CYM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (43, 'CF', 'Central African Republic', 'Bangui', 'Africa', 'AF', '+236', 'XAF', 'FCFA', 'CAF', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (44, 'TD', 'Chad', 'N\'Djamena', 'Africa', 'AF', '+235', 'XAF', 'FCFA', 'TCD', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (45, 'CL', 'Chile', 'Santiago', 'South America', 'SA', '+56', 'CLP', '$', 'CHL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (46, 'CN', 'China', 'Beijing', 'Asia', 'AS', '+86', 'CNY', '¥', 'CHN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (47, 'CX', 'Christmas Island', 'Flying Fish Cove', 'Asia', 'AS', '+61', 'AUD', '$', 'CXR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (48, 'CC', 'Cocos (Keeling) Islands', 'West Island', 'Asia', 'AS', '+672', 'AUD', '$', 'CCK', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (49, 'CO', 'Colombia', 'Bogota', 'South America', 'SA', '+57', 'COP', '$', 'COL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (50, 'KM', 'Comoros', 'Moroni', 'Africa', 'AF', '+269', 'KMF', 'CF', 'COM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (51, 'CG', 'Congo', 'Brazzaville', 'Africa', 'AF', '+242', 'XAF', 'FC', 'COG', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (52, 'CD', 'Congo, Democratic Republic of the Congo', 'Kinshasa', 'Africa', 'AF', '+242', 'CDF', 'FC', 'COD', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (53, 'CK', 'Cook Islands', 'Avarua', 'Oceania', 'OC', '+682', 'NZD', '$', 'COK', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (54, 'CR', 'Costa Rica', 'San Jose', 'North America', 'NA', '+506', 'CRC', '₡', 'CRI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (55, 'CI', 'Cote D\'Ivoire', 'Yamoussoukro', 'Africa', 'AF', '+225', 'XOF', 'CFA', 'CIV', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (56, 'HR', 'Croatia', 'Zagreb', 'Europe', 'EU', '+385', 'HRK', 'kn', 'HRV', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (57, 'CU', 'Cuba', 'Havana', 'North America', 'NA', '+53', 'CUP', '$', 'CUB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (58, 'CW', 'Curacao', 'Willemstad', 'North America', 'NA', '+599', 'ANG', 'ƒ', 'CUW', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (59, 'CY', 'Cyprus', 'Nicosia', 'Asia', 'AS', '+357', 'EUR', '€', 'CYP', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (60, 'CZ', 'Czech Republic', 'Prague', 'Europe', 'EU', '+420', 'CZK', 'Kč', 'CZE', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (61, 'DK', 'Denmark', 'Copenhagen', 'Europe', 'EU', '+45', 'DKK', 'Kr.', 'DNK', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (62, 'DJ', 'Djibouti', 'Djibouti', 'Africa', 'AF', '+253', 'DJF', 'Fdj', 'DJI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (63, 'DM', 'Dominica', 'Roseau', 'North America', 'NA', '+1767', 'XCD', '$', 'DMA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (64, 'DO', 'Dominican Republic', 'Santo Domingo', 'North America', 'NA', '+1809', 'DOP', '$', 'DOM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (65, 'EC', 'Ecuador', 'Quito', 'South America', 'SA', '+593', 'USD', '$', 'ECU', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (66, 'EG', 'Egypt', 'Cairo', 'Africa', 'AF', '+20', 'EGP', 'ج.م', 'EGY', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (67, 'SV', 'El Salvador', 'San Salvador', 'North America', 'NA', '+503', 'USD', '$', 'SLV', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (68, 'GQ', 'Equatorial Guinea', 'Malabo', 'Africa', 'AF', '+240', 'XAF', 'FCFA', 'GNQ', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (69, 'ER', 'Eritrea', 'Asmara', 'Africa', 'AF', '+291', 'ERN', 'Nfk', 'ERI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (70, 'EE', 'Estonia', 'Tallinn', 'Europe', 'EU', '+372', 'EUR', '€', 'EST', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (71, 'ET', 'Ethiopia', 'Addis Ababa', 'Africa', 'AF', '+251', 'ETB', 'Nkf', 'ETH', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (72, 'FK', 'Falkland Islands (Malvinas)', 'Stanley', 'South America', 'SA', '+500', 'FKP', '£', 'FLK', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (73, 'FO', 'Faroe Islands', 'Torshavn', 'Europe', 'EU', '+298', 'DKK', 'Kr.', 'FRO', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (74, 'FJ', 'Fiji', 'Suva', 'Oceania', 'OC', '+679', 'FJD', 'FJ$', 'FJI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (75, 'FI', 'Finland', 'Helsinki', 'Europe', 'EU', '+358', 'EUR', '€', 'FIN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (76, 'FR', 'France', 'Paris', 'Europe', 'EU', '+33', 'EUR', '€', 'FRA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (77, 'GF', 'French Guiana', 'Cayenne', 'South America', 'SA', '+594', 'EUR', '€', 'GUF', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (78, 'PF', 'French Polynesia', 'Papeete', 'Oceania', 'OC', '+689', 'XPF', '₣', 'PYF', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (79, 'TF', 'French Southern Territories', 'Port-aux-Francais', 'Antarctica', 'AN', '+262', 'EUR', '€', 'ATF', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (80, 'GA', 'Gabon', 'Libreville', 'Africa', 'AF', '+241', 'XAF', 'FCFA', 'GAB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (81, 'GM', 'Gambia', 'Banjul', 'Africa', 'AF', '+220', 'GMD', 'D', 'GMB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (82, 'GE', 'Georgia', 'Tbilisi', 'Asia', 'AS', '+995', 'GEL', 'ლ', 'GEO', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (83, 'DE', 'Germany', 'Berlin', 'Europe', 'EU', '+49', 'EUR', '€', 'DEU', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (84, 'GH', 'Ghana', 'Accra', 'Africa', 'AF', '+233', 'GHS', 'GH₵', 'GHA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (85, 'GI', 'Gibraltar', 'Gibraltar', 'Europe', 'EU', '+350', 'GIP', '£', 'GIB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (86, 'GR', 'Greece', 'Athens', 'Europe', 'EU', '+30', 'EUR', '€', 'GRC', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (87, 'GL', 'Greenland', 'Nuuk', 'North America', 'NA', '+299', 'DKK', 'Kr.', 'GRL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (88, 'GD', 'Grenada', 'St. George\'s', 'North America', 'NA', '+1473', 'XCD', '$', 'GRD', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (89, 'GP', 'Guadeloupe', 'Basse-Terre', 'North America', 'NA', '+590', 'EUR', '€', 'GLP', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (90, 'GU', 'Guam', 'Hagatna', 'Oceania', 'OC', '+1671', 'USD', '$', 'GUM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (91, 'GT', 'Guatemala', 'Guatemala City', 'North America', 'NA', '+502', 'GTQ', 'Q', 'GTM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (92, 'GG', 'Guernsey', 'St Peter Port', 'Europe', 'EU', '+44', 'GBP', '£', 'GGY', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (93, 'GN', 'Guinea', 'Conakry', 'Africa', 'AF', '+224', 'GNF', 'FG', 'GIN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (94, 'GW', 'Guinea-Bissau', 'Bissau', 'Africa', 'AF', '+245', 'XOF', 'CFA', 'GNB', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (95, 'GY', 'Guyana', 'Georgetown', 'South America', 'SA', '+592', 'GYD', '$', 'GUY', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (96, 'HT', 'Haiti', 'Port-au-Prince', 'North America', 'NA', '+509', 'HTG', 'G', 'HTI', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (97, 'HM', 'Heard Island and Mcdonald Islands', '', 'Antarctica', 'AN', '+0', 'AUD', '$', 'HMD', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (98, 'VA', 'Holy See (Vatican City State)', 'Vatican City', 'Europe', 'EU', '+39', 'EUR', '€', 'VAT', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (99, 'HN', 'Honduras', 'Tegucigalpa', 'North America', 'NA', '+504', 'HNL', 'L', 'HND', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (100, 'HK', 'Hong Kong', 'Hong Kong', 'Asia', 'AS', '+852', 'HKD', '$', 'HKG', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (101, 'HU', 'Hungary', 'Budapest', 'Europe', 'EU', '+36', 'HUF', 'Ft', 'HUN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (102, 'IS', 'Iceland', 'Reykjavik', 'Europe', 'EU', '+354', 'ISK', 'kr', 'ISL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (103, 'IN', 'India', 'New Delhi', 'Asia', 'AS', '+91', 'INR', '₹', 'IND', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (104, 'ID', 'Indonesia', 'Jakarta', 'Asia', 'AS', '+62', 'IDR', 'Rp', 'IDN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (105, 'IR', 'Iran, Islamic Republic of', 'Tehran', 'Asia', 'AS', '+98', 'IRR', '﷼', 'IRN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (106, 'IQ', 'Iraq', 'Baghdad', 'Asia', 'AS', '+964', 'IQD', 'د.ع', 'IRQ', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (107, 'IE', 'Ireland', 'Dublin', 'Europe', 'EU', '+353', 'EUR', '€', 'IRL', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (108, 'IM', 'Isle of Man', 'Douglas, Isle of Man', 'Europe', 'EU', '+44', 'GBP', '£', 'IMN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (109, 'IL', 'Israel', 'Jerusalem', 'Asia', 'AS', '+972', 'ILS', '₪', 'ISR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (110, 'IT', 'Italy', 'Rome', 'Europe', 'EU', '+39', 'EUR', '€', 'ITA', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (111, 'JM', 'Jamaica', 'Kingston', 'North America', 'NA', '+1876', 'JMD', 'J$', 'JAM', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (112, 'JP', 'Japan', 'Tokyo', 'Asia', 'AS', '+81', 'JPY', '¥', 'JPN', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (113, 'JE', 'Jersey', 'Saint Helier', 'Europe', 'EU', '+44', 'GBP', '£', 'JEY', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (114, 'JO', 'Jordan', 'Amman', 'Asia', 'AS', '+962', 'JOD', 'ا.د', 'JOR', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (115, 'KZ', 'Kazakhstan', 'Astana', 'Asia', 'AS', '+7', 'KZT', 'лв', 'KAZ', '2021-11-03 22:07:15', '2021-11-04 15:59:30'), (116, 'KE', 'Kenya', 'Nairobi', 'Africa', 'AF', '+254', 'KES', 'KSh', 'KEN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (117, 'KI', 'Kiribati', 'Tarawa', 'Oceania', 'OC', '+686', 'AUD', '$', 'KIR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (118, 'KP', 'Korea, Democratic People\'s Republic of', 'Pyongyang', 'Asia', 'AS', '+850', 'KPW', '₩', 'PRK', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (119, 'KR', 'Korea, Republic of', 'Seoul', 'Asia', 'AS', '+82', 'KRW', '₩', 'KOR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (120, 'XK', 'Kosovo', 'Pristina', 'Europe', 'EU', '+381', 'EUR', '€', 'XKX', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (121, 'KW', 'Kuwait', 'Kuwait City', 'Asia', 'AS', '+965', 'KWD', 'ك.د', 'KWT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (122, 'KG', 'Kyrgyzstan', 'Bishkek', 'Asia', 'AS', '+996', 'KGS', 'лв', 'KGZ', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (123, 'LA', 'Lao People\'s Democratic Republic', 'Vientiane', 'Asia', 'AS', '+856', 'LAK', '₭', 'LAO', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (124, 'LV', 'Latvia', 'Riga', 'Europe', 'EU', '+371', 'EUR', '€', 'LVA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (125, 'LB', 'Lebanon', 'Beirut', 'Asia', 'AS', '+961', 'LBP', '£', 'LBN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (126, 'LS', 'Lesotho', 'Maseru', 'Africa', 'AF', '+266', 'LSL', 'L', 'LSO', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (127, 'LR', 'Liberia', 'Monrovia', 'Africa', 'AF', '+231', 'LRD', '$', 'LBR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (128, 'LY', 'Libyan Arab Jamahiriya', 'Tripolis', 'Africa', 'AF', '+218', 'LYD', 'د.ل', 'LBY', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (129, 'LI', 'Liechtenstein', 'Vaduz', 'Europe', 'EU', '+423', 'CHF', 'CHf', 'LIE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (130, 'LT', 'Lithuania', 'Vilnius', 'Europe', 'EU', '+370', 'EUR', '€', 'LTU', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (131, 'LU', 'Luxembourg', 'Luxembourg', 'Europe', 'EU', '+352', 'EUR', '€', 'LUX', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (132, 'MO', 'Macao', 'Macao', 'Asia', 'AS', '+853', 'MOP', '$', 'MAC', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (133, 'MK', 'Macedonia, the Former Yugoslav Republic of', 'Skopje', 'Europe', 'EU', '+389', 'MKD', 'ден', 'MKD', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (134, 'MG', 'Madagascar', 'Antananarivo', 'Africa', 'AF', '+261', 'MGA', 'Ar', 'MDG', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (135, 'MW', 'Malawi', 'Lilongwe', 'Africa', 'AF', '+265', 'MWK', 'MK', 'MWI', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (136, 'MY', 'Malaysia', 'Kuala Lumpur', 'Asia', 'AS', '+60', 'MYR', 'RM', 'MYS', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (137, 'MV', 'Maldives', 'Male', 'Asia', 'AS', '+960', 'MVR', 'Rf', 'MDV', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (138, 'ML', 'Mali', 'Bamako', 'Africa', 'AF', '+223', 'XOF', 'CFA', 'MLI', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (139, 'MT', 'Malta', 'Valletta', 'Europe', 'EU', '+356', 'EUR', '€', 'MLT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (140, 'MH', 'Marshall Islands', 'Majuro', 'Oceania', 'OC', '+692', 'USD', '$', 'MHL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (141, 'MQ', 'Martinique', 'Fort-de-France', 'North America', 'NA', '+596', 'EUR', '€', 'MTQ', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (142, 'MR', 'Mauritania', 'Nouakchott', 'Africa', 'AF', '+222', 'MRO', 'MRU', 'MRT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (143, 'MU', 'Mauritius', 'Port Louis', 'Africa', 'AF', '+230', 'MUR', '₨', 'MUS', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (144, 'YT', 'Mayotte', 'Mamoudzou', 'Africa', 'AF', '+269', 'EUR', '€', 'MYT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (145, 'MX', 'Mexico', 'Mexico City', 'North America', 'NA', '+52', 'MXN', '$', 'MEX', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (146, 'FM', 'Micronesia, Federated States of', 'Palikir', 'Oceania', 'OC', '+691', 'USD', '$', 'FSM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (147, 'MD', 'Moldova, Republic of', 'Chisinau', 'Europe', 'EU', '+373', 'MDL', 'L', 'MDA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (148, 'MC', 'Monaco', 'Monaco', 'Europe', 'EU', '+377', 'EUR', '€', 'MCO', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (149, 'MN', 'Mongolia', 'Ulan Bator', 'Asia', 'AS', '+976', 'MNT', '₮', 'MNG', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (150, 'ME', 'Montenegro', 'Podgorica', 'Europe', 'EU', '+382', 'EUR', '€', 'MNE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (151, 'MS', 'Montserrat', 'Plymouth', 'North America', 'NA', '+1664', 'XCD', '$', 'MSR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (152, 'MA', 'Morocco', 'Rabat', 'Africa', 'AF', '+212', 'MAD', 'DH', 'MAR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (153, 'MZ', 'Mozambique', 'Maputo', 'Africa', 'AF', '+258', 'MZN', 'MT', 'MOZ', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (154, 'MM', 'Myanmar', 'Nay Pyi Taw', 'Asia', 'AS', '+95', 'MMK', 'K', 'MMR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (155, 'NA', 'Namibia', 'Windhoek', 'Africa', 'AF', '+264', 'NAD', '$', 'NAM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (156, 'NR', 'Nauru', 'Yaren', 'Oceania', 'OC', '+674', 'AUD', '$', 'NRU', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (157, 'NP', 'Nepal', 'Kathmandu', 'Asia', 'AS', '+977', 'NPR', '₨', 'NPL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (158, 'NL', 'Netherlands', 'Amsterdam', 'Europe', 'EU', '+31', 'EUR', '€', 'NLD', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (159, 'AN', 'Netherlands Antilles', 'Willemstad', 'North America', 'NA', '+599', 'ANG', 'NAf', 'ANT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (160, 'NC', 'New Caledonia', 'Noumea', 'Oceania', 'OC', '+687', 'XPF', '₣', 'NCL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (161, 'NZ', 'New Zealand', 'Wellington', 'Oceania', 'OC', '+64', 'NZD', '$', 'NZL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (162, 'NI', 'Nicaragua', 'Managua', 'North America', 'NA', '+505', 'NIO', 'C$', 'NIC', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (163, 'NE', 'Niger', 'Niamey', 'Africa', 'AF', '+227', 'XOF', 'CFA', 'NER', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (164, 'NG', 'Nigeria', 'Abuja', 'Africa', 'AF', '+234', 'NGN', '₦', 'NGA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (165, 'NU', 'Niue', 'Alofi', 'Oceania', 'OC', '+683', 'NZD', '$', 'NIU', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (166, 'NF', 'Norfolk Island', 'Kingston', 'Oceania', 'OC', '+672', 'AUD', '$', 'NFK', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (167, 'MP', 'Northern Mariana Islands', 'Saipan', 'Oceania', 'OC', '+1670', 'USD', '$', 'MNP', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (168, 'NO', 'Norway', 'Oslo', 'Europe', 'EU', '+47', 'NOK', 'kr', 'NOR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (169, 'OM', 'Oman', 'Muscat', 'Asia', 'AS', '+968', 'OMR', '.ع.ر', 'OMN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (170, 'PK', 'Pakistan', 'Islamabad', 'Asia', 'AS', '+92', 'PKR', '₨', 'PAK', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (171, 'PW', 'Palau', 'Melekeok', 'Oceania', 'OC', '+680', 'USD', '$', 'PLW', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (172, 'PS', 'Palestinian Territory, Occupied', 'East Jerusalem', 'Asia', 'AS', '+970', 'ILS', '₪', 'PSE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (173, 'PA', 'Panama', 'Panama City', 'North America', 'NA', '+507', 'PAB', 'B/.', 'PAN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (174, 'PG', 'Papua New Guinea', 'Port Moresby', 'Oceania', 'OC', '+675', 'PGK', 'K', 'PNG', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (175, 'PY', 'Paraguay', 'Asuncion', 'South America', 'SA', '+595', 'PYG', '₲', 'PRY', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (176, 'PE', 'Peru', 'Lima', 'South America', 'SA', '+51', 'PEN', 'S/.', 'PER', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (177, 'PH', 'Philippines', 'Manila', 'Asia', 'AS', '+63', 'PHP', '₱', 'PHL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (178, 'PN', 'Pitcairn', 'Adamstown', 'Oceania', 'OC', '+64', 'NZD', '$', 'PCN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (179, 'PL', 'Poland', 'Warsaw', 'Europe', 'EU', '+48', 'PLN', 'zł', 'POL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (180, 'PT', 'Portugal', 'Lisbon', 'Europe', 'EU', '+351', 'EUR', '€', 'PRT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (181, 'PR', 'Puerto Rico', 'San Juan', 'North America', 'NA', '+1787', 'USD', '$', 'PRI', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (182, 'QA', 'Qatar', 'Doha', 'Asia', 'AS', '+974', 'QAR', 'ق.ر', 'QAT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (183, 'RE', 'Reunion', 'Saint-Denis', 'Africa', 'AF', '+262', 'EUR', '€', 'REU', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (184, 'RO', 'Romania', 'Bucharest', 'Europe', 'EU', '+40', 'RON', 'lei', 'ROM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (185, 'RU', 'Russian Federation', 'Moscow', 'Asia', 'AS', '+70', 'RUB', '₽', 'RUS', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (186, 'RW', 'Rwanda', 'Kigali', 'Africa', 'AF', '+250', 'RWF', 'FRw', 'RWA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (187, 'BL', 'Saint Barthelemy', 'Gustavia', 'North America', 'NA', '+590', 'EUR', '€', 'BLM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (188, 'SH', 'Saint Helena', 'Jamestown', 'Africa', 'AF', '+290', 'SHP', '£', 'SHN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (189, 'KN', 'Saint Kitts and Nevis', 'Basseterre', 'North America', 'NA', '+1869', 'XCD', '$', 'KNA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (190, 'LC', 'Saint Lucia', 'Castries', 'North America', 'NA', '+1758', 'XCD', '$', 'LCA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (191, 'MF', 'Saint Martin', 'Marigot', 'North America', 'NA', '+590', 'EUR', '€', 'MAF', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (192, 'PM', 'Saint Pierre and Miquelon', 'Saint-Pierre', 'North America', 'NA', '+508', 'EUR', '€', 'SPM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (193, 'VC', 'Saint Vincent and the Grenadines', 'Kingstown', 'North America', 'NA', '+1784', 'XCD', '$', 'VCT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (194, 'WS', 'Samoa', 'Apia', 'Oceania', 'OC', '+684', 'WST', 'SAT', 'WSM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (195, 'SM', 'San Marino', 'San Marino', 'Europe', 'EU', '+378', 'EUR', '€', 'SMR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (196, 'ST', 'Sao Tome and Principe', 'Sao Tome', 'Africa', 'AF', '+239', 'STD', 'Db', 'STP', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (197, 'SA', 'Saudi Arabia', 'Riyadh', 'Asia', 'AS', '+966', 'SAR', '﷼', 'SAU', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (198, 'SN', 'Senegal', 'Dakar', 'Africa', 'AF', '+221', 'XOF', 'CFA', 'SEN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (199, 'RS', 'Serbia', 'Belgrade', 'Europe', 'EU', '+381', 'RSD', 'din', 'SRB', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (200, 'CS', 'Serbia and Montenegro', 'Belgrade', 'Europe', 'EU', '+381', 'RSD', 'din', 'SCG', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (201, 'SC', 'Seychelles', 'Victoria', 'Africa', 'AF', '+248', 'SCR', 'SRe', 'SYC', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (202, 'SL', 'Sierra Leone', 'Freetown', 'Africa', 'AF', '+232', 'SLL', 'Le', 'SLE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (203, 'SG', 'Singapore', 'Singapur', 'Asia', 'AS', '+65', 'SGD', '$', 'SGP', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (204, 'SX', 'Sint Maarten', 'Philipsburg', 'North America', 'NA', '+1', 'ANG', 'ƒ', 'SXM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (205, 'SK', 'Slovakia', 'Bratislava', 'Europe', 'EU', '+421', 'EUR', '€', 'SVK', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (206, 'SI', 'Slovenia', 'Ljubljana', 'Europe', 'EU', '+386', 'EUR', '€', 'SVN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (207, 'SB', 'Solomon Islands', 'Honiara', 'Oceania', 'OC', '+677', 'SBD', 'Si$', 'SLB', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (208, 'SO', 'Somalia', 'Mogadishu', 'Africa', 'AF', '+252', 'SOS', 'Sh.so.', 'SOM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (209, 'ZA', 'South Africa', 'Pretoria', 'Africa', 'AF', '+27', 'ZAR', 'R', 'ZAF', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (210, 'GS', 'South Georgia and the South Sandwich Islands', 'Grytviken', 'Antarctica', 'AN', '+500', 'GBP', '£', 'SGS', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (211, 'SS', 'South Sudan', 'Juba', 'Africa', 'AF', '+211', 'SSP', '£', 'SSD', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (212, 'ES', 'Spain', 'Madrid', 'Europe', 'EU', '+34', 'EUR', '€', 'ESP', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (213, 'LK', 'Sri Lanka', 'Colombo', 'Asia', 'AS', '+94', 'LKR', 'Rs', 'LKA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (214, 'SD', 'Sudan', 'Khartoum', 'Africa', 'AF', '+249', 'SDG', '.س.ج', 'SDN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (215, 'SR', 'Suriname', 'Paramaribo', 'South America', 'SA', '+597', 'SRD', '$', 'SUR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (216, 'SJ', 'Svalbard and Jan Mayen', 'Longyearbyen', 'Europe', 'EU', '+47', 'NOK', 'kr', 'SJM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (217, 'SZ', 'Swaziland', 'Mbabane', 'Africa', 'AF', '+268', 'SZL', 'E', 'SWZ', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (218, 'SE', 'Sweden', 'Stockholm', 'Europe', 'EU', '+46', 'SEK', 'kr', 'SWE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (219, 'CH', 'Switzerland', 'Berne', 'Europe', 'EU', '+41', 'CHF', 'CHf', 'CHE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (220, 'SY', 'Syrian Arab Republic', 'Damascus', 'Asia', 'AS', '+963', 'SYP', 'LS', 'SYR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (221, 'TW', 'Taiwan, Province of China', 'Taipei', 'Asia', 'AS', '+886', 'TWD', '$', 'TWN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (222, 'TJ', 'Tajikistan', 'Dushanbe', 'Asia', 'AS', '+992', 'TJS', 'SM', 'TJK', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (223, 'TZ', 'Tanzania, United Republic of', 'Dodoma', 'Africa', 'AF', '+255', 'TZS', 'TSh', 'TZA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (224, 'TH', 'Thailand', 'Bangkok', 'Asia', 'AS', '+66', 'THB', '฿', 'THA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (225, 'TL', 'Timor-Leste', 'Dili', 'Asia', 'AS', '+670', 'USD', '$', 'TLS', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (226, 'TG', 'Togo', 'Lome', 'Africa', 'AF', '+228', 'XOF', 'CFA', 'TGO', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (227, 'TK', 'Tokelau', NULL, 'Oceania', 'OC', '+690', 'NZD', '$', 'TKL', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (228, 'TO', 'Tonga', 'Nuku\'alofa', 'Oceania', 'OC', '+676', 'TOP', '$', 'TON', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (229, 'TT', 'Trinidad and Tobago', 'Port of Spain', 'North America', 'NA', '+1868', 'TTD', '$', 'TTO', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (230, 'TN', 'Tunisia', 'Tunis', 'Africa', 'AF', '+216', 'TND', 'ت.د', 'TUN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (231, 'TR', 'Turkey', 'Ankara', 'Asia', 'AS', '+90', 'TRY', '₺', 'TUR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (232, 'TM', 'Turkmenistan', 'Ashgabat', 'Asia', 'AS', '+7370', 'TMT', 'T', 'TKM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (233, 'TC', 'Turks and Caicos Islands', 'Cockburn Town', 'North America', 'NA', '+1649', 'USD', '$', 'TCA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (234, 'TV', 'Tuvalu', 'Funafuti', 'Oceania', 'OC', '+688', 'AUD', '$', 'TUV', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (235, 'UG', 'Uganda', 'Kampala', 'Africa', 'AF', '+256', 'UGX', 'USh', 'UGA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (236, 'UA', 'Ukraine', 'Kiev', 'Europe', 'EU', '+380', 'UAH', '₴', 'UKR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (237, 'AE', 'United Arab Emirates', 'Abu Dhabi', 'Asia', 'AS', '+971', 'AED', 'إ.د', 'ARE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (238, 'GB', 'United Kingdom', 'London', 'Europe', 'EU', '+44', 'GBP', '£', 'GBR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (239, 'US', 'United States', 'Washington', 'North America', 'NA', '+1', 'USD', '$', 'USA', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (240, 'UM', 'United States Minor Outlying Islands', NULL, 'North America', 'NA', '+1', 'USD', '$', 'UMI', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (241, 'UY', 'Uruguay', 'Montevideo', 'South America', 'SA', '+598', 'UYU', '$', 'URY', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (242, 'UZ', 'Uzbekistan', 'Tashkent', 'Asia', 'AS', '+998', 'UZS', 'лв', 'UZB', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (243, 'VU', 'Vanuatu', 'Port Vila', 'Oceania', 'OC', '+678', 'VUV', 'VT', 'VUT', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (244, 'VE', 'Venezuela', 'Caracas', 'South America', 'SA', '+58', 'VEF', 'Bs', 'VEN', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (245, 'VN', 'Viet Nam', 'Hanoi', 'Asia', 'AS', '+84', 'VND', '₫', 'VNM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (246, 'VG', 'Virgin Islands, British', 'Road Town', 'North America', 'NA', '+1284', 'USD', '$', 'VGB', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (247, 'VI', 'Virgin Islands, U.s.', 'Charlotte Amalie', 'North America', 'NA', '+1340', 'USD', '$', 'VIR', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (248, 'WF', 'Wallis and Futuna', 'Mata Utu', 'Oceania', 'OC', '+681', 'XPF', '₣', 'WLF', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (249, 'EH', 'Western Sahara', 'El-Aaiun', 'Africa', 'AF', '+212', 'MAD', 'MAD', 'ESH', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (250, 'YE', 'Yemen', 'Sanaa', 'Asia', 'AS', '+967', 'YER', '﷼', 'YEM', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (251, 'ZM', 'Zambia', 'Lusaka', 'Africa', 'AF', '+260', 'ZMW', 'ZK', 'ZMB', '2021-11-03 22:07:16', '2021-11-04 15:59:30'), (252, 'ZW', 'Zimbabwe', 'Harare', 'Africa', 'AF', '+263', 'ZWL', '$', 'ZWE', '2021-11-03 22:07:16', '2021-11-04 15:59:30'); -- -------------------------------------------------------- -- -- Table structure for table `earning_statistics` -- CREATE TABLE `earning_statistics` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `earning_statistic_id` bigint(20) UNSIGNED DEFAULT NULL, `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payout_rate` double(8,2) DEFAULT NULL, `earning_source` enum('download','referral') COLLATE utf8mb4_unicode_ci NOT NULL, `earnings` decimal(18,9) NOT NULL DEFAULT '0.000000000', `referral_id` bigint(20) UNSIGNED DEFAULT NULL, `file_entry_id` bigint(20) UNSIGNED DEFAULT NULL, `file_entry_details` longtext COLLATE utf8mb4_unicode_ci, `referer_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referer_details` text COLLATE utf8mb4_unicode_ci, `downloads` int(10) UNSIGNED NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL COMMENT '0:Invalid 1:Valid', `status_reason` varchar(255) 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 `editor_files` -- CREATE TABLE `editor_files` ( `id` bigint(20) UNSIGNED NOT NULL, `path` varchar(255) 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 `extensions` -- CREATE TABLE `extensions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `credentials` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text 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`, `credentials`, `instructions`, `status`, `created_at`, `updated_at`) VALUES (1, 'Google reCAPTCHA', 'google_recaptcha', 'images/extensions/google-recaptcha.png', '{\"site_key\":null,\"secret_key\":null}', NULL, 0, '2022-02-23 19:40:12', '2023-10-12 19:51:27'), (2, 'hCaptcha', 'hcaptcha', 'images/extensions/hcaptcha.png', '{\"site_key\":null,\"secret_key\":null}', NULL, 0, '2022-02-23 19:40:12', '2023-10-06 15:38:15'), (3, 'Tawk.to', 'tawk_to', 'images/extensions/tawk-to.png', '{\"api_key\":null}', '', 0, '2022-02-23 19:40:12', '2023-05-12 18:47:09'), (5, 'Google Analytics 4', 'google_analytics', 'images/extensions/google-analytics.png', '{\"measurement_id\":null}', '', 0, '2022-02-23 19:40:12', '2023-05-12 18:45:00'); -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text 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 `faqs` -- INSERT INTO `faqs` (`id`, `lang`, `title`, `body`, `created_at`, `updated_at`) VALUES (1, 'en', 'What is Lorem Ipsum?', '

Lorem Ipsum 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.

', '2023-03-22 19:21:24', '2023-03-22 19:21:24'), (2, 'en', 'Where does it come from?', '

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.

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.

', '2023-03-22 19:21:42', '2023-03-22 19:21:42'), (3, 'en', 'Why do we use it?', '

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).

', '2023-03-22 19:21:58', '2023-03-22 19:21:58'), (4, 'en', 'Where can I get some?', '

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.

', '2023-03-22 19:22:14', '2023-03-22 19:22:32'); -- -------------------------------------------------------- -- -- Table structure for table `features` -- CREATE TABLE `features` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text 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 `features` -- INSERT INTO `features` (`id`, `lang`, `title`, `image`, `body`, `created_at`, `updated_at`) VALUES (1, 'en', 'Earn Money', 'images/others/features/wIfEvOCzE8wU8Lk_1679511340.svg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt consequatur neque earum eum commodi recusandae.', '2023-03-22 14:55:40', '2023-03-22 14:55:40'), (2, 'en', 'Live Statistic', 'images/others/features/2BwR60YuvMIHgLh_1679512012.svg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt consequatur neque earum eum commodi recusandae.', '2023-03-22 15:06:52', '2023-03-22 15:06:52'), (3, 'en', 'Simple Upload', 'images/others/features/EiQz5KjQrwbX30B_1679512050.svg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt consequatur neque earum eum commodi recusandae.', '2023-03-22 15:07:30', '2023-03-22 15:07:30'), (4, 'en', '24 / 7 Support', 'images/others/features/xoCr7f84mazVmvJ_1679512067.svg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt consequatur neque earum eum commodi recusandae.', '2023-03-22 15:07:47', '2023-03-22 15:07:47'), (5, 'en', 'Huge Servers', 'images/others/features/XGc9FqFFtiPQE0R_1679512099.svg', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Sunt consequatur neque earum eum commodi recusandae.', '2023-03-22 15:08:19', '2023-03-22 15:08:19'); -- -------------------------------------------------------- -- -- Table structure for table `file_entries` -- CREATE TABLE `file_entries` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `parent_id` bigint(20) UNSIGNED DEFAULT NULL, `storage_provider_id` bigint(20) UNSIGNED DEFAULT NULL, `ip` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `filename` text COLLATE utf8mb4_unicode_ci NOT NULL, `mime` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `size` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `extension` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` enum('folder','file') COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `path` text COLLATE utf8mb4_unicode_ci, `path_ids` text COLLATE utf8mb4_unicode_ci, `downloads` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `visibility` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0:private 1:public', `expiry_at` datetime DEFAULT NULL, `is_viewed` 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 `file_reports` -- CREATE TABLE `file_reports` ( `id` bigint(20) UNSIGNED NOT NULL, `file_entry_id` bigint(20) UNSIGNED NOT NULL, `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` int(11) NOT NULL, `details` text COLLATE utf8mb4_unicode_ci NOT NULL, `is_viewed` 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 `footer_menu` -- CREATE TABLE `footer_menu` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `link` text COLLATE utf8mb4_unicode_ci NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `parent_id` bigint(20) UNSIGNED DEFAULT NULL, `order` bigint(20) 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_menu` -- INSERT INTO `footer_menu` (`id`, `name`, `link`, `lang`, `parent_id`, `order`, `created_at`, `updated_at`) VALUES (1, 'Neo Files', '/page-example', 'en', NULL, 1, '2023-02-05 16:20:43', '2023-12-07 23:45:45'), (2, 'About Us', '/page-example', 'en', 1, 1, '2023-02-05 16:21:04', '2023-02-05 16:21:26'), (3, 'Careers', '/page-example', 'en', 1, 2, '2023-02-05 16:21:21', '2023-02-05 16:32:58'), (4, 'Legal', '/page-example', 'en', NULL, 2, '2023-02-05 16:21:53', '2023-02-05 16:33:43'), (5, 'Privacy policy', '/privacy-policy', 'en', 4, 1, '2023-02-05 16:22:03', '2023-02-10 19:47:39'), (6, 'Terms of use', '/terms-of-use', 'en', 4, 2, '2023-02-05 16:22:16', '2023-02-10 19:47:48'), (7, 'Copyright Policy', '/page-example', 'en', 4, 4, '2023-02-05 16:22:27', '2023-02-05 16:34:26'), (8, 'Contact Us', '/contact-us', 'en', 1, 3, '2023-02-05 16:22:53', '2023-03-24 12:50:13'), (10, 'Press Room', '/page-example', 'en', 1, 4, '2023-02-05 16:33:25', '2023-02-05 16:33:33'), (11, 'Cookies Policy', '/page-example', 'en', 4, 3, '2023-02-05 16:34:06', '2023-02-05 16:34:11'), (12, 'Help & Support', '/page-example', 'en', NULL, 3, '2023-02-05 16:34:49', '2023-12-07 23:46:13'), (13, 'Help Center', '/page-example', 'en', 12, 1, '2023-02-05 16:35:02', '2023-02-05 16:35:22'), (14, 'Customer Service', '/page-example', 'en', 12, 2, '2023-02-05 16:35:12', '2023-02-05 16:35:22'), (15, 'Frequently Asked Questions', '/page-example', 'en', 12, 3, '2023-02-05 16:35:28', '2023-02-05 16:35:33'), (16, 'Report a Problem', '/page-example', 'en', 12, 4, '2023-02-05 16:35:49', '2023-02-05 16:35:53'), (17, 'Explore', '/page-example', 'en', NULL, 4, '2023-02-05 16:36:27', '2023-02-05 16:38:22'), (18, 'Features', '/features', 'en', 17, 1, '2023-02-05 16:37:52', '2023-02-10 19:12:43'), (19, 'Pricing', '/premium', 'en', 17, 2, '2023-02-05 16:38:04', '2023-12-08 09:17:41'), (20, 'Blog', '/blog', 'en', 17, 3, '2023-02-05 16:38:14', '2023-02-10 19:12:26'), (21, 'FAQs', '/faqs', 'en', 17, 4, '2023-02-19 16:18:46', '2023-02-19 16:18:52'); -- -------------------------------------------------------- -- -- Table structure for table `languages` -- CREATE TABLE `languages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `flag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `sort_id` int(11) 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 `languages` -- INSERT INTO `languages` (`id`, `name`, `flag`, `code`, `sort_id`, `created_at`, `updated_at`) VALUES (1, 'English', 'images/languages/en.png', 'en', 0, '2021-12-11 14:35:51', '2023-01-28 11:30:27'); -- -------------------------------------------------------- -- -- Table structure for table `mail_templates` -- CREATE TABLE `mail_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `shortcodes` longtext COLLATE utf8mb4_unicode_ci, `status` tinyint(1) NOT NULL DEFAULT '1', `license` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mail_templates` -- INSERT INTO `mail_templates` (`id`, `lang`, `alias`, `name`, `subject`, `body`, `shortcodes`, `status`, `license`) VALUES (1, 'en', 'password_reset', 'Reset Password', 'Reset Password Notification', '

Hello!

You are receiving this email because we received a password reset request for your account, please click on the link below to reset your password.

{{link}}

This password reset link will expire in {{expiry_time}} minutes. If you did not request a password reset, no further action is required.

Regards,
{{website_name}}

', '{\n\"link\":\"Password reset link\",\n\"expiry_time\":\"Link expiry time\",\n\"website_name\":\"Your website name\"\n}', 1, 1), (3, 'en', 'email_verification', 'Email Verification', 'Verify Email Address', '

Hello!

Please click on the link below to verify your email address.

{{link}}

If you did not create an account, no further action is required.

Regards,
{{website_name}}

', '{\"link\":\"Email verification link\",\"website_name\":\"Your website name\"}', 1, 1), (4, 'en', 'user_withdrawal_notification', 'User Withdrawal Notification', 'Your withdrawal status has been updated', '

Hi, {{username}}

The status of your withdrawal request has been updated

Withdrawal details:

Request ID: #{{request_id}}

Downloads Earnings : {{downloads_earnings}}

Referrals earnings : {{referrals_earnings}}

Total Amount : {{total_amount}}

Withdrawal method : {{withdrawal_method}}

Withdrawal account : {{withdrawal_account}}

Date: {{date}}

Status : {{status}}

Link: {{link}}

Regards, 
{{website_name}}

', '{\"username\":\"The user name\",\"request_id\":\"The withdrawal request id\",\"downloads_earnings\":\"Withdrawal downloads earnings amount\", \"referrals_earnings\":\"Withdrawal referrals earnings amount\", \"total_amount\":\"Total withdrawal amount\", \"withdrawal_method\":\"Withdrawal method\", \"withdrawal_account\":\"Withdrawal account\", \"status\":\"Withdrawal request status\",\"date\":\"The withdrawal request date\",\"link\":\"The withdrawal view link\",\"website_name\":\"Your website name\"}', 1, 1), (5, 'en', 'user_transaction_notification', 'User Transaction Notification', 'Your transaction status has been updated', '

Hi, {{username}}

Your transaction status has been changed

Transaction details:

Transaction ID: #{{transaction_id}}

Transaction Amount: {{amount}}

Transaction Status: {{status}}

Payment Gateway: {{gateway}}

Transaction Date: {{date}}

Link: {{link}}

Regards, 
{{website_name}}

', '{ \"username\":\"The user name\", \"transaction_id\":\"Transaction ID\", \"amount\":\"Transaction amount (price)\", \"status\":\"Transaction status\", \"gateway\":\"Transaction payment gateway\",\"date\":\"The transaction date\", \"link\":\"Transaction view link\", \"website_name\":\"Your website name\" }', 1, 1), (6, 'en', 'admin_withdrawal_notification', 'Admin Withdrawal Notification', 'New Withdrawal Request', '

Hi, Admin

The user {{username}} requested a new withdrawal

Withdrawal details:

Request ID: #{{request_id}}

Downloads Earnings : {{downloads_earnings}}

Referrals earnings : {{referrals_earnings}}

Total Amount : {{total_amount}}

Withdrawal method : {{withdrawal_method}}

Withdrawal account : {{withdrawal_account}}

Date: {{date}}

Link: {{link}}

Regards, 
{{website_name}}

', '{\"username\":\"The user name\",\"request_id\":\"The withdrawal request id\",\"downloads_earnings\":\"Withdrawal downloads earnings amount\", \"referrals_earnings\":\"Withdrawal referrals earnings amount\", \"total_amount\":\"Total withdrawal amount\", \"withdrawal_method\":\"Withdrawal method\", \"withdrawal_account\":\"Withdrawal account\",\"date\":\"The withdrawal request date\",\"link\":\"The withdrawal view link\",\"website_name\":\"Your website name\"}', 1, 1), (7, 'en', 'admin_transaction_notification', 'Admin Transaction Notification', 'New Pending Transaction', '

Hi, Admin

You have a new pending transaction waiting for review

Transaction details:

Username: {{username}}

Transaction ID: #{{transaction_id}}

Transaction Amount: {{amount}}

Payment Gateway: {{gateway}}

Transaction Date: {{date}}

Link: {{link}}

Regards, 
{{website_name}}

', '{ \"username\":\"The user name\", \"transaction_id\":\"Transaction ID\", \"amount\":\"Transaction amount (price)\", \"gateway\":\"Transaction payment gateway\",\r\n\"date\":\"The transaction date\",\"link\":\"Transaction view link\", \"website_name\":\"Your website name\" }', 1, 1), (8, 'en', 'subscription_expire_notification', 'Subscription Expire Notification', 'Subscription Expire Notification', '

Hi, {{username}}

I hope this email finds you well. We are writing to inform you that your subscription has expired as of {{expiry_date}}.

To continue enjoying the benefits of our service, we encourage you to renew your subscription at your earliest convenience. You can do this by following the link provided below:

{{link}}

Renewing your subscription is easy and straightforward, and will only take a few minutes. Once you renew, you will regain full access to all of the features and benefits of our service.

If you have any questions or concerns, please do not hesitate to contact our customer support team. We are available to assist you and address any issues that you may have.

Thank you for your continued support of our service. We look forward to serving you again soon.

Best regards,
{{website_name}}

', '{\"username\":\"User name\",\"expiry_date\":\"Subscription expiry date\",\"link\":\"User Subscription page\",\"website_name\":\"Your website name\"}', 1, 2), (9, 'en', 'subscription_deleted_notification', 'Subscription Deleted Notification', 'Subscription Deleted Notification', '

Hi, {{username}}

I regret to inform you that your subscription has expired for an extended period of time and we were unable to renew it despite our efforts to contact you.

As a result, we have deleted all files and folders from your account. Please note that this action is irreversible and cannot be undone.

We would like to remind you that our terms and conditions state that we reserve the right to delete any subscription that has not been renewed for a prolonged period of time after it has expired.

We understand that losing your data can be frustrating, and we apologize for any inconvenience caused. Please note that we are unable to retrieve any deleted files or folders, and we strongly recommend that you back up your important data to avoid similar situations in the future.

If you wish to continue using our service, we encourage you to subscribe again. Our team will be more than happy to assist you in setting up your new account.

Thank you for your understanding.

Best regards,
{{website_name}}

', '{\"username\":\"User name\",\"website_name\":\"Your website name\"}', 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5, '2021_10_03_223916_create_admins_table', 1), (6, '2021_10_03_224118_create_admin_password_resets', 1), (12, '2021_10_07_221832_create_settings_table', 4), (27, '2021_10_14_230536_create_languages_table', 8), (52, '2021_10_15_212511_create_translates_table', 12), (54, '2021_10_04_213420_create_pages_table', 14), (55, '2021_10_06_201713_create_blog_categories_table', 14), (56, '2021_10_06_201752_create_blog_articles_table', 14), (62, '2021_11_03_225531_create_countries_table', 19), (73, '2021_12_01_100425_create_admin_notifications_table', 24), (87, '2022_01_06_180145_create_blog_comments_table', 32), (92, '2021_10_28_191044_create_storage_providers_table', 36), (93, '2022_02_23_213634_create_extensions_table', 37), (97, '2022_01_06_225055_create_features_table', 41), (98, '2021_10_24_215104_create_seo_configurations_table', 42), (101, '2022_04_03_220038_create_mail_templates_table', 43), (105, '2014_10_12_100000_create_password_resets_table', 44), (106, '2019_12_14_000001_create_personal_access_tokens_table', 44), (109, '2021_12_14_233352_create_navbar_menu_table', 46), (114, '2023_02_04_164717_create_editor_files_table', 49), (115, '2023_03_22_190745_create_faqs_table', 50), (116, '2023_03_22_200127_create_steps_table', 51), (117, '2021_12_15_215308_create_footer_menu_table', 52), (118, '2014_10_12_000000_create_users_table', 53), (119, '2021_11_01_162229_create_user_logs_table', 53), (123, '2023_03_25_215458_create_withdrawal_methods_table', 54), (125, '2023_03_27_132810_create_payout_rates_table', 55), (127, '2023_03_29_204941_create_announcements_table', 57), (128, '2023_03_31_143851_create_withdrawals_table', 58), (140, '2023_04_11_183918_create_file_entries_table', 65), (142, '2023_04_02_211225_create_plans_table', 66), (145, '2023_04_05_194009_create_subscriptions_table', 68), (146, '2023_04_03_180933_create_premium_plans_table', 69), (158, '2023_05_17_181545_create_referrals_table', 70), (161, '2023_05_17_191254_create_earning_statistics_table', 71), (162, '2023_05_18_142135_create_file_reports_table', 72), (163, '2023_05_24_143353_create_advertisements_table', 73), (165, '2023_09_26_125948_create_themes_table', 74), (166, '2023_10_06_100242_create_addons_table', 75), (167, '2023_04_01_224119_create_payment_gateways_table', 76), (168, '2023_04_05_191348_create_transactions_table', 76), (169, '2023_10_10_141330_create_o_auth_providers_table', 77); -- -------------------------------------------------------- -- -- Table structure for table `navbar_menu` -- CREATE TABLE `navbar_menu` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `link` text COLLATE utf8mb4_unicode_ci NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `parent_id` bigint(20) UNSIGNED DEFAULT NULL, `order` bigint(20) 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_menu` -- INSERT INTO `navbar_menu` (`id`, `name`, `link`, `lang`, `parent_id`, `order`, `created_at`, `updated_at`) VALUES (6, 'Home', '/', 'en', NULL, 1, '2023-02-01 15:40:56', '2023-02-01 15:59:00'), (7, 'Payout Rates', '/payout-rates', 'en', NULL, 3, '2023-02-01 15:58:00', '2023-10-11 15:38:35'), (8, 'Payment Proof', '/payment-proof', 'en', NULL, 4, '2023-02-01 16:07:47', '2023-03-22 20:40:46'), (16, 'Premium', '/premium', 'en', NULL, 4, '2023-12-08 09:20:13', '2023-12-08 09:20:13'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_providers` -- CREATE TABLE `oauth_providers` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `credentials` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text 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 `oauth_providers` -- INSERT INTO `oauth_providers` (`id`, `name`, `alias`, `icon`, `credentials`, `instructions`, `status`, `created_at`, `updated_at`) VALUES (1, 'Facebook', 'facebook', 'fab fa-facebook-f', '{\"client_id\":null,\"client_secret\":null}', '', 0, '2022-02-23 17:40:12', '2023-10-12 19:59:59'), (2, 'Google', 'google', 'fab fa-google', '{\"client_id\":null,\"client_secret\":null}', '', 0, '2022-02-23 17:40:12', '2023-10-12 19:59:53'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `views` bigint(20) 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`, `lang`, `title`, `slug`, `content`, `short_description`, `views`, `created_at`, `updated_at`) VALUES (4, 'en', 'Privacy Policy', 'privacy-policy', '

What is Lorem Ipsum?

Lorem Ipsum 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.

Where does it come from?

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.

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.

Why do we use it?

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).

Where can I get some?

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.

', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 29, '2023-01-28 11:56:37', '2023-12-17 22:28:22'), (5, 'en', 'Terms of use', 'terms-of-use', '

What is Lorem Ipsum?

Lorem Ipsum 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.

Where does it come from?

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.

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.

Why do we use it?

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).

Where can I get some?

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.

', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 9, '2023-01-28 11:57:10', '2023-12-17 15:47:40'), (7, 'en', 'Page Example', 'page-example', '

What is Lorem Ipsum?

Lorem Ipsum 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.

Where does it come from?

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.

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.

Why do we use it?

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).

Where can I get some?

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.

', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 29, '2023-01-28 11:57:10', '2023-12-20 20:55:44'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) 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 `payment_gateways` -- CREATE TABLE `payment_gateways` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `handler` text COLLATE utf8mb4_unicode_ci NOT NULL, `credentials` longtext COLLATE utf8mb4_unicode_ci, `description` text COLLATE utf8mb4_unicode_ci, `is_manual` tinyint(1) NOT NULL DEFAULT '0', `instructions` longtext COLLATE utf8mb4_unicode_ci, `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Disabled 1:Active', `sort_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `payment_gateways` -- INSERT INTO `payment_gateways` (`id`, `name`, `alias`, `logo`, `handler`, `credentials`, `description`, `is_manual`, `instructions`, `status`, `sort_id`) VALUES (1, 'Paypal', 'paypal', 'images/payment-gateways/paypal.png', 'App\\Http\\Controllers\\Premium\\Payments\\Paypal\\ProcessController', '{\"client_id\":\"AcNJxK8uTNW0LydCVAQ1iex_pffZSWQiv1z2skmP9Bv5p_xSd2LK1wr7hSCQ_HjreReDvjvOOD8_-CmJ\",\"client_secret\":\"EM7Alo8vtWMTGajDLgAMwBzzkRFCGcUUHVHkDUtCUDDz90wtKibKyNso5YX1P-AwTWapCsIuSHhFf1z7\"}', NULL, 0, NULL, 1, 1), (2, 'Stripe', 'stripe', 'images/payment-gateways/stripe.png', 'App\\Http\\Controllers\\Premium\\Payments\\Stripe\\ProcessController', '{\"publishable_key\":\"pk_test_AXJnsLZeYQLe5L2qzA8FI94o00HCMh14t5\",\"secret_key\":\"sk_test_WlDtXCea4H8cKRFk7bgzW3xq00hcfmF73r\"}', NULL, 0, NULL, 1, 2), (3, 'Mollie', 'mollie', 'images/payment-gateways/mollie.png', 'App\\Http\\Controllers\\Premium\\Payments\\Mollie\\ProcessController', '{\"api_key\":\"test_ztGDe2MuPREeHwFqbwuJTrbrtCmmcw\"}', NULL, 0, NULL, 1, 3), (4, 'Razorpay', 'razorpay', 'images/payment-gateways/razorpay.png', 'App\\Http\\Controllers\\Premium\\Payments\\Razorpay\\ProcessController', '{\"key_id\":\"rzp_test_DUPTzXW3UC4iBC\",\"key_secret\":\"EUbzW2yEuosyZEivq9koTKnr\"}', NULL, 0, NULL, 1, 4), (5, 'Paystack', 'paystack', 'images/payment-gateways/paystack.png', 'App\\Http\\Controllers\\Premium\\Payments\\Paystack\\ProcessController', '{\"public_key\":\"pk_test_762f08f728fbd0191221a7b1a06ac10b6017be24\",\"secret_key\":\"sk_test_f525daf950659e2c2cac6dfec9b3bf1fdc4b76b9\"}', NULL, 0, NULL, 1, 5), (7, 'Coinbase Commerce', 'coinbase_commerce', 'images/payment-gateways/coinbase_commerce.png', 'App\\Http\\Controllers\\Premium\\Payments\\CoinbaseCommerce\\ProcessController', '{\"api_key\":\"2E8YCQWQ\",\"webhook_shared_secret\":\"2E8YCQWQ\"}', 'Webhook Endpoint :\r\n[URL]/premium/payment/coinbase-commerce', 0, NULL, 1, 7), (8, 'Coingate', 'coingate', 'images/payment-gateways/coingate.png', 'App\\Http\\Controllers\\Premium\\Payments\\Coingate\\ProcessController', '{\"auth_token\":\"299kVnCm91kxQ2AJw377FxLG2LpRR_qmszQvLFhC\"}', NULL, 0, NULL, 1, 6), (9, 'Account Balance', 'balance', 'images/payment-gateways/balance.png', 'App\\Http\\Controllers\\Premium\\Payments\\Balance\\ProcessController', NULL, NULL, 1, NULL, 1, 0), (10, 'Bank Wire', 'bank_wire', 'images/payment-gateways/bank_wire.png', 'App\\Http\\Controllers\\Premium\\Payments\\Manual\\ProcessController', NULL, NULL, 1, NULL, 1, 8); -- -------------------------------------------------------- -- -- Table structure for table `payout_rates` -- CREATE TABLE `payout_rates` ( `id` bigint(20) UNSIGNED NOT NULL, `country_id` bigint(20) UNSIGNED DEFAULT NULL, `flag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` double(8,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `payout_rates` -- INSERT INTO `payout_rates` (`id`, `country_id`, `flag`, `amount`, `created_at`, `updated_at`) VALUES (1, 239, 'images/payout-rates/us.png', 10.00, '2023-03-27 17:16:36', '2023-03-27 17:17:20'), (2, 83, 'images/payout-rates/de.png', 8.00, '2023-03-27 17:17:48', '2023-03-27 17:17:48'), (3, 76, 'images/payout-rates/fr.png', 7.00, '2023-03-27 17:24:35', '2023-03-27 17:24:35'), (4, 238, 'images/payout-rates/gb.png', 9.00, '2023-03-27 17:24:51', '2023-03-27 17:24:51'), (5, 158, 'images/payout-rates/nl.png', 6.00, '2023-03-27 17:25:15', '2023-03-27 17:25:15'), (6, 152, 'images/payout-rates/ma.png', 5.00, '2023-03-27 17:27:28', '2023-03-27 17:27:28'), (7, 197, 'images/payout-rates/sa.png', 4.00, '2023-03-27 17:27:48', '2023-03-27 17:27:48'), (8, 66, 'images/payout-rates/eg.png', 3.00, '2023-03-27 17:28:08', '2023-03-27 17:28:08'), (9, 103, 'images/payout-rates/in.png', 6.00, '2023-03-27 17:30:29', '2023-03-27 17:30:29'), (10, 104, 'images/payout-rates/id.png', 2.00, '2023-03-27 17:30:44', '2023-03-27 17:30:44'), (12, NULL, 'images/payout-rates/all.png', 1.00, '2023-05-16 15:07:50', '2023-05-16 15:07:50'); -- -------------------------------------------------------- -- -- Table structure for table `plans` -- CREATE TABLE `plans` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `storage_space` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Megabyte', `max_file_size` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Megabyte', `file_expiry_days` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Days', `download_waiting_time` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Seconds', `advertisements` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Hidden 1:Visible', `download_captcha` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Hidden 1:Visible', `upload_status` tinyint(1) NOT NULL DEFAULT '1', `sort_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `plans` -- INSERT INTO `plans` (`id`, `name`, `alias`, `short_description`, `storage_space`, `max_file_size`, `file_expiry_days`, `download_waiting_time`, `advertisements`, `download_captcha`, `upload_status`, `sort_id`) VALUES (1, 'Home Basic', 'visitors', NULL, 100, 50, 7, 20, 1, 1, 1, 0), (2, 'Home Premium', 'users', NULL, 1024, 500, 30, 10, 1, 1, 1, 2), (3, 'Enterprise', 'premium', 'The most popular', NULL, NULL, NULL, NULL, 0, 0, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `premium_plans` -- CREATE TABLE `premium_plans` ( `id` bigint(20) UNSIGNED NOT NULL, `plan_id` bigint(20) UNSIGNED NOT NULL, `interval` bigint(20) NOT NULL, `price` double(10,2) 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 `premium_plans` -- INSERT INTO `premium_plans` (`id`, `plan_id`, `interval`, `price`, `created_at`, `updated_at`) VALUES (16, 3, 1, 3.99, '2023-09-19 18:45:12', '2023-09-19 18:45:12'), (17, 3, 7, 7.99, '2023-09-19 18:45:19', '2023-09-19 18:45:19'), (18, 3, 30, 19.99, '2023-09-19 18:45:25', '2023-09-19 18:45:25'), (19, 3, 365, 99.99, '2023-09-19 18:45:32', '2023-09-19 18:45:32'); -- -------------------------------------------------------- -- -- Table structure for table `referrals` -- CREATE TABLE `referrals` ( `id` bigint(20) UNSIGNED NOT NULL, `referring_user_id` bigint(20) UNSIGNED NOT NULL, `referred_user_id` bigint(20) UNSIGNED NOT NULL, `earnings` decimal(18,9) NOT NULL DEFAULT '0.000000000', `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 `seo_configurations` -- CREATE TABLE `seo_configurations` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(70) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `keywords` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `robots_index` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `robots_follow_links` varchar(50) 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 `seo_configurations` -- INSERT INTO `seo_configurations` (`id`, `lang`, `title`, `description`, `keywords`, `robots_index`, `robots_follow_links`, `created_at`, `updated_at`) VALUES (3, 'en', 'Earn Money Upload Files', 'Earn Money Upload & Sharing Files', 'Upload Files, Upload Earn Money, Earn Money From Upload Files', 'index', 'follow', '2023-03-23 18:29:11', '2023-12-07 23:44:37'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text 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\":\"NeoFiles\",\"site_url\":\"https:\\/\\/neofiles.codenine.biz.id\",\"contact_email\":null,\"terms_of_service_link\":null,\"date_format\":\"10\",\"timezone\":\"America\\/New_York\",\"default_captcha\":null,\"adblock_detection\":null}'), (3, 'smtp', '{\"mailer\":\"smtp\",\"host\":null,\"port\":null,\"username\":null,\"password\":null,\"encryption\":\"tls\",\"from_email\":null,\"from_name\":null,\"status\":0}'), (4, 'actions', '{\"registration_status\":1,\"disposable_emails_status\":1,\"gdpr_cookie_status\":1,\"language_type\":1,\"language_menu\":1,\"blog_status\":1,\"payout_rates_page\":1,\"payment_proof_page\":1,\"email_verification_status\":0,\"force_ssl_status\":0,\"contact_page\":0}'), (5, 'popup', '{\"status\":1,\"body\":\"

<\\/strong><\\/span><\\/p>

What is Lorem Ipsum?<\\/strong><\\/span><\\/h2>

Lorem Ipsum 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>\"}'), (6, 'currency', '{\"code\":\"USD\",\"symbol\":\"$\",\"position\":\"1\",\"earnings_decimals\":\"4\",\"prices_decimals\":\"2\"}'), (7, 'filesystem', '{\"upload\":{\"types\":{\"status\":1,\"extensions\":null},\"chunk_size\":\"90\",\"max_files\":\"4\"},\"download\":{\"links_expiration_time\":\"60\",\"download_links_prefix\":\"download\"},\"others\":{\"default_folders\":\"Videos,Music,Photos,Documents\"}}'), (8, 'earnings', '{\"downloads\":{\"status\":1,\"store\":1,\"paid\":\"1\"},\"referrals\":{\"status\":1,\"percentage\":\"10\"},\"bonus\":{\"users\":\"0\"},\"security\":{\"trustip_api_key\":null,\"blocked_referrers\":null,\"proxy_vpn_detection\":0}}'), (9, 'subscription', '{\"expire_notification\":1,\"delete_expired\":\"3\"}'), (10, 'system', '{\"colors\":{\"primary_color\":\"#04cfd6\",\"secondary_color\":\"#105B81\",\"sidebar_color\":\"#02324B\",\"navbar_color\":\"#ffffff\",\"background_color\":\"#f5f7fa\"}}'); -- -------------------------------------------------------- -- -- Table structure for table `steps` -- CREATE TABLE `steps` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text 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 `steps` -- INSERT INTO `steps` (`id`, `lang`, `title`, `body`, `created_at`, `updated_at`) VALUES (1, 'en', 'Upload Your Files', 'After signing up. You can use our platform to upload and share any type of content.', '2023-03-22 20:15:34', '2023-12-08 07:08:11'), (2, 'en', 'Share Download Links', 'If upload is complete, get the download link then share it with friends or social media and any more', '2023-03-22 20:16:47', '2023-12-08 07:10:49'), (3, 'en', 'Earn Money', 'Share your files with your friends and followers and get paid for every download!', '2023-03-22 20:17:00', '2023-12-08 07:08:38'); -- -------------------------------------------------------- -- -- Table structure for table `storage_providers` -- CREATE TABLE `storage_providers` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `handler` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `credentials` longtext COLLATE utf8mb4_unicode_ci, `instructions` text COLLATE utf8mb4_unicode_ci, `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:Disabled 1:Enabled', `is_default` tinyint(1) 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 `storage_providers` -- INSERT INTO `storage_providers` (`id`, `name`, `alias`, `handler`, `logo`, `credentials`, `instructions`, `status`, `is_default`, `created_at`, `updated_at`) VALUES (1, 'Local Storage', 'local', 'App\\Http\\Controllers\\Storage\\LocalController', 'images/storage/local.png', NULL, NULL, 1, 1, '2022-02-20 22:13:06', '2023-10-06 19:04:41'), (2, 'Amazon S3', 's3', 'App\\Http\\Controllers\\Storage\\AmazonController', 'images/storage/amazon.png', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null}', NULL, 0, 0, '2022-02-20 22:12:55', '2023-10-06 19:04:53'); -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `expiry_at` datetime DEFAULT NULL, `expire_notification` tinyint(4) NOT NULL DEFAULT '0', `is_viewed` 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 `themes` -- CREATE TABLE `themes` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `preview_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) 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', 'The default theme offers a sleek and modern design, prioritizing user-friendly navigation and aesthetics. ', '2023-10-05 01:21:46', '2023-10-05 01:21:46'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `price` double(10,2) NOT NULL, `interval` bigint(20) UNSIGNED NOT NULL, `payment_gateway_id` bigint(20) UNSIGNED DEFAULT NULL, `payment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payer_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:Unpaid 1:Pending 2:Paid 3:Cancelled', `proof` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_viewed` 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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `firstname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lastname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `downloads_earnings` decimal(18,9) NOT NULL DEFAULT '0.000000000', `referrals_earnings` decimal(18,9) NOT NULL DEFAULT '0.000000000', `address` text COLLATE utf8mb4_unicode_ci, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `withdrawal_method_id` bigint(20) UNSIGNED DEFAULT NULL, `withdrawal_account` text COLLATE utf8mb4_unicode_ci, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `google2fa_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0: Disabled, 1: Active', `google2fa_secret` text COLLATE utf8mb4_unicode_ci, `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0: Banned, 1: Active', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_viewed` 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 `user_logs` -- CREATE TABLE `user_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `timezone` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `location` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `browser` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `os` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `withdrawals` -- CREATE TABLE `withdrawals` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `downloads_earnings` decimal(18,9) NOT NULL, `referrals_earnings` decimal(18,9) NOT NULL, `total` decimal(18,9) NOT NULL, `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:Pending 2:Returned 3:Approved 4:Completed 5:Cancelled', `is_viewed` 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 `withdrawal_methods` -- CREATE TABLE `withdrawal_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `minimum` double(8,2) NOT NULL DEFAULT '0.00', `description` text COLLATE utf8mb4_unicode_ci, `sort_id` int(11) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `withdrawal_methods` -- INSERT INTO `withdrawal_methods` (`id`, `name`, `logo`, `minimum`, `description`, `sort_id`, `status`, `created_at`, `updated_at`) VALUES (1, 'Paypal', 'images/withdrawal-methods/kL1dYqKEKMWzgFu_1724819369.svg', 10.00, '

Lorem ipsum dolor sit, Amet consectetur adipisicing elit. Deleniti esse reprehenderit voluptates obcaecati placeat architecto hic ratione ducimus nemo.

', 1, 1, '2023-03-25 23:00:19', '2024-08-27 22:39:10'), (7, 'DANA Dompet', 'images/withdrawal-methods/2xoWGEaL6QuZegs_1724819024.svg', 5.00, NULL, 2, 1, '2024-08-27 22:23:44', '2024-08-27 22:23:44'), (8, 'OVO Dompet', 'images/withdrawal-methods/LDPBdL4bnGuPvT5_1724819323.svg', 5.00, NULL, 3, 1, '2024-08-27 22:27:00', '2024-08-27 22:28:43'), (9, 'Bank Central Asia (BCA)', 'images/withdrawal-methods/lXPOP2tSx09hcp1_1724819493.svg', 10.00, NULL, 4, 1, '2024-08-27 22:31:33', '2024-08-27 22:31:33'), (10, 'Bank Rakyat Indonesia (BRI)', 'images/withdrawal-methods/bmN5JERpw9GIpzJ_1724819567.svg', 10.00, NULL, 5, 1, '2024-08-27 22:32:47', '2024-08-27 22:32:47'), (11, 'Bank Mandiri', 'images/withdrawal-methods/oRQhEwifHLHX1Vy_1724819670.svg', 10.00, NULL, 6, 1, '2024-08-27 22:34:30', '2024-08-27 22:34:30'), (12, 'Bank Negara Indonesia (BNI)', 'images/withdrawal-methods/gueGj6kKPpz0sdc_1724819738.svg', 10.00, NULL, 7, 1, '2024-08-27 22:35:38', '2024-08-27 22:35:38'), (13, 'Google Pay', 'images/withdrawal-methods/DV7DpZncneCpHZu_1724819942.svg', 15.00, NULL, 0, 1, '2024-08-27 22:39:02', '2024-08-27 22:39:10'), (14, 'Bitcoin Crypto', 'images/withdrawal-methods/qjbIJzhjW6jo10t_1724820140.svg', 20.00, NULL, 9, 1, '2024-08-27 22:42:20', '2024-08-27 22:42:20'), (15, 'USDT Tether', 'images/withdrawal-methods/QU4WQqiQmdSuEG7_1724820295.svg', 20.00, NULL, 10, 1, '2024-08-27 22:44:55', '2024-08-27 22:44:55'); -- -- 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 `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `admin_notifications` -- ALTER TABLE `admin_notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin_password_resets` -- ALTER TABLE `admin_password_resets` ADD KEY `admin_password_resets_email_index` (`email`); -- -- Indexes for table `advertisements` -- ALTER TABLE `advertisements` ADD PRIMARY KEY (`id`); -- -- Indexes for table `announcements` -- ALTER TABLE `announcements` ADD PRIMARY KEY (`id`), ADD KEY `announcements_lang_foreign` (`lang`); -- -- 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_category_id_foreign` (`category_id`), ADD KEY `blog_articles_admin_id_foreign` (`admin_id`), ADD KEY `blog_articles_lang_foreign` (`lang`); -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `blog_categories_slug_unique` (`slug`), ADD KEY `blog_categories_lang_foreign` (`lang`); -- -- Indexes for table `blog_comments` -- ALTER TABLE `blog_comments` ADD PRIMARY KEY (`id`), ADD KEY `blog_comments_user_id_foreign` (`user_id`), ADD KEY `blog_comments_article_id_foreign` (`article_id`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `earning_statistics` -- ALTER TABLE `earning_statistics` ADD PRIMARY KEY (`id`), ADD KEY `earning_statistics_user_id_foreign` (`user_id`), ADD KEY `earning_statistics_earning_statistic_id_foreign` (`earning_statistic_id`), ADD KEY `earning_statistics_referral_id_foreign` (`referral_id`); -- -- Indexes for table `editor_files` -- ALTER TABLE `editor_files` ADD PRIMARY KEY (`id`); -- -- Indexes for table `extensions` -- ALTER TABLE `extensions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`), ADD KEY `faqs_lang_foreign` (`lang`); -- -- Indexes for table `features` -- ALTER TABLE `features` ADD PRIMARY KEY (`id`), ADD KEY `features_lang_foreign` (`lang`); -- -- Indexes for table `file_entries` -- ALTER TABLE `file_entries` ADD PRIMARY KEY (`id`), ADD KEY `file_entries_user_id_foreign` (`user_id`), ADD KEY `file_entries_parent_id_foreign` (`parent_id`), ADD KEY `file_entries_storage_provider_id_foreign` (`storage_provider_id`); -- -- Indexes for table `file_reports` -- ALTER TABLE `file_reports` ADD PRIMARY KEY (`id`), ADD KEY `file_reports_file_entry_id_foreign` (`file_entry_id`); -- -- Indexes for table `footer_menu` -- ALTER TABLE `footer_menu` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `footer_menu_name_unique` (`name`), ADD KEY `footer_menu_lang_foreign` (`lang`), ADD KEY `footer_menu_parent_id_foreign` (`parent_id`); -- -- Indexes for table `languages` -- ALTER TABLE `languages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `languages_code_unique` (`code`); -- -- Indexes for table `mail_templates` -- ALTER TABLE `mail_templates` ADD PRIMARY KEY (`id`), ADD KEY `mail_templates_lang_foreign` (`lang`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `navbar_menu` -- ALTER TABLE `navbar_menu` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `navbar_menu_name_unique` (`name`), ADD KEY `navbar_menu_lang_foreign` (`lang`), ADD KEY `navbar_menu_parent_id_foreign` (`parent_id`); -- -- Indexes for table `oauth_providers` -- ALTER TABLE `oauth_providers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `pages_page_slug_unique` (`slug`), ADD KEY `pages_lang_foreign` (`lang`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payment_gateways` -- ALTER TABLE `payment_gateways` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payout_rates` -- ALTER TABLE `payout_rates` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `payout_rates_country_id_unique` (`country_id`); -- -- Indexes for table `plans` -- ALTER TABLE `plans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `premium_plans` -- ALTER TABLE `premium_plans` ADD PRIMARY KEY (`id`), ADD KEY `premium_plans_plan_id_foreign` (`plan_id`); -- -- Indexes for table `referrals` -- ALTER TABLE `referrals` ADD PRIMARY KEY (`id`), ADD KEY `referrals_referring_user_id_foreign` (`referring_user_id`), ADD KEY `referrals_referred_user_id_foreign` (`referred_user_id`); -- -- Indexes for table `seo_configurations` -- ALTER TABLE `seo_configurations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `seo_configurations_lang_unique` (`lang`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `steps` -- ALTER TABLE `steps` ADD PRIMARY KEY (`id`), ADD KEY `steps_lang_foreign` (`lang`); -- -- Indexes for table `storage_providers` -- ALTER TABLE `storage_providers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `subscriptions_user_id_foreign` (`user_id`); -- -- Indexes for table `themes` -- ALTER TABLE `themes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `themes_alias_unique` (`alias`); -- -- 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`); -- -- 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_mobile_unique` (`mobile`), ADD KEY `users_withdrawal_method_id_foreign` (`withdrawal_method_id`); -- -- Indexes for table `user_logs` -- ALTER TABLE `user_logs` ADD PRIMARY KEY (`id`), ADD KEY `user_logs_user_id_foreign` (`user_id`); -- -- Indexes for table `withdrawals` -- ALTER TABLE `withdrawals` ADD PRIMARY KEY (`id`), ADD KEY `withdrawals_user_id_foreign` (`user_id`); -- -- Indexes for table `withdrawal_methods` -- ALTER TABLE `withdrawal_methods` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `withdrawal_methods_name_unique` (`name`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `addons` -- ALTER TABLE `addons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `admin_notifications` -- ALTER TABLE `admin_notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `advertisements` -- ALTER TABLE `advertisements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `announcements` -- ALTER TABLE `announcements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_articles` -- ALTER TABLE `blog_articles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_comments` -- ALTER TABLE `blog_comments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253; -- -- AUTO_INCREMENT for table `earning_statistics` -- ALTER TABLE `earning_statistics` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `editor_files` -- ALTER TABLE `editor_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `extensions` -- ALTER TABLE `extensions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `features` -- ALTER TABLE `features` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `file_entries` -- ALTER TABLE `file_entries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `file_reports` -- ALTER TABLE `file_reports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `footer_menu` -- ALTER TABLE `footer_menu` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `languages` -- ALTER TABLE `languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `mail_templates` -- ALTER TABLE `mail_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170; -- -- AUTO_INCREMENT for table `navbar_menu` -- ALTER TABLE `navbar_menu` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `oauth_providers` -- ALTER TABLE `oauth_providers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `payment_gateways` -- ALTER TABLE `payment_gateways` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `payout_rates` -- ALTER TABLE `payout_rates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `plans` -- ALTER TABLE `plans` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `premium_plans` -- ALTER TABLE `premium_plans` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `referrals` -- ALTER TABLE `referrals` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `seo_configurations` -- ALTER TABLE `seo_configurations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `steps` -- ALTER TABLE `steps` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `storage_providers` -- ALTER TABLE `storage_providers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `themes` -- ALTER TABLE `themes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `user_logs` -- ALTER TABLE `user_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `withdrawals` -- ALTER TABLE `withdrawals` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `withdrawal_methods` -- ALTER TABLE `withdrawal_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- Constraints for dumped tables -- -- -- Constraints for table `announcements` -- ALTER TABLE `announcements` ADD CONSTRAINT `announcements_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `blog_articles` -- ALTER TABLE `blog_articles` ADD CONSTRAINT `blog_articles_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `blog_articles_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `blog_articles_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `blog_categories` -- ALTER TABLE `blog_categories` ADD CONSTRAINT `blog_categories_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `blog_comments` -- ALTER TABLE `blog_comments` ADD CONSTRAINT `blog_comments_article_id_foreign` FOREIGN KEY (`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 `earning_statistics` -- ALTER TABLE `earning_statistics` ADD CONSTRAINT `earning_statistics_earning_statistic_id_foreign` FOREIGN KEY (`earning_statistic_id`) REFERENCES `earning_statistics` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `earning_statistics_referral_id_foreign` FOREIGN KEY (`referral_id`) REFERENCES `referrals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `earning_statistics_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `faqs` -- ALTER TABLE `faqs` ADD CONSTRAINT `faqs_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `features` -- ALTER TABLE `features` ADD CONSTRAINT `features_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `file_entries` -- ALTER TABLE `file_entries` ADD CONSTRAINT `file_entries_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `file_entries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `file_entries_storage_provider_id_foreign` FOREIGN KEY (`storage_provider_id`) REFERENCES `storage_providers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `file_entries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `file_reports` -- ALTER TABLE `file_reports` ADD CONSTRAINT `file_reports_file_entry_id_foreign` FOREIGN KEY (`file_entry_id`) REFERENCES `file_entries` (`id`) ON DELETE CASCADE; -- -- Constraints for table `footer_menu` -- ALTER TABLE `footer_menu` ADD CONSTRAINT `footer_menu_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE, ADD CONSTRAINT `footer_menu_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `footer_menu` (`id`) ON DELETE CASCADE; -- -- Constraints for table `mail_templates` -- ALTER TABLE `mail_templates` ADD CONSTRAINT `mail_templates_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `navbar_menu` -- ALTER TABLE `navbar_menu` ADD CONSTRAINT `navbar_menu_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE, ADD CONSTRAINT `navbar_menu_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `navbar_menu` (`id`) ON DELETE CASCADE; -- -- Constraints for table `pages` -- ALTER TABLE `pages` ADD CONSTRAINT `pages_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `payout_rates` -- ALTER TABLE `payout_rates` ADD CONSTRAINT `payout_rates_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `premium_plans` -- ALTER TABLE `premium_plans` ADD CONSTRAINT `premium_plans_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE; -- -- Constraints for table `referrals` -- ALTER TABLE `referrals` ADD CONSTRAINT `referrals_referred_user_id_foreign` FOREIGN KEY (`referred_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `referrals_referring_user_id_foreign` FOREIGN KEY (`referring_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `seo_configurations` -- ALTER TABLE `seo_configurations` ADD CONSTRAINT `seo_configurations_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `steps` -- ALTER TABLE `steps` ADD CONSTRAINT `steps_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE; -- -- Constraints for table `subscriptions` -- ALTER TABLE `subscriptions` ADD CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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`) ON DELETE CASCADE, ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_withdrawal_method_id_foreign` FOREIGN KEY (`withdrawal_method_id`) REFERENCES `withdrawal_methods` (`id`) ON DELETE SET NULL; -- -- Constraints for table `user_logs` -- ALTER TABLE `user_logs` ADD CONSTRAINT `user_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `withdrawals` -- ALTER TABLE `withdrawals` ADD CONSTRAINT `withdrawals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;