aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2020_07_07_01_world.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_07_01_world.sql b/sql/updates/world/3.3.5/2020_07_07_01_world.sql
new file mode 100644
index 00000000000..080e1421c97
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_07_07_01_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;
+
+TRUNCATE TABLE `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);