ALTER TABLE `security_person`
ADD COLUMN `entrydate`  datetime NULL COMMENT '入职日期' AFTER `sfcq`,
ADD COLUMN `signdate`  datetime NULL COMMENT '签订日期' AFTER `entrydate`,
ADD COLUMN `htstartdate`  datetime NULL COMMENT '开始日期' AFTER `signdate`,
ADD COLUMN `htenddate`  datetime NULL COMMENT '结束日期' AFTER `htstartdate`,
ADD COLUMN `htLife`  varchar(6) NULL COMMENT '合同年限' AFTER `htenddate`,
ADD COLUMN `htbh`  varchar(20) NULL COMMENT '合同编号' AFTER `htLife`,
ADD COLUMN `htstate`  varchar(20) NULL COMMENT '合同状态' AFTER `htbh`;