From ec2cbac35d2eaa3fddf65ca8dfc6c7583b87ff06 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期五, 16 六月 2023 00:24:12 +0800 Subject: [PATCH] fix 修复 Mapper 多参数未加 @Param注解问题 --- script/sql/oracle/oracle_ry_vue_5.X.sql | 16 +++++++--------- 1 files changed, 7 insertions(+), 9 deletions(-) diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql index 9d57d30..3e93ae9 100644 --- a/script/sql/oracle/oracle_ry_vue_5.X.sql +++ b/script/sql/oracle/oracle_ry_vue_5.X.sql @@ -654,9 +654,9 @@ ); alter table sys_oper_log add constraint pk_sys_oper_log 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 '鏃ュ織涓婚敭'; @@ -828,10 +828,6 @@ insert into sys_config values(2, '000000', '鐢ㄦ埛绠＄悊-璐﹀彿鍒濆瀵嗙爜', 'sys.user.initPassword', '123456', 'Y', 103, 1, sysdate, null, null, '鍒濆鍖栧瘑鐮� 123456' ); insert into sys_config values(3, '000000', '涓绘鏋堕〉-渚ц竟鏍忎富棰�', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, sysdate, null, null, '娣辫壊涓婚theme-dark锛屾祬鑹蹭富棰榯heme-light' ); insert into sys_config values(5, '000000', '璐﹀彿鑷姪-鏄惁寮�鍚敤鎴锋敞鍐屽姛鑳�', 'sys.account.registerUser', 'false', 'Y', 103, 1, sysdate, null, null, '鏄惁寮�鍚敞鍐岀敤鎴峰姛鑳斤紙true寮�鍚紝false鍏抽棴锛�'); -insert into sys_config values(6, '000000', '鐢ㄦ埛閰嶇疆-瀵嗙爜鏈�澶ч敊璇鏁�', 'sys.user.maxRetryCount', '5', 'Y', 103, 1, sysdate, null, null, '瀵嗙爜鏈�澶ч敊璇鏁�'); -insert into sys_config values(7, '000000', '鐢ㄦ埛閰嶇疆-瀵嗙爜閿佸畾鏃堕棿', 'sys.user.lockTime', '10', 'Y', 103, 1, sysdate, null, null, '瀵嗙爜閿佸畾鏃堕棿锛堝垎閽燂級'); -insert into sys_config values(8, '000000', '璐﹀彿鑷姪-鐭俊寮�鍏�', 'sys.account.smsEnabled', 'false', 'Y', 103, 1, sysdate, null, null, '鏄惁寮�鍚煭淇″姛鑳斤紙true寮�鍚紝false鍏抽棴锛�'); -insert into sys_config values(9, '000000', '璐﹀彿鑷姪-楠岃瘉鐮佹ā鏉縤d', 'sys.account.templateId', '', 'Y', 103, 1, sysdate, null, null, '楠岃瘉鐮佹ā鏉縤d'); insert into sys_config values(11, '000000', 'OSS棰勮鍒楄〃璧勬簮寮�鍏�', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, sysdate, null, null, 'true:寮�鍚�, false:鍏抽棴'); @@ -852,8 +848,8 @@ ); alter table sys_logininfor add constraint pk_sys_logininfor 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'; @@ -914,6 +910,7 @@ -- ---------------------------- create table gen_table ( table_id number(20) not null, + data_name varchar2(200) default '', table_name varchar2(200) default '', table_comment varchar2(500) default '', sub_table_name varchar(64) default null, @@ -940,6 +937,7 @@ comment on table gen_table is '浠ｇ爜鐢熸垚涓氬姟琛�'; comment on column gen_table.table_id is '缂栧彿'; +comment on column gen_table.data_name is '鏁版嵁婧愬悕绉�'; comment on column gen_table.table_name is '琛ㄥ悕绉�'; comment on column gen_table.table_comment is '琛ㄦ弿杩�'; comment on column gen_table.sub_table_name is '鍏宠仈瀛愯〃鐨勮〃鍚�'; -- Gitblit v1.9.3