-- 增加加密身份证号列和加密移动电话列
ALTER TABLE  `risk_se_user`
    ADD COLUMN `encryptIdentifyNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' AFTER `zwId`;
ALTER TABLE `risk_se_user`
    ADD COLUMN `encryptMobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '移动电话' AFTER `encryptIdentifyNumber`;
update  `risk_se_user`  set encryptIdentifyNumber=(HEX(AES_ENCRYPT(username,'183954'))) ;
update  `risk_se_user`  set encryptMobile=(HEX(AES_ENCRYPT(phone,'183954'))) ;
-- 修改用户密码为Bcx@666666
UPDATE `risk_se_user` SET `password` = '$2a$10$rF6flfRwmY7o662hN0ufpOnZ9xq9RyQm0pVuHt3qZb/WzOQ0gKc9C';
-- admin改为bcxadmin
UPDATE `risk_se_user` SET `userName` = 'bcxadmin' WHERE `userName` = 'admin';

-- 审计日志开关
INSERT INTO `config_systemconfig`(`oid`, `createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES (NULL, NULL, NULL, 'switch_auditLog', 'on', NULL);