Core/DBLayer: Fix remaining errors in loading world tables and a couple of them in characters database

Also removed World::LoadIp2nation(), it was not doing anything.
Closes #5897

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/world/2012_03_27_04_world_misc.sql b/sql/updates/world/2012_03_27_04_world_misc.sql
new file mode 100644
index 00000000000..e85350476c9
--- /dev/null
+++ b/sql/updates/world/2012_03_27_04_world_misc.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `spell_dbc` CHANGE `StackAmount` `StackAmount` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `waypoint_data` CHANGE `action_chance` `action_chance` smallint(6) NOT NULL DEFAULT '100';
+ALTER TABLE `item_loot_template` CHANGE `maxcount` `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';