From b1d3da260275c6e685a8e3d0305dfdd7e24857fc Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期三, 28 十月 2026 11:51:49 +0800 Subject: [PATCH] feat(sql): 新增门户字号全局参数初始化脚本 --- sql/mysql/portal_ui_font_config.sql | 21 +++++++++++++++++++++ 1 files changed, 21 insertions(+), 0 deletions(-) diff --git a/sql/mysql/portal_ui_font_config.sql b/sql/mysql/portal_ui_font_config.sql new file mode 100644 index 0000000..fc28b21 --- /dev/null +++ b/sql/mysql/portal_ui_font_config.sql @@ -0,0 +1,21 @@ +-- 闂ㄦ埛瀛楀彿鍏ㄥ眬閰嶇疆锛堝熀纭�璁炬柦 -> 鍙傛暟閰嶇疆锛� +-- 璇存槑锛氶棬鎴烽椤靛瓧鍙枫�佽彍鍗曞瓧鍙蜂繚瀛樹负鍏ㄥ眬鍙傛暟锛屾墍鏈夌敤鎴峰叡鐢紱鍓嶇鍚姩鍚庤鍙栧苟搴旂敤銆� +-- 鍙傛暟鍙湪銆屽熀纭�璁炬柦 -> 鍙傛暟閰嶇疆銆嶄腑鐩存帴缁存姢锛屼篃鍙湪銆屽亸濂借缃� -> 澶栬銆嶄腑淇敼銆� + +-- 棣栭〉瀛楀彿锛氱櫨鍒嗘瘮锛�100 琛ㄧず鍘熷澶у皬锛屽缓璁� 100-150 +INSERT INTO infra_config (category, name, config_key, value, type, visible, remark, creator, updater, create_time, update_time, deleted) +SELECT '闂ㄦ埛閰嶇疆', '棣栭〉瀛楀彿(%)', 'portal.ui.home-font-size', '115', 1, 1, + '棣栭〉鏂囧瓧缂╂斁鐧惧垎姣旓紝100 涓哄師濮嬪ぇ灏忥紝鍙缃� 100-150', '1', '1', NOW(), NOW(), 0 +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM infra_config WHERE config_key = 'portal.ui.home-font-size' AND deleted = 0 +); + +-- 鑿滃崟瀛楀彿锛氬崟浣� px锛屽缓璁� 12-22 +INSERT INTO infra_config (category, name, config_key, value, type, visible, remark, creator, updater, create_time, update_time, deleted) +SELECT '闂ㄦ埛閰嶇疆', '鑿滃崟瀛楀彿(px)', 'portal.ui.menu-font-size', '16', 1, 1, + '椤堕儴瀵艰埅涓庝晶杈硅彍鍗曟枃瀛楀ぇ灏忥紝鍗曚綅 px锛屽彲璁剧疆 12-22', '1', '1', NOW(), NOW(), 0 +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM infra_config WHERE config_key = 'portal.ui.menu-font-size' AND deleted = 0 +); -- Gitblit v1.9.3