diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-08-06 19:21:04 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2025-02-01 20:00:46 +0100 |
| commit | 8268ab34b74353ed6a4a07f69f3cc16e4ca3e3d7 (patch) | |
| tree | def97ba28466b0e55a4bbca209a8008afd86efea /sql | |
| parent | ba0ed27e3298c3cd997ec211f988d8de145e2e0d (diff) | |
DB/Schema: Change basehp/mana/armor in creature_classlevelstatus to unsigned mediumint
There's no reason to be cheap...
(cherry picked from commit 4d8b06d0bdf691ed81e0ba417ab4d2486702f0dd)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2025_02_01_00_world_2012_08_06_01_world_classlevelstats.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_02_01_00_world_2012_08_06_01_world_classlevelstats.sql b/sql/updates/world/3.3.5/2025_02_01_00_world_2012_08_06_01_world_classlevelstats.sql new file mode 100644 index 00000000000..880bde5f2e9 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_02_01_00_world_2012_08_06_01_world_classlevelstats.sql @@ -0,0 +1,5 @@ +ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` int unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` int unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` int unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` int unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` int unsigned NOT NULL DEFAULT '1'; |