Grouper upgrade tasks

1

Add missing self group sets For groups

N

N

2.5.1

v4+

Yes

2

Move subject resolution status attributes to member table (GRP-2841)

N

N

2.5.30

v4+

No

3

Refactor group recent memberships (GRP-2874)

N

N

2.5.30

v4+

No

4

Reconfigure recent memberships (GRP-2893)

N

N

2.5.32

v4+

No

5

Change inherited privs to act as GrouperSystem (GRP-2926)

N

N

2.5.36

v4+

No

6

Add missing self group sets for stems

N

N

2.6.6

v4+

No

7

Store folderUuidToShow in db for grouper gsh templates

N

N

2.6.8

v4+

No

8

Set grouper_members id_index column to non nullable (GRP-4332)

Y

N

2.6.16

v4+

No

9

Make permissions limits not public (GRP-4633)

N

N

4.1.0

v4+

No

10

Add indexes to grouper loader logs (GRP-5195)

Y

N

4.10.0

v4+

No

11

Create grouper sync dependency table (GRP-5302)

Y

N

4.10.4

v4+

No

12

Create provisioning SCIM loader tables (GRP-5514)

Y

N

4.14.0

v4+

No

13

Create provisioning azure loader table (GRP-5625)

Y

N

4.15.0

v4+

No

14

Create provisioning adobe loader table

Y

N

4.16.0

v4+

No

15

Moved some DDL from v45/v46 sql script files which included: (GRP-4759)

• Add internal_id to members table along with index

• Add internal_id to fields table along with index

• Add internal_id to groups table along with index

• Create grouper_sql_cache_group table along with index

• Create grouper_sql_cache_mship table along with indexes

• Add source_internal_id to pit members table along with index

• Add source_internal_id to pit fields table along with index

• Add source_internal_id to pit groups table along with index

• Create grouper_sql_cache_group_v view

Populate internal id on groups and fields tables and make not null

For Oracle, add a few constraints to grouper_fields, grouper_groups and grouper_sql_cache_group

Y

N

5.8.0

v5+

Yes

16

Make grouper members internal id not null

Y

N

5.8.0

v5+

Yes

17

Update point in time internal id where null (GRP-4799)

Y

N

5.8.2

v5+

Yes

18

Remove group sync job (GRP-5346)

N

N

5.8.5

v5+

No

19

Remove grouper report job (GRP-5331)

N

N

5.11.0

v5+

No

20

Remove maintenance jobs (GRP-5315 | GRP-5316 | GRP-5321 | GRP-5322)

N

N

5.12.0

v5+

No

21

Refactor sql group cache and membership table (GRP-5717)

Y

N

5.13.0

v5+

No

22

Add id index to point in time stem and attribute def tables (GRP-5717)

Y

N

5.13.0

v5+

No

23

Delete sql cacheable attributes (GRP-5737)

N

N

5.13.1

v5+

No

24

Convert membership cache timestamp to number (GRP-5781)

Y

N

5.14.0

v5+

Yes

25

Create or recreate membership history cache table (GRP-5792)

Y

N

5.14.0

v5+

No

26

None, skipped

N

N

v5+

No

27

Add functions to convert millis/micros from epoch to timestamp (GRP-5822 | GRP-6010)

Y

N

5.14.0

5.17.0 (Oracle)

v5+

No

28

Add DDL for sql cache dependency tables (GRP-5822)

Y

N

5.14.0

v5+

No

29

Add index grouper_sync_mship_mem_idx (GRP-5877)

Y

N

4.17.0

v4+

No

30

Add history tables for data fields (GRP-5972)

Y

N

5.15.5

v5+

No

31

Update tables for data fields (GRP-6032)

Y

N

5.17.0

v5+

No

32

Add views grouper_sql_dependency_group_v,
grouper_sql_dependency_row_v,
grouper_sql_dependency_attr_v (GRP-6175)

Y

N

5.18.0

5.18.2 (Oracle)

v5+

No

33

Adds dependencies for sql cache full sync to run in v4

Y

Y

4.19.0

v4 only

No

34

Run sql cache full sync (GRP-6285)

N

N

5.20.1

v5+

Yes

35

Added indexes fld_assgn_mem_df_dict_idx and dtrwfldasg_df_dict_dra_idx (GRP-6329)

Y

N

5.21.1

v5+

No

36

grouper_prov_duo_user primary key should be (user_id, config_id), not just user_name (GRP-6468)

Y

N

6.0.0

v4+

No

37

Tables: grouper_lifecycle_event, grouper_lifecycle_event_config (GRP-6541)
Constraint for oracle: grouper_stems_id_index_unq

Y

N

6.0.0

v7+

No

38

Tables: grouper_oauth_client, grouper_oauth_code, grouper_oauth_pend_authz_req, grouper_mcp_tool_log

Y

N

v7+

No

39

Comments on tables: grouper_lifecycle_event_config, grouper_lifecycle_event

Add indexes: fld_assgn_field_dict_idx, fld_assgn_field_int_idx

Y

N

6.2.0, 7.1.0

v6+

No

40

Redo index grouper_duo_user_user_name_idx (non unique), and add index: group_set_member_member_field_idx

Y

N

4.23.0, 6.2.0, 7.1.0

v4+

No

41

Add generic grouper prov tables to store target data

Y

N

7.2.0

v7+

Yes

42

Drop unnecessary indexes on grouper_change_log_entry_temp

Y

N

7.2.0

v7+

No

43

Widen grouper_members.subject_identifier0

Add primary key grouper_stem_view_privilege.grouper_stem_v_priv_pk

Y

N

7.3.0

v7+

No

44

Encrypt the OAuth JWT signing private key at rest in database config

N

N

7.4.0

v7+

No

45

grouper_file.file_contents_clob: Postgres varchar(10000000) to text, MySQL mediumtext to longtext (GRP-7417)
Add grouper_file.created_on_micros and updated_on_micros (GRP-7439)
Add grouper_file.file_contents_blob for binary files (GRP-7446)
Zoom: grouper_prov_zoom_user.id nullable, grouper_zoom_user_id_idx non-unique (GRP-7445)
Widen grouper_failsafe.name to varchar(512) (GRP-6303)
Fix data_row_internal_id in grouper_data_row_field_asgn_v and grouper_data_row_assign_v (GRP-6677)

Y

N

7.7.0

v7+

No

46

AI assistant in the Grouper UI:

• Add grouper_mcp_tool_log.entry_path (whether a tool call came from an MCP client or the UI)

• Tables: grouper_ai_agent_usage (usage per user per day), grouper_ai_agent_call_log (one row per call to the AI provider)

Y

N

7.8.0

v7+

No