-- 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;