From e145880a9ce786108df18bf139e062e3de3c714a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 10 十月 2022 16:59:14 +0800
Subject: [PATCH] 1
---
data/db.sql | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/data/db.sql b/data/db.sql
index cecbb36..1a0b608 100644
--- a/data/db.sql
+++ b/data/db.sql
@@ -264,11 +264,14 @@
select * from lf.sys_login;
select * from lf.sys_login_2022;
select * from lf.sys_login_2024;
+select a.*,b.uname from lf.sys_login a inner join lf.sys_user b on a.userid = b.id;
----------------------------------------------------------------------------------------------------- 6.鎿嶄綔鏃ュ織琛�
-- DROP TABLE IF EXISTS lf.sys_operate;
create table lf.sys_operate(
id serial8,
modular varchar(60),
+ module1 varchar(50),
+ module2 varchar(50),
url varchar(1024),
ip varchar(30),
exec bigint,
@@ -295,6 +298,8 @@
comment on table lf.sys_operate is '鎿嶄綔鏃ュ織琛�';
comment on column lf.sys_operate.id is '涓婚敭ID';
comment on column lf.sys_operate.modular is '鎿嶄綔妯″潡锛氬 鏁版嵁绠＄悊\鐩綍绠＄悊';
+comment on column lf.sys_operate.modular1 is '涓�绾фā鍧楋細濡� 鏁版嵁绠＄悊';
+comment on column lf.sys_operate.modular2 is '浜岀骇妯″潡锛氬 鐩綍绠＄悊';
comment on column lf.sys_operate.url is '鎿嶄綔缃戝潃';
comment on column lf.sys_operate.ip is 'IP鍦板潃';
comment on column lf.sys_operate.exec is '鎿嶄綔鏃堕棿锛氬崟浣嶄负姣';
@@ -304,6 +309,11 @@
comment on column lf.sys_operate.optime is '鎿嶄綔鏃堕棿';
comment on column lf.sys_operate.bak is '澶囨敞';
+alter table lf.sys_operate add column modular1 varchar(50);
+alter table lf.sys_operate add column modular2 varchar(50);
+select split_part(modular,'\',1),split_part(modular,'\',2) from lf.sys_operate;
+update lf.sys_operate set modular1=split_part(modular,'\',1),modular2=split_part(modular,'\',2);
+
/*insert into lf.sys_operate (modular,url,ip,type) values ('鏁版嵁绠＄悊\鐩綍绠＄悊','data/manage/update','192.168.20.106',5);
insert into lf.sys_operate (modular,url,ip,type,optime) values ('鏁版嵁绠＄悊\鐩綍绠＄悊','data/manage/delete','192.168.20.107',4,'2024-01-02');*/
--
Gitblit v1.9.3