From 0cecbec3b38d9ceee53d7f126417f70ff8ce3606 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期一, 08 八月 2022 11:21:44 +0800
Subject: [PATCH] update 更新 解锁菜单权限sql

---
 script/sql/update/sqlserver/update-4.2-4.3.sql |   15 ++++++++++++++-
 1 files changed, 14 insertions(+), 1 deletions(-)

diff --git a/script/sql/update/sqlserver/update-4.2-4.3.sql b/script/sql/update/sqlserver/update-4.2-4.3.sql
index 9a3c41b..44c2a40 100644
--- a/script/sql/update/sqlserver/update-4.2-4.3.sql
+++ b/script/sql/update/sqlserver/update-4.2-4.3.sql
@@ -1 +1,14 @@
-insert into sys_menu values('112',  '缂撳瓨鍒楄〃', '2',   '6', 'cacheList',  'monitor/cache/list',       '', '1', '0', 'C', '0', '0', 'monitor:cache:list',      'redis-list',    'admin', now(), '', null, '缂撳瓨鍒楄〃鑿滃崟');
+INSERT [sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query_param], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (112, N'缂撳瓨鍒楄〃', 2, 6, N'cacheList', N'monitor/cache/list', N'', 1, 0, N'C', N'0', N'0', N'monitor:cache:list', N'redis-list', N'admin', getdate(), N'', NULL, N'缂撳瓨鍒楄〃鑿滃崟')
+GO
+
+delete from sys_menu WHERE menu_id = 116;
+GO
+
+update sys_config set config_key = 'sys.account.captchaEnabled' where config_id = 4
+GO
+
+INSERT [sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query_param], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (1050, N'璐︽埛瑙i攣', 501, 4, N'#', N'', N'', 1, 0, N'F', N'0', N'0', N'monitor:logininfor:unlock',  N'#', N'admin', getdate(), N'', null, N'')
+GO
+
+INSERT [sys_role_menu] ([role_id], [menu_id]) VALUES (2, 1050)
+GO

--
Gitblit v1.9.3