![]() SCHEMA - create new table hhelpdesk_step_log ( 3044604 ) SCHEMA - Enable auto-closing completed Service Requests and Work Requests ( 3044286 ) SCHEMA - Add new field to Work_team table ( 3044603 ) UPDATE afm_flds SET afm_size = 512 WHERE table_name = 'msds_h_data' AND field_name = 'url' UPDATE afm_flds SET afm_size = 512 WHERE table_name = 'msds_data' AND field_name = 'url' SCHEMA - For Bali3: MSDS data - url field length expansion needed ( 3044910 ) SCHEMA / PNAV / DATA - Changes to support Energy Management Easy On-Ramp ( 3045302 ) IF EXISTS (SELECT 1 FROM sysindex WHERE index_name='bas_data_time_norm_num_comboIndex') DROP INDEX bas_data_time_norm_num.bas_data_time_norm_num_comboIndex ĬREATE INDEX bas_data_time_norm_num_comboIndex ON bas_data_time_norm_num (date_measured, time_measured, interval) IF EXISTS (SELECT 1 FROM sysindex WHERE index_name='bas_data_clean_num_comboIndex') DROP INDEX bas_data_clean_num.bas_data_clean_num_comboIndex ĬREATE INDEX bas_data_clean_num_comboIndex ON bas_data_clean_num (date_measured, time_measured, process_status) SCHEMA - Add indexes for Energy sub-metering analytics / BAS reports ( 3045295 ) SCHEMA - Add tables and fields for BAS / sub-meter analytics features ( 3044921 ) SCHEMA - add new table for Building Operations: cf_work_team ( 3044606 ) SCHEMA - set minimum values to zero for Building Operations costs fields ( 3044373 ) UPDATE afm_flds SET num_format=4 WHERE table_name='eqstd' AND field_name='spec_depth' SET numeric_format TO length FOR standard depth SCHEMA - YDim field types do not have ft/M appended to their titles( 3044814 ) SCHEMA - add new redline document fields (survey_redline_eq) to tables eq and eq_audit ( 3044834 ) UPDATE afm_flds SET ml_heading = 'Date Manager 3 Approved' WHERE table_name = 'mo' AND field_name = 'date_app_mgr3' UPDATE afm_flds SET ml_heading = 'Date Manager 2 Approved' WHERE table_name = 'mo' AND field_name = 'date_app_mgr2' SCHEMA - Update ml_heading for fields date_app_mgr2 and date_app_mgr3 ( 3043493 ) SCHEMA - Remove the AUTOINCREMENT for pct_id in hrmpct table ( 3043869 ) SCHEMA - Adding Date Last Surveyed to the rm table ( 3044922 ) UPDATE afm_flds set max_val=9 where table_name='project' and field_name='priority' SCHEMA - Set afm_flds.max_val=9 for project.priority ( 3045515 ) SCHEMA - MS SQL - ORCL - Add missing fields for view ab-rplm-gvmnt-rp-add-new-prop.axvw. UPDATE afm_flds SET allow_null=1 WHERE table_name='ta_lease' and field_name='lessor_id' SCHEMA - Follow up KB 3043753 - allow null value for lessor_id field in ta_lease table ( 3045002 ) SCHEMA - Create new table 'ls_contacts' for lease multiple contacts ( 3044759 ) SCHEMA - Changes for Portfolio Forecast Wizard ( 3044649 ) UPDATE afm_flds SET afm_size=64 WHERE table_name='gp' AND field_name='name' ![]() SCHEMA - SCHEMA - Widen the field size of gp.name to 64( 3045365 ) SCHEMA - Add tables/fields/wfr/connector data ( 3044625 ) SCHEMA - Greek-ing metrics titles ( 3042918 ) SCHEMA - METRICS - Create archive table afm_hmetric_trend_values, in order to archive old metric values( 3043313 ) SCHEMA Add fields 'values_remove_older_than' and 'values_remove_method' to afm_metric_definition ( 3043301 ) SCHEMA - Correct the definition of view activity_log_hactivity_log( 3045021 ) SCHEMA, FILES - Create an index on afm_metric_trend_values for fields 'metric_date', 'collect_group_by' ( 3042579 ) UPDATE afm_tbls SET table_type='PROCESS NAVIGATOR' WHERE table_name in ('afm_tasks', 'afm_subtasks') UPDATE afm_tbls SET table_type='APPLICATION DICTIONARY' WHERE table_name in ('afm_bim_categories', 'afm_bim_param') SCHEMA - Table type inconsistency for ARCHIBUS tables ( 3043386 ) Version 21.3 Database Schema Revision History (Database Version 140) View your ARCHIBUS Database version by checking the ARCHIBUS Schema Preferences Since database schema versions can run with different releases of theĪRCHIBUS program, databases are tagged with an "ARCHIBUS Database You need to include only the BOMA 96 enumeration changes if you need the You can review this information if you need some newĭatabase object on which a new desired feature depends. New versions of ARCHIBUS are backward-compatible with previous schemaįormats. Using the standard ARCHIBUS schema do not need this information.Įven sites with custom schema might not need this information. So they can see if they need to migrate any changes from the released Information is provided for the benefit of users with customized schemas This topic contains the list of changes to the database schema file Database Schema Revision History Database Schema Revision History
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |