Schema changes for 9.4
Schema-level changes
New tables
-
NJAccountPlan
-
NJAccountPlanXOverview
-
NJAccountPlanEntity
-
NJAccountPlanOpportunity
-
NJAttachmentXAccountPlan
-
NJAccountPlanCov
-
NJRisk
-
NJCompetitor
-
IFInterest
-
IFVersion
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
-
NJUserField
-
NJEnumDisplay
-
NJEnumCode
Table-Level Changes:
|
Modified Table |
New Column |
Modified Column |
Renamed Column |
Removed Column |
New Index |
Renamed Index |
Dropped & Recreated Index |
Removed Index |
|
NJUserField |
userFieldTypeId |
|
|
|
UserField.FK_Type |
|
|
|
|
NJAct |
accountPlanId |
|
|
|
Act.FK_AccountPlan |
|
|
|
|
NJAct |
accountPlanModified |
|
|
|
|
|
|
|
|
NJActSeries |
accountPlanId |
|
|
|
ActSeries.FK_AccountPlan |
|
|
|
|
NJActSeries |
accountPlanModified |
|
|
|
|
|
|
|
Environment file changes for 9.4
-
The following flags were added to the Environment file:
-
rest.configMetadata
-
rest.schemaBase
-
rest.version
-
rest.defaultPageSize
-
-
Removed SQLHook "nexj.core.persistence.sql.ObjectQueueHook" from the Environment file and moved it to ObjectQueueDatabase.datasource
Data Source Connections:
|
Added |
Removed |
|
inform:Inform RelationalDatabaseConnection |
|
Channel Connections:
|
Added |
Removed |
|
inform:ArticleSearch HTTPConnection |
|
|
rest:OpenAPI HTTPConnection |
|
|
rest:REST HTTPConnection |
|
|
rest:SelectionOptions HTTPConnection |
|
|
inform:RelatedObject HTTPConnection |
|
Mixins:
|
Added |
Removed |
Updated minimum version |
|
nexj:model:restapi |
|
|
|
nexj:model:inform |
|
|
|
|
|
nexj:model:afl |
|
|
|
nexj:model:afl-mda |
|
|
|
nexj:model:portal |
Schema changes for 9.3
Schema-level changes
New tables
-
RPTOrderBy (included as of 9.2.2.0)
-
RPTExecutedFiles (included as of 9.2.2.0)
-
RPTEmailTarget (included as of 9.2.2.0)
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
-
NJEnumDisplay
-
NJProcess
-
RPTRecalculate (included as of 9.2.2.0)
Table-Level Changes:
|
Modified Table |
New Column |
Modified Column |
Renamed Column |
Removed Column |
New Index |
Renamed Index |
Dropped & Recreated Index |
Removed Index |
|
RPTCalculatedValue (modified as of 9.2.2.0) |
|
field |
|
|
|
|
|
|
|
RPTGroupBy (modified as of 9.2.2.0) |
|
field |
|
|
|
|
|
|
|
RPTDashboardItem (modified as of 9.2.2.0) |
caption |
|
|
|
|
|
|
|
|
RPTDashbaordItem (modified as of 9.2.2.0) |
description |
|
|
|
|
|
|
|
|
RPTFile (modified as of 9.2.2.0) |
executedReport |
|
|
|
File.FK_ExecReport |
|
|
|
|
RPTFile (modified as of 9.2.2.0) |
createTime |
|
|
|
|
|
|
|
|
RPTFile (modified as of 9.2.2.0) |
executedFiles |
|
|
|
File.FK_ExeFile |
|
|
|
|
RPTFile (modified as of 9.2.2.0) |
|
mimeType |
|
|
|
|
|
|
|
RPTFileName (modified as of 9.2.2.0) |
|
|
|
|
|
|
|
FileName.UNIQ |
|
RPTScheduledReport (modified as of 9.2.2.0) |
executedTime |
|
|
|
|
|
|
|
Environment file changes for 9.3
-
Added theme flag to Environment (to specify UI theme to load).
Channel Connections:
|
Added |
Removed |
|
ExchangeEWSSender6 HTTPConnection |
|
Mixins:
|
Added |
Removed |
Updated minimum version |
|
|
|
nexj:model:afl |
|
|
|
nexj:model:afl-mda |
|
|
|
nexj:model:portal |