-- Sentiment columns on bot_contacts (run once in phpMyAdmin, DB lzgqnjwu_bot)

ALTER TABLE bot_contacts
    ADD COLUMN atmosphere_score TINYINT UNSIGNED NULL DEFAULT NULL AFTER telegram_blocked,
    ADD COLUMN satisfaction_score TINYINT UNSIGNED NULL DEFAULT NULL AFTER atmosphere_score,
    ADD COLUMN sentiment_flags VARCHAR(500) NULL DEFAULT NULL AFTER satisfaction_score,
    ADD COLUMN sentiment_summary TEXT NULL DEFAULT NULL AFTER sentiment_flags,
    ADD COLUMN sentiment_analyzed_at DATETIME NULL DEFAULT NULL AFTER sentiment_summary;