/*
 Navicat Premium Data Transfer

 Source Server         : lwtdev.com
 Source Server Type    : MySQL
 Source Server Version : 50045
 Source Host           : lwtdev.com
 Source Database       : alacomp

 Target Server Type    : MySQL
 Target Server Version : 50045
 File Encoding         : utf-8

 Date: 02/01/2010 16:16:36 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `counties`
-- ----------------------------
DROP TABLE IF EXISTS `counties`;
CREATE TABLE `counties` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `counties`
-- ----------------------------
INSERT INTO `counties` VALUES ('0', '-select-'), ('1', 'Autauga'), ('2', 'Baldwin'), ('3', 'Barbour'), ('4', 'Bibb'), ('5', 'Bullock'), ('6', 'Butler'), ('7', 'Calhoun'), ('8', 'Chambers'), ('9', 'Cherokee'), ('10', 'Chilton'), ('11', 'Choctaw'), ('12', 'Clarke'), ('13', 'Clay'), ('14', 'Cleburne'), ('15', 'Coffee'), ('16', 'Colbert'), ('17', 'Coosa'), ('18', 'Cullman'), ('19', 'Dale'), ('20', 'Dallas'), ('21', 'Dekalb'), ('22', 'Elmore'), ('23', 'Escambia'), ('24', 'Etowah'), ('25', 'Fayette'), ('26', 'Geneva'), ('27', 'Hale'), ('28', 'Henry'), ('29', 'Houston'), ('30', 'Jackson'), ('31', 'Jefferson'), ('32', 'Lamar'), ('33', 'Lauderdale'), ('34', 'Lawrence'), ('35', 'Lee'), ('36', 'Limestone'), ('37', 'Lowndes'), ('38', 'Madison'), ('39', 'Marion'), ('40', 'Marshall'), ('41', 'Monroe'), ('42', 'Montgomery'), ('43', 'Morgan'), ('44', 'Pickens'), ('45', 'Randolph'), ('46', 'Shelby'), ('47', 'St. Clair'), ('48', 'Sumter'), ('49', 'Tallapoosa'), ('50', 'Tuscaloosa'), ('51', 'Washington'), ('52', 'Winston'), ('105', 'Blount'), ('106', 'Covington'), ('107', 'Crenshaw'), ('108', 'Franklin'), ('109', 'Marengo'), ('110', 'Mobile'), ('111', 'Conecuh'), ('113', 'Greene'), ('114', 'Macon'), ('115', 'Perry'), ('116', 'Pike'), ('117', 'Russell'), ('118', 'Talladega'), ('119', 'Walker'), ('120', 'Wilcox');