www
89 lines
2.8 KiB
SQL
89 lines
2.8 KiB
SQL
ALTER TABLE `video_clips`
|
|
ADD COLUMN `quality_status` VARCHAR(50) NULL AFTER `retry_count`,
|
|
ADD COLUMN `quality_score` DECIMAL(5, 2) NULL AFTER `quality_status`,
|
|
ADD COLUMN `quality_issues` JSON NULL AFTER `quality_score`;
|
|
|
|
INSERT INTO `provider_configs`
|
|
(`provider_type`, `provider_code`, `display_name`, `mode`, `model_name`, `config_json`, `is_enabled`, `priority`, `rate_limit_json`, `cost_rule_json`, `created_at`, `updated_at`)
|
|
VALUES
|
|
(
|
|
'VideoProvider',
|
|
'runway-image-to-video',
|
|
'Runway Image-to-Video',
|
|
'real',
|
|
'gen4.5',
|
|
JSON_OBJECT(
|
|
'driver', 'runway_image_to_video',
|
|
'api_key_env', 'RUNWAYML_API_SECRET',
|
|
'base_url', 'https://api.dev.runwayml.com',
|
|
'api_version', '2024-11-06',
|
|
'timeout_ms', 180000,
|
|
'create_endpoint', '/v1/image_to_video',
|
|
'task_endpoint_template', '/v1/tasks/{task_id}',
|
|
'poll_interval_ms', 10000,
|
|
'max_poll_attempts', 90,
|
|
'ratio', '720:1280',
|
|
'duration', 5,
|
|
'note', '默认禁用。启用后必须在业务侧显式确认真实视频生成，避免误扣费。'
|
|
),
|
|
false,
|
|
40,
|
|
JSON_OBJECT('rpm', 5, 'concurrency', 1),
|
|
JSON_OBJECT(
|
|
'flat_cost', 0,
|
|
'unit', 'video_seconds',
|
|
'price_per_second', 0,
|
|
'currency', 'USD',
|
|
'max_cost_per_call', 0,
|
|
'daily_cost_limit', 0,
|
|
'note', '请按 Runway 实际账单填写 price_per_second 或单次/每日成本上限。'
|
|
),
|
|
NOW(3),
|
|
NOW(3)
|
|
),
|
|
(
|
|
'VideoProvider',
|
|
'kling-image-to-video',
|
|
'Kling Image-to-Video',
|
|
'real',
|
|
'kling-v3',
|
|
JSON_OBJECT(
|
|
'driver', 'kling_image_to_video',
|
|
'api_key_env', 'KLING_API_KEY',
|
|
'base_url', 'https://api-singapore.klingai.com',
|
|
'timeout_ms', 180000,
|
|
'create_endpoint', '/v1/videos/image2video',
|
|
'task_endpoint_template', '/v1/videos/image2video/{task_id}',
|
|
'poll_interval_ms', 10000,
|
|
'max_poll_attempts', 90,
|
|
'image_field', 'image',
|
|
'prompt_field', 'prompt',
|
|
'duration_field', 'duration',
|
|
'aspect_ratio_field', 'aspect_ratio',
|
|
'aspect_ratio', '9:16',
|
|
'duration', 5,
|
|
'note', '默认禁用。不同 Kling 官方/网关接口字段可能不同，可在高级配置里调整字段名和 Base URL。'
|
|
),
|
|
false,
|
|
40,
|
|
JSON_OBJECT('rpm', 5, 'concurrency', 1),
|
|
JSON_OBJECT(
|
|
'flat_cost', 0,
|
|
'unit', 'video_seconds',
|
|
'price_per_second', 0,
|
|
'currency', 'USD',
|
|
'max_cost_per_call', 0,
|
|
'daily_cost_limit', 0,
|
|
'note', '请按 Kling 实际账单填写 price_per_second 或单次/每日成本上限。'
|
|
),
|
|
NOW(3),
|
|
NOW(3)
|
|
)
|
|
ON DUPLICATE KEY UPDATE
|
|
`display_name` = VALUES(`display_name`),
|
|
`mode` = VALUES(`mode`),
|
|
`model_name` = VALUES(`model_name`),
|
|
`priority` = VALUES(`priority`),
|
|
`rate_limit_json` = VALUES(`rate_limit_json`),
|
|
`updated_at` = NOW(3);
|