shudao-main/shudao-chat-py/add_click_count_to_hot_question.sql

-- 为 hot_question 表添加 click_count 字段
ALTER TABLE `hot_question` ADD COLUMN `click_count` INT DEFAULT 0 COMMENT '点击量' AFTER `question_icon`;

-- 更新现有数据，设置默认点击量
UPDATE `hot_question` SET `click_count` = 0 WHERE `click_count` IS NULL;