diff options
| author | Jeremy <Golrag@users.noreply.github.com> | 2018-03-04 22:32:08 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-03-04 22:32:08 +0100 |
| commit | f411b7a90e4900c9e2df7c1e0c7a301360408cec (patch) | |
| tree | 9793744cf0749d37bb13d6d69355b8672e5f6c34 /sql/base | |
| parent | e0eafc1cac9d840f897f9269e8440aaebfab6a96 (diff) | |
Core/Player: Implement PvP Talents (#19962)
* SPELL_AURA_119 -> SPELL_AURA_PVP_TALENTS
* Learn Honorable Medallion when pvp rules are enabled
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 27 |
1 files changed, 26 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 55abfac06c7..9e08c4a4a31 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1087,6 +1087,30 @@ LOCK TABLES `character_pet_declinedname` WRITE; UNLOCK TABLES; -- +-- Table structure for table `character_pvp_talent` +-- + +DROP TABLE IF EXISTS `character_pvp_talent`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_pvp_talent` ( + `guid` bigint(20) unsigned NOT NULL, + `talentId` mediumint(8) unsigned NOT NULL, + `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`talentId`,`talentGroup`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `character_pvp_talent` +-- + +LOCK TABLES `character_pvp_talent` WRITE; +/*!40000 ALTER TABLE `character_pvp_talent` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_pvp_talent` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `character_queststatus` -- @@ -3537,7 +3561,8 @@ INSERT INTO `updates` VALUES ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25), ('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','ARCHIVED','2018-02-03 23:52:42',0), ('2018_02_08_00_characters.sql','75FA162A9B85D678B26F972371265F1EC2C75187','ARCHIVED','2018-02-08 22:23:28',0), -('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117); +('2018_02_19_00_characters.sql','75A0FFAFD0633921708DB0F72F9CC9796ACB960B','RELEASED','2018-02-19 22:33:32',117), +('2018_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','RELEASED','2018-03-04 18:15:24',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |