Subversion Repositories SmartDukaan

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