aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql5
1 files changed, 5 insertions, 0 deletions
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;