diff options
| author | ahchxj2416 <64737877+ahchxj2416@users.noreply.github.com> | 2020-05-07 21:28:33 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-05-07 15:28:33 +0200 |
| commit | d40c302839936d442a5dd26bac408d60780b266a (patch) | |
| tree | 46399f248bb31b74caeecb4404b266cdec640bd1 | |
| parent | ea812fec1153280b94d2fff8bdefd678e86bddeb (diff) | |
SQL: Fix 2020_05_02_02_world.sql for mariadb (#24561)
| -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), |