-- Glass broadcast tables
CREATE TABLE IF NOT EXISTS glass_broadcast_drafts (id INT AUTO_INCREMENT PRIMARY KEY, admin_id BIGINT NOT NULL, message_text TEXT NOT NULL, temp_title VARCHAR(255) NULL, status VARCHAR(20) NOT NULL DEFAULT 'draft', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS glass_broadcast_buttons (id INT AUTO_INCREMENT PRIMARY KEY, draft_id INT NOT NULL, title VARCHAR(255) NOT NULL, url TEXT NOT NULL, position VARCHAR(20) NOT NULL DEFAULT 'bottom_left') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS glass_broadcast_queue (id BIGINT AUTO_INCREMENT PRIMARY KEY, draft_id INT NOT NULL, user_id BIGINT NOT NULL, status TINYINT NOT NULL DEFAULT 0, sent_at DATETIME NULL, UNIQUE KEY uniq_draft_user (draft_id,user_id), KEY idx_status (status,draft_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;