# This script creates a city table for use with the social network database

SET foreign_key_checks = 0;
# Drop any existing city table
DROP TABLE IF EXISTS City;

--
-- Table structure for table `City`
--

CREATE TABLE `City` (
  `cityId` int(11) NOT NULL auto_increment,
  `name` varchar(60) default NULL,
  `country` varchar(60) default NULL,
  `population` int(11) default NULL,
  PRIMARY KEY  (`cityId`)
) ENGINE = InnoDB;

--
-- Inserting data into table `City`
--

INSERT INTO `City` (`name`, `country`, `population`) VALUES('Auckland', 'New Zealand', 1000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Wellington', 'New Zealand', 390000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Christchurch', 'New Zealand', 375000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Sydney', 'Australia', 4600000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Melbourne', 'Australia', 3900000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Adelaide', 'Australia', 1200000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Brisbane', 'Australia', 2000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Perth', 'Australia', 1700000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Mumbai', 'India', 13000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('New Delhi', 'India', 295000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Beijing', 'China', 22000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Shanghai', 'China', 17000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Tokyo', 'Japan', 13000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Osaka', 'Japan', 2600000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Los Angeles', 'USA', 4000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('New York City', 'USA', 8400000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('London', 'UK', 7500000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Moscow', 'Russia', 10500000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Lagos', 'Nigeria', 8000000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Paris', 'France', 2200000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Rome', 'Italy', 2800000);
INSERT INTO `City` (`name`, `country`, `population`) VALUES('Singapore', 'Singapore', 4400000);

SET foreign_key_checks = 1;