diff options
| author | click <none@none> | 2010-11-19 15:53:14 +0100 |
|---|---|---|
| committer | click <none@none> | 2010-11-19 15:53:14 +0100 |
| commit | 5cd39040592f526719d99b960a1a0d16499f86b4 (patch) | |
| tree | ef668f219c2bfc0c56d69312f56ab8f08fe26cb5 /sql/updates | |
| parent | 3e27be75014ec74efc94a8d7bcc03f2391dcc098 (diff) | |
Core/DBLayer: Move tables reserved_name, gameobject_respawn and creature_respawn from WORLD database to CHARACTER database as it's content is realm-specific and should be preserved (thanks to leak for the cleanup)
*** TO PRESERVE (COPY) THE DATA CONTAINED IN THE OLD TABLES, YOU MUST FOLLOW THE FOLLOWING SQL-RECIPE (REPLACE DATABASENAMES WHERE NEEDED!) ***
-- Move creature_respawn from world to characters db
INSERT INTO `characters`.`creature_respawn` (`guid`, `respawntime`, `instance`)
SELECT `guid, `respawntime` `instance` * FROM `world`.`creature_respawn`;
-- Remove creature_respawn table from world db
DROP TABLE `world`.`creature_respawn`;
-- Move gameobject_respawn from world to characters db
INSERT INTO `characters`.`gameobject_respawn` (`guid`, `respawntime`, `instance`)
SELECT `guid`, `respawntime`, `instance` FROM `world`.`gameobject_respawn`;
-- Remove creature_respawn table from world db
DROP TABLE `world`.`gameobject_respawn`;
-- Move reserved names from world to characters db
INSERT INTO `characters`.`reserved_name` (`name`)
SELECT `name` FROM `world`.`reserved_name`;
-- Remove reserved_names table from world db
DROP TABLE `world`.`reserved_name`;
*** THE ABOVE MUST BE DONE, OR EXISTING INSTANCES WILL BE FULLY RESPAWNED - YOU HAVE BEEN WARNED ***
Closes issue 4842. Closes issue 4849.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
4 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/10475_characters_character_banned.sql b/sql/updates/10475_characters_character_banned.sql new file mode 100644 index 00000000000..1d4789a4f33 --- /dev/null +++ b/sql/updates/10475_characters_character_banned.sql @@ -0,0 +1 @@ +ALTER TABLE character_banned ENGINE = InnoDB; diff --git a/sql/updates/10475_characters_creature_respawn.sql b/sql/updates/10475_characters_creature_respawn.sql new file mode 100644 index 00000000000..e6964910597 --- /dev/null +++ b/sql/updates/10475_characters_creature_respawn.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS `creature_respawn`; +CREATE TABLE `creature_respawn` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `respawntime` int(10) unsigned NOT NULL DEFAULT '0', + `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; + diff --git a/sql/updates/10475_characters_gameobject_respawn.sql b/sql/updates/10475_characters_gameobject_respawn.sql new file mode 100644 index 00000000000..2a5f0c03de7 --- /dev/null +++ b/sql/updates/10475_characters_gameobject_respawn.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS `gameobject_respawn`; +CREATE TABLE `gameobject_respawn` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `respawntime` int(10) unsigned NOT NULL DEFAULT '0', + `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; + diff --git a/sql/updates/10475_characters_reserved_name.sql b/sql/updates/10475_characters_reserved_name.sql new file mode 100644 index 00000000000..dedab8b5911 --- /dev/null +++ b/sql/updates/10475_characters_reserved_name.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `reserved_name`; +CREATE TABLE `reserved_name` ( + `name` varchar(12) NOT NULL DEFAULT '', + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names'; + |