-- Add image_url column to chat_messages table
-- Run this SQL script to add the new column to existing database

ALTER TABLE chat_messages 
ADD COLUMN image_url VARCHAR(500) NULL;

-- Add comment to document the column purpose
COMMENT ON COLUMN chat_messages.image_url IS 'URL for generated images when message_type is image_response';
