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

START TRANSACTION;



--
-- Database: `mimeld_mxtransfer`
--

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

--
-- Table structure for table `additionals`
--

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

--
-- Dumping data for table `additionals`
--

INSERT INTO `additionals` (`id`, `key`, `value`) VALUES
(4, 'popup_notice_status', '0'),
(5, 'popup_notice_description', '<h2 style=\"text-align:center\"><span style=\"color:#1abc9c\"><strong>What is Lorem Ipsum?</strong></span></h2>\r\n\r\n<p style=\"text-align:center\"><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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>');

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

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

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

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

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

CREATE TABLE `admin_password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) 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,
  `position` varchar(255) NOT NULL,
  `size` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) NOT NULL,
  `code` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` (`id`, `position`, `size`, `symbol`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Home Page (Top)', 'Responsive', 'home_page_top', NULL, 0, '2022-05-09 19:10:23', '2024-05-04 13:04:26'),
(2, 'Home Page (Bottom)', 'Responsive', 'home_page_bottom', NULL, 0, '2022-05-09 19:10:23', '2022-05-10 08:54:37'),
(3, 'Blog Articles (Center)', 'Responsive', 'blog_articles_center', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:05'),
(4, 'Blog Articles (Bottom)', 'Responsive', 'blog_articles_bottom', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:10'),
(5, 'Blog Sidebar', 'Responsive', 'blog_sidebar', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:15'),
(6, 'Blog Single Article (Top)', 'Responsive', 'blog_single_article_top', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:20'),
(7, 'Blog Single Article (Bottom)', 'Responsive', 'blog_single_article_bottom', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:26'),
(8, 'Download Page (Top)', 'Responsive', 'download_page_top', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:32'),
(9, 'Download Page (Bottom)', 'Responsive', 'download_page_bottom', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:38'),
(10, 'Download Page (Down Bottom)', 'Responsive', 'download_page_down_bottom', NULL, 0, '2022-05-09 22:09:41', '2022-05-10 08:56:42'),
(11, 'Head Code', NULL, 'head_code', NULL, 0, '2022-05-09 23:09:26', '2022-05-09 18:23:17');

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

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

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

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(20) NOT NULL,
  `percentage` bigint(20) NOT NULL DEFAULT 1,
  `plan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action_type` tinyint(4) NOT NULL,
  `limit` bigint(20) NOT NULL DEFAULT 1,
  `expiry_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `code`, `percentage`, `plan_id`, `action_type`, `limit`, `expiry_at`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'VVGSHT7PH0AM', 20, 3, 0, 2, '2024-10-17 07:43:00', NULL, '2024-10-03 22:13:18', '2024-10-03 22:13:18');

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

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

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

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text 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`, `content`, `created_at`, `updated_at`) VALUES
(1, 'en', 'How do I upload a file?', '<p>To upload a file, simply click on the &quot;Upload&quot; button and select the file from your device. You can also drag and drop files directly onto the upload area.</p>', '2024-05-06 04:39:11', '2024-05-06 04:39:11'),
(2, 'en', 'What types of files can I upload?', '<p>Our platform supports a variety of file types including documents (PDF, DOCX, etc.), images (JPEG, PNG, etc.), videos, and more. However, there may be limitations on file size and formats, so please check our guidelines.</p>', '2024-05-06 04:40:07', '2024-05-06 04:40:07'),
(3, 'en', 'How do I download a file that has been shared with me?', '<p>To download a file, simply click on the file name or thumbnail to open the file preview, then click on the &quot;Download&quot; button.</p>', '2024-05-06 04:40:58', '2024-05-06 04:40:58'),
(4, 'en', 'Can I share files with others?', '<p>Yes, you can share files with others by generating a unique link or by inviting specific individuals via email. You can control who has access to your files and set permissions accordingly.</p>', '2024-05-06 04:42:16', '2024-05-06 04:42:16'),
(5, 'en', 'Is the file transfer secure?', '<p>Yes, we prioritize security and use encryption protocols to ensure that your files are transferred securely. However, it&#39;s always recommended to avoid sharing sensitive information unless necessary.</p>', '2024-05-06 04:43:09', '2024-05-06 04:43:09'),
(6, 'en', 'How long are files stored on the platform?', '<p>Files are typically stored for a specified period of time, after which they may be automatically deleted. Please check our policies for details on file retention.</p>', '2024-05-06 04:44:04', '2024-05-06 04:44:04'),
(7, 'en', 'What happens if I encounter an error during file transfer?', '<p>If you encounter any errors during file transfer, please try again later. If the issue persists, you can contact our support team for assistance.</p>', '2024-05-06 04:45:29', '2024-05-06 04:45:29'),
(8, 'en', 'Is there a limit to the number of files I can transfer?', '<p>There may be limits on the number of files you can transfer depending on your account type and subscription plan. Please refer to our pricing and plans for more information.</p>', '2024-05-06 04:47:05', '2024-05-06 04:47:05');

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `footer_menu`
--

CREATE TABLE `footer_menu` (
  `id` int(10) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `name` varchar(100) NOT NULL,
  `link` text 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;

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `native` varchar(150) NOT NULL,
  `code` varchar(3) 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`, `native`, `code`, `created_at`, `updated_at`) VALUES
(1, 'English', 'English', 'en', '2024-05-04 10:10:02', '2024-05-04 10:10:02'),
(3, 'Spanish', 'Spanish', 'es', '2024-05-04 10:10:02', '2024-05-04 10:10:02');

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

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

CREATE TABLE `mail_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `group_name` varchar(255) NOT NULL,
  `key` text NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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
(2, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(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),
(15, '2021_10_13_195121_create_messages_table', 7),
(26, '2019_08_19_000000_create_failed_jobs_table', 8),
(27, '2021_10_14_230536_create_languages_table', 8),
(29, '2021_10_17_222714_create_additionals_table', 9),
(51, '2021_10_24_215104_create_seo_configurations_table', 11),
(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),
(64, '2021_11_25_183407_add_columns_to_users_table', 21),
(65, '2014_10_12_000000_create_users_table', 22),
(66, '2021_10_20_204848_create_support_tickets_table', 22),
(67, '2021_10_20_204947_create_support_replies_table', 22),
(68, '2021_10_20_211900_create_support_attachments_table', 22),
(71, '2021_11_01_162229_create_user_logs_table', 23),
(73, '2021_12_01_100425_create_admin_notifications_table', 24),
(74, '2021_12_05_004428_create_user_notifications_table', 25),
(77, '2021_12_05_230539_create_social_providers_table', 26),
(82, '2021_12_28_203912_add_views_to_blog_categories_table', 29),
(83, '2021_12_28_203935_add_views_to_blog_articles_table', 29),
(84, '2021_12_28_204116_add_views_to_pages_table', 30),
(86, '2021_12_15_215308_create_footer_menu_table', 31),
(87, '2022_01_06_180145_create_blog_comments_table', 32),
(89, '2022_01_08_213840_create_payment_gateways_table', 34),
(92, '2021_10_28_191044_create_storage_providers_table', 36),
(93, '2022_02_23_213634_create_extensions_table', 37),
(94, '2022_01_12_214207_create_addons_table', 38),
(95, '2022_02_26_131252_create_faqs_table', 39),
(96, '2021_12_14_233352_create_navbar_menu_table', 40),
(99, '2022_02_28_193538_create_plans_table', 41),
(105, '2022_03_04_202348_create_subscriptions_table', 42),
(109, '2022_03_07_231527_create_taxes_table', 44),
(115, '2022_03_22_210122_create_transfers_table', 49),
(116, '2022_04_03_220038_create_mail_templates_table', 50),
(117, '2022_04_27_210604_create_slideshows_table', 51),
(118, '2022_05_09_170656_create_advertisements_table', 52),
(120, '2022_05_11_175131_create_coupons_table', 53),
(123, '2022_03_04_205910_create_transactions_table', 54),
(124, '2022_01_06_225055_create_features_table', 55),
(127, '2022_03_18_001216_create_uploads_table', 56),
(128, '2022_03_22_210123_create_transfer_files_table', 56);

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

--
-- Table structure for table `navbar_menu`
--

CREATE TABLE `navbar_menu` (
  `id` int(10) UNSIGNED NOT NULL,
  `page` tinyint(4) NOT NULL,
  `lang` varchar(3) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `link` text 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 `navbar_menu`
--

INSERT INTO `navbar_menu` (`id`, `page`, `lang`, `name`, `type`, `link`, `sort_id`, `created_at`, `updated_at`) VALUES
(1, 0, 'en', 'About us', 0, 'https://mxtransfer.mimeld.com/en/about-us', 0, '2024-05-04 10:41:38', '2024-05-05 04:03:49'),
(2, 0, 'en', 'Prices', 1, '#prices', 1, '2024-05-04 11:13:34', '2024-05-04 15:13:30'),
(3, 0, 'en', 'FAQ', 1, '#faq', 2, '2024-05-04 15:06:00', '2024-05-08 04:25:37'),
(4, 0, 'en', 'Contact', 1, '#contact', 4, '2024-05-04 15:14:30', '2024-05-04 15:15:08');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `short_description` varchar(200) 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
(1, 'en', 'About us', 'about-us', '<p>Welcome to Mxtransfer, your ultimate destination for seamless and reliable transportation solutions. We understand the importance of efficient and hassle-free transfers, whether you&#39;re commuting daily or embarking on a journey of exploration. At Mxtransfer, we&#39;re committed to providing you with top-notch service that exceeds your expectations every step of the way.</p>\r\n\r\n<p>With years of experience in the transportation industry, we&#39;ve honed our expertise to offer a comprehensive range of transfer options tailored to your needs. From airport transfers to city tours, corporate events to leisure trips, we&#39;ve got you covered. Our fleet of vehicles is meticulously maintained to ensure your safety and comfort on every ride.</p>\r\n\r\n<p>What sets Mxtransfer apart is our unwavering dedication to customer satisfaction. We believe in going the extra mile to make your journey memorable for all the right reasons. Our team of professional drivers is handpicked for their expertise, professionalism, and commitment to service excellence. Whether you&#39;re traveling solo, with family, or in a group, you can trust us to provide personalized attention and assistance to meet your specific requirements.</p>\r\n\r\n<p>At Mxtransfer, we prioritize convenience and efficiency without compromising on quality. Our user-friendly online booking platform allows you to reserve your transfer in just a few clicks, eliminating the hassle of waiting in queues or dealing with last-minute arrangements. With real-time tracking and updates, you can have peace of mind knowing that your transfer is in safe hands from start to finish.</p>\r\n\r\n<p>We understand that every journey is unique, which is why we offer customizable transfer solutions to suit your preferences and budget. Whether you prefer a luxurious sedan, spacious SUV, or a comfortable minivan, we have the perfect vehicle to accommodate your needs. Need special arrangements or additional services? Just let us know, and we&#39;ll tailor your transfer experience accordingly.</p>\r\n\r\n<p>At Mxtransfer, we&#39;re not just in the business of getting you from point A to point B; we&#39;re committed to creating memorable experiences that leave a lasting impression. Whether you&#39;re traveling for business or leisure, our goal is to ensure that you arrive at your destination safely, comfortably, and on time, every time.</p>', 'About us', 73, '2024-05-04 10:12:37', '2024-10-07 21:52:12');

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

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

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

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

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

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

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

--
-- Table structure for table `seo_configurations`
--

CREATE TABLE `seo_configurations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `title` varchar(70) NOT NULL,
  `description` varchar(150) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `robots_index` varchar(50) NOT NULL,
  `robots_follow_links` varchar(50) 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 `settings`
--

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

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

INSERT INTO `settings` (`id`, `key`, `value`) VALUES
(1, 'website_name', 'MXTransfer'),
(2, 'website_url', 'https://mxtransfer.mimeld.com'),
(3, 'website_dark_logo', 'images/dark-logo.png'),
(4, 'website_light_logo', 'images/light-logo.png'),
(5, 'website_favicon', 'images/favicon.png'),
(6, 'website_social_image', 'images/social-image.jpg'),
(7, 'website_primary_color', '#FFCE43'),
(8, 'website_secondary_color', '#FFCE43'),
(9, 'website_email_verify_status', '0'),
(10, 'website_registration_status', '1'),
(11, 'mail_status', '1'),
(12, 'mail_mailer', 'smtp'),
(13, 'mail_host', 'mail.mimeld.com'),
(14, 'mail_port', '465'),
(15, 'mail_username', 'info@mimeld.com'),
(16, 'mail_password', 'Coder_$321'),
(17, 'mail_encryption', 'ssl'),
(18, 'mail_form_email', 'mxtransfer@mimeld.com'),
(19, 'mail_from_name', 'MXTransfer'),
(25, 'contact_email', 'info@miracuves.com'),
(34, 'terms_of_service_link', 'https://mxtransfer.mimeld.com'),
(36, 'website_cookie', '1'),
(38, 'date_format', '14'),
(39, 'timezone', 'America/New_York'),
(40, 'website_force_ssl_status', '0'),
(45, 'website_blog_status', '1'),
(46, 'website_contact_form_status', '1'),
(47, 'website_currency', '5'),
(50, 'expired_subscriptions_data_delete', '30'),
(51, 'unaccepted_file_types', 'exe,php'),
(55, 'website_tickets_status', '1'),
(56, 'website_mail_logo', 'images/mail-logo.png'),
(57, 'website_mail_primary_color', '#5BBC2E'),
(58, 'website_mail_background_color', '#EDF2F7'),
(59, 'website_mail_normal_text_color', '#718096'),
(60, 'website_mail_bold_text_color', '#3D4852'),
(61, 'active_users_counter', '0'),
(62, 'transferred_files_counter', '0'),
(63, 'daily_visitors_couner', '0'),
(64, 'all_time_downloads_couner', '0'),
(65, 'counter_status', '0'),
(66, 'website_faq_status', '1'),
(67, 'website_file_icon_dark_color', '#5BBC2E'),
(68, 'website_file_icon_medium_color', '#74D249'),
(69, 'website_file_icon_light_color', '#93E76C');

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

--
-- Table structure for table `slideshows`
--

CREATE TABLE `slideshows` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '1:Image 2:Video',
  `source` tinyint(1) NOT NULL COMMENT '1:Upload 2:URL',
  `file` text NOT NULL,
  `duration` 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 `slideshows`
--

INSERT INTO `slideshows` (`id`, `type`, `source`, `file`, `duration`, `created_at`, `updated_at`) VALUES
(3, 1, 1, 'uploads/slideshow/vIEK5bPTLRLWWkc_1715222792.jpg', 1, '2024-05-08 19:45:38', '2024-05-08 20:46:33');

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

--
-- Table structure for table `social_providers`
--

CREATE TABLE `social_providers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `facebook` varchar(100) 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 `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0:Disabled 1:Active',
  `expiry_at` timestamp NULL DEFAULT NULL,
  `read_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 `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `plan_id`, `status`, `expiry_at`, `read_status`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 1, NULL, 1, '2024-05-04 10:20:29', '2024-10-03 22:11:48');

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

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

CREATE TABLE `support_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_reply_id` bigint(20) UNSIGNED NOT NULL,
  `attachment` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_replies`
--

CREATE TABLE `support_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `support_ticket_id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_number` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `subject` varchar(255) NOT NULL,
  `priority` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0: Normal, 1: Low , 2: High, 3: Urgent',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0: Opened, 1: Answered, 2: Replied, 3: Closed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `percentage` 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;

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `checkout_id` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED DEFAULT NULL,
  `details_before_discount` longtext NOT NULL,
  `details_after_discount` longtext DEFAULT NULL,
  `plan_price` double(10,2) NOT NULL,
  `tax_price` double(10,2) NOT NULL DEFAULT 0.00,
  `fees_price` double(10,2) NOT NULL DEFAULT 0.00,
  `total_price` double(10,2) NOT NULL,
  `payment_gateway_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `payer_id` varchar(255) DEFAULT NULL,
  `payer_email` varchar(255) DEFAULT NULL,
  `type` tinyint(4) NOT NULL COMMENT '0:Subscribe 1:renew 2:Upgrade',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1:Pending 2:Paid 3:Canceled',
  `cancellation_reason` text DEFAULT NULL,
  `read_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 `transactions`
--

INSERT INTO `transactions` (`id`, `checkout_id`, `transaction_id`, `user_id`, `plan_id`, `coupon_id`, `details_before_discount`, `details_after_discount`, `plan_price`, `tax_price`, `fees_price`, `total_price`, `payment_gateway_id`, `payment_id`, `payer_id`, `payer_email`, `type`, `status`, `cancellation_reason`, `read_status`, `created_at`, `updated_at`) VALUES
(1, 'f11baf84f1182eb4c3d5415b3164d1c4181d85da', 'E25CNBT2WOOMB2TV', 1, 1, NULL, '{\"plan_price\":\"0.00\",\"tax_price\":\"0.00\",\"total_price\":\"0.00\"}', NULL, 0.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, 0, 2, NULL, 1, '2024-05-04 10:20:03', '2024-05-04 10:37:05'),
(2, 'ac748fc7c57ab95945930cfc22c4f71fd6bbd2b7', '4XWVUXNZP115R9D7', 2, 2, NULL, '{\"plan_price\":\"9.00\",\"tax_price\":\"0.00\",\"total_price\":\"9.00\"}', NULL, 9.00, 0.00, 0.00, 9.00, NULL, 'cs_test_a1brTKqvc72yLVSb9CbCP2JxB4RAYldYdNwMu9RVsMSZo6vXNUs9biTKon', NULL, NULL, 0, 1, NULL, 0, '2024-05-05 22:52:10', '2024-05-05 22:53:28'),
(3, '99b7aac24df9de378bae0e56ebcdc18c32132611', 'P9TXJ5YG159VZ8DJ', 4, 1, NULL, '{\"plan_price\":\"0.00\",\"tax_price\":\"0.00\",\"total_price\":\"0.00\"}', NULL, 0.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, '2024-06-08 13:15:59', '2024-06-08 13:15:59'),
(4, '50f3b011408cd8780fc32080af10ab93cf4c7f21', '95JQGYGFM2GT7CYR', 1, 4, NULL, '{\"plan_price\":\"99.99\",\"tax_price\":\"0.00\",\"total_price\":\"99.99\"}', NULL, 99.99, 0.00, 0.00, 99.99, NULL, NULL, NULL, NULL, 2, 0, NULL, 0, '2024-06-28 06:44:35', '2024-06-28 06:44:35'),
(5, '5e6437a121c046e9cc877d1289a56b70b545ba38', 'OTHX5W2B349SZOJE', 1, 2, NULL, '{\"plan_price\":\"9.00\",\"tax_price\":\"0.00\",\"total_price\":\"9.00\"}', NULL, 9.00, 0.00, 0.00, 9.00, NULL, 'cs_test_a1NbWZlQFQs4VIZNUAqilI8hqfUI2yR82NfRG0LIJffxPMLb0T6zw8mFtf', NULL, NULL, 2, 1, NULL, 0, '2024-10-03 06:00:55', '2024-10-03 06:01:03'),
(6, '4192bafbd2a85e9ba0493a9073ef02c5f52a6154', 'JO636MSTZ4VU7WMJ', 1, 2, NULL, '{\"plan_price\":\"9.00\",\"tax_price\":\"0.00\",\"total_price\":\"9.00\"}', NULL, 9.00, 0.00, 0.00, 9.00, NULL, 'cs_test_a1esEBxRKVpfeLj1eVWUs4gxCsIJCKHU64rOSzKt3tt1oxmZIumVlNqJ0V', NULL, NULL, 2, 1, NULL, 0, '2024-10-03 21:50:13', '2024-10-03 21:50:29'),
(7, '0c7e6a6e256bb2c888d4ed1b16871677d894025e', 'DUUXOECE14R7UN5W', 1, 2, NULL, '{\"plan_price\":\"9.00\",\"tax_price\":\"0.00\",\"total_price\":\"9.00\"}', NULL, 9.00, 0.00, 0.00, 9.00, NULL, NULL, NULL, NULL, 1, 0, NULL, 0, '2024-10-03 22:03:04', '2024-10-03 22:03:04');

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

--
-- Table structure for table `transfer_files`
--

CREATE TABLE `transfer_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transfer_id` bigint(20) UNSIGNED NOT NULL,
  `storage_provider_id` bigint(20) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `filename` varchar(255) NOT NULL,
  `mime` varchar(255) NOT NULL,
  `extension` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `path` text NOT NULL,
  `downloads` 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 `transfer_files`
--

INSERT INTO `transfer_files` (`id`, `ip`, `user_id`, `transfer_id`, `storage_provider_id`, `name`, `filename`, `mime`, `extension`, `size`, `path`, `downloads`, `created_at`, `updated_at`) VALUES
(7, '152.58.131.126', NULL, 7, 1, 'miracuvex_mytransfer.sql', '4XcSNEcaYlC5cft_1714903337.sql', 'application/x-sql', 'sql', '269466', 'anonymous/4XcSNEcaYlC5cft_1714903337.sql', 0, '2024-05-05 04:02:31', '2024-05-05 04:02:31'),
(8, '194.146.93.104', NULL, 8, 1, 'saastheme-55.rar', 'mG8vfGuC4bl76QP_1715610367.rar', 'application/x-rar', 'rar', '172692', 'anonymous/mG8vfGuC4bl76QP_1715610367.rar', 0, '2024-05-13 08:26:31', '2024-05-13 08:26:31'),
(9, '96.22.171.110', NULL, 9, 1, 'Mock Demo Reel Example.mp4', 'welvnYIeqXrJ4ci_1717874045.mp4', 'video/mp4', 'mp4', '17472973', 'anonymous/welvnYIeqXrJ4ci_1717874045.mp4', 1, '2024-06-08 13:14:40', '2024-06-08 13:14:49'),
(10, '110.226.183.251', NULL, 10, 1, '1727938442-file.xlsx', 'gNJJGkTw1fRsDFf_1727956975.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'xlsx', '5863', 'anonymous/gNJJGkTw1fRsDFf_1727956975.xlsx', 1, '2024-10-03 06:03:13', '2024-10-03 06:03:33'),
(12, '49.15.224.225', 1, 12, 1, '8.jpg', 'V43wqzAWxxggaZ0_1728013758.jpg', 'image/jpeg', 'jpg', '104616', 'users/V53YMO/V43wqzAWxxggaZ0_1728013758.jpg', 0, '2024-10-03 21:49:47', '2024-10-03 21:49:47'),
(13, '49.15.224.225', NULL, 13, 1, '8.jpg', '3xrFpqR8ynpUXJi_1728014358.jpg', 'image/jpeg', 'jpg', '104616', 'anonymous/3xrFpqR8ynpUXJi_1728014358.jpg', 1, '2024-10-03 21:59:40', '2024-10-03 22:12:05'),
(14, '49.15.224.225', 1, 14, 1, 'car1.jpg', 'c7x1TxW9FqKk2M4_1728014466.jpg', 'image/jpeg', 'jpg', '5164', 'users/V53YMO/c7x1TxW9FqKk2M4_1728014466.jpg', 0, '2024-10-03 22:01:56', '2024-10-03 22:01:56'),
(15, '49.15.224.225', 1, 14, 1, 'car4.jpg', 'o0apRL6VYAWaMDl_1728014467.jpg', 'image/jpeg', 'jpg', '40751', 'users/V53YMO/o0apRL6VYAWaMDl_1728014467.jpg', 0, '2024-10-03 22:01:56', '2024-10-03 22:01:56'),
(16, '49.15.224.225', 1, 14, 1, 'car2.jpg', 'HjwPCQFYuoROvzL_1728014467.jpg', 'image/jpeg', 'jpg', '114755', 'users/V53YMO/HjwPCQFYuoROvzL_1728014467.jpg', 0, '2024-10-03 22:01:56', '2024-10-03 22:01:56'),
(18, '49.15.224.225', 1, 15, 1, '8.jpg', 'uHsBjcIb000XeBU_1728014537.jpg', 'image/jpeg', 'jpg', '104616', 'users/V53YMO/uHsBjcIb000XeBU_1728014537.jpg', 0, '2024-10-03 22:02:19', '2024-10-03 22:02:19'),
(19, '49.15.224.225', 1, 16, 1, 'hardrive.jpg', '818z01YVf5G9CJ5_1728014666.jpg', 'image/jpeg', 'jpg', '49019', 'users/V53YMO/818z01YVf5G9CJ5_1728014666.jpg', 1, '2024-10-03 22:04:40', '2024-10-03 22:04:52'),
(20, '49.15.224.225', 1, 17, 1, 'doctor1.jpg', 'uZyjyXsJ8mVXHel_1728014813.jpg', 'image/jpeg', 'jpg', '15189', 'users/V53YMO/uZyjyXsJ8mVXHel_1728014813.jpg', 0, '2024-10-03 22:07:28', '2024-10-03 22:07:28'),
(21, '49.15.224.225', 1, 17, 1, 'Fake id 2.jpg', 'sV2UzFttXFRqA01_1728014813.jpg', 'image/jpeg', 'jpg', '21819', 'users/V53YMO/sV2UzFttXFRqA01_1728014813.jpg', 0, '2024-10-03 22:07:28', '2024-10-03 22:07:28'),
(22, '49.15.224.225', 1, 17, 1, 'Fake id 1.jpg', 'WUcy611mvCi3v0L_1728014813.jpg', 'image/jpeg', 'jpg', '27851', 'users/V53YMO/WUcy611mvCi3v0L_1728014813.jpg', 0, '2024-10-03 22:07:28', '2024-10-03 22:07:28'),
(23, '49.15.224.225', 1, 18, 1, 'ifa.jpg', 'XQRggjmUrNZvt5t_1728014968.jpg', 'image/jpeg', 'jpg', '45177', 'users/V53YMO/XQRggjmUrNZvt5t_1728014968.jpg', 0, '2024-10-03 22:09:43', '2024-10-03 22:09:43'),
(24, '103.201.151.122', NULL, 19, 1, 'cv.txt', 'BZmmNQRLBaA5iGW_1728019853.txt', 'text/plain', 'txt', '18', 'anonymous/BZmmNQRLBaA5iGW_1728019853.txt', 1, '2024-10-03 23:32:16', '2024-10-03 23:32:45'),
(25, '103.201.151.122', NULL, 20, 1, 'cv.txt', 'lMottimrlxV4r09_1728019960.txt', 'text/plain', 'txt', '18', 'anonymous/lMottimrlxV4r09_1728019960.txt', 0, '2024-10-03 23:33:53', '2024-10-03 23:33:53'),
(26, '103.201.151.122', NULL, 21, 1, 'cv.txt', 'tlY3JXPZ7HhVUy3_1728020055.txt', 'text/plain', 'txt', '18', 'anonymous/tlY3JXPZ7HhVUy3_1728020055.txt', 0, '2024-10-03 23:34:19', '2024-10-03 23:34:19'),
(27, '103.201.151.122', NULL, 22, 1, 'cv.txt', '3uayCcOCW0K6dG8_1728026773.txt', 'text/plain', 'txt', '18', 'anonymous/3uayCcOCW0K6dG8_1728026773.txt', 0, '2024-10-04 01:27:13', '2024-10-04 01:27:13'),
(28, '103.201.151.122', NULL, 23, 1, 'cv.txt', 'tPq91mur2CrQ6td_1728026866.txt', 'text/plain', 'txt', '18', 'anonymous/tPq91mur2CrQ6td_1728026866.txt', 0, '2024-10-04 01:28:22', '2024-10-04 01:28:22'),
(29, '103.201.151.122', 1, 24, 1, 'cv.txt', 'gGkU4kqAQUZtYiH_1728029095.txt', 'text/plain', 'txt', '18', 'users/V53YMO/gGkU4kqAQUZtYiH_1728029095.txt', 0, '2024-10-04 02:05:32', '2024-10-04 02:05:32'),
(30, '103.201.151.122', 1, 25, 1, 'cv.txt', 'IKTa4n80QthXlEj_1728029179.txt', 'text/plain', 'txt', '18', 'users/V53YMO/IKTa4n80QthXlEj_1728029179.txt', 1, '2024-10-04 02:06:39', '2024-10-04 02:07:11'),
(32, '103.201.151.122', 1, 26, 1, 'cv (1).txt', 'z3p3IbKhXaEuCWc_1728029666.txt', 'text/plain', 'txt', '18', 'users/V53YMO/z3p3IbKhXaEuCWc_1728029666.txt', 0, '2024-10-04 02:14:48', '2024-10-04 02:14:48');

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

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

CREATE TABLE `translates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(3) NOT NULL,
  `group_name` varchar(255) NOT NULL DEFAULT 'general',
  `key` text NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;





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

--
-- Table structure for table `uploads`
--

CREATE TABLE `uploads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `storage_provider_id` bigint(20) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `filename` varchar(255) NOT NULL,
  `mime` varchar(255) NOT NULL,
  `extension` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `path` text 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 `uploads`
--

INSERT INTO `uploads` (`id`, `ip`, `user_id`, `storage_provider_id`, `name`, `filename`, `mime`, `extension`, `size`, `path`, `created_at`, `updated_at`) VALUES
(2, '202.8.119.203', NULL, 1, 'miracuvex_mytrans.sql', 'a4fQHEUwPfu1LxG_1714841012.sql', 'application/x-sql', 'sql', '185290', 'anonymous/a4fQHEUwPfu1LxG_1714841012.sql', '2024-05-04 10:43:32', '2024-05-04 10:43:32'),
(4, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', 'SSkaOT7ip9qUlIs_1714850897.sql', 'application/x-sql', 'sql', '269462', 'anonymous/SSkaOT7ip9qUlIs_1714850897.sql', '2024-05-04 13:28:17', '2024-05-04 13:28:17'),
(6, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', '5j6o0wd13BvYtJU_1714852132.sql', 'application/x-sql', 'sql', '269462', 'anonymous/5j6o0wd13BvYtJU_1714852132.sql', '2024-05-04 13:48:52', '2024-05-04 13:48:52'),
(7, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', 'hyuqXygO2Iolohk_1714852433.sql', 'application/x-sql', 'sql', '269462', 'anonymous/hyuqXygO2Iolohk_1714852433.sql', '2024-05-04 13:53:53', '2024-05-04 13:53:53'),
(8, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', 'fxkCpcNsumsEOi1_1714852475.sql', 'application/x-sql', 'sql', '269462', 'anonymous/fxkCpcNsumsEOi1_1714852475.sql', '2024-05-04 13:54:35', '2024-05-04 13:54:35'),
(9, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', 'WRhZfi9ulCgT9Ii_1714852536.sql', 'application/x-sql', 'sql', '269462', 'anonymous/WRhZfi9ulCgT9Ii_1714852536.sql', '2024-05-04 13:55:36', '2024-05-04 13:55:36'),
(13, '152.58.131.227', NULL, 1, 'miracuvex_mytransfer (1).sql', '6vuu7wo4Cz6d18r_1714852934.sql', 'application/x-sql', 'sql', '269462', 'anonymous/6vuu7wo4Cz6d18r_1714852934.sql', '2024-05-04 14:02:14', '2024-05-04 14:02:14'),
(15, '152.58.131.227', NULL, 1, 'wasabi.png', 'hM8uRetiZ1VJoC0_1714853935.png', 'image/png', 'png', '29199', 'anonymous/hM8uRetiZ1VJoC0_1714853935.png', '2024-05-04 14:18:55', '2024-05-04 14:18:55'),
(18, '152.58.130.56', NULL, 1, 'Y2meta.app - Happy Birthday Wish My Girlfriend _And Birthday Status _Birthday Special Video (128 kbps).mp3', 'SUFwF7QCmKJNQtR_1714858288.mp3', 'audio/mpeg', 'mp3', '249263', 'anonymous/SUFwF7QCmKJNQtR_1714858288.mp3', '2024-05-04 15:31:28', '2024-05-04 15:31:28'),
(19, '152.58.131.66', NULL, 1, 'digitalocean.png', 'QYs6rhdUFV6wilU_1714858886.png', 'image/png', 'png', '12048', 'anonymous/QYs6rhdUFV6wilU_1714858886.png', '2024-05-04 15:41:26', '2024-05-04 15:41:26'),
(20, '152.58.130.56', NULL, 1, 'Y2meta.app - Happy Birthday Wish My Girlfriend _And Birthday Status _Birthday Special Video (128 kbps).mp3', 'Fd1lDgZcoAswBuO_1714858894.mp3', 'audio/mpeg', 'mp3', '249263', 'anonymous/Fd1lDgZcoAswBuO_1714858894.mp3', '2024-05-04 15:41:34', '2024-05-04 15:41:34'),
(21, '152.58.130.56', NULL, 1, 'Y2meta.app - Happy Birthday Wish My Girlfriend _And Birthday Status _Birthday Special Video (128 kbps).mp3', 'HHqr9J5rl0IR6YO_1714859028.mp3', 'audio/mpeg', 'mp3', '249263', 'anonymous/HHqr9J5rl0IR6YO_1714859028.mp3', '2024-05-04 15:43:48', '2024-05-04 15:43:48'),
(22, '103.249.38.54', NULL, 1, 'SAL-QTN-2024-00018.pdf', 's9aS7HFLU2QPC5r_1714890853.pdf', 'application/pdf', 'pdf', '46796', 'anonymous/s9aS7HFLU2QPC5r_1714890853.pdf', '2024-05-05 00:34:13', '2024-05-05 00:34:13'),
(26, '171.79.32.70', NULL, 1, 'about array.pdf', 'mrizgeRReHZJlHd_1714970786.pdf', 'application/pdf', 'pdf', '92326', 'anonymous/mrizgeRReHZJlHd_1714970786.pdf', '2024-05-05 22:46:26', '2024-05-05 22:46:26'),
(27, '213.74.247.150', NULL, 1, 'image2.png', 'h638PHVzKp0Li3l_1715330466.png', 'image/png', 'png', '73199', 'anonymous/h638PHVzKp0Li3l_1715330466.png', '2024-05-10 02:41:06', '2024-05-10 02:41:06'),
(28, '86.29.202.218', NULL, 1, 'Хаски-Седьмое октября (Instrumental).mp3', 'DhjuhTSvEpHEs0m_1715507667.mp3', 'audio/mpeg', 'mp3', '6580855', 'anonymous/DhjuhTSvEpHEs0m_1715507667.mp3', '2024-05-12 03:54:27', '2024-05-12 03:54:27'),
(30, '178.197.207.168', NULL, 1, 'projectsend-r1605.zip', 'XqlNQaxhOBP9zV0_1715806468.zip', 'application/zip', 'zip', '29037176', 'anonymous/XqlNQaxhOBP9zV0_1715806468.zip', '2024-05-15 14:54:28', '2024-05-15 14:54:28'),
(32, '76.86.243.68', NULL, 1, 'Style 962-60 - 768 b.jpg', 'RJjYwugA8FbjNof_1718836833.jpg', 'image/jpeg', 'jpg', '6494150', 'anonymous/RJjYwugA8FbjNof_1718836833.jpg', '2024-06-19 16:40:33', '2024-06-19 16:40:33'),
(33, '124.40.246.153', NULL, 1, 'GD.jpg', 'VCqUZbiqa9xnlwX_1725959103.jpg', 'image/jpeg', 'jpg', '6145148', 'anonymous/VCqUZbiqa9xnlwX_1725959103.jpg', '2024-09-10 03:05:03', '2024-09-10 03:05:03'),
(37, '49.15.224.225', 1, 1, '8.jpg', 'JspbakUcyyLwYfy_1728013711.jpg', 'image/jpeg', 'jpg', '104616', 'users/V53YMO/JspbakUcyyLwYfy_1728013711.jpg', '2024-10-03 21:48:31', '2024-10-03 21:48:31'),
(56, '103.201.151.122', NULL, 1, 'cv.txt', 'F8CPptBxvtbxVzu_1728029077.txt', 'text/plain', 'txt', '18', 'anonymous/F8CPptBxvtbxVzu_1728029077.txt', '2024-10-04 02:04:37', '2024-10-04 02:04:37');

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

--
-- 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) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `country_code` varchar(100) DEFAULT NULL,
  `timezone` varchar(150) DEFAULT NULL,
  `location` varchar(60) DEFAULT NULL,
  `latitude` varchar(60) DEFAULT NULL,
  `longitude` varchar(60) DEFAULT NULL,
  `browser` varchar(60) DEFAULT NULL,
  `os` varchar(60) 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 `user_logs`
--

INSERT INTO `user_logs` (`id`, `user_id`, `ip`, `country`, `country_code`, `timezone`, `location`, `latitude`, `longitude`, `browser`, `os`, `created_at`, `updated_at`) VALUES
(1, 1, '152.58.131.42', 'India', 'IN', 'Asia/Kolkata', 'Lucknow, IN', '26.8756', '80.9115', 'Chrome', 'Windows 10', '2024-05-04 09:50:08', '2024-05-04 09:50:08'),
(2, 1, '202.8.119.203', 'India', 'IN', 'Asia/Kolkata', 'Kolkata, IN', '22.518', '88.3832', 'Safari', 'Mac OS X', '2024-05-05 05:07:50', '2024-05-05 05:07:50'),
(3, 1, '152.58.152.102', 'India', 'IN', 'Asia/Kolkata', 'Lucknow, IN', '26.8756', '80.9115', 'Chrome', 'Windows 10', '2024-05-05 05:08:39', '2024-05-05 05:08:39'),
(4, 2, '171.79.32.70', 'India', 'IN', 'Asia/Kolkata', 'Indore, IN', '22.717', '75.8337', 'Chrome', 'Windows 10', '2024-05-05 22:51:47', '2024-05-05 22:51:47'),
(5, 3, '171.79.32.70', 'India', 'IN', 'Asia/Kolkata', 'Indore, IN', '22.717', '75.8337', 'Chrome', 'Windows 10', '2024-05-05 23:13:18', '2024-05-05 23:13:18'),
(6, 1, '37.6.177.65', 'Greece', 'GR', 'Europe/Athens', 'Sparti, GR', '37.0799', '22.4282', 'Chrome', 'Mac OS X', '2024-05-06 11:47:40', '2024-05-06 11:47:40'),
(7, 1, '94.195.59.160', 'United Kingdom', 'GB', 'Europe/London', 'Sunderland, GB', '54.92', '-1.429', 'Chrome', 'Mac OS X', '2024-05-06 11:49:44', '2024-05-06 11:49:44'),
(8, 4, '96.22.171.110', 'Canada', 'CA', 'America/Toronto', 'Montreal, CA', '45.5075', '-73.5887', 'Chrome', 'Mac OS X', '2024-06-08 13:15:53', '2024-06-08 13:15:53'),
(9, 1, '106.219.121.126', 'India', 'IN', 'Asia/Kolkata', 'Faridabad, IN', '28.4098', '77.31', 'Unknown', 'Unknown', '2024-06-28 01:12:32', '2024-06-28 01:12:32'),
(10, 1, '122.161.52.201', 'India', 'IN', 'Asia/Kolkata', 'Noida, IN', '28.6145', '77.3063', 'Chrome', 'Windows 10', '2024-06-28 03:45:50', '2024-06-28 03:45:50'),
(11, 1, '27.56.255.19', 'India', 'IN', 'Asia/Kolkata', 'Indore, IN', '22.7196', '75.8577', 'Chrome', 'Windows 10', '2024-06-28 05:20:16', '2024-06-28 05:20:16'),
(12, 1, '110.226.183.132', 'India', 'IN', 'Asia/Kolkata', 'Mumbai, IN', '19.0748', '72.8856', 'Chrome', 'Windows 10', '2024-09-01 23:12:31', '2024-09-01 23:12:31'),
(13, 1, '110.226.183.251', 'India', 'IN', 'Asia/Kolkata', 'Mumbai, IN', '19.0748', '72.8856', 'Chrome', 'Windows 10', '2024-10-03 05:58:38', '2024-10-03 05:58:38'),
(14, 1, '49.15.224.225', 'India', 'IN', 'Asia/Kolkata', 'Delhi, IN', '28.6542', '77.2373', 'Chrome', 'Windows 10', '2024-10-03 21:48:01', '2024-10-03 21:48:01'),
(15, 1, '103.201.151.122', 'India', 'IN', 'Asia/Kolkata', 'Thāne, IN', '19.1963', '72.9675', 'Chrome', 'Windows 10', '2024-10-04 02:04:49', '2024-10-04 02:04:49');

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

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

CREATE TABLE `user_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) 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 `user_notifications`
--

INSERT INTO `user_notifications` (`id`, `user_id`, `title`, `link`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Thanks for joining us User!', NULL, 'https://mytransfer.miracuvex.com/images/icons/welcome.png', 1, '2024-05-04 09:50:08', '2024-10-03 21:54:57'),
(2, 2, 'Thanks for joining us john!', NULL, 'https://mxtransfer.mimeld.com/images/icons/welcome.png', 0, '2024-05-05 22:51:47', '2024-05-05 22:51:47'),
(3, 3, 'Thanks for joining us liza!', NULL, 'https://mxtransfer.mimeld.com/images/icons/welcome.png', 0, '2024-05-05 23:13:18', '2024-05-05 23:13:18'),
(4, 4, 'Thanks for joining us Félix!', NULL, 'https://mxtransfer.mimeld.com/images/icons/welcome.png', 0, '2024-06-08 13:15:53', '2024-06-08 13:15:53');

--
-- Indexes for dumped tables
--

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

--
-- 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 `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 `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`),
  ADD KEY `coupons_plan_id_foreign` (`plan_id`);

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

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

--
-- 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 KEY `navbar_menu_lang_foreign` (`lang`);

--
-- 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 `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

--
-- Indexes for table `support_replies`
--
ALTER TABLE `support_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_replies_support_ticket_id_foreign` (`support_ticket_id`),
  ADD KEY `support_replies_admin_id_foreign` (`admin_id`);

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

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `taxes_country_id_unique` (`country_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_checkout_id_unique` (`checkout_id`),
  ADD UNIQUE KEY `transactions_transaction_id_unique` (`transaction_id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`),
  ADD KEY `transactions_plan_id_foreign` (`plan_id`),
  ADD KEY `transactions_coupon_id_foreign` (`coupon_id`),
  ADD KEY `transactions_payment_gateway_id_foreign` (`payment_gateway_id`);

--
-- Indexes for table `transfer_files`
--
ALTER TABLE `transfer_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transfer_files_user_id_foreign` (`user_id`),
  ADD KEY `transfer_files_transfer_id_foreign` (`transfer_id`),
  ADD KEY `transfer_files_storage_provider_id_foreign` (`storage_provider_id`);

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

--
-- Indexes for table `uploads`
--
ALTER TABLE `uploads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uploads_user_id_foreign` (`user_id`),
  ADD KEY `uploads_storage_provider_id_foreign` (`storage_provider_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 `user_notifications`
--
ALTER TABLE `user_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_notifications_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- 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 `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

--
-- AUTO_INCREMENT for table `footer_menu`
--
ALTER TABLE `footer_menu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT for table `navbar_menu`
--
ALTER TABLE `navbar_menu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  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 for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- 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 `coupons`
--
ALTER TABLE `coupons`
  ADD CONSTRAINT `coupons_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`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 `footer_menu`
--
ALTER TABLE `footer_menu`
  ADD CONSTRAINT `footer_menu_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) 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;

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `pages_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) 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 `social_providers`
--
ALTER TABLE `social_providers`
  ADD CONSTRAINT `social_providers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `support_attachments`
--
ALTER TABLE `support_attachments`
  ADD CONSTRAINT `support_attachments_support_reply_id_foreign` FOREIGN KEY (`support_reply_id`) REFERENCES `support_replies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_replies`
--
ALTER TABLE `support_replies`
  ADD CONSTRAINT `support_replies_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `support_replies_support_ticket_id_foreign` FOREIGN KEY (`support_ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `taxes`
--
ALTER TABLE `taxes`
  ADD CONSTRAINT `taxes_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_payment_gateway_id_foreign` FOREIGN KEY (`payment_gateway_id`) REFERENCES `payment_gateways` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transfer_files`
--
ALTER TABLE `transfer_files`
  ADD CONSTRAINT `transfer_files_storage_provider_id_foreign` FOREIGN KEY (`storage_provider_id`) REFERENCES `storage_providers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfer_files_transfer_id_foreign` FOREIGN KEY (`transfer_id`) REFERENCES `transfers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfer_files_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `translates`
--
ALTER TABLE `translates`
  ADD CONSTRAINT `translates_lang_foreign` FOREIGN KEY (`lang`) REFERENCES `languages` (`code`) ON DELETE CASCADE;

--
-- Constraints for table `uploads`
--
ALTER TABLE `uploads`
  ADD CONSTRAINT `uploads_storage_provider_id_foreign` FOREIGN KEY (`storage_provider_id`) REFERENCES `storage_providers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `uploads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- 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 `user_notifications`
--
ALTER TABLE `user_notifications`
  ADD CONSTRAINT `user_notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

