--liquibase formatted sql
--changeset patrick.thomlinson:add-states

CREATE TABLE IF NOT EXISTS `states` (
	`id` INT NOT NULL AUTO_INCREMENT,
    `country` VARCHAR(2),
    `name` VARCHAR(25),
    `code` VARCHAR(2),
    `region` VARCHAR(7),
    `shipper` VARCHAR(6),
	`last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

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