diff options
| author | Cerveciento <Cerveciento@users.noreply.github.com> | 2020-09-23 03:15:00 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-09-23 03:15:00 +0300 |
| commit | c84354389e450a3d754e0a3fa20d35414cbaea6f (patch) | |
| tree | 60db3abd440d9ead7b86f64120f1e9beb308a763 | |
| parent | 2ca94fa36825d46aa9431f24671be188e1562154 (diff) | |
DB/Locales: Add missing esES & esMX POI locales
Closes #25486
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_23_03_world_335.sql | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_09_23_03_world_335.sql b/sql/updates/world/3.3.5/2020_09_23_03_world_335.sql new file mode 100644 index 00000000000..86abce288b9 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |