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