zaGr7qC5

1
2CREATE TABLE IF NOT EXISTS `counties` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `name` varchar(200) NOT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;
7
8--
9-- Dumping data for table `counties`
10--
11
12INSERT INTO `counties` (`id`, `name`) VALUES
13(1, 'Broward'),
14(2, 'Palm Beach'),
15(3, 'Miami - Dade'),
16(4, 'Martin'),
17(5, 'Monroe'),
18(6, 'Charlotte'),
19(8, 'Lee'),
20(9, 'Hendry'),
21(10, 'Collier'),
22(11, 'Volusia'),
23(12, 'Brevard'),
24(13, 'Indian River'),
25(14, 'Okeechobee'),
26(15, 'St. Lucie'),
27(16, 'Citrus'),
28(17, 'Hernando'),
29(18, 'Pasco'),
30(19, 'Pinellas'),
31(20, 'Hillsborough'),
32(21, 'Manatee'),
33(22, 'Sarasota'),
34(23, 'DeSoto'),
35(24, 'Escambia'),
36(25, 'Okaloosa'),
37(26, 'Santa Rosa'),
38(27, 'Walton'),
39(28, 'Franklin'),
40(29, 'Gadsden'),
41(30, 'Leon'),
42(31, 'Liberty'),
43(32, 'Wakulla'),
44(33, 'Columbia'),
45(34, 'Dixie'),
46(35, 'Hamilton'),
47(36, 'Lafayette'),
48(37, 'Madison'),
49(38, 'Suwannee'),
50(39, 'Taylor'),
51(40, 'Clay'),
52(41, 'Duval'),
53(42, 'Nassau'),
54(43, 'Lake'),
55(44, 'Marion'),
56(45, 'Sumter'),
57(46, 'Flagler'),
58(47, 'Putnam'),
59(48, 'St. Johns'),
60(49, 'Alachua'),
61(50, 'Baker'),
62(51, 'Bradford'),
63(52, 'Gilchrist'),
64(53, 'Levy'),
65(54, 'Union'),
66(55, 'Orange'),
67(56, 'Osceola'),
68(57, 'Hardee'),
69(58, 'Highlands'),
70(59, 'Polk'),
71(61, 'Bay'),
72(62, 'Calhoun'),
73(63, 'Gulf'),
74(64, 'Holmes'),
75(65, 'Jackson'),
76(66, 'Washington'),
77(68, 'Seminole'),
78(69, 'Glades'),
79(70, 'Jefferson');