-- MySQL dump 10.13 Distrib 5.1.51, for pc-linux-gnu (i686)
--
-- Host: 127.0.0.1 Database: world
-- ------------------------------------------------------
-- Server version 5.1.51-debug-log
/*!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 latin1 */;
/*!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 `City`
--
DROP TABLE IF EXISTS `City`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `City` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` char(35) NOT NULL DEFAULT '',
`CountryCode` char(3) NOT NULL DEFAULT '',
`District` char(20) NOT NULL DEFAULT '',
`Population` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `CountryCode` (`CountryCode`),
CONSTRAINT `city_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `Country` (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `City`
--
-- ORDER BY: `ID`
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);
INSERT INTO `City` VALUES (37,'Constantine','DZA','Constantine',443727);
INSERT INTO `City` VALUES (38,'Annaba','DZA','Annaba',222518);
INSERT INTO `City` VALUES (39,'Batna','DZA','Batna',183377);
INSERT INTO `City` VALUES (40,'Sétif','DZA','Sétif',179055);
INSERT INTO `City` VALUES (41,'Sidi Bel Abbès','DZA','Sidi Bel Abbès',153106);
INSERT INTO `City` VALUES (42,'Skikda','DZA','Skikda',128747);
INSERT INTO `City` VALUES (43,'Biskra','DZA','Biskra',128281);
INSERT INTO `City` VALUES (44,'Blida (el-Boulaida)','DZA','Blida',127284);
INSERT INTO `City` VALUES (45,'Béjaïa','DZA','Béjaïa',117162);
INSERT INTO `City` VALUES (46,'Mostaganem','DZA','Mostaganem',115212);
INSERT INTO `City` VALUES (47,'Tébessa','DZA','Tébessa',112007);
INSERT INTO `City` VALUES (48,'Tlemcen (Tilimsen)','DZA','Tlemcen',110242);
INSERT INTO `City` VALUES (49,'Béchar','DZA','Béchar',107311);
INSERT INTO `City` VALUES (50,'Tiaret','DZA','Tiaret',100118);
INSERT INTO `City` VALUES (51,'Ech-Chleff (el-Asnam)','DZA','Chlef',96794);
INSERT INTO `City` VALUES (52,'Ghardaïa','DZA','Ghardaïa',89415);
INSERT INTO `City` VALUES (53,'Tafuna','ASM','Tutuila',5200);
INSERT INTO `City` VALUES (54,'Fagatogo','ASM','Tutuila',2323);
INSERT INTO `City` VALUES (55,'Andorra la Vella','AND','Andorra la Vella',21189);
INSERT INTO `City` VALUES (56,'Luanda','AGO','Luanda',2022000);
INSERT INTO `City` VALUES (57,'Huambo','AGO','Huambo',163100);
INSERT INTO `City` VALUES (58,'Lobito','AGO','Benguela',130000);
INSERT INTO `City` VALUES (59,'Benguela','AGO','Benguela',128300);
INSERT INTO `City` VALUES (60,'Namibe','AGO','Namibe',118200);
INSERT INTO `City` VALUES (61,'South Hill','AIA','',961);
INSERT INTO `City` VALUES (62,'The Valley','AIA','',595);
INSERT INTO `City` VALUES (63,'Saint John´s','ATG','St John',24000);
INSERT INTO `City` VALUES (64,'Dubai','ARE','Dubai',669181);
INSERT INTO `City` VALUES (65,'Abu Dhabi','ARE','Abu Dhabi',398695);
INSERT INTO `City` VALUES (66,'Sharja','ARE','Sharja',320095);
INSERT INTO `City` VALUES (67,'al-Ayn','ARE','Abu Dhabi',225970);
INSERT INTO `City` VALUES (68,'Ajman','ARE','Ajman',114395);
INSERT INTO `City` VALUES (69,'Buenos Aires','ARG','Distrito Federal',2982146);
INSERT INTO `City` VALUES (70,'La Matanza','ARG','Buenos Aires',1266461);
INSERT INTO `City` VALUES (71,'Córdoba','ARG','Córdoba',1157507);
INSERT INTO `City` VALUES (72,'Rosario','ARG','Santa Fé',907718);
INSERT INTO `City` VALUES (73,'Lomas de Zamora','ARG','Buenos Aires',622013);
INSERT INTO `City` VALUES (74,'Quilmes','ARG','Buenos Aires',559249);
INSERT INTO `City` VALUES (75,'Almirante Brown','ARG','Buenos Aires',538918);
INSERT INTO `City` VALUES (76,'La Plata','ARG','Buenos Aires',521936);
INSERT INTO `City` VALUES (77,'Mar del Plata','ARG','Buenos Aires',512880);
INSERT INTO `City` VALUES (78,'San Miguel de Tucumán','ARG','Tucumán',470809);
INSERT INTO `City` VALUES (79,'Lanús','ARG','Buenos Aires',469735);
INSERT INTO `City` VALUES (80,'Merlo','ARG','Buenos Aires',463846);
INSERT INTO `City` VALUES (81,'General San Martín','ARG','Buenos Aires',422542);
INSERT INTO `City` VALUES (82,'Salta','ARG','Salta',367550);
INSERT INTO `City` VALUES (83,'Moreno','ARG','Buenos Aires',356993);
INSERT INTO `City` VALUES (84,'Santa Fé','ARG','Santa Fé',353063);
INSERT INTO `City` VALUES (85,'Avellaneda','ARG','Buenos Aires',353046);
INSERT INTO `City` VALUES (86,'Tres de Febrero','ARG','Buenos Aires',352311);
INSERT INTO `City` VALUES (87,'Morón','ARG','Buenos Aires',349246);
INSERT INTO `City` VALUES (88,'Florencio Varela','ARG','Buenos Aires',315432);
INSERT INTO `City` VALUES (89,'San Isidro','ARG','Buenos Aires',306341);
INSERT INTO `City` VALUES (90,'Tigre','ARG','Buenos Aires',296226);
INSERT INTO `City` VALUES (91,'Malvinas Argentinas','ARG','Buenos Aires',290335);
INSERT INTO `City` VALUES (92,'Vicente López','ARG','Buenos Aires',288341);
INSERT INTO `City` VALUES (93,'Berazategui','ARG','Buenos Aires',276916);
INSERT INTO `City` VALUES (94,'Corrientes','ARG','Corrientes',258103);
INSERT INTO `C
评论1