From a28dd0fe4057d9d1c52be85457ad0c3882ec2d40 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期二, 07 三月 2023 18:26:09 +0800
Subject: [PATCH] fix 修复 数据加密拦截器空数据异常
---
script/sql/postgres/postgres_ry_vue_5.X.sql | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql
index 4ad90df..65857bf 100644
--- a/script/sql/postgres/postgres_ry_vue_5.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_5.X.sql
@@ -667,8 +667,13 @@
status int4 default 0,
error_msg varchar(2000) default ''::varchar,
oper_time timestamp,
+ cost_time int8 default 0,
constraint sys_oper_log_pk primary key (oper_id)
);
+
+create unique index idx_sys_oper_log_bt ON sys_oper_log (business_type);
+create unique index idx_sys_oper_log_s ON sys_oper_log (status);
+create unique index idx_sys_oper_log_ot ON sys_oper_log (oper_time);
comment on table sys_oper_log is '鎿嶄綔鏃ュ織璁板綍';
comment on column sys_oper_log.oper_id is '鏃ュ織涓婚敭';
@@ -688,6 +693,7 @@
comment on column sys_oper_log.status is '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�';
comment on column sys_oper_log.error_msg is '閿欒娑堟伅';
comment on column sys_oper_log.oper_time is '鎿嶄綔鏃堕棿';
+comment on column sys_oper_log.cost_time is '娑堣�楁椂闂�';
-- ----------------------------
-- 11銆佸瓧鍏哥被鍨嬭〃
@@ -709,7 +715,7 @@
constraint sys_dict_type_pk primary key (dict_id)
);
-CREATE UNIQUE INDEX sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type);
+create unique index sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type);
comment on table sys_dict_type is '瀛楀吀绫诲瀷琛�';
comment on column sys_dict_type.dict_id is '瀛楀吀涓婚敭';
@@ -865,6 +871,9 @@
constraint sys_logininfor_pk primary key (info_id)
);
+create unique index idx_sys_logininfor_s ON sys_logininfor (status);
+create unique index idx_sys_logininfor_lt ON sys_logininfor (login_time);
+
comment on table sys_logininfor is '绯荤粺璁块棶璁板綍';
comment on column sys_logininfor.info_id is '璁块棶ID';
comment on column sys_logininfor.tenant_id is '绉熸埛缂栧彿';
@@ -940,6 +949,7 @@
gen_type char default '0'::bpchar not null,
gen_path varchar(200) default '/'::varchar,
options varchar(1000) default null::varchar,
+ create_dept int8,
create_by int8,
create_time timestamp,
update_by int8,
--
Gitblit v1.9.3