aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <none@none>2010-10-09 17:52:00 +0200
committerShauren <none@none>2010-10-09 17:52:00 +0200
commit91a97c7b831650c4a874f8fca29f57e89376991a (patch)
treef3327998b8bbf381c76baf599856d3c96736d8dd /sql/updates
parent324de6fb4c6f56ac08a487d24e47e457bf11b5c3 (diff)
DB-Schema/World/creature: Added possibility to override npcflag, unit_flags, dynamicflags in creature table
Core/Player: Fixed bad query in previous revision --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10192_world_creature.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/10192_world_creature.sql b/sql/updates/10192_world_creature.sql
new file mode 100644
index 00000000000..012ef06ad07
--- /dev/null
+++ b/sql/updates/10192_world_creature.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `creature`
+ ADD COLUMN `npcflag` int(10) unsigned NOT NULL DEFAULT '0' AFTER `MovementType`,
+ ADD COLUMN `unit_flags` int(10) unsigned NOT NULL DEFAULT '0' AFTER `npcflag`,
+ ADD COLUMN `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0' AFTER `unit_flags`;