Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single `respawn` table

(cherry picked from commit 374597c8e96c886f1e3647d405bf3160c8b98bf8)

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2021_12_16_00_characters_2019_07_14_00_characters.sql b/sql/updates/characters/master/2021_12_16_00_characters_2019_07_14_00_characters.sql
new file mode 100644
index 00000000000..ca35b4b6994
--- /dev/null
+++ b/sql/updates/characters/master/2021_12_16_00_characters_2019_07_14_00_characters.sql
@@ -0,0 +1,20 @@
+-- 
+DROP TABLE IF EXISTS `respawn`;
+CREATE TABLE `respawn` (
+  `type` smallint(10) unsigned NOT NULL,
+  `spawnId` bigint(20) unsigned NOT NULL,
+  `respawnTime` bigint(20) NOT NULL,
+  `mapId` smallint(10) unsigned NOT NULL,
+  `instanceId` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`type`,`spawnId`,`instanceId`),
+  KEY `idx_instance` (`instanceId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stored respawn times';
+
+INSERT INTO `respawn` (`type`,`spawnId`,`respawnTime`,`mapId`,`instanceId`)
+SELECT 0 as `type`,`guid`,`respawnTime`,`mapId`,`instanceId` FROM `creature_respawn`;
+
+INSERT INTO `respawn` (`type`,`spawnId`,`respawnTime`,`mapId`,`instanceId`)
+SELECT 1 as `type`,`guid`,`respawnTime`,`mapId`,`instanceId` FROM `gameobject_respawn`;
+
+DROP TABLE `creature_respawn`;
+DROP TABLE `gameobject_respawn`;