Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.