Subversion Repositories SmartDukaan

Rev

Blame | Last modification | View Log | RSS feed

-- Adds approver tracking to HID allocation requests.
-- requested_allocation now represents an ADDITIONAL one-time qty (over and above current stock),
-- approved via the FOFO "Requested Allocations" edit screen; created_by = requestor, approved_by = approver.
ALTER TABLE fofo.requested_hid_allocation
    ADD COLUMN approved_by VARCHAR(255) NULL AFTER updated_at;