TRUNCATE TABLE `creature`; UPDATE `creature_template` SET `AiName`=NULL WHERE `AiName`='SmartAI';
TRUNCATE TABLE `gameobject`;
TRUNCATE TABLE `vehicle_template_accessory`;
TRUNCATE TABLE `npc_spellclick_spells`;
TRUNCATE TABLE `creature_addon`;
TRUNCATE TABLE `creature_formations`;
TRUNCATE TABLE `pool_creature`;
TRUNCATE TABLE `game_event_npc_vendor`;
TRUNCATE TABLE `linked_respawn`;
TRUNCATE TABLE `smart_scripts`;
TRUNCATE TABLE `pool_gameobject`;
TRUNCATE TABLE `quest_template`;
TRUNCATE TABLE `quest_poi`;
TRUNCATE TABLE `quest_poi_points`;
TRUNCATE TABLE `quest_start_scripts`;
TRUNCATE TABLE `quest_end_scripts`;
TRUNCATE TABLE `creature_involvedrelation`;
TRUNCATE TABLE `creature_questrelation`;
TRUNCATE TABLE `gameobject_questrelation`;
TRUNCATE TABLE `gameobject_involvedrelation`;
TRUNCATE TABLE `pool_quest`;
TRUNCATE TABLE `lfg_dungeon_rewards`;
TRUNCATE TABLE `spell_area`;
TRUNCATE TABLE `conditions`;
TRUNCATE TABLE `db_script_string`;
TRUNCATE TABLE `gameobject_scripts`;
TRUNCATE TABLE `event_scripts`;
TRUNCATE TABLE `areatrigger_involvedrelation`;
TRUNCATE TABLE `areatrigger_teleport`;
TRUNCATE TABLE `outdoorpvp_template`;
DELETE FROM `access_requirement` WHERE `quest_done_A` > '0';
DELETE FROM `access_requirement` WHERE `quest_done_H` > '0';
DELETE FROM `disables` WHERE `comment` = 'Deprecated quest';