-- Restore script for write-off MOHIT-INV-2026-08-31 (generated Mon Aug 31 08:35:53 PM PDT 2026)
UPDATE stocks SET quantity=1, updated_at='2025-10-10 23:38:26' WHERE id=3480;  -- REPT461128 @ loc 153
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6718;  -- 312-1430L-AC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6719;  -- 312-1430R-AC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6720;  -- 314-2910R-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6721;  -- 315-2906L-US @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6722;  -- 317-2509L-UD @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6723;  -- 317-2927L-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6724;  -- 334-2505L-UD @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6725;  -- 341-1415R-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6726;  -- 341-2902L-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6727;  -- 344-1427L-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6728;  -- 344-1427R-UC @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6729;  -- 344-1429L-US @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6730;  -- 344-1429R-US @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6731;  -- GM179GR @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6732;  -- MC1216100 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6733;  -- MZ125GL @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6734;  -- NI1042122 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6735;  -- RC22370027 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6736;  -- RC76790002 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6737;  -- RK76350015 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6738;  -- RN01730001 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6739;  -- RT10990007 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6740;  -- RV10860004 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6741;  -- TO1033124 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6742;  -- TO1039278 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:19' WHERE id=6743;  -- TO1042154 @ loc 202
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:18' WHERE id=5215;  -- P13528 @ loc 204
UPDATE stocks SET quantity=1, updated_at='2026-08-18 01:50:18' WHERE id=5145;  -- RF07580036Q @ loc 206
-- also delete the history rows this write-off created:
-- DELETE FROM stock_history WHERE reference_id='MOHIT-INV-2026-08-31';