40 lines
935 B
SQL
40 lines
935 B
SQL
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- 左侧父级菜单顺序直接影响后台入口效率：团队管理靠近用户管理，后台设置固定沉到底部。
|
|
SET @now_ms = CAST(UNIX_TIMESTAMP(UTC_TIMESTAMP(3)) * 1000 AS UNSIGNED);
|
|
|
|
UPDATE admin_menus
|
|
SET sort = CASE code
|
|
WHEN 'overview' THEN 10
|
|
WHEN 'app-users' THEN 20
|
|
WHEN 'host-org' THEN 30
|
|
WHEN 'rooms' THEN 40
|
|
WHEN 'app-config' THEN 50
|
|
WHEN 'resources' THEN 60
|
|
WHEN 'operations' THEN 70
|
|
WHEN 'payment' THEN 80
|
|
WHEN 'activities' THEN 90
|
|
WHEN 'games' THEN 100
|
|
WHEN 'geo' THEN 110
|
|
WHEN 'system' THEN 120
|
|
WHEN 'logs' THEN 130
|
|
ELSE sort
|
|
END,
|
|
updated_at_ms = @now_ms
|
|
WHERE parent_id IS NULL
|
|
AND code IN (
|
|
'overview',
|
|
'app-users',
|
|
'host-org',
|
|
'rooms',
|
|
'app-config',
|
|
'resources',
|
|
'operations',
|
|
'payment',
|
|
'activities',
|
|
'games',
|
|
'geo',
|
|
'system',
|
|
'logs'
|
|
);
|