Subversion Repositories SmartDukaan

Rev

Blame | Last modification | View Log | RSS feed 

-- Address masters can be retired: only active ones are offered when a warehouse is created or remapped.
-- Existing mappings keep printing whatever address they point to, active or not.
-- Must be applied BEFORE deploying the matching dao (WarehouseAddressMaster.active is mapped).
-- 25 rows; MySQL 5.7 rebuilds the table, which is instant at this size. APPLIED on hadb1 2026-10-01.

ALTER TABLE transaction.warehouseaddressmaster
  ADD COLUMN active TINYINT(1) NOT NULL DEFAULT 1,
  ALGORITHM=INPLACE, LOCK=NONE;

-- verify
SELECT active, COUNT(*) FROM transaction.warehouseaddressmaster GROUP BY active;