-- Add soft delete columns to messages table
ALTER TABLE messages
    ADD COLUMN deleted_by_sender BOOLEAN DEFAULT FALSE,
    ADD COLUMN deleted_by_receiver BOOLEAN DEFAULT FALSE;

-- Create indexes for better query performance
CREATE INDEX idx_messages_deleted_by_sender ON messages (deleted_by_sender);
CREATE INDEX idx_messages_deleted_by_receiver ON messages (deleted_by_receiver);

