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