-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 12, 2026 at 09:09 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29

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: `tms2.0`
--

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `continent` varchar(255) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `continent`, `name`, `status`) VALUES
(1, 'Africa', 'Algeria', 1),
(2, 'Africa', 'American Samoa', 1),
(3, 'Africa', 'Angola', 1),
(4, 'Africa', 'Benin', 1),
(5, 'Africa', 'Botswana', 1),
(6, 'Africa', 'Burkina Faso', 1),
(7, 'Africa', 'Burundi', 1),
(8, 'Africa', 'Cameroon', 1),
(9, 'Africa', 'Cape Verde', 1),
(10, 'Africa', 'Central African Republic', 1),
(11, 'Africa', 'Chad', 1),
(12, 'Africa', 'Comoros', 1),
(13, 'Africa', 'Congo (Brazzaville)', 1),
(14, 'Africa', 'Congo (Kinshasa)', 1),
(15, 'Africa', 'Djibouti', 1),
(16, 'Africa', 'Egypt', 1),
(17, 'Africa', 'Equatorial Guinea', 1),
(18, 'Africa', 'Eritrea', 1),
(19, 'Africa', 'Ethiopia', 1),
(20, 'Africa', 'French Southern Territories', 1),
(21, 'Africa', 'Gabon', 1),
(22, 'Africa', 'Gambia', 1),
(23, 'Africa', 'Ghana', 1),
(24, 'Africa', 'Guinea', 1),
(25, 'Africa', 'Guinea-Bissau', 1),
(26, 'Africa', 'Kenya', 1),
(27, 'Africa', 'Lesotho', 1),
(28, 'Africa', 'Liberia', 1),
(29, 'Africa', 'Libya', 1),
(30, 'Africa', 'Madagascar', 1),
(31, 'Africa', 'Malawi', 1),
(32, 'Africa', 'Mali', 1),
(33, 'Africa', 'Mauritania', 1),
(34, 'Africa', 'Mayotte', 1),
(35, 'Africa', 'Morocco', 1),
(36, 'Africa', 'Mozambique', 1),
(37, 'Africa', 'Namibia', 1),
(38, 'Africa', 'Niger', 1),
(39, 'Africa', 'Nigeria', 1),
(40, 'Africa', 'Palestinian Territory', 1),
(41, 'Africa', 'Reunion', 1),
(42, 'Africa', 'Rwanda', 1),
(43, 'Africa', 'Saint Helena', 1),
(44, 'Africa', 'Sao Tome and Principe', 1),
(45, 'Africa', 'Senegal', 1),
(46, 'Africa', 'Seychelles', 1),
(47, 'Africa', 'Sierra Leone', 1),
(48, 'Africa', 'Somalia', 1),
(49, 'Africa', 'South Africa', 1),
(50, 'Africa', 'Sudan', 1),
(51, 'Africa', 'Swaziland', 1),
(52, 'Africa', 'Tanzania', 1),
(53, 'Africa', 'Tunisia', 1),
(54, 'Africa', 'Uganda', 1),
(55, 'Africa', 'Western Sahara', 1),
(56, 'Africa', 'Zambia', 1),
(57, 'Africa', 'Zimbabwe', 1),
(58, 'Asia', 'Afghanistan', 1),
(59, 'Australia', 'Australia', 1),
(60, 'Asia', 'Bangladesh', 1),
(61, 'Asia', 'Bhutan', 1),
(62, 'Asia', 'British Indian Ocean Territory', 1),
(63, 'Asia', 'Brunei', 1),
(64, 'Asia', 'Cambodia', 1),
(65, 'Asia', 'China', 1),
(66, 'Asia', 'Christmas Island', 1),
(67, 'Asia', 'Cocos (Keeling) Islands', 1),
(68, 'Asia', 'Cook Islands', 1),
(69, 'Asia', 'East Timor', 1),
(70, 'Asia', 'Fiji', 1),
(71, 'Asia', 'French Polynesia', 1),
(72, 'Asia', 'Guam', 1),
(73, 'Asia', 'Heard Island and McDonald Islands', 1),
(74, 'Asia', 'Hong Kong ', 1),
(75, 'Asia', 'India', 1),
(76, 'Asia', 'Indonesia', 1),
(77, 'Asia', 'Japan', 1),
(78, 'Asia', 'Kazakhstan', 1),
(79, 'Asia', 'Kiribati', 1),
(80, 'Asia', 'Kyrgyzstan', 1),
(81, 'Asia', 'Laos', 1),
(82, 'Asia', 'Macao S.A.R., China', 1),
(83, 'Asia', 'Malaysia', 1),
(84, 'Asia', 'Maldives', 1),
(85, 'Asia', 'Marshall Islands', 1),
(86, 'Asia', 'Mauritius', 1),
(87, 'Asia', 'Micronesia', 1),
(88, 'Asia', 'Mongolia', 1),
(89, 'Asia', 'Myanmar', 1),
(90, 'Asia', 'Nauru', 1),
(91, 'Asia', 'Nepal', 1),
(92, 'Asia', 'New Caledonia', 1),
(93, 'Asia', 'New Zealand', 1),
(94, 'Asia', 'Niue', 1),
(95, 'Asia', 'Norfolk Island', 1),
(96, 'Asia', 'North Korea', 1),
(97, 'Asia', 'Northern Mariana Islands', 1),
(98, 'Asia', 'Pakistan', 1),
(99, 'Asia', 'Palau', 1),
(100, 'Asia', 'Papua New Guinea', 1),
(101, 'Asia', 'Philippines', 1),
(102, 'Asia', 'Pitcairn', 1),
(103, 'Asia', 'Russia', 1),
(104, 'Asia', 'Samoa', 1),
(105, 'Asia', 'Singapore', 1),
(106, 'Asia', 'Solomon Islands', 1),
(107, 'Asia', 'South Korea', 1),
(108, 'Asia', 'Sri Lanka', 1),
(109, 'Asia', 'Taiwan', 1),
(110, 'Asia', 'Tajikistan', 1),
(111, 'Asia', 'Thailand', 1),
(112, 'Asia', 'Togo', 1),
(113, 'Asia', 'Tokelau', 1),
(114, 'Asia', 'Tonga', 1),
(115, 'Asia', 'Tuvalu', 1),
(116, 'Asia', 'Uzbekistan', 1),
(117, 'Asia', 'Vanuatu', 1),
(118, 'Asia', 'Wallis and Futuna', 1),
(119, 'Europe', 'Albania', 1),
(120, 'Europe', 'Andorra', 1),
(121, 'Europe', 'Armenia', 1),
(122, 'Europe', 'Austria', 1),
(123, 'Europe', 'Azerbaijan', 1),
(124, 'Europe', 'Belarus', 1),
(125, 'Europe', 'Belgium', 1),
(126, 'Europe', 'Bosnia and Herzegovina', 1),
(127, 'Europe', 'Bouvet Island', 1),
(128, 'Europe', 'Bulgaria', 1),
(129, 'Europe', 'Croatia', 1),
(130, 'Europe', 'Cyprus', 1),
(131, 'Europe', 'Czech Republic', 1),
(132, 'Europe', 'Denmark', 1),
(133, 'Europe', 'Estonia', 1),
(134, 'Europe', 'Faroe Islands', 1),
(135, 'Europe', 'Finland', 1),
(136, 'Europe', 'France', 1),
(137, 'Europe', 'Georgia', 1),
(138, 'Europe', 'Germany', 1),
(139, 'Europe', 'Gibraltar', 1),
(140, 'Europe', 'Greece', 1),
(141, 'Europe', 'Guernsey', 1),
(142, 'Europe', 'Hungary', 1),
(143, 'Europe', 'Ireland', 1),
(144, 'Europe', 'Italy', 1),
(145, 'Europe', 'Latvia', 1),
(146, 'Europe', 'Liechtenstein', 1),
(147, 'Europe', 'Lithuania', 1),
(148, 'Europe', 'Luxembourg', 1),
(149, 'Europe', 'Macedonia', 1),
(150, 'Europe', 'Malta', 1),
(151, 'Europe', 'Moldova', 1),
(152, 'Europe', 'Monaco', 1),
(153, 'Europe', 'Netherlands', 1),
(154, 'Europe', 'Norway', 1),
(155, 'Europe', 'Poland', 1),
(156, 'Europe', 'Portugal', 1),
(157, 'Europe', 'Romania', 1),
(159, 'Europe', 'San Marino', 1),
(160, 'Europe', 'Serbia', 1),
(161, 'Europe', 'Serbia And Montenegro', 1),
(162, 'Europe', 'Slovakia', 1),
(163, 'Europe', 'Slovenia', 1),
(164, 'Europe', 'South Georgia and the South Sandwich Islands', 1),
(165, 'Europe', 'Spain', 1),
(166, 'Europe', 'Svalbard and Jan Mayen', 1),
(167, 'Europe', 'Sweden', 1),
(168, 'Europe', 'Switzerland', 1),
(169, 'Europe', 'Turkeyddd', 1),
(170, 'Europe', 'Ukraine', 1),
(171, 'Europe', 'United Kingdom', 1),
(172, 'Europe', 'Vatican', 1),
(173, 'South America', 'Anguilla', 1),
(174, 'South America', 'Antarctica', 1),
(175, 'South America', 'Antigua and Barbuda', 1),
(176, 'South America', 'Argentina', 1),
(177, 'South America', 'Aruba', 1),
(178, 'South America', 'Bahamas', 1),
(179, 'South America', 'Barbados', 1),
(180, 'South America', 'Belize', 1),
(181, 'South America', 'Bermuda', 1),
(182, 'South America', 'Bolivia', 1),
(183, 'South America', 'Brazil', 1),
(184, 'South America', 'Cayman Islands', 1),
(185, 'South America', 'Chile', 1),
(186, 'South America', 'Colombia', 1),
(187, 'South America', 'Costa Rica', 1),
(188, 'South America', 'Cuba', 1),
(189, 'North America', 'Dominican Republic', 1),
(190, 'South America', 'Ecuador', 1),
(191, 'South America', 'El Salvador', 1),
(192, 'South America', 'Falkland Islands', 1),
(193, 'South America', 'French Guiana', 1),
(194, 'South America', 'Grenada', 1),
(195, 'South America', 'Guadeloupe', 1),
(196, 'South America', 'Guatemala', 1),
(197, 'South America', 'Guyana', 1),
(198, 'South America', 'Haiti', 1),
(199, 'South America', 'Honduras', 1),
(200, 'South America', 'Jamaica', 1),
(201, 'South America', 'Jersey', 1),
(202, 'South America', 'Martinique', 1),
(203, 'South America', 'Mexico-SA', 1),
(204, 'South America', 'Montserrat', 1),
(205, 'South America', 'Netherlands Antilles', 1),
(206, 'South America', 'Nicaragua', 1),
(207, 'South America', 'Nicaragua', 1),
(208, 'South America', 'Panama', 1),
(209, 'South America', 'Paraguay', 1),
(210, 'South America', 'Peru', 1),
(211, 'South America', 'Puerto Rico', 1),
(212, 'South America', 'Saint Kitts and Nevis', 1),
(213, 'South America', 'Saint Lucia', 1),
(214, 'South America', 'Saint Vincent and the Grenadines', 1),
(215, 'South America', 'Suriname', 1),
(216, 'South America', 'Trinidad and Tobago', 1),
(217, 'South America', 'Turks and Caicos Islands', 1),
(218, 'South America', 'U.S. Virgin Islands', 1),
(219, 'South America', 'Uruguay', 1),
(220, 'South America', 'Venezuela', 1),
(222, 'North America', 'Bermuda', 1),
(223, 'North America', 'Canada', 1),
(224, 'North America', 'Dominican ', 1),
(226, 'North America', 'Greenland', 1),
(227, 'North America', 'Mexico', 1),
(228, 'North America', 'Saint Pierre and Miquelon', 1),
(229, 'North America', 'United States', 1),
(230, 'Middle East', 'Bahrain', 1),
(231, 'Middle East', 'Iran', 1),
(232, 'Middle East', 'Iraq', 1),
(233, 'Middle East', 'Israel', 1),
(234, 'Middle East', 'Jordan', 1),
(235, 'Middle East', 'Kuwait', 1),
(237, 'Middle East', 'Lebanon', 1),
(238, 'Middle East', 'Oman', 1),
(239, 'Middle East', 'Qatar', 1),
(240, 'Middle East', 'Saudi Arabia', 1),
(241, 'Middle East', 'Syria', 1),
(242, 'Middle East', 'Turkey', 1),
(243, 'Asia', 'Turkmenistan', 1),
(244, 'Middle East', 'United Arab Emirates', 1),
(245, 'Middle East', 'Yemen', 1),
(246, 'Asia', 'test country', 1),
(247, 'Asia', 'Vietnam', 1),
(249, 'Europe', 'Kosovo', 1),
(250, 'Europe', 'Albania', 1),
(251, 'Europe', 'Aland Islands', 1),
(252, 'North America', 'Caribbean Netherlands', 1),
(253, 'North America', 'British Virgin Islands', 1),
(254, 'South America', 'Curacao', 1),
(255, 'Africa', 'Democratic Republic of the Congo  ', 1),
(256, 'Europe', 'Iceland', 1),
(257, 'Europe', 'Isle of Man', 1),
(258, 'Africa', 'Ivory Coast', 1),
(259, 'North America', 'Saint Barthelemy', 1),
(260, 'North America', 'Saint Martin', 1),
(261, 'North America', 'Sint Maarten', 1),
(262, 'Africa', 'South Sudan', 1),
(263, 'None', 'None', 1),
(265, 'Europe', 'NA', 1),
(266, 'North America', 'N/A', 1);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=532;
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 */;
