-- Migration: Replace project description with goal_text for better AI intelligence
-- This improves project creation by asking for actionable goals instead of generic descriptions

-- Rename description column to goal_text to better reflect its purpose
ALTER TABLE projects CHANGE COLUMN description goal_text TEXT;

-- Add comment for clarity
ALTER TABLE projects MODIFY COLUMN goal_text TEXT COMMENT 'Main project goal - what the project aims to achieve';