-- 更新系統功能 Emoji 圖示
-- 執行日期: 2026-02-23

-- 系統管理功能 (is_mana=true)
UPDATE system_functions SET function_icon = '⚙️' WHERE id = 10; -- system_managements (系統管理後台)
UPDATE system_functions SET function_icon = '🔧' WHERE id = 11; -- system_settings (系統參數設定)
UPDATE system_functions SET function_icon = '📋' WHERE id = 12; -- system_codes (系統代碼設定)
UPDATE system_functions SET function_icon = '🔔' WHERE id = 13; -- system_notifications (系統通知設定)
UPDATE system_functions SET function_icon = '📊' WHERE id = 14; -- system_logs (系統稽核查詢)
UPDATE system_functions SET function_icon = '🎯' WHERE id = 15; -- system_functions (系統功能設定)
UPDATE system_functions SET function_icon = '🏢' WHERE id = 16; -- init_tenants (公司初始資料建置)

-- 一般租戶功能 (is_mana=false)
UPDATE system_functions SET function_icon = '📊' WHERE id = 23; -- dashboard (系統首頁)
UPDATE system_functions SET function_icon = '🏢' WHERE id = 17; -- tenant (公司資料維護)
UPDATE system_functions SET function_icon = '🏛️' WHERE id = 18; -- tenant_departments (部門資料維護)
UPDATE system_functions SET function_icon = '👥' WHERE id = 19; -- tenant_user_roles (角色設定作業)
UPDATE system_functions SET function_icon = '🔐' WHERE id = 20; -- tenant_role_rights (角色權限設定作業)
UPDATE system_functions SET function_icon = '👤' WHERE id = 21; -- tenant_emp_resumes (人員檔歷維護)
UPDATE system_functions SET function_icon = '⚙️' WHERE id = 22; -- tenant_emp_settings (人員任用設定作業)

-- 驗證更新結果
SELECT id, code, name, function_icon
FROM system_functions
ORDER BY id;