diff options
| author | onefang | 2021-09-03 06:45:08 +1000 |
|---|---|---|
| committer | onefang | 2021-09-03 06:45:08 +1000 |
| commit | 4e496acc7f0779529ebad0eb0ecea7c7ae2afe92 (patch) | |
| tree | 33ff08cfebafb737af21e3d0fb1912a4a6c134d9 /OpenSim/Data | |
| parent | Change the database schemas for a few, might be able to create them now. (diff) | |
| download | opensim-SC-4e496acc7f0779529ebad0eb0ecea7c7ae2afe92.zip opensim-SC-4e496acc7f0779529ebad0eb0ecea7c7ae2afe92.tar.gz opensim-SC-4e496acc7f0779529ebad0eb0ecea7c7ae2afe92.tar.bz2 opensim-SC-4e496acc7f0779529ebad0eb0ecea7c7ae2afe92.tar.xz | |
os_groups UUIDs are 36 charcters, not 255 varchars.
Diffstat (limited to 'OpenSim/Data')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | 8 |
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` ( | |||
| 23 | 23 | ||
| 24 | CREATE TABLE IF NOT EXISTS `os_groups_membership` ( | 24 | CREATE TABLE IF NOT EXISTS `os_groups_membership` ( |
| 25 | `GroupID`char(36) NOT NULL default '', | 25 | `GroupID`char(36) NOT NULL default '', |
| 26 | `PrincipalID` VARCHAR(255) NOT NULL default '', | 26 | `PrincipalID` CHAR(36) NOT NULL default '', |
| 27 | `SelectedRoleID` char(36) NOT NULL default '', | 27 | `SelectedRoleID` char(36) NOT NULL default '', |
| 28 | `Contribution` int(11) NOT NULL default '0', | 28 | `Contribution` int(11) NOT NULL default '0', |
| 29 | `ListInProfile` int(4) NOT NULL default '1', | 29 | `ListInProfile` int(4) NOT NULL default '1', |
| @@ -49,7 +49,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_roles` ( | |||
| 49 | CREATE TABLE IF NOT EXISTS `os_groups_rolemembership` ( | 49 | CREATE TABLE IF NOT EXISTS `os_groups_rolemembership` ( |
| 50 | `GroupID` char(36) NOT NULL default '', | 50 | `GroupID` char(36) NOT NULL default '', |
| 51 | `RoleID` char(36) NOT NULL default '', | 51 | `RoleID` char(36) NOT NULL default '', |
| 52 | `PrincipalID` VARCHAR(255) NOT NULL default '', | 52 | `PrincipalID` CHAR(36) NOT NULL default '', |
| 53 | PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`), | 53 | PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`), |
| 54 | KEY `PrincipalID` (`PrincipalID`) | 54 | KEY `PrincipalID` (`PrincipalID`) |
| 55 | ) ENGINE=MyISAM; | 55 | ) ENGINE=MyISAM; |
| @@ -59,7 +59,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_invites` ( | |||
| 59 | `InviteID` char(36) NOT NULL default '', | 59 | `InviteID` char(36) NOT NULL default '', |
| 60 | `GroupID` char(36) NOT NULL default '', | 60 | `GroupID` char(36) NOT NULL default '', |
| 61 | `RoleID` char(36) NOT NULL default '', | 61 | `RoleID` char(36) NOT NULL default '', |
| 62 | `PrincipalID` VARCHAR(255) NOT NULL default '', | 62 | `PrincipalID` CHAR(36) NOT NULL default '', |
| 63 | `TMStamp` timestamp NOT NULL, | 63 | `TMStamp` timestamp NOT NULL, |
| 64 | PRIMARY KEY (`InviteID`), | 64 | PRIMARY KEY (`InviteID`), |
| 65 | UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`) | 65 | UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`) |
| @@ -84,7 +84,7 @@ CREATE TABLE IF NOT EXISTS `os_groups_notices` ( | |||
| 84 | ) ENGINE=MyISAM; | 84 | ) ENGINE=MyISAM; |
| 85 | 85 | ||
| 86 | CREATE TABLE IF NOT EXISTS `os_groups_principals` ( | 86 | CREATE TABLE IF NOT EXISTS `os_groups_principals` ( |
| 87 | `PrincipalID` VARCHAR(255) NOT NULL default '', | 87 | `PrincipalID` CHAR(36) NOT NULL default '', |
| 88 | `ActiveGroupID` char(36) NOT NULL default '', | 88 | `ActiveGroupID` char(36) NOT NULL default '', |
| 89 | PRIMARY KEY (`PrincipalID`) | 89 | PRIMARY KEY (`PrincipalID`) |
| 90 | ) ENGINE=MyISAM; | 90 | ) ENGINE=MyISAM; |