-- liquibase formatted sql

-- changeset cyril:update purchase order

ALTER TABLE `purchase_order`
    ADD COLUMN `shopId` INT NULL AFTER `supplierId`,
    ADD CONSTRAINT `FK_PURCHASE_ORDER_ON_SHOPID`
        FOREIGN KEY (`shopId`)
            REFERENCES `shop` (`id`);