aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/scripts
diff options
context:
space:
mode:
Diffstat (limited to 'scripts')
-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;