Subversion Repositories SmartDukaan

-- Reopening a delayed internal movement PO.
--
-- POScheduler ages a purchase order off createdAt, and createdAt is the PO date - so a PO reopened after the
-- auto-close window is immediately older than the window again and the next tick closes it straight back. This
-- column records when a PO was reopened; the scheduler ages off that instead when it is set, giving a reopened PO
-- the same fresh window a new one gets.
--
-- Additive and nullable: existing rows keep behaving exactly as before.
ALTER TABLE warehouse.purchaseorder
    ADD COLUMN reopenedAt DATETIME NULL COMMENT 'When this PO was last reopened; POScheduler ages from this when set';