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;