From f44e6834df4278fece0ca9c419b644512de812a6 Mon Sep 17 00:00:00 2001 From: Nay Date: Wed, 28 Mar 2012 00:38:04 +0100 Subject: 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 --- sql/updates/world/2012_03_27_04_world_misc.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_03_27_04_world_misc.sql (limited to 'sql') 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'; -- cgit v1.2.3