-- Migration: Add next_show_at field to tasks table
-- This script adds the next_show_at field for postponing tasks

-- ============================================
-- Add next_show_at column
-- ============================================
ALTER TABLE tasks 
ADD COLUMN IF NOT EXISTS next_show_at TIMESTAMP WITH TIME ZONE;

-- ============================================
-- Comments for documentation
-- ============================================
COMMENT ON COLUMN tasks.next_show_at IS 'Date when task should be shown again (NULL means use last_completed_at + period)';