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 |