From 173f44a1f9a59509996192e3446cbd26f2613b5e Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 10 十月 2025 15:55:32 +0800
Subject: [PATCH] yys 新增关键煤种锁仓模块
---
ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003427__create_table_storage_blob.sql | 36 +++++++++++++++++++++++++-----------
1 files changed, 25 insertions(+), 11 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..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
@@ -2,19 +2,33 @@
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,
+ 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.filename 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