From d6bcc229eba25ae240322f48ea3f31b832d55ab4 Mon Sep 17 00:00:00 2001
From: onefang
Date: Sun, 19 May 2019 21:56:12 +1000
Subject: Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space
---
 .../MySQL/Resources/os_groups_Store.migrations     | 28 +++++++++++-----------
 1 file changed, 14 insertions(+), 14 deletions(-)

(limited to 'OpenSim/Data/MySQL/Resources/os_groups_Store.migrations')

diff --git a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
index 6ec8914..0b605ab 100644
--- a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
+++ b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
@@ -2,7 +2,7 @@
 
 BEGIN;
 
-CREATE TABLE `os_groups_groups` (
+CREATE TABLE IF NOT EXISTS `os_groups_groups` (
   `GroupID` char(36) NOT NULL default '',
   `Location` varchar(255) NOT NULL default '',
   `Name` varchar(255) NOT NULL default '',
@@ -18,10 +18,10 @@ CREATE TABLE `os_groups_groups` (
   PRIMARY KEY  (`GroupID`),
   UNIQUE KEY `Name` (`Name`),
   FULLTEXT KEY `Name_2` (`Name`)
-) ENGINE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-CREATE TABLE `os_groups_membership` (
+CREATE TABLE IF NOT EXISTS `os_groups_membership` (
   `GroupID`char(36) NOT NULL default '',
   `PrincipalID` VARCHAR(255) NOT NULL default '',
   `SelectedRoleID` char(36) NOT NULL default '',
@@ -31,10 +31,10 @@ CREATE TABLE `os_groups_membership` (
   `AccessToken` char(36) NOT NULL default '',
   PRIMARY KEY  (`GroupID`,`PrincipalID`),
   KEY `PrincipalID` (`PrincipalID`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-CREATE TABLE `os_groups_roles` (
+CREATE TABLE IF NOT EXISTS `os_groups_roles` (
   `GroupID` char(36) NOT NULL default '',
   `RoleID` char(36) NOT NULL default '',
   `Name` varchar(255) NOT NULL default '',
@@ -43,19 +43,19 @@ CREATE TABLE `os_groups_roles` (
   `Powers` bigint(20) unsigned NOT NULL default '0',
   PRIMARY KEY  (`GroupID`,`RoleID`),
   KEY `GroupID` (`GroupID`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-CREATE TABLE `os_groups_rolemembership` (
+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 '',
   PRIMARY KEY  (`GroupID`,`RoleID`,`PrincipalID`),
   KEY `PrincipalID` (`PrincipalID`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-CREATE TABLE `os_groups_invites` (
+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 '',
@@ -63,10 +63,10 @@ CREATE TABLE `os_groups_invites` (
   `TMStamp` timestamp NOT NULL,
   PRIMARY KEY  (`InviteID`),
   UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-CREATE TABLE `os_groups_notices` (
+CREATE TABLE IF NOT EXISTS `os_groups_notices` (
   `GroupID` char(36) NOT NULL default '',
   `NoticeID` char(36) NOT NULL default '',
   `TMStamp` int(10) unsigned NOT NULL default '0',
@@ -81,13 +81,13 @@ CREATE TABLE `os_groups_notices` (
   PRIMARY KEY  (`NoticeID`),
   KEY  `GroupID` (`GroupID`),
   KEY `TMStamp` (`TMStamp`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE `os_groups_principals` (
+CREATE TABLE IF NOT EXISTS `os_groups_principals` (
   `PrincipalID` VARCHAR(255) NOT NULL default '',
   `ActiveGroupID` char(36) NOT NULL default '',
   PRIMARY KEY  (`PrincipalID`)
-) ENGINE=InnoDB;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;
 
-- 
cgit v1.1