Files
roast_command_center/db/migrations/013_roast_observations.sql
snowspeeder 5f3a015ea2
Test and deploy / test-and-deploy (push) Successful in 1m43s
Fix report pagination and rebuild saved plan navigation
2026-09-05 15:47:44 -04:00

3 lines
200 B
SQL

ALTER TABLE actual_roasts ADD COLUMN IF NOT EXISTS observations jsonb NOT NULL DEFAULT '{}';
CREATE INDEX IF NOT EXISTS roast_plans_user_updated_idx ON roast_plans(user_id, updated_at DESC, id DESC);