From 15f7a7db6562960741afe4bc525dfdbeaa01460d Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 17 六月 2022 10:23:40 +0800
Subject: [PATCH] fix 修复 代码生成表字段类型不匹配 导致查询不准确问题
---
script/sql/sqlserver/sqlserver_ry_vue_4.X.sql | 2 +-
script/sql/update/oracle/update-4.1-4.2.sql | 2 ++
script/sql/update/sqlserver/update-4.1-4.2.sql | 3 +++
script/sql/oracle/oracle_ry_vue_4.X.sql | 2 +-
script/sql/ry_vue_4.X.sql | 2 +-
script/sql/update/update-4.1-4.2.sql | 1 +
6 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index b32a02e..eabf919 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -812,7 +812,7 @@
-- ----------------------------
create table gen_table_column (
column_id number(20) not null,
- table_id varchar2(64),
+ table_id number(20),
column_name varchar2(200),
column_comment varchar2(500),
column_type varchar2(100),
diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql
index 9455274..07fe33e 100644
--- a/script/sql/ry_vue_4.X.sql
+++ b/script/sql/ry_vue_4.X.sql
@@ -614,7 +614,7 @@
drop table if exists gen_table_column;
create table gen_table_column (
column_id bigint(20) not null comment '缂栧彿',
- table_id varchar(64) comment '褰掑睘琛ㄧ紪鍙�',
+ table_id bigint(20) comment '褰掑睘琛ㄧ紪鍙�',
column_name varchar(200) comment '鍒楀悕绉�',
column_comment varchar(500) comment '鍒楁弿杩�',
column_type varchar(100) comment '鍒楃被鍨�',
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
index df36ecc..97b8be1 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
@@ -157,7 +157,7 @@
CREATE TABLE [gen_table_column]
(
[column_id] bigint NOT NULL,
- [table_id] nvarchar(64) NULL,
+ [table_id] bigint NULL,
[column_name] nvarchar(200) NULL,
[column_comment] nvarchar(500) NULL,
[column_type] nvarchar(100) NULL,
diff --git a/script/sql/update/oracle/update-4.1-4.2.sql b/script/sql/update/oracle/update-4.1-4.2.sql
index 9471490..a4cbf24 100644
--- a/script/sql/update/oracle/update-4.1-4.2.sql
+++ b/script/sql/update/oracle/update-4.1-4.2.sql
@@ -8,3 +8,5 @@
update sys_oss_config set endpoint = 'cos.ap-beijing.myqcloud.com' where oss_config_id = 4;
insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', 'N', '', '1', '', NULL, 'admin', sysdate, 'admin', sysdate, '');
+
+ALTER TABLE "GEN_TABLE_COLUMN" MODIFY ("TABLE_ID" NUMBER(20,0));
diff --git a/script/sql/update/sqlserver/update-4.1-4.2.sql b/script/sql/update/sqlserver/update-4.1-4.2.sql
index 414917f..9e217ec 100644
--- a/script/sql/update/sqlserver/update-4.1-4.2.sql
+++ b/script/sql/update/sqlserver/update-4.1-4.2.sql
@@ -22,3 +22,6 @@
INSERT INTO [sys_oss_config] ([oss_config_id], [config_key], [access_key], [secret_key], [bucket_name], [prefix], [endpoint], [domain], [is_https], [region], [status], [ext1], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'image', N'ruoyi', N'ruoyi123', N'ruoyi', N'image', N'127.0.0.1:9000', N'',N'N', N'', N'1', N'', N'admin', getdate(), N'admin', getdate(), NULL)
GO
+
+ALTER TABLE [gen_table_column] ALTER COLUMN [table_id] bigint NULL
+GO
diff --git a/script/sql/update/update-4.1-4.2.sql b/script/sql/update/update-4.1-4.2.sql
index 2f4f3bd..2d47677 100644
--- a/script/sql/update/update-4.1-4.2.sql
+++ b/script/sql/update/update-4.1-4.2.sql
@@ -7,3 +7,4 @@
insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', 'N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL, '');
+alter table gen_table_column modify column table_id bigint(0) null default null COMMENT '褰掑睘琛ㄧ紪鍙�';
--
Gitblit v1.9.3