10 lines
299 B
SQL
10 lines
299 B
SQL
-- 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");
|