--liquibase formatted sql

--changeset Joshua.Witt:158348ba-f0fc-404c-8aa5-4879282d6b33
CREATE TABLE `orders`(
  `id` INT NOT NULL AUTO_INCREMENT,
  `corporate_id` VARCHAR(45) NOT NULL,
  `group_id` VARCHAR(45) NULL,
  `location_id` VARCHAR(45) NULL,
  `carrier_code` VARCHAR(45) NULL,
  `total` INT NULL,
  `chksum` VARCHAR(45) NULL,
  `origin_postal_code` VARCHAR(45) NULL,
  `destination_postal_code` VARCHAR(45) NULL,
  `sw_number` VARCHAR(45) NOT NULL,
  `rlms_number` VARCHAR(45) NULL,
  `shipment_type` VARCHAR(45) NULL,
  `is_manual` VARCHAR(45) NULL,
  `status` VARCHAR(45) NULL,
  `order_date` DATETIME NULL,
  PRIMARY KEY (`id`,`sw_number`));
--rollback drop table orders;
