From 39108e68c9a68dcfbfc9e06172a174f8f699d086 Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Tue, 25 May 2010 16:39:29 +0200
Subject: Set default spawndistance for creatures to 0 on creature creation

--HG--
branch : trunk
---
 sql/updates/8292_world_creature.sql | 1 +
 sql/world.sql                       | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/8292_world_creature.sql

(limited to 'sql')

diff --git a/sql/updates/8292_world_creature.sql b/sql/updates/8292_world_creature.sql
new file mode 100644
index 00000000000..fe905274436
--- /dev/null
+++ b/sql/updates/8292_world_creature.sql
@@ -0,0 +1 @@
+ALTER TABLE `creature` CHANGE `spawndist` `spawndist` FLOAT NOT NULL DEFAULT '0';
diff --git a/sql/world.sql b/sql/world.sql
index f914ec5fcda..b4f51ab49b6 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -723,7 +723,7 @@ CREATE TABLE `creature` (
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120',
-  `spawndist` float NOT NULL DEFAULT '5',
+  `spawndist` float NOT NULL DEFAULT '0',
   `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
   `curmana` int(10) unsigned NOT NULL DEFAULT '0',
-- 
cgit v1.2.3