diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-06 14:02:20 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-06 14:02:52 +0200 |
| commit | 6d743652fc3349582212eb70a1168fefe4504b4f (patch) | |
| tree | c245b70e4cddf634ed0b8b5b494c404f11b0f98c | |
| parent | 06850338348ab4effa374ea3122d41e7efa01b34 (diff) | |
DB/Hotfixes: Change gameobjects data fields to signed
| -rw-r--r-- | sql/updates/hotfixes/2015_04_06_02_hotfixes.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_04_06_02_hotfixes.sql b/sql/updates/hotfixes/2015_04_06_02_hotfixes.sql new file mode 100644 index 00000000000..e573419b3ca --- /dev/null +++ b/sql/updates/hotfixes/2015_04_06_02_hotfixes.sql @@ -0,0 +1,13 @@ +UPDATE `gameobjects` SET `Data0`=0 WHERE `ID` IN (239085 /*-Unknown-*/, 239086 /*-Unknown-*/); + +ALTER TABLE `gameobjects` + CHANGE `Data0` `Data0` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data1` `Data1` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data2` `Data2` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data3` `Data3` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data4` `Data4` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data5` `Data5` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data6` `Data6` INT(10) NOT NULL DEFAULT '0', + CHANGE `Data7` `Data7` INT(10) NOT NULL DEFAULT '0'; + +UPDATE `gameobjects` SET `Data0`=-1 WHERE `Id` IN (239085 /*-Unknown-*/, 239086 /*-Unknown-*/); |