From 750cbe93122ca8d3d71d80b86e3a1eeaf458a3ec Mon Sep 17 00:00:00 2001
From: Yjoioooo <693337446@qq.com>
Date: 星期四, 06 四月 2023 11:26:31 +0800
Subject: [PATCH] update 处理多余的角色删除操作，合并到insertUserRole
---
script/sql/postgres/postgres_ry_vue_5.X.sql | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql
index 7f5e859..bdf28b4 100644
--- a/script/sql/postgres/postgres_ry_vue_5.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_5.X.sql
@@ -671,9 +671,9 @@
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);
+create index idx_sys_oper_log_bt ON sys_oper_log (business_type);
+create index idx_sys_oper_log_s ON sys_oper_log (status);
+create 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 '鏃ュ織涓婚敭';
@@ -871,8 +871,8 @@
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);
+create index idx_sys_logininfor_s ON sys_logininfor (status);
+create 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';
--
Gitblit v1.9.3