Changes to the data model for Oracle

Tables

The following tables were modified:
  • EVENT
    • DATA column changed to INLINE
    • ATTEMPT_COUNT column was added
    • PUBLISHED column was added
    • PUBLISH_REQ_TIME column was added
    • PUBLISH_ATTEMPT_COUNT column was added
  • TRANSMISSION_BASE/H_TRANSMISSION_BASE
    • IDEMPOTENT_KEY column was added
  • FSM
    • OBJ_SELECT_TEMPLAT column size changed from 1000 to 2000
  • FSM_TRANSITION
    • OVERRIDE_SELECTION column size changed from 1000 to 2000
  • OBJ_VALUE
    • KEY column size changed from 40 to 100
  • EXT_PUB_RULE
    • ISOLATION column was added

Views

The following views were modified to add the IDEMPOTENT_KEY column:
  • TRANSMISSION_V
  • TRANSMISSION_BASE_V
  • TRANSMISSION_V_UPD

Triggers

The following triggers were modified to add the IDEMPOTENT_KEY column:
  • TRANSMISSION_V_INS
  • TRANSMISSION_V_UPD
  • TRANS_BASE_V_INS
  • TRANS_BASE_V_UPD

Stored procedures

The following stored procedures were modified:
  • UPSERT_OBJ_VALUE key parameter length changed from 40 to 100

Indexes

The following indexes were added:
  • New EVT_PUB_IDX index on the EVENT table