-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse Norell Sent: 08 December 2003 23:17 To: dbmail@dbmail.org Subject: RE: [Dbmail] Unused Mailbox
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 _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
