diff options
| author | click <none@none> | 2010-05-25 16:39:29 +0200 |
|---|---|---|
| committer | click <none@none> | 2010-05-25 16:39:29 +0200 |
| commit | 39108e68c9a68dcfbfc9e06172a174f8f699d086 (patch) | |
| tree | 3fb0dc44a4be44815df6f498e05372da9d2b1684 /sql | |
| parent | 2b9eef87e4812890ec7875c581ce9e5b67644abc (diff) | |
Set default spawndistance for creatures to 0 on creature creation
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/8292_world_creature.sql | 1 | ||||
| -rw-r--r-- | sql/world.sql | 2 |
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', |