Ilja Booij wrote: > However, I found a flaw in my shared mailbox implementation. Quite a > stupid, but fundamental, flaw. I gave the shared mailboxes an > owner_id > of '0', but this violates foreign key constraints, as there > is no user > with user_idnr '0'. > > I've not devoted time to fixing this yet. I'd like to fix in > a way that > doesn't require changing too much in the rest of dbmail. Is there > anyone here who has thought about this?
Following on my last email, I would put shared_mailboxes in the same table as normal user mailboxes and add a flag to identify it's a shared mailbox and therefore find authorized users in a separate table. This way you benefit from the existing code and need to write very little additional code, generally speaking. Cheers! Chris
