*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

2 files changed, 11 insertions, 0 deletions

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;