

ALTER TABLE `yearreportdata`
ADD COLUMN `personnum` varchar(50) DEFAULT NULL COMMENT '保安人员数（排除 内勤人员）' AFTER `zc`,
ADD COLUMN `certificateCount` varchar(50) DEFAULT NULL COMMENT '保安人员资格证人数' AFTER `personnum`,
ADD COLUMN `cjnum` varchar(50) DEFAULT NULL COMMENT '初级保安员证人数' AFTER `certificateCount`,
ADD COLUMN `zjnum` varchar(50) DEFAULT NULL COMMENT '中级保安员证人数' AFTER `cjnum`,
ADD COLUMN `gjnum` varchar(50) DEFAULT NULL COMMENT '高级保安员证人数' AFTER `zjnum`,
ADD COLUMN `managernum` varchar(50) DEFAULT NULL COMMENT '保安管理师证人数' AFTER `gjnum`,
ADD COLUMN `gjmanagernum` varchar(50) DEFAULT NULL COMMENT '高级保安管理师证人数' AFTER `managernum`,
ADD COLUMN `malenum`  varchar(50) NULL COMMENT '男总数' AFTER `gjmanagernum`,
ADD COLUMN `femalenum`  varchar(50) NULL COMMENT '保安人员女数' AFTER `malenum`,
ADD COLUMN `escortnum`  varchar(50) NULL COMMENT '武装押运人员人数' AFTER `femalenum`,
ADD COLUMN `armnum`  varchar(50) NULL COMMENT '持抢证人员人数' AFTER `escortnum`,

ADD COLUMN `approvalCount`  varchar(50) NULL COMMENT '备案总数' AFTER `armnum`,
ADD COLUMN `personcertificateCount`  varchar(50) NULL COMMENT '保安员资格证报名' AFTER `approvalCount`,
ADD COLUMN `crosscompanyCount`  varchar(50) NULL COMMENT '保安员跨区域服务备案' AFTER `personcertificateCount`,
ADD COLUMN `subsidiaryCount`  varchar(50) NULL COMMENT '设立分公司备案' AFTER `crosscompanyCount`,
ADD COLUMN `traincompanyCount`  varchar(50) NULL COMMENT '设立保安培训单位许可' AFTER `subsidiaryCount`,
ADD COLUMN `legalchangeCount`  varchar(50) NULL COMMENT '保安服务（培训）许可证项目变更审批' AFTER `traincompanyCount`,
ADD COLUMN `taskTotal`  varchar(50) NULL COMMENT '任务总数' AFTER `legalchangeCount`,
ADD COLUMN `cycleCount`  varchar(50) NULL COMMENT '周期任务' AFTER `taskTotal`,
ADD COLUMN `temporaryCount`  varchar(50) NULL COMMENT '临时任务' AFTER `cycleCount`,
ADD COLUMN `urgentCount`  varchar(50) NULL COMMENT '紧急任务' AFTER `temporaryCount`,
ADD COLUMN `personCount`  varchar(50) NULL COMMENT '总人数' AFTER `urgentCount`,
ADD COLUMN `initCount`  varchar(50) NULL COMMENT '基本信息完成人数' AFTER `personCount`,
ADD COLUMN `authCount`  varchar(50) NULL COMMENT '身份验证通过人数' AFTER `initCount`,
ADD COLUMN `unAuthCount`  varchar(50) NULL COMMENT '身份验证不通过人数' AFTER `authCount`,
ADD COLUMN `baseInfo`  varchar(50) NULL COMMENT '单位基本信息' AFTER `unAuthCount`,
ADD COLUMN `investor`  varchar(50) NULL COMMENT '出资人信息' AFTER `baseInfo`,
ADD COLUMN `management`  varchar(50) NULL COMMENT '管理层信息' AFTER `investor`,
ADD COLUMN `branch`  varchar(50) NULL COMMENT '分公司信息' AFTER `management`,
ADD COLUMN `serviceHt`  varchar(50) NULL COMMENT '服务合同信息' AFTER `branch`,
ADD COLUMN `device`  varchar(50) NULL COMMENT '车辆/枪支/技防设备信息' AFTER `serviceHt`,
ADD COLUMN `laborHt`  varchar(50) NULL COMMENT '劳动合同信息' AFTER `device`,

ADD COLUMN `policyCount`  varchar(50) NULL COMMENT '已购团意险人数' AFTER `laborHt`,
ADD COLUMN `unPolicyCount`  varchar(50) NULL COMMENT '未购团意险人数' AFTER `policyCount`,
ADD COLUMN `quotaCount`  varchar(50) NULL COMMENT '足额人数' AFTER `unPolicyCount`,
ADD COLUMN `unQuotaCount`  varchar(50) NULL COMMENT '不足额人数' AFTER `quotaCount`,

ADD COLUMN `approvalstate` varchar(50) NULL COMMENT '审批状态' AFTER `unQuotaCount`,
ADD COLUMN `approvalperson` varchar(50) NULL COMMENT '审批人' AFTER `approvalstate`,
ADD COLUMN `approvaldate` datetime NULL COMMENT '审批日期' AFTER `approvalperson`,
ADD COLUMN `approvalreason` varchar(500) NULL COMMENT '审批意见' AFTER `approvaldate`,
ADD COLUMN `approvalfile` varchar(500) NULL COMMENT '审批意见文件' AFTER `approvalreason`;

ADD COLUMN `filingIsStamped` BIT(1) NULL COMMENT '备案是否盖章确认' AFTER `device`;
ADD COLUMN `filingIsPassed` BIT(1) NULL COMMENT '备案是否通过' AFTER `filingIsStamped`;
ADD COLUMN `filingYear` varchar(255) NULL COMMENT '备案年份' AFTER `filingIsPassed`;
ADD COLUMN `companyName` varchar(255) NULL COMMENT '公司名字' AFTER `approvalfile`;
ADD COLUMN `areaCode` varchar(255) NULL COMMENT '区域代码' AFTER `companyName`;




