diff options
| author | Shauren <shauren.trinity@gmail.com> | 2015-07-12 00:41:56 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2015-07-12 00:41:56 +0200 |
| commit | 228b9329259e136bfab281127963e99ec6ff43a0 (patch) | |
| tree | 161ef67262a841f8b34f24823c4a5eddc3ec8569 /sql | |
| parent | f7f7e4d0610c51434387fcd1947cac515db739a5 (diff) | |
Core/Players: Fixed power slot ordering
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/2015_07_12_00_characters.sql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index e011983e2cb..4332ea6051d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1425,6 +1425,7 @@ CREATE TABLE `character_stats` ( `maxpower3` int(10) unsigned NOT NULL DEFAULT '0', `maxpower4` int(10) unsigned NOT NULL DEFAULT '0', `maxpower5` int(10) unsigned NOT NULL DEFAULT '0', + `maxpower6` int(10) unsigned NOT NULL DEFAULT '0', `strength` int(10) unsigned NOT NULL DEFAULT '0', `agility` int(10) unsigned NOT NULL DEFAULT '0', `stamina` int(10) unsigned NOT NULL DEFAULT '0', @@ -1627,6 +1628,7 @@ CREATE TABLE `characters` ( `power3` int(10) unsigned NOT NULL DEFAULT '0', `power4` int(10) unsigned NOT NULL DEFAULT '0', `power5` int(10) unsigned NOT NULL DEFAULT '0', + `power6` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1', `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/characters/2015_07_12_00_characters.sql b/sql/updates/characters/2015_07_12_00_characters.sql new file mode 100644 index 00000000000..575097f7ff0 --- /dev/null +++ b/sql/updates/characters/2015_07_12_00_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` ADD `power6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `power5`; +ALTER TABLE `character_stats` ADD `maxpower6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `maxpower5`; |