delimiter |

CREATE TRIGGER test.before_insert_app_users
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
	SET NEW.token = LEFT(MD5(NOW()), 8);
END
|
delimiter ;