/*
 Navicat Premium Data Transfer


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

 Date: 02/01/2010 14:33:50 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

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

-- ----------------------------
--  Records of `states`
-- ----------------------------
INSERT INTO `states` VALUES ('0', '-select-', '-select-'), ('1', 'ALABAMA', 'AL'), ('2', 'ALASKA ', 'AK'), ('3', 'ARIZONA', 'AZ'), ('4', 'ARKANSAS', 'AR'), ('5', 'CALIFORNIA', 'CA'), ('6', 'COLORADO', 'CO'), ('7', 'CONNECTICUT', 'CT'), ('8', 'DELAWARE', 'DE'), ('9', 'DISTRICT OF COLUMBIA', 'DC'), ('10', 'FLORIDA', 'FL'), ('11', 'GEORGIA', 'GA'), ('12', 'HAWAII ', 'HI'), ('13', 'IDAHO', 'ID'), ('14', 'ILLINOIS', 'IL'), ('15', 'INDIANA', 'IN'), ('16', 'IOWA', 'IA'), ('17', 'KANSAS ', 'KS'), ('18', 'KENTUCKY', 'KY'), ('19', 'LOUISIANA', 'LA'), ('20', 'MAINE', 'ME'), ('21', 'MARYLAND', 'MD'), ('22', 'MASSACHUSETTS', 'MA'), ('23', 'MICHIGAN', 'MI'), ('24', 'MINNESOTA', 'MN'), ('25', 'MISSISSIPPI', 'MS'), ('26', 'MISSOURI', 'MO'), ('27', 'MONTANA', 'MT'), ('28', 'NEBRASKA', 'NE'), ('29', 'NEVADA ', 'NV'), ('30', 'NEW HAMPSHIRE', 'NH'), ('31', 'NEW JERSEY', 'NJ'), ('32', 'NEW MEXICO', 'NM'), ('33', 'NEW YORK', 'NY'), ('34', 'NORTH CAROLINA', 'NC'), ('35', 'NORTH DAKOTA', 'ND'), ('36', 'OHIO', 'OH'), ('37', 'OKLAHOMA', 'OK'), ('38', 'OREGON ', 'OR'), ('39', 'PENNSYLVANIA', 'PA'), ('40', 'PUERTO RICO', 'PR'), ('41', 'RHODE ISLAND', 'RI'), ('42', 'SOUTH CAROLINA', 'SC'), ('43', 'SOUTH DAKOTA', 'SD'), ('44', 'TENNESSEE', 'TN'), ('45', 'TEXAS', 'TX'), ('46', 'UTAH', 'UT'), ('47', 'VERMONT', 'VT'), ('48', 'U.S. VIRGIN ISLANDS', 'VI'), ('49', 'VIRGINIA', 'VA'), ('50', 'WASHINGTON', 'WA'), ('51', 'WEST VIRGINIA', 'WV'), ('52', 'WISCONSIN', 'WI'), ('53', 'WYOMING', 'WY');