Use another table for user lookup

[Damian]

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20240403/fa136896/attachment.htm>