From d63b4703ef5017a6b49571b1558f6716f55733f2 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 17 十月 2022 09:14:48 +0800
Subject: [PATCH] 1、修改所有Mapper的删除功能 2、用户添加批量修改密码功能 3、添加Java的GDAL操作类
---
data/db_tab.sql | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 7185ed6..fcaa293 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -419,6 +419,7 @@
depid integer default 1,
name varchar(100),
descr varchar(100),
+ is_admin integer default 0,
create_user integer default 1,
create_time timestamp(6) without time zone default now(),
update_user integer,
@@ -430,12 +431,13 @@
comment on column lf.sys_role.depid is '鍗曚綅ID';
comment on column lf.sys_role.name is '鍚嶇О';
comment on column lf.sys_role.descr is '鎻忚堪';
+comment on column lf.sys_role.is_admin is '鏄惁涓虹鐞嗗憳锛�0-鍚�,1-鏄�';
comment on column lf.sys_role.create_user is '鍒涘缓浜篒D';
comment on column lf.sys_role.create_time is '鍒涘缓鏃堕棿';
comment on column lf.sys_role.update_user is '鏇存柊浜篒D';
comment on column lf.sys_role.update_time is '鏇存柊鏃堕棿';
comment on column lf.sys_role.bak is '澶囨敞';
---insert into lf.sys_role (id,depid,name,descr) values (1,1,'Admin','绯荤粺绠＄悊鍛�');
+--insert into lf.sys_role (id,depid,name,descr,is_admin) values (1,1,'Admin','绯荤粺绠＄悊鍛�',1);
select * from lf.sys_role;
select a.*,b.name depname from lf.sys_role a inner join lf.sys_dep b on a.depid = b.id order by a.id limit 10 offset 0;
@@ -830,7 +832,9 @@
comment on column lf.sys_args.create_time is '鍒涘缓鏃堕棿';
comment on column lf.sys_args.update_user is '鏇存柊浜篒D';
comment on column lf.sys_args.update_time is '鏇存柊鏃堕棿';
-/* insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('鑷姩鐧诲嚭鏃堕棿',15,15,3,1440,1,'榛樿鐢ㄦ埛15鍒嗛挓涓嶆搷浣滐紝灏辫嚜鍔ㄧ櫥鍑虹郴缁熴��','AUTO_LOGOUT');
+/* insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('瀵嗙爜鍑洪敊娆℃暟',5,5,3,20,1,'榛樿鐢ㄦ埛瀵嗙爜杩炵画杈撳叆鍑洪敊5娆★紝灏辨殏鏃舵嫆缁濈櫥褰曘��','PWD_ERR_COUNT');
+insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('瀵嗙爜鍑洪敊绛夊緟鏃堕棿',5,5,1,60,1,'榛樿鐢ㄦ埛瀵嗙爜杩炵画杈撳叆澶氭鍑洪敊鏃讹紝5鍒嗛挓鍐呮嫆缁濈櫥褰曘��','PWD_ERR_TIME');
+insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('鑷姩鐧诲嚭鏃堕棿',15,15,3,1440,1,'榛樿鐢ㄦ埛15鍒嗛挓涓嶆搷浣滐紝灏辫嚜鍔ㄧ櫥鍑虹郴缁熴��','AUTO_LOGOUT');
insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('浠ょ墝鏈夋晥鏈�',240,240,60,1440,1,'浠ょ墝榛樿鏈夋晥鏈熶负240鍒嗛挓锛岃秴鏃跺皢澶辨晥銆�','TOKEN_EXPIRE');
insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('缂撳瓨鏈夋晥鏈�',240,240,60,1440,1,'缂撳瓨榛樿鏈夋晥鏈熶负240鍒嗛挓锛岃秴鏃跺皢澶辨晥銆�','CACHE_EXPIRE');
insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('鏈�澶ф枃浠舵暟',2000,2000,500,2500,1,'鍗曚釜鏂囦欢澶逛笅榛樿鏈�澶у瓨鍌ㄦ枃浠剁殑鏁扮洰涓�2000涓��','MAX_FILES');
--
Gitblit v1.9.3