Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2022.01

  1. Last updated
  2. Save as PDF

For details on the exact changes for the V.2022.01 database, see the following files:

Localization

These files update the translation of new strings:

  • /webapp/projects/users/public/dt/v2022.01.001/translation/update-translation-doublebyte.duw

  • /webapp/projects/users/public/dt/v2022.01.001/translation/update-translation-singlebyte.duw

Sample Data

The /webapp/projects/users/public/dt/v2022.01.001/sample-data/app-eam/update-sample-data.duw makes these updates:

  • AD-7973 : Correct sample equipment without status. All sample equipment must have a status.

The / webapp/projects/users/public/dt/v2022.01.001/sample-data/app-workplace/update-sample-data.duw makes these updates:

  • AD-8100 : Set back from 50% to 100% the Occupancy Target for the building NC05 - was incoherent with the floor capacity targets

The /webapp/projects/users/public/dt/v2022.01.001/sample-data/onsite/update-sample-data.duw makes these updates:

  • AD-7633 : Fix some conflict hours in wrcf records

  • AD-8013 : Add SLA data for OnSite testing

  • AD-8128 : Set WILL Technician's cf.cf_change_wr value to 1

The /webapp/projects/users/public/dt/v2022.01.001/sample-data/reports/update-sample-data.duw makes these updates:

  • AD-7453 : Sample Reports Central reports for BMS equipment diagnostics

The /webapp/projects/users/public/dt/v2022.01.001/sample-data/system/update-sample-data.duw makes these updates:

  • AD-8027 : Set units to imperial in HQ database

Schema - Schema Template

The Schema Template holds changes to the schema database that do not necessarily apply to an upgrade. This includes changes that could overwrite production data. The schema template is a distinction between the use of scripts as documentation of changes to schema as a template, and a method to upgrade a database.

The /webapp/projects/users/public/dt/v2022.01.001/schema-template/system/update-schema-template.duw makes these updates:

  • AD-7896 : assign edit security group to afm_connector and afm_conn_flds fields.

  • AD-7842 : assign edit security group to afm_roleprocs and afm_userprocs

The / webapp/projects/users/public/dt/v2022.01.001/schema-template/pnav/update-schema-template.duw makes these updates:

  • AD-7345 : Align applications home page for SaaS with navigator

Schema - Application Parameters

The / webapp/projects/users/public/dt/v2022.01.001/schema/app-reservations/update-schema.duw makes these updates:

  • AD-6442 : Add activity parameter for panel booking

The /webapp/projects/users/public/dt/v2022.01.001/schema/update-schema.duw makes these updates:

  • AD-6443 : Reservations - Activity parameter for panel bookings

The / webapp/projects/users/public/dt/v2022.01.001/schema/activity-params/update-schema.duw makes these updates:

  • AD-7986 : Create application parameter to enable WFR parameter encryption

  • AD-7345 : Add application parameters for push notifications feature

  • AD-7233 : Update application parameter to allow multiple bookings

Schema - Hoteling

The /webapp/projects/users/public/dt/v2022.01.001/schema/app-hoteling/update-schema.duw makes these updates:

  • AD-7547 : Hoteling - Move the email notifications texts for bookings into the messages table

  • AD-7721 : Hoteling - Add ptask for new report : Bookings and Reservations

Schema - Solutions

The /webapp/projects/users/public/dt/v2022.01.001/schema/app-solutions/update-schema.duw makes these updates:

  • AD-8014 : Temporarily, de-activate the Forge Integration for v2022.01

  • AD-6088 : Update task file name for View Equipment Diagnostics History to point to new file

  • AD-7385 : POC - BMS - Fix field definition for Cost Savings

Schema - Workplace

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

  • AD-4480 : Workplace - External links for Service Requests

Schema - Maintenance

The / webapp/projects/users/public/dt/v2022.01.001/schema/bldgops/update-schema.duw makes these updates:

  • AD-7489, AD-7987 : WR Details : Display document name in the Activity section instead of file name

  • AD-7782 : Make "Estimate" action configurable.

Schema - OnSite

The /webapp/projects/users/public/dt/v2022.01.001/schema/onsite/connect/update-schema.duw makes these updates:

  • AD-7331 : Move connect background sync classes to com.archibus.connect package.

  • AD-7344, AD-7343, AD-7573, AD-7575, AD-7836, AD-7873 : Add gros, helpdesk_sla_priority, rmtype and rmcat to connect background sync. Remove UUID lookup for non-validated fields. Add missing uuid export for afm_enterprise_graphics. Add afm_last_uuid to track last used uuid per table.

  • AD-7835 : Set decimals on connect staging tables

  • AD-7869 : Set fields on staging tables to be nullable and have no default value, as deletions have to field values

  • AD-8030 : Do not sync curr_% location fields, and don't validate them in general.

  • AD-7873 : New afm_last_uuid table.

  • AD-8085 : Reconcile fields in export queries, connectors, and staging tables

Schema - System

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

  • AD-7698 : Increase all file names to variable length and 255 characters

  • AD-7698 : Add FORGE filetype to enterprise graphics table

  • AD-7930 : Give afm_secure access to afm_password_token

  • AD-7895 : Cost per area should not have a "."

  • AD-6562 : Add indexes to rmpct for amenities search