-- Add "pending" as valid task status
--
-- Migration: 019_add_pending_status
-- Purpose: Add "pending" status to support tasks awaiting approval/dependencies
--
-- Status meanings:
--   - pending: Created, awaiting approval or dependencies
--   - open: Approved and ready to start
--   - in_progress: Currently being worked on
--   - testing: Implementation complete, being tested
--   - blocked: Stuck waiting for something
--   - completed: Done
--
-- Related: MCP error when trying to set status="pending"

-- Drop existing constraint
ALTER TABLE tasks DROP CONSTRAINT IF EXISTS tasks_status_check;

-- Add new constraint with pending status
ALTER TABLE tasks ADD CONSTRAINT tasks_status_check
    CHECK (status IN ('pending', 'open', 'in_progress', 'testing', 'blocked', 'completed'));