ALTER TABLE `yearreportdata`
ADD COLUMN `lineInsure`  bit NULL COMMENT '是否线下投保' AFTER `approvalstate`,
ADD COLUMN `szss`  varchar(500) NULL COMMENT '所在地省市县（区）' AFTER `lineInsure`,
ADD COLUMN `province`  varchar(500) NULL COMMENT '所在地省代码' AFTER `szss`,
ADD COLUMN `city`  varchar(500) NULL COMMENT '所在地市代码' AFTER `province`,
ADD COLUMN `district`  varchar(500) NULL COMMENT '所在地县（区）代码' AFTER `city`;

update yearreportdata set lineInsure = true where id in (
select yearReportId from sb_yearreport_insurance where active = true);