[mangos-0.12]missed part of 091_9339_01_characters_group.sql

[mns]

before_upgrade_to_0.13

diff --git a/sql/updates/before_upgrade_to_0.13/091_9339_01_characters_group.sql b/sql/updates/before_upgrade_to_0.13/091_9339_01_characters_group.sql
new file mode 100644
index 0000000..f3be2b7
--- /dev/null
+++ b/sql/updates/before_upgrade_to_0.13/091_9339_01_characters_group.sql
@@ -0,0 +1,14 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_091_9339_01_characters_group required_066_8409_01_characters_guild bit;
+
+ALTER TABLE group_member
+  CHANGE COLUMN `groupId` `leaderGuid` int(11) unsigned NOT NULL;
+
+UPDATE `group_member`,`groups` SET `group_member`.`leaderGuid` = `groups`.`leaderGuid` WHERE `group_member`.`leaderGuid` = `groups`.`groupId`;
+
+ALTER TABLE groups
+  DROP COLUMN `groupId`;
+
+ALTER TABLE groups
+  DROP INDEX `leaderGuid`,
+  ADD PRIMARY KEY (`leaderGuid`);
+
diff --git a/sql/updates/before_upgrade_to_0.13/Makefile.am b/sql/updates/before_upgrade_to_0.13/Makefile.am
index 9b94c02..699f852 100644
--- a/sql/updates/before_upgrade_to_0.13/Makefile.am
+++ b/sql/updates/before_upgrade_to_0.13/Makefile.am
@@ -35,6 +35,7 @@ pkgdata_DATA = \\
 066_8402_01_characters_guild_eventlog.sql \\
 066_8402_02_characters_guild_bank_eventlog.sql \\
 066_8409_01_characters_guild.sql \\
+ 091_9339_01_characters_group.sql \\
 README

## Additional files to include when running 'make dist'
@@ -50,4 +51,5 @@ EXTRA_DIST = \\
 066_8402_01_characters_guild_eventlog.sql \\
 066_8402_02_characters_guild_bank_eventlog.sql \\
 066_8409_01_characters_guild.sql \\
+ 091_9339_01_characters_group.sql \\
 README

Patch file

[mns]

For 097_9611_01_characters.sql :

ALTER TABLE character_db_version CHANGE COLUMN required_097_9611_01_characters required_091_9339_01_characters_group bit;
ALTER TABLE `group_member`            DROP INDEX `Idx_memberGuid`;
ALTER TABLE `guild_eventlog`          DROP INDEX `Idx_PlayerGuid1`;
ALTER TABLE `guild_eventlog`          DROP INDEX `Idx_PlayerGuid2`;
ALTER TABLE `guild_bank_eventlog`     DROP INDEX `Idx_PlayerGuid`;
ALTER TABLE `petition_sign`           DROP INDEX `Idx_playerguid`;
ALTER TABLE `petition_sign`           DROP INDEX `Idx_ownerguid`;
ALTER TABLE `guild_eventlog`          DROP INDEX `Idx_LogGuid`;
ALTER TABLE `guild_bank_eventlog`     DROP INDEX `Idx_LogGuid`;
ALTER TABLE `guild_bank_item`         DROP INDEX `Idx_item_guid`;
ALTER TABLE `corpse`                  DROP INDEX `Idx_player`;
ALTER TABLE `corpse`                  DROP INDEX `Idx_time`;
ALTER TABLE `guild_rank`              DROP INDEX `Idx_rid`;

[VladimirMangos]

Ah, added. Sometime forgot add reversed sql update. Thank you