From 8d2afd179804c3cdb199591619e4e72b1dad5476 Mon Sep 17 00:00:00 2001
From: Vincent-Michael <vincent_michael@gmx.de>
Date: Wed, 7 Sep 2016 12:20:06 +0200
Subject: DB/Hotfixes: Updated hotfixes creature table structure for 7.0.3

---
 sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql

(limited to 'sql')

diff --git a/sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql
new file mode 100644
index 00000000000..d8a2b719212
--- /dev/null
+++ b/sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `creature`
+  CHANGE `Type` `Type` MEDIUMINT(3) UNSIGNED DEFAULT 0 NOT NULL AFTER `FemaleSubName`,
+  ADD COLUMN `Family` TINYINT(3) UNSIGNED DEFAULT 0 NOT NULL AFTER `Type`,
+  CHANGE `Rank` `Classification` TINYINT(3) UNSIGNED DEFAULT 0 NOT NULL,
+  CHANGE `InhabitType` `InhabitType` TINYINT(3) UNSIGNED DEFAULT 0 NOT NULL; 
-- 
cgit v1.2.3