TDB 927.22111 - 2022/11/20TDB927.22111

5 files changed, 1 insertions, 36 deletions

diff --git a/sql/updates/characters/master/2022_09_18_00_characters.sql b/sql/updates/characters/master/2022_09_18_00_characters.sql
deleted file mode 100644
index c87d83fa1f6..00000000000
--- a/sql/updates/characters/master/2022_09_18_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `character_action` MODIFY `action` bigint unsigned NOT NULL DEFAULT 0;
diff --git a/sql/updates/characters/master/2022_10_03_00_characters.sql b/sql/updates/characters/master/2022_10_03_00_characters.sql
deleted file mode 100644
index ab8c334882c..00000000000
--- a/sql/updates/characters/master/2022_10_03_00_characters.sql
+++ /dev/null
@@ -1,30 +0,0 @@
---
--- 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/updates/characters/master/2022_10_03_01_characters.sql b/sql/updates/characters/master/2022_10_03_01_characters.sql
deleted file mode 100644
index 7883656f3c7..00000000000
--- a/sql/updates/characters/master/2022_10_03_01_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DROP TABLE IF EXISTS `character_instance`;
-DROP TABLE IF EXISTS `group_instance`;
-DROP TABLE IF EXISTS `instance_reset`;
diff --git a/sql/updates/characters/master/2022_10_03_02_characters.sql b/sql/updates/characters/master/2022_10_03_02_characters.sql
deleted file mode 100644
index 0bc7b663012..00000000000
--- a/sql/updates/characters/master/2022_10_03_02_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-DROP TABLE IF EXISTS `instance_scenario_progress`;
diff --git a/sql/updates/characters/master/2022_08_21_00_characters.sql b/sql/updates/characters/master/2022_11_20_00_characters.sql
index f81eae18344..46bfa1de3a1 100644
--- a/sql/updates/characters/master/2022_08_21_00_characters.sql
+++ b/sql/updates/characters/master/2022_11_20_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 927.22082 characters
+-- TDB 927.22111 characters
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED');