On 06/23/2012 12:29 PM, cl445 wrote:
>
> What is the best way to delete an user from dbmail in SQL? Is there a
> cascading delete for dbmail_users?
Yes. When you delete a dbmail_users record, this will trigger a
cascading delete on
dbmail_mailboxes,
dbmail_acl,
dbmail_sievescripts,
dbmail_subscription,
dbmail_auto_notifications,
dbmail_auto_replies
dbmail_messages
However, as Harald mentions this will not clean out the actual message
blobs, only their metadata records.
dbmail-util will clean out any physmessages, partlists and mimeparts
records that are no longer connected to any email messages.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
