Help Stored Procedure Cleanup the Database

CREATE PROCEDURE [dbo].[clean_account]
AS
BEGIN
TRUNCATE TABLE cabal_additional_dungeon_instance_table
TRUNCATE TABLE cabal_AlzEarnLock_table
TRUNCATE TABLE cabal_auth_table
TRUNCATE TABLE cabal_autoblock_log
TRUNCATE TABLE cabal_blockip_list
TRUNCATE TABLE cabal_blockuser_table
TRUNCATE TABLE cabal_bot_report_table
TRUNCATE TABLE cabal_character_count_table
TRUNCATE TABLE cabal_charge_auth
TRUNCATE TABLE cabal_freeip_list
TRUNCATE TABLE cabal_GM_ip_table
TRUNCATE TABLE cabal_hackuser_list
TRUNCATE TABLE cabal_otp_table
TRUNCATE TABLE cabal_permission_shop
TRUNCATE TABLE cabal_sub_password_table
TRUNCATE TABLE cabalapp_android_push_category
TRUNCATE TABLE cabalapp_android_push_message
TRUNCATE TABLE cabalapp_android_registration_id
TRUNCATE TABLE cabalapp_iphone_device_token
TRUNCATE TABLE cabalapp_iphone_lastlogin
TRUNCATE TABLE cabalapp_iphone_push_category
TRUNCATE TABLE cabalapp_iphone_push_message
TRUNCATE TABLE facebook_authcode
TRUNCATE TABLE facebook_event
TRUNCATE TABLE facebook_event_category
TRUNCATE TABLE facebook_event_log
TRUNCATE TABLE facebook_event_log_image
TRUNCATE TABLE facebook_userevent
TRUNCATE TABLE facebook_usermapping
TRUNCATE TABLE ipchecking
TRUNCATE TABLE Web_Log
TRUNCATE TABLE Web_Vote
TRUNCATE TABLE Web_Wall
END

CREATE PROCEDURE [dbo].[clean_cabalcash]
AS
BEGIN
TRUNCATE TABLE CashAccount
TRUNCATE TABLE CashChargeErrorLog
TRUNCATE TABLE CashLog
TRUNCATE TABLE CashLogType
TRUNCATE TABLE CashPremiumLog
TRUNCATE TABLE epoint_buy
TRUNCATE TABLE epoint_charge
TRUNCATE TABLE epoint_charge_transfer
TRUNCATE TABLE GiftCashLog
TRUNCATE TABLE MyCashItem
TRUNCATE TABLE npc_deleteCashLog
TRUNCATE TABLE PAYPAL_LOG
TRUNCATE TABLE VoucherDetails
TRUNCATE TABLE VoucherItemMaster
TRUNCATE TABLE VoucherMaster
END

CREATE PROCEDURE [dbo].[clean_cabalguild]
AS
BEGIN
TRUNCATE TABLE Guildboard
TRUNCATE TABLE GuildBoardComment
TRUNCATE TABLE GuildDetail
TRUNCATE TABLE GuildGuestBoard
TRUNCATE TABLE GuildInfo
TRUNCATE TABLE GuildMaster_Change_Log
TRUNCATE TABLE tempguild
END

CREATE PROCEDURE [dbo].[clean_netcafebilling]
AS
BEGIN
TRUNCATE TABLE Point
END

CREATE PROCEDURE [dbo].[clean_gamedb]
AS
BEGIN
TRUNCATE TABLE cabal_achievement_history
TRUNCATE TABLE cabal_achievement_open
TRUNCATE TABLE cabal_achievement_title
TRUNCATE TABLE cabal_achievement_title_shared
TRUNCATE TABLE cabal_agentshop_bookmark
TRUNCATE TABLE cabal_agentshop_done_table
TRUNCATE TABLE cabal_agentshop_pet_table
TRUNCATE TABLE cabal_agentshop_price_average
TRUNCATE TABLE cabal_agentshop_price_daily
TRUNCATE TABLE cabal_agentshop_sale_table
TRUNCATE TABLE cabal_alzSupply_table
TRUNCATE TABLE cabal_Assistant_table
TRUNCATE TABLE cabal_badwoard
TRUNCATE TABLE cabal_bbead_table
TRUNCATE TABLE cabal_character_table
TRUNCATE TABLE cabal_craft_table
TRUNCATE TABLE cabal_DungeonPoint_table
TRUNCATE TABLE cabal_DungeonRanking_Data_table
TRUNCATE TABLE cabal_DungeonRankingParty_table
TRUNCATE TABLE cabal_DungeonRankingSingle_table
TRUNCATE TABLE cabal_ems_userstate_table
TRUNCATE TABLE cabal_equipment_lock_table
TRUNCATE TABLE cabal_equipment_table
TRUNCATE TABLE cabal_event_partydg
TRUNCATE TABLE cabal_event_singledg
TRUNCATE TABLE cabal_event_special_character_data
TRUNCATE TABLE cabal_event_special_character_data_for_client
TRUNCATE TABLE cabal_Forcecalibur_Owner
TRUNCATE TABLE cabal_guildEnterLog_table
TRUNCATE TABLE cabal_GuildLord_WinnerRecord
TRUNCATE TABLE cabal_guildMaxCcu_table
TRUNCATE TABLE cabal_help_table
TRUNCATE TABLE cabal_instantWar_nationRewardWarResults
TRUNCATE TABLE Cabal_InstantWar_Penalty_table
TRUNCATE TABLE cabal_instantWar_results
TRUNCATE TABLE cabal_instantWar_statistics
TRUNCATE TABLE cabal_Inventory_table
TRUNCATE TABLE cabal_item_extend_table
TRUNCATE TABLE cabal_last_login_character
UPDATE cabal_itemserial_table SET SerialBgn = 0
TRUNCATE TABLE cabal_LordOfWar_point_table
TRUNCATE TABLE cabal_LordOfWar_Rank_table
TRUNCATE TABLE cabal_LordOfWar_table
TRUNCATE TABLE cabal_mail_notice_forward_table
DELETE FROM cabal_mail_notice_table
TRUNCATE TABLE cabal_mail_received_table
TRUNCATE TABLE cabal_mail_report_table
TRUNCATE TABLE cabal_mail_sent_pet_table
DELETE FROM cabal_mail_sent_table
DELETE FROM cabal_pet_table
TRUNCATE TABLE cabal_qddata_table
TRUNCATE TABLE cabal_questdata_table
TRUNCATE TABLE cabal_quickslot_table
TRUNCATE TABLE cabal_record_combo
TRUNCATE TABLE cabal_saved_buff_table
TRUNCATE TABLE cabal_skilllist_table
TRUNCATE TABLE cabal_sold_item_table
TRUNCATE TABLE cabal_soul_ability_table
TRUNCATE TABLE cabal_title_guild
TRUNCATE TABLE Cabal_Title_PlayHistory
TRUNCATE TABLE Cabal_Title_Show_Table
TRUNCATE TABLE Cabal_Title_Table
TRUNCATE TABLE cabal_title_viaserver_table
TRUNCATE TABLE cabal_tool_agentshop_auto_item_table
TRUNCATE TABLE cabal_tool_agentshop_auto_table
TRUNCATE TABLE cabal_tool_agentshop_log_table
TRUNCATE TABLE cabal_tool_agentshop_schedule_log_table
TRUNCATE TABLE cabal_tool_agentshop_search_item_table
TRUNCATE TABLE cabal_warehouse_ext_table
TRUNCATE TABLE cabal_warehouse_ext2_table
TRUNCATE TABLE cabal_warehouse_table
TRUNCATE TABLE cabal_WarExp_Table
TRUNCATE TABLE cabalapp_log_table
TRUNCATE TABLE chat_buddy_pr_message
TRUNCATE TABLE chat_buddy_table
TRUNCATE TABLE chat_buddygroup_table
TRUNCATE TABLE ChatBlacklist
TRUNCATE TABLE chg_mrank
TRUNCATE TABLE chg_srank
TRUNCATE TABLE deleted_cabal_achievement_title
TRUNCATE TABLE deleted_cabal_character_table
TRUNCATE TABLE deleted_cabal_inventory_table
TRUNCATE TABLE deleted_cabal_item_extend_table
TRUNCATE TABLE deleted_Cabal_Title_PlayHistory
TRUNCATE TABLE EVENT_LEVELUP_NEWCHAR_TABLE
TRUNCATE TABLE Guild
TRUNCATE TABLE guild_backup
TRUNCATE TABLE guild_level_limit
TRUNCATE TABLE guild_warehouse_log
TRUNCATE TABLE guild_warehouse_table
TRUNCATE TABLE GuildGroup
TRUNCATE TABLE GuildMember
TRUNCATE TABLE levelUpStepTable
TRUNCATE TABLE LevUpEventWinTable
TRUNCATE TABLE log_nation
TRUNCATE TABLE Mail
END

 

 

 

 

USE Master
GO
exec Account.dbo.clean_account
GO
exec CabalCash.dbo.clean_cabalcash
GO
exec CabalGuild.dbo.clean_cabalguild
GO
exec NetCafeBilling.dbo.clean_netcafebilling
GO
exec Server01.dbo.clean_gamedb