From c5593ef779a4ba7bbe9df391bc0defd3bf6c33a1 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Sat, 6 Dec 2008 14:01:44 -0600
Subject: *Update to Mangos 6880. Source: Mangos. *Skip 6878, 6871. *Main
 change: change cell size, add is3dDistance for IsWithinDistInMap and
 isVisibleForOrDetect.

--HG--
branch : trunk
---
 sql/characters.sql             | 2 +-
 sql/updates/410_characters.sql | 2 ++
 2 files changed, 3 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/410_characters.sql

(limited to 'sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 2e5eedcf6a7..83903ecc592 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -963,7 +963,7 @@ CREATE TABLE `guild_member` (
   `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
   KEY `guildid_key` (`guildid`),
   KEY `guildid_rank_key` (`guildid`,`rank`),
-  KEY `guid_key` (`guid`)
+  UNIQUE KEY `guid_key` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
 
 --
diff --git a/sql/updates/410_characters.sql b/sql/updates/410_characters.sql
new file mode 100644
index 00000000000..0e47f296e7e
--- /dev/null
+++ b/sql/updates/410_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `guild_member` DROP INDEX `guid_key` ,
+ADD UNIQUE `guid_key` ( `guid` );
\ No newline at end of file
-- 
cgit v1.2.3