
CREATE TABLE `state_list` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `state_name` varchar(255) DEFAULT NULL,
  `state_short_name` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`state_id`),
  KEY `state_name` (`state_name`),
  KEY `state_id` (`state_id`)
) ;



INSERT INTO `state_list` VALUES (1, 'Massachusetts', 'MA');
INSERT INTO `state_list` VALUES (2, 'Maine', 'ME');
INSERT INTO `state_list` VALUES (3, 'Rhode Island', 'RI');
INSERT INTO `state_list` VALUES (4, 'Vermont', 'VT');
INSERT INTO `state_list` VALUES (5, 'New Hampshire', 'NH');
INSERT INTO `state_list` VALUES (7, 'Connecticut', 'CT');
INSERT INTO `state_list` VALUES (8, 'Delaware', 'DE');
INSERT INTO `state_list` VALUES (10, 'Florida', 'FL');
INSERT INTO `state_list` VALUES (11, 'Georgia', 'GA');
INSERT INTO `state_list` VALUES (12, 'Hawaii', 'HI');
INSERT INTO `state_list` VALUES (13, 'Idaho', 'ID');
INSERT INTO `state_list` VALUES (14, 'Illinois', 'IL');
INSERT INTO `state_list` VALUES (15, 'Indiana', 'IN');
INSERT INTO `state_list` VALUES (16, 'Iowa', 'IA');
INSERT INTO `state_list` VALUES (17, 'Kansas', 'KS');
INSERT INTO `state_list` VALUES (18, 'Kentucky', 'KY');
INSERT INTO `state_list` VALUES (19, 'Louisiana', 'LA');
INSERT INTO `state_list` VALUES (21, 'Maryland', 'MD');
INSERT INTO `state_list` VALUES (23, 'Michigan', 'MI');
INSERT INTO `state_list` VALUES (24, 'Minnesota', 'MN');
INSERT INTO `state_list` VALUES (25, 'Mississippi', 'MS');
INSERT INTO `state_list` VALUES (26, 'Missouri', 'MO');
INSERT INTO `state_list` VALUES (27, 'Montana', 'MT');
INSERT INTO `state_list` VALUES (28, 'Nebraska', 'NE');
INSERT INTO `state_list` VALUES (29, 'Nevada', 'NV');
INSERT INTO `state_list` VALUES (31, 'New Jersey', 'NJ');
INSERT INTO `state_list` VALUES (32, 'New Mexico', 'NM');
INSERT INTO `state_list` VALUES (33, 'New York', 'NY');
INSERT INTO `state_list` VALUES (34, 'North Carolina', 'NC');
INSERT INTO `state_list` VALUES (35, 'North Dakota', 'ND');
INSERT INTO `state_list` VALUES (36, 'Ohio', 'OH');
INSERT INTO `state_list` VALUES (37, 'Oklahoma', 'OK');
INSERT INTO `state_list` VALUES (38, 'Oregon', 'OR');
INSERT INTO `state_list` VALUES (39, 'Pennsylvania', 'PA');
INSERT INTO `state_list` VALUES (41, 'South Carolina', 'SC');
INSERT INTO `state_list` VALUES (42, 'South Dakota', 'SD');
INSERT INTO `state_list` VALUES (43, 'Tennessee', 'TN');
INSERT INTO `state_list` VALUES (44, 'Texas', 'TX');
INSERT INTO `state_list` VALUES (45, 'Utah', 'UT');
INSERT INTO `state_list` VALUES (47, 'Virginia', 'VA');
INSERT INTO `state_list` VALUES (48, 'Washington', 'WA');
INSERT INTO `state_list` VALUES (49, 'West Virginia', 'WV');
INSERT INTO `state_list` VALUES (50, 'Wisconsin', 'WI');
INSERT INTO `state_list` VALUES (51, 'Wyoming', 'WY');
INSERT INTO `state_list` VALUES (71, 'Alabama', 'AL');
INSERT INTO `state_list` VALUES (72, 'Alaska', 'AK');
INSERT INTO `state_list` VALUES (73, 'Arizona', 'AZ');
INSERT INTO `state_list` VALUES (74, 'Arkansas', 'AR');
INSERT INTO `state_list` VALUES (75, 'California', 'CA');
INSERT INTO `state_list` VALUES (76, 'Colorado', 'CO');
INSERT INTO `state_list` VALUES (90, 'District of Columbia', 'DC');
INSERT INTO `state_list` VALUES (91, 'Puerto Rico', 'PR');
        