Sales
Denmark +45 7944 7000
Europe +45 7944 7000
North America +1 (202)-536-4165
Support
Denmark +45 7944 7002
North America +1 (202)-536-4165

Detailed Changes of Resource Central Database Version 4.3.0003.0003 (RC4.3 RTM)

Modified on Thu, 22 Aug at 11:17 PM

Overview

This article outlines the changes of the Database structure version 4.3.0003.0003 (RC4.3 RTM) compared to version 4.2.00029.0012 (RC4.2 SR3). The content below describes the addition and removal of tables and columns in any table, as well as the modification to the tables/columns.


Impact on existing Insights report

If you have made changes to the standard pages delivered with Insights or if you have created new pages, you need to check the listed changes to the data structure. If any of these changes has an impact on your own pages or your changes to the standard pages, you need to redo these changes to get them to apply to the new data structure.

If none of the changes have any impact on the customized pages, you can remain on the already installed version, and no updates are necessary.

Pay attention to any deleted tables or columns, if you are using any of them in your customizations, you need to upgrade.


Detailed changes

  • Deleted tables/columns

RelationsAssignments (table)


  • Added tables/columns

ExAuthProtocols

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
EnabledRBAC
New
BIT
NULL
Add new column for RBAC feature
RemoveRBACUser
New
INT
NULL
Add new column for RBAC feature

Items

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
SalesPriceInternally
New
REAL
NULL

SalesPriceExternally
New
REAL
NULL

IsInternalAvailable
New
BIT
NULL

IsExternalAvailable
New
BIT
NULL

IsFlexiblePricing
New
BIT
NULL

IsUseAlternativeText
New
BIT
NULL

EnableExtendedDeadline
New
BIT
NULL

WorkDayExtendedDeadline
New
INT
NULL

TimeExtendedDeadline
New
DATETIME
NULL

QuantityThreshold
New
INT
NULL

MessageLog

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
CreatedName
New
NVARCHAR
NULL
Add column to store Name of persons who edit order in the back-end

 OrderLines

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
MinQuantityThreshold
New
INT
NULL

IsUsingExtendedDeadline
New
BIT
NULL

TimeExtendedDealine
New
DATETIME
NULL

Orders

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
IsBigEvent
New
BIT
NULL

Persons

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
RBACUser
New
BIT
NULL

LastActive
New
DATETIME
NULL

PropertyTypes

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
IsInternalAvailable
New
BIT
NULL

IsExternalAvailable
New
BIT
NULL

RC_OrderLines_Temp

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
MinQuantityThreshold
New
INT
NULL

IsUsingExtendedDeadline
New
BIT
NULL

TimeExtendedDealine
New
DATETIME
NULL

RC_Orders_Temp

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
IsBigEvent
New
BIT
NULL

Reservations

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
IsSentReminderMail
New
BIT
NOT NULL

Resources

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
HTMLIdExternal
New
INT
NULL

DisplayAttendeesSectionExternal
New
TINYINT
NULL

Roles

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
EnableRBAC
New
BIT
NULL

RBACRole
New
NVARCHAR
NULL

ScreenConfiguration

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
PersonId
New
INT
NOT NULL

TableKeys

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
Id
New
INT
NOT NULL

OrderLinesEditable (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
Id
New
INT
NOT NULL

OrderLinesId
New
INT
NULL

OrderId
New
INT
NULL

ItemId
New
INT
NULL

ItemSalesPrice
New
REAL
NULL

ItemCaption
New
NVARVHAR
NULL


OrderLinesEditable (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
Id
New
INT
NOT NULL

OrderMessageId
New
INT
NOT NULL

LocationId
New
INT
NOT NULL


OrderMessages (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
Id
New
INT
NOT NULL

Created
New
DATETIME
NULL

CreatedBy
New
INT
NULL

LastUpdated
New
DATETIME
NULL

LastUpdatedBy
New
INT
NULL

DeliveryTimeFrom
New
TIME
NULL

DeliveryTimeTo
New
TIME
NULL

IsLargeOrder
New
BIT
NOT NULL

IsDisableOrderFormMessage
New
BIT
NOT NULL

FormMessage
New
NVARCHAR
NOT NULL

EmailMessage
New
NVARCHAR
NOT NULL

MessageType
New
INT
NOT NULL

IsRoot
New
BIT
NULL

RootLocationId
New
INT
NULL

Person2Locations (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
Id
New
INT
NOT NULL

Created
New
DATETIME
NULL

CreatedBy
New
INT
NULL

LastUpdated
New
DATETIME
NULL

LastUpdatedBy
New
INT
NULL

PersonId
New
INT
NOT NULL

LocationId
New
INT
NOT NULL


ReservationsExternal (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
ResourceID
New
INT
NOT NULL

ReservationID
New
INT
NOT NULL

ExternalReservationId
New
NVARCHAR
NULL

ExternalOrganizerEmail
New
VARCHAR
NOT NULL

ExternalOrganizerName
New
NVARCHAR
NULL

ExternalOrganizerPhoneNumber
New
NVARCHAR
NULL

ReservationGlobalId
New
NVARCHAR
NOT NULL


ResourceDeleteProcessing (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
ResourceId
New
INT
NOT NULL

 
Role2Locations (New table)

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
id
New
INT
NOT NULL

LastUpdated
New
DATETIME
NULL

RoleId
New
INT
NULL

LocationId
New
INT
NULL


  • Changed items

ResourceAttendees

Columns
Update type
Data type
 
Nullable
Data meaning, where data comes from, rules on forming data
AttendeeEmail
Change data type
NVARCHAR
NOT NULL

AttendeeDisplayName
Change from NULL to NOT NULL
NVARCHAR
NOT NULL


Properties

Applies toRC 4.3.0003.0003 (RC 4.3 RTM)

Reference: TFS #353670

Knowledge base ID: 0327

Last updated: Sep 13, 2023







Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article