From c05ed659cbc561b6e7c0016cc7b1548886d5337a Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
Date: Fri, 24 Dec 2010 18:55:50 +0100
Subject: Core/Entities: - Rename creature_linked_respawn to linked_respawn -
 Update functionality: add field ´linkType´. ** 0 = creature respawn dependant
 on creature (default) ** 1 = creature respawn dependant on gameobject ** 2 =
 gameobject respawn dependant on gameobject ** 3 = gameobject respawn
 dependant on creature
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

--HG--
branch : trunk
---
 sql/base/world_database.sql | 47 +++++++++++++++++++++++----------------------
 1 file changed, 24 insertions(+), 23 deletions(-)

(limited to 'sql/base/world_database.sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 6a9990a6f16..0e705852df0 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1450,29 +1450,6 @@ LOCK TABLES `creature_involvedrelation` WRITE;
 /*!40000 ALTER TABLE `creature_involvedrelation` ENABLE KEYS */;
 UNLOCK TABLES;
 
---
--- Table structure for table `creature_linked_respawn`
---
-
-DROP TABLE IF EXISTS `creature_linked_respawn`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `creature_linked_respawn` (
-  `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature',
-  `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature',
-  PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System';
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `creature_linked_respawn`
---
-
-LOCK TABLES `creature_linked_respawn` WRITE;
-/*!40000 ALTER TABLE `creature_linked_respawn` DISABLE KEYS */;
-/*!40000 ALTER TABLE `creature_linked_respawn` ENABLE KEYS */;
-UNLOCK TABLES;
-
 --
 -- Table structure for table `creature_loot_template`
 --
@@ -3143,6 +3120,30 @@ LOCK TABLES `lfg_dungeon_rewards` WRITE;
 /*!40000 ALTER TABLE `lfg_dungeon_rewards` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `linked_respawn`
+--
+
+DROP TABLE IF EXISTS `linked_respawn`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `linked_respawn` (
+  `guid` int(10) unsigned NOT NULL COMMENT 'slave entity',
+  `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master entity',
+  `linkType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0: creature->creature, 1: creature->GO, 2: GO->GO, 3: GO->creature', 
+  PRIMARY KEY (`guid`, `linkType`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Respawn Link System';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `linked_respawn`
+--
+
+LOCK TABLES `linked_respawn` WRITE;
+/*!40000 ALTER TABLE `linked_respawn` DISABLE KEYS */;
+/*!40000 ALTER TABLE `linked_respawn` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `locales_achievement_reward`
 --
-- 
cgit v1.2.3

