aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2019-07-15 05:59:57 +0000
committerTDB Release <tdb-release@build.bot>2019-07-15 05:59:57 +0000
commitf46644c92585c5bccc612363d1b8aae5d0667960 (patch)
tree197d1eddb89478d66e87aac0b6c726806921ac5b /sql/updates/characters
parent374597c8e96c886f1e3647d405bf3160c8b98bf8 (diff)
TDB 335.19071 - 2019/07/15TDB335.19071
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/3.3.5/2019_07_14_00_characters.sql20
-rw-r--r--sql/updates/characters/3.3.5/2019_07_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2019_06_15_00_characters.sql)2
2 files changed, 1 insertions, 21 deletions
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
deleted file mode 100644
index 24fc278db61..00000000000
--- a/sql/updates/characters/3.3.5/2019_07_14_00_characters.sql
+++ /dev/null
@@ -1,20 +0,0 @@
---
-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`;
diff --git a/sql/updates/characters/3.3.5/2019_06_15_00_characters.sql b/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql
index 96e266d212b..7b15aaa0140 100644
--- a/sql/updates/characters/3.3.5/2019_06_15_00_characters.sql
+++ b/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql
@@ -1,2 +1,2 @@
--- TDB 335.19061 characters
+-- TDB 335.19071 characters
UPDATE `updates` SET `state`='ARCHIVED';