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, and code that does not know the column
-- ignores it - so this runs safely BEFORE the release that maps it, and must, because the entity maps it.
--
-- hadb1 is MySQL 5.7, which has no INSTANT add-column, so this rebuilds the table rather than only touching
-- metadata. ~53k rows, seconds. ALGORITHM/LOCK are stated so it fails loudly rather than quietly taking a
-- table lock if that ever stops being true.
ALTER TABLE warehouse.purchaseorder
    ADD COLUMN reopenedAt DATETIME NULL COMMENT 'When this PO was last reopened; POScheduler ages from this when set',
    ALGORITHM=INPLACE, LOCK=NONE;