From b257a28fa9a9177df32845db8171d376bd6d4404 Mon Sep 17 00:00:00 2001 From: maximius Date: Sun, 1 Nov 2009 17:53:07 -0800 Subject: *Cleanup, fix many cases of unoptimized loops, potential crashes, excessively large data types, unnecessary or wrong casts, non-standardized function calls, and so on.. *Proper Maexxna Web Spray locations (old locations sent players flying into the air) --HG-- branch : trunk --- sql/updates/6156_characters.sql | 8 ++++++++ sql/updates/6156_world.sql | 3 +++ 2 files changed, 11 insertions(+) create mode 100644 sql/updates/6156_characters.sql create mode 100644 sql/updates/6156_world.sql (limited to 'sql/updates') diff --git a/sql/updates/6156_characters.sql b/sql/updates/6156_characters.sql new file mode 100644 index 00000000000..b0e3d4e540f --- /dev/null +++ b/sql/updates/6156_characters.sql @@ -0,0 +1,8 @@ + +ALTER TABLE `character_aura` MODIFY COLUMN `effect_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, + MODIFY COLUMN `stackcount` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1, + MODIFY COLUMN `remaincharges` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0; + +ALTER TABLE `pet_aura` MODIFY COLUMN `effect_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, + MODIFY COLUMN `stackcount` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1, + MODIFY COLUMN `remaincharges` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0; diff --git a/sql/updates/6156_world.sql b/sql/updates/6156_world.sql new file mode 100644 index 00000000000..eed5fcddc13 --- /dev/null +++ b/sql/updates/6156_world.sql @@ -0,0 +1,3 @@ + +-- the (4) in TINYINT(4) is kind of useless here, but whatever. This column should be unsigned. +ALTER TABLE `exploration_basexp` MODIFY COLUMN `level` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0; -- cgit v1.2.3