Database Schema Revision History V2025.01
The /webapp/projects/users/public/dt/v2024.04.002/schema/update-schema.duw makes these updates:
-
AD-19796 : Recreate SQL views.
The /webapp/projects/users/public/dt/v2025.01.001/schema-template/bldgops/update-schema-template.duw makes these updates:
-
AD-19953 : Performance Improvement - Set activity parameter AbBldgOpsOnDemandWork - BldgOpsConsoleExpandOnOpen to 0 by default
The /webapp/projects/users/public/dt/v2025.01.001/schema-template/metrics/update-schema-template.duw makes these updates:
-
AD-20605 : Use full field name in where clause of eam metrics
The /webapp/projects/users/public/dt/v2025.01.001/schema-template/system/update-schema-template.duw makes these updates:
-
AD-19797 : Import missing currency symbols into dbt and jp databases
The /webapp/projects/users/public/dt/v2025.01.001/schema/bldgops/update-schema.duw makes these updates:
-
AD-17546 : Add priority attribute in notification
The /webapp/projects/users/public/dt/v2025.01.001/schema/maintenance/update-schema.duw makes these updates:
-
AD-19966 : Add new field question_ext.show_previous_values
The /webapp/projects/users/public/dt/v2025.01.001/schema/reservations/update-schema.duw makes these updates:
-
AD-16833 : Enlarge reservation_name from 64 to 255 characters
-
AD-16922 : Add specific messages to notify organizer when a recurring reservation is cancelled
The /webapp/projects/users/public/dt/v2025.01.001/schema/system/update-schema.duw makes these updates:
-
AD-19695 : Add a new activity parameter AbSystemAdministration-AwarenessMessage used for displaying a message on the log in screen
-
AD-20417 : Add the AbWorkplaceIntelligentBookings application and associate it with the AbWorkplaceServices domain
-
AD-20549 : Add the Intelligent Bookings parameters for activating the creation of booking recommendations and their usage
-
AD-20555 : Make vpa_rest.role_name to be not validated so it can hold the special VPA ALL OTHER ROLES value
-
AD-19945 : Additional indexes for maintenance console performance