-- Migrate hq_inventory.status ENUM
-- From: ('available','reserved','sold','shipped','written_off')
-- To:   ('available','shipped','wholesale','broken','locked')
--
-- As of 2026-04-17, production has only 'available' (762) and 'shipped' (20),
-- so no row remapping is needed.

ALTER TABLE hq_inventory
  MODIFY COLUMN status
  ENUM('available','shipped','wholesale','broken','locked')
  NOT NULL DEFAULT 'available';
