aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/8292_world_creature.sql1
-rw-r--r--sql/world.sql2
2 files changed, 2 insertions, 1 deletions
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',