--liquibase formatted sql
--changeset {patrick.thomlinson}:{71b3111d-10f2-44bc-8f26-38cf4deb2432}

CREATE TABLE `category_type` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(20) NOT NULL,
  `type` VARCHAR(20) CHARACTER SET 'utf8' NOT NULL,
  PRIMARY KEY (`id`));

INSERT INTO `category_type` (`category`,`type`) VALUES ('brokerage','brokerageAP');
INSERT INTO `category_type` (`category`,`type`) VALUES ('insurance','insuranceAP');
INSERT INTO `category_type` (`category`,`type`) VALUES ('base_freight','baseAP');
INSERT INTO `category_type` (`category`,`type`) VALUES ('fuel_surcharge','baseAP');