Merge pull request #11719 from Dehravor/master-loot

Core/Loot: Fix master loot

2 files changed, 2 insertions, 0 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 86d08ca954b..c7e1372e9a1 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1632,6 +1632,7 @@ CREATE TABLE `groups` (
   `groupType` tinyint(3) unsigned NOT NULL,
   `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `masterLooterGuid` int(10) unsigned NOT NULL,
   PRIMARY KEY (`guid`),
   KEY `leaderGuid` (`leaderGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
diff --git a/sql/updates/characters/2014_03_16_00_characters_groups.sql b/sql/updates/characters/2014_03_16_00_characters_groups.sql
new file mode 100644
index 00000000000..bec5963c23c
--- /dev/null
+++ b/sql/updates/characters/2014_03_16_00_characters_groups.sql
@@ -0,0 +1 @@
+ALTER TABLE `groups` ADD COLUMN `masterLooterGuid` INT(10) UNSIGNED NOT NULL AFTER `raiddifficulty`;