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

--HG--
branch : trunk

2 files changed, 10 insertions, 4 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b9916340c19..96a59021971 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1424,10 +1424,10 @@ DROP TABLE IF EXISTS `group_member`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `group_member` (
   `guid` int(11) unsigned NOT NULL,
-  `memberGuid` int(11) unsigned NOT NULL,
-  `memberFlags` tinyint(2) unsigned NOT NULL,
-  `subgroup` smallint(6) unsigned NOT NULL,
-  `roles` smallint(6) unsigned NOT NULL default '0',
+  `memberGuid` int(11) unsigned NOT NULL default '0',
+  `memberFlags` tinyint(3) unsigned NOT NULL default '0',
+  `subgroup` tinyint(3) unsigned NOT NULL default '0',
+  `roles` tinyint(3) unsigned NOT NULL default '0',
   PRIMARY KEY  (`memberGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
 /*!40101 SET character_set_client = @saved_cs_client */;
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';