From 3eb812d9afc90e909a52eae85b3a31eedaf684bc Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期五, 30 五月 2025 16:16:59 +0800
Subject: [PATCH] 修复

---
 ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql |   18 +++++++++++-------
 1 files changed, 11 insertions(+), 7 deletions(-)

diff --git a/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql
index 05cf963..d1ad350 100644
--- a/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql
+++ b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql
@@ -2,12 +2,14 @@
 
 CREATE TABLE storage_blob
 (
-    id           bigserial PRIMARY KEY,
-    created_at   timestamp    default now() NOT NULL,
-    key          varchar(150) DEFAULT ''    NOT NULL,
-    content_type varchar(100) DEFAULT ''    NOT NULL,
-    filename     varchar(255) DEFAULT ''    NOT NULL,
-    byte_size    bigint       DEFAULT 0     NOT NULL,
+    id                bigserial PRIMARY KEY,
+    create_time        timestamp    default now() NOT NULL,
+    key               varchar(150) DEFAULT ''    NOT NULL,
+    content_type      varchar(100) DEFAULT ''    NOT NULL,
+    original_filename varchar(255) DEFAULT ''    NOT NULL,
+    bucket_filename   varchar(255) DEFAULT ''    NOT NULL,
+    bucket_name       varchar(255) DEFAULT ''    NOT NULL,
+    byte_size         bigint       DEFAULT 0     NOT NULL,
     UNIQUE (key)
 );
 
@@ -15,6 +17,8 @@
 
 COMMENT ON COLUMN storage_blob.key IS '璧勬簮id';
 COMMENT ON COLUMN storage_blob.content_type IS '璧勬簮绫诲瀷锛屼緥濡侸PG鍥剧墖鐨勮祫婧愮被鍨嬩负image/jpg';
-COMMENT ON COLUMN storage_blob.filename IS '鏂囦欢鍚�';
+COMMENT ON COLUMN storage_blob.original_filename IS '鍘熸枃浠跺悕绉�';
+COMMENT ON COLUMN storage_blob.bucket_filename IS '瀛樺偍妗朵腑鏂囦欢鍚�';
+COMMENT ON COLUMN storage_blob.bucket_name IS '瀛樺偍妗跺悕';
 COMMENT ON COLUMN storage_blob.byte_size IS '璧勬簮灏哄(瀛楄妭)';
 

--
Gitblit v1.9.3