-- v0.20: pantry categories + price tracking

ALTER TABLE "Item"
  ADD COLUMN "pantryCategory"    TEXT,
  ADD COLUMN "pantrySubcategory" TEXT,
  ADD COLUMN "pricePaid"         DECIMAL(10,2),
  ADD COLUMN "priceUnit"         TEXT;

CREATE INDEX "Item_pantryCategory_idx" ON "Item"("pantryCategory");