-- 文档管理
ALTER TABLE `inspection-report`.`b_inspection_document`
    ADD column fileSize varchar(50) DEFAULT NULL COMMENT '文件大小';

ALTER TABLE `inspection-report`.`b_inspection_document`
    ADD COLUMN `status` int(1) DEFAULT '0' COMMENT '删除状态 0 正常，1删除，默认0';

ALTER TABLE `inspection-report`.`b_insepectionreport_type`
    ADD COLUMN `status` int(1) DEFAULT '0' COMMENT '删除状态 0 正常，1删除，默认0';

-- 授权所有type
INSERT INTO b_inspection_document_auth ( id, docId, userName, roleId ) SELECT UUID( ), id, 'admin' AS userName, '' AS roleId  FROM b_insepectionreport_type;
INSERT INTO b_inspection_document_auth ( id, docId, userName, roleId ) SELECT UUID( ), id, 'admin' AS userName, '' AS roleId  FROM b_insepectionreport_document;