-- 文档管理 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;