-- 专家简历表增加专家奶浴,任务报价字段 ALTER TABLE `risk_expertcheckinfo` ADD COLUMN `expertSource` varchar(50) NULL COMMENT '专家来源:public,private' AFTER `level`; ALTER TABLE `risk_expertcheckinfo` ADD COLUMN `taskQuote` varchar(50) NULL COMMENT '任务报价' AFTER `expertSource`; -- 修改历史数据 update `risk_expertcheckinfo` set expertSource='private'; -- 专家用户表增加专家奶浴,专家等级,任务报价字段 ALTER TABLE `risk_expertuser` ADD COLUMN `expertSource` varchar(50) NULL COMMENT '专家来源:public,private' AFTER `personAchievement`; ALTER TABLE `risk_expertuser` ADD COLUMN `level` varchar(50) NULL COMMENT '专家等级' AFTER `expertSource`; ALTER TABLE `risk_expertuser` ADD COLUMN `taskQuote` varchar(50) NULL COMMENT '任务报价' AFTER `level`; -- 修改历史数据 update `risk_expertuser` set expertSource='private'; update risk_expertuser set level='1' where expertCategory='初级'; update risk_expertuser set level='2' where expertCategory='中级'; update risk_expertuser set level='3' where expertCategory='高级'; -- 新增数据字典 insert into sys_dict(description,label,sort,type,value) values('报告撰写状态','待专家接单','7','REPORTSUBSTATUS','40'); insert into sys_dict(description,label,sort,type,value) values('报告撰写状态','专家已拒绝','8','REPORTSUBSTATUS','41'); insert into sys_dict(description,label,sort,type,value) values('任务状态','待接单','12','TASKSTATUS','6'); insert into sys_dict(description,label,sort,type,value) values('任务状态','已拒绝','13','TASKSTATUS','7'); -- 新增共享专家订单表 CREATE TABLE `risk_expertorderform_public` ( `oid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `activityId` bigint(20) DEFAULT NULL, `orgId` bigint(20) DEFAULT NULL, `orderNo` varchar(50) DEFAULT NULL, `reportId` bigint(20) DEFAULT NULL, `taskId` bigint(20) DEFAULT NULL, `taskType` varchar(255) DEFAULT NULL COMMENT '任务类型', `userId` bigint(20) DEFAULT NULL COMMENT '专家id', `taskQuote` varchar(50) DEFAULT NULL COMMENT '任务报价', `taskStatus` varchar(50) DEFAULT NULL COMMENT '任务状态', `expertSource` varchar(50) DEFAULT NULL COMMENT '专家来源', `createOn` datetime DEFAULT NULL, `updateOn` datetime DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='共享专家订单';