/*
Countries MySQL 
Sean Walther
http://www.seangw.com/wordpress/
*/

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` char(40) NOT NULL,
  `code` char(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of states
-- ----------------------------
INSERT INTO states VALUES ('1', 'Alaska', 'AK');
INSERT INTO states VALUES ('2', 'Alabama', 'AL');
INSERT INTO states VALUES ('3', 'American Samoa', 'AS');
INSERT INTO states VALUES ('4', 'Arizona', 'AZ');
INSERT INTO states VALUES ('5', 'Arkansas', 'AR');
INSERT INTO states VALUES ('6', 'California', 'CA');
INSERT INTO states VALUES ('7', 'Colorado', 'CO');
INSERT INTO states VALUES ('8', 'Connecticut', 'CT');
INSERT INTO states VALUES ('9', 'Delaware', 'DE');
INSERT INTO states VALUES ('10', 'District of Columbia', 'DC');
INSERT INTO states VALUES ('11', 'Federated States of Micronesia', 'FM');
INSERT INTO states VALUES ('12', 'Florida', 'FL');
INSERT INTO states VALUES ('13', 'Georgia', 'GA');
INSERT INTO states VALUES ('14', 'Guam', 'GU');
INSERT INTO states VALUES ('15', 'Hawaii', 'HI');
INSERT INTO states VALUES ('16', 'Idaho', 'ID');
INSERT INTO states VALUES ('17', 'Illinois', 'IL');
INSERT INTO states VALUES ('18', 'Indiana', 'IN');
INSERT INTO states VALUES ('19', 'Iowa', 'IA');
INSERT INTO states VALUES ('20', 'Kansas', 'KS');
INSERT INTO states VALUES ('21', 'Kentucky', 'KY');
INSERT INTO states VALUES ('22', 'Louisiana', 'LA');
INSERT INTO states VALUES ('23', 'Maine', 'ME');
INSERT INTO states VALUES ('24', 'Marshall Islands', 'MH');
INSERT INTO states VALUES ('25', 'Maryland', 'MD');
INSERT INTO states VALUES ('26', 'Massachusetts', 'MA');
INSERT INTO states VALUES ('27', 'Michigan', 'MI');
INSERT INTO states VALUES ('28', 'Minnesota', 'MN');
INSERT INTO states VALUES ('29', 'Mississippi', 'MS');
INSERT INTO states VALUES ('30', 'Missouri', 'MO');
INSERT INTO states VALUES ('31', 'Montana', 'MT');
INSERT INTO states VALUES ('32', 'Nebraska', 'NE');
INSERT INTO states VALUES ('33', 'Nevada', 'NV');
INSERT INTO states VALUES ('34', 'New Hampshire', 'NH');
INSERT INTO states VALUES ('35', 'New Jersey', 'NJ');
INSERT INTO states VALUES ('36', 'New Mexico', 'NM');
INSERT INTO states VALUES ('37', 'New York', 'NY');
INSERT INTO states VALUES ('38', 'North Carolina', 'NC');
INSERT INTO states VALUES ('39', 'North Dakota', 'ND');
INSERT INTO states VALUES ('40', 'Northern Mariana Islands', 'MP');
INSERT INTO states VALUES ('41', 'Ohio', 'OH');
INSERT INTO states VALUES ('42', 'Oklahoma', 'OK');
INSERT INTO states VALUES ('43', 'Oregon', 'OR');
INSERT INTO states VALUES ('44', 'Palau', 'PW');
INSERT INTO states VALUES ('45', 'Pennsylvania', 'PA');
INSERT INTO states VALUES ('46', 'Puerto Rico', 'PR');
INSERT INTO states VALUES ('47', 'Rhode Island', 'RI');
INSERT INTO states VALUES ('48', 'South Carolina', 'SC');
INSERT INTO states VALUES ('49', 'South Dakota', 'SD');
INSERT INTO states VALUES ('50', 'Tennessee', 'TN');
INSERT INTO states VALUES ('51', 'Texas', 'TX');
INSERT INTO states VALUES ('52', 'Utah', 'UT');
INSERT INTO states VALUES ('53', 'Vermont', 'VT');
INSERT INTO states VALUES ('54', 'Virgin Islands', 'VI');
INSERT INTO states VALUES ('55', 'Virginia', 'VA');
INSERT INTO states VALUES ('56', 'Washington', 'WA');
INSERT INTO states VALUES ('57', 'West Virginia', 'WV');
INSERT INTO states VALUES ('58', 'Wisconsin', 'WI');
INSERT INTO states VALUES ('59', 'Wyoming', 'WY');
INSERT INTO states VALUES ('60', 'Armed Forces Africa', 'AE');
INSERT INTO states VALUES ('61', 'Armed Forces Americas (except Canada)', 'AA');
INSERT INTO states VALUES ('62', 'Armed Forces Canada', 'AE');
INSERT INTO states VALUES ('63', 'Armed Forces Europe', 'AE');
INSERT INTO states VALUES ('64', 'Armed Forces Middle East', 'AE');
INSERT INTO states VALUES ('65', 'Armed Forces Pacific', 'AP');