-- migrate:up
CREATE TABLE `orders_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(50) NOT NULL,
  `old_zipcode` varchar(20) DEFAULT NULL,
  `new_zipcode` varchar(20) DEFAULT NULL,
  `old_sku` varchar(100) DEFAULT NULL,
  `new_sku` varchar(100) DEFAULT NULL,
  `changed_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- migrate:down
DROP TABLE IF EXISTS `orders_history`;