diff options
| author | TDB Release <tdb-release@build.bot> | 2019-07-15 05:59:57 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2019-07-15 05:59:57 +0000 |
| commit | f46644c92585c5bccc612363d1b8aae5d0667960 (patch) | |
| tree | 197d1eddb89478d66e87aac0b6c726806921ac5b /sql/updates/characters | |
| parent | 374597c8e96c886f1e3647d405bf3160c8b98bf8 (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.sql | 20 | ||||
| -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'; |
