-- Add is_active column to todo_task table
-- Allows administrators to enable/disable tasks without deleting them
ALTER TABLE todo_task ADD COLUMN is_active TINYINT(1) NOT NULL DEFAULT 1 COMMENT 'Whether the task is active and visible to employees' AFTER requires_photo;

CREATE INDEX idx_todo_task_is_active ON todo_task (is_active);
