-- BMC's own asset purpose, separate from hardware type and rental status.
-- Existing assets remain unclassified; customer hardware is not reclassified.
ALTER TABLE hardware_assets
ADD COLUMN IF NOT EXISTS bmc_asset_category VARCHAR(20)
    CHECK (bmc_asset_category IN ('rental', 'internal'));