| | |
| | | |
| | | 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`; |
| | | 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 '关联的记录id'; |
| | | 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 '资源类型,例如JPG图片的资源类型为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 '资源尺寸(字节)'; |