-- Migration: Add message edit and hide options
ALTER TABLE support_messages ADD COLUMN is_hidden BOOLEAN DEFAULT FALSE;
ALTER TABLE support_messages ADD COLUMN is_edited BOOLEAN DEFAULT FALSE;
ALTER TABLE support_messages ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

ALTER TABLE chat_messages ADD COLUMN is_hidden BOOLEAN DEFAULT FALSE;
ALTER TABLE chat_messages ADD COLUMN is_edited BOOLEAN DEFAULT FALSE;
ALTER TABLE chat_messages ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
