AHRS/sql/sqlManage/sqlManage.sql

/*
 数据库更新的sql语句跟随git进行提交。
 每次git更新之后，请务必仔细留意并阅读数据库更新脚本文档sqlManageUpdate.md
 */

/*
  ---------------------------------------------------------------------
  -- @author andy.wu
  -- @description 公共备注表(ahrs_public_notes)新增文件路径字段(attachment)
  -- @time 2023.2.20 16:07
  ---------------------------------------------------------------------
  alter table ahrs_public_notes
    add attachment varchar(255) comment '附件路径';

 */
/*
  ---------------------------------------------------------------------
  -- @author linian
  -- @description 修改招聘的学历、学位字典排序
  -- @time 2023.2.22 10:02
  ---------------------------------------------------------------------
  UPDATE sys_dict_data SET dict_sort = '1' WHERE dict_type = 'recruit_education' AND dict_value = '5';
  UPDATE sys_dict_data SET dict_sort = '2' WHERE dict_type = 'recruit_education' AND dict_value = '4';
  UPDATE sys_dict_data SET dict_sort = '3' WHERE dict_type = 'recruit_education' AND dict_value = '3';
  UPDATE sys_dict_data SET dict_sort = '4' WHERE dict_type = 'recruit_education' AND dict_value = '2';
  UPDATE sys_dict_data SET dict_sort = '5' WHERE dict_type = 'recruit_education' AND dict_value = '1';
  UPDATE sys_dict_data SET dict_sort = '6' WHERE dict_type = 'recruit_education' AND dict_value = '6';
  UPDATE sys_dict_data SET dict_sort = '7' WHERE dict_type = 'recruit_education' AND dict_value = '7';

  UPDATE sys_dict_data SET dict_sort = '0' WHERE dict_type = 'recruit_degree' AND dict_value = '5';
  UPDATE sys_dict_data SET dict_sort = '1' WHERE dict_type = 'recruit_degree' AND dict_value = '4';
  UPDATE sys_dict_data SET dict_sort = '2' WHERE dict_type = 'recruit_degree' AND dict_value = '3';
  UPDATE sys_dict_data SET dict_sort = '3' WHERE dict_type = 'recruit_degree' AND dict_value = '2';
  UPDATE sys_dict_data SET dict_sort = '4' WHERE dict_type = 'recruit_degree' AND dict_value = '1';
  UPDATE sys_dict_data SET dict_sort = '5' WHERE dict_type = 'recruit_degree' AND dict_value = '0';

 */

/*
  -----------------------------------------------------------------------
  -- @author andy.wu
  -- @description 调动信息表(ahrs_post_transfer)，新增人事综合管理部门意见(rszhgl_dept_comment)，新增调出单位意见(export_dept_comment)字段
  -- @time 2023.2.20 16:07
  -----------------------------------------------------------------------
 */
alter table ahrs_post_transfer
    add rszhgl_dept_comment varchar(255)  comment '人事综合管理部门意见';
alter table ahrs_post_transfer
    add export_dept_comment varchar(255)  comment '调出单位意见';