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