From b289f4c1b1aeebf656dbe055e37be8490b8ecab9 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 26 八月 2022 14:54:31 +0800
Subject: [PATCH] update 优化 调整 oss表key 与 ossconfig的service 字段长度不匹配
---
script/sql/postgres/postgres_ry_vue_4.X.sql | 4 ++--
script/sql/sqlserver/sqlserver_ry_vue_4.X.sql | 4 ++--
script/sql/oracle/oracle_ry_vue_4.X.sql | 4 ++--
script/sql/ry_vue_4.X.sql | 4 ++--
4 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index ac8523d..ad3a442 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -874,7 +874,7 @@
original_name varchar(255) not null,
file_suffix varchar(10) not null,
url varchar(500) not null,
- service varchar(10) default 'minio' not null,
+ service varchar(20) default 'minio' not null,
create_by varchar(64) default '',
create_time date,
update_by varchar(64) default '',
@@ -901,7 +901,7 @@
-- ----------------------------
create table sys_oss_config (
oss_config_id number(20) not null,
- config_key varchar(255) not null,
+ config_key varchar(20) not null,
access_key varchar(255) default '',
secret_key varchar(255) default '',
bucket_name varchar(255) default '',
diff --git a/script/sql/postgres/postgres_ry_vue_4.X.sql b/script/sql/postgres/postgres_ry_vue_4.X.sql
index e529254..2983ea8 100644
--- a/script/sql/postgres/postgres_ry_vue_4.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_4.X.sql
@@ -891,7 +891,7 @@
create_time timestamp,
update_by varchar(64) default ''::varchar,
update_time timestamp,
- service varchar(10) default 'minio'::varchar,
+ service varchar(20) default 'minio'::varchar,
constraint sys_oss_pk primary key (oss_id)
);
@@ -914,7 +914,7 @@
create table if not exists sys_oss_config
(
oss_config_id int8,
- config_key varchar(255) default ''::varchar not null,
+ config_key varchar(20) default ''::varchar not null,
access_key varchar(255) default ''::varchar,
secret_key varchar(255) default ''::varchar,
bucket_name varchar(255) default ''::varchar,
diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql
index fbe9f79..8b1aa3e 100644
--- a/script/sql/ry_vue_4.X.sql
+++ b/script/sql/ry_vue_4.X.sql
@@ -655,7 +655,7 @@
create_by varchar(64) default '' comment '涓婁紶浜�',
update_time datetime default null comment '鏇存柊鏃堕棿',
update_by varchar(64) default '' comment '鏇存柊浜�',
- service varchar(10) not null default 'minio' comment '鏈嶅姟鍟�',
+ service varchar(20) not null default 'minio' comment '鏈嶅姟鍟�',
primary key (oss_id)
) engine=innodb comment ='OSS瀵硅薄瀛樺偍琛�';
@@ -665,7 +665,7 @@
drop table if exists sys_oss_config;
create table sys_oss_config (
oss_config_id bigint(20) not null comment '涓诲缓',
- config_key varchar(255) not null default '' comment '閰嶇疆key',
+ config_key varchar(20) not null default '' comment '閰嶇疆key',
access_key varchar(255) default '' comment 'accessKey',
secret_key varchar(255) default '' comment '绉橀挜',
bucket_name varchar(255) default '' comment '妗跺悕绉�',
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
index c27b1bd..8fbb2ba 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
@@ -2116,7 +2116,7 @@
[create_by] nvarchar(64) DEFAULT '' NULL,
[update_time] datetime2(7) NULL,
[update_by] nvarchar(64) DEFAULT '' NULL,
- [service] nvarchar(10) DEFAULT ('minio') NOT NULL,
+ [service] nvarchar(20) DEFAULT ('minio') NOT NULL,
CONSTRAINT [PK__sys_oss__91241EA442389F0D] PRIMARY KEY CLUSTERED ([oss_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
@@ -2193,7 +2193,7 @@
CREATE TABLE [sys_oss_config]
(
[oss_config_id] bigint NOT NULL,
- [config_key] nvarchar(255) DEFAULT '' NOT NULL,
+ [config_key] nvarchar(20) DEFAULT '' NOT NULL,
[access_key] nvarchar(255) DEFAULT '' NULL,
[secret_key] nvarchar(255) DEFAULT '' NULL,
[bucket_name] nvarchar(255) DEFAULT '' NULL,
--
Gitblit v1.9.3