diff options
| author | Cerveciento <Cerveciento@users.noreply.github.com> | 2020-09-23 03:15:00 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-27 23:19:39 +0100 |
| commit | 20511e5f793cb0a929a1ffbe23d17a3ddb8554f4 (patch) | |
| tree | 1aa94c3f9f52bb80832fd40f7ac8a090b1846733 | |
| parent | cf564441ed408ac5de3374feaa81f05085768641 (diff) | |
DB/Locales: Add missing esES & esMX POI locales
Closes #25486
(cherry picked from commit c84354389e450a3d754e0a3fa20d35414cbaea6f)
| -rw-r--r-- | sql/updates/world/master/2022_02_27_39_world_2020_09_23_03_world_335.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_27_39_world_2020_09_23_03_world_335.sql b/sql/updates/world/master/2022_02_27_39_world_2020_09_23_03_world_335.sql new file mode 100644 index 00000000000..86abce288b9 --- /dev/null +++ b/sql/updates/world/master/2022_02_27_39_world_2020_09_23_03_world_335.sql @@ -0,0 +1,42 @@ +-- 447 Morganus +SET @ID := 447; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Morganus', 0), +(@ID, 'esMX','Morganus', 0); +-- 448 Recuerdos de la Fiesta de la Cerveza +SET @ID := 448; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Recuerdos de la Fiesta de la Cerveza', 0), +(@ID, 'esMX','Recuerdos de la Fiesta de la Cerveza', 0); +-- 449 Carrera de Carneros de la Fiesta de la Cerveza +SET @ID := 449; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Carrera de Carneros de la Fiesta de la Cerveza', 0), +(@ID, 'esMX','Carrera de Carneros de la Fiesta de la Cerveza', 0); +-- 450 Club de la Cerveza del Mes, Forjaz +SET @ID := 450; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Club de la Cerveza del Mes, Forjaz', 0), +(@ID, 'esMX','Club de la Cerveza del Mes, Forjaz', 0); +-- 451 Recuerdos de la Fiesta de la Cerveza Goblin +SET @ID := 451; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Recuerdos de la Fiesta de la Cerveza Goblin', 0), +(@ID, 'esMX','Recuerdos de la Fiesta de la Cerveza Goblin', 0); +-- 452 Carrera de Carneros de la Fiesta de la Cerveza Goblin +SET @ID := 452; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Carrera de Carneros de la Fiesta de la Cerveza Goblin', 0), +(@ID, 'esMX','Carrera de Carneros de la Fiesta de la Cerveza Goblin', 0); +-- 453 Club de la Cerveza del Mes, Orgrimmar +SET @ID := 453; +DELETE FROM `points_of_interest_locale` WHERE `ID` = @ID AND `locale` IN('esES', 'esMX'); +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES +(@ID, 'esES','Club de la Cerveza del Mes, Orgrimmar', 0), +(@ID, 'esMX','Club de la Cerveza del Mes, Orgrimmar', 0); |