-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 13, 2026 at 11:36 AM
-- Server version: 10.11.18-MariaDB-log
-- PHP Version: 8.4.21

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


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

--
-- Database: `qhtesting_internation_scholars_test`
--

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

--
-- Table structure for table `dns_countries`
--

CREATE TABLE `dns_countries` (
  `id` smallint(5) UNSIGNED NOT NULL COMMENT 'Surrogate PK.',
  `name` varchar(100) NOT NULL COMMENT 'County name (human-readable).',
  `country_code` char(2) DEFAULT NULL COMMENT 'ISO 3166-1 alpha-2 of the country this county belongs to (e.g., KE).',
  `embassy_link` varchar(1000) DEFAULT NULL COMMENT 'This is the embassy link in which one can schedue a visa appointment date',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Soft on/off switch for UI filtering.',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Row creation timestamp.',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Row last-update timestamp.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Lookup of counties (names + short codes) with optional ISO country code.';

--
-- Dumping data for table `dns_countries`
--

INSERT INTO `dns_countries` (`id`, `name`, `country_code`, `embassy_link`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Afghanistan', 'AF', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(2, 'Albania', 'AL', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(3, 'Algeria', 'DZ', 'https://www.ustraveldocs.com/dz/en/step-4', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(4, 'Andorra', 'AD', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(5, 'Angola', 'AO', 'https://ais.usvisa-info.com/en-ao/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(6, 'Antigua and Barbuda', 'AG', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(7, 'Argentina', 'AR', 'https://ais.usvisa-info.com/en-ar/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(8, 'Armenia', 'AM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(9, 'Australia', 'AU', 'https://www.ustraveldocs.com/au/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(10, 'Austria', 'AT', 'https://ais.usvisa-info.com/en-at/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(11, 'Azerbaijan', 'AZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(12, 'Bahamas', 'BS', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(13, 'Bahrain', 'BH', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(14, 'Bangladesh', 'BD', 'https://www.ustraveldocs.com/bd/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(15, 'Barbados', 'BB', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(16, 'Belarus', 'BY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(17, 'Belgium', 'BE', 'https://ais.usvisa-info.com/en-be/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(18, 'Belize', 'BZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(19, 'Benin', 'BJ', 'https://evisaforms.state.gov/default.asp?postcode=COT&appcode=3', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(20, 'Bhutan', 'BT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(21, 'Bolivia', 'BO', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(22, 'Bosnia and Herzegovina', 'BA', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(23, 'Botswana', 'BW', 'https://evisaforms.state.gov/default.asp?CSRFToken=AA7A7BCDAD9E43369A80459C4B52D28C&PostCode=GAB&CountryCode=BOT+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(24, 'Brazil', 'BR', 'https://ais.usvisa-info.com/en-br/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(25, 'Brunei Darussalam', 'BN', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(26, 'Bulgaria', 'BG', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(27, 'Burkina Faso', 'BF', 'https://www.usvisaappt.com/visa/page?country=BF&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(28, 'Burundi', 'BI', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=BUJ&CountryCode=BRND++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(29, 'Cabo Verde', 'CV', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(30, 'Cambodia', 'KH', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(31, 'Cameroon', 'CM', 'https://www.usvisaappt.com/visa/page?country=CM&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(32, 'Canada', 'CA', 'https://ais.usvisa-info.com/en-ca/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(33, 'Central African Republic', 'CF', 'https://cf.usembassy.gov/visas/', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(34, 'Chad', 'TD', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=NDJ&CountryCode=CHAD++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(35, 'Chile', 'CL', 'https://ais.usvisa-info.com/en-cl/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(36, 'China', 'CN', 'https://www.ustraveldocs.com/cn/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(37, 'Colombia', 'CO', 'https://ais.usvisa-info.com/en-co/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(38, 'Comoros', 'KM', 'Link', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(39, 'Congo', 'CG', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(40, 'Congo, Democratic Republic of the', 'CD', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(41, 'Costa Rica', 'CR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(42, 'Croatia', 'HR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(43, 'Cuba', 'CU', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(44, 'Cyprus', 'CY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(45, 'Czechia', 'CZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(46, 'Denmark', 'DK', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(47, 'Djibouti', 'DJ', 'https://ais.usvisa-info.com/en-dj/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(48, 'Dominica', 'DM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(49, 'Dominican Republic', 'DO', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(50, 'Ecuador', 'EC', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(51, 'Egypt', 'EG', 'https://www.ustraveldocs.com/eg/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(52, 'El Salvador', 'SV', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(53, 'Equatorial Guinea', 'GQ', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=MBO&CountryCode=EGN+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(54, 'Eritrea', 'ER', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=ASM&CountryCode=ERI+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(55, 'Estonia', 'EE', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(56, 'Eswatini', 'SZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(57, 'Ethiopia', 'ET', 'https://ais.usvisa-info.com/en-et/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(58, 'Fiji', 'FJ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(59, 'Finland', 'FI', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(60, 'France', 'FR', 'https://ais.usvisa-info.com/en-fr/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(61, 'Gabon', 'GA', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=LIB&CountryCode=GABN++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(62, 'Gambia', 'GM', 'https://www.usvisaappt.com/visa/page?country=GM&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(63, 'Georgia', 'GE', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(64, 'Germany', 'DE', 'https://ais.usvisa-info.com/en-de/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(65, 'Ghana', 'GH', 'https://www.usvisaappt.com/visa/page?country=GH&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(66, 'Greece', 'GR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(67, 'Grenada', 'GD', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(68, 'Guatemala', 'GT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(69, 'Guinea', 'GN', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=CRY&CountryCode=GNEA&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(70, 'Guinea-Bissau', 'GW', 'https://gw.usmission.gov/visas/#:~:text=The%20U.S.%20does%20not%20have%20an%20embassy%20in%20Guinea%2DBissau.%20All%20U.S.%20consular%20services%2C%20including%20visa%20processing%2C%20are%20handled%20by%20the%20U.S.%20Embassy%20in%20Dakar%2C%20Senegal.', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(71, 'Guyana', 'GY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(72, 'Haiti', 'HT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(73, 'Honduras', 'HN', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(74, 'Hungary', 'HU', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(75, 'Iceland', 'IS', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(76, 'India', 'IN', 'https://www.ustraveldocs.com/in/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(77, 'Indonesia', 'ID', 'https://www.ustraveldocs.com/id/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(78, 'Iran', 'IR', 'https://travel.state.gov/content/travel/en/us-visas/visa-information-resources/list-of-posts.html', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(79, 'Iraq', 'IQ', 'https://ais.usvisa-info.com/en-iq/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(80, 'Ireland', 'IE', 'https://ais.usvisa-info.com/en-ie/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(81, 'Israel', 'IL', 'https://ais.usvisa-info.com/en-il/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(82, 'Italy', 'IT', 'https://ais.usvisa-info.com/en-it/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(83, 'Jamaica', 'JM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(84, 'Japan', 'JP', 'https://www.ustraveldocs.com/jp/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(85, 'Jordan', 'JO', 'https://ais.usvisa-info.com/en-jo/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(86, 'Kazakhstan', 'KZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(87, 'Kenya', 'KE', 'https://ais.usvisa-info.com/en-ke/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(88, 'Kiribati', 'KI', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(89, 'Kuwait', 'KW', 'https://ais.usvisa-info.com/en-kw/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(90, 'Kyrgyzstan', 'KG', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(91, 'Lao People\'s Democratic Republic', 'LA', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(92, 'Latvia', 'LV', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(93, 'Lebanon', 'LB', 'https://ais.usvisa-info.com/en-lb/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(94, 'Lesotho', 'LS', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=MAS&CountryCode=LES+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(95, 'Liberia', 'LR', 'https://www.usvisaappt.com/visa/page?country=LR&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(96, 'Libya', 'LY', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=TRP&CountryCode=LBYA++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(97, 'Liechtenstein', 'LI', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(98, 'Lithuania', 'LT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(99, 'Luxembourg', 'LU', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(100, 'Madagascar', 'MG', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=ANT&CountryCode=MADG++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(101, 'Malawi', 'MW', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=LIL&CountryCode=MALW++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(102, 'Malaysia', 'MY', 'https://www.ustraveldocs.com/my/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(103, 'Maldives', 'MV', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(104, 'Mali', 'ML', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=BAM&CountryCode=MALI++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(105, 'Malta', 'MT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(106, 'Marshall Islands', 'MH', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(107, 'Mauritania', 'MR', 'https://ais.usvisa-info.com/en-mr/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(108, 'Mauritius', 'MU', 'https://ais.usvisa-info.com/en-mu/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(109, 'Mexico', 'MX', 'https://ais.usvisa-info.com/en-mx/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(110, 'Micronesia', 'FM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(111, 'Moldova', 'MD', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(112, 'Monaco', 'MC', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(113, 'Mongolia', 'MN', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(114, 'Montenegro', 'ME', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(115, 'Morocco', 'MA', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=CSB&CountryCode=MORO++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(116, 'Mozambique', 'MZ', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=MAP&CountryCode=MOZ+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(117, 'Myanmar', 'MM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(118, 'Namibia', 'NA', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=WHK&CountryCode=NAMB++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(119, 'Nauru', 'NR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(120, 'Nepal', 'NP', 'https://www.ustraveldocs.com/np/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(121, 'Netherlands', 'NL', 'https://ais.usvisa-info.com/en-nl/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(122, 'New Zealand', 'NZ', 'https://www.ustraveldocs.com/nz/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(123, 'Nicaragua', 'NI', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(124, 'Niger', 'NE', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=NMY&CountryCode=NIR+++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(125, 'Nigeria', 'NG', 'https://www.usvisaappt.com/visa/page?country=NG&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(126, 'North Korea', 'KP', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(127, 'North Macedonia', 'MK', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(128, 'Norway', 'NO', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(129, 'Oman', 'OM', 'https://ais.usvisa-info.com/en-om/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(130, 'Pakistan', 'PK', 'https://www.ustraveldocs.com/pk/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(131, 'Palau', 'PW', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(132, 'Palestine, State of', 'PS', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(133, 'Panama', 'PA', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(134, 'Papua New Guinea', 'PG', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(135, 'Paraguay', 'PY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(136, 'Peru', 'PE', 'https://ais.usvisa-info.com/en-pe/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(137, 'Philippines', 'PH', 'https://www.ustraveldocs.com/ph/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(138, 'Poland', 'PL', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(139, 'Portugal', 'PT', 'https://ais.usvisa-info.com/en-pt/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(140, 'Qatar', 'QA', 'https://ais.usvisa-info.com/en-qa/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(141, 'Romania', 'RO', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(142, 'Russian Federation', 'RU', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(143, 'Rwanda', 'RW', 'https://www.usvisaappt.com/visa/page?country=RW&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(144, 'Saint Kitts and Nevis', 'KN', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(145, 'Saint Lucia', 'LC', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(146, 'Saint Vincent and the Grenadines', 'VC', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(147, 'Samoa', 'WS', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(148, 'San Marino', 'SM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(149, 'Sao Tome and Principe', 'ST', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(150, 'Saudi Arabia', 'SA', 'https://ais.usvisa-info.com/en-sa/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(151, 'Senegal', 'SN', 'https://www.usvisaappt.com/visa/page?country=SN&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(152, 'Serbia', 'RS', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(153, 'Seychelles', 'SC', 'https://ais.usvisa-info.com/en-mu/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(154, 'Sierra Leone', 'SL', 'https://www.usvisaappt.com/visa/page?country=SL&apiPageName=nonImmigrantVisaProc&locale=en', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(155, 'Singapore', 'SG', 'https://www.ustraveldocs.com/sg/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(156, 'Slovakia', 'SK', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(157, 'Slovenia', 'SI', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(158, 'Solomon Islands', 'SB', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(159, 'Somalia', 'SO', 'Link', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(160, 'South Africa', 'ZA', 'https://ais.usvisa-info.com/en-za/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(161, 'South Korea', 'KR', 'https://www.ustraveldocs.com/kr/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(162, 'South Sudan', 'SS', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=JBA&CountryCode=SSDN&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(163, 'Spain', 'ES', 'https://ais.usvisa-info.com/en-es/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(164, 'Sri Lanka', 'LK', 'https://www.ustraveldocs.com/lk/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(165, 'Sudan', 'SD', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=KHT&CountryCode=SUDA++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(166, 'Suriname', 'SR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(167, 'Sweden', 'SE', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(168, 'Switzerland', 'CH', 'https://ais.usvisa-info.com/en-ch/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(169, 'Syrian Arab Republic', 'SY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(170, 'Taiwan', 'TW', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(171, 'Tajikistan', 'TJ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(172, 'Tanzania', 'TZ', 'https://ais.usvisa-info.com/en-tz/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(173, 'Thailand', 'TH', 'https://www.ustraveldocs.com/th/en/nonimmigrant-visa', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(174, 'Timor-Leste', 'TL', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(175, 'Togo', 'TG', 'https://ais.usvisa-info.com/en-tg/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(176, 'Tonga', 'TO', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(177, 'Trinidad and Tobago', 'TT', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(178, 'Tunisia', 'TN', 'https://evisaforms.state.gov/default.asp?CSRFToken=E9729347969E44D5A91A2E00BDBC01CF&PostCode=TNS&CountryCode=TNSA++++++&CountryCodeShow=&PostCodeShow=&Submit=Submit', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(179, 'Turkey', 'TR', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(180, 'Turkmenistan', 'TM', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(181, 'Tuvalu', 'TV', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(182, 'Uganda', 'UG', 'https://ais.usvisa-info.com/en-ug/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(183, 'Ukraine', 'UA', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(184, 'United Arab Emirates', 'AE', 'https://ais.usvisa-info.com/en-ae/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(185, 'United Kingdom', 'GB', 'https://ais.usvisa-info.com/en-gb/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(186, 'United States of America', 'US', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(187, 'Uruguay', 'UY', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(188, 'Uzbekistan', 'UZ', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(189, 'Vanuatu', 'VU', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(190, 'Venezuela', 'VE', 'https://ve.usembassy.gov/visas/', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(191, 'Viet Nam', 'VN', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(192, 'Yemen', 'YE', NULL, 1, '2025-09-20 07:11:02', '2025-09-20 07:11:02'),
(193, 'Zambia', 'ZM', 'https://ais.usvisa-info.com/en-zm/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05'),
(194, 'Zimbabwe', 'ZW', 'https://ais.usvisa-info.com/en-zw/niv', 1, '2025-09-20 07:11:02', '2026-03-30 09:01:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `dns_countries`
--
ALTER TABLE `dns_countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_code` (`country_code`),
  ADD KEY `idx_dns_countries_country` (`country_code`),
  ADD KEY `idx_dns_countries_name` (`name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dns_countries`
--
ALTER TABLE `dns_countries`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Surrogate PK.', AUTO_INCREMENT=195;
COMMIT;

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