Core/Battlegrounds: Rework queues (#29200)

* No more copies of Battleground classes
* FreesSlotQueues now have as key the MapId instead of queue id
* Random queues can now popup already busy specific battelgrounds (queues are NOT merged)
* Removed Holiday handling, this should already be handled in BattlegroundMgr::IsBGWeekend

3 files changed, 8 insertions, 2 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index d72e85fffc7..5e75e1c5b69 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -636,6 +636,7 @@ CREATE TABLE `character_battleground_data` (
   `taxiStart` int unsigned NOT NULL DEFAULT '0',
   `taxiEnd` int unsigned NOT NULL DEFAULT '0',
   `mountSpell` int unsigned NOT NULL DEFAULT '0',
+  `queueId` BIGINT UNSIGNED DEFAULT '0',
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3397,7 +3398,7 @@ CREATE TABLE `pvpstats_battlegrounds` (
   `id` bigint unsigned NOT NULL AUTO_INCREMENT,
   `winner_faction` tinyint NOT NULL,
   `bracket_id` tinyint unsigned NOT NULL,
-  `type` tinyint unsigned NOT NULL,
+  `type` int unsigned NOT NULL,
   `date` datetime NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3708,7 +3709,8 @@ INSERT INTO `updates` VALUES
 ('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0),
 ('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','ARCHIVED','2023-05-04 16:17:31',0),
 ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0),
-('2023_07_14_00_characters.sql','BB44A95A9C4B0C16878A5316AC38E702A8AACDE2','ARCHIVED','2023-07-14 08:24:44',0);
+('2023_07_14_00_characters.sql','BB44A95A9C4B0C16878A5316AC38E702A8AACDE2','ARCHIVED','2023-07-14 08:24:44',0),
+('2023_08_26_00_characters.sql','FA50838609AB5E645FB2DCAC970BD5706F9EFAAF','RELEASED','2023-08-26 12:18:22',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/master/2023_08_26_00_characters.sql b/sql/updates/characters/master/2023_08_26_00_characters.sql
new file mode 100644
index 00000000000..7b1ca982250
--- /dev/null
+++ b/sql/updates/characters/master/2023_08_26_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `character_battleground_data` ADD `queueId` BIGINT UNSIGNED NULL DEFAULT '0' AFTER `mountSpell`;
+
+ALTER TABLE `pvpstats_battlegrounds` CHANGE `type` `type` int unsigned NOT NULL;
diff --git a/sql/updates/world/master/2023_08_26_00_world.sql b/sql/updates/world/master/2023_08_26_00_world.sql
new file mode 100644
index 00000000000..1809516b75d
--- /dev/null
+++ b/sql/updates/world/master/2023_08_26_00_world.sql
@@ -0,0 +1 @@
+DROP TABLE IF EXISTS `game_event_battleground_holiday`;