ALTER TABLE `security_person` ADD COLUMN `zgtraincompanyno` varchar(20) NULL AFTER `traintime`, ADD COLUMN `zgtraincompanyname` varchar(50) NULL COMMENT '资格证培训单位名称' AFTER `zgtraincompanyno`, ADD COLUMN `zgtraintime` varchar(16) NULL COMMENT '资格证培训时间' AFTER `zgtraincompanyname`, ADD COLUMN `zgcredential` varchar(50) NULL COMMENT '资格证书号' AFTER `zgtraintime`, ADD COLUMN `zgcertificatejgno` varchar(20) NULL COMMENT '资格发证机关编号' AFTER `zgcredential`, ADD COLUMN `zgcertificatejgname` varchar(50) NULL COMMENT '资格发证机关名称' AFTER `zgcertificatejgno`, ADD COLUMN `zgcertificatejgtime` varchar(16) NULL COMMENT '资格发证日期' AFTER `zgcertificatejgname`;