-- Add category (enum) and subcategory (free text) to inventory items
ALTER TABLE app.inventory_item
  ADD COLUMN category TEXT NOT NULL DEFAULT 'operations',
  ADD COLUMN subcategory TEXT;

CREATE INDEX idx_inventory_item_category ON app.inventory_item(category);