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/V20250525003447__create_table_storage_attachment.sql | 22 +++++++++++-----------
1 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003447__create_table_storage_attachment.sql b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003447__create_table_storage_attachment.sql
index d743faa..98a73de 100644
--- a/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003447__create_table_storage_attachment.sql
+++ b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250525003447__create_table_storage_attachment.sql
@@ -2,24 +2,24 @@
-- 闄勪欢琛�
-- ----------------------------
drop table if exists storage_attachment;
-CREATE TABLE storage_attachments
+CREATE TABLE storage_attachment
(
id bigserial PRIMARY KEY,
- created_at timestamp default now() NOT NULL,
- updated_at timestamp default now() NOT NULL,
- deleted_at bigint DEFAULT 0 NOT NULL,
+ create_time timestamp default now() NOT NULL,
+ update_time timestamp default now() NOT NULL,
+ deleted bigint DEFAULT 0 NOT NULL,
record_type smallint DEFAULT 0 NOT NULL,
record_id bigint DEFAULT 0 NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
storage_blob_id bigint DEFAULT 0 NOT NULL
);
-COMMENT ON TABLE storage_attachments IS '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+COMMENT ON TABLE storage_attachment IS '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
-COMMENT ON COLUMN storage_attachments.record_type IS '鍏宠仈鐨勮褰曠被鍨�';
-COMMENT ON COLUMN storage_attachments.record_id IS '鍏宠仈鐨勮褰昳d';
-COMMENT ON COLUMN storage_attachments.name IS '鍚嶇О, 濡�: file, avatar (鍖哄垎鍚屼竴鏉¤褰曚笉鍚岀被鍨嬬殑闄勪欢)';
-COMMENT ON COLUMN storage_attachments.storage_blob_id IS '鍏宠仈storage_blob璁板綍id';
+COMMENT ON COLUMN storage_attachment.record_type IS '鍏宠仈鐨勮褰曠被鍨�';
+COMMENT ON COLUMN storage_attachment.record_id IS '鍏宠仈鐨勮褰昳d';
+COMMENT ON COLUMN storage_attachment.name IS '鍚嶇О, 濡�: file, avatar (鍖哄垎鍚屼竴鏉¤褰曚笉鍚岀被鍨嬬殑闄勪欢)';
+COMMENT ON COLUMN storage_attachment.storage_blob_id IS '鍏宠仈storage_blob璁板綍id';
-CREATE INDEX idx_storage_attachments_on_record
- ON storage_attachments (record_type, record_id);
\ No newline at end of file
+CREATE INDEX idx_storage_attachment_on_record
+ ON storage_attachment (record_type, record_id);
\ No newline at end of file
--
Gitblit v1.9.3