From c4e3ccb0b53486f025a7c35694efdd2267142149 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 16 一月 2023 19:10:21 +0800
Subject: [PATCH] 1

---
 data/update.sql |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/data/update.sql b/data/update.sql
index af088e9..f0323ab 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -1,3 +1,6 @@
+select * from lf.sys_menu where position('http://' in url) > 0;
+select url, replace(url, 'pipe.cppe.com', '{host}') from lf.sys_menu where position('http://' in url) > 0;
+update lf.sys_menu set url = replace(url, 'pipe.cppe.com', '{host}') where position('http://' in url) > 0;
 ------------------------------------------------------ 鏇存柊鑿滃崟+鐢ㄦ埛
 select * from lf.sys_menu where cn_name = '鏁版嵁搴撶洃鎺�';
 -- update lf.sys_menu set url = 'http://pipe.cppe.com:8088/server/druid/index.html' where cn_name = '鏁版嵁搴撶洃鎺�';

--
Gitblit v1.9.3