xjvvtyZE

1--
2-- Database: `testing`
3--
4
5-- --------------------------------------------------------
6
7--
8-- Table structure for table `country_state_city`
9--
10
11CREATE TABLE IF NOT EXISTS `country_state_city` (
12  `id` int(11) NOT NULL,
13  `country` varchar(250) NOT NULL,
14  `state` varchar(250) NOT NULL,
15  `city` varchar(250) NOT NULL
16) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
17
18--
19-- Dumping data for table `country_state_city`
20--
21
22INSERT INTO `country_state_city` (`id`, `country`, `state`, `city`) VALUES
23(1, 'USA', 'New York', 'New York city'),
24(2, 'USA', 'New York', 'Buffalo'),
25(3, 'USA', 'New York', 'Albany'),
26(4, 'USA', 'Alabama', 'Birmingham'),
27(5, 'USA', 'Alabama', 'Montgomery'),
28(6, 'USA', 'Alabama', 'Huntsville'),
29(7, 'USA', 'California', 'Los Angeles'),
30(8, 'USA', 'California', 'San Francisco'),
31(9, 'USA', 'California', 'San Diego'),
32(10, 'Canada', 'Ontario', 'Toronto'),
33(11, 'Canada', 'Ontario', 'Ottawa'),
34(12, 'Canada', 'British Columbia', 'Vancouver'),
35(13, 'Canada', 'British Columbia', 'Victoria'),
36(14, 'Australia', 'New South Wales', 'Sydney'),
37(15, 'Australia', 'New South Wales', 'Newcastle'),
38(16, 'Australia', 'Queensland', 'City of Brisbane'),
39(17, 'Australia', 'Queensland', 'Gold Coast\r\n');
40
41--
42-- Indexes for dumped tables
43--
44
45--
46-- Indexes for table `country_state_city`
47--
48ALTER TABLE `country_state_city`
49  ADD PRIMARY KEY (`id`);
50
51--
52-- AUTO_INCREMENT for dumped tables
53--
54
55--
56-- AUTO_INCREMENT for table `country_state_city`
57--
58ALTER TABLE `country_state_city`
59  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;