diff options
| author | funjoker <funjoker109@gmail.com> | 2020-02-01 14:52:59 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-02-01 14:52:59 +0100 |
| commit | 6c85964065dc2b2d397904d79755eacc43a8ab0d (patch) | |
| tree | cef617febca4aacd06a69d504ce3dee4ca92683b /sql | |
| parent | ba1e5cd4134af429635068f323a2179c57a3c5eb (diff) | |
Sync broadcast_text naming (#24102)
* Sync broadcast_text naming
official namings for broadcast_text
* Rename 2020_01_24_00_world_335.sql to 2020_02_01_02_world_335.sql
Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_01_02_world_335.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_01_02_world_335.sql b/sql/updates/world/3.3.5/2020_02_01_02_world_335.sql new file mode 100644 index 00000000000..39f0da3581f --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_01_02_world_335.sql @@ -0,0 +1,17 @@ +ALTER TABLE `broadcast_text` +CHANGE COLUMN `Language` `LanguageID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `ID`, +CHANGE COLUMN `MaleText` `Text` LONGTEXT NULL AFTER `LanguageID`, +CHANGE COLUMN `FemaleText` `Text1` LONGTEXT NULL AFTER `Text`, +CHANGE COLUMN `EmoteID0` `EmoteID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `Text1`, +CHANGE COLUMN `EmoteID1` `EmoteID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteID1`, +CHANGE COLUMN `EmoteID2` `EmoteID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteID2`, +CHANGE COLUMN `EmoteDelay0` `EmoteDelay1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteID3`, +CHANGE COLUMN `EmoteDelay1` `EmoteDelay2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay1`, +CHANGE COLUMN `EmoteDelay2` `EmoteDelay3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay2`, +CHANGE COLUMN `SoundId` `SoundEntriesID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmoteDelay3`, +CHANGE COLUMN `Unk1` `EmotesID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `SoundEntriesID`, +CHANGE COLUMN `Unk2` `Flags` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `EmotesID`; + +ALTER TABLE `broadcast_text_locale` +CHANGE COLUMN `MaleText` `Text` TEXT NULL AFTER `locale`, +CHANGE COLUMN `FemaleText` `Text1` TEXT NULL AFTER `Text`; |