
ALTER TABLE `sb_personcertificate`
ADD COLUMN `residentType`  varchar(3) NULL COMMENT '户籍类型',
ADD COLUMN `residentPlaceType`  varchar(3) NULL COMMENT '户籍所在地类型',
ADD COLUMN `comContractId`  varchar(30) NULL COMMENT '合同ID';



delete from sys_dict where codeType='residentType';
INSERT INTO `sys_dict` (`sysDictId`, `isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES (null, '1', 'residentType', NULL, '户籍类型', '1', '农村', '1');
INSERT INTO `sys_dict` (`sysDictId`, `isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES (null, '1', 'residentType', NULL, '户籍类型', '2', '城镇', '2');



delete from sys_dict where codeType='residentPlaceType';
INSERT INTO `sys_dict` (`sysDictId`, `isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES (null, '1', 'residentPlaceType', NULL, '户籍所在地类型', '1', '本市', '1');
INSERT INTO `sys_dict` (`sysDictId`, `isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES (null, '1', 'residentPlaceType', NULL, '户籍所在地类型', '2', '外埠', '2');



