Subversion Repositories SmartDukaan

-- Map an internal PO to the transaction/order it creates.
-- Populated only for internal POs (supplier.internal = true) via PurchaseOrderServiceImpl.createOrderInternally.
-- Used to block warehouse changes on orders whose transaction is mapped to a PO.
ALTER TABLE warehouse.purchaseorder
    ADD COLUMN transactionId INT NULL;

-- Lookup is order.transactionId -> purchaseorder.transactionId (selectByTransactionId).
CREATE INDEX idx_purchaseorder_transactionId ON warehouse.purchaseorder (transactionId);