4dkankan-center-manage/doc/2.sql

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `ry_id_index`(`ry_id`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `ry_no_index`(`ry_no`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `phone_index`(`phone`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `id_card_index`(`id_card`, `rec_status`) USING HASH;


DELETE FROM sys_user WHERE rec_status != 'A';

ALTER TABLE `4dkankan_v4`.`sys_user`
    ADD UNIQUE INDEX `user_name_index`(`user_name`, `rec_status`) USING HASH;

DELETE FROM t_user WHERE rec_status != 'A';

ALTER TABLE `4dkankan_v4`.`t_user`
    ADD UNIQUE INDEX `user_name_index`(`user_name`, `rec_status`) USING HASH;