| 37853 |
amit |
1 |
-- RECORD ONLY - applied on hadb1 2026-10-05. Do not re-run (the backup table already exists).
|
|
|
2 |
-- The last 3 franchise stores on UP-WEST/NOIDA (7678, suspended) move to HR-NSSPL/UPW (13372), like the other UP-West
|
|
|
3 |
-- stores, so no new order lands on a suspended warehouse. Internal stores stay on their warehouse on purpose.
|
|
|
4 |
CREATE TABLE fofo._bak_fofo_store_wh_20261005 AS
|
|
|
5 |
SELECT id, code, warehouse_id FROM fofo.fofo_store WHERE id IN (175140546, 175140548, 175140555);
|
|
|
6 |
UPDATE fofo.fofo_store SET warehouse_id = 13372
|
|
|
7 |
WHERE id IN (175140546, 175140548, 175140555) -- UPBSR1697, UPAMH1699, UPHPR1704
|
|
|
8 |
AND warehouse_id = 7678 AND fofo_type = 'FRANCHISE';
|