Subversion Repositories SmartDukaan

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
36910 amit 1 
-- Map an internal PO to the transaction/order it creates.
2 
-- Populated only for internal POs (supplier.internal = true) via PurchaseOrderServiceImpl.createOrderInternally.
3 
-- Used to block warehouse changes on orders whose transaction is mapped to a PO.
4 
ALTER TABLE warehouse.purchaseorder
5 
    ADD COLUMN transactionId INT NULL;
6 
 
7 
-- Lookup is order.transactionId -> purchaseorder.transactionId (selectByTransactionId).
8 
CREATE INDEX idx_purchaseorder_transactionId ON warehouse.purchaseorder (transactionId);