Core/Events: refactored battleground holiday assignments.

 Instead of going with shitty bitmasks we now accept plain battleground ids
 instead

(cherry picked from commit 8a82403400ef49415e14530f4b55d55ef38bc74e)

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_21_31_world_2020_07_07_00_world.sql b/sql/updates/world/master/2022_01_21_31_world_2020_07_07_00_world.sql
new file mode 100644
index 00000000000..c4fd7462fe0
--- /dev/null
+++ b/sql/updates/world/master/2022_01_21_31_world_2020_07_07_00_world.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `game_event_battleground_holiday`   
+	CHANGE `eventEntry` `EventEntry` TINYINT(3) UNSIGNED NOT NULL COMMENT 'game_event EventEntry identifier',
+	CHANGE `bgflag` `BattlegroundID` INT(3) UNSIGNED DEFAULT 0 NOT NULL;
+
+DELETE FROM `game_event_battleground_holiday`;
+-- INSERT INTO `game_event_battleground_holiday` (`EventEntry`, `BattlegroundID`) VALUES
+-- (18, 1),
+-- (19, 2),
+-- (20, 3),
+-- (21, 7),
+-- (53, 9),
+-- (54, 30);