diff options
Diffstat (limited to 'makima/migrations/20250122000000_add_task_hidden.sql')
| -rw-r--r-- | makima/migrations/20250122000000_add_task_hidden.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/makima/migrations/20250122000000_add_task_hidden.sql b/makima/migrations/20250122000000_add_task_hidden.sql new file mode 100644 index 0000000..42eed52 --- /dev/null +++ b/makima/migrations/20250122000000_add_task_hidden.sql @@ -0,0 +1,5 @@ +-- 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; |