diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql | 13 | ||||
| -rw-r--r-- | sql/updates/world/master/2024_11_19_00_world.sql | 5 |
2 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql new file mode 100644 index 00000000000..678c526c8e2 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql @@ -0,0 +1,13 @@ +-- +-- Table structure for table `mount_equipment` +-- +DROP TABLE IF EXISTS `mount_equipment`; +CREATE TABLE `mount_equipment` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Item` int NOT NULL DEFAULT '0', + `BuffSpell` int NOT NULL DEFAULT '0', + `Unknown820` int NOT NULL DEFAULT '0', + `LearnedBySpell` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/sql/updates/world/master/2024_11_19_00_world.sql b/sql/updates/world/master/2024_11_19_00_world.sql new file mode 100644 index 00000000000..dc2c1212fb1 --- /dev/null +++ b/sql/updates/world/master/2024_11_19_00_world.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_comfortable_riders_barding'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_saddlechute'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(296837, 'spell_gen_comfortable_riders_barding'), +(297091, 'spell_gen_saddlechute'); |