TRUNCATE `visitormessage`; 

                       TRUNCATE `visitormessage_hash`; 

                       UPDATE user SET vmunreadcount = 0, vmmoderatedcount = 0 

                       TRUNCATE `pm`; 

                       TRUNCATE `pmreceipt`; 

                       TRUNCATE `pmtext`; 

                       UPDATE `user` SET `pmtotal` = 0, `pmunread` = 0;