R524809
16 lines
545 B
SQL
16 lines
545 B
SQL
-- Ozon 店铺默认以人民币计价；保留 RUB 作为平台支持币种。
|
|
-- 使用独立迁移，确保已初始化的数据库也会获得该配置。
|
|
SET search_path TO atlas, public;
|
|
|
|
INSERT INTO platform_currency_support (platform_id, currency_code)
|
|
SELECT id, 'CNY'::CHAR(3)
|
|
FROM platforms
|
|
WHERE code = 'OZON'
|
|
ON CONFLICT (platform_id, currency_code) DO UPDATE
|
|
SET is_enabled = true;
|
|
|
|
UPDATE platforms
|
|
SET capabilities = capabilities || jsonb_build_object('default_currency_code', 'CNY'),
|
|
updated_at = now()
|
|
WHERE code = 'OZON';
|