1 2 Previous Next 15 Replies Latest reply on Jul 6, 2006 6:42 PM by gohip Go to original post
      • 15. Re: POP --> isDeleted
        gohip

        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);


        1 2 Previous Next