Files
AIGC/demo/database_migration_20251119_add_duration.sql

9 lines
350 B
MySQL
Raw Permalink Normal View History

-- 为 storyboard_video_tasks 表添加 duration 字段
-- 执行时间2025-11-19
ALTER TABLE storyboard_video_tasks
ADD COLUMN duration INT NOT NULL DEFAULT 10 COMMENT '视频时长(秒)' AFTER hd_mode;
-- 更新现有记录设置默认值为10秒
UPDATE storyboard_video_tasks SET duration = 10 WHERE duration IS NULL OR duration = 0;