SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `states` (
  `id` int(11) NOT NULL auto_increment,
  `code` char(2) NOT NULL,
  `name` char(40) NOT NULL,
  PRIMARY KEY  (`id`)
);

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