Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2023.02

  1. Last updated
  2. Save as PDF

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

Sample Data

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

  • AD-13059 : reverse some onsite sample dates to make more sense relative to DateSampleDatesLastUpdated

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

  • AD-12943 : Add sample asset families from Revit Families

  • AD-12943 : Add sample asset standard attributes

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

  • *AD-13058 : reverse some bldgops sample dates to make more sense relative to DateSampleDatesLastUpdated

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

  • AD-12791 : reverse some onsite sample dates to make more sense relative to DateSampleDatesLastUpdated

  • ${import.file('%publicDataTransferDirectory%\v2023.02.001\sample-data\onsite\ad_12791_wrcf.csv')};

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

  • AD-12791 : advance sample data dates

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

  • AD-13452 : 10 team start dates are still in the future.

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

  • AD-13320 : Add sample data for eqstd attributes

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

  • AD-12603 : fix onsite sample data dates

  • AD-12708 : Roll-back changes to IoT space data

  • AD-12690 : roll back additional dates for OnSite demonstrations.

Application Parameters

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

  • AD-13510 : Add activity parameters for OnSite mobile data input

  • AD-13511 : Add activity parameters for OnSite config

  • AD-13512 : Add activity parameters for OnSite config

Reservations

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

  • AD-12335 : new activity params to support external meeting requestors in Exchange

  • AD-12440 : new customizable warning message for the Outlook Plugin

  • AD-13451 : add task and workflow rule for google calendar integration

Space

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

  • AD-13126 : add new fields to iot_space_util

Assets

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

  • AD-12912 : Add Define Asset Standards task to Cloud Assets navigator

  • AD-12941 : Add Asset Families form to the Navigator

OnSite

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

  • AD-12692 : support configuration of timers for OnSite

Solutions

The /webapp/projects/users/public/dt/v2023.02.001/schema/solutions/update-schema.du w makes these updates:

  • AD-12561 : Change title for table iot_space_util

  • AD-7901 : Set Archibus Type to None for field bms_analysis_id in table bms_analysis_config

  • AD-13303 : Add new application AbIntegrationIoT, used for licensing the integration with Vergesense

System

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

  • AD-12496 : make all lat/lon fields precision 16.

  • AD-12866 : remove edit security group from wr_sync.step_user_name