Hello, I think dbmail-maintenance cleans that up. Or you could manually run something like "delete from mailboxes where owner_idnr not in (select distinct user_idnr from users)" or even add a foreign key in mailboxes that references users (using "on delete cascade").
jn ---- Original Message ---- From: Nunno Luca <[email protected]> To: <[email protected]> Subject: [Dbmail] Unused Mailbox Sent: Mon, 8 Dec 2003 23:42:25 +0100 > Hi all, > > How i can delete the unused MailBoxes ? > Delete an user or a mailbox don't clear entry in mailbox table ( i think > because they reference the messages) > > Anyone can suggest a query to delete it ? > > Thank's > > -- End Original Message -- -- Jesse Norell jesse (at) kci.net
