From 374597c8e96c886f1e3647d405bf3160c8b98bf8 Mon Sep 17 00:00:00 2001 From: Treeston Date: Sun, 14 Jul 2019 18:49:38 +0200 Subject: Core/DB: Unify `creature_respawn` and `gameobject_respawn` into a single `respawn` table --- .../characters/3.3.5/2019_07_14_00_characters.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/characters/3.3.5/2019_07_14_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/3.3.5/2019_07_14_00_characters.sql b/sql/updates/characters/3.3.5/2019_07_14_00_characters.sql new file mode 100644 index 00000000000..24fc278db61 --- /dev/null +++ b/sql/updates/characters/3.3.5/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` int(10) unsigned NOT NULL, + `respawnTime` bigint(20) unsigned 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`; -- cgit v1.2.3