18 lines
562 B
SQL
18 lines
562 B
SQL
-- Limit LIKEI app game-list rows to the Turkey region.
|
|
-- Production Turkey Region observed in sys_region_config: 2046066409959649281.
|
|
-- Re-check sys_region_config before production execution if region data has been rebuilt.
|
|
-- After direct SQL execution, clear Redis GAME_LIST* cache or wait for its 1-hour TTL.
|
|
|
|
START TRANSACTION;
|
|
|
|
SET @sys_origin := 'LIKEI';
|
|
SET @turkey_region_id := '2046066409959649281';
|
|
|
|
UPDATE sys_game_list_config
|
|
SET regions = @turkey_region_id,
|
|
update_time = NOW(3)
|
|
WHERE sys_origin = @sys_origin
|
|
AND is_showcase = 1;
|
|
|
|
COMMIT;
|