my-recipes/backend/add_is_pinned_column.sql
2025-12-11 15:51:54 +02:00

6 lines
180 B
SQL

-- Add is_pinned column to grocery_lists table
ALTER TABLE grocery_lists ADD COLUMN IF NOT EXISTS is_pinned BOOLEAN DEFAULT FALSE;
-- Verify the column was added
\d grocery_lists