diff options
| author | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-07 12:20:06 +0200 |
|---|---|---|
| committer | Vincent-Michael <vincent_michael@gmx.de> | 2016-09-07 12:20:31 +0200 |
| commit | 8d2afd179804c3cdb199591619e4e72b1dad5476 (patch) | |
| tree | e7984d0513655b61aaaaa44a662a6ffb11d6e6a5 /sql/updates | |
| parent | 9b8dbf92811c1cd7084466439d9fd37405014311 (diff) | |
DB/Hotfixes: Updated hotfixes creature table structure for 7.0.3
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/hotfixes/6.x/2016_09_07_00_hotfixes.sql | 5 |
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; |