Subversion Repositories SmartDukaan

-- NOTE ONLY - no SQL to run. Changes made on hadb1 on 2026-10-05 outside any Claude session (no script or backup kept
-- by whoever ran them), recorded so the history is complete.
--
-- 1. Franchise store remap, afternoon of 2026-10-05:
--      fofo.fofo_store.warehouse_id 7720 -> 13368, 7573 -> 13370, 9514 -> 13372 (FRANCHISE stores; INTERNAL stores kept).
--      After: 13368 = 292 franchise stores (91 active), 13370 = 69 (18), 13372 = 403 (244).
--
-- 2. Pending orders (status 3) moved to HR, same afternoon, with reservations
--    (transaction.order.warehouse_id + fulfilmentWarehouseId, inventory.currentreservationsnapshot,
--    inventory.currentinventorysnapshot.reserved). Verified consistent: each moved order's reservation row is on its new
--    fulfilment warehouse. Of the 112 orders listed in transaction._wh_move_plan_20261005:
--      7573 -> 13368: 29   7678 -> 13368: 2   7720 -> 13368: 2   9514 -> 13368: 22   9514 -> 13372: 57
--    Orders on internal movement POs were left on 7573/9514/10516 by choice (13 at the time).
--    transaction._bak_order_wh_move_20261005 / inventory._bak_crs_wh_move_20261005 / inventory._bak_cis_wh_move_20261005
--    are snapshots taken mid-move by a rolled-back attempt, not a clean "before".