Knowledge Base Article

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article Database Changes Between Spira v4.2 and v5.0

by Adam S on Wednesday, July 27, 2016

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
TST_DATA_SYNC_PROJECT Dynamic Data Columns Changed EXTERNAL_KEY increased to 255 length
TST_DATA_SYNC_SYSTEM Dynamic Data Columns Changed Various text fields increased to 255 length
TST_HISTORY_CHANGESET Dynamic Data Columns Changed SIGNATURE_HASH added
TST_PROJECT_ATTACHMENT_TYPE Dynamic Data Columns Changed ACTIVE_YN changed to IS_ACTIVE, DEFAULT_YN changed to IS_DEFAULT
TST_PROJECT_ROLE Dynamic Data Columns Changed DOCUMENTS_ADD_YN, DOCUMENTS_EDIT_YN, DOCUMENTS_DELETE_YN removed, all other YN fields converted to IS_ bit fields
TST_PROJECT_ROLE_PERMISSION Dynamic Data Data Added Rows added for the new 'Document/Attachment' artifact type, replacing the old DOCUMENT-EDIT and DOCUMENT-EDIT flags on TST_ROLE
TST_PROJECT_ROLE_PERMISSION Dynamic Data Data Added Rows added to give Modify All users Bulk Edit permissions (by default)
TST_RELEASE Dynamic Data Columns Changed ACTIVE_YN, ITERATION_YN fields removed and replaced by Type/Status columns. ATTACHMENTS_YN and SUMMARY_YN replaced by IS_ fields. Also added nullable OWNER_ID field. Also CONCURRENCY_DATE added
TST_RELEASE_DISCUSSION Dynamic Data Columns Changed DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_RELEASE_TEST_CASE Dynamic Data Columns Changed EXECUTION_STATUS_ID, ACTUAL_DURATION and EXECUTION_DATE added to column
TST_REQUIREMENT_DISCUSSION Dynamic Data Columns Changed DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_REQUIREMENT_WORKFLOW_TRANSITION Dynamic Data Columns Changed IS_SIGNATURE_REQUIRED added
TST_TASK_DISCUSSION Dynamic Data Columns Changed DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TASK_WORKFLOW_TRANSITION Dynamic Data Columns Changed IS_SIGNATURE_REQUIRED added
TST_TEST_CASE Dynamic Data Columns Changed INDENT_LEVEL, ACTIVE_YN, FOLDER_YN, FOLDER_COUNT_XXXXX fields removed. ACTUAL_DURATION added. ATTACHMENTS_YN and TEST_STEPS_YN changed to IS_ATTACHMENTS and IS_TEST_STEPS bit fields. TEST_CASE_STATUS_ID and TEST_CASE_TYPE_ID, TEST_CASE_FOLDER_ID foreign key fields added. Also COMPONENT_IDS and IS_SUSPECT fields added
TST_TEST_CASE_DISCUSSION Dynamic Data Columns Changed DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TEST_RUN Dynamic Data Columns Changed ATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added
TST_TEST_RUN Dynamic Data Columns Changed Removed the IS_DELETED field (was never used)
TST_TEST_RUN_STEP Dynamic Data Columns Changed ACTUAL_DURATION, START_DATE and END_DATE added
TST_TEST_RUNS_PENDING Dynamic Data Columns Changed COUNT_NOT_APPLICABLE added
TST_TEST_SET Dynamic Data Columns Changed FOLDER_YN, INDENT_LEVEL removed. ATTACHMENTS_YN changed to IS_ATTACHMENTS. Also added TEST_SET_FOLDER_ID, EXECUTION_DATE, BUILD_EXECUTE_TIME_INTERVAL, ESTIMATED_DURATION, ACTUAL_DURATION, COUNT_XXXXXX fields
TST_TEST_SET Dynamic Data Columns Changed IS_DYNAMIC, IS_AUTO_SCHEDULED, TEST_CONFIGURATION_SET_ID, and DYNAMIC_QUERY columns added
TST_TEST_SET_DISCUSSION Dynamic Data Columns Changed DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TEST_STEP Dynamic Data Columns Changed ATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added
TST_WORKFLOW_TRANSITION Dynamic Data Columns Changed IS_SIGNATURE_REQUIRED added
TST_RELEASE_USER Dynamic Data Columns Renamed VISIBLE_YN and EXPANDED_YN switched to IS_VISIBLE and IS_EXPANDED bit fields
TST_GLOBAL_SETTING Dynamic Data Data Changed Set Testing_CreateDefaultTestStep to FALSE for upgrades
TST_REQUIREMENT_TYPE_PROJECT_WORKFLOW Dynamic Data Data Added References to the new Design Element type need to be added to all existing workflows
TST_CUSTOM_PROPERTY_DEPENDENCY Dynamic Data Table Added For future use
TST_DASHBOARD_CUSTOM Dynamic Data Table Added For future use
TST_DASHBOARD_CUSTOM_PERMISSION Dynamic Data Table Added For future use
TST_GLOBAL_SETTING_SECURE Dynamic Data Table Added Migrate over the LDAP bind password and SMTP password
TST_GRAPH_CUSTOM Dynamic Data Table Added For future use
TST_MESSAGE_ARTIFACT Dynamic Data Table Added For future use
TST_PROJECT_ARTIFACT_SHARING Dynamic Data Table Added For future use
TST_PROJECT_SETTING_VALUE Dynamic Data Table Added For future use
TST_RELEASE_TEST_CASE_FOLDER Dynamic Data Table Added Calculated post-migrating used stored-proc
TST_RELEASE_TEST_SET Dynamic Data Table Added Calculated post-migrating used stored-proc
TST_RELEASE_TEST_SET_FOLDER Dynamic Data Table Added Calculated post-migrating used stored-proc
TST_RELEASE_TYPE_PROJECT_WORKFLOW Dynamic Data Table Added Create default workflow per project
TST_RELEASE_WORKFLOW Dynamic Data Table Added Create default workflow per project
TST_RELEASE_WORKFLOW_CUSTOM_PROPERTY Dynamic Data Table Added Create default workflow per project
TST_RELEASE_WORKFLOW_FIELD Dynamic Data Table Added Create default workflow per project
TST_RELEASE_WORKFLOW_TRANSITION Dynamic Data Table Added Create default workflow per project
TST_RELEASE_WORKFLOW_TRANSITION_ROLE Dynamic Data Table Added Create default workflow per project
TST_REQUIREMENT_TEST_STEP Dynamic Data Table Added For future use
TST_SESSION Dynamic Data Table Added For future use - not migrated
TST_TEST_CASE_FOLDER Dynamic Data Table Added Migrate test case folders from TST_TEST_CASE table
TST_TEST_CASE_TYPE_PROJECT_WORKFLOW Dynamic Data Table Added Create default workflow per project
TST_TEST_CASE_WORKFLOW Dynamic Data Table Added Create default workflow per project
TST_TEST_CASE_WORKFLOW_CUSTOM_PROPERTY Dynamic Data Table Added Create default workflow per project
TST_TEST_CASE_WORKFLOW_FIELD Dynamic Data Table Added Create default workflow per project
TST_TEST_CASE_WORKFLOW_TRANSITION Dynamic Data Table Added Create default workflow per project
TST_TEST_CASE_WORKFLOW_TRANSITION_ROLE Dynamic Data Table Added Create default workflow per project
TST_TEST_CONFIGURATION Dynamic Data Table Added For future use
TST_TEST_CONFIGURATION_PARAMETER_VALUE Dynamic Data Table Added For future use
TST_TEST_CONFIGURATION_SET Dynamic Data Table Added For future use
TST_TEST_CONFIGURATION_SET_PARAMETER Dynamic Data Table Added For future use
TST_TEST_RUN_STEP_INCIDENT Dynamic Data Table Added Migrated from TST_INCIDENT
TST_TEST_SET_FOLDER Dynamic Data Table Added Migrate test set folders from TST_TEST_SET table
TST_TEST_SET_PARAMETER Dynamic Data Table Added  
TST_TEST_CASE_USER Dynamic Data Table Deleted  
TST_TEST_SET_USER Dynamic Data Table Deleted  
TST_DASHBOARD_USER_PERSONALIZATION Dynamic Data Data Invalid Need to delete any existing entries (and not migrate) for the Reports dashboard since types have changed
TST_PERMISSION Static Data Data Added, Columns Changed New permission added to Bulk Edit and ACTIVE_YN changed to IS_ACTIVE
TST_ARTIFACT_FIELD Static Data Columns Changed All of the existing _YN fields were changed to IS_ bit fields
TST_ARTIFACT_FIELD_TYPE Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE
TST_ARTIFACT_TYPE Static Data Columns Changed NOTIFY_YN, ACTIVE_YN, DATA_SYNC_YN replaced by IS_NOTIFY, IS_ACTIVE, IS_DATA_SYNC bit fields. Also new IS_ATTACHMENTS, IS_CUSTOM_PROPERTIES added
TST_ATTACHMENT_TYPE Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE
TST_EXECUTION_STATUS Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE bit field
TST_GRAPH Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE
TST_GRAPH_TYPE Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE and new custom graph type added
TST_TEST_CASE_PRIORITY Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE bit field
TST_TEST_RUN_TYPE Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE bit field
TST_TEST_SET_STATUS Static Data Columns Changed ACTIVE_YN changed to IS_ACTIVE bit field
TST_ARTIFACT_FIELD Static Data Data Added Rows added for the new 'Document/Attachment' artifact type
TST_ARTIFACT_FIELD Static Data Data 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
TST_REPORT_SECTION Static Data Data Changed Report default section templates changed
TST_DASHBOARD_CUSTOM_TYPE Static Data Table Added For future use
TST_PROJECT_SETTING Static Data Table Added For future use
TST_RELEASE_STATUS Static Data Table Added  
TST_RELEASE_TYPE Static Data Table Added  
TST_TEST_CASE_STATUS Static Data Table Added  
TST_TEST_CASE_TYPE Static Data Table Added  

Attachments
Article Info
Last Updated: 7/27/2016
Article ID: KB214
# Views: 8395
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.