It always seemed to me that the dbmail_aliases table should have a
user_idnr column along with the deliver_to column. This way if
deliver_to was null, go to the user's inbox. This would allow
constraints to prevent dangling aliases on user delete, and aliases to
user_idnrs that don't exist.
It would require a user for every alias, but there's no harm in creating
administrative users that don't actually receive mail.
Michael Monnerie wrote:
...
The bad thing is that the design of that table is broken, as you can't
guarantee that the number refers to an existing user. OTOH, I don't
know how to do it better, other than introducing another
table "dbmail_external_aliases" just for text entries, and changing the
existing dbmail_aliases to having only user_idnr.
So at least dbmail-util should clean up the mess here.
...
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
