--liquibase formatted sql

--changeset cyril:update purchase order line

ALTER TABLE `purchase_order_line`
    CHANGE COLUMN `priceUnit` `currencyId` INT NULL DEFAULT NULL,
    ADD CONSTRAINT `FK_PURCHASE_ORDER_LINE_ON_UOMID` FOREIGN KEY (`uomId`) REFERENCES `uom_conversion` (`id`),
    ADD CONSTRAINT `FK_PURCHASE_ORDER_LINE_ON_CURRENCYID` FOREIGN KEY (`currencyId`) REFERENCES `currency` (`id`);