aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/scripts/group_migrate.sql
diff options
context:
space:
mode:
authorDavid Walter Seikel2016-11-28 00:03:49 +1000
committerDavid Walter Seikel2016-11-28 00:03:49 +1000
commitb52915c316819a26021c9ac3f1dcafe5abb84a98 (patch)
tree966fd13f1a6b61a4b5c2ae21c2c6edf69cb03d74 /scripts/group_migrate.sql
parentNew script for backing up everything. (diff)
downloadopensim-SC_OLD-b52915c316819a26021c9ac3f1dcafe5abb84a98.zip
opensim-SC_OLD-b52915c316819a26021c9ac3f1dcafe5abb84a98.tar.gz
opensim-SC_OLD-b52915c316819a26021c9ac3f1dcafe5abb84a98.tar.bz2
opensim-SC_OLD-b52915c316819a26021c9ac3f1dcafe5abb84a98.tar.xz
Script for migrating groups to the built in core version.
Diffstat (limited to 'scripts/group_migrate.sql')
-rw-r--r--scripts/group_migrate.sql48
1 files changed, 48 insertions, 0 deletions
diff --git a/scripts/group_migrate.sql b/scripts/group_migrate.sql
new file mode 100644
index 0000000..6c15011
--- /dev/null
+++ b/scripts/group_migrate.sql
@@ -0,0 +1,48 @@
1INSERT INTO `griddy`.`os_groups_groups`
2(GroupID, Name, Charter, InsigniaID, FounderID, MembershipFee, OpenEnrollment, ShowInList,
3AllowPublish, MaturePublish, OwnerRoleID)
4SELECT GroupID, Name, Charter, InsigniaID, FounderID, MemberShipFee, OpenEnrollment, ShowInList, AllowPublish,
5MaturePublish, OwnerRoleID
6FROM `griddy`.osgroup;
7
8/*fill os_groups_invites in ROBUST database with values from osgroupinvite
9or FlotSam osgroupinvite*/
10INSERT INTO `griddy`.`os_groups_invites`
11(InviteID, GroupID, RoleID, PrincipalID, TMStamp)
12SELECT InviteID, GroupID, RoleID, AgentID, TMStamp
13FROM `griddy`.osgroupinvite;
14
15/*fill os_groups_membership in ROBUST database with values from osgroupmembership
16or FlotSam osgroupmembership*/
17INSERT INTO `griddy`.`os_groups_membership`
18(GroupID, PrincipalID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices)
19SELECT GroupID, AgentID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices
20FROM `griddy`.osgroupmembership;
21
22/*fill os_groups_notices in ROBUST database with values from osgroupnotice
23or FlotSam osgroupnotice*/
24INSERT INTO `griddy`.`os_groups_notices`
25(GroupID, NoticeID, TMStamp, FromName, Subject, Message)
26SELECT GroupID, NoticeID, Timestamp, FromName, Subject, Message
27FROM `griddy`.osgroupnotice;
28
29/*fill os_groups_principals in ROBUST database with values from osagent
30or FlotSam osagent*/
31INSERT INTO `griddy`.`os_groups_principals`
32(PrincipalID, ActiveGroupID)
33SELECT AgentID, ActiveGroupID
34FROM `griddy`.osagent;
35
36/*fill os_groups_rolemembership in ROBUST database with values from osrolemembership
37or FlotSam osgrouprolemembership*/
38INSERT INTO `griddy`.os_groups_rolemembership
39(GroupID, RoleID, PrincipalID)
40SELECT GroupID, RoleID, AgentID
41FROM `griddy`.osgrouprolemembership;
42
43/*fill os_groups_roles in ROBUST database with values from osroles
44or FlotSam osrole*/
45INSERT INTO `griddy`.os_groups_roles
46(GroupID, RoleID, Name, Description, Title, Powers)
47SELECT GroupID, RoleID, Name, Description, Title, Powers
48FROM `griddy`.osrole;