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;