Created
December 29, 2018 12:27
-
-
Save FrancescoBorzi/f83b9502c97ea2f42207d1c1de8f9d1b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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