From 02131fe32bb6837e75bdeae0ca94c4ee06ac26bf Mon Sep 17 00:00:00 2001 From: ModoX Date: Thu, 2 Jan 2025 12:49:28 +0100 Subject: Core/Player: Changed player_classlevelstats types to int32 --- sql/updates/world/master/2025_01_02_01_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2025_01_02_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2025_01_02_01_world.sql b/sql/updates/world/master/2025_01_02_01_world.sql new file mode 100644 index 00000000000..a287f8c78c0 --- /dev/null +++ b/sql/updates/world/master/2025_01_02_01_world.sql @@ -0,0 +1,6 @@ +-- using signed as Stats updatefield is also signed +ALTER TABLE `player_classlevelstats` + MODIFY COLUMN `str` int NOT NULL COMMENT 'strength' AFTER `level`, + MODIFY COLUMN `agi` int NOT NULL COMMENT 'agility' AFTER `str`, + MODIFY COLUMN `sta` int NOT NULL COMMENT 'stamina' AFTER `agi`, + MODIFY COLUMN `inte` int NOT NULL COMMENT 'intellect' AFTER `sta`; -- cgit v1.2.3