ALTER TABLE `sb_investor`
ADD COLUMN `huji` varchar(50) NULL COMMENT '户籍' AFTER `idCardType`;


ALTER TABLE `security_company`
ADD COLUMN `give_license_name` varchar(50) NULL COMMENT '发证机关名称' AFTER `public_security_license_number`,
ADD COLUMN `give_license_date` datetime NULL COMMENT '发证日期' AFTER `give_license_name`;

ALTER TABLE `sb_management_info`
ADD COLUMN `nation` varchar(50) NULL COMMENT '民族' AFTER `departName`,
ADD COLUMN `edu` varchar(50) NULL COMMENT '学历' AFTER `nation`,
ADD COLUMN `province` varchar(50) NULL COMMENT '省' AFTER `edu`,
ADD COLUMN `city` varchar(50) NULL COMMENT '市' AFTER `province`,
ADD COLUMN `district` varchar(50) NULL COMMENT '区' AFTER `city`,
ADD COLUMN `newaddress` varchar(255) NULL COMMENT '居住地址详细地址' AFTER `district`;


ALTER TABLE `sb_legalchange`
ADD COLUMN `giveLicenseDate`  varchar(50) NULL COMMENT '原发证日期' AFTER `cardState`,
ADD COLUMN `expireRemarks`  varchar(200) NULL COMMENT '到期换证备注' AFTER `giveLicenseDate`;

