Use another table for user lookup
Filip Bartmann
filbar at centrum.cz
Tue Apr 2 17:38:46 CEST 2024
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
More information about the amavis-users
mailing list