yumi-golang/migrations/027_task_center_recharge_jump.sql
2026-05-09 00:16:01 +08:00

14 lines
510 B
SQL

-- Recharge tasks should open the Flutter in-app recharge route, not a room.
-- Existing configs created before RECHARGE_IN_APP existed may still carry
-- ROOM_RANDOM_WITH_MIC or an empty jump page.
UPDATE task_center_task_config
SET
jump_type = 'RECHARGE_IN_APP',
jump_page = '',
update_time = NOW(3)
WHERE condition_type = 'RECHARGE_GOLD'
AND (
jump_type IN ('', 'NONE', 'ROOM_RANDOM', 'ROOM_RANDOM_WITH_MIC', 'RECHARGE_IN_APP')
OR jump_page IN ('', '/room', '/main/me/wallet/recharge')
);