diff options
| author | Nayd <dnpd.dd@gmail.com> | 2015-01-11 19:35:24 +0000 |
|---|---|---|
| committer | Nayd <dnpd.dd@gmail.com> | 2015-01-11 19:35:24 +0000 |
| commit | a7b49225283aedd828b42cefb5e113b260003d27 (patch) | |
| tree | 16cae7083adf6ddae1b61ef6e514e0e52d4b0c31 /sql | |
| parent | e34b2ae663b304a77ac5da1a752c85f3b38b2c44 (diff) | |
DB/Schema: Boost stats in `player_levelstats` from tinyint to smallint
Needed to accommodate base stats higher than 255
Ref #13823
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_01_11_01_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2015_01_11_01_world.sql b/sql/updates/world/2015_01_11_01_world.sql new file mode 100644 index 00000000000..ed475365e80 --- /dev/null +++ b/sql/updates/world/2015_01_11_01_world.sql @@ -0,0 +1,5 @@ +ALTER TABLE `player_levelstats` CHANGE `str` `str` SMALLINT(6) UNSIGNED NOT NULL COMMENT 'strength'; +ALTER TABLE `player_levelstats` CHANGE `agi` `agi` SMALLINT(6) UNSIGNED NOT NULL COMMENT 'agility'; +ALTER TABLE `player_levelstats` CHANGE `sta` `sta` SMALLINT(6) UNSIGNED NOT NULL COMMENT 'stamina'; +ALTER TABLE `player_levelstats` CHANGE `inte` `inte` SMALLINT(6) UNSIGNED NOT NULL COMMENT 'intellect'; +ALTER TABLE `player_levelstats` CHANGE `spi` `spi` SMALLINT(6) UNSIGNED NOT NULL COMMENT 'spirit'; |