As part of the v5.0 update to SpiraTest, SpiraPlan and SpiraTeam, we made major changes to the database structure to improve performance and usability as well as lay the foundation for v5.1, v5.2 and v5.3 due out later this year. Customers using custom reports that relied on the old v4.2 database structure will need to modify their custom reports.

The following changes were made to the database structure in v5.0:

TST_ATTACHMENT

Dynamic Data

Column Added

CONCURRENCY_DATE
Added

TST_AUTOMATION_HOST

Dynamic Data

Column Added

LAST_CONTACT_DATE
added

TST_CUSTOM_PROPERTY

Dynamic Data

Column Added

DEPENDENT_CUSTOM_PROPERTY_ID
added

TST_CUSTOM_PROPERTY_VALUE

Dynamic Data

Column Added

DEPENDENT_CUSTOM_PROPERTY_LIST_ID
added

TST_TVAULT_PROJECT

Dynamic Data

Column Added

Added column
TARAVAULT_ID BIGINT

TST_USER_ARTIFACT_FIELD

Dynamic Data

Column Added

WIDTH field added

TST_USER_CUSTOM_PROPERTY

Dynamic Data

Column Added

WIDTH field added

TST_TVAULT_USER

Dynamic Data

Column Added/Changed

Added
column TARAVAULT_USERLOGIN and TARAVAULT_PASSWORD was changed to
NVARCHAR(MAX)

TST_INCIDENT

Dynamic Data

Column Removed

TEST_RUN_STEP_ID
column removed and the data migrated to the new TST_TEST_RUN_STEP_INCIDENT
table

TST_DATA_SYNC_SYSTEM

Dynamic Data

Columns Added

CAPTION and
IS_ENCRYPTED fields added, both can be left blank during upgrade

TST_REPORT_AVAILABLE_SECTION

Dynamic Data

Columns Added

POSITION nullable
field added

TST_REPORT_CUSTOM_SECTION

Dynamic Data

Columns Added

POSITION nullable
field added

TST_USER_PROFILE

Dynamic Data

Columns Added

Added
an organization field to the user profile table - which is set to allow nulls

TST_ATTACHMENT_VERSION

Dynamic Data

Columns Changed

CURRENT_YN
changed to IS_CURRENT

TST_AUTOMATION_ENGINE

Dynamic Data

Columns Changed

ACTIVE_YN
changed to IS_ACTIVE bit field

TST_AUTOMATION_HOST

Dynamic Data

Columns Changed

ACTIVE_YN
and ATTACHMENTS_YN fields changed to IS_ACTIVE and IS_ATTACHMENTS and
CONCURRENCY_DATE added

Release
ActiveYn, IterationYn fields disabled, new Status/Type/Owner fields added and
workflow flag set to True on various Release fields

TST_ARTIFACT_FIELD

Static Data

Data Added

Test
Case ActiveYn field disabled, new Status/Type fields added and workflow flag
set to True on various Test Case fields. Also ComponentIds and IsSuspect
fields added to test cases

TST_ARTIFACT_FIELD

Static Data

Data Added

Test
Set BuildExecuteTimeInterval field added and position of TestSetId field
incremented. Also ActiveYn changed to IsActive for automation hosts. Also
added Description field for TestRuns. Also log-history set to TRUE/1 for
several of the Test Run fields

TST_GLOBAL_FILETYPES

Static Data

Data Added

JSON type added

TST_GLOBAL_FILETYPES

Static Data

Data Added

Filetypes
added for Rapise .sstest, .rest and .trp files

TST_REQUIREMENT_TYPE

Static Data

Data Added

Design
Element Added, also need to add to all workflows using

TST_USER_COLLECTION

Static Data

Data Added

GuidedTours.State
added

TST_REPORT_SECTION_ELEMENT

Static Data

Data Added

Added test steps to
the test set detailed report section

TST_NOTIFICATION_ARTIFACT_TEMPLATE

Static Data

Data Added/Changed

Notification
templates changed and new template added for 'Documents'

TST_ARTIFACT_TYPE

Static Data

Data Changed

New
entry for 'Document' artifact type added

TST_PROJECT_COLLECTION

Static Data

Data Changed

The
TestCaseSelectedRelease collection is set to ACTIVE_YN = 'N', new
TestSetDetails.TestCases.Columns collection