I have in my MariaDB database used table users for other needs. Is
there any opiniion to use another table such as emails which has
structure
CREATE TABLE `emails` (
`id` int(5) NOT NULL auto_increment,
`email` varchar(255) NOT NULL,
`password` mediumtext NOT NULL,
`user_id` int(5) NOT NULL,
`domain` varchar(255) NOT NULL,
`enabled` int(1) NOT NULL,
`virtual` int(1) NOT NULL
PRIMARY KEY (`id`))
so email address is concatencated from `email`@`domain`
I am not quite sure what you want to do. Do you want to sql-query the
email address from above emails.email @ emails.domain, where it
currently is queried from [1]'s users.email?
[1]
https://gitlab.com/amavis/amavis/-/blob/v2.13.1/README_FILES/README.sql-mysql#L75-83