| 37822 |
amit |
1 |
-- Address masters can be retired: only active ones are offered when a warehouse is created or remapped.
|
|
|
2 |
-- Existing mappings keep printing whatever address they point to, active or not.
|
|
|
3 |
-- Must be applied BEFORE deploying the matching dao (WarehouseAddressMaster.active is mapped).
|
|
|
4 |
-- 25 rows; MySQL 5.7 rebuilds the table, which is instant at this size. APPLIED on hadb1 2026-10-01.
|
|
|
5 |
|
|
|
6 |
ALTER TABLE transaction.warehouseaddressmaster
|
|
|
7 |
ADD COLUMN active TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
8 |
ALGORITHM=INPLACE, LOCK=NONE;
|
|
|
9 |
|
|
|
10 |
-- verify
|
|
|
11 |
SELECT active, COUNT(*) FROM transaction.warehouseaddressmaster GROUP BY active;
|