From 40e4ce58f634598fafd205dfe54cb90e8b63b6f2 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期五, 20 六月 2025 17:30:15 +0800
Subject: [PATCH] 生产加工
---
ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql | 26 ++++++++++++++++++--------
1 files changed, 18 insertions(+), 8 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 d1ad350..223074b 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
@@ -3,22 +3,32 @@
CREATE TABLE storage_blob
(
id bigserial PRIMARY KEY,
- create_time timestamp default now() NOT NULL,
+ 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,
+ type varchar(150),
UNIQUE (key)
);
-COMMENT ON TABLE storage_blob IS '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+COMMENT
+ON TABLE storage_blob IS '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
-COMMENT ON COLUMN storage_blob.key IS '璧勬簮id';
-COMMENT ON COLUMN storage_blob.content_type IS '璧勬簮绫诲瀷锛屼緥濡侸PG鍥剧墖鐨勮祫婧愮被鍨嬩负image/jpg';
-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 '璧勬簮灏哄(瀛楄妭)';
+COMMENT
+ON COLUMN storage_blob.key IS '璧勬簮id';
+COMMENT
+ON COLUMN storage_blob.content_type IS '璧勬簮绫诲瀷锛屼緥濡侸PG鍥剧墖鐨勮祫婧愮被鍨嬩负image/jpg';
+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 '璧勬簮灏哄(瀛楄妭)';
+COMMENT
+ON COLUMN storage_blob.type IS '0鐢熶骇鍓� 1鐢熶骇鍚� 2鐢熶骇闂';
--
Gitblit v1.9.3