From 408bb461b35e102036d2006925c69bb3e11db0a5 Mon Sep 17 00:00:00 2001 From: raczman Date: Tue, 14 Apr 2009 14:45:05 +0200 Subject: Add sql update for creature respawn linking. --HG-- branch : trunk --- sql/updates/1362_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/1362_world.sql (limited to 'sql') diff --git a/sql/updates/1362_world.sql b/sql/updates/1362_world.sql new file mode 100644 index 00000000000..a6d786871d6 --- /dev/null +++ b/sql/updates/1362_world.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS `creature_linked_respawn`; +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'; + +DELETE FROM `trinity_string` WHERE `entry` = '750'; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +('750', 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- cgit v1.2.3