-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: localhost    Database: sgloanapp_db_v1
-- ------------------------------------------------------
-- Server version	5.7.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 */;
/*!40101 SET NAMES utf8 */;
/*!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_codes`
--

DROP TABLE IF EXISTS `country_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country_codes` (
  `id` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country_codes`
--

LOCK TABLES `country_codes` WRITE;
/*!40000 ALTER TABLE `country_codes` DISABLE KEYS */;
INSERT INTO `country_codes` VALUES (1,'USA','1'),(2,'Algeria','213'),(3,'Andorra','376'),(4,'Angola','244'),(5,'Anguilla','1264'),(6,'Antigua & Barbuda','1268'),(7,'Argentina','54'),(8,'Armenia','374'),(9,'Aruba','297'),(10,'Australia','61'),(11,'Austria','43'),(12,'Azerbaijan','994'),(13,'Bahamas','1242'),(14,'Bahrain','973'),(15,'Bangladesh','880'),(16,'Barbados','1246'),(17,'Belarus','375'),(18,'Belgium','32'),(19,'Belize','501'),(20,'Benin','229'),(21,'Bermuda','1441'),(22,'Bhutan','975'),(23,'Bolivia','591'),(24,'Bosnia Herzegovina','387'),(25,'Botswana','267'),(26,'Brazil','55'),(27,'Brunei','673'),(28,'Bulgaria','359'),(29,'Burkina Faso','226'),(30,'Burundi','257'),(31,'Cambodia','855'),(32,'Cameroon','237'),(33,'Canada','1'),(34,'Cape Verde Islands','238'),(35,'Cayman Islands','1345'),(36,'Central African Republic','236'),(37,'Chile','56'),(38,'China','86'),(39,'Colombia','57'),(40,'Comoros','269'),(41,'Congo','242'),(42,'Cook Islands','682'),(43,'Costa Rica','506'),(44,'Croatia','385'),(45,'Cuba','53'),(46,'Cyprus North','90392'),(47,'Cyprus South','357'),(48,'Czech Republic','42'),(49,'Denmark','45'),(50,'Djibouti','253'),(51,'Dominica','1809'),(52,'Dominican Republic','1809'),(53,'Ecuador','593'),(54,'Egypt','20'),(55,'El Salvador','503'),(56,'Equatorial Guinea','240'),(57,'Eritrea','291'),(58,'Estonia','372'),(59,'Ethiopia','251'),(60,'Falkland Islands','500'),(61,'Faroe Islands','298'),(62,'Fiji','679'),(63,'Finland','358'),(64,'France','33'),(65,'French Guiana','594'),(66,'French Polynesia','689'),(67,'Gabon','241'),(68,'Gambia','220'),(69,'Georgia','7880'),(70,'Germany','49'),(71,'Ghana','233'),(72,'Gibraltar','350'),(73,'Greece','30'),(74,'Greenland','299'),(75,'Grenada','1473'),(76,'Guadeloupe','590'),(77,'Guam','671'),(78,'Guatemala','502'),(79,'Guinea','224'),(80,'Guinea - Bissau','245'),(81,'Guyana','592'),(82,'Haiti','509'),(83,'Honduras','504'),(84,'Hong Kong','852'),(85,'Hungary','36'),(86,'Iceland','354'),(87,'India','91'),(88,'Indonesia','62'),(89,'Iran','98'),(90,'Iraq','964'),(91,'Ireland','353'),(92,'Israel','972'),(93,'Italy','39'),(94,'Jamaica','1876'),(95,'Japan','81'),(96,'Jordan','962'),(97,'Kazakhstan','7'),(98,'Kenya','254'),(99,'Kiribati','686'),(100,'Korea North','850'),(101,'Korea South','82'),(102,'Kuwait','965'),(103,'Kyrgyzstan','996'),(104,'Laos','856'),(105,'Latvia','371'),(106,'Lebanon','961'),(107,'Lesotho','266'),(108,'Liberia','231'),(109,'Libya','218'),(110,'Liechtenstein','417'),(111,'Lithuania','370'),(112,'Luxembourg','352'),(113,'Macao','853'),(114,'Macedonia','389'),(115,'Madagascar','261'),(116,'Malawi','265'),(117,'Malaysia','60'),(118,'Maldives','960'),(119,'Mali','223'),(120,'Malta','356'),(121,'Marshall Islands','692'),(122,'Martinique','596'),(123,'Mauritania','222'),(124,'Mayotte','269'),(125,'Mexico','52'),(126,'Micronesia','691'),(127,'Moldova','373'),(128,'Monaco','377'),(129,'Mongolia','976'),(130,'Montserrat','1664'),(131,'Morocco','212'),(132,'Mozambique','258'),(133,'Myanmar','95'),(134,'Namibia','264'),(135,'Nauru','674'),(136,'Nepal','977'),(137,'Netherlands','31'),(138,'New Caledonia','687'),(139,'New Zealand','64'),(140,'Nicaragua','505'),(141,'Niger','227'),(142,'Nigeria','234'),(143,'Niue','683'),(144,'Norfolk Islands','672'),(145,'Northern Marianas','670'),(146,'Norway','47'),(147,'Oman','968'),(148,'Palau','680'),(149,'Panama','507'),(150,'Papua New Guinea','675'),(151,'Paraguay','595'),(152,'Peru','51'),(153,'Philippines','63'),(154,'Poland','48'),(155,'Portugal','351'),(156,'Puerto Rico','1787'),(157,'Qatar','974'),(158,'Reunion','262'),(159,'Romania','40'),(160,'Russia','7'),(161,'Rwanda','250'),(162,'San Marino','378'),(163,'Sao Tome & Principe','239'),(164,'Saudi Arabia','966'),(165,'Senegal','221'),(166,'Serbia','381'),(167,'Seychelles','248'),(168,'Sierra Leone','232'),(169,'Singapore','65'),(170,'Slovak Republic','421'),(171,'Slovenia','386'),(172,'Solomon Islands','677'),(173,'Somalia','252'),(174,'South Africa','27'),(175,'Spain','34'),(176,'Sri Lanka','94'),(177,'St. Helena','290'),(178,'St. Kitts','1869'),(179,'St. Lucia','1758'),(180,'Sudan','249'),(181,'Suriname','597'),(182,'Swaziland','268'),(183,'Sweden','46'),(184,'Switzerland','41'),(185,'Syria','963'),(186,'Taiwan','886'),(187,'Tajikstan','7'),(188,'Thailand','66'),(189,'Togo','228'),(190,'Tonga','676'),(191,'Trinidad & Tobago','1868'),(192,'Tunisia','216'),(193,'Turkey','90'),(194,'Turkmenistan','7'),(195,'Turkmenistan','993'),(196,'Turks & Caicos Islands','1649'),(197,'Tuvalu','688'),(198,'Uganda','256'),(199,'Ukraine','380'),(200,'United Arab Emirates','971'),(201,'Uruguay','598'),(202,'Uzbekistan','7'),(203,'Vanuatu','678'),(204,'Vatican City','379'),(205,'Venezuela','58'),(206,'Vietnam','84'),(207,'Virgin Islands - British','84'),(208,'Virgin Islands - US','84'),(209,'Wallis & Futuna','681'),(210,'Yemen (North)','969'),(211,'Yemen (South)','967'),(212,'Zambia','260'),(213,'Zimbabwe','263');
/*!40000 ALTER TABLE `country_codes` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-06-10 11:43:50
