diff options
Diffstat (limited to 'scripts')
-rw-r--r-- | scripts/group_migrate.sql | 48 |
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 @@ | |||
1 | INSERT INTO `griddy`.`os_groups_groups` | ||
2 | (GroupID, Name, Charter, InsigniaID, FounderID, MembershipFee, OpenEnrollment, ShowInList, | ||
3 | AllowPublish, MaturePublish, OwnerRoleID) | ||
4 | SELECT GroupID, Name, Charter, InsigniaID, FounderID, MemberShipFee, OpenEnrollment, ShowInList, AllowPublish, | ||
5 | MaturePublish, OwnerRoleID | ||
6 | FROM `griddy`.osgroup; | ||
7 | |||
8 | /*fill os_groups_invites in ROBUST database with values from osgroupinvite | ||
9 | or FlotSam osgroupinvite*/ | ||
10 | INSERT INTO `griddy`.`os_groups_invites` | ||
11 | (InviteID, GroupID, RoleID, PrincipalID, TMStamp) | ||
12 | SELECT InviteID, GroupID, RoleID, AgentID, TMStamp | ||
13 | FROM `griddy`.osgroupinvite; | ||
14 | |||
15 | /*fill os_groups_membership in ROBUST database with values from osgroupmembership | ||
16 | or FlotSam osgroupmembership*/ | ||
17 | INSERT INTO `griddy`.`os_groups_membership` | ||
18 | (GroupID, PrincipalID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices) | ||
19 | SELECT GroupID, AgentID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices | ||
20 | FROM `griddy`.osgroupmembership; | ||
21 | |||
22 | /*fill os_groups_notices in ROBUST database with values from osgroupnotice | ||
23 | or FlotSam osgroupnotice*/ | ||
24 | INSERT INTO `griddy`.`os_groups_notices` | ||
25 | (GroupID, NoticeID, TMStamp, FromName, Subject, Message) | ||
26 | SELECT GroupID, NoticeID, Timestamp, FromName, Subject, Message | ||
27 | FROM `griddy`.osgroupnotice; | ||
28 | |||
29 | /*fill os_groups_principals in ROBUST database with values from osagent | ||
30 | or FlotSam osagent*/ | ||
31 | INSERT INTO `griddy`.`os_groups_principals` | ||
32 | (PrincipalID, ActiveGroupID) | ||
33 | SELECT AgentID, ActiveGroupID | ||
34 | FROM `griddy`.osagent; | ||
35 | |||
36 | /*fill os_groups_rolemembership in ROBUST database with values from osrolemembership | ||
37 | or FlotSam osgrouprolemembership*/ | ||
38 | INSERT INTO `griddy`.os_groups_rolemembership | ||
39 | (GroupID, RoleID, PrincipalID) | ||
40 | SELECT GroupID, RoleID, AgentID | ||
41 | FROM `griddy`.osgrouprolemembership; | ||
42 | |||
43 | /*fill os_groups_roles in ROBUST database with values from osroles | ||
44 | or FlotSam osrole*/ | ||
45 | INSERT INTO `griddy`.os_groups_roles | ||
46 | (GroupID, RoleID, Name, Description, Title, Powers) | ||
47 | SELECT GroupID, RoleID, Name, Description, Title, Powers | ||
48 | FROM `griddy`.osrole; | ||