From 29e032707686b18bbcce7029e8dd2eaa6606f6d4 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 4 Mar 2025 13:52:20 +0100 Subject: Core/Players: Implement warband scene collection --- sql/updates/auth/master/2025_03_04_00_auth.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/auth/master/2025_03_04_00_auth.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/master/2025_03_04_00_auth.sql b/sql/updates/auth/master/2025_03_04_00_auth.sql new file mode 100644 index 00000000000..28cb2180db8 --- /dev/null +++ b/sql/updates/auth/master/2025_03_04_00_auth.sql @@ -0,0 +1,12 @@ +-- +-- Table structure for table `battlenet_account_warband_scenes` +-- +DROP TABLE IF EXISTS `battlenet_account_warband_scenes`; +CREATE TABLE `battlenet_account_warband_scenes` ( + `battlenetAccountId` int unsigned NOT NULL, + `warbandSceneId` int NOT NULL DEFAULT '0', + `isFavorite` tinyint(1) DEFAULT '0', + `hasFanfare` tinyint(1) DEFAULT '0', + PRIMARY KEY (`battlenetAccountId`,`warbandSceneId`), + CONSTRAINT `fk_battlenet_account_warband_scenes__accountId` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3