-- MySQL dump 10.13 Distrib 8.0.19, for osx10.14 (x86_64) -- -- Host: 127.0.0.1 Database: li -- ------------------------------------------------------ -- Server version 8.0.19-debug /*!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 */; SET @old_autocommit=@@autocommit; -- -- Current Database: `licence` -- /*!40000 DROP DATABASE IF EXISTS `licence`*/; CREATE DATABASE `licence` DEFAULT CHARACTER SET utf8mb4; USE `licence`; -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `city` ( `ID` int NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `CountryCode` (`CountryCode`), CONSTRAINT `city_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `city` -- -- ORDER BY: `ID` set autocommit=0; INSERT INTO `city` VALUES (1,'Kabul','AFG','Kabol',1780000); INSERT INTO `city` VALUES (2,'Qandahar','AFG','Qandahar',237500); INSERT INTO `city` VALUES (3,'Herat','AFG','Herat',186800); INSERT INTO `city` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800); INSERT INTO `city` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200); INSERT INTO `city` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321); INSERT INTO `city` VALUES (7,'Haag','NLD','Zuid-Holland',440900); INSERT INTO `city` VALUES (8,'Utrecht','NLD','Utrecht',234323); INSERT INTO `city` VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843); INSERT INTO `city` VALUES (10,'Tilburg','NLD','Noord-Brabant',193238); INSERT INTO `city` VALUES (11,'Groningen','NLD','Groningen',172701); INSERT INTO `city` VALUES (12,'Breda','NLD','Noord-Brabant',160398); INSERT INTO `city` VALUES (13,'Apeldoorn','NLD','Gelderland',153491); INSERT INTO `city` VALUES (14,'Nijmegen','NLD','Gelderland',152463); INSERT INTO `city` VALUES (15,'Enschede','NLD','Overijssel',149544); INSERT INTO `city` VALUES (16,'Haarlem','NLD','Noord-Holland',148772); INSERT INTO `city` VALUES (17,'Almere','NLD','Flevoland',142465); INSERT INTO `city` VALUES (18,'Arnhem','NLD','Gelderland',138020); INSERT INTO `city` VALUES (19,'Zaanstad','NLD','Noord-Holland',135621); INSERT INTO `city` VALUES (20,'´s-Hertogenbosch','NLD','Noord-Brabant',129170); INSERT INTO `city` VALUES (21,'Amersfoort','NLD','Utrecht',126270); INSERT INTO `city` VALUES (22,'Maastricht','NLD','Limburg',122087); INSERT INTO `city` VALUES (23,'Dordrecht','NLD','Zuid-Holland',119811); INSERT INTO `city` VALUES (24,'Leiden','NLD','Zuid-Holland',117196); INSERT INTO `city` VALUES (25,'Haarlemmermeer','NLD','Noord-Holland',110722); INSERT INTO `city` VALUES (26,'Zoetermeer','NLD','Zuid-Holland',110214); INSERT INTO `city` VALUES (27,'Emmen','NLD','Drenthe',105853); INSERT INTO `city` VALUES (28,'Zwolle','NLD','Overijssel',105819); INSERT INTO `city` VALUES (29,'Ede','NLD','Gelderland',101574); INSERT INTO `city` VALUES (30,'Delft','NLD','Zuid-Holland',95268); INSERT INTO `city` VALUES (31,'Heerlen','NLD','Limburg',95052); INSERT INTO `city` VALUES (32,'Alkmaar','NLD','Noord-Holland',92713); INSERT INTO `city` VALUES (33,'Willemstad','ANT','Curaçao',2345); INSERT INTO `city` VALUES (34,'Tirana','ALB','Tirana',270000); INSERT INTO `city` VALUES (35,'Alger','DZA','Alger',2168000); INSERT INTO `city` VALUES (36,'Oran','DZA','Oran',609823); commit; -- -- 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` ( `Code` char(3) NOT NULL DEFAULT '', `Name` char(52) NOT NULL DEFAULT '', `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL DEFAULT 'Asia', `Region` char(26) NOT NULL DEFAULT '', `SurfaceArea` decimal(10,2) NOT NULL DEFAULT '0.00', `IndepYear` smallint DEFAULT NULL, `Population` int NOT NULL DEFAULT '0', `LifeExpectancy` decimal(3,1) DEFAULT NULL, `GNP` decimal(10,2) DEFAULT NULL, `GNPOld` decimal(10,2) DEFAULT NULL, `LocalName` char(45) NOT NULL DEFAULT '', `GovernmentForm` char(45) NOT NULL DEFAULT '', `HeadOfState` char(60) DEFAULT NULL, `Capital` int DEFAULT NULL, `Code2` char(2) NOT NULL DEFAULT '', PRIMARY KEY (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country` -- -- ORDER BY: `Code` set autocommit=0; INSERT INTO `country` VALUES ('ABW','Aruba','North America','Caribbean',193.00,NULL,103000,78.4,828.00,793.00,'Aruba','Nonmetropolitan Territory of The Netherlands','Beatrix',129,'AW'); INSERT INTO `country` VALUES ('AFG','Afghanistan','Asia','Southern and Central Asia',652090.00,1919,22720000,45.9,5976.00,NULL,'Afganistan/Afqanestan','Islamic Emirate','Mohammad Omar',1,'AF'); INSERT INTO `country` VALUES ('AGO','Angola','Africa','Central Africa',1246700.00,1975,12878000,38.3,6648.00,7984.00,'Angola','Republic','José Eduardo dos Santos',56,'AO'); INSERT INTO `country` VALUES ('AIA','Anguilla','North America','Caribbean',96.00,NULL,8000,76.1,63.20,NULL,'Anguilla','Dependent Territory of the UK','Elisabeth II',62,'AI'); INSERT INTO `country` VALUES ('ALB','Albania','Europe','Southern Europe',28748.00,1912,3401200,71.6,3205.00,2500.00,'Shqipëria','Republic','Rexhep Mejdani',34,'AL'); INSERT INTO `country` VALUES ('AND','Andorra','Europe','Southern Europe',468.00,1278,78000,83.5,1630.00,NULL,'Andorra','Parliamentary Coprincipality','',55,'AD'); INSERT INTO `country` VALUES ('ANT','Netherlands Antilles','North America','Caribbean',800.00,NULL,217000,74.7,1941.00,NULL,'Nederlandse Antillen','Nonmetropolitan Territory of The Netherlands','Beatrix',33,'AN'); INSERT INTO `country` VALUES ('ARE','United Arab Emirates','Asia','Middle East',83600.00,1971,2441000,74.1,37966.00,36846.00,'Al-Imarat al-´Arabiya al-Muttahida','Emirate Federation','Zayid bin Sultan al-Nahayan',65,'AE'); INSERT INTO `country` VALUES ('ARG','Argentina','South America','South America',2780400.00,1816,37032000,75.1,340238.00,323310.00,'Argentina','Federal Republic','Fernando de la Rúa',69,'AR'); INSERT INTO `country` VALUES ('ARM','Armenia','Asia','Middle East',29800.00,1991,3520000,66.4,1813.00,1627.00,'Hajastan','Republic','Robert Kotšarjan',126,'AM'); INSERT INTO `country` VALUES ('ASM','American Samoa','Oceania','Polynesia',199.00,NULL,68000,75.1,334.00,NULL,'Amerika Samoa','US Territory','George W. Bush',54,'AS'); INSERT INTO `country` VALUES ('ATA','Antarctica','Antarctica','Antarctica',13120000.00,NULL,0,NULL,0.00,NULL,'–','Co-administrated','',NULL,'AQ'); INSERT INTO `country` VALUES ('ATF','French Southern territories','Antarctica','Antarctica',7780.00,NULL,0,NULL,0.00,NULL,'Terres australes françaises','Nonmetropolitan Territory of France','Jacques Chirac',NULL,'TF'); INSERT INTO `country` VALUES ('ATG','Antigua and Barbuda','North America','Caribbean',442.00,1981,68000,70.5,612.00,584.00,'Antigua and Barbuda','Constitutional Monarchy','Elisabeth II',63,'AG'); INSERT INTO `country` VALUES ('AUS','Australia','Oceania','Australia and New Zealand',7741220.00,1901,18886000,79.8,351182.00,392911.00,'Australia','Constitutional Monarchy, Federation','Elisabeth II',135,'AU'); INSERT INTO `country` VALUES ('AUT','Austria','Europe','Western Europe',83859.00,1918,8091800,77.7,211860.00,206025.00,'Österreich','Federal Republic','Thomas Klestil',1523,'AT'); INSERT INTO `country` VALUES ('YEM','Yemen','Asia','Middle East',527968.00,1918,18112000,59.8,6041.00,5729.00,'Al-Yaman','Republic','Ali Abdallah Salih',1780,'YE'); INSERT INTO `country` VALUES ('YUG','Yugoslavia','Europe','Southern Europe',102173.00,1918,10640000,72.4,17000.00,NULL,'Jugoslavija','Federal Republic','Vojislav Koštunica',1792,'YU'); INSERT INTO `country` VALUES ('ZAF','South Africa','Africa','Southern Africa',1221037.00,1910,40377000,51.1,116729.00,129092.00,'South Africa','Republic','Thabo Mbeki',716,'ZA'); INSERT INTO `country` VALUES ('ZMB','Zambia','Africa','Eastern Africa',752618.00,1964,9169000,37.2,3377.00,3922.00,'Zambia','Republic','Frederick Chiluba',3162,'ZM'); INSERT INTO `country` VALUES ('ZWE','Zimbabwe','Africa','Eastern Africa',390757.00,1980,11669000,37.8,5951.00,8670.00,'Zimbabwe','Republic','Robert G. Mugabe',4068,'ZW'); commit; -- -- Table structure for table `countrylanguage` -- DROP TABLE IF EXISTS `countrylanguage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `countrylanguage` ( `CountryCode` char(3) NOT NULL DEFAULT '', `Language` char(30) NOT NULL DEFAULT '', `IsOfficial` enum('T','F') NOT NULL DEFAULT 'F', `Percentage` decimal(4,1) NOT NULL DEFAULT '0.0', PRIMARY KEY (`CountryCode`,`Language`), KEY `CountryCode` (`CountryCode`), CONSTRAINT `countryLanguage_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `countrylanguage` -- -- ORDER BY: `CountryCode`,`Language` set autocommit=0; INSERT INTO `countrylanguage` VALUES ('ABW','Dutch','T',5.3); INSERT INTO `countrylanguage` VALUES ('ABW','English','F',9.5); INSERT INTO `countrylanguage` VALUES ('ABW','Papiamento','F',76.7); INSERT INTO `countrylanguage` VALUES ('ABW','Spanish','F',7.4); INSERT INTO `countrylanguage` VALUES ('AFG','Balochi','F',0.9); INSERT INTO `countrylanguage` VALUES ('AFG','Dari','T',32.1); INSERT INTO `countrylanguage` VALUES ('AFG','Pashto','T',52.4); INSERT INTO `countrylanguage` VALUES ('AFG','Turkmenian','F',1.9); INSERT INTO `countrylanguage` VALUES ('AFG','Uzbek','F',8.8); INSERT INTO `countrylanguage` VALUES ('AGO','Ambo','F',2.4); INSERT INTO `countrylanguage` VALUES ('AGO','Chokwe','F',4.2); INSERT INTO `countrylanguage` VALUES ('AGO','Kongo','F',13.2); INSERT INTO `countrylanguage` VALUES ('AGO','Luchazi','F',2.4); INSERT INTO `countrylanguage` VALUES ('AGO','Luimbe-nganguela','F',5.4); INSERT INTO `countrylanguage` VALUES ('AGO','Luvale','F',3.6); INSERT INTO `countrylanguage` VALUES ('AGO','Mbundu','F',21.6); INSERT INTO `countrylanguage` VALUES ('AGO','Nyaneka-nkhumbi','F',5.4); INSERT INTO `countrylanguage` VALUES ('AGO','Ovimbundu','F',37.2); commit; -- -- Dumping events for database 'li' -- -- -- Dumping routines for database 'li' -- /*!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 */; SET autocommit=@old_autocommit; -- Dump completed on 2020-01-22 9:56:18 -- MySQL dump 10.13 Distrib 8.0.19, for osx10.14 (x86_64) -- -- Host: 127.0.0.1 Database: ma -- ------------------------------------------------------ -- Server version 8.0.19-debug /*!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 */; SET @old_autocommit=@@autocommit; -- -- Current Database: `ma` -- /*!40000 DROP DATABASE IF EXISTS `world`*/; CREATE DATABASE `ma` DEFAULT CHARACTER SET utf8mb4; USE `ma`; -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `city` ( `ID` int NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `CountryCode` (`CountryCode`), CONSTRAINT `city_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `city` -- -- ORDER BY: `ID` set autocommit=0; INSERT INTO `city` VALUES (1,'Kabul','AFG','Kabol',1780000); INSERT INTO `city` VALUES (2,'Qandahar','AFG','Qandahar',237500); INSERT INTO `city` VALUES (3,'Herat','AFG','Herat',186800); INSERT INTO `city` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800); INSERT INTO `city` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200); INSERT INTO `city` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321); INSERT INTO `city` VALUES (7,'Haag','NLD','Zuid-Holland',440900); INSERT INTO `city` VALUES (8,'Utrecht','NLD','Utrecht',234323); INSERT INTO `city` VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843); INSERT INTO `city` VALUES (10,'Tilburg','NLD','Noord-Brabant',193238); INSERT INTO `city` VALUES (11,'Groningen','NLD','Groningen',172701); INSERT INTO `city` VALUES (12,'Breda','NLD','Noord-Brabant',160398); INSERT INTO `city` VALUES (13,'Apeldoorn','NLD','Gelderland',153491); INSERT INTO `city` VALUES (14,'Nijmegen','NLD','Gelderland',152463); INSERT INTO `city` VALUES (15,'Enschede','NLD','Overijssel',149544); INSERT INTO `city` VALUES (16,'Haarlem','NLD','Noord-Holland',148772); INSERT INTO `city` VALUES (17,'Almere','NLD','Flevoland',142465); INSERT INTO `city` VALUES (18,'Arnhem','NLD','Gelderland',138020); INSERT INTO `city` VALUES (19,'Zaanstad','NLD','Noord-Holland',135621); INSERT INTO `city` VALUES (20,'´s-Hertogenbosch','NLD','Noord-Brabant',129170); INSERT INTO `city` VALUES (21,'Amersfoort','NLD','Utrecht',126270); INSERT INTO `city` VALUES (22,'Maastricht','NLD','Limburg',122087); INSERT INTO `city` VALUES (23,'Dordrecht','NLD','Zuid-Holland',119811); INSERT INTO `city` VALUES (24,'Leiden','NLD','Zuid-Holland',117196); INSERT INTO `city` VALUES (25,'Haarlemmermeer','NLD','Noord-Holland',110722); INSERT INTO `city` VALUES (26,'Zoetermeer','NLD','Zuid-Holland',110214); INSERT INTO `city` VALUES (27,'Emmen','NLD','Drenthe',105853); INSERT INTO `city` VALUES (28,'Zwolle','NLD','Overijssel',105819); INSERT INTO `city` VALUES (29,'Ede','NLD','Gelderland',101574); INSERT INTO `city` VALUES (30,'Delft','NLD','Zuid-Holland',95268); INSERT INTO `city` VALUES (31,'Heerlen','NLD','Limburg',95052); INSERT INTO `city` VALUES (32,'Alkmaar','NLD','Noord-Holland',92713); INSERT INTO `city` VALUES (33,'Willemstad','ANT','Curaçao',2345); INSERT INTO `city` VALUES (34,'Tirana','ALB','Tirana',270000); INSERT INTO `city` VALUES (35,'Alger','DZA','Alger',2168000); INSERT INTO `city` VALUES (36,'Oran','DZA','Oran',609823); commit; -- -- 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` ( `Code` char(3) NOT NULL DEFAULT '', `Name` char(52) NOT NULL DEFAULT '', `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL DEFAULT 'Asia', `Region` char(26) NOT NULL DEFAULT '', `SurfaceArea` decimal(10,2) NOT NULL DEFAULT '0.00', `IndepYear` smallint DEFAULT NULL, `Population` int NOT NULL DEFAULT '0', `LifeExpectancy` decimal(3,1) DEFAULT NULL, `GNP` decimal(10,2) DEFAULT NULL, `GNPOld` decimal(10,2) DEFAULT NULL, `LocalName` char(45) NOT NULL DEFAULT '', `GovernmentForm` char(45) NOT NULL DEFAULT '', `HeadOfState` char(60) DEFAULT NULL, `Capital` int DEFAULT NULL, `Code2` char(2) NOT NULL DEFAULT '', PRIMARY KEY (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country` -- -- ORDER BY: `Code` set autocommit=0; INSERT INTO `country` VALUES ('ABW','Aruba','North America','Caribbean',193.00,NULL,103000,78.4,828.00,793.00,'Aruba','Nonmetropolitan Territory of The Netherlands','Beatrix',129,'AW'); INSERT INTO `country` VALUES ('AFG','Afghanistan','Asia','Southern and Central Asia',652090.00,1919,22720000,45.9,5976.00,NULL,'Afganistan/Afqanestan','Islamic Emirate','Mohammad Omar',1,'AF'); INSERT INTO `country` VALUES ('AGO','Angola','Africa','Central Africa',1246700.00,1975,12878000,38.3,6648.00,7984.00,'Angola','Republic','José Eduardo dos Santos',56,'AO'); INSERT INTO `country` VALUES ('AIA','Anguilla','North America','Caribbean',96.00,NULL,8000,76.1,63.20,NULL,'Anguilla','Dependent Territory of the UK','Elisabeth II',62,'AI'); INSERT INTO `country` VALUES ('ALB','Albania','Europe','Southern Europe',28748.00,1912,3401200,71.6,3205.00,2500.00,'Shqipëria','Republic','Rexhep Mejdani',34,'AL'); INSERT INTO `country` VALUES ('AND','Andorra','Europe','Southern Europe',468.00,1278,78000,83.5,1630.00,NULL,'Andorra','Parliamentary Coprincipality','',55,'AD'); INSERT INTO `country` VALUES ('ANT','Netherlands Antilles','North America','Caribbean',800.00,NULL,217000,74.7,1941.00,NULL,'Nederlandse Antillen','Nonmetropolitan Territory of The Netherlands','Beatrix',33,'AN'); INSERT INTO `country` VALUES ('ARE','United Arab Emirates','Asia','Middle East',83600.00,1971,2441000,74.1,37966.00,36846.00,'Al-Imarat al-´Arabiya al-Muttahida','Emirate Federation','Zayid bin Sultan al-Nahayan',65,'AE'); INSERT INTO `country` VALUES ('ARG','Argentina','South America','South America',2780400.00,1816,37032000,75.1,340238.00,323310.00,'Argentina','Federal Republic','Fernando de la Rúa',69,'AR'); INSERT INTO `country` VALUES ('ARM','Armenia','Asia','Middle East',29800.00,1991,3520000,66.4,1813.00,1627.00,'Hajastan','Republic','Robert Kotšarjan',126,'AM'); INSERT INTO `country` VALUES ('ASM','American Samoa','Oceania','Polynesia',199.00,NULL,68000,75.1,334.00,NULL,'Amerika Samoa','US Territory','George W. Bush',54,'AS'); INSERT INTO `country` VALUES ('ATA','Antarctica','Antarctica','Antarctica',13120000.00,NULL,0,NULL,0.00,NULL,'–','Co-administrated','',NULL,'AQ'); INSERT INTO `country` VALUES ('ATF','French Southern territories','Antarctica','Antarctica',7780.00,NULL,0,NULL,0.00,NULL,'Terres australes françaises','Nonmetropolitan Territory of France','Jacques Chirac',NULL,'TF'); INSERT INTO `country` VALUES ('ATG','Antigua and Barbuda','North America','Caribbean',442.00,1981,68000,70.5,612.00,584.00,'Antigua and Barbuda','Constitutional Monarchy','Elisabeth II',63,'AG'); INSERT INTO `country` VALUES ('AUS','Australia','Oceania','Australia and New Zealand',7741220.00,1901,18886000,79.8,351182.00,392911.00,'Australia','Constitutional Monarchy, Federation','Elisabeth II',135,'AU'); INSERT INTO `country` VALUES ('AUT','Austria','Europe','Western Europe',83859.00,1918,8091800,77.7,211860.00,206025.00,'Österreich','Federal Republic','Thomas Klestil',1523,'AT'); INSERT INTO `country` VALUES ('YEM','Yemen','Asia','Middle East',527968.00,1918,18112000,59.8,6041.00,5729.00,'Al-Yaman','Republic','Ali Abdallah Salih',1780,'YE'); INSERT INTO `country` VALUES ('YUG','Yugoslavia','Europe','Southern Europe',102173.00,1918,10640000,72.4,17000.00,NULL,'Jugoslavija','Federal Republic','Vojislav Koštunica',1792,'YU'); INSERT INTO `country` VALUES ('ZAF','South Africa','Africa','Southern Africa',1221037.00,1910,40377000,51.1,116729.00,129092.00,'South Africa','Republic','Thabo Mbeki',716,'ZA'); INSERT INTO `country` VALUES ('ZMB','Zambia','Africa','Eastern Africa',752618.00,1964,9169000,37.2,3377.00,3922.00,'Zambia','Republic','Frederick Chiluba',3162,'ZM'); INSERT INTO `country` VALUES ('ZWE','Zimbabwe','Africa','Eastern Africa',390757.00,1980,11669000,37.8,5951.00,8670.00,'Zimbabwe','Republic','Robert G. Mugabe',4068,'ZW'); commit; -- -- Table structure for table `countrylanguage` -- DROP TABLE IF EXISTS `countrylanguage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `countrylanguage` ( `CountryCode` char(3) NOT NULL DEFAULT '', `Language` char(30) NOT NULL DEFAULT '', `IsOfficial` enum('T','F') NOT NULL DEFAULT 'F', `Percentage` decimal(4,1) NOT NULL DEFAULT '0.0', PRIMARY KEY (`CountryCode`,`Language`), KEY `CountryCode` (`CountryCode`), CONSTRAINT `countryLanguage_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `countrylanguage` -- -- ORDER BY: `CountryCode`,`Language` set autocommit=0; INSERT INTO `countrylanguage` VALUES ('ABW','Dutch','T',5.3); INSERT INTO `countrylanguage` VALUES ('ABW','English','F',9.5); INSERT INTO `countrylanguage` VALUES ('ABW','Papiamento','F',76.7); INSERT INTO `countrylanguage` VALUES ('ABW','Spanish','F',7.4); INSERT INTO `countrylanguage` VALUES ('AFG','Balochi','F',0.9); INSERT INTO `countrylanguage` VALUES ('AFG','Dari','T',32.1); INSERT INTO `countrylanguage` VALUES ('AFG','Pashto','T',52.4); INSERT INTO `countrylanguage` VALUES ('AFG','Turkmenian','F',1.9); INSERT INTO `countrylanguage` VALUES ('AFG','Uzbek','F',8.8); INSERT INTO `countrylanguage` VALUES ('AGO','Ambo','F',2.4); INSERT INTO `countrylanguage` VALUES ('AGO','Chokwe','F',4.2); INSERT INTO `countrylanguage` VALUES ('AGO','Kongo','F',13.2); INSERT INTO `countrylanguage` VALUES ('AGO','Luchazi','F',2.4); INSERT INTO `countrylanguage` VALUES ('AGO','Luimbe-nganguela','F',5.4); INSERT INTO `countrylanguage` VALUES ('AGO','Luvale','F',3.6); INSERT INTO `countrylanguage` VALUES ('AGO','Mbundu','F',21.6); INSERT INTO `countrylanguage` VALUES ('AGO','Nyaneka-nkhumbi','F',5.4); INSERT INTO `countrylanguage` VALUES ('AGO','Ovimbundu','F',37.2); commit; -- -- Dumping events for database 'world' -- -- -- Dumping routines for database 'world' -- /*!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 */; SET autocommit=@old_autocommit; -- Dump completed on 2020-01-22 9:56:18