TRUNCATE `accountlock`;
TRUNCATE `achiever`;
TRUNCATE `address`;
TRUNCATE `apppurchase`;
TRUNCATE `attributemaster`;
TRUNCATE `autoregdetail`;
TRUNCATE `autoregistration`;
TRUNCATE `backupofdata`;
TRUNCATE `bannermaster`;
TRUNCATE `binaryprocessing`;
TRUNCATE `binaryprocessingdate`;
TRUNCATE `contactus`;
TRUNCATE `designationmaster`;
TRUNCATE `designationupdate`;
TRUNCATE `directreferal`;
TRUNCATE `display`;
TRUNCATE `documentlist`;
TRUNCATE `download`;
TRUNCATE `ewallet`;
TRUNCATE `franchiseelist`;
TRUNCATE `franchiseemaster`;
TRUNCATE `fundrequest`;
TRUNCATE `holidaymaster`;
TRUNCATE `image`;
TRUNCATE `joining`;
TRUNCATE `joininincome`;
TRUNCATE `levelincome`;
TRUNCATE `littlespring`;
TRUNCATE `matrixincome`;
TRUNCATE `memberdocument`;
TRUNCATE `mregdetail`;
TRUNCATE `mvc`;
TRUNCATE `mycart`;
TRUNCATE `mycartstage`;
TRUNCATE `news`;
TRUNCATE `packagedispathdetails`;
TRUNCATE `paymnetdetail`;
TRUNCATE `payout`;
TRUNCATE `pbill`;
TRUNCATE `pbilldetail`;
TRUNCATE `pinallocation`;
TRUNCATE `pinbonusincome`;
TRUNCATE `pinmaster`;
TRUNCATE `pinrequest`;
TRUNCATE `pintransaction`;
TRUNCATE `pintransfer`;
TRUNCATE `popupimg`;
TRUNCATE `productattribute`;
TRUNCATE `productimage`;
TRUNCATE `purchase`;
TRUNCATE `purchaseorder`;
TRUNCATE `purchaseorderdetails`;
TRUNCATE `regdetail`;
TRUNCATE `repurchasebusiness`;
TRUNCATE `repurchaseregdetail`;
TRUNCATE `roiincome`;
TRUNCATE `royaltyincome`;
TRUNCATE `slideradd`;
TRUNCATE `sliderreg`;
TRUNCATE `sponsorincome`;
TRUNCATE `stage`;
TRUNCATE `stocktransaction`;
TRUNCATE `suppliermaster`;
TRUNCATE `support`;
TRUNCATE `temppurchase`;
TRUNCATE `tickettype`;
TRUNCATE `tmpmycart`;
TRUNCATE `topupdetails`;
TRUNCATE `venderreg`;
TRUNCATE `visitor`;
TRUNCATE `withdrawalrequest`;
TRUNCATE `roidate`;
TRUNCATE `cartaddress`;
TRUNCATE `cart`;
TRUNCATE `weeklybinary`;
TRUNCATE `fundtrandfer`;
TRUNCATE `upgradepkg`;
TRUNCATE `rewardachipair`;
TRUNCATE `rewardachim`;
TRUNCATE `royaltyfinal`;
TRUNCATE `productcategory`;
TRUNCATE `productmaster`;



delete from registration where memberid!='100001';
update registration set tail=0,taildate="0000-00-00 00:00:00",leftsponsor='0',rightsponsor=0,autoregi='0';