aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/6882_world_creature_addon.sql1
-rw-r--r--sql/updates/6882_world_creature_template_addon.sql1
-rw-r--r--sql/world.sql2
3 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/6882_world_creature_addon.sql b/sql/updates/6882_world_creature_addon.sql
new file mode 100644
index 00000000000..6c8c54b75ad
--- /dev/null
+++ b/sql/updates/6882_world_creature_addon.sql
@@ -0,0 +1 @@
+ALTER TABLE `creature_addon` DROP COLUMN `moveflags`;
diff --git a/sql/updates/6882_world_creature_template_addon.sql b/sql/updates/6882_world_creature_template_addon.sql
new file mode 100644
index 00000000000..cd5b3e5bde9
--- /dev/null
+++ b/sql/updates/6882_world_creature_template_addon.sql
@@ -0,0 +1 @@
+ALTER TABLE `creature_template_addon` DROP COLUMN `moveflags`;
diff --git a/sql/world.sql b/sql/world.sql
index 8ad219f7006..5113bcea1ff 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -754,7 +754,6 @@ CREATE TABLE `creature_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` int(10) unsigned NOT NULL DEFAULT '0',
- `moveflags` int(10) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@@ -1703,7 +1702,6 @@ CREATE TABLE `creature_template_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `moveflags` int(10) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;