Use another table for user lookup

Filip Bartmann <[email protected]> Tue, 2 Apr 2024 17:38:46 +0200
Newsgroups gmane.mail.virus.amavis.user
Message-ID <CAOWLHvsdD4p53nHS66mu+0P-J7D3wPXjC531K2dk1ptLeRxg4g@mail.gmail.com>
Hello,
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 use this docs - https://www.ijs.si/software/amavisd/README.sql-mysql.txt

Thanks in advance,
Filip Bartmann