From ccd87b6ac99259a01b9099a4d570f6d9e7dbb506 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期五, 30 五月 2025 14:48:54 +0800 Subject: [PATCH] Merge branch 'master' of http://114.132.189.42:9002/r/zd-after into li --- 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