Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2023.01

  1. Last updated
  2. Save as PDF

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

Sample Data

The /webapp/projects/users/public/dt/v2023.01.002/sample-data/app-common/update-sample-data.duw makes these updates:

  • AD-12535: De-activate all metrics on sample database to avoid collecting un-needed values

  • AD-12535: Delete metric values that are not sample data and affect home pages

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

  • AD-12351: Populate site_id for equipment in buildings MC10, NB with missing site_id value

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

  • AD-11346 : Archibus Healthcare v1 sample data

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

  • ON-1730 : OnSite sample data work logs should set is_work_log = 1

  • AD-12332 : OnSite. Add Checklist sample data for demo

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

  • AD-12320 : Advance sample data dates

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/v2023.01.002/schema-template/update-schema-template.duw makes these updates:

  • AD-12514 : Remove trailing characters from cost category

  • AD-12401 : Decrease max document size for building photos

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

  • AD-11714: Revert previous activity parameter value of AbCommonResources-MobileSyncDataChangesOnlyTables

  • AD-11857 : Delete the application parameter from the database AbOnSiteMobile-MaxRequestsToDownloadForOfflineUse

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

  • AD-11704 : Remove solutions activities from schema database

OnSite

The /webapp/projects/users/public/dt/v2023.01.001/deployment-scripts/onsite/onsite-deployment.duw makes these updates:

  • AD-7317 : Add deployment scripts for OnSite to copy note from wr/hwr to helpdesk step log

The /webapp/projects/users/public/dt/v2023.01.002/deployment-scripts/onsite/onsite-deployment.duw makes these updates:

  • AD-7317 : Add deployment scripts for OnSite to copy note from wr/hwr to helpdesk step log

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

  • AD-11714 : Add new OnSite activity parameter AbOnSiteMobile-OnSiteSyncDataChangesOnlyTables

  • AD-12106 : Add new Offline Support application parameters for conflict resolution

The /webapp/projects/users/public/dt/v2023.01.002/schema/onsite/update-schema.duw makes these updates:

  • AD-12333 : Remove MaxRequestsToDownloadForOfflineUse application parameter

  • AD-12540 : Fix meaning of 1 and 0 in description of OfflineSyncActiveWR% parameters.

Assets

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

  • AD-12031 : Increase size for asset attributes fields

  • AD-11719 : New asset tables

  • AD-11945 : Updates to assets hierarchy, import asset classes, migrate BIM Families into the new Asset Families table

Real Estate

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

  • AD-7648 Add group for lease delete

Space

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

  • AD-12131 Vergesense API collect data WFR

Workplace

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

  • AD-11848 : Show building name on calendar cards

  • AD-11992 : New Wayfinding application

Healthcare

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

  • AD-11346 : ARCHIBUS Healthcare v1

System

The /webapp/projects/users/public/dt/v2023.01.002/schema/pnav/update-schema.duw makes these updates:

  • AD-12349 : remove livecycle pdf examples due to product end of life

The /webapp/projects/users/public/dt/v2023.01.002/schema/sys-admin/update-schema.duw makes these updates:

  • * AD-11114 : Add workflow rule for parsing AXVW file restriction

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

  • AD-12035 : update Title for Navigator tables that are used only by Archibus Client/Server

Localization

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

  • Double-byte databases now only update translations for double-byte languages. The alllangs folder is available to import translations for all languages.