fix_gerrit_ldap_user_with_dot.sql

delimiter #

create trigger fix_dot_account_external_ids after insert on account_external_ids
for each row
begin
  SET @external_id = NEW.external_id;
  if @external_id like 'gerrit:*' then
    SET @new_external_id = REPLACE(@external_id, 'gerrit:', 'username:');
    insert into account_external_ids (account_id, email_address, password, external_id) values (new.account_id, new.email_address, new.password, @new_external_id);
  end if;
end#

delimiter ;