diff options
author | funjoker <funjoker109@gmail.com> | 2023-11-20 12:15:43 +0100 |
---|---|---|
committer | funjoker <funjoker109@gmail.com> | 2023-11-20 12:15:43 +0100 |
commit | 2ccb00fc66a6e1e72916ff76d44163bd4dbf4ea6 (patch) | |
tree | f78a8cb31853a2ddcb8f9e42b9e3b232d3f092ac | |
parent | a0c446dd9a4541d9b170276a4a5d6b789f4ec36d (diff) |
DB: Update player_racestats
-rw-r--r-- | sql/updates/world/3.4.x/2023_11_20_00_world.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/3.4.x/2023_11_20_00_world.sql b/sql/updates/world/3.4.x/2023_11_20_00_world.sql new file mode 100644 index 00000000000..7969d33f159 --- /dev/null +++ b/sql/updates/world/3.4.x/2023_11_20_00_world.sql @@ -0,0 +1,24 @@ +DROP TABLE IF EXISTS `player_racestats`; +CREATE TABLE IF NOT EXISTS `player_racestats` ( +`race` tinyint unsigned NOT NULL, +`str` smallint NOT NULL COMMENT 'strength', +`agi` smallint NOT NULL COMMENT 'agility', +`sta` smallint NOT NULL COMMENT 'stamina', +`inte` smallint NOT NULL COMMENT 'intellect', +`spi` smallint NOT NULL COMMENT 'spirit', +`comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, +PRIMARY KEY (`race`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stores race stats.'; + +DELETE FROM `player_racestats`; +INSERT INTO `player_racestats` (`race`, `str`, `agi`, `sta`, `inte`, `spi`, `comment`) VALUES +(1, 0, 0, 0, 0, 0, 'Human'), +(2, 3, -3, 1, -3, -2, 'Orc'), +(3, 5, -4, 1, -1, -1, 'Dwarf'), +(4, -4, 4, 0, 0, 0, 'Night Elf'), +(5, -1, -2, 0, -2, 5, 'Undead'), +(6, 5, -4, 1, -4, 2, 'Tauren'), +(7, -5, 2, 0, 3, 0, 'Gnome'), +(8, 1, -2, 0, -4, 1, 'Troll'), +(10, -3, 1, 0, 2, 0, 'Blood Elf'), +(11, -3, 2, 0, 3, -2, 'Draenei'); |