ALTER TABLE `risk_serviceorg`
ADD COLUMN `syncSP`  varchar(20) NULL COMMENT '是否已同步审批系统' AFTER `minQuote`;

update risk_serviceorg set syncSP = 0;


ALTER TABLE `risk_activity`
ADD COLUMN `sbApprovalStatus`  varchar(100) NULL COMMENT '申报系统的审批状态，仅供客服人员查看，不参与业务逻辑处理' AFTER `approvalContent`;


update risk_composeframe set type = 100008 where type = 100004;
update risk_composeframe set type = 100004 where type = 100006;
update risk_composeframe set type = 100006 where type = 100008;




#预生产要加
ALTER TABLE `risk_tips`
ADD COLUMN `createOn`  datetime NULL AFTER `tips`,
ADD COLUMN `updateOn`  datetime NULL AFTER `createOn`;


update sys_dict set value = 100008 where value = 100004 and type = 'COMPOSEFRAMETYPE';
update sys_dict set value = 100004 where value = 100006 and type = 'COMPOSEFRAMETYPE';
update sys_dict set value = 100006 where value = 100008 and type = 'COMPOSEFRAMETYPE';