diff options
| -rw-r--r-- | sql/updates/world/master/2020_05_02_02_world.sql | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/sql/updates/world/master/2020_05_02_02_world.sql b/sql/updates/world/master/2020_05_02_02_world.sql index 530762970c7..60604e63984 100644 --- a/sql/updates/world/master/2020_05_02_02_world.sql +++ b/sql/updates/world/master/2020_05_02_02_world.sql @@ -1,6 +1,14 @@ -TRUNCATE `player_levelstats`; -ALTER TABLE `player_levelstats` DROP COLUMN `race`; -RENAME TABLE `player_levelstats` TO `player_classlevelstats`; +DROP TABLE IF EXISTS `player_levelstats`; +DROP TABLE IF EXISTS `player_classlevelstats`; +CREATE TABLE `player_classlevelstats` ( + `class` tinyint(3) unsigned NOT NULL, + `level` tinyint(3) unsigned NOT NULL, + `str` smallint(5) unsigned NOT NULL COMMENT 'strength', + `agi` smallint(5) unsigned NOT NULL COMMENT 'agility', + `sta` smallint(5) unsigned NOT NULL COMMENT 'stamina', + `inte` smallint(5) unsigned NOT NULL COMMENT 'intellect', + PRIMARY KEY (`class`,`level`) +) ENGINE=MyISAM CHARSET=utf8 COMMENT = 'Stores levels stats.'; INSERT INTO `player_classlevelstats` (`class`, `level`, `str`, `agi`, `sta`, `inte`) VALUES (1, 1, 17, 10, 11, 8), |