DROP TABLE IF EXISTS `wbstate`;
CREATE TABLE wbstate (
  stateid int(10) unsigned NOT NULL AUTO_INCREMENT,
  abbrev char(10) NOT NULL,
  title varchar(255) NOT NULL,
  country char(2) NOT NULL,
  PRIMARY KEY (stateid)
) AUTO_INCREMENT=10000 COMMENT='List of states for each country';

-- US
INSERT INTO wbstate VALUES
(101,'AL','Alabama','us'),
(102,'AK','Alaska','us'),
(103,'AZ','Arizona','us'),
(104,'AR','Arkansas','us'),
(105,'CA','California','us'),
(106,'CO','Colorado','us'),
(107,'CT','Connecticut','us'),
(108,'DE','Delaware','us'),
(109,'DC','District of Columbia','us'),
(110,'FL','Florida','us'),
(111,'GA','Georgia','us'),
(112,'HI','Hawaii','us'),
(113,'ID','Idaho','us'),
(114,'IL','Illinois','us'),
(115,'IN','Indiana','us'),
(116,'IA','Iowa','us'),
(117,'KS','Kansas','us'),
(118,'KY','Kentucky','us'),
(119,'LA','Louisiana','us'),
(120,'ME','Maine','us'),
(121,'MD','Maryland','us'),
(122,'MA','Massachusetts','us'),
(123,'MI','Michigan','us'),
(124,'MN','Minnesota','us'),
(125,'MS','Mississippi','us'),
(126,'MO','Missouri','us'),
(127,'MT','Montana','us'),
(128,'NE','Nebraska','us'),
(129,'NV','Nevada','us'),
(130,'NH','New Hampshire','us'),
(131,'NJ','New Jersey','us'),
(132,'NM','New Mexico','us'),
(133,'NY','New York','us'),
(134,'NC','North Carolina','us'),
(135,'ND','North Dakota','us'),
(136,'OH','Ohio','us'),
(137,'OK','Oklahoma','us'),
(138,'OR','Oregon','us'),
(139,'PA','Pennsylvania','us'),
(140,'RI','Rhode Island','us'),
(141,'SC','South Carolina','us'),
(142,'SD','South Dakota','us'),
(143,'TN','Tennessee','us'),
(144,'TX','Texas','us'),
(145,'UT','Utah','us'),
(146,'VT','Vermont','us'),
(147,'VA','Virginia','us'),
(148,'WA','Washington','us'),
(149,'WV','West Virginia','us'),
(150,'WI','Wisconsin','us'),
(151,'WY','Wyoming','us');

-- Canada
INSERT INTO wbstate VALUES
(201,'AB','Alberta','ca'),
(202,'BC','British Columbia','ca'),
(203,'MB','Manitoba','ca'),
(204,'NB','New Brunswick','ca'),
(205,'NF','Newfoundland','ca'),
(206,'NT','Northwest Territories','ca'),
(207,'NS','Nova Scotia','ca'),
(208,'ON','Ontario','ca'),
(209,'PE','Prince Edward Island','ca'),
(210,'PQ','Quebec','ca'),
(211,'SK','Saskatchewan','ca');

-- Australia
INSERT INTO wbstate VALUES
(251,'ACT','Australian Capital Territory','au'),
(252,'ACT','Jervis Bay Territory','au'),
(253,'NT','Northern Territory','au'),
(254,'NSW','New South Wale','au'),
(255,'SA','South Australia','au'),
(256,'TAS','Tasmania','au'),
(257,'VIC','Victoria','au'),
(258,'WA','Western Australia','au'),
(259,'','Ashmore and Cartier Islands','au'),
(260,'','Australian Antarctic Territory','au'),
(261,'WA','Christmas Island','au'),
(262,'WA','Cocos (Keeling) Islands','au'),
(263,'','Coral Sea Islands','au'),
(264,'','Heard Island and McDonald Islands','au'),
(265,'NSW','Norfolk Island','au'),
(266,'QLD','Queensland','au');

