[Jboss-dev-forums] [Design of JBoss Collaboration Server] - Re: POP --> isDeleted

[<go...@ic...>]

Welcome back from vacation, hope you got to enjoy it, how was the weather in SanFran?

I would like to help with "patching", but ATM am busy with normal work.  I will try and make an effort though...

I did this in mySQL....see anything wrong with it, other than  maybe inefficiency,  i.e. to delete all of a users email related data...

DELETE FROM messagedata WHERE folder_id = lngUserInBoxID;	
  | /* Now clean orphaned emails in other tables */
  | DELETE FROM paged_mail_store WHERE id not in (select m.bodyid from messagedata m);
  | DELETE FROM paged_mail_store_pages WHERE blobid not in (select b.id from paged_mail_store b);
  | DELETE FROM storeitemmetadata WHERE pid not in (select b.id from paged_mail_store b);

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3956025#3956025

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3956025