diff options
| author | Shauren <shauren.trinity@gmail.com> | 2018-12-09 14:45:03 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-12-09 14:45:03 +0100 |
| commit | f94deace764f0b8d99249760d2bc2e85c891c387 (patch) | |
| tree | 4c7c56f34768fc7aef05268061a12845c5bf67ce /sql/base | |
| parent | 8725eec9c1c15f3e76bd9d524d4a5d8d0b3f0a44 (diff) | |
| parent | a70030ff252b266d12023ffada2a309409c1ccdb (diff) | |
Merge branch 'bfa'
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 687f66af959..fa28bd1fa25 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1095,9 +1095,12 @@ DROP TABLE IF EXISTS `character_pvp_talent`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_pvp_talent` ( `guid` bigint(20) unsigned NOT NULL, - `talentId` mediumint(8) unsigned NOT NULL, + `talentId0` int(10) unsigned NOT NULL, + `talentId1` int(10) unsigned NOT NULL, + `talentId2` int(10) unsigned NOT NULL, + `talentId3` int(10) unsigned NOT NULL, `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`talentId`,`talentGroup`) + PRIMARY KEY (`guid`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1731,7 +1734,6 @@ CREATE TABLE `characters` ( `deleteDate` int(10) unsigned DEFAULT NULL, `honor` int(10) unsigned NOT NULL DEFAULT '0', `honorLevel` int(10) unsigned NOT NULL DEFAULT '1', - `prestigeLevel` int(10) unsigned NOT NULL DEFAULT '0', `honorRestState` tinyint(3) unsigned NOT NULL DEFAULT '2', `honorRestBonus` float NOT NULL DEFAULT '0', `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0', @@ -3566,7 +3568,10 @@ INSERT INTO `updates` VALUES ('2018_03_04_00_characters.sql','2A4CD2EE2547E718490706FADC78BF36F0DED8D6','RELEASED','2018-03-04 18:15:24',0), ('2018_04_28_00_characters.sql','CBD0FDC0F32DE3F456F7CE3D9CAD6933CD6A50F5','RELEASED','2018-04-28 12:44:09',0), ('2018_07_28_00_characters.sql','31F66AE7831251A8915625EC7F10FA138AB8B654','RELEASED','2018-07-28 18:30:19',0), -('2018_07_31_00_characters.sql','7DA8D4A4534520B23E6F5BBD5B8EE205B799C798','RELEASED','2018-07-31 20:54:39',0); +('2018_07_31_00_characters.sql','7DA8D4A4534520B23E6F5BBD5B8EE205B799C798','RELEASED','2018-07-31 20:54:39',0), +('2018_12_09_00_characters.sql','7FE9641C93ED762597C08F1E9B6649C9EC2F0E47','RELEASED','2018-09-18 23:34:29',0), +('2018_12_09_01_characters.sql','C80B936AAD94C58A0F33382CED08CFB4E0B6AC34','RELEASED','2018-10-10 22:05:28',0), +('2018_12_09_02_characters.sql','DBBA0C06985CE8AC4E6E7E94BD6B2673E9ADFAE2','RELEASED','2018-12-02 17:32:31',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |