credit-rating/zksy-common/sql/libin.sql

ALTER TABLE `taojianggonghui`.`gh_difficult_help_file`
ADD COLUMN `material_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '材料id' AFTER `update_time`;


---2022/5/14 已执行
ALTER TABLE `taojianggonghui`.`gh_difficult_workers`
MODIFY COLUMN `approve_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核人' AFTER `create_name`;

---2022/5/19 已执行
ALTER TABLE `taojianggonghui`.`gh_activity_register`
ADD COLUMN `p_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父ID' AFTER `age`;
----2022/5/25 已执行
ALTER TABLE `taojianggonghui`.`gh_model_worker`
ADD COLUMN `medical_insurance` varchar(2)  COMMENT '医保类型（字典）' AFTER `unit_nature`;
----2022/5/24 已执行
ALTER TABLE `taojianggonghui`.`gh_model_worker`
ADD UNIQUE INDEX `unique_cardnum_deptid`(`card_num`, `dept_id`) USING BTREE;
--------2022/5/25 已执行
ALTER TABLE `taojianggonghui`.`gh_difficult_workers`
ADD UNIQUE INDEX `unique_cardNum_deptID_DIFF`(`dept_id`, `card_num`) USING BTREE;