From 4bc6459d779256b233084fc9142296e79667a951 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期二, 03 六月 2025 17:25:01 +0800
Subject: [PATCH] 1.主营业务模块添加 2.采购登记
---
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