Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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_characters.sql b/tc_characters.sql
--- a/acore_characters.sql
+++ b/tc_characters.sql
--- Dumping structure for table acore_characters.account_tutorial
+-- Dumping structure for table tc_characters.account_tutorial
DROP TABLE IF EXISTS `account_tutorial`;
CREATE TABLE IF NOT EXISTS `account_tutorial` (
`accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
@@ -45,10 +45,10 @@ CREATE TABLE IF NOT EXISTS `account_tutorial` (
`tut6` int(10) unsigned NOT NULL DEFAULT '0',
`tut7` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`accountId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.arena_team_member
+-- Dumping structure for table tc_characters.arena_team_member
DROP TABLE IF EXISTS `arena_team_member`;
CREATE TABLE IF NOT EXISTS `arena_team_member` (
`arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',
@@ -88,16 +88,25 @@ CREATE TABLE IF NOT EXISTS `arena_team_member` (
`weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
`seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
`seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
- `personalRating` smallint(5) NOT NULL DEFAULT '0',
+ `personalRating` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`arenaTeamId`,`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.auctionhouse
+-- Dumping structure for table tc_characters.auctionbidders
+DROP TABLE IF EXISTS `auctionbidders`;
+CREATE TABLE IF NOT EXISTS `auctionbidders` (
+ `id` int(10) unsigned NOT NULL DEFAULT '0',
+ `bidderguid` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`,`bidderguid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+.
+-- Dumping structure for table tc_characters.auctionhouse
DROP TABLE IF EXISTS `auctionhouse`;
CREATE TABLE IF NOT EXISTS `auctionhouse` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
- `auctioneerguid` int(10) unsigned NOT NULL DEFAULT '0',
+ `houseid` tinyint(3) unsigned NOT NULL DEFAULT '7',
`itemguid` int(10) unsigned NOT NULL DEFAULT '0',
`itemowner` int(10) unsigned NOT NULL DEFAULT '0',
`buyoutprice` int(10) unsigned NOT NULL DEFAULT '0',
@@ -111,7 +120,7 @@ CREATE TABLE IF NOT EXISTS `auctionhouse` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.channels
+-- Dumping structure for table tc_characters.channels
DROP TABLE IF EXISTS `channels`;
CREATE TABLE IF NOT EXISTS `channels` (
- `channelId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`team` int(10) unsigned NOT NULL,
`announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
`ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
`password` varchar(32) DEFAULT NULL,
+ `bannedList` text,
`lastUsed` int(10) unsigned NOT NULL,
- PRIMARY KEY (`channelId`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Channel System';
-
--- Dumping structure for table acore_characters.channels_bans
-DROP TABLE IF EXISTS `channels_bans`;
-CREATE TABLE IF NOT EXISTS `channels_bans` (
- `channelId` int(10) unsigned NOT NULL,
- `playerGUID` int(10) unsigned NOT NULL,
- `banTime` int(10) unsigned NOT NULL,
- PRIMARY KEY (`channelId`,`playerGUID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+ PRIMARY KEY (`name`,`team`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';
--- Dumping structure for table acore_characters.channels_rights
-DROP TABLE IF EXISTS `channels_rights`;
-CREATE TABLE IF NOT EXISTS `channels_rights` (
- `name` varchar(128) NOT NULL,
- `flags` int(10) unsigned NOT NULL,
- `speakdelay` int(10) unsigned NOT NULL,
- `joinmessage` varchar(255) NOT NULL DEFAULT '',
- `delaymessage` varchar(255) NOT NULL DEFAULT '',
- `moderators` text,
- PRIMARY KEY (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- Dumping structure for table acore_characters.character_arena_stats
+-- Dumping structure for table tc_characters.character_arena_stats
DROP TABLE IF EXISTS `character_arena_stats`;
CREATE TABLE IF NOT EXISTS `character_arena_stats` (
- `guid` int(10) NOT NULL,
- `slot` tinyint(3) NOT NULL,
- `matchMakerRating` smallint(5) NOT NULL,
- `maxMMR` smallint(5) NOT NULL,
+ `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `matchMakerRating` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_aura
+-- Dumping structure for table tc_characters.character_aura
DROP TABLE IF EXISTS `character_aura`;
CREATE TABLE IF NOT EXISTS `character_aura` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
@@ -370,11 +355,13 @@ CREATE TABLE IF NOT EXISTS `character_aura` (
`maxDuration` int(11) NOT NULL DEFAULT '0',
`remainTime` int(11) NOT NULL DEFAULT '0',
`remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `critChance` float NOT NULL DEFAULT '0',
+ `applyResilience` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.character_banned
+-- Dumping structure for table tc_characters.character_banned
DROP TABLE IF EXISTS `character_banned`;
CREATE TABLE IF NOT EXISTS `character_banned` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
@@ -387,24 +374,33 @@ CREATE TABLE IF NOT EXISTS `character_banned` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
--- Dumping structure for table acore_characters.character_battleground_random
-DROP TABLE IF EXISTS `character_battleground_random`;
-CREATE TABLE IF NOT EXISTS `character_battleground_random` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+-- Dumping structure for table tc_characters.character_battleground_data
+DROP TABLE IF EXISTS `character_battleground_data`;
+CREATE TABLE IF NOT EXISTS `character_battleground_data` (
+ `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier',
+ `team` smallint(5) unsigned NOT NULL,
+ `joinX` float NOT NULL DEFAULT '0',
+ `joinY` float NOT NULL DEFAULT '0',
+ `joinZ` float NOT NULL DEFAULT '0',
+ `joinO` float NOT NULL DEFAULT '0',
+ `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
+ `taxiStart` int(10) unsigned NOT NULL DEFAULT '0',
+ `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0',
+ `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.character_brew_of_the_month
-DROP TABLE IF EXISTS `character_brew_of_the_month`;
-CREATE TABLE IF NOT EXISTS `character_brew_of_the_month` (
- `guid` int(10) unsigned NOT NULL,
- `lastEventId` int(10) unsigned NOT NULL DEFAULT '0',
+-- Dumping structure for table tc_characters.character_battleground_random
+DROP TABLE IF EXISTS `character_battleground_random`;
+CREATE TABLE IF NOT EXISTS `character_battleground_random` (
+ `guid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_entry_point
-DROP TABLE IF EXISTS `character_entry_point`;
-CREATE TABLE IF NOT EXISTS `character_entry_point` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
- `joinX` float NOT NULL DEFAULT '0',
- `joinY` float NOT NULL DEFAULT '0',
- `joinZ` float NOT NULL DEFAULT '0',
- `joinO` float NOT NULL DEFAULT '0',
- `joinMapId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
- `taxiPath` text,
- `mountSpell` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
-
--- Dumping structure for table acore_characters.character_equipmentsets
+-- Dumping structure for table tc_characters.character_equipmentsets
DROP TABLE IF EXISTS `character_equipmentsets`;
CREATE TABLE IF NOT EXISTS `character_equipmentsets` (
- `guid` int(10) NOT NULL DEFAULT '0',
- `setguid` bigint(20) NOT NULL AUTO_INCREMENT,
+ `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `setguid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(31) NOT NULL,
`iconname` varchar(100) NOT NULL,
@@ -466,7 +447,16 @@ CREATE TABLE IF NOT EXISTS `character_equipmentsets` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_gifts
+-- Dumping structure for table tc_characters.character_fishingsteps
+DROP TABLE IF EXISTS `character_fishingsteps`;
+CREATE TABLE IF NOT EXISTS `character_fishingsteps` (
+ `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `fishingSteps` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+.
+-- Dumping structure for table tc_characters.character_gifts
DROP TABLE IF EXISTS `character_gifts`;
CREATE TABLE IF NOT EXISTS `character_gifts` (
`guid` int(10) unsigned NOT NULL DEFAULT '0',
@@ -478,7 +468,7 @@ CREATE TABLE IF NOT EXISTS `character_gifts` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_instance
+-- Dumping structure for table tc_characters.character_instance
DROP TABLE IF EXISTS `character_instance`;
CREATE TABLE IF NOT EXISTS `character_instance` (
`guid` int(10) unsigned NOT NULL DEFAULT '0',
`instance` int(10) unsigned NOT NULL DEFAULT '0',
`permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `extended` tinyint(3) unsigned NOT NULL,
+ `extendState` tinyint(2) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`guid`,`instance`),
KEY `instance` (`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_queststatus_rewarded
+-- Dumping structure for table tc_characters.character_queststatus_rewarded
DROP TABLE IF EXISTS `character_queststatus_rewarded`;
CREATE TABLE IF NOT EXISTS `character_queststatus_rewarded` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
- `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `active` tinyint(10) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`guid`,`quest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.character_spell
+-- Dumping structure for table tc_characters.character_spell
DROP TABLE IF EXISTS `character_spell`;
CREATE TABLE IF NOT EXISTS `character_spell` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
- `specMask` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.character_spell_cooldown
+-- Dumping structure for table tc_characters.character_spell_cooldown
DROP TABLE IF EXISTS `character_spell_cooldown`;
CREATE TABLE IF NOT EXISTS `character_spell_cooldown` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
`spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
`item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
`time` int(10) unsigned NOT NULL DEFAULT '0',
- `needSend` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
+ `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.character_talent
+-- Dumping structure for table tc_characters.character_talent
DROP TABLE IF EXISTS `character_talent`;
CREATE TABLE IF NOT EXISTS `character_talent` (
`guid` int(10) unsigned NOT NULL,
`spell` mediumint(8) unsigned NOT NULL,
- `specMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`,`spell`)
+ `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`guid`,`spell`,`talentGroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.corpse
+-- Dumping structure for table tc_characters.corpse
DROP TABLE IF EXISTS `corpse`;
CREATE TABLE IF NOT EXISTS `corpse` (
- `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
@@ -772,19 +763,18 @@ CREATE TABLE IF NOT EXISTS `corpse` (
`time` int(10) unsigned NOT NULL DEFAULT '0',
`corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
- PRIMARY KEY (`corpseGuid`),
+ PRIMARY KEY (`guid`),
KEY `idx_type` (`corpseType`),
KEY `idx_instance` (`instanceId`),
- KEY `idx_player` (`guid`),
KEY `idx_time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System';
--- Dumping structure for table acore_characters.creature_respawn
+-- Dumping structure for table tc_characters.creature_respawn
DROP TABLE IF EXISTS `creature_respawn`;
CREATE TABLE IF NOT EXISTS `creature_respawn` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
- `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
+ `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
`mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
PRIMARY KEY (`guid`,`instanceId`),
@@ -792,11 +782,11 @@ CREATE TABLE IF NOT EXISTS `creature_respawn` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
--- Dumping structure for table acore_characters.gameobject_respawn
+-- Dumping structure for table tc_characters.gameobject_respawn
DROP TABLE IF EXISTS `gameobject_respawn`;
CREATE TABLE IF NOT EXISTS `gameobject_respawn` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
- `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',
+ `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
`mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
`instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
PRIMARY KEY (`guid`,`instanceId`),
@@ -804,7 +794,7 @@ CREATE TABLE IF NOT EXISTS `gameobject_respawn` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
--- Dumping structure for table acore_characters.gm_survey
+-- Dumping structure for table tc_characters.gm_survey
DROP TABLE IF EXISTS `gm_survey`;
CREATE TABLE IF NOT EXISTS `gm_survey` (
`surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
@@ -843,12 +833,11 @@ CREATE TABLE IF NOT EXISTS `gm_survey` (
`mainSurvey` int(10) unsigned NOT NULL DEFAULT '0',
`comment` longtext NOT NULL,
`createTime` int(10) unsigned NOT NULL DEFAULT '0',
- `maxMMR` smallint(5) NOT NULL,
PRIMARY KEY (`surveyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.gm_ticket
+-- Dumping structure for table tc_characters.gm_ticket
DROP TABLE IF EXISTS `gm_ticket`;
CREATE TABLE IF NOT EXISTS `gm_ticket` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
@@ -862,7 +851,7 @@ CREATE TABLE IF NOT EXISTS `gm_ticket` (
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`lastModifiedTime` int(10) unsigned NOT NULL DEFAULT '0',
- `closedBy` int(10) unsigned NOT NULL DEFAULT '0',
+ `closedBy` int(10) NOT NULL DEFAULT '0',
`assignedTo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned',
`comment` text NOT NULL,
`response` text NOT NULL,
@@ -870,12 +859,12 @@ CREATE TABLE IF NOT EXISTS `gm_ticket` (
`escalated` tinyint(3) unsigned NOT NULL DEFAULT '0',
`viewed` tinyint(3) unsigned NOT NULL DEFAULT '0',
`needMoreHelp` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `resolvedBy` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket',
+ `resolvedBy` int(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
--- Dumping structure for table acore_characters.groups
+-- Dumping structure for table tc_characters.groups
DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
`guid` int(10) unsigned NOT NULL,
@@ -883,14 +872,14 @@ CREATE TABLE IF NOT EXISTS `groups` (
`lootMethod` tinyint(3) unsigned NOT NULL,
`looterGuid` int(10) unsigned NOT NULL,
`lootThreshold` tinyint(3) unsigned NOT NULL,
- `icon1` int(10) unsigned NOT NULL,
- `icon2` int(10) unsigned NOT NULL,
- `icon3` int(10) unsigned NOT NULL,
- `icon4` int(10) unsigned NOT NULL,
- `icon5` int(10) unsigned NOT NULL,
- `icon6` int(10) unsigned NOT NULL,
- `icon7` int(10) unsigned NOT NULL,
- `icon8` int(10) unsigned NOT NULL,
+ `icon1` bigint(20) unsigned NOT NULL,
+ `icon2` bigint(20) unsigned NOT NULL,
+ `icon3` bigint(20) unsigned NOT NULL,
+ `icon4` bigint(20) unsigned NOT NULL,
+ `icon5` bigint(20) unsigned NOT NULL,
+ `icon6` bigint(20) unsigned NOT NULL,
+ `icon7` bigint(20) unsigned NOT NULL,
+ `icon8` bigint(20) unsigned NOT NULL,
`groupType` tinyint(3) unsigned NOT NULL,
`difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
`raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -900,7 +889,18 @@ CREATE TABLE IF NOT EXISTS `groups` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
--- Dumping structure for table acore_characters.group_member
+-- Dumping structure for table tc_characters.group_instance
+DROP TABLE IF EXISTS `group_instance`;
+CREATE TABLE IF NOT EXISTS `group_instance` (
+ `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `instance` int(10) unsigned NOT NULL DEFAULT '0',
+ `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`guid`,`instance`),
+ KEY `instance` (`instance`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- Dumping structure for table tc_characters.group_member
DROP TABLE IF EXISTS `group_member`;
CREATE TABLE IF NOT EXISTS `group_member` (
`guid` int(10) unsigned NOT NULL,
@@ -912,7 +912,7 @@ CREATE TABLE IF NOT EXISTS `group_member` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
--- Dumping structure for table acore_characters.instance
+-- Dumping structure for table tc_characters.instance
DROP TABLE IF EXISTS `instance`;
CREATE TABLE IF NOT EXISTS `instance` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`map` smallint(5) unsigned NOT NULL DEFAULT '0',
- `resettime` int(10) unsigned NOT NULL DEFAULT '0',
+ `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
`difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
`completedEncounters` int(10) unsigned NOT NULL DEFAULT '0',
`data` tinytext NOT NULL,
@@ -1064,18 +1064,18 @@ CREATE TABLE IF NOT EXISTS `instance` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.instance_reset
+-- Dumping structure for table tc_characters.instance_reset
DROP TABLE IF EXISTS `instance_reset`;
CREATE TABLE IF NOT EXISTS `instance_reset` (
`mapid` smallint(5) unsigned NOT NULL DEFAULT '0',
`difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `resettime` int(10) unsigned NOT NULL DEFAULT '0',
+ `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`mapid`,`difficulty`),
KEY `difficulty` (`difficulty`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.item_loot_storage
-DROP TABLE IF EXISTS `item_loot_storage`;
-CREATE TABLE IF NOT EXISTS `item_loot_storage` (
- `containerGUID` int(10) unsigned NOT NULL,
- `itemid` int(10) unsigned NOT NULL,
- `count` int(10) unsigned NOT NULL,
- `randomPropertyId` int(10) NOT NULL,
- `randomSuffix` int(10) unsigned NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- Dumping structure for table tc_characters.item_loot_items
+DROP TABLE IF EXISTS `item_loot_items`;
+CREATE TABLE IF NOT EXISTS `item_loot_items` (
+ `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
+ `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)',
+ `item_count` int(10) NOT NULL DEFAULT '0' COMMENT 'stack size',
+ `follow_rules` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'follow loot rules',
+ `ffa` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'free-for-all',
+ `blocked` tinyint(1) NOT NULL DEFAULT '0',
+ `counted` tinyint(1) NOT NULL DEFAULT '0',
+ `under_threshold` tinyint(1) NOT NULL DEFAULT '0',
+ `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop',
+ `rnd_prop` int(10) NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled',
+ `rnd_suffix` int(10) NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled'
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- Dumping structure for table tc_characters.item_loot_money
+DROP TABLE IF EXISTS `item_loot_money`;
+CREATE TABLE IF NOT EXISTS `item_loot_money` (
+ `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
+ `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)',
+ PRIMARY KEY (`container_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--- Dumping structure for table acore_characters.log_arena_fights
-DROP TABLE IF EXISTS `log_arena_fights`;
-CREATE TABLE IF NOT EXISTS `log_arena_fights` (
- `fight_id` int(10) unsigned NOT NULL,
- `time` datetime NOT NULL,
- `type` tinyint(3) unsigned NOT NULL,
- `duration` int(10) unsigned NOT NULL,
- `winner` int(10) unsigned NOT NULL,
- `loser` int(10) unsigned NOT NULL,
- `winner_tr` smallint(5) unsigned NOT NULL,
- `winner_mmr` smallint(5) unsigned NOT NULL,
- `winner_tr_change` smallint(6) NOT NULL,
- `loser_tr` smallint(5) unsigned NOT NULL,
- `loser_mmr` smallint(5) unsigned NOT NULL,
- `loser_tr_change` smallint(6) NOT NULL,
- `currOnline` int(10) unsigned NOT NULL,
- PRIMARY KEY (`fight_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- Dumping structure for table acore_characters.log_arena_memberstats
-DROP TABLE IF EXISTS `log_arena_memberstats`;
-CREATE TABLE IF NOT EXISTS `log_arena_memberstats` (
- `fight_id` int(10) unsigned NOT NULL,
- `member_id` tinyint(3) unsigned NOT NULL,
- `name` char(20) NOT NULL,
- `guid` int(10) unsigned NOT NULL,
- `team` int(10) unsigned NOT NULL,
- `account` int(10) unsigned NOT NULL,
- `ip` char(15) NOT NULL,
- `damage` int(10) unsigned NOT NULL,
- `heal` int(10) unsigned NOT NULL,
- `kblows` int(10) unsigned NOT NULL,
- PRIMARY KEY (`fight_id`,`member_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- Dumping structure for table acore_characters.log_encounter
-DROP TABLE IF EXISTS `log_encounter`;
-CREATE TABLE IF NOT EXISTS `log_encounter` (
- `time` datetime NOT NULL,
- `map` smallint(5) unsigned NOT NULL,
- `difficulty` tinyint(3) unsigned NOT NULL,
- `creditType` tinyint(3) unsigned NOT NULL,
- `creditEntry` int(10) unsigned NOT NULL,
- `playersInfo` text NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- Dumping structure for table acore_characters.log_money
-DROP TABLE IF EXISTS `log_money`;
-CREATE TABLE IF NOT EXISTS `log_money` (
- `sender_acc` int(11) unsigned NOT NULL,
- `sender_guid` int(11) unsigned NOT NULL,
- `sender_name` char(32) CHARACTER SET utf8 NOT NULL,
- `sender_ip` char(32) CHARACTER SET utf8 NOT NULL,
- `receiver_acc` int(11) unsigned NOT NULL,
- `receiver_name` char(32) CHARACTER SET utf8 NOT NULL,
- `money` bigint(20) unsigned NOT NULL,
- `topic` char(255) CHARACTER SET utf8 NOT NULL,
- `date` datetime NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
--- Dumping structure for table acore_characters.pet_aura
+-- Dumping structure for table tc_characters.pet_aura
DROP TABLE IF EXISTS `pet_aura`;
CREATE TABLE IF NOT EXISTS `pet_aura` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
@@ -1296,11 +1247,13 @@ CREATE TABLE IF NOT EXISTS `pet_aura` (
`maxDuration` int(11) NOT NULL DEFAULT '0',
`remainTime` int(11) NOT NULL DEFAULT '0',
`remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`,`spell`,`effectMask`)
+ `critChance` float NOT NULL DEFAULT '0',
+ `applyResilience` tinyint(3) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
--- Dumping structure for table acore_characters.pet_spell
+-- Dumping structure for table tc_characters.pet_spell
DROP TABLE IF EXISTS `pet_spell`;
CREATE TABLE IF NOT EXISTS `pet_spell` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
@@ -1310,17 +1263,19 @@ CREATE TABLE IF NOT EXISTS `pet_spell` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
--- Dumping structure for table acore_characters.pet_spell_cooldown
+-- Dumping structure for table tc_characters.pet_spell_cooldown
DROP TABLE IF EXISTS `pet_spell_cooldown`;
CREATE TABLE IF NOT EXISTS `pet_spell_cooldown` (
`guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
`spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
`time` int(10) unsigned NOT NULL DEFAULT '0',
+ `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
+ `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`spell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- Dumping structure for table acore_characters.reserved_name
+-- Dumping structure for table tc_characters.quest_tracker
+DROP TABLE IF EXISTS `quest_tracker`;
+CREATE TABLE IF NOT EXISTS `quest_tracker` (
+ `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `character_guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `quest_accept_time` datetime NOT NULL,
+ `quest_complete_time` datetime DEFAULT NULL,
+ `quest_abandon_time` datetime DEFAULT NULL,
+ `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0',
+ `core_hash` varchar(120) NOT NULL DEFAULT '0',
+ `core_revision` varchar(120) NOT NULL DEFAULT '0'
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+.
+-- Dumping structure for table tc_characters.reserved_name
DROP TABLE IF EXISTS `reserved_name`;
CREATE TABLE IF NOT EXISTS `reserved_name` (
`name` varchar(12) NOT NULL DEFAULT '',
@@ -1370,19 +1339,28 @@ CREATE TABLE IF NOT EXISTS `reserved_name` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names';
--- Dumping structure for table acore_characters.version_db_characters
-DROP TABLE IF EXISTS `version_db_characters`;
-CREATE TABLE IF NOT EXISTS `version_db_characters` (
- `sql_rev` varchar(100) NOT NULL,
- `required_rev` varchar(100) DEFAULT NULL,
- `2018_12_23_00` bit(1) DEFAULT NULL,
- PRIMARY KEY (`sql_rev`),
- KEY `required` (`required_rev`),
- CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_characters` (`sql_rev`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB';
+-- Dumping structure for table tc_characters.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_characters.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.';
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.