From f2892a672a495a78562836561f51a2a274cd16aa Mon Sep 17 00:00:00 2001 From: WangBQ <wangbinglilac@sina.com> Date: 星期一, 29 五月 2023 10:26:10 +0800 Subject: [PATCH] !349 代码生成 从对应数据源加载表结构信息 存储到主数据源 实现存储统一 * 数据库脚本修改，gen_table增加data_name字段，存储对应数据源名称 * 代码生成 从对应数据源加载表结构信息 存储到主数据源 实现存储统一(表结构需要增加对应的数据来源字段) https://gitee.com/… --- script/sql/oracle/oracle_ry_vue_5.X.sql | 12 +++++++----- 1 files changed, 7 insertions(+), 5 deletions(-) diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql index 78ceb59..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 '鏃ュ織涓婚敭'; @@ -848,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'; @@ -910,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, @@ -936,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