diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/os_groups_Store.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations index 9e6f1c1..0b605ab 100644 --- a/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations +++ b/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations | |||
@@ -2,7 +2,7 @@ | |||
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `os_groups_groups` ( | 5 | CREATE TABLE IF NOT EXISTS `os_groups_groups` ( |
6 | `GroupID` char(36) NOT NULL default '', | 6 | `GroupID` char(36) NOT NULL default '', |
7 | `Location` varchar(255) NOT NULL default '', | 7 | `Location` varchar(255) NOT NULL default '', |
8 | `Name` varchar(255) NOT NULL default '', | 8 | `Name` varchar(255) NOT NULL default '', |
@@ -18,10 +18,10 @@ CREATE TABLE `os_groups_groups` ( | |||
18 | PRIMARY KEY (`GroupID`), | 18 | PRIMARY KEY (`GroupID`), |
19 | UNIQUE KEY `Name` (`Name`), | 19 | UNIQUE KEY `Name` (`Name`), |
20 | FULLTEXT KEY `Name_2` (`Name`) | 20 | FULLTEXT KEY `Name_2` (`Name`) |
21 | ) ENGINE=MyISAM; | 21 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
22 | 22 | ||
23 | 23 | ||
24 | CREATE TABLE `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` VARCHAR(255) NOT NULL default '', |
27 | `SelectedRoleID` char(36) NOT NULL default '', | 27 | `SelectedRoleID` char(36) NOT NULL default '', |
@@ -31,10 +31,10 @@ CREATE TABLE `os_groups_membership` ( | |||
31 | `AccessToken` char(36) NOT NULL default '', | 31 | `AccessToken` char(36) NOT NULL default '', |
32 | PRIMARY KEY (`GroupID`,`PrincipalID`), | 32 | PRIMARY KEY (`GroupID`,`PrincipalID`), |
33 | KEY `PrincipalID` (`PrincipalID`) | 33 | KEY `PrincipalID` (`PrincipalID`) |
34 | ) ENGINE=MyISAM; | 34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
35 | 35 | ||
36 | 36 | ||
37 | CREATE TABLE `os_groups_roles` ( | 37 | CREATE TABLE IF NOT EXISTS `os_groups_roles` ( |
38 | `GroupID` char(36) NOT NULL default '', | 38 | `GroupID` char(36) NOT NULL default '', |
39 | `RoleID` char(36) NOT NULL default '', | 39 | `RoleID` char(36) NOT NULL default '', |
40 | `Name` varchar(255) NOT NULL default '', | 40 | `Name` varchar(255) NOT NULL default '', |
@@ -43,19 +43,19 @@ CREATE TABLE `os_groups_roles` ( | |||
43 | `Powers` bigint(20) unsigned NOT NULL default '0', | 43 | `Powers` bigint(20) unsigned NOT NULL default '0', |
44 | PRIMARY KEY (`GroupID`,`RoleID`), | 44 | PRIMARY KEY (`GroupID`,`RoleID`), |
45 | KEY `GroupID` (`GroupID`) | 45 | KEY `GroupID` (`GroupID`) |
46 | ) ENGINE=MyISAM; | 46 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
47 | 47 | ||
48 | 48 | ||
49 | CREATE TABLE `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` VARCHAR(255) 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 DEFAULT CHARSET=utf8; |
56 | 56 | ||
57 | 57 | ||
58 | CREATE TABLE `os_groups_invites` ( | 58 | 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 '', |
@@ -63,10 +63,10 @@ CREATE TABLE `os_groups_invites` ( | |||
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`) |
66 | ) ENGINE=MyISAM; | 66 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
67 | 67 | ||
68 | 68 | ||
69 | CREATE TABLE `os_groups_notices` ( | 69 | CREATE TABLE IF NOT EXISTS `os_groups_notices` ( |
70 | `GroupID` char(36) NOT NULL default '', | 70 | `GroupID` char(36) NOT NULL default '', |
71 | `NoticeID` char(36) NOT NULL default '', | 71 | `NoticeID` char(36) NOT NULL default '', |
72 | `TMStamp` int(10) unsigned NOT NULL default '0', | 72 | `TMStamp` int(10) unsigned NOT NULL default '0', |
@@ -81,13 +81,13 @@ CREATE TABLE `os_groups_notices` ( | |||
81 | PRIMARY KEY (`NoticeID`), | 81 | PRIMARY KEY (`NoticeID`), |
82 | KEY `GroupID` (`GroupID`), | 82 | KEY `GroupID` (`GroupID`), |
83 | KEY `TMStamp` (`TMStamp`) | 83 | KEY `TMStamp` (`TMStamp`) |
84 | ) ENGINE=MyISAM; | 84 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
85 | 85 | ||
86 | CREATE TABLE `os_groups_principals` ( | 86 | CREATE TABLE IF NOT EXISTS `os_groups_principals` ( |
87 | `PrincipalID` VARCHAR(255) NOT NULL default '', | 87 | `PrincipalID` VARCHAR(255) 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 DEFAULT CHARSET=utf8; |
91 | 91 | ||
92 | COMMIT; | 92 | COMMIT; |
93 | 93 | ||
@@ -112,4 +112,4 @@ DROP TABLE `diva_groups_principals`; | |||
112 | 112 | ||
113 | DELETE FROM `migrations` WHERE name='diva_im_Store'; | 113 | DELETE FROM `migrations` WHERE name='diva_im_Store'; |
114 | 114 | ||
115 | COMMIT; \ No newline at end of file | 115 | COMMIT; |