From 17665c929c3a9fb7fe75dd680648129bc1c1f874 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 22 Jul 2018 13:22:35 +0200 Subject: Core/Instances: Instance lock rewrite (WIP) --- .../characters/master/2022_10_03_00_characters.sql | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sql/updates/characters/master/2022_10_03_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2022_10_03_00_characters.sql b/sql/updates/characters/master/2022_10_03_00_characters.sql new file mode 100644 index 00000000000..ab8c334882c --- /dev/null +++ b/sql/updates/characters/master/2022_10_03_00_characters.sql @@ -0,0 +1,30 @@ +-- +-- Table structure for table `character_instance_lock` +-- +DROP TABLE IF EXISTS `character_instance_lock`; +CREATE TABLE `character_instance_lock` ( + `guid` bigint unsigned NOT NULL, + `mapId` int unsigned NOT NULL, + `lockId` int unsigned NOT NULL, + `instanceId` int unsigned DEFAULT NULL, + `difficulty` tinyint unsigned DEFAULT NULL, + `data` text COLLATE utf8mb4_unicode_ci, + `completedEncountersMask` int unsigned DEFAULT NULL, + `entranceWorldSafeLocId` int unsigned DEFAULT NULL, + `expiryTime` bigint unsigned DEFAULT NULL, + `extended` tinyint unsigned DEFAULT NULL, + PRIMARY KEY (`guid`,`mapId`,`lockId`), + UNIQUE KEY `uk_character_instanceId` (`guid`,`instanceId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `instance` +-- +DROP TABLE IF EXISTS `instance`; +CREATE TABLE `instance` ( + `instanceId` int unsigned NOT NULL, + `data` text COLLATE utf8mb4_unicode_ci, + `completedEncountersMask` int unsigned DEFAULT NULL, + `entranceWorldSafeLocId` int unsigned DEFAULT NULL, + PRIMARY KEY (`instanceId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3