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

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 to: RC 4.3.0003.0003 (RC 4.3 RTM)

Reference: TFS #353670

Knowledge base ID: 0327

Last updated: Sep 13, 2023