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