AC-TC-diff-world.diff

AC-TC-diff-characters.diff
AC revision: https://github.com/azerothcore/azerothcore-wotlk/commit/008f16fac2fb159e0259da7959fe64f5584bc7de
TC revision: https://github.com/TrinityCore/TrinityCore/commit/3dbe80ee2e0d1848302bcf34b654693462942639

Date: 29-12-2018

diff --git a/acore_world.sql b/tc_world.sql

--- a/acore_world.sql
+++ b/tc_world.sql

 
--- Dumping structure for table acore_world.achievement_reward
+-- Dumping structure for table tc_world.achievement_reward
 DROP TABLE IF EXISTS `achievement_reward`;
 CREATE TABLE IF NOT EXISTS `achievement_reward` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `title_A` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `title_H` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `item` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `sender` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `subject` varchar(255) DEFAULT NULL,
-  `text` text,
-  `mailTemplate` mediumint(8) unsigned DEFAULT '0',
-  PRIMARY KEY (`entry`)
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `TitleA` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `TitleH` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Sender` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Subject` varchar(255) DEFAULT NULL,
+  `Body` text,
+  `MailTemplateID` mediumint(8) unsigned DEFAULT '0',
+  PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
 
 
--- Dumping structure for table acore_world.areatrigger
-DROP TABLE IF EXISTS `areatrigger`;
-CREATE TABLE IF NOT EXISTS `areatrigger` (
-  `entry` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `map` int(10) unsigned NOT NULL DEFAULT '0',
-  `x` float NOT NULL DEFAULT '0',
-  `y` float NOT NULL DEFAULT '0',
-  `z` float NOT NULL DEFAULT '0',
-  `radius` float NOT NULL DEFAULT '0' COMMENT 'Seems to be a box of size yards with center at x,y,z',
-  `length` float NOT NULL DEFAULT '0' COMMENT 'Most commonly used when size is 0, but not always',
-  `width` float NOT NULL DEFAULT '0' COMMENT 'Most commonly used when size is 0, but not always',
-  `height` float NOT NULL DEFAULT '0' COMMENT 'Most commonly used when size is 0, but not always',
-  `orientation` float NOT NULL DEFAULT '0' COMMENT 'Most commonly used when size is 0, but not always',
-  PRIMARY KEY (`entry`)
-) ENGINE=InnoDB AUTO_INCREMENT=5873 DEFAULT CHARSET=latin1;
+-- Dumping structure for table tc_world.achievement_reward_locale
+DROP TABLE IF EXISTS `achievement_reward_locale`;
+CREATE TABLE IF NOT EXISTS `achievement_reward_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) NOT NULL,
+  `Subject` text,
+  `Body` text,
+  PRIMARY KEY (`ID`,`Locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

--- Dumping structure for table acore_world.command
+-- Dumping structure for table tc_world.broadcast_text_locale
+DROP TABLE IF EXISTS `broadcast_text_locale`;
+CREATE TABLE IF NOT EXISTS `broadcast_text_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `MaleText` text,
+  `FemaleText` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.command
 DROP TABLE IF EXISTS `command`;
 CREATE TABLE IF NOT EXISTS `command` (
   `name` varchar(50) NOT NULL DEFAULT '',
-  `security` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `permission` smallint(5) unsigned NOT NULL DEFAULT '0',
   `help` longtext,
   PRIMARY KEY (`name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System';
 
 
 
--- Dumping structure for table acore_world.creature
+-- Dumping structure for table tc_world.creature
 DROP TABLE IF EXISTS `creature`;
 CREATE TABLE IF NOT EXISTS `creature` (
   `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
   `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
   `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
+  `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
+  `areaId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier',
   `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `phaseMask` int(10) unsigned NOT NULL DEFAULT '1',
   `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -235,13 +244,15 @@ CREATE TABLE IF NOT EXISTS `creature` (
   `npcflag` int(10) unsigned NOT NULL DEFAULT '0',
   `unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
+  `ScriptName` char(64) DEFAULT '',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`guid`),
   KEY `idx_map` (`map`),
   KEY `idx_id` (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2023137 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
+) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
 

--- Dumping structure for table acore_world.creature_equip_template
+-- Dumping structure for table tc_world.creature_equip_template
 DROP TABLE IF EXISTS `creature_equip_template`;
 CREATE TABLE IF NOT EXISTS `creature_equip_template` (
   `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -283,12 +294,12 @@ CREATE TABLE IF NOT EXISTS `creature_equip_template` (
   `ItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`CreatureID`,`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.creature_onkill_reputation
+-- Dumping structure for table tc_world.creature_movement_override
+DROP TABLE IF EXISTS `creature_movement_override`;
+CREATE TABLE IF NOT EXISTS `creature_movement_override` (
+  `SpawnId` int(10) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`SpawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.creature_onkill_reputation
 DROP TABLE IF EXISTS `creature_onkill_reputation`;
 CREATE TABLE IF NOT EXISTS `creature_onkill_reputation` (
   `creature_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
@@ -348,7 +371,7 @@ CREATE TABLE IF NOT EXISTS `creature_onkill_reputation` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain';
 
  
--- Dumping structure for table acore_world.creature_questitem
+-- Dumping structure for table tc_world.creature_questitem
 DROP TABLE IF EXISTS `creature_questitem`;
 CREATE TABLE IF NOT EXISTS `creature_questitem` (
   `CreatureEntry` int(10) unsigned NOT NULL DEFAULT '0',
   `Idx` int(10) unsigned NOT NULL DEFAULT '0',
   `ItemId` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
   PRIMARY KEY (`CreatureEntry`,`Idx`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
  
--- Dumping structure for table acore_world.creature_template
+-- Dumping structure for table tc_world.creature_template
 DROP TABLE IF EXISTS `creature_template`;
 CREATE TABLE IF NOT EXISTS `creature_template` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -418,13 +442,11 @@ CREATE TABLE IF NOT EXISTS `creature_template` (
   `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value',
   `scale` float NOT NULL DEFAULT '1',
   `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `mindmg` float NOT NULL DEFAULT '0',
-  `maxdmg` float NOT NULL DEFAULT '0',
   `dmgschool` tinyint(4) NOT NULL DEFAULT '0',
-  `attackpower` int(10) unsigned NOT NULL DEFAULT '0',
-  `dmg_multiplier` float NOT NULL DEFAULT '1',
-  `baseattacktime` int(10) unsigned NOT NULL DEFAULT '0',
-  `rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0',
+  `BaseAttackTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `RangeAttackTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `BaseVariance` float NOT NULL DEFAULT '1',
+  `RangeVariance` float NOT NULL DEFAULT '1',
   `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `unit_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0',
@@ -434,9 +456,6 @@ CREATE TABLE IF NOT EXISTS `creature_template` (
   `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `minrangedmg` float NOT NULL DEFAULT '0',
-  `maxrangedmg` float NOT NULL DEFAULT '0',
-  `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0',
   `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `type_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -462,24 +481,26 @@ CREATE TABLE IF NOT EXISTS `creature_template` (
   `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `AIName` char(64) NOT NULL DEFAULT '',
   `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
   `HoverHeight` float NOT NULL DEFAULT '1',
-  `Health_mod` float NOT NULL DEFAULT '1',
-  `Mana_mod` float NOT NULL DEFAULT '1',
-  `Armor_mod` float NOT NULL DEFAULT '1',
+  `HealthModifier` float NOT NULL DEFAULT '1',
+  `ManaModifier` float NOT NULL DEFAULT '1',
+  `ArmorModifier` float NOT NULL DEFAULT '1',
+  `DamageModifier` float NOT NULL DEFAULT '1',
+  `ExperienceModifier` float NOT NULL DEFAULT '1',
   `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `movementId` int(11) unsigned NOT NULL DEFAULT '0',
   `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0',
+  `spell_school_immune_mask` int(3) unsigned NOT NULL DEFAULT '0',
   `flags_extra` int(10) unsigned NOT NULL DEFAULT '0',
   `ScriptName` char(64) NOT NULL DEFAULT '',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
 
  
--- Dumping structure for table acore_world.creature_text
+-- Dumping structure for table tc_world.creature_template_movement
+DROP TABLE IF EXISTS `creature_template_movement`;
+CREATE TABLE IF NOT EXISTS `creature_template_movement` (
+  `CreatureId` int(10) unsigned NOT NULL DEFAULT '0',
+  `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`CreatureId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.creature_text
 DROP TABLE IF EXISTS `creature_text`;
 CREATE TABLE IF NOT EXISTS `creature_text` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `text` longtext,
-  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `language` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `probability` float NOT NULL DEFAULT '0',
-  `emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `duration` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `BroadcastTextID` mediumint(6) unsigned NOT NULL DEFAULT '0',
+  `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Text` longtext,
+  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Language` tinyint(3) NOT NULL DEFAULT '0',
+  `Probability` float unsigned NOT NULL DEFAULT '0',
+  `Emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Duration` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `BroadcastTextId` mediumint(6) NOT NULL DEFAULT '0',
   `TextRange` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `comment` varchar(255) DEFAULT '',
-  PRIMARY KEY (`entry`,`groupid`,`id`)
+  PRIMARY KEY (`CreatureID`,`GroupID`,`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.db_script_string
-DROP TABLE IF EXISTS `db_script_string`;
-CREATE TABLE IF NOT EXISTS `db_script_string` (
-  `entry` int(10) unsigned NOT NULL DEFAULT '0',
-  `content_default` text NOT NULL,
-  `content_loc1` text,
-  `content_loc2` text,
-  `content_loc3` text,
-  `content_loc4` text,
-  `content_loc5` text,
-  `content_loc6` text,
-  `content_loc7` text,
-  `content_loc8` text,
-  PRIMARY KEY (`entry`)
+-- Dumping structure for table tc_world.creature_text_locale
+DROP TABLE IF EXISTS `creature_text_locale`;
+CREATE TABLE IF NOT EXISTS `creature_text_locale` (
+  `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) NOT NULL,
+  `Text` text,
+  PRIMARY KEY (`CreatureID`,`GroupID`,`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--- Dumping structure for table acore_world.gameobject
+-- Dumping structure for table tc_world.gameobject
 DROP TABLE IF EXISTS `gameobject`;
 CREATE TABLE IF NOT EXISTS `gameobject` (
   `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
   `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier',
   `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
+  `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
+  `areaId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier',
   `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `phaseMask` int(10) unsigned NOT NULL DEFAULT '1',
   `position_x` float NOT NULL DEFAULT '0',
@@ -633,22 +663,27 @@ CREATE TABLE IF NOT EXISTS `gameobject` (
   `spawntimesecs` int(11) NOT NULL DEFAULT '0',
   `animprogress` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ScriptName` char(64) DEFAULT '',
   `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM AUTO_INCREMENT=268970 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
+) ENGINE=MyISAM AUTO_INCREMENT=255094 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
 
 
--- Dumping structure for table acore_world.gameobject_addon
+-- Dumping structure for table tc_world.gameobject_addon
 DROP TABLE IF EXISTS `gameobject_addon`;
 CREATE TABLE IF NOT EXISTS `gameobject_addon` (
   `guid` int(10) unsigned NOT NULL DEFAULT '0',
+  `parent_rotation0` float NOT NULL DEFAULT '0',
+  `parent_rotation1` float NOT NULL DEFAULT '0',
+  `parent_rotation2` float NOT NULL DEFAULT '0',
+  `parent_rotation3` float NOT NULL DEFAULT '1',
   `invisibilityType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `invisibilityValue` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
--- Dumping structure for table acore_world.gameobject_questender
+-- Dumping structure for table tc_world.gameobject_overrides
+DROP TABLE IF EXISTS `gameobject_overrides`;
+CREATE TABLE IF NOT EXISTS `gameobject_overrides` (
+  `spawnId` int(10) unsigned NOT NULL DEFAULT '0',
+  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `flags` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`spawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.gameobject_questender
 DROP TABLE IF EXISTS `gameobject_questender`;
 CREATE TABLE IF NOT EXISTS `gameobject_questender` (
   `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -674,17 +719,18 @@ CREATE TABLE IF NOT EXISTS `gameobject_questender` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.gameobject_questitem
+-- Dumping structure for table tc_world.gameobject_questitem
 DROP TABLE IF EXISTS `gameobject_questitem`;
 CREATE TABLE IF NOT EXISTS `gameobject_questitem` (
   `GameObjectEntry` int(10) unsigned NOT NULL DEFAULT '0',
   `Idx` int(10) unsigned NOT NULL DEFAULT '0',
   `ItemId` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
   PRIMARY KEY (`GameObjectEntry`,`Idx`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
  
--- Dumping structure for table acore_world.gameobject_template
+-- Dumping structure for table tc_world.gameobject_template
 DROP TABLE IF EXISTS `gameobject_template`;
 CREATE TABLE IF NOT EXISTS `gameobject_template` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -703,8 +749,6 @@ CREATE TABLE IF NOT EXISTS `gameobject_template` (
   `IconName` varchar(100) NOT NULL DEFAULT '',
   `castBarCaption` varchar(100) NOT NULL DEFAULT '',
   `unk1` varchar(100) NOT NULL DEFAULT '',
-  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `flags` int(10) unsigned NOT NULL DEFAULT '0',
   `size` float NOT NULL DEFAULT '1',
   `Data0` int(10) unsigned NOT NULL DEFAULT '0',
   `Data1` int(11) NOT NULL DEFAULT '0',
@@ -732,13 +776,25 @@ CREATE TABLE IF NOT EXISTS `gameobject_template` (
   `Data23` int(10) unsigned NOT NULL DEFAULT '0',
   `AIName` char(64) NOT NULL DEFAULT '',
   `ScriptName` varchar(64) NOT NULL DEFAULT '',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
 
 
--- Dumping structure for table acore_world.gameobject_template_locale
+-- Dumping structure for table tc_world.gameobject_template_addon
+DROP TABLE IF EXISTS `gameobject_template_addon`;
+CREATE TABLE IF NOT EXISTS `gameobject_template_addon` (
+  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.gameobject_template_locale
 DROP TABLE IF EXISTS `gameobject_template_locale`;
 CREATE TABLE IF NOT EXISTS `gameobject_template_locale` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -750,23 +806,24 @@ CREATE TABLE IF NOT EXISTS `gameobject_template_locale` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.game_event
+-- Dumping structure for table tc_world.game_event
 DROP TABLE IF EXISTS `game_event`;
 CREATE TABLE IF NOT EXISTS `game_event` (
   `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event',
-  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
-  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
+  `start_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute start date, the event will never start before',
+  `end_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute end date, the event will never start after',
   `occurence` bigint(20) unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event',
   `length` bigint(20) unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
   `holiday` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
   `holidayStage` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console',
   `world_event` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event',
+  `announce` tinyint(3) unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config',
   PRIMARY KEY (`eventEntry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.game_graveyard_zone
-DROP TABLE IF EXISTS `game_graveyard_zone`;
-CREATE TABLE IF NOT EXISTS `game_graveyard_zone` (
-  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `ghost_zone` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`id`,`ghost_zone`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
-
-
--- Dumping structure for table acore_world.game_tele
+-- Dumping structure for table tc_world.game_tele
 DROP TABLE IF EXISTS `game_tele`;
 CREATE TABLE IF NOT EXISTS `game_tele` (
   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
@@ -931,10 +978,10 @@ CREATE TABLE IF NOT EXISTS `game_tele` (
   `map` smallint(5) unsigned NOT NULL DEFAULT '0',
   `name` varchar(100) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1435 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
+) ENGINE=MyISAM AUTO_INCREMENT=1433 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
 

 
--- Dumping structure for table acore_world.gossip_menu
+-- Dumping structure for table tc_world.gossip_menu
 DROP TABLE IF EXISTS `gossip_menu`;
 CREATE TABLE IF NOT EXISTS `gossip_menu` (
-  `entry` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `text_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`entry`,`text_id`)
+  `MenuID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `TextID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuID`,`TextID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.gossip_menu_option
+-- Dumping structure for table tc_world.gossip_menu_option
 DROP TABLE IF EXISTS `gossip_menu_option`;
 CREATE TABLE IF NOT EXISTS `gossip_menu_option` (
-  `menu_id` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `id` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `option_icon` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `option_text` text,
-  `option_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `npc_option_npcflag` int(10) unsigned NOT NULL DEFAULT '0',
-  `action_menu_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `action_poi_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `box_coded` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `box_money` int(10) unsigned NOT NULL DEFAULT '0',
-  `box_text` text,
-  PRIMARY KEY (`menu_id`,`id`)
+  `MenuID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OptionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OptionIcon` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `OptionText` text,
+  `OptionBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0',
+  `OptionType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `OptionNpcFlag` int(10) unsigned NOT NULL DEFAULT '0',
+  `ActionMenuID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ActionPoiID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `BoxCoded` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `BoxMoney` int(10) unsigned NOT NULL DEFAULT '0',
+  `BoxText` text,
+  `BoxBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuID`,`OptionID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.gossip_menu_option_locale
+DROP TABLE IF EXISTS `gossip_menu_option_locale`;
+CREATE TABLE IF NOT EXISTS `gossip_menu_option_locale` (
+  `MenuID` smallint(6) unsigned NOT NULL DEFAULT '0',
+  `OptionID` smallint(6) unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) NOT NULL,
+  `OptionText` text,
+  `BoxText` text,
+  PRIMARY KEY (`MenuID`,`OptionID`,`Locale`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.holiday_dates
+-- Dumping structure for table tc_world.graveyard_zone
+DROP TABLE IF EXISTS `graveyard_zone`;
+CREATE TABLE IF NOT EXISTS `graveyard_zone` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `GhostZone` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Comment` text,
+  PRIMARY KEY (`ID`,`GhostZone`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
+
+
+-- Dumping structure for table tc_world.holiday_dates
 DROP TABLE IF EXISTS `holiday_dates`;
 CREATE TABLE IF NOT EXISTS `holiday_dates` (
   `id` int(10) unsigned NOT NULL,
   `date_id` tinyint(3) unsigned NOT NULL,
   `date_value` int(10) unsigned NOT NULL,
   PRIMARY KEY (`id`,`date_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.instance_template
+-- Dumping structure for table tc_world.instance_spawn_groups
+DROP TABLE IF EXISTS `instance_spawn_groups`;
+CREATE TABLE IF NOT EXISTS `instance_spawn_groups` (
+  `instanceMapId` smallint(5) unsigned NOT NULL,
+  `bossStateId` tinyint(3) unsigned NOT NULL,
+  `bossStates` tinyint(3) unsigned NOT NULL,
+  `spawnGroupId` int(10) unsigned NOT NULL,
+  `flags` tinyint(3) unsigned NOT NULL,
+  PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.instance_template
 DROP TABLE IF EXISTS `instance_template`;
 CREATE TABLE IF NOT EXISTS `instance_template` (
   `map` smallint(5) unsigned NOT NULL,
@@ -1015,7 +1101,7 @@ CREATE TABLE IF NOT EXISTS `instance_template` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

--- Dumping structure for table acore_world.item_set_names
+-- Dumping structure for table tc_world.item_set_names
 DROP TABLE IF EXISTS `item_set_names`;
 CREATE TABLE IF NOT EXISTS `item_set_names` (
   `entry` mediumint(8) unsigned NOT NULL,
   `name` varchar(255) NOT NULL DEFAULT '',
   `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.item_template
+-- Dumping structure for table tc_world.item_set_names_locale
+DROP TABLE IF EXISTS `item_set_names_locale`;
+CREATE TABLE IF NOT EXISTS `item_set_names_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.item_template
 DROP TABLE IF EXISTS `item_template`;
 CREATE TABLE IF NOT EXISTS `item_template` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -1194,14 +1291,26 @@ CREATE TABLE IF NOT EXISTS `item_template` (
   `minMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0',
   `maxMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0',
   `flagsCustom` int(10) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`),
   KEY `items_index` (`class`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
 
 
--- Dumping structure for table acore_world.lfg_dungeon_rewards
+-- Dumping structure for table tc_world.item_template_locale
+DROP TABLE IF EXISTS `item_template_locale`;
+CREATE TABLE IF NOT EXISTS `item_template_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name` text,
+  `Description` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.lfg_dungeon_rewards
 DROP TABLE IF EXISTS `lfg_dungeon_rewards`;
 CREATE TABLE IF NOT EXISTS `lfg_dungeon_rewards` (
   `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc',
@@ -1212,7 +1321,7 @@ CREATE TABLE IF NOT EXISTS `lfg_dungeon_rewards` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.lfg_dungeon_template
+-- Dumping structure for table tc_world.lfg_dungeon_template
 DROP TABLE IF EXISTS `lfg_dungeon_template`;
 CREATE TABLE IF NOT EXISTS `lfg_dungeon_template` (
   `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc',
@@ -1221,11 +1330,12 @@ CREATE TABLE IF NOT EXISTS `lfg_dungeon_template` (
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`dungeonId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

 
--- Dumping structure for table acore_world.locales_achievement_reward
-DROP TABLE IF EXISTS `locales_achievement_reward`;
-CREATE TABLE IF NOT EXISTS `locales_achievement_reward` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `subject_loc1` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc2` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc3` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc4` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc5` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc6` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc7` varchar(100) NOT NULL DEFAULT '',
-  `subject_loc8` varchar(100) NOT NULL DEFAULT '',
-  `text_loc1` text,
-  `text_loc2` text,
-  `text_loc3` text,
-  `text_loc4` text,
-  `text_loc5` text,
-  `text_loc6` text,
-  `text_loc7` text,
-  `text_loc8` text,
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_broadcast_text
-DROP TABLE IF EXISTS `locales_broadcast_text`;
-CREATE TABLE IF NOT EXISTS `locales_broadcast_text` (
-  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `MaleText_loc1` longtext,
-  `MaleText_loc2` longtext,
-  `MaleText_loc3` longtext,
-  `MaleText_loc4` longtext,
-  `MaleText_loc5` longtext,
-  `MaleText_loc6` longtext,
-  `MaleText_loc7` longtext,
-  `MaleText_loc8` longtext,
-  `FemaleText_loc1` longtext,
-  `FemaleText_loc2` longtext,
-  `FemaleText_loc3` longtext,
-  `FemaleText_loc4` longtext,
-  `FemaleText_loc5` longtext,
-  `FemaleText_loc6` longtext,
-  `FemaleText_loc7` longtext,
-  `FemaleText_loc8` longtext,
-  `VerifiedBuild` smallint(5) DEFAULT '0',
-  PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_creature_text
-DROP TABLE IF EXISTS `locales_creature_text`;
-CREATE TABLE IF NOT EXISTS `locales_creature_text` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `text_loc1` text,
-  `text_loc2` text,
-  `text_loc3` text,
-  `text_loc4` text,
-  `text_loc5` text,
-  `text_loc6` text,
-  `text_loc7` text,
-  `text_loc8` text,
-  PRIMARY KEY (`entry`,`groupid`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_gossip_menu_option
-DROP TABLE IF EXISTS `locales_gossip_menu_option`;
-CREATE TABLE IF NOT EXISTS `locales_gossip_menu_option` (
-  `menu_id` smallint(6) unsigned NOT NULL DEFAULT '0',
-  `id` smallint(6) unsigned NOT NULL DEFAULT '0',
-  `option_text_loc1` text,
-  `option_text_loc2` text,
-  `option_text_loc3` text,
-  `option_text_loc4` text,
-  `option_text_loc5` text,
-  `option_text_loc6` text,
-  `option_text_loc7` text,
-  `option_text_loc8` text,
-  `box_text_loc1` text,
-  `box_text_loc2` text,
-  `box_text_loc3` text,
-  `box_text_loc4` text,
-  `box_text_loc5` text,
-  `box_text_loc6` text,
-  `box_text_loc7` text,
-  `box_text_loc8` text,
-  PRIMARY KEY (`menu_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_item
-DROP TABLE IF EXISTS `locales_item`;
-CREATE TABLE IF NOT EXISTS `locales_item` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `name_loc1` varchar(100) NOT NULL DEFAULT '',
-  `name_loc2` varchar(100) NOT NULL DEFAULT '',
-  `name_loc3` varchar(100) NOT NULL DEFAULT '',
-  `name_loc4` varchar(100) NOT NULL DEFAULT '',
-  `name_loc5` varchar(100) NOT NULL DEFAULT '',
-  `name_loc6` varchar(100) NOT NULL DEFAULT '',
-  `name_loc7` varchar(100) NOT NULL DEFAULT '',
-  `name_loc8` varchar(100) NOT NULL DEFAULT '',
-  `description_loc1` varchar(255) DEFAULT NULL,
-  `description_loc2` varchar(255) DEFAULT NULL,
-  `description_loc3` varchar(255) DEFAULT NULL,
-  `description_loc4` varchar(255) DEFAULT NULL,
-  `description_loc5` varchar(255) DEFAULT NULL,
-  `description_loc6` varchar(255) DEFAULT NULL,
-  `description_loc7` varchar(255) DEFAULT NULL,
-  `description_loc8` varchar(255) DEFAULT NULL,
-  `VerifiedBuild` smallint(5) DEFAULT '0',
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_item_set_names
-DROP TABLE IF EXISTS `locales_item_set_names`;
-CREATE TABLE IF NOT EXISTS `locales_item_set_names` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `name_loc1` varchar(100) NOT NULL DEFAULT '',
-  `name_loc2` varchar(100) NOT NULL DEFAULT '',
-  `name_loc3` varchar(100) NOT NULL DEFAULT '',
-  `name_loc4` varchar(100) NOT NULL DEFAULT '',
-  `name_loc5` varchar(100) NOT NULL DEFAULT '',
-  `name_loc6` varchar(100) NOT NULL DEFAULT '',
-  `name_loc7` varchar(100) NOT NULL DEFAULT '',
-  `name_loc8` varchar(100) NOT NULL DEFAULT '',
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_npc_text
-DROP TABLE IF EXISTS `locales_npc_text`;
-CREATE TABLE IF NOT EXISTS `locales_npc_text` (
-  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `Text0_0_loc1` longtext,
-  `Text0_0_loc2` longtext,
-  `Text0_0_loc3` longtext,
-  `Text0_0_loc4` longtext,
-  `Text0_0_loc5` longtext,
-  `Text0_0_loc6` longtext,
-  `Text0_0_loc7` longtext,
-  `Text0_0_loc8` longtext,
-  `Text0_1_loc1` longtext,
-  `Text0_1_loc2` longtext,
-  `Text0_1_loc3` longtext,
-  `Text0_1_loc4` longtext,
-  `Text0_1_loc5` longtext,
-  `Text0_1_loc6` longtext,
-  `Text0_1_loc7` longtext,
-  `Text0_1_loc8` longtext,
-  `Text1_0_loc1` longtext,
-  `Text1_0_loc2` longtext,
-  `Text1_0_loc3` longtext,
-  `Text1_0_loc4` longtext,
-  `Text1_0_loc5` longtext,
-  `Text1_0_loc6` longtext,
-  `Text1_0_loc7` longtext,
-  `Text1_0_loc8` longtext,
-  `Text1_1_loc1` longtext,
-  `Text1_1_loc2` longtext,
-  `Text1_1_loc3` longtext,
-  `Text1_1_loc4` longtext,
-  `Text1_1_loc5` longtext,
-  `Text1_1_loc6` longtext,
-  `Text1_1_loc7` longtext,
-  `Text1_1_loc8` longtext,
-  `Text2_0_loc1` longtext,
-  `Text2_0_loc2` longtext,
-  `Text2_0_loc3` longtext,
-  `Text2_0_loc4` longtext,
-  `Text2_0_loc5` longtext,
-  `Text2_0_loc6` longtext,
-  `Text2_0_loc7` longtext,
-  `Text2_0_loc8` longtext,
-  `Text2_1_loc1` longtext,
-  `Text2_1_loc2` longtext,
-  `Text2_1_loc3` longtext,
-  `Text2_1_loc4` longtext,
-  `Text2_1_loc5` longtext,
-  `Text2_1_loc6` longtext,
-  `Text2_1_loc7` longtext,
-  `Text2_1_loc8` longtext,
-  `Text3_0_loc1` longtext,
-  `Text3_0_loc2` longtext,
-  `Text3_0_loc3` longtext,
-  `Text3_0_loc4` longtext,
-  `Text3_0_loc5` longtext,
-  `Text3_0_loc6` longtext,
-  `Text3_0_loc7` longtext,
-  `Text3_0_loc8` longtext,
-  `Text3_1_loc1` longtext,
-  `Text3_1_loc2` longtext,
-  `Text3_1_loc3` longtext,
-  `Text3_1_loc4` longtext,
-  `Text3_1_loc5` longtext,
-  `Text3_1_loc6` longtext,
-  `Text3_1_loc7` longtext,
-  `Text3_1_loc8` longtext,
-  `Text4_0_loc1` longtext,
-  `Text4_0_loc2` longtext,
-  `Text4_0_loc3` longtext,
-  `Text4_0_loc4` longtext,
-  `Text4_0_loc5` longtext,
-  `Text4_0_loc6` longtext,
-  `Text4_0_loc7` longtext,
-  `Text4_0_loc8` longtext,
-  `Text4_1_loc1` longtext,
-  `Text4_1_loc2` longtext,
-  `Text4_1_loc3` longtext,
-  `Text4_1_loc4` longtext,
-  `Text4_1_loc5` longtext,
-  `Text4_1_loc6` longtext,
-  `Text4_1_loc7` longtext,
-  `Text4_1_loc8` longtext,
-  `Text5_0_loc1` longtext,
-  `Text5_0_loc2` longtext,
-  `Text5_0_loc3` longtext,
-  `Text5_0_loc4` longtext,
-  `Text5_0_loc5` longtext,
-  `Text5_0_loc6` longtext,
-  `Text5_0_loc7` longtext,
-  `Text5_0_loc8` longtext,
-  `Text5_1_loc1` longtext,
-  `Text5_1_loc2` longtext,
-  `Text5_1_loc3` longtext,
-  `Text5_1_loc4` longtext,
-  `Text5_1_loc5` longtext,
-  `Text5_1_loc6` longtext,
-  `Text5_1_loc7` longtext,
-  `Text5_1_loc8` longtext,
-  `Text6_0_loc1` longtext,
-  `Text6_0_loc2` longtext,
-  `Text6_0_loc3` longtext,
-  `Text6_0_loc4` longtext,
-  `Text6_0_loc5` longtext,
-  `Text6_0_loc6` longtext,
-  `Text6_0_loc7` longtext,
-  `Text6_0_loc8` longtext,
-  `Text6_1_loc1` longtext,
-  `Text6_1_loc2` longtext,
-  `Text6_1_loc3` longtext,
-  `Text6_1_loc4` longtext,
-  `Text6_1_loc5` longtext,
-  `Text6_1_loc6` longtext,
-  `Text6_1_loc7` longtext,
-  `Text6_1_loc8` longtext,
-  `Text7_0_loc1` longtext,
-  `Text7_0_loc2` longtext,
-  `Text7_0_loc3` longtext,
-  `Text7_0_loc4` longtext,
-  `Text7_0_loc5` longtext,
-  `Text7_0_loc6` longtext,
-  `Text7_0_loc7` longtext,
-  `Text7_0_loc8` longtext,
-  `Text7_1_loc1` longtext,
-  `Text7_1_loc2` longtext,
-  `Text7_1_loc3` longtext,
-  `Text7_1_loc4` longtext,
-  `Text7_1_loc5` longtext,
-  `Text7_1_loc6` longtext,
-  `Text7_1_loc7` longtext,
-  `Text7_1_loc8` longtext,
-  PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_page_text
-DROP TABLE IF EXISTS `locales_page_text`;
-CREATE TABLE IF NOT EXISTS `locales_page_text` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `Text_loc1` longtext,
-  `Text_loc2` longtext,
-  `Text_loc3` longtext,
-  `Text_loc4` longtext,
-  `Text_loc5` longtext,
-  `Text_loc6` longtext,
-  `Text_loc7` longtext,
-  `Text_loc8` longtext,
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_points_of_interest
-DROP TABLE IF EXISTS `locales_points_of_interest`;
-CREATE TABLE IF NOT EXISTS `locales_points_of_interest` (
-  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `icon_name_loc1` text,
-  `icon_name_loc2` text,
-  `icon_name_loc3` text,
-  `icon_name_loc4` text,
-  `icon_name_loc5` text,
-  `icon_name_loc6` text,
-  `icon_name_loc7` text,
-  `icon_name_loc8` text,
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.locales_quest
-DROP TABLE IF EXISTS `locales_quest`;
-CREATE TABLE IF NOT EXISTS `locales_quest` (
-  `Id` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `Title_loc1` text,
-  `Title_loc2` text,
-  `Title_loc3` text,
-  `Title_loc4` text,
-  `Title_loc5` text,
-  `Title_loc6` text,
-  `Title_loc7` text,
-  `Title_loc8` text,
-  `Details_loc1` text,
-  `Details_loc2` text,
-  `Details_loc3` text,
-  `Details_loc4` text,
-  `Details_loc5` text,
-  `Details_loc6` text,
-  `Details_loc7` text,
-  `Details_loc8` text,
-  `Objectives_loc1` text,
-  `Objectives_loc2` text,
-  `Objectives_loc3` text,
-  `Objectives_loc4` text,
-  `Objectives_loc5` text,
-  `Objectives_loc6` text,
-  `Objectives_loc7` text,
-  `Objectives_loc8` text,
-  `OfferRewardText_loc1` text,
-  `OfferRewardText_loc2` text,
-  `OfferRewardText_loc3` text,
-  `OfferRewardText_loc4` text,
-  `OfferRewardText_loc5` text,
-  `OfferRewardText_loc6` text,
-  `OfferRewardText_loc7` text,
-  `OfferRewardText_loc8` text,
-  `RequestItemsText_loc1` text,
-  `RequestItemsText_loc2` text,
-  `RequestItemsText_loc3` text,
-  `RequestItemsText_loc4` text,
-  `RequestItemsText_loc5` text,
-  `RequestItemsText_loc6` text,
-  `RequestItemsText_loc7` text,
-  `RequestItemsText_loc8` text,
-  `EndText_loc1` text,
-  `EndText_loc2` text,
-  `EndText_loc3` text,
-  `EndText_loc4` text,
-  `EndText_loc5` text,
-  `EndText_loc6` text,
-  `EndText_loc7` text,
-  `EndText_loc8` text,
-  `CompletedText_loc1` text,
-  `CompletedText_loc2` text,
-  `CompletedText_loc3` text,
-  `CompletedText_loc4` text,
-  `CompletedText_loc5` text,
-  `CompletedText_loc6` text,
-  `CompletedText_loc7` text,
-  `CompletedText_loc8` text,
-  `ObjectiveText1_loc1` text,
-  `ObjectiveText1_loc2` text,
-  `ObjectiveText1_loc3` text,
-  `ObjectiveText1_loc4` text,
-  `ObjectiveText1_loc5` text,
-  `ObjectiveText1_loc6` text,
-  `ObjectiveText1_loc7` text,
-  `ObjectiveText1_loc8` text,
-  `ObjectiveText2_loc1` text,
-  `ObjectiveText2_loc2` text,
-  `ObjectiveText2_loc3` text,
-  `ObjectiveText2_loc4` text,
-  `ObjectiveText2_loc5` text,
-  `ObjectiveText2_loc6` text,
-  `ObjectiveText2_loc7` text,
-  `ObjectiveText2_loc8` text,
-  `ObjectiveText3_loc1` text,
-  `ObjectiveText3_loc2` text,
-  `ObjectiveText3_loc3` text,
-  `ObjectiveText3_loc4` text,
-  `ObjectiveText3_loc5` text,
-  `ObjectiveText3_loc6` text,
-  `ObjectiveText3_loc7` text,
-  `ObjectiveText3_loc8` text,
-  `ObjectiveText4_loc1` text,
-  `ObjectiveText4_loc2` text,
-  `ObjectiveText4_loc3` text,
-  `ObjectiveText4_loc4` text,
-  `ObjectiveText4_loc5` text,
-  `ObjectiveText4_loc6` text,
-  `ObjectiveText4_loc7` text,
-  `ObjectiveText4_loc8` text,
-  `VerifiedBuild` smallint(5) DEFAULT '0',
-  PRIMARY KEY (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
 
 
--- Dumping structure for table acore_world.npc_text
+-- Dumping structure for table tc_world.npc_text
 DROP TABLE IF EXISTS `npc_text`;
 CREATE TABLE IF NOT EXISTS `npc_text` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `text0_0` longtext,
   `text0_1` longtext,
+  `BroadcastTextID0` mediumint(6) NOT NULL DEFAULT '0',
   `lang0` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability0` float NOT NULL DEFAULT '0',
   `em0_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1705,6 +1418,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em0_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text1_0` longtext,
   `text1_1` longtext,
+  `BroadcastTextID1` mediumint(6) NOT NULL DEFAULT '0',
   `lang1` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability1` float NOT NULL DEFAULT '0',
   `em1_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1715,6 +1429,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em1_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text2_0` longtext,
   `text2_1` longtext,
+  `BroadcastTextID2` mediumint(6) NOT NULL DEFAULT '0',
   `lang2` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability2` float NOT NULL DEFAULT '0',
   `em2_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1725,6 +1440,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em2_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text3_0` longtext,
   `text3_1` longtext,
+  `BroadcastTextID3` mediumint(6) NOT NULL DEFAULT '0',
   `lang3` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability3` float NOT NULL DEFAULT '0',
   `em3_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1735,6 +1451,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em3_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text4_0` longtext,
   `text4_1` longtext,
+  `BroadcastTextID4` mediumint(6) NOT NULL DEFAULT '0',
   `lang4` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability4` float NOT NULL DEFAULT '0',
   `em4_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1745,6 +1462,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em4_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text5_0` longtext,
   `text5_1` longtext,
+  `BroadcastTextID5` mediumint(6) NOT NULL DEFAULT '0',
   `lang5` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability5` float NOT NULL DEFAULT '0',
   `em5_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1755,6 +1473,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em5_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text6_0` longtext,
   `text6_1` longtext,
+  `BroadcastTextID6` mediumint(6) NOT NULL DEFAULT '0',
   `lang6` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability6` float NOT NULL DEFAULT '0',
   `em6_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1765,6 +1484,7 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em6_5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `text7_0` longtext,
   `text7_1` longtext,
+  `BroadcastTextID7` mediumint(6) NOT NULL DEFAULT '0',
   `lang7` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Probability7` float NOT NULL DEFAULT '0',
   `em7_0` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1773,12 +1493,37 @@ CREATE TABLE IF NOT EXISTS `npc_text` (
   `em7_3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `em7_4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `em7_5` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.npc_trainer
+-- Dumping structure for table tc_world.npc_text_locale
+DROP TABLE IF EXISTS `npc_text_locale`;
+CREATE TABLE IF NOT EXISTS `npc_text_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) NOT NULL,
+  `Text0_0` longtext,
+  `Text0_1` longtext,
+  `Text1_0` longtext,
+  `Text1_1` longtext,
+  `Text2_0` longtext,
+  `Text2_1` longtext,
+  `Text3_0` longtext,
+  `Text3_1` longtext,
+  `Text4_0` longtext,
+  `Text4_1` longtext,
+  `Text5_0` longtext,
+  `Text5_1` longtext,
+  `Text6_0` longtext,
+  `Text6_1` longtext,
+  `Text7_0` longtext,
+  `Text7_1` longtext,
+  PRIMARY KEY (`ID`,`Locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+

--- Dumping structure for table acore_world.npc_vendor
+-- Dumping structure for table tc_world.npc_vendor
 DROP TABLE IF EXISTS `npc_vendor`;
 CREATE TABLE IF NOT EXISTS `npc_vendor` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -1800,12 +1545,13 @@ CREATE TABLE IF NOT EXISTS `npc_vendor` (
   `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `incrtime` int(10) unsigned NOT NULL DEFAULT '0',
   `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
   KEY `slot` (`slot`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';
 
 
 
--- Dumping structure for table acore_world.pet_levelstats
+-- Dumping structure for table tc_world.page_text_locale
+DROP TABLE IF EXISTS `page_text_locale`;
+CREATE TABLE IF NOT EXISTS `page_text_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Text` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.pet_levelstats
 DROP TABLE IF EXISTS `pet_levelstats`;
 CREATE TABLE IF NOT EXISTS `pet_levelstats` (
   `creature_entry` mediumint(8) unsigned NOT NULL,
@@ -1845,7 +1602,7 @@ CREATE TABLE IF NOT EXISTS `pet_levelstats` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
 
 
--- Dumping structure for table acore_world.playercreateinfo_item
+-- Dumping structure for table tc_world.playercreateinfo_cast_spell
+DROP TABLE IF EXISTS `playercreateinfo_cast_spell`;
+CREATE TABLE IF NOT EXISTS `playercreateinfo_cast_spell` (
+  `raceMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `classMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `note` varchar(255) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.playercreateinfo_item
 DROP TABLE IF EXISTS `playercreateinfo_item`;
 CREATE TABLE IF NOT EXISTS `playercreateinfo_item` (
   `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -1913,18 +1680,19 @@ CREATE TABLE IF NOT EXISTS `playercreateinfo_item` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.playercreateinfo_spell
-DROP TABLE IF EXISTS `playercreateinfo_spell`;
-CREATE TABLE IF NOT EXISTS `playercreateinfo_spell` (
-  `racemask` int(10) unsigned NOT NULL DEFAULT '0',
-  `classmask` int(10) unsigned NOT NULL DEFAULT '0',
-  `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `Note` varchar(255) DEFAULT NULL,
-  PRIMARY KEY (`racemask`,`classmask`,`Spell`)
+-- Dumping structure for table tc_world.playercreateinfo_skills
+DROP TABLE IF EXISTS `playercreateinfo_skills`;
+CREATE TABLE IF NOT EXISTS `playercreateinfo_skills` (
+  `raceMask` int(10) unsigned NOT NULL,
+  `classMask` int(10) unsigned NOT NULL,
+  `skill` smallint(5) unsigned NOT NULL,
+  `rank` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `comment` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`raceMask`,`classMask`,`skill`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
--- Dumping structure for table acore_world.player_factionchange_items
+-- Dumping structure for table tc_world.player_factionchange_items
 DROP TABLE IF EXISTS `player_factionchange_items`;
 CREATE TABLE IF NOT EXISTS `player_factionchange_items` (
+  `race_A` int(10) unsigned NOT NULL,
   `alliance_id` int(10) unsigned NOT NULL,
-  `alliance_comment` text NOT NULL,
+  `commentA` text,
+  `race_H` int(10) unsigned NOT NULL,
   `horde_id` int(10) unsigned NOT NULL,
-  `horde_comment` text NOT NULL,
+  `commentH` text,
   PRIMARY KEY (`alliance_id`,`horde_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

--- Dumping structure for table acore_world.player_factionchange_spells
+-- Dumping structure for table tc_world.player_factionchange_spells
 DROP TABLE IF EXISTS `player_factionchange_spells`;
 CREATE TABLE IF NOT EXISTS `player_factionchange_spells` (
   `alliance_id` int(10) unsigned NOT NULL,
-  `alliance_comment` text NOT NULL,
   `horde_id` int(10) unsigned NOT NULL,
-  `horde_comment` text NOT NULL,
   PRIMARY KEY (`alliance_id`,`horde_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
--- Dumping structure for table acore_world.points_of_interest
+-- Dumping structure for table tc_world.points_of_interest
 DROP TABLE IF EXISTS `points_of_interest`;
 CREATE TABLE IF NOT EXISTS `points_of_interest` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2038,13 +1806,25 @@ CREATE TABLE IF NOT EXISTS `points_of_interest` (
   `PositionY` float NOT NULL DEFAULT '0',
   `Icon` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Flags` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `Data` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Importance` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Name` text NOT NULL,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.pool_creature
+-- Dumping structure for table tc_world.points_of_interest_locale
+DROP TABLE IF EXISTS `points_of_interest_locale`;
+CREATE TABLE IF NOT EXISTS `points_of_interest_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.pool_creature
 DROP TABLE IF EXISTS `pool_creature`;
 CREATE TABLE IF NOT EXISTS `pool_creature` (
   `guid` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2056,7 +1836,7 @@ CREATE TABLE IF NOT EXISTS `pool_creature` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.quest_offer_reward
+-- Dumping structure for table tc_world.quest_greeting
+DROP TABLE IF EXISTS `quest_greeting`;
+CREATE TABLE IF NOT EXISTS `quest_greeting` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GreetEmoteType` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `GreetEmoteDelay` int(10) unsigned NOT NULL DEFAULT '0',
+  `Greeting` text,
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`Type`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.quest_greeting_locale
+DROP TABLE IF EXISTS `quest_greeting_locale`;
+CREATE TABLE IF NOT EXISTS `quest_greeting_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Greeting` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`Type`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.quest_mail_sender
+DROP TABLE IF EXISTS `quest_mail_sender`;
+CREATE TABLE IF NOT EXISTS `quest_mail_sender` (
+  `QuestId` int(5) unsigned NOT NULL DEFAULT '0',
+  `RewardMailSenderEntry` int(5) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.quest_offer_reward
 DROP TABLE IF EXISTS `quest_offer_reward`;
 CREATE TABLE IF NOT EXISTS `quest_offer_reward` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2152,7 +1966,18 @@ CREATE TABLE IF NOT EXISTS `quest_offer_reward` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.quest_poi
+-- Dumping structure for table tc_world.quest_offer_reward_locale
+DROP TABLE IF EXISTS `quest_offer_reward_locale`;
+CREATE TABLE IF NOT EXISTS `quest_offer_reward_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `RewardText` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+-- Dumping structure for table tc_world.quest_poi
 DROP TABLE IF EXISTS `quest_poi`;
 CREATE TABLE IF NOT EXISTS `quest_poi` (
   `QuestID` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2163,12 +1988,13 @@ CREATE TABLE IF NOT EXISTS `quest_poi` (
   `Floor` int(10) unsigned NOT NULL DEFAULT '0',
   `Priority` int(10) unsigned NOT NULL DEFAULT '0',
   `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`QuestID`,`id`),
   KEY `idx` (`QuestID`,`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.quest_poi_points
+-- Dumping structure for table tc_world.quest_poi_points
 DROP TABLE IF EXISTS `quest_poi_points`;
 CREATE TABLE IF NOT EXISTS `quest_poi_points` (
   `QuestID` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2176,12 +2002,13 @@ CREATE TABLE IF NOT EXISTS `quest_poi_points` (
   `Idx2` int(10) unsigned NOT NULL DEFAULT '0',
   `X` int(11) NOT NULL DEFAULT '0',
   `Y` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`),
   KEY `questId_id` (`QuestID`,`Idx1`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.quest_template
+-- Dumping structure for table tc_world.quest_request_items_locale
+DROP TABLE IF EXISTS `quest_request_items_locale`;
+CREATE TABLE IF NOT EXISTS `quest_request_items_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `CompletionText` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+-- Dumping structure for table tc_world.quest_template
 DROP TABLE IF EXISTS `quest_template`;
 CREATE TABLE IF NOT EXISTS `quest_template` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2300,12 +2138,12 @@ CREATE TABLE IF NOT EXISTS `quest_template` (
   `ObjectiveText2` text,
   `ObjectiveText3` text,
   `ObjectiveText4` text,
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '1',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';
 
 
--- Dumping structure for table acore_world.quest_template_addon
+-- Dumping structure for table tc_world.quest_template_addon
 DROP TABLE IF EXISTS `quest_template_addon`;
 CREATE TABLE IF NOT EXISTS `quest_template_addon` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2313,7 +2151,7 @@ CREATE TABLE IF NOT EXISTS `quest_template_addon` (
   `AllowableClasses` int(10) unsigned NOT NULL DEFAULT '0',
   `SourceSpellID` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `PrevQuestID` mediumint(8) NOT NULL DEFAULT '0',
-  `NextQuestID` mediumint(8) NOT NULL DEFAULT '0',
+  `NextQuestID` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0',
   `RewardMailTemplateID` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewardMailDelay` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2329,7 +2167,26 @@ CREATE TABLE IF NOT EXISTS `quest_template_addon` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.reference_loot_template
+-- Dumping structure for table tc_world.quest_template_locale
+DROP TABLE IF EXISTS `quest_template_locale`;
+CREATE TABLE IF NOT EXISTS `quest_template_locale` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Title` text,
+  `Details` text,
+  `Objectives` text,
+  `EndText` text,
+  `CompletedText` text,
+  `ObjectiveText1` text,
+  `ObjectiveText2` text,
+  `ObjectiveText3` text,
+  `ObjectiveText4` text,
+  `VerifiedBuild` smallint(5) DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.reference_loot_template
 DROP TABLE IF EXISTS `reference_loot_template`;
 CREATE TABLE IF NOT EXISTS `reference_loot_template` (
   `Entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2346,7 +2203,7 @@ CREATE TABLE IF NOT EXISTS `reference_loot_template` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
 
 
--- Dumping structure for table acore_world.script_waypoint
+-- Dumping structure for table tc_world.script_spline_chain_meta
+DROP TABLE IF EXISTS `script_spline_chain_meta`;
+CREATE TABLE IF NOT EXISTS `script_spline_chain_meta` (
+  `entry` int(10) unsigned NOT NULL,
+  `chainId` smallint(5) unsigned NOT NULL,
+  `splineId` tinyint(3) unsigned NOT NULL,
+  `expectedDuration` int(10) unsigned NOT NULL,
+  `msUntilNext` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.script_spline_chain_waypoints
+DROP TABLE IF EXISTS `script_spline_chain_waypoints`;
+CREATE TABLE IF NOT EXISTS `script_spline_chain_waypoints` (
+  `entry` int(10) unsigned NOT NULL,
+  `chainId` smallint(5) unsigned NOT NULL,
+  `splineId` tinyint(3) unsigned NOT NULL,
+  `wpId` tinyint(3) unsigned NOT NULL,
+  `x` float NOT NULL,
+  `y` float NOT NULL,
+  `z` float NOT NULL,
+  PRIMARY KEY (`entry`,`chainId`,`splineId`,`wpId`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.script_waypoint
 DROP TABLE IF EXISTS `script_waypoint`;
 CREATE TABLE IF NOT EXISTS `script_waypoint` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry',
@@ -2395,7 +2278,7 @@ CREATE TABLE IF NOT EXISTS `script_waypoint` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints';
 
--- Dumping structure for table acore_world.skill_extra_item_template
+-- Dumping structure for table tc_world.skill_extra_item_template
 DROP TABLE IF EXISTS `skill_extra_item_template`;
 CREATE TABLE IF NOT EXISTS `skill_extra_item_template` (
   `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
   `requiredSpecialization` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
   `additionalCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create add',
-  `newMaxOrEntry` mediumint(8) NOT NULL DEFAULT '0',
+  `additionalMaxNum` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'max num of adds',
   PRIMARY KEY (`spellId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System';
 
 
--- Dumping structure for table acore_world.skinning_loot_template
+-- Dumping structure for table tc_world.skill_perfect_item_template
+DROP TABLE IF EXISTS `skill_perfect_item_template`;
+CREATE TABLE IF NOT EXISTS `skill_perfect_item_template` (
+  `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
+  `requiredSpecialization` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
+  `perfectCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create the perfect item instead',
+  `perfectItemType` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead',
+  PRIMARY KEY (`spellId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Crafting Perfection System';
+
+
+-- Dumping structure for table tc_world.skinning_loot_template
 DROP TABLE IF EXISTS `skinning_loot_template`;
 CREATE TABLE IF NOT EXISTS `skinning_loot_template` (
   `Entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2443,7 +2337,7 @@ CREATE TABLE IF NOT EXISTS `skinning_loot_template` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
 
 
--- Dumping structure for table acore_world.smart_scripts
+-- Dumping structure for table tc_world.smart_scripts
 DROP TABLE IF EXISTS `smart_scripts`;
 CREATE TABLE IF NOT EXISTS `smart_scripts` (
   `entryorguid` int(11) NOT NULL,
@@ -2458,6 +2352,7 @@ CREATE TABLE IF NOT EXISTS `smart_scripts` (
   `event_param2` int(10) unsigned NOT NULL DEFAULT '0',
   `event_param3` int(10) unsigned NOT NULL DEFAULT '0',
   `event_param4` int(10) unsigned NOT NULL DEFAULT '0',
+  `event_param5` int(10) unsigned NOT NULL DEFAULT '0',
   `action_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `action_param1` int(10) unsigned NOT NULL DEFAULT '0',
   `action_param2` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2469,6 +2364,7 @@ CREATE TABLE IF NOT EXISTS `smart_scripts` (
   `target_param1` int(10) unsigned NOT NULL DEFAULT '0',
   `target_param2` int(10) unsigned NOT NULL DEFAULT '0',
   `target_param3` int(10) unsigned NOT NULL DEFAULT '0',
+  `target_param4` int(10) unsigned NOT NULL DEFAULT '0',
   `target_x` float NOT NULL DEFAULT '0',
   `target_y` float NOT NULL DEFAULT '0',
   `target_z` float NOT NULL DEFAULT '0',
@@ -2478,7 +2374,27 @@ CREATE TABLE IF NOT EXISTS `smart_scripts` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
 
 
--- Dumping structure for table acore_world.spelldifficulty_dbc
+-- Dumping structure for table tc_world.spawn_group
+DROP TABLE IF EXISTS `spawn_group`;
+CREATE TABLE IF NOT EXISTS `spawn_group` (
+  `groupId` int(10) unsigned NOT NULL,
+  `spawnType` tinyint(10) unsigned NOT NULL,
+  `spawnId` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`groupId`,`spawnType`,`spawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.spawn_group_template
+DROP TABLE IF EXISTS `spawn_group_template`;
+CREATE TABLE IF NOT EXISTS `spawn_group_template` (
+  `groupId` int(10) unsigned NOT NULL,
+  `groupName` varchar(100) NOT NULL,
+  `groupFlags` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`groupId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+
+-- Dumping structure for table tc_world.spelldifficulty_dbc
 DROP TABLE IF EXISTS `spelldifficulty_dbc`;
 CREATE TABLE IF NOT EXISTS `spelldifficulty_dbc` (
   `id` int(11) unsigned NOT NULL DEFAULT '0',
@@ -2490,7 +2406,7 @@ CREATE TABLE IF NOT EXISTS `spelldifficulty_dbc` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

--- Dumping structure for table acore_world.spell_bonus_data
+-- Dumping structure for table tc_world.spell_bonus_data
 DROP TABLE IF EXISTS `spell_bonus_data`;
 CREATE TABLE IF NOT EXISTS `spell_bonus_data` (
-  `entry` mediumint(5) unsigned NOT NULL,
+  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `direct_bonus` float NOT NULL DEFAULT '0',
   `dot_bonus` float NOT NULL DEFAULT '0',
   `ap_bonus` float NOT NULL DEFAULT '0',
@@ -2520,7 +2436,7 @@ CREATE TABLE IF NOT EXISTS `spell_bonus_data` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 

--- Dumping structure for table acore_world.spell_dbc
+-- Dumping structure for table tc_world.spell_dbc
 DROP TABLE IF EXISTS `spell_dbc`;
 CREATE TABLE IF NOT EXISTS `spell_dbc` (
   `Id` int(10) unsigned NOT NULL,
@@ -2614,6 +2530,7 @@ CREATE TABLE IF NOT EXISTS `spell_dbc` (
   `EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0',
   `EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0',
   `EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellName` varchar(100) DEFAULT NULL,
   `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0',
@@ -2627,43 +2544,51 @@ CREATE TABLE IF NOT EXISTS `spell_dbc` (
   `DmgMultiplier3` float NOT NULL DEFAULT '0',
   `AreaGroupId` int(11) NOT NULL DEFAULT '0',
   `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
-  `Comment` text NOT NULL,
   PRIMARY KEY (`Id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
 
 
--- Dumping structure for table acore_world.spell_enchant_proc_data
+-- Dumping structure for table tc_world.spell_enchant_proc_data
 DROP TABLE IF EXISTS `spell_enchant_proc_data`;
 CREATE TABLE IF NOT EXISTS `spell_enchant_proc_data` (
-  `entry` int(10) unsigned NOT NULL,
-  `customChance` int(10) unsigned NOT NULL DEFAULT '0',
-  `PPMChance` float unsigned NOT NULL DEFAULT '0',
-  `procEx` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`entry`)
+  `EnchantID` int(10) unsigned NOT NULL,
+  `Chance` float NOT NULL DEFAULT '0',
+  `ProcsPerMinute` float NOT NULL DEFAULT '0',
+  `HitMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`EnchantID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
 
 
--- Dumping structure for table acore_world.spell_group
+-- Dumping structure for table tc_world.spell_group
 DROP TABLE IF EXISTS `spell_group`;
 CREATE TABLE IF NOT EXISTS `spell_group` (
   `id` int(10) unsigned NOT NULL DEFAULT '0',
-  `spell_id` int(11) unsigned NOT NULL DEFAULT '0',
-  `special_flag` int(11) unsigned NOT NULL DEFAULT '0',
+  `spell_id` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`spell_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
 
 
--- Dumping structure for table acore_world.spell_group_stack_rules
+-- Dumping structure for table tc_world.spell_group_stack_rules
 DROP TABLE IF EXISTS `spell_group_stack_rules`;
 CREATE TABLE IF NOT EXISTS `spell_group_stack_rules` (
   `group_id` int(11) unsigned NOT NULL DEFAULT '0',
   `stack_rule` tinyint(3) NOT NULL DEFAULT '0',
-  `description` varchar(150) NOT NULL DEFAULT '',
   PRIMARY KEY (`group_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.spell_linked_spell
+-- Dumping structure for table tc_world.spell_learn_spell
+DROP TABLE IF EXISTS `spell_learn_spell`;
+CREATE TABLE IF NOT EXISTS `spell_learn_spell` (
+  `entry` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `SpellID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Active` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  PRIMARY KEY (`entry`,`SpellID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
+
+
+-- Dumping structure for table tc_world.spell_linked_spell
 DROP TABLE IF EXISTS `spell_linked_spell`;
 CREATE TABLE IF NOT EXISTS `spell_linked_spell` (
   `spell_trigger` mediumint(8) NOT NULL,
@@ -2674,7 +2599,7 @@ CREATE TABLE IF NOT EXISTS `spell_linked_spell` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System';
 
 
--- Dumping structure for table acore_world.spell_mixology
-DROP TABLE IF EXISTS `spell_mixology`;
-CREATE TABLE IF NOT EXISTS `spell_mixology` (
-  `entry` mediumint(8) unsigned NOT NULL,
-  `pctMod` float NOT NULL DEFAULT '30' COMMENT 'bonus multiplier',
-  PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
-
-
--- Dumping structure for table acore_world.spell_pet_auras
+-- Dumping structure for table tc_world.spell_pet_auras
 DROP TABLE IF EXISTS `spell_pet_auras`;
 CREATE TABLE IF NOT EXISTS `spell_pet_auras` (
   `spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id',
@@ -2711,47 +2627,29 @@ CREATE TABLE IF NOT EXISTS `spell_pet_auras` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.spell_proc
+-- Dumping structure for table tc_world.spell_proc
 DROP TABLE IF EXISTS `spell_proc`;
 CREATE TABLE IF NOT EXISTS `spell_proc` (
-  `spellId` mediumint(8) NOT NULL DEFAULT '0',
-  `schoolMask` tinyint(4) NOT NULL DEFAULT '0',
-  `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0',
-  `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0',
-  `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0',
-  `typeMask` int(10) unsigned NOT NULL DEFAULT '0',
-  `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0',
-  `spellPhaseMask` int(11) NOT NULL DEFAULT '0',
-  `hitMask` int(11) NOT NULL DEFAULT '0',
-  `attributesMask` int(10) unsigned NOT NULL DEFAULT '0',
-  `ratePerMinute` float NOT NULL DEFAULT '0',
-  `chance` float NOT NULL DEFAULT '0',
-  `cooldown` float unsigned NOT NULL DEFAULT '0',
-  `charges` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`spellId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-
--- Dumping structure for table acore_world.spell_proc_event
-DROP TABLE IF EXISTS `spell_proc_event`;
-CREATE TABLE IF NOT EXISTS `spell_proc_event` (
-  `entry` mediumint(8) NOT NULL DEFAULT '0',
-  `SchoolMask` tinyint(4) NOT NULL DEFAULT '0',
+  `SpellId` int(11) NOT NULL DEFAULT '0',
+  `SchoolMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0',
   `SpellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0',
-  `procFlags` int(10) unsigned NOT NULL DEFAULT '0',
-  `procEx` int(10) unsigned NOT NULL DEFAULT '0',
-  `ppmRate` float NOT NULL DEFAULT '0',
-  `CustomChance` float NOT NULL DEFAULT '0',
+  `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellTypeMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellPhaseMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `HitMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `ProcsPerMinute` float NOT NULL DEFAULT '0',
+  `Chance` float NOT NULL DEFAULT '0',
   `Cooldown` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`entry`)
+  `Charges` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`SpellId`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
--- Dumping structure for table acore_world.spell_target_position
+-- Dumping structure for table tc_world.spell_target_position
 DROP TABLE IF EXISTS `spell_target_position`;
 CREATE TABLE IF NOT EXISTS `spell_target_position` (
   `ID` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
@@ -2807,11 +2705,12 @@ CREATE TABLE IF NOT EXISTS `spell_target_position` (
   `PositionY` float NOT NULL DEFAULT '0',
   `PositionZ` float NOT NULL DEFAULT '0',
   `Orientation` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) DEFAULT '0',
   PRIMARY KEY (`ID`,`EffectIndex`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
 
 
--- Dumping structure for table acore_world.vehicle_accessory
+-- Dumping structure for table tc_world.updates
+DROP TABLE IF EXISTS `updates`;
+CREATE TABLE IF NOT EXISTS `updates` (
+  `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.',
+  `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
+  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
+  `speed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
+  PRIMARY KEY (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.';
+
+
+-- Dumping structure for table tc_world.updates_include
+DROP TABLE IF EXISTS `updates_include`;
+CREATE TABLE IF NOT EXISTS `updates_include` (
+  `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
+  PRIMARY KEY (`path`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.';
+
+
+-- Dumping structure for table tc_world.vehicle_accessory
 DROP TABLE IF EXISTS `vehicle_accessory`;
 CREATE TABLE IF NOT EXISTS `vehicle_accessory` (
   `guid` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -2865,7 +2785,7 @@ CREATE TABLE IF NOT EXISTS `vehicle_accessory` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
 

 
--- Dumping structure for table acore_world.version
+-- Dumping structure for table tc_world.version
 DROP TABLE IF EXISTS `version`;
 CREATE TABLE IF NOT EXISTS `version` (
-  `core_version` varchar(120) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
+  `core_version` varchar(255) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
   `core_revision` varchar(120) DEFAULT NULL,
   `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.',
   `cache_id` int(11) DEFAULT '0',
@@ -2890,19 +2810,7 @@ CREATE TABLE IF NOT EXISTS `version` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes';
 

--- Dumping structure for table acore_world.version_db_world
-DROP TABLE IF EXISTS `version_db_world`;
-CREATE TABLE IF NOT EXISTS `version_db_world` (
-  `sql_rev` varchar(100) NOT NULL,
-  `required_rev` varchar(100) DEFAULT NULL,
-  `2018_12_28_00` bit(1) DEFAULT NULL,
-  PRIMARY KEY (`sql_rev`),
-  KEY `required` (`required_rev`),
-  CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_world` (`sql_rev`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB';
-
 
--- Dumping structure for table acore_world.waypoint_data
+-- Dumping structure for table tc_world.waypoint_data
 DROP TABLE IF EXISTS `waypoint_data`;
 CREATE TABLE IF NOT EXISTS `waypoint_data` (
   `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID',
@@ -2943,12 +2851,12 @@ CREATE TABLE IF NOT EXISTS `waypoint_data` (
   `move_type` int(11) NOT NULL DEFAULT '0',
   `action` int(11) NOT NULL DEFAULT '0',
   `action_chance` smallint(6) NOT NULL DEFAULT '100',
-  `wpguid` int(11) NOT NULL DEFAULT '0',
+  `wpguid` int(11) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`point`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;