PKP Open Journaling Systems - Database triggers to set user email as username

ojs-trigger-email-as-username.sql

--
-- Create these triggers to allow OJS user login with his or her email instead of his username
-- (OJS controllers do not allow this feature, thus it can be implemented at database level)
--
DELIMITER $$
CREATE TRIGGER `update_username` BEFORE INSERT ON `users` FOR EACH ROW begin
set new.username = new.email;
end
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `update_username_edition` BEFORE UPDATE ON `users` FOR EACH ROW set new.username = new.email
$$
DELIMITER ;