-- MySQL dump 10.13  Distrib 8.0.33, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: emedsol_test
-- ------------------------------------------------------
-- Server version	8.0.35

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country` (
  `country_id` int NOT NULL AUTO_INCREMENT,
  `country_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=258 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country`
--

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

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-07-20  9:37:40
