<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<blockquote type="cite"
cite="mid:CAOWLHvsdD4p53nHS66mu+0P-J7D3wPXjC531K2dk1ptLeRxg4g@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">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`
</pre>
</blockquote>
<p>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?</p>
<p>[1]
<a class="moz-txt-link-freetext" href="https://gitlab.com/amavis/amavis/-/blob/v2.13.1/README_FILES/README.sql-mysql#L75-83">https://gitlab.com/amavis/amavis/-/blob/v2.13.1/README_FILES/README.sql-mysql#L75-83</a><br>
</p>
</body>
</html>