From 2cb1b84204359948f36fa8ef53e567961b7b11c8 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期四, 25 八月 2022 09:42:07 +0800
Subject: [PATCH] fix 修复 部门与角色 状态导出字典使用错误
---
script/sql/update/postgres/update-4.2-4.3.sql | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/script/sql/update/postgres/update-4.2-4.3.sql b/script/sql/update/postgres/update-4.2-4.3.sql
index 9a3c41b..8efbbd0 100644
--- a/script/sql/update/postgres/update-4.2-4.3.sql
+++ b/script/sql/update/postgres/update-4.2-4.3.sql
@@ -1 +1,16 @@
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, '缂撳瓨鍒楄〃鑿滃崟');
+
+delete from sys_menu WHERE menu_id = 116;
+
+update sys_config set config_key = 'sys.account.captchaEnabled' where config_id = 4
+
+insert into sys_menu values('1050', '璐︽埛瑙ｉ攣', '501', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', now(), '', null, '');
+
+insert into sys_role_menu values ('2', '1050');
+
+-- 瀛楃涓茶嚜鍔ㄨ浆鏃堕棿 閬垮厤妗嗘灦鏃堕棿鏌ヨ鎶ラ敊闂
+create or replace function cast_varchar_to_timestamp(varchar) returns timestamptz as $$
+select to_timestamp($1, 'yyyy-mm-dd hh24:mi:ss');
+$$ language sql strict ;
+
+create cast (varchar as timestamptz) with function cast_varchar_to_timestamp as IMPLICIT;
--
Gitblit v1.9.3