From d73e4a964030a61c5433d104cd9f788a050a8cc5 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 31 Dec 2021 16:38:19 +0100 Subject: DB: World db column type corrections * char to varchar * unsigned float to float * longtext to mediumtext (this is probably still too large for affected columns) --- sql/updates/world/master/2021_12_31_11_world.sql | 27 ++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 sql/updates/world/master/2021_12_31_11_world.sql diff --git a/sql/updates/world/master/2021_12_31_11_world.sql b/sql/updates/world/master/2021_12_31_11_world.sql new file mode 100644 index 00000000000..9f5b25aefaa --- /dev/null +++ b/sql/updates/world/master/2021_12_31_11_world.sql @@ -0,0 +1,27 @@ +-- Convert char to varchar +ALTER TABLE `areatrigger_scripts` MODIFY `ScriptName` varchar(64) NOT NULL; +ALTER TABLE `battleground_template` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `battleground_template` MODIFY `Comment` varchar(32) NOT NULL; +ALTER TABLE `conditions` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `creature` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `criteria_data` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `game_weather` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `gameobject` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `gameobject_template` MODIFY `AIName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `outdoorpvp_template` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE `spell_script_names` MODIFY `ScriptName` varchar(64) NOT NULL; +ALTER TABLE `transports` MODIFY `ScriptName` varchar(64) NOT NULL DEFAULT ''; + +-- floats +ALTER TABLE `creature_formations` MODIFY `dist` float NOT NULL; +ALTER TABLE `creature_formations` MODIFY `angle` float NOT NULL; +ALTER TABLE `creature_text` MODIFY `Probability` float NOT NULL DEFAULT '0'; +ALTER TABLE `item_template_addon` MODIFY `SpellPPMChance` float NOT NULL DEFAULT '0'; +ALTER TABLE `player_xp_for_level` MODIFY `Experience` int(10) unsigned NOT NULL; +ALTER TABLE `pool_members` MODIFY `chance` float NOT NULL; +ALTER TABLE `script_spline_chain_meta` MODIFY `velocity` float NOT NULL DEFAULT '0'; + +-- longtext +ALTER TABLE `command` MODIFY `help` mediumtext NOT NULL; +ALTER TABLE `creature_text` MODIFY `Text` mediumtext NOT NULL; +ALTER TABLE `page_text` MODIFY `Text` mediumtext NOT NULL; -- cgit v1.2.3