From 4e496acc7f0779529ebad0eb0ecea7c7ae2afe92 Mon Sep 17 00:00:00 2001
From: onefang
Date: Fri, 3 Sep 2021 06:45:08 +1000
Subject: os_groups UUIDs are 36 charcters, not 255 varchars.

---
 OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'OpenSim')

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;
-- 
cgit v1.1