-- ============================================================
-- iBilik Capital Database v2.5.2
-- Phase 7F Management Dashboard Permission
-- Baseline: Database v2.5.1
-- ============================================================

SET NAMES utf8mb4;

INSERT INTO permission_catalog
(permission_code,module_code,permission_type,name_zh,name_en,description_zh,description_en,active_flag,sort_order,created_at)
VALUES
(
 'MANAGEMENT_DASHBOARD_VIEW',
 'MANAGEMENT',
 'REPORT',
 '查看管理層財務總覽',
 'View Management Dashboard',
 '允許查看現金、投資者負債、應收、Pool、Recycling Profit、Bonus、損益與3/6/12個月負債壓力',
 'Allows viewing cash, investor liabilities, receivables, Pool, recycling profit, bonus, profitability and 3/6/12-month liability pressure',
 1,
 600,
 NOW(6)
)
ON DUPLICATE KEY UPDATE
module_code=VALUES(module_code),
permission_type=VALUES(permission_type),
name_zh=VALUES(name_zh),
name_en=VALUES(name_en),
description_zh=VALUES(description_zh),
description_en=VALUES(description_en),
active_flag=1,
sort_order=VALUES(sort_order);

SELECT permission_code,name_zh,name_en
FROM permission_catalog
WHERE permission_code='MANAGEMENT_DASHBOARD_VIEW';

SELECT 'iBilik Capital Database v2.5.2 Management Dashboard permission completed.' AS migration_status;
