aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorraczman <none@none>2009-04-14 14:45:05 +0200
committerraczman <none@none>2009-04-14 14:45:05 +0200
commit408bb461b35e102036d2006925c69bb3e11db0a5 (patch)
tree9edcd1dacd544e9aca0009b2b9b9bf31245903c8
parentdef6071b8f15712a0ef5b1afc0b336f73a7d4e62 (diff)
Add sql update for creature respawn linking.
--HG-- branch : trunk
-rw-r--r--sql/updates/1362_world.sql10
1 files changed, 10 insertions, 0 deletions
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);