Core/Database: Adjust character database fields to have an existing default value (group_member) - fixes a transactionerror

--HG--
branch : trunk

1 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/10543_world_group_member.sql b/sql/updates/10543_world_group_member.sql
new file mode 100644
index 00000000000..5c018bcad90
--- /dev/null
+++ b/sql/updates/10543_world_group_member.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `group_member`
+CHANGE `guid` `guid` INT(11) UNSIGNED NOT NULL,
+CHANGE `memberGuid` `memberGuid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `memberFlags` `memberFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `subgroup` `subgroup` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `roles` `roles` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';