diff options
| author | TDB Release <tdb-release@build.bot> | 2022-11-20 11:12:09 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2022-11-20 11:12:09 +0000 |
| commit | 85205d8ca5d41e4eca09619ebf46d92e7b925aaa (patch) | |
| tree | 53bdfca18e1a7ab0f109c08635282761cbd555ee /sql/old/9.x/characters | |
| parent | deff234e8fe4e84d5e6042410a2de9e8fd1983b2 (diff) | |
TDB 927.22111 - 2022/11/20TDB927.22111
Diffstat (limited to 'sql/old/9.x/characters')
5 files changed, 38 insertions, 0 deletions
diff --git a/sql/old/9.x/characters/22082_2022_11_20/2022_08_21_00_characters.sql b/sql/old/9.x/characters/22082_2022_11_20/2022_08_21_00_characters.sql new file mode 100644 index 00000000000..f81eae18344 --- /dev/null +++ b/sql/old/9.x/characters/22082_2022_11_20/2022_08_21_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 927.22082 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED'); diff --git a/sql/old/9.x/characters/22082_2022_11_20/2022_09_18_00_characters.sql b/sql/old/9.x/characters/22082_2022_11_20/2022_09_18_00_characters.sql new file mode 100644 index 00000000000..c87d83fa1f6 --- /dev/null +++ b/sql/old/9.x/characters/22082_2022_11_20/2022_09_18_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `character_action` MODIFY `action` bigint unsigned NOT NULL DEFAULT 0; diff --git a/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_00_characters.sql b/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_00_characters.sql new file mode 100644 index 00000000000..ab8c334882c --- /dev/null +++ b/sql/old/9.x/characters/22082_2022_11_20/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; diff --git a/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_01_characters.sql b/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_01_characters.sql new file mode 100644 index 00000000000..7883656f3c7 --- /dev/null +++ b/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_01_characters.sql @@ -0,0 +1,3 @@ +DROP TABLE IF EXISTS `character_instance`; +DROP TABLE IF EXISTS `group_instance`; +DROP TABLE IF EXISTS `instance_reset`; diff --git a/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_02_characters.sql b/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_02_characters.sql new file mode 100644 index 00000000000..0bc7b663012 --- /dev/null +++ b/sql/old/9.x/characters/22082_2022_11_20/2022_10_03_02_characters.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `instance_scenario_progress`; |