Created
May 6, 2015 01:13
-
-
Save milhomem/3e917f1b8ec2fecb2c90 to your computer and use it in GitHub Desktop.
Associate google account OAuth with existing gerrit account
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- SELECT OLD AND NEW INFORMATION IF EMAIL ARE THE SAME | |
select * from account_external_ids where EMAIL_ADDRESS = 'XXXXX@XXXX'; | |
-- NEW ID | |
delete from account_external_ids where account_id= NEW_ID; | |
delete from accounts where ACCOUNT_ID= NEW_ID; | |
-- OLD ID | |
INSERT INTO account_external_ids values (OLD_ID, 'XXXXX@XXXX'', NULL, OAUTH_IDENTIFIER); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment