From 8a4d8e070f32da6fb52aebb5ed5af7b7b7e52e6d Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期四, 10 七月 2025 13:52:52 +0800
Subject: [PATCH] 导出sql修改

---
 doc/add.sql |   56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 56 insertions(+), 0 deletions(-)

diff --git a/doc/add.sql b/doc/add.sql
index 2d53f4a..8902911 100644
--- a/doc/add.sql
+++ b/doc/add.sql
@@ -74,3 +74,59 @@
 alter table product_record
     add 鍒梍name int null comment 'sale_ledger_projectI_id';
 
+# 娣诲姞璁惧鍚嶇О鍜岃鏍煎瀷鍙�
+ALTER TABLE `product-inventory-management`.`device_repair`
+    ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`,
+    ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`;
+
+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`;
+
+
+
+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