Database Schema Revision History V.2024.04

Version 2024.04 Database Schema Revision History

The /webapp/projects/users/public/dt/v2024.04.001/deployment-scripts/generatePassword/generate-password.duw makes these updates:

• AD-18334 : Added deployment script to generate random passwords for sample users in demo environments.

The /webapp/projects/users/public/dt/v2024.04.001/schema/app-space/update-schema.duw makes these updates:

• AD-19040, AD-19381 : Add new field rm_team.days_in_office to log the week days when the team occupies the room

The /webapp/projects/users/public/dt/v2024.04.001/schema/app-workplace/update-schema.duw makes these updates:

• AD-18981 : Add AbSpaceHotelling-HotellingService wfr to support workplace app

The /webapp/projects/users/public/dt/v2024.04.001/schema/system/update-schema.duw makes these updates:

• AD-19398 : Limit access to AbSystemAdministration-getWorkflowRuleRecord(s) workflow rules to "SYSTEM MGR" group

• AD-19398 : Add VPA restriction on afm_wf_rules table for role GUEST

• AD-18144 : Make all lat/lon fields precision 8.

• AD-19274 : Alter afm_connector for column ftp_password to increase the size from 64 to 128.

The /webapp/projects/users/public/dt/finalize-db.duw makes these updates:

• AD-19390 : Ensure reserve.rm_calendar_item_id remains case sensitive for compatibility with MS Exchange.