From 5cd39040592f526719d99b960a1a0d16499f86b4 Mon Sep 17 00:00:00 2001 From: click Date: Fri, 19 Nov 2010 15:53:14 +0100 Subject: 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 --- sql/base/world_database.sql | 72 --------------------------------------------- 1 file changed, 72 deletions(-) (limited to 'sql/base/world_database.sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 8a1f9bf5596..7e0a4e0cc45 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -1574,31 +1574,6 @@ LOCK TABLES `creature_questrelation` WRITE; /*!40000 ALTER TABLE `creature_questrelation` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `creature_respawn` --- - -DROP TABLE IF EXISTS `creature_respawn`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `creature_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `respawntime` bigint(20) NOT NULL DEFAULT '0', - `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `creature_respawn` --- - -LOCK TABLES `creature_respawn` WRITE; -/*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */; -/*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `creature_template` -- @@ -2635,31 +2610,6 @@ LOCK TABLES `gameobject_questrelation` WRITE; /*!40000 ALTER TABLE `gameobject_questrelation` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `gameobject_respawn` --- - -DROP TABLE IF EXISTS `gameobject_respawn`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `gameobject_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `respawntime` bigint(20) NOT NULL DEFAULT '0', - `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `gameobject_respawn` --- - -LOCK TABLES `gameobject_respawn` WRITE; -/*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */; -/*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `gameobject_scripts` -- @@ -16592,28 +16542,6 @@ LOCK TABLES `reputation_spillover_template` WRITE; /*!40000 ALTER TABLE `reputation_spillover_template` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `reserved_name` --- - -DROP TABLE IF EXISTS `reserved_name`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `reserved_name` ( - `name` varchar(12) NOT NULL DEFAULT '', - PRIMARY KEY (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player Reserved Names'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `reserved_name` --- - -LOCK TABLES `reserved_name` WRITE; -/*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */; -/*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `script_texts` -- -- cgit v1.2.3