Files
hfb_jysh/backend/migrations/000032_crash_branding.sql

32 lines
915 B
SQL

-- +goose Up
UPDATE chat_support_groups
SET name = '撞车-客服',
description = '用户从撞车入口联系客服时,按本组成员在线与负载分配'
WHERE code = 'mohong';
UPDATE system_configs
SET description = REPLACE(description, '摸大红', '撞车'),
`value` = REPLACE(`value`, '摸大红', '撞车')
WHERE `key` LIKE 'mohong.%';
UPDATE permissions
SET name = REPLACE(name, '摸大红', '撞车')
WHERE code LIKE 'mohong:%';
-- +goose Down
UPDATE chat_support_groups
SET name = '摸大红-客服',
description = '用户从摸大红入口联系客服时,按本组成员在线与负载分配'
WHERE code = 'mohong';
UPDATE system_configs
SET description = REPLACE(description, '撞车', '摸大红'),
`value` = REPLACE(`value`, '撞车', '摸大红')
WHERE `key` LIKE 'mohong.%';
UPDATE permissions
SET name = REPLACE(name, '撞车', '摸大红')
WHERE code LIKE 'mohong:%';