From 3f76740d3a61230d80546f659102267315ef9f22 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期二, 08 七月 2025 11:07:39 +0800
Subject: [PATCH] 2025-07-08 配置文件更新
---
doc/add.sql | 50 +++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 49 insertions(+), 1 deletions(-)
diff --git a/doc/add.sql b/doc/add.sql
index 35b95ae..8902911 100644
--- a/doc/add.sql
+++ b/doc/add.sql
@@ -81,4 +81,52 @@
ALTER TABLE `product-inventory-management`.`device_maintenance`
ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`,
- ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`;
\ No newline at end of file
+ ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`;
+
+
+
+DROP TABLE IF EXISTS storage_attachment;
+CREATE TABLE storage_attachment (
+ id BIGINT AUTO_INCREMENT PRIMARY KEY,
+ create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+ update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP 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='閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+
+ALTER TABLE storage_attachment
+ COMMENT '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+
+ALTER TABLE storage_attachment MODIFY record_type SMALLINT COMMENT '鍏宠仈鐨勮褰曠被鍨�';
+ALTER TABLE storage_attachment MODIFY record_id BIGINT COMMENT '鍏宠仈鐨勮褰昳d';
+ALTER TABLE storage_attachment MODIFY name VARCHAR(100) COMMENT '鍚嶇О, 濡�: file, avatar (鍖哄垎鍚屼竴鏉¤褰曚笉鍚岀被鍨嬬殑闄勪欢)';
+ALTER TABLE storage_attachment MODIFY storage_blob_id BIGINT COMMENT '鍏宠仈storage_blob璁板綍id';
+
+CREATE INDEX idx_storage_attachment_on_record
+ ON storage_attachment (record_type, record_id);
+
+
+CREATE TABLE storage_blob (
+ id BIGINT AUTO_INCREMENT PRIMARY KEY,
+ create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+ key_name 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_name)
+) COMMENT='閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+
+ALTER TABLE storage_blob
+ COMMENT '閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�';
+
+ALTER TABLE storage_blob MODIFY key_name VARCHAR(150) COMMENT '璧勬簮id';
+ALTER TABLE storage_blob MODIFY content_type VARCHAR(100) COMMENT '璧勬簮绫诲瀷锛屼緥濡侸PG鍥剧墖鐨勮祫婧愮被鍨嬩负image/jpg';
+ALTER TABLE storage_blob MODIFY original_filename VARCHAR(255) COMMENT '鍘熸枃浠跺悕绉�';
+ALTER TABLE storage_blob MODIFY bucket_filename VARCHAR(255) COMMENT '瀛樺偍妗朵腑鏂囦欢鍚�';
+ALTER TABLE storage_blob MODIFY bucket_name VARCHAR(255) COMMENT '瀛樺偍妗跺悕';
+ALTER TABLE storage_blob MODIFY byte_size BIGINT COMMENT '璧勬簮灏哄(瀛楄妭)';
--
Gitblit v1.9.3