From 17badd7ea4d77c0aafbdfa65e05743cb7856489c Mon Sep 17 00:00:00 2001
From: chenhj <chenhj@lunor.cn>
Date: 星期五, 30 五月 2025 14:40:58 +0800
Subject: [PATCH] Merge pull request 'chen' (#12) from chen into master

---
 ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql |   24 ++++++++++++++++++++++++
 1 files changed, 24 insertions(+), 0 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
new file mode 100644
index 0000000..d1ad350
--- /dev/null
+++ b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql
@@ -0,0 +1,24 @@
+DROP TABLE IF EXISTS storage_blob;
+
+CREATE TABLE storage_blob
+(
+    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)
+);
+
+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 '璧勬簮灏哄(瀛楄妭)';
+

--
Gitblit v1.9.3