Re: [Postfixadmin-devel] DB schema question

[Christian B. <pos...@cb...>]

Hello,

Am Samstag, 30. November 2024, 06:18 schrieb Richard Hector:
> I notice that the mailbox table has username and domain columns, where
> the username is the full email address including the domain name. Are
> the domain names in both places guaranteed to be the same?

Nobody can stop you from doing a silly INSERT or UPDATE query directly 
in the database.

That said - as long as you only use PostfixAdmin to modify the database, 
the domain column and the domain in the mailbox name are guaranteed to 
be the same.

> If they are always the same, then the example db query for
> virtual_alias_domain_mailbox_maps could be significantly simplified.

Alias domains have a few special cases and pitfalls, but nevertheless, 
I'm looking forward for your proposal ;-)


Regards,

Christian Boltz
-- 
I usually explain databases as 2TB sized global variables
with a weird access method and concurrent access.
[https://twitter.com/isotopp/status/1352618340871778308]