diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 12 | ||||
| -rw-r--r-- | sql/updates/characters/2014_11_12_00_characters.sql | 4 |
2 files changed, 10 insertions, 6 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 30934a4a81f..29f14fa7b39 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -763,7 +763,7 @@ DROP TABLE IF EXISTS `character_glyphs`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_glyphs` ( `guid` bigint(20) unsigned NOT NULL, - `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', + `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', `glyph1` smallint(5) unsigned DEFAULT '0', `glyph2` smallint(5) unsigned DEFAULT '0', `glyph3` smallint(5) unsigned DEFAULT '0', @@ -773,7 +773,7 @@ CREATE TABLE `character_glyphs` ( `glyph7` smallint(5) unsigned DEFAULT '0', `glyph8` smallint(5) unsigned DEFAULT '0', `glyph9` smallint(5) unsigned DEFAULT '0', - PRIMARY KEY (`guid`,`spec`) + PRIMARY KEY (`guid`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1276,8 +1276,8 @@ DROP TABLE IF EXISTS `character_talent`; CREATE TABLE `character_talent` ( `guid` bigint(20) unsigned NOT NULL, `spell` mediumint(8) unsigned NOT NULL, - `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`spell`,`spec`) + `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`spell`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1383,8 +1383,8 @@ CREATE TABLE `characters` ( `power4` int(10) unsigned NOT NULL DEFAULT '0', `power5` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', - `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0', + `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1', + `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, `equipmentCache` longtext, `knownTitles` longtext, diff --git a/sql/updates/characters/2014_11_12_00_characters.sql b/sql/updates/characters/2014_11_12_00_characters.sql new file mode 100644 index 00000000000..68aaf99d5d0 --- /dev/null +++ b/sql/updates/characters/2014_11_12_00_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_glyphs` CHANGE `spec` `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `character_talent` CHANGE `spec` `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `characters` CHANGE `speccount` `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `characters` CHANGE `activespec` `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0'; |