path: root/makima/migrations/20250122000000_add_task_hidden.sql

-- Add hidden column to tasks table for dismissing completed standalone tasks
ALTER TABLE tasks ADD COLUMN hidden BOOLEAN NOT NULL DEFAULT FALSE;

-- Create index for filtering hidden tasks efficiently
CREATE INDEX IF NOT EXISTS idx_tasks_hidden ON tasks(hidden) WHERE hidden = false;