aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_21_31_world_2020_07_07_00_world.sql12
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);