Subversion Repositories SmartDukaan

-- Drops warehouse.purchaseorder.reopenedAt (added by add_po_reopened_at_20260918.sql).
-- Movement POs no longer auto-close, so nothing needs a reopen clock; the entity no longer maps the column.
-- Run ONLY AFTER the dao/fofo/cron builds without the mapping are deployed: the currently deployed builds still
-- map the column and would fail every purchaseorder read if it were dropped first.
-- MySQL 5.7: DROP COLUMN rebuilds the table (~54k rows, small). INPLACE keeps it online.
ALTER TABLE warehouse.purchaseorder DROP COLUMN reopenedAt, ALGORITHM=INPLACE, LOCK=NONE;