李建琦
6d655c9903
Release / update-version (push) Has been cancelled
Release / build-frontend (push) Has been cancelled
Release / release (push) Has been cancelled
Release / sync-version-file (push) Has been cancelled
CI / shell (push) Canceled after 0s
CI / test (push) Canceled after 0s
CI / frontend (push) Canceled after 0s
CI / golangci-lint (push) Canceled after 0s
Security Scan / backend-security (push) Canceled after 0s
Security Scan / frontend-security (push) Canceled after 0s
17 lines
1.1 KiB
SQL
17 lines
1.1 KiB
SQL
-- Add independent group pricing controls for Grok video generation.
|
||
-- Video prices intentionally do not backfill from image prices: image and video
|
||
-- generation must be priced separately.
|
||
|
||
ALTER TABLE groups
|
||
ADD COLUMN IF NOT EXISTS video_rate_independent BOOLEAN NOT NULL DEFAULT false,
|
||
ADD COLUMN IF NOT EXISTS video_rate_multiplier DECIMAL(10,4) NOT NULL DEFAULT 1.0,
|
||
ADD COLUMN IF NOT EXISTS video_price_480p DECIMAL(20,8),
|
||
ADD COLUMN IF NOT EXISTS video_price_720p DECIMAL(20,8),
|
||
ADD COLUMN IF NOT EXISTS video_price_1080p DECIMAL(20,8);
|
||
|
||
COMMENT ON COLUMN groups.video_rate_independent IS '视频生成是否使用独立倍率；false 表示共享分组有效倍率';
|
||
COMMENT ON COLUMN groups.video_rate_multiplier IS '视频生成独立倍率，仅 video_rate_independent=true 时生效';
|
||
COMMENT ON COLUMN groups.video_price_480p IS '480p 视频生成单价 (USD)，Grok 平台使用';
|
||
COMMENT ON COLUMN groups.video_price_720p IS '720p 视频生成单价 (USD)，Grok 平台使用';
|
||
COMMENT ON COLUMN groups.video_price_1080p IS '1080p 视频生成单价 (USD)，Grok 平台使用';
|