Core/GameObject: migrated non-WDB fields to new gameobject_template_addon table

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_08_29_01_world.sql b/sql/updates/world/3.3.5/2016_08_29_01_world.sql
new file mode 100644
index 00000000000..732f5788318
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_08_29_01_world.sql
@@ -0,0 +1,18 @@
+DROP TABLE IF EXISTS `gameobject_template_addon`;
+CREATE TABLE `gameobject_template_addon`(
+    `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+    `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+    `flags` int(10) unsigned NOT NULL DEFAULT '0',
+    `mingold` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+    `maxgold` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
+    PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`)
+SELECT `entry`, `faction`, `flags`, `mingold`, `maxgold` FROM `gameobject_template`;
+
+ALTER TABLE `gameobject_template`
+DROP COLUMN `faction`,
+DROP COLUMN `flags`,
+DROP COLUMN `mingold`,
+DROP COLUMN `maxgold`;