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