-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 22, 2013 at 07:10 AM
-- Server version: 5.5.29
-- PHP Version: 5.4.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `country_state`
--

DELIMITER $$
--
-- Procedures
--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `CNAME` varchar(100) NOT NULL,
  `CCAPITAL` varchar(100) NOT NULL,
  `CAREA` bigint(20) NOT NULL,
  `CPOPULATION` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`CNAME`, `CCAPITAL`, `CAREA`, `CPOPULATION`) VALUES
('Australia', 'Canberra', 7692024, 23000000),
('Tuvalu', 'Funafuti', 26, 10544);

-- --------------------------------------------------------

--
-- Table structure for table `entity`
--

CREATE TABLE `entity` (
  `CNAME` varchar(100) NOT NULL,
  `TYPE` varchar(100) NOT NULL,
  `NAME` varchar(100) NOT NULL,
  `CAPITAL` varchar(100) NOT NULL,
  `AREA` bigint(20) NOT NULL,
  `POPULATION` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `entity`
--

INSERT INTO `entity` (`CNAME`, `TYPE`, `NAME`, `CAPITAL`, `AREA`, `POPULATION`) VALUES
('Australia', 'STATE', 'West Australia', 'Perth', 2529875, 2296411),
('Australia', 'STATE', 'South Australia', 'Adelaide', 983482, 1644642),
('Australia', 'STATE', 'New South Wales', 'Sydney', 800642, 7238819),
('Australia', 'STATE', 'Victoria', 'Melbourne', 227416, 5603100),
('Australia', 'STATE', 'Queensland', 'Brisbane', 1730648, 4516361),
('Australia', 'STATE', 'Tasmania', 'Hobart', 68401, 507626),
('Australia', 'TERRITORY', 'Northern Territory', 'Darwin', 1349129, 229675),
('Australia', 'TERRITORY', 'Australian Capital Territory', 'Canberra', 2358, 358894),
('Australia', 'TERRITORY', 'Jervis Bay Territory', 'Jervis Bay Village', 70, 611),
('Australia', 'EXTERNAL', 'Ashmore and Cartier Islands', ' ', 199, 0),
('Australia', 'EXTERNAL', 'Australian Antarctic Territory', 'Mawson Station', 5896500, 1000),
('Australia', 'EXTERNAL', 'Christmas Island', 'Flying Fish Cove', 135, 1493),
('Australia', 'EXTERNAL', 'Cocos (Keeling) Islands', 'West Island', 14, 628),
('Australia', 'EXTERNAL', 'Coral Sea Islands', 'Willis Island', 10, 4),
('Australia', 'EXTERNAL', 'Heard Island and McDonald Islands', 'Atlas Cove', 372, 0),
('Australia', 'EXTERNAL', 'Norfolk Island', 'Kingston', 35, 2114);