aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2023-11-20 12:15:43 +0100
committerfunjoker <funjoker109@gmail.com>2023-11-20 12:15:43 +0100
commit2ccb00fc66a6e1e72916ff76d44163bd4dbf4ea6 (patch)
treef78a8cb31853a2ddcb8f9e42b9e3b232d3f092ac
parenta0c446dd9a4541d9b170276a4a5d6b789f4ec36d (diff)
DB: Update player_racestats
-rw-r--r--sql/updates/world/3.4.x/2023_11_20_00_world.sql24
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');