Quick Clean DB

[[DEV] Tiger]

I would like to share with you a quick cleaning of the date base. It was written for 4.3 databased.You have to create a new procedure and copy the script. Maybe someone you need
TGAME_GSP

 Spoiler

TGAME_GSP

ALTER PROCEDURE [dbo].[TClearAll]
AS

TRUNCATE TABLE TUNIFYPET
TRUNCATE TABLE TTOURNAMENTSTATUSTABLE
TRUNCATE TABLE TTOURNAMENTPLAYERTABLE
TRUNCATE TABLE TTNMTEVENTTABLE
TRUNCATE TABLE TTNMTEVENTREWARDTABLE
TRUNCATE TABLE TTEMPSKILLTABLE
TRUNCATE TABLE TTEMPSKILLMAINTAINTABLE
TRUNCATE TABLE TTEMPITEMUSEDTABLE
TRUNCATE TABLE TTEMPITEMTABLE
TRUNCATE TABLE TTEMPINVENTABLE
TRUNCATE TABLE TTEMPEXPITEMTABLE
TRUNCATE TABLE TTEMPCABINETTABLE
TRUNCATE TABLE TTEMPCABINETITEMTABLE
TRUNCATE TABLE TSOULMATETABLE
TRUNCATE TABLE TSKILLTABLE
TRUNCATE TABLE TSKILLREWARDMONEY
TRUNCATE TABLE TSKILLMAINTAINTABLE
TRUNCATE TABLE TSKILLLOG
TRUNCATE TABLE TRPSGAMERECORDTABLE
TRUNCATE TABLE TRESERVEDPOST
TRUNCATE TABLE TRENAMED
TRUNCATE TABLE TRECALLMONTABLE
TRUNCATE TABLE TRECALLMAINTAINTABLE
TRUNCATE TABLE TQUESTTERMTABLE
TRUNCATE TABLE TQUESTTABLE
TRUNCATE TABLE TPVPRECORDTABLE
TRUNCATE TABLE TPVPRECENTTABLE
TRUNCATE TABLE TPVPOINTTABLE
TRUNCATE TABLE TPROTECTEDTABLE
TRUNCATE TABLE TPOSTTABLE
TRUNCATE TABLE TPOSTITEMTABLE
TRUNCATE TABLE TPOSTERRORTABLE
TRUNCATE TABLE TPETTABLE
TRUNCATE TABLE TOPERATORTABLE
TRUNCATE TABLE TMOUNTTABLE
TRUNCATE TABLE TMOUNTITEMTABLE
TRUNCATE TABLE TMONTHRANKTABLE
TRUNCATE TABLE TMONTHPVPOINTTABLE
TRUNCATE TABLE TMENTORTABLE
TRUNCATE TABLE TITEMUSEDTABLE
TRUNCATE TABLE TITEMTABLE
TRUNCATE TABLE TITEMLOG
TRUNCATE TABLE TITEMCHANGE
TRUNCATE TABLE TINVENTABLE
TRUNCATE TABLE THOTKEYTABLE
TRUNCATE TABLE THEROTABLE
TRUNCATE TABLE TGUILDWANTEDTABLE
TRUNCATE TABLE TGUILDVOLUNTEERTABLE
TRUNCATE TABLE TGUILDTACTICSWANTEDTABLE
TRUNCATE TABLE TGUILDTACTICSTABLE
TRUNCATE TABLE TGUILDTABLE
TRUNCATE TABLE TGUILDRELATION
TRUNCATE TABLE TGUILDPVPRECORDTABLE
TRUNCATE TABLE TGUILDPVPOINTREWARDTABLE
TRUNCATE TABLE TGUILDPLAYLOG
TRUNCATE TABLE TGUILDMEMBERTABLE
TRUNCATE TABLE TGUILDCABINETTABLE
TRUNCATE TABLE TGUILDARTICLETABLE
TRUNCATE TABLE TGMREWARDTABLE
TRUNCATE TABLE TGMREWARDCHART
TRUNCATE TABLE TFRIENDTABLE
TRUNCATE TABLE TFRIENDGROUPTABLE
TRUNCATE TABLE TFAKESHOPCHART
TRUNCATE TABLE TFAKECHARCHART
TRUNCATE TABLE TEXPITEMTABLE
TRUNCATE TABLE TEVENTQUARTERGIVETABLE
TRUNCATE TABLE TEVENTQUARTERCHART
TRUNCATE TABLE TEVENTITEMTABLE
TRUNCATE TABLE TERASECHARLOG
TRUNCATE TABLE TDUELSCORETABLE
TRUNCATE TABLE TDUELCHARTABLE
TRUNCATE TABLE TCMGIFTTABLE
TRUNCATE TABLE TCHARTABLE
TRUNCATE TABLE TCASTLEAPPLICANTTABLE
TRUNCATE TABLE TCABINETTABLE
TRUNCATE TABLE TCABINETITEMTABLE
TRUNCATE TABLE TAUCTIONTABLE
TRUNCATE TABLE TAUCTIONINTEREST
TRUNCATE TABLE TAUCTIONBIDDER
TRUNCATE TABLE TAIDTABLE
TRUNCATE TABLE TACTIVECHARTABLE
TRUNCATE TABLE Premi
TRUNCATE TABLE OTESTER

TGLOBAL_GSP

 Spoiler

TGLOBAL_GSP

ALTER PROCEDURE [dbo].[TClearAll]
AS

TRUNCATE TABLE USERIPLOG
TRUNCATE TABLE TVERSION
TRUNCATE TABLE TUSERPROTECTED
TRUNCATE TABLE TUSERINFOTABLE
TRUNCATE TABLE TUSERATTENDTABLE
TRUNCATE TABLE TUNIFYPOSTITEMTABLE
TRUNCATE TABLE TUNIFYCASHITEM
TRUNCATE TABLE ttempuser
TRUNCATE TABLE ttemplevel
TRUNCATE TABLE TTEMPDURINGITEMTABLE
TRUNCATE TABLE TTEMPCASHITEM
TRUNCATE TABLE TSMSTABLE
TRUNCATE TABLE TRESERVEDNAME
TRUNCATE TABLE TPREVERSION
TRUNCATE TABLE TPCBANGPLAYTABLE
TRUNCATE TABLE TPCBANGMASTERTABLE
TRUNCATE TABLE TMANAGERLOG
TRUNCATE TABLE TLOGGEDTODAY
TRUNCATE TABLE TLOG
TRUNCATE TABLE TLASTMONTHPOINTTABLE
TRUNCATE TABLE TIPBAN
TRUNCATE TABLE TIPAUTHORITY
TRUNCATE TABLE Tgiftitem
TRUNCATE TABLE TGIFTCATs
TRUNCATE TABLE TEVENTHORSE
TRUNCATE TABLE test
TRUNCATE TABLE TEMPUSERID
TRUNCATE TABLE TempEvent
TRUNCATE TABLE TDURINGITEMTABLE
TRUNCATE TABLE TCURRENTUSER
TRUNCATE TABLE TCOMEBACKTABLE
TRUNCATE TABLE TCHARITEMTABLE
TRUNCATE TABLE TCASHTESTTABLE
TRUNCATE TABLE TCASHITEMCABINETTABLE_temp
TRUNCATE TABLE TCASHITEMCABINETTABLE
TRUNCATE TABLE TCASHITEMBUYTABLE
TRUNCATE TABLE TCABINETITEMCHART
TRUNCATE TABLE TALLRANKTABLE
TRUNCATE TABLE TALLRANKGUILDTABLE
TRUNCATE TABLE TALLLOCALTABLE
TRUNCATE TABLE TALLCHARTABLE_TRIGGER
TRUNCATE TABLE TALLCHARTABLE_OLD
TRUNCATE TABLE TALLCHARTABLE
TRUNCATE TABLE TACCOUNTCHARTABLE
TRUNCATE TABLE TACCOUNT_BACKUP
TRUNCATE TABLE TACCOUNT

[caneca59]

Great

[Sicarium]

TRUNCATE TABLE Premi

This is my table. Not all guys got that.

[[DEV] Tiger]

Originally Posted by Sicarium

This is my table. Not all guys got that.

It can be removed from the list

[Sicarium]

I know but you should write that if they don't have it