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 <dbmail@dbmail.org> To: <dbmail@dbmail.org> 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
