-- ============================================================
-- V8: 添加速创API(SuChuang)的Sora2模型配置
-- 描述: 速创API只有一个Sora2接口，通过参数区分不同功能
-- 作者: 1818AI  
-- 日期: 2025-10-23
-- ============================================================

USE `1818ai`;

-- 插入速创Sora2模型配置
-- 速创不区分具体模型，通过参数控制：aspectRatio, duration, size, url(图生视频时)

-- 文生视频模型（8个）
-- 9:16 竖屏
INSERT INTO `points_config` (`model_name`, `description`, `points_cost`, `provider_type`, `provider_config`, `task_type`, `is_enabled`, `create_time`, `update_time`)
VALUES 
('sc_sora2_text_portrait_10s_small', '速创Sora2 文生视频-竖屏-10秒-标清', 80, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"10","size":"small"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_portrait_10s_large', '速创Sora2 文生视频-竖屏-10秒-高清', 200, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"10","size":"large"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_portrait_15s_small', '速创Sora2 文生视频-竖屏-15秒-标清', 130, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"15","size":"small"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_portrait_15s_large', '速创Sora2 文生视频-竖屏-15秒-高清', 320, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"15","size":"large"}', 
 'text_to_video', 1, NOW(), NOW());

-- 16:9 横屏
INSERT INTO `points_config` (`model_name`, `description`, `points_cost`, `provider_type`, `provider_config`, `task_type`, `is_enabled`, `create_time`, `update_time`)
VALUES 
('sc_sora2_text_landscape_10s_small', '速创Sora2 文生视频-横屏-10秒-标清', 80, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"10","size":"small"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_landscape_10s_large', '速创Sora2 文生视频-横屏-10秒-高清', 200, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"10","size":"large"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_landscape_15s_small', '速创Sora2 文生视频-横屏-15秒-标清', 130, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"15","size":"small"}', 
 'text_to_video', 1, NOW(), NOW()),

('sc_sora2_text_landscape_15s_large', '速创Sora2 文生视频-横屏-15秒-高清', 320, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"15","size":"large"}', 
 'text_to_video', 1, NOW(), NOW());

-- 图生视频模型（8个）
-- 9:16 竖屏
INSERT INTO `points_config` (`model_name`, `description`, `points_cost`, `provider_type`, `provider_config`, `task_type`, `is_enabled`, `create_time`, `update_time`)
VALUES 
('sc_sora2_img_portrait_10s_small', '速创Sora2 图生视频-竖屏-10秒-标清', 90, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"10","size":"small","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_portrait_10s_large', '速创Sora2 图生视频-竖屏-10秒-高清', 240, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"10","size":"large","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_portrait_15s_small', '速创Sora2 图生视频-竖屏-15秒-标清', 140, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"15","size":"small","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_portrait_15s_large', '速创Sora2 图生视频-竖屏-15秒-高清', 360, 'suchuang', 
 '{"aspectRatio":"9:16","duration":"15","size":"large","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW());

-- 16:9 横屏
INSERT INTO `points_config` (`model_name`, `description`, `points_cost`, `provider_type`, `provider_config`, `task_type`, `is_enabled`, `create_time`, `update_time`)
VALUES 
('sc_sora2_img_landscape_10s_small', '速创Sora2 图生视频-横屏-10秒-标清', 90, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"10","size":"small","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_landscape_10s_large', '速创Sora2 图生视频-横屏-10秒-高清', 240, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"10","size":"large","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_landscape_15s_small', '速创Sora2 图生视频-横屏-15秒-标清', 140, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"15","size":"small","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW()),

('sc_sora2_img_landscape_15s_large', '速创Sora2 图生视频-横屏-15秒-高清', 360, 'suchuang', 
 '{"aspectRatio":"16:9","duration":"15","size":"large","requireImage":true}', 
 'image_to_video', 1, NOW(), NOW());

-- 验证插入的模型
SELECT 
    model_name,
    description,
    points_cost,
    provider_type,
    task_type,
    is_enabled
FROM points_config
WHERE provider_type = 'suchuang'
ORDER BY task_type, model_name;

-- ============================================================
-- V8脚本结束
-- ============================================================

