修改 externalId（externalId 和 accountId 不一致）
1. SSO 修改
1.1 查询
SELECT account_id, display_name, external_id FROM t_abs_sso_account WHERE account_id = 'zhex08330100019';1.2 查询结果
| account_id | display_name | external_id |
|---|---|---|
zhex08330100019 | 李寒浠 | 2089247411306360833 |
1.3 修改
UPDATE t_abs_sso_account SET external_id = 'zhex08330100019' WHERE account_id = 'zhex08330100019';2. 财险 HRMS 数据确认
SELECT * FROM outsourced_staff WHERE id = 'zhex08330100019';
SELECT * FROM outsourced_staff_movement WHERE account_id = 'zhex08330100019';
SELECT * FROM outsourced_staff_onoffboard_application_record WHERE account_id = '2089247411306360833';3. 财险 HRMS 修改
UPDATE outsourced_staff SET id = 'zhex08330100019' WHERE account_id = 'zhex08330100019';
UPDATE outsourced_staff_movement SET staff_id = 'zhex08330100019' WHERE account_id = 'zhex08330100019';
UPDATE outsourced_staff_onoffboard_application_record SET account_id = 'zhex08330100019' WHERE account_id = '2089247411306360833';4. 刷新缓存
在账号中心页面修改该账号的信息（例如账号有效期），保存后刷新缓存。
5. 回滚（保底）
5.1 SSO 回滚
UPDATE t_abs_sso_account SET external_id = '2089247411306360833' WHERE account_id = 'zhex08330100019';5.2 财险 HRMS 回滚
UPDATE outsourced_staff SET id = '2089247411306360833' WHERE account_id = 'zhex08330100019';
UPDATE outsourced_staff_movement SET staff_id = '2089247411306360833' WHERE account_id = 'zhex08330100019';
UPDATE outsourced_staff_onoffboard_application_record SET account_id = '2089247411306360833' WHERE account_id = 'zhex08330100019';5.3 刷新缓存
在账号中心页面修改该账号的信息（例如账号有效期），保存后刷新缓存。