aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/os_groups_Store.migrations
blob: 6ec89144b551a238da93b459ca76bec6018c59f9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
:VERSION 1         # -------------------------- 

BEGIN;

CREATE TABLE `os_groups_groups` (
  `GroupID` char(36) NOT NULL default '',
  `Location` varchar(255) NOT NULL default '',
  `Name` varchar(255) NOT NULL default '',
  `Charter` text NOT NULL,
  `InsigniaID` char(36) NOT NULL default '',
  `FounderID` char(36) NOT NULL default '',
  `MembershipFee` int(11) NOT NULL default '0',
  `OpenEnrollment` varchar(255) NOT NULL default '',
  `ShowInList` int(4) NOT NULL default '0',
  `AllowPublish` int(4) NOT NULL default '0',
  `MaturePublish` int(4) NOT NULL default '0',
  `OwnerRoleID` char(36) NOT NULL default '',
  PRIMARY KEY  (`GroupID`),
  UNIQUE KEY `Name` (`Name`),
  FULLTEXT KEY `Name_2` (`Name`)
) ENGINE=MyISAM;


CREATE TABLE `os_groups_membership` (
  `GroupID`char(36) NOT NULL default '',
  `PrincipalID` VARCHAR(255) NOT NULL default '',
  `SelectedRoleID` char(36) NOT NULL default '',
  `Contribution` int(11) NOT NULL default '0',
  `ListInProfile` int(4) NOT NULL default '1',
  `AcceptNotices` int(4) NOT NULL default '1',
  `AccessToken` char(36) NOT NULL default '',
  PRIMARY KEY  (`GroupID`,`PrincipalID`),
  KEY `PrincipalID` (`PrincipalID`)
) ENGINE=InnoDB;


CREATE TABLE `os_groups_roles` (
  `GroupID` char(36) NOT NULL default '',
  `RoleID` char(36) NOT NULL default '',
  `Name` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `Title` varchar(255) NOT NULL default '',
  `Powers` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`GroupID`,`RoleID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB;


CREATE TABLE `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;


CREATE TABLE `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 '',
  `TMStamp` timestamp NOT NULL,
  PRIMARY KEY  (`InviteID`),
  UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
) ENGINE=InnoDB;


CREATE TABLE `os_groups_notices` (
  `GroupID` char(36) NOT NULL default '',
  `NoticeID` char(36) NOT NULL default '',
  `TMStamp` int(10) unsigned NOT NULL default '0',
  `FromName` varchar(255) NOT NULL default '',
  `Subject` varchar(255) NOT NULL default '',
  `Message` text NOT NULL,
  `HasAttachment` int(4) NOT NULL default '0',
  `AttachmentType` int(4) NOT NULL default '0',
  `AttachmentName` varchar(128) NOT NULL default '',
  `AttachmentItemID` char(36) NOT NULL default '',
  `AttachmentOwnerID` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`NoticeID`),
  KEY  `GroupID` (`GroupID`),
  KEY `TMStamp` (`TMStamp`)
) ENGINE=InnoDB;

CREATE TABLE `os_groups_principals` (
  `PrincipalID` VARCHAR(255) NOT NULL default '',
  `ActiveGroupID` char(36) NOT NULL default '',
  PRIMARY KEY  (`PrincipalID`)
) ENGINE=InnoDB;

COMMIT;

:VERSION 2         # -------------------------- 

BEGIN;

INSERT INTO `os_groups_groups` SELECT * from `diva_groups_groups`;
DROP TABLE `diva_groups_groups`;
INSERT INTO `os_groups_membership` SELECT * from `diva_groups_membership`;
DROP TABLE `diva_groups_membership`;
INSERT INTO `os_groups_roles` SELECT * from `diva_groups_roles`;
DROP TABLE `diva_groups_roles`;
INSERT INTO `os_groups_rolemembership` SELECT * from `diva_groups_rolemembership`;
DROP TABLE `diva_groups_rolemembership`;
INSERT INTO `os_groups_invites` SELECT * from `diva_groups_invites`;
DROP TABLE `diva_groups_invites`;
INSERT INTO `os_groups_notices` SELECT * from `diva_groups_notices`;
DROP TABLE `diva_groups_notices`;
INSERT INTO `os_groups_principals` SELECT * from `diva_groups_principals`;
DROP TABLE `diva_groups_principals`;

DELETE FROM `migrations` WHERE name='diva_im_Store';

COMMIT;