ALTER TABLE `security_good_thing`
ADD COLUMN `goodDeedsType`  varchar(4) NULL COMMENT '好人好事类型' AFTER `goodDeedsId`;


INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '01', '见义勇为', '1');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '02', '尊老爱幼', '2');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '03', ' 爱岗敬业', '3');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '04', '孝顺爱亲', '4');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '05', '拾金不昧', '5');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '06', '爱国爱党', '6');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '07', '保护环境', '7');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '08', '勤俭节约', '8');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '09', ' 助人为乐', '9');
INSERT INTO sys_dict (`isActive`, `codeType`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'goodDeedsType', '好人好事类型', '99', '其他', '10');