-- Groups that receive new gift codes. Menus stay in private chats.
-- If the bot is already in a group, remove it and add it again after this migration
-- so Telegram sends my_chat_member and the group is stored.

CREATE TABLE IF NOT EXISTS broadcast_chats (
    chat_id BIGINT NOT NULL PRIMARY KEY,
    title VARCHAR(255) NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
