-- Add file attachment support to chat_messages table

ALTER TABLE chat_messages 
ADD COLUMN file_path VARCHAR(255) NULL AFTER message,
ADD COLUMN file_name VARCHAR(255) NULL AFTER file_path,
ADD COLUMN file_type VARCHAR(100) NULL AFTER file_name,
ADD COLUMN file_size INT NULL AFTER file_type;