DROP TABLE IF EXISTS `tblstates`;

CREATE TABLE `tblstates` (
  `state_code` char(2) NOT NULL default '',
  `state_name` varchar(50) default NULL,
  PRIMARY KEY  (`state_code`),
  UNIQUE KEY `state_code` (`state_code`)
) TYPE=MyISAM;

/*Data for the table `tblstates` */

insert into `tblstates` (`state_code`,`state_name`) values ('AK','Alaska');
insert into `tblstates` (`state_code`,`state_name`) values ('AL','Alabama');
insert into `tblstates` (`state_code`,`state_name`) values ('AR','Arkansas');
insert into `tblstates` (`state_code`,`state_name`) values ('AZ','Arizona');
insert into `tblstates` (`state_code`,`state_name`) values ('CA','California');
insert into `tblstates` (`state_code`,`state_name`) values ('CO','Colorado');
insert into `tblstates` (`state_code`,`state_name`) values ('CT','Connecticut');
insert into `tblstates` (`state_code`,`state_name`) values ('DC','District of Columbia');
insert into `tblstates` (`state_code`,`state_name`) values ('DE','Delaware');
insert into `tblstates` (`state_code`,`state_name`) values ('FL','Florida');
insert into `tblstates` (`state_code`,`state_name`) values ('GA','Georgia');
insert into `tblstates` (`state_code`,`state_name`) values ('HI','Hawaii');
insert into `tblstates` (`state_code`,`state_name`) values ('IA','Iowa');
insert into `tblstates` (`state_code`,`state_name`) values ('ID','Idaho');
insert into `tblstates` (`state_code`,`state_name`) values ('IL','Illinois');
insert into `tblstates` (`state_code`,`state_name`) values ('IN','Indiana');
insert into `tblstates` (`state_code`,`state_name`) values ('KS','Kansas');
insert into `tblstates` (`state_code`,`state_name`) values ('KY','Kentucky');
insert into `tblstates` (`state_code`,`state_name`) values ('LA','Louisiana');
insert into `tblstates` (`state_code`,`state_name`) values ('MA','Massachusetts');
insert into `tblstates` (`state_code`,`state_name`) values ('MD','Maryland');
insert into `tblstates` (`state_code`,`state_name`) values ('ME','Maine');
insert into `tblstates` (`state_code`,`state_name`) values ('MI','Michigan');
insert into `tblstates` (`state_code`,`state_name`) values ('MN','Minnesota');
insert into `tblstates` (`state_code`,`state_name`) values ('MO','Missouri');
insert into `tblstates` (`state_code`,`state_name`) values ('MS','Mississippi');
insert into `tblstates` (`state_code`,`state_name`) values ('MT','Montana');
insert into `tblstates` (`state_code`,`state_name`) values ('NA','N/A - Outside U.S.');
insert into `tblstates` (`state_code`,`state_name`) values ('NC','North Carolina');
insert into `tblstates` (`state_code`,`state_name`) values ('ND','North Dakota');
insert into `tblstates` (`state_code`,`state_name`) values ('NE','Nebraska');
insert into `tblstates` (`state_code`,`state_name`) values ('NH','New Hampshire');
insert into `tblstates` (`state_code`,`state_name`) values ('NJ','New Jersey');
insert into `tblstates` (`state_code`,`state_name`) values ('NM','New Mexico');
insert into `tblstates` (`state_code`,`state_name`) values ('NV','Nevada');
insert into `tblstates` (`state_code`,`state_name`) values ('NY','New York');
insert into `tblstates` (`state_code`,`state_name`) values ('OH','Ohio');
insert into `tblstates` (`state_code`,`state_name`) values ('OK','Oklahoma');
insert into `tblstates` (`state_code`,`state_name`) values ('OR','Oregon');
insert into `tblstates` (`state_code`,`state_name`) values ('PA','Pennsylvania');
insert into `tblstates` (`state_code`,`state_name`) values ('RI','Rhode Island');
insert into `tblstates` (`state_code`,`state_name`) values ('SC','South Carolina');
insert into `tblstates` (`state_code`,`state_name`) values ('SD','South Dakota');
insert into `tblstates` (`state_code`,`state_name`) values ('TN','Tennessee');
insert into `tblstates` (`state_code`,`state_name`) values ('TX','Texas');
insert into `tblstates` (`state_code`,`state_name`) values ('UT','Utah');
insert into `tblstates` (`state_code`,`state_name`) values ('VA','Virginia');
insert into `tblstates` (`state_code`,`state_name`) values ('VT','Vermont');
insert into `tblstates` (`state_code`,`state_name`) values ('WA','Washington');
insert into `tblstates` (`state_code`,`state_name`) values ('WI','Wisconsin');
insert into `tblstates` (`state_code`,`state_name`) values ('WV','West Virginia');
insert into `tblstates` (`state_code`,`state_name`) values ('WY','Wyoming');