UPDATE t_user
SET USEIM = IF(ASCII(USEIM) = '1' OR USEIM = '1',1,0),
    TELEPHONEPUBLIC = IF(ASCII(TELEPHONEPUBLIC) = '1' OR TELEPHONEPUBLIC = '1',1,0),
    TELEPHONEPUBLIC2 = IF(ASCII(TELEPHONEPUBLIC2) = '1' OR TELEPHONEPUBLIC2 = '1',1,0),
    EMAILPUBLIC = IF(ASCII(EMAILPUBLIC) = '1' OR EMAILPUBLIC = '1',1,0),
    USERINFOPUBLIC = IF(ASCII(USERINFOPUBLIC) = '1' OR USERINFOPUBLIC = '1',1,0),
    LIAISON_OFFICER = IF(ASCII(LIAISON_OFFICER) = '1' OR LIAISON_OFFICER = '1',1,0)
-- WHERE ID = 'p1Dg0Qvs'
;


ALTER TABLE `t_user`
    MODIFY COLUMN `USEIM` bit(1) NULL DEFAULT NULL COMMENT '是否使用及时通讯',
    MODIFY COLUMN `TELEPHONEPUBLIC` bit(1) NULL DEFAULT NULL COMMENT '手机是否公开',
    MODIFY COLUMN `TELEPHONEPUBLIC2` bit(1) NULL DEFAULT NULL COMMENT '手机 2 是否公开',
    MODIFY COLUMN `EMAILPUBLIC` bit(1) NULL DEFAULT NULL COMMENT '邮件是否公开',
    MODIFY COLUMN `USERINFOPUBLIC` bit(1) NULL DEFAULT NULL COMMENT '受保护信息是否在通信录公开',
    MODIFY COLUMN `LIAISON_OFFICER` bit(1) NULL DEFAULT NULL COMMENT '是否部门接口人'
;