From ca59c2a51250d76ee1e6794a31ff86f956eefcb7 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期二, 07 三月 2023 18:05:39 +0800 Subject: [PATCH] fix 修复 sql文件 创建人更新人表类型错误 --- script/sql/ry_vue_5.X.sql | 24 +++++++++++++++--------- 1 files changed, 15 insertions(+), 9 deletions(-) diff --git a/script/sql/ry_vue_5.X.sql b/script/sql/ry_vue_5.X.sql index da10377..430e882 100644 --- a/script/sql/ry_vue_5.X.sql +++ b/script/sql/ry_vue_5.X.sql @@ -179,9 +179,9 @@ status char(1) not null comment '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', - create_by varchar(64) default null comment '鍒涘缓鑰�', + create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', - update_by varchar(64) default null comment '鏇存柊鑰�', + update_by bigint(20) default null comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (role_id) @@ -514,7 +514,11 @@ status int(1) default 0 comment '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�', error_msg varchar(2000) default '' comment '閿欒娑堟伅', oper_time datetime comment '鎿嶄綔鏃堕棿', - primary key (oper_id) + cost_time bigint(20) default 0 comment '娑堣�楁椂闂�', + primary key (oper_id), + key idx_sys_oper_log_bt (business_type), + key idx_sys_oper_log_s (status), + key idx_sys_oper_log_ot (oper_time) ) engine=innodb comment = '鎿嶄綔鏃ュ織璁板綍'; @@ -530,9 +534,9 @@ dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷', status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', - create_by varchar(64) default null comment '鍒涘缓鑰�', + create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', - update_by varchar(64) default null comment '鏇存柊鑰�', + update_by bigint(20) default null comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (dict_id), @@ -566,9 +570,9 @@ is_default char(1) default 'N' comment '鏄惁榛樿锛圷鏄� N鍚︼級', status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', - create_by varchar(64) default null comment '鍒涘缓鑰�', + create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', - update_by varchar(64) default null comment '鏇存柊鑰�', + update_by bigint(20) default null comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (dict_code) @@ -643,7 +647,9 @@ status char(1) default '0' comment '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�', msg varchar(255) default '' comment '鎻愮ず娑堟伅', login_time datetime comment '璁块棶鏃堕棿', - primary key (info_id) + primary key (info_id), + key idx_sys_logininfor_s (status), + key idx_sys_logininfor_lt (login_time) ) engine=innodb comment = '绯荤粺璁块棶璁板綍'; @@ -779,7 +785,7 @@ create_time datetime default null comment '鍒涘缓鏃堕棿', update_by bigint(20) default null comment '鏇存柊鑰�', update_time datetime default null comment '鏇存柊鏃堕棿', - remark varchar(500) default null comment '澶囨敞', + remark varchar(500) default null comment '澶囨敞', primary key (oss_config_id) ) engine=innodb comment='瀵硅薄瀛樺偍閰嶇疆琛�'; -- Gitblit v1.9.3