1 files changed, 4 insertions, 4 deletions

diff --git a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
index dfea50d..59e320c 100644
--- a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
+++ b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
@@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_groups` (
 
 CREATE TABLE IF NOT EXISTS `os_groups_membership` (
   `GroupID`char(36) NOT NULL default '',
-  `PrincipalID` VARCHAR(255) NOT NULL default '',
+  `PrincipalID` CHAR(36) NOT NULL default '',
   `SelectedRoleID` char(36) NOT NULL default '',
   `Contribution` int(11) NOT NULL default '0',
   `ListInProfile` int(4) NOT NULL default '1',
@@ -49,7 +49,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_roles` (
 CREATE TABLE IF NOT EXISTS `os_groups_rolemembership` (
   `GroupID` char(36) NOT NULL default '',
   `RoleID` char(36) NOT NULL default '',
-  `PrincipalID` VARCHAR(255) NOT NULL default '',
+  `PrincipalID` CHAR(36) NOT NULL default '',
   PRIMARY KEY  (`GroupID`,`RoleID`,`PrincipalID`),
   KEY `PrincipalID` (`PrincipalID`)
 ) ENGINE=MyISAM;
@@ -59,7 +59,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_invites` (
   `InviteID` char(36) NOT NULL default '',
   `GroupID` char(36) NOT NULL default '',
   `RoleID` char(36) NOT NULL default '',
-  `PrincipalID` VARCHAR(255) NOT NULL default '',
+  `PrincipalID` CHAR(36) NOT NULL default '',
   `TMStamp` timestamp NOT NULL,
   PRIMARY KEY  (`InviteID`),
   UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
@@ -84,7 +84,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_notices` (
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `os_groups_principals` (
-  `PrincipalID` VARCHAR(255) NOT NULL default '',
+  `PrincipalID` CHAR(36) NOT NULL default '',
   `ActiveGroupID` char(36) NOT NULL default '',
   PRIMARY KEY  (`PrincipalID`)
 ) ENGINE=MyISAM;