/*
Free list of US and Canada state codes in SQL format provided by Mad Capsule Media
http://www.madcapsule.com
This file was created on November 19th, 2011.
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `states` */

DROP TABLE IF EXISTS `states`;

CREATE TABLE `states` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(2) default NULL,
  `state` varchar(150) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;

/*Data for the table `states` */

insert  into `states`(`id`,`code`,`state`) values (1,'OT','Outside US/Canada'),(2,'AL','Alabama'),(3,'AK','Alaska'),(4,'AZ','Arizona'),(5,'AR','Arkansas'),(6,'CA','California'),(7,'CO','Colorado'),(8,'CT','Connecticut'),(9,'DE','Delaware'),(10,'DC','District of Columbia'),(11,'FL','Florida'),(12,'GA','Georgia'),(13,'HI','Hawaii'),(14,'ID','Idaho'),(15,'IL','Illinois'),(16,'IN','Indiana'),(17,'IA','Iowa'),(18,'KS','Kansas'),(19,'KY','Kentucky'),(20,'LA','Louisiana'),(21,'ME','Maine'),(22,'MT','Montana'),(23,'NE','Nebraska'),(24,'NV','Nevada'),(25,'NH','New Hampshire'),(26,'NJ','New Jersey'),(27,'NM','New Mexico'),(28,'NY','New York'),(29,'NC','North Carolina'),(30,'ND','North Dakota'),(31,'OH','Ohio'),(32,'OK','Oklahoma'),(33,'OR','Oregon'),(34,'MD','Maryland'),(35,'MA','Massachusetts'),(36,'MI','Michigan'),(37,'MN','Minnesota'),(38,'MS','Mississippi'),(39,'MO','Missouri'),(40,'PA','Pennsylvania'),(41,'RI','Rhode Island'),(42,'SC','South Carolina'),(43,'SD','South Dakota'),(44,'TN','Tennessee'),(45,'TX','Texas'),(46,'UT','Utah'),(47,'VT','Vermont'),(48,'VA','Virginia'),(49,'WA','Washington'),(50,'WV','West Virginia'),(51,'WI','Wisconsin'),(52,'WY','Wyoming'),(53,'AB','Alberta'),(54,'BC','British Columbia'),(55,'MB','Manitoba'),(56,'NB','New Brunswick'),(57,'NL','Newfoundland and Labrador'),(58,'NS','Nova Scotia'),(59,'NU','Nunavut'),(60,'ON','Ontario'),(61,'PE','Prince Edward Island'),(62,'QC','Quebec'),(63,'SK','Saskatchewan'),(64,'YT','Yukon'),(65,'NT','Northwest Territories');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;