-- MySQL dump 10.13  Distrib 8.0.42, for Linux (x86_64)
--
-- Host: localhost    Database: magnongrpin_mdes
-- ------------------------------------------------------
-- Server version	8.0.42

/*!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 `careers`
--

DROP TABLE IF EXISTS `careers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `careers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_position` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `types_roles` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `experience` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `linkedln_url` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `portfolio_url` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `my_query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `c_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `careers`
--

LOCK TABLES `careers` WRITE;
/*!40000 ALTER TABLE `careers` DISABLE KEYS */;
INSERT INTO `careers` (`id`, `job_position`, `fname`, `email`, `country_code`, `mobile`, `location`, `types_roles`, `experience`, `linkedln_url`, `portfolio_url`, `my_query`, `c_date`) VALUES (1,'','sa','asd','asd','asd','asd','asd','asd','asd','asd','asd','2024-12-19'),(2,'','Test','test@test.com','+43','1234567891','asdasd','Design','12','http://test.com','http://test.com','sdfsdf','2024-12-19'),(3,'','Test','test@test.com','+41','1234567891','Test','Content Writer','18','http://test.com','http://test.com','Testing','2024-12-19'),(4,'','Test','test@test.com','+40','1234567891','Test','Content Writer','23','http://test.com','http://test.com','Testing','2024-12-19'),(5,'','cbx','bipin.bangwal@magnon-egplus.com','+7','','hfgh','Types of Roles','','','','','2024-12-19'),(6,'','SHADANAND PANDEYA','shadanand.magnon@gmail.com','+91','9876543210','111111111111111111','Client Acquisition','99999999999','http://abc.com','http://abc.com','Hello Testing, I am Lee','2024-12-19'),(7,'','SHADANAND PANDEYA','shadanand.magnon@gmail.com','+91','9876543210','111111111111111111','Client Acquisition','99999999999','http://abc.com','http://abc.com','Hello Testing, I am Lee','2024-12-19'),(8,'','Test','te_st@test.com','+7','','fasf','Types of Roles','','','','','2024-12-19'),(9,'','Test','test@test.com','+7','','asdasd','Types of Roles','','','','','2024-12-19'),(10,'','','','','','','','','','','','2024-12-19'),(11,'','','','','','','','','','','','2024-12-19'),(12,'','','','','','','','','','','','2024-12-19'),(13,'','','','','','','','','','','','2024-12-19'),(14,'','','','','','','','','','','','2024-12-19'),(15,'','Test','test@test.com','+91','','asdas','Types of Roles','','','','<script src=\"https://code.jquery.com/jquery.js\"></script>','2024-12-19'),(16,'','asdasd','test@test.com','+91','1234567891','asdasd','PR & CorpCom','32','http://test.com','http://test.com','asdassadsds','2024-12-19'),(17,'','zdfsdf','test@test.com','+91','','sdfsdfs','Types of Roles','','','','dvsdfsdf cfgdfgdf','2024-12-19'),(18,'','scs','test@test.com','+91','','sdfasd','Finance','','','','adg sdg sdf sdfs','2024-12-19'),(19,'','zscasd','brajesh.kumar@magnon-egplus.com','+91','1234567891','zxd','Copywriter','23432','','','sdf sdf sdfs dfsd','2024-12-19'),(20,'','dfg dfgdfg','test@test.com','+91','1234567891','sgfsdf','Content Writer','343','','','sdfsdf fds fsdf','2024-12-19'),(21,'','Test','test@test.com','+91','','sdfsdf','Types of Roles','','','','zxf sdc asf asdfa','2024-12-19'),(22,'','Test','test@test.com','+91','','sdfsdfsd','Types of Roles','','','','dsfdsfsdfds','2024-12-19'),(23,'','','','','','','','','','','','2024-12-19'),(24,'','','','','','','','','','','','2024-12-19'),(25,'','','','','','','','','','','','2024-12-19'),(26,'','','','','','','','','','','','2024-12-19'),(27,'','Test','test@test.com','+91','','sadsd','Types of Roles','','','','adasdasdasdas','2024-12-19'),(28,'','Tanya','tanya.vashistha01@gmail.com','+91','8130341404','Delhi','Client Acquisition','5','https://magnongroup.in/mdes/Magnon-Designory/Contact.html','','From Careers page','2024-12-20'),(29,'','Ankit','ankit.kumar@magnondesignory.com','+91','8586882010','Noida','Design','10','https://in.linkedin.com/','','Testing pupose','2024-12-20'),(30,'','Tanya vashistha','tanya.vashistha01@gmail.com','+91','8130341404','Delhi','Copywriter','5','','','From Careers page - 2','2024-12-20'),(31,'','Nitish Bhardwaj','mag75164@adobe.com','+91','9205413825','Noida','Copywriter','3','','','sdjhjkdndhv','2024-12-20'),(32,'','Reena Singh','reena.singh@magnondesignory.com','+91','9560509962','Noida','Client Acquisition','18','https://www.linkedin.com/','','career page ','2024-12-20'),(33,'','Ashutosh Tripathi','ashutosh.tripathi@magnondesignory.com','+91','6306551431','Noida','Office Administration','2','https://magnongroup.in/mdes/Magnon-Designory','https://magnongroup.in/mdes/Magnon-Designory','Testing message','2024-12-20'),(34,'','Shivani Shukla','shivani1746@gmail.com','+91','7007081203','Noida','Client Acquisition','4','','','Please hire me','2024-12-20'),(35,'','Shivani Shukla','shivani1746@gmail.com','+91','7007081203','Noida','Client Acquisition','4','','','Please hire me','2024-12-20'),(36,'','Test','test@test.com','+91','1234567891','asdas','Client Acquisition','32','http://test.com','','asdas das dasd as','2024-12-20'),(37,'','Test','test@test.com','+91','1234567891','asd','Client Acquisition','32','http://test.com','','adwfdvfwefwee','2024-12-20'),(38,'','Test','test@test.com','+91','1234567891','sdfdsf','Copywriter','32','http://test.com','','sdcf sdf sdf sd','2024-12-20'),(39,'','Tanya','tanya.vashistha01@gmail.com','+91','9599761172','Delhi','Copywriter','5','https://www.linkedin.com/in/tanya-vashistha-84ab69122/','','I am looking for Copy','2024-12-20'),(40,'','Tanya vashistha','tanya.vashistha01@gmail.com','+91','8130341404','Delhi','Content Writer','5','https://www.linkedin.com/in/tanya-vashistha-84ab69122/','','From Careers page','2024-12-23'),(41,'','Test','test@test.com','+91','1234567891','Noida','Copywriter','12','http://test.com','','','2024-12-23'),(42,'','Test','test@test.com','+91','1234567891','Noida','Design','12','http://test.com','','Testing Testring','2024-12-24'),(43,'','Test','test@test.com','+91','1234567891','Noida','Content Writer','21','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(44,'','Test','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(45,'','Test','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(46,'Job Description','Test','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(47,'Hiring now in Mumbai.  Openings for immediate joiners only.','Test Sub form','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','','2024-12-24'),(48,'Job Description','Test sub forms','test@test.com','+91','1234567891','Noida','Client Acquisition','12','http://test1.com','','asdasda asd asd asdasd','2024-12-24'),(49,'','sdf','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','sdfsdfsdfsdfsdf','2024-12-24'),(50,'','Test','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(51,'Hiring now in Mumbai.  Openings for immediate joiners only.','Test','test@test.com','+91','1234567891','Noida','Content Writer','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(52,'','Test','test@test.com','+91','1234567891','Noida','Office Administration','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(53,'Hiring now in Mumbai.  Openings for immediate joiners only.','Test','test@test.com','+91','1234567891','Noida','Client Acquisition','12','http://test.com','','asdasda asd asd asdasd','2024-12-24'),(54,'Hiring now in Mumbai.  Openings for immediate joiners only.','Test','test@test.com','+91','1234567891','Noida','Finance','12','http://test.com','','Testing1111','2024-12-24'),(55,'Hiring now in Mumbai.  Openings for immediate joiners only.','shivani shukla','shivani1746@gmail.com','+91','0000000000','noida','Client Acquisition','4','https://www.youtube.com/watch?v=B9tKy_UNE1w','','','2024-12-24'),(56,'Job Description','shivani shukla','shivani1746@gmail.com','+91','0000000000','noida','Client Acquisition','4','https://www.youtube.com/watch?v=B9tKy_UNE1w','','','2024-12-24'),(57,'Job Description','shivani shukla','shivani1746@gmail.com','+91','0000000000','noida','Client Acquisition','4','https://www.linkedin.com/in/shivanishukla04/','','','2024-12-26');
/*!40000 ALTER TABLE `careers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_us`
--

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_us` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fname` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `company` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `my_query` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `c_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_us`
--

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
INSERT INTO `contact_us` (`id`, `fname`, `company`, `city`, `country_code`, `mobile`, `email`, `gender`, `my_query`, `c_date`) VALUES (1,'Test','test','test','+355','1234567891','test@test.com','Male','sadsd','2024-12-12'),(2,'Test','test','test','+355','1234567891','test@test.com','Male','zfasdas','2024-12-12'),(3,'Test','test','test','','','test@test.com','Male','adasdas','2024-12-19'),(4,'bl','dfggsd','chdfgdf','','','bipin.bangwal@magnon-egplus.com','Female','chdfgdf','2024-12-19'),(5,'test','test','test','+46','1111111111','bipin.bangwal@magnon-egplus.com','Male','test','2024-12-19'),(6,'SHADANAND PANDEYA','Magnon Solutions Pvt Ltd','NOIDA','+91','9876543210','shadanand.magnon@gmail.com','Male','Hello Testing, Hello','2024-12-19'),(7,'Test','sdas2412','asdas767','+20','1234567891','test@test.com','Other','Testing my_query my_query','2024-12-19'),(8,'tanya','ABC','New Delhi','+91','8130341404','tanya.vashistha01@gmail.com','Female','From Contact Page','2024-12-20'),(9,'Ankit','Magnon','Noida','+91','8586882010','ankit.kumar@magnondesignory.com','Male','Testing purpose','2024-12-20'),(10,'Sumit Kumar ','Magnon solutions Pvt Ltd ','Noida ','+91','8395029955','Testing@gmail.com','Male','Testing of the form','2024-12-20'),(11,'Reena Singh','Magnon','Gautum Buddh Nagar','+91','9560509962','reena.singh@magnondesignory.com','Female','Testing get in touch page.','2024-12-20'),(12,'Ashutosh','Magnon Group','Noida','+91','6306551431','ashutosh.tripathi@magnondesignory.com','Male','This is a test note','2024-12-20'),(13,'Test','test','asdsad','+91','1234567891','test@test.com','..a digital media publisher/ad-network','sd fsdf sdf sdf sdf sd','2024-12-20'),(14,'Mudit Vashistha','Bizight Solutions Pvt Ltd','NEW DELHI','+91','9599761172','tanya.vashistha01@gmail.com','..a digital media publisher/ad-network','Testing 123','2024-12-20'),(15,'shivani shukla','Magnon','Noida','+91','0000000000','shivani1746@gmail.com','..looking for digital agency services','...................................','2024-12-23'),(16,'Mudit Vashistha','Bizight Solutions Pvt Ltd','NEW DELHI','+91','9599761172','tanya.vashistha01@gmail.com','..looking for digital agency services','Testing....','2024-12-23');
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` char(2) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` int NOT NULL,
  `continent_code` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` (`id`, `code`, `name`, `phone`, `continent_code`) VALUES (1,'AF','Afghanistan',93,'AS'),(2,'AX','Åland Islands',358,'EU'),(3,'AL','Albania',355,'EU'),(4,'DZ','Algeria',213,'AF'),(5,'AS','American Samoa',1,'OC'),(6,'AD','Andorra',376,'EU'),(7,'AO','Angola',244,'AF'),(8,'AI','Anguilla',1,'NA'),(9,'AQ','Antarctica',672,'AN'),(10,'AG','Antigua and Barbuda',1,'NA'),(11,'AR','Argentina',54,'SA'),(12,'AM','Armenia',374,'AS'),(13,'AW','Aruba',297,'NA'),(14,'AU','Australia',61,'OC'),(15,'AT','Austria',43,'EU'),(16,'AZ','Azerbaijan',994,'AS'),(17,'BS','Bahamas',1,'NA'),(18,'BH','Bahrain',973,'AS'),(19,'BD','Bangladesh',880,'AS'),(20,'BB','Barbados',1,'NA'),(21,'BY','Belarus',375,'EU'),(22,'BE','Belgium',32,'EU'),(23,'BZ','Belize',501,'NA'),(24,'BJ','Benin',229,'AF'),(25,'BM','Bermuda',1,'NA'),(26,'BT','Bhutan',975,'AS'),(27,'BO','Bolivia (Plurinational State of)',591,'SA'),(28,'BA','Bosnia and Herzegovina',387,'EU'),(29,'BW','Botswana',267,'AF'),(30,'BV','Bouvet Island',55,'AN'),(31,'BR','Brazil',55,'SA'),(32,'IO','British Indian Ocean Territory',246,'AS'),(33,'BN','Brunei Darussalam',673,'AS'),(34,'BG','Bulgaria',359,'EU'),(35,'BF','Burkina Faso',226,'AF'),(36,'BI','Burundi',257,'AF'),(37,'CV','Cabo Verde',238,'AF'),(38,'KH','Cambodia',855,'AS'),(39,'CM','Cameroon',237,'AF'),(40,'CA','Canada',1,'NA'),(41,'BQ','Caribbean Netherlands',599,'NA'),(42,'KY','Cayman Islands',1,'NA'),(43,'CF','Central African Republic',236,'AF'),(44,'TD','Chad',235,'AF'),(45,'CL','Chile',56,'SA'),(46,'CN','China',86,'AS'),(47,'CX','Christmas Island',61,'AS'),(48,'CC','Cocos (Keeling) Islands',61,'AS'),(49,'CO','Colombia',57,'SA'),(50,'KM','Comoros',269,'AF'),(51,'CG','Congo',242,'AF'),(52,'CD','Congo, Democratic Republic of the',243,'AF'),(53,'CK','Cook Islands',682,'OC'),(54,'CR','Costa Rica',506,'NA'),(55,'HR','Croatia',385,'EU'),(56,'CU','Cuba',53,'NA'),(57,'CW','Curaçao',599,'NA'),(58,'CY','Cyprus',357,'AS'),(59,'CZ','Czech Republic',420,'EU'),(60,'CI','Côte d\'Ivoire',225,'AF'),(61,'DK','Denmark',45,'EU'),(62,'DJ','Djibouti',253,'AF'),(63,'DM','Dominica',1,'NA'),(64,'DO','Dominican Republic',1,'NA'),(65,'EC','Ecuador',593,'SA'),(66,'EG','Egypt',20,'AF'),(67,'SV','El Salvador',503,'NA'),(68,'GQ','Equatorial Guinea',240,'AF'),(69,'ER','Eritrea',291,'AF'),(70,'EE','Estonia',372,'EU'),(71,'SZ','Eswatini (Swaziland)',268,'AF'),(72,'ET','Ethiopia',251,'AF'),(73,'FK','Falkland Islands (Malvinas)',500,'SA'),(74,'FO','Faroe Islands',298,'EU'),(75,'FJ','Fiji',679,'OC'),(76,'FI','Finland',358,'EU'),(77,'FR','France',33,'EU'),(78,'GF','French Guiana',594,'SA'),(79,'PF','French Polynesia',689,'OC'),(80,'TF','French Southern Territories',262,'AN'),(81,'GA','Gabon',241,'AF'),(82,'GM','Gambia',220,'AF'),(83,'GE','Georgia',995,'AS'),(84,'DE','Germany',49,'EU'),(85,'GH','Ghana',233,'AF'),(86,'GI','Gibraltar',350,'EU'),(87,'GR','Greece',30,'EU'),(88,'GL','Greenland',299,'NA'),(89,'GD','Grenada',1,'NA'),(90,'GP','Guadeloupe',590,'NA'),(91,'GU','Guam',1,'OC'),(92,'GT','Guatemala',502,'NA'),(93,'GG','Guernsey',44,'EU'),(94,'GN','Guinea',224,'AF'),(95,'GW','Guinea-Bissau',245,'AF'),(96,'GY','Guyana',592,'SA'),(97,'HT','Haiti',509,'NA'),(98,'HM','Heard Island and Mcdonald Islands',61,'AN'),(99,'HN','Honduras',504,'NA'),(100,'HK','Hong Kong',852,'AS'),(101,'HU','Hungary',36,'EU'),(102,'IS','Iceland',354,'EU'),(103,'IN','India',91,'AS'),(104,'ID','Indonesia',62,'AS'),(105,'IR','Iran',98,'AS'),(106,'IQ','Iraq',964,'AS'),(107,'IE','Ireland',353,'EU'),(108,'IM','Isle of Man',44,'EU'),(109,'IL','Israel',972,'AS'),(110,'IT','Italy',39,'EU'),(111,'JM','Jamaica',1,'NA'),(112,'JP','Japan',81,'AS'),(113,'JE','Jersey',44,'EU'),(114,'JO','Jordan',962,'AS'),(115,'KZ','Kazakhstan',7,'AS'),(116,'KE','Kenya',254,'AF'),(117,'KI','Kiribati',686,'OC'),(118,'KP','Korea, North',850,'AS'),(119,'KR','Korea, South',82,'AS'),(120,'XK','Kosovo',383,'EU'),(121,'KW','Kuwait',965,'AS'),(122,'KG','Kyrgyzstan',996,'AS'),(123,'LA','Lao People\'s Democratic Republic',856,'AS'),(124,'LV','Latvia',371,'EU'),(125,'LB','Lebanon',961,'AS'),(126,'LS','Lesotho',266,'AF'),(127,'LR','Liberia',231,'AF'),(128,'LY','Libya',218,'AF'),(129,'LI','Liechtenstein',423,'EU'),(130,'LT','Lithuania',370,'EU'),(131,'LU','Luxembourg',352,'EU'),(132,'MO','Macao',853,'AS'),(133,'MK','Macedonia North',389,'EU'),(134,'MG','Madagascar',261,'AF'),(135,'MW','Malawi',265,'AF'),(136,'MY','Malaysia',60,'AS'),(137,'MV','Maldives',960,'AS'),(138,'ML','Mali',223,'AF'),(139,'MT','Malta',356,'EU'),(140,'MH','Marshall Islands',692,'OC'),(141,'MQ','Martinique',596,'NA'),(142,'MR','Mauritania',222,'AF'),(143,'MU','Mauritius',230,'AF'),(144,'YT','Mayotte',262,'AF'),(145,'MX','Mexico',52,'NA'),(146,'FM','Micronesia',691,'OC'),(147,'MD','Moldova',373,'EU'),(148,'MC','Monaco',377,'EU'),(149,'MN','Mongolia',976,'AS'),(150,'ME','Montenegro',382,'EU'),(151,'MS','Montserrat',1,'NA'),(152,'MA','Morocco',212,'AF'),(153,'MZ','Mozambique',258,'AF'),(154,'MM','Myanmar (Burma)',95,'AS'),(155,'NA','Namibia',264,'AF'),(156,'NR','Nauru',674,'OC'),(157,'NP','Nepal',977,'AS'),(158,'NL','Netherlands',31,'EU'),(159,'AN','Netherlands Antilles',599,'NA'),(160,'NC','New Caledonia',687,'OC'),(161,'NZ','New Zealand',64,'OC'),(162,'NI','Nicaragua',505,'NA'),(163,'NE','Niger',227,'AF'),(164,'NG','Nigeria',234,'AF'),(165,'NU','Niue',683,'OC'),(166,'NF','Norfolk Island',672,'OC'),(167,'MP','Northern Mariana Islands',1,'OC'),(168,'NO','Norway',47,'EU'),(169,'OM','Oman',968,'AS'),(170,'PK','Pakistan',92,'AS'),(171,'PW','Palau',680,'OC'),(172,'PS','Palestine',970,'AS'),(173,'PA','Panama',507,'NA'),(174,'PG','Papua New Guinea',675,'OC'),(175,'PY','Paraguay',595,'SA'),(176,'PE','Peru',51,'SA'),(177,'PH','Philippines',63,'AS'),(178,'PN','Pitcairn Islands',64,'OC'),(179,'PL','Poland',48,'EU'),(180,'PT','Portugal',351,'EU'),(181,'PR','Puerto Rico',1,'NA'),(182,'QA','Qatar',974,'AS'),(183,'RE','Reunion',262,'AF'),(184,'RO','Romania',40,'EU'),(185,'RU','Russian Federation',7,'AS'),(186,'RW','Rwanda',250,'AF'),(187,'BL','Saint Barthelemy',590,'NA'),(188,'SH','Saint Helena',290,'AF'),(189,'KN','Saint Kitts and Nevis',1,'NA'),(190,'LC','Saint Lucia',1,'NA'),(191,'MF','Saint Martin',590,'NA'),(192,'PM','Saint Pierre and Miquelon',508,'NA'),(193,'VC','Saint Vincent and the Grenadines',1,'NA'),(194,'WS','Samoa',685,'OC'),(195,'SM','San Marino',378,'EU'),(196,'ST','Sao Tome and Principe',239,'AF'),(197,'SA','Saudi Arabia',966,'AS'),(198,'SN','Senegal',221,'AF'),(199,'RS','Serbia',381,'EU'),(200,'CS','Serbia and Montenegro',381,'EU'),(201,'SC','Seychelles',248,'AF'),(202,'SL','Sierra Leone',232,'AF'),(203,'SG','Singapore',65,'AS'),(204,'SX','Sint Maarten',1,'NA'),(205,'SK','Slovakia',421,'EU'),(206,'SI','Slovenia',386,'EU'),(207,'SB','Solomon Islands',677,'OC'),(208,'SO','Somalia',252,'AF'),(209,'ZA','South Africa',27,'AF'),(210,'GS','South Georgia and the South Sandwich Islands',500,'AN'),(211,'SS','South Sudan',211,'AF'),(212,'ES','Spain',34,'EU'),(213,'LK','Sri Lanka',94,'AS'),(214,'SD','Sudan',249,'AF'),(215,'SR','Suriname',597,'SA'),(216,'SJ','Svalbard and Jan Mayen',47,'EU'),(217,'SE','Sweden',46,'EU'),(218,'CH','Switzerland',41,'EU'),(219,'SY','Syria',963,'AS'),(220,'TW','Taiwan',886,'AS'),(221,'TJ','Tajikistan',992,'AS'),(222,'TZ','Tanzania',255,'AF'),(223,'TH','Thailand',66,'AS'),(224,'TL','Timor-Leste',670,'AS'),(225,'TG','Togo',228,'AF'),(226,'TK','Tokelau',690,'OC'),(227,'TO','Tonga',676,'OC'),(228,'TT','Trinidad and Tobago',1,'NA'),(229,'TN','Tunisia',216,'AF'),(230,'TR','Turkey (Türkiye)',90,'AS'),(231,'TM','Turkmenistan',993,'AS'),(232,'TC','Turks and Caicos Islands',1,'NA'),(233,'TV','Tuvalu',688,'OC'),(234,'UM','U.S. Outlying Islands',1,'NA'),(235,'UG','Uganda',256,'AF'),(236,'UA','Ukraine',380,'EU'),(237,'AE','United Arab Emirates',971,'AS'),(238,'GB','United Kingdom',44,'EU'),(239,'US','United States',1,'NA'),(240,'UY','Uruguay',598,'SA'),(241,'UZ','Uzbekistan',998,'AS'),(242,'VU','Vanuatu',678,'OC'),(243,'VA','Vatican City Holy See',39,'EU'),(244,'VE','Venezuela',58,'SA'),(245,'VN','Vietnam',84,'AS'),(246,'VG','Virgin Islands, British',1,'NA'),(247,'VI','Virgin Islands, U.S',1,'NA'),(248,'WF','Wallis and Futuna',681,'OC'),(249,'EH','Western Sahara',212,'AF'),(250,'YE','Yemen',967,'AS'),(251,'ZM','Zambia',260,'AF'),(252,'ZW','Zimbabwe',263,'AF');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'magnongrpin_mdes'
--

--
-- Dumping routines for database 'magnongrpin_mdes'
--
/*!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 2025-05-23 22:32:32