diff options
| -rw-r--r-- | sql/base/characters_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/10543_world_group_member.sql | 6 |
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'; |