railway-prod2/sql/2022.5.sql

ALTER TABLE `bus_jcb_blq`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' AFTER `sbzt_desc`,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `check_user`,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_dmcgyq`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' ,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' ,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_fdfxjyq`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' AFTER `sbzt_desc`,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `check_user`,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_glkg`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' AFTER `sbzt_desc`,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `check_user`,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_jcxc`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' ,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' ,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_qmjcjl`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' ,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' ,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;

ALTER TABLE `bus_jcb_wjcxc`
    MODIFY COLUMN `check_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查人' ,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' ,
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`;



ALTER TABLE `bus_jceb_fzswjfxc`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;

ALTER TABLE `bus_jceb_gjsfx`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;

ALTER TABLE `bus_jceb_jddz`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;

ALTER TABLE `bus_jceb_jyzqsjl`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;

ALTER TABLE `bus_jceb_lbjghjl`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;

ALTER TABLE `bus_jceb_qmjcjl`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人' ,
    MODIFY COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人';

ALTER TABLE `bus_jceb_xsjcjl`
    MODIFY COLUMN `operator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测人',
    ADD COLUMN `confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认人' AFTER `operator`;


ALTER TABLE `bus_jcb_blq`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_dmcgyq`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_fdfxjyq`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_glkg`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_jcxc`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_qmjcjl`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;

ALTER TABLE `bus_jcb_wjcxc`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;


ALTER TABLE `bus_jceb_fzswjfxc`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_gjsfx`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_jddz`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_jyzqsjl`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_lbjghjl`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_qmjcjl`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;

ALTER TABLE `bus_jceb_xsjcjl`
    ADD COLUMN `confirm_date` date NULL DEFAULT NULL COMMENT '确认日期' AFTER `confirm_user`;


ALTER TABLE `bus_jceb_fzswjfxc`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_gjsfx`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_jddz`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_jyzqsjl`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_lbjghjl`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_qmjcjl`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;
ALTER TABLE `bus_jceb_xsjcjl`
    ADD COLUMN `center_confirm_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中心领导确认人' AFTER `confirm_user`,
ADD COLUMN `center_confirm_date` date NULL DEFAULT NULL COMMENT '中心领导确认日期' AFTER `center_confirm_user`;