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

TST_ATTACHMENTDynamic DataColumn AddedCONCURRENCY_DATE Added
TST_AUTOMATION_HOSTDynamic DataColumn AddedLAST_CONTACT_DATE added
TST_CUSTOM_PROPERTYDynamic DataColumn AddedDEPENDENT_CUSTOM_PROPERTY_ID added
TST_CUSTOM_PROPERTY_VALUEDynamic DataColumn AddedDEPENDENT_CUSTOM_PROPERTY_LIST_ID added
TST_TVAULT_PROJECTDynamic DataColumn AddedAdded column TARAVAULT_ID BIGINT
TST_USER_ARTIFACT_FIELDDynamic DataColumn AddedWIDTH field added
TST_USER_CUSTOM_PROPERTYDynamic DataColumn AddedWIDTH field added
TST_TVAULT_USERDynamic DataColumn Added/ChangedAdded column TARAVAULT_USERLOGIN and TARAVAULT_PASSWORD was changed to NVARCHAR(MAX)
TST_INCIDENTDynamic DataColumn RemovedTEST_RUN_STEP_ID column removed and the data migrated to the new TST_TEST_RUN_STEP_INCIDENT table
TST_DATA_SYNC_SYSTEMDynamic DataColumns AddedCAPTION and IS_ENCRYPTED fields added, both can be left blank during upgrade
TST_REPORT_AVAILABLE_SECTIONDynamic DataColumns AddedPOSITION nullable field added
TST_REPORT_CUSTOM_SECTIONDynamic DataColumns AddedPOSITION nullable field added
TST_USER_PROFILEDynamic DataColumns AddedAdded an organization field to the user profile table - which is set to allow nulls
TST_ATTACHMENT_VERSIONDynamic DataColumns ChangedCURRENT_YN changed to IS_CURRENT
TST_AUTOMATION_ENGINEDynamic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE bit field
TST_AUTOMATION_HOSTDynamic DataColumns ChangedACTIVE_YN and ATTACHMENTS_YN fields changed to IS_ACTIVE and IS_ATTACHMENTS and CONCURRENCY_DATE added
TST_DATA_SYNC_PROJECTDynamic DataColumns ChangedEXTERNAL_KEY increased to 255 length
TST_DATA_SYNC_SYSTEMDynamic DataColumns ChangedVarious text fields increased to 255 length
TST_HISTORY_CHANGESETDynamic DataColumns ChangedSIGNATURE_HASH added
TST_PROJECT_ATTACHMENT_TYPEDynamic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE, DEFAULT_YN changed to IS_DEFAULT
TST_PROJECT_ROLEDynamic DataColumns ChangedDOCUMENTS_ADD_YN, DOCUMENTS_EDIT_YN, DOCUMENTS_DELETE_YN removed, all other YN fields converted to IS_ bit fields
TST_PROJECT_ROLE_PERMISSIONDynamic DataData AddedRows added for the new 'Document/Attachment' artifact type, replacing the old DOCUMENT-EDIT and DOCUMENT-EDIT flags on TST_ROLE
TST_PROJECT_ROLE_PERMISSIONDynamic DataData AddedRows added to give Modify All users Bulk Edit permissions (by default)
TST_RELEASEDynamic DataColumns ChangedACTIVE_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_DISCUSSIONDynamic DataColumns ChangedDELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_RELEASE_TEST_CASEDynamic DataColumns ChangedEXECUTION_STATUS_ID, ACTUAL_DURATION and EXECUTION_DATE added to column
TST_REQUIREMENT_DISCUSSIONDynamic DataColumns ChangedDELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_REQUIREMENT_WORKFLOW_TRANSITIONDynamic DataColumns ChangedIS_SIGNATURE_REQUIRED added
TST_TASK_DISCUSSIONDynamic DataColumns ChangedDELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TASK_WORKFLOW_TRANSITIONDynamic DataColumns ChangedIS_SIGNATURE_REQUIRED added
TST_TEST_CASEDynamic DataColumns ChangedINDENT_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_DISCUSSIONDynamic DataColumns ChangedDELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TEST_RUNDynamic DataColumns ChangedATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added
TST_TEST_RUNDynamic DataColumns ChangedRemoved the IS_DELETED field (was never used)
TST_TEST_RUN_STEPDynamic DataColumns ChangedACTUAL_DURATION, START_DATE and END_DATE added
TST_TEST_RUNS_PENDINGDynamic DataColumns ChangedCOUNT_NOT_APPLICABLE added
TST_TEST_SETDynamic DataColumns ChangedFOLDER_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_SETDynamic DataColumns ChangedIS_DYNAMIC, IS_AUTO_SCHEDULED, TEST_CONFIGURATION_SET_ID, and DYNAMIC_QUERY columns added
TST_TEST_SET_DISCUSSIONDynamic DataColumns ChangedDELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing)
TST_TEST_STEPDynamic DataColumns ChangedATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added
TST_WORKFLOW_TRANSITIONDynamic DataColumns ChangedIS_SIGNATURE_REQUIRED added
TST_RELEASE_USERDynamic DataColumns RenamedVISIBLE_YN and EXPANDED_YN switched to IS_VISIBLE and IS_EXPANDED bit fields
TST_GLOBAL_SETTINGDynamic DataData ChangedSet Testing_CreateDefaultTestStep to FALSE for upgrades
TST_REQUIREMENT_TYPE_PROJECT_WORKFLOWDynamic DataData AddedReferences to the new Design Element type need to be added to all existing workflows
TST_CUSTOM_PROPERTY_DEPENDENCYDynamic DataTable AddedFor future use
TST_DASHBOARD_CUSTOMDynamic DataTable AddedFor future use
TST_DASHBOARD_CUSTOM_PERMISSIONDynamic DataTable AddedFor future use
TST_GLOBAL_SETTING_SECUREDynamic DataTable AddedMigrate over the LDAP bind password and SMTP password
TST_GRAPH_CUSTOMDynamic DataTable AddedFor future use
TST_MESSAGE_ARTIFACTDynamic DataTable AddedFor future use
TST_PROJECT_ARTIFACT_SHARINGDynamic DataTable AddedFor future use
TST_PROJECT_SETTING_VALUEDynamic DataTable AddedFor future use
TST_RELEASE_TEST_CASE_FOLDERDynamic DataTable AddedCalculated post-migrating used stored-proc
TST_RELEASE_TEST_SETDynamic DataTable AddedCalculated post-migrating used stored-proc
TST_RELEASE_TEST_SET_FOLDERDynamic DataTable AddedCalculated post-migrating used stored-proc
TST_RELEASE_TYPE_PROJECT_WORKFLOWDynamic DataTable AddedCreate default workflow per project
TST_RELEASE_WORKFLOWDynamic DataTable AddedCreate default workflow per project
TST_RELEASE_WORKFLOW_CUSTOM_PROPERTYDynamic DataTable AddedCreate default workflow per project
TST_RELEASE_WORKFLOW_FIELDDynamic DataTable AddedCreate default workflow per project
TST_RELEASE_WORKFLOW_TRANSITIONDynamic DataTable AddedCreate default workflow per project
TST_RELEASE_WORKFLOW_TRANSITION_ROLEDynamic DataTable AddedCreate default workflow per project
TST_REQUIREMENT_TEST_STEPDynamic DataTable AddedFor future use
TST_SESSIONDynamic DataTable AddedFor future use - not migrated
TST_TEST_CASE_FOLDERDynamic DataTable AddedMigrate test case folders from TST_TEST_CASE table
TST_TEST_CASE_TYPE_PROJECT_WORKFLOWDynamic DataTable AddedCreate default workflow per project
TST_TEST_CASE_WORKFLOWDynamic DataTable AddedCreate default workflow per project
TST_TEST_CASE_WORKFLOW_CUSTOM_PROPERTYDynamic DataTable AddedCreate default workflow per project
TST_TEST_CASE_WORKFLOW_FIELDDynamic DataTable AddedCreate default workflow per project
TST_TEST_CASE_WORKFLOW_TRANSITIONDynamic DataTable AddedCreate default workflow per project
TST_TEST_CASE_WORKFLOW_TRANSITION_ROLEDynamic DataTable AddedCreate default workflow per project
TST_TEST_CONFIGURATIONDynamic DataTable AddedFor future use
TST_TEST_CONFIGURATION_PARAMETER_VALUEDynamic DataTable AddedFor future use
TST_TEST_CONFIGURATION_SETDynamic DataTable AddedFor future use
TST_TEST_CONFIGURATION_SET_PARAMETERDynamic DataTable AddedFor future use
TST_TEST_RUN_STEP_INCIDENTDynamic DataTable AddedMigrated from TST_INCIDENT
TST_TEST_SET_FOLDERDynamic DataTable AddedMigrate test set folders from TST_TEST_SET table
TST_TEST_SET_PARAMETERDynamic DataTable Added 
TST_TEST_CASE_USERDynamic DataTable Deleted 
TST_TEST_SET_USERDynamic DataTable Deleted 
TST_DASHBOARD_USER_PERSONALIZATIONDynamic DataData InvalidNeed to delete any existing entries (and not migrate) for the Reports dashboard since types have changed
TST_PERMISSIONStatic DataData Added, Columns ChangedNew permission added to Bulk Edit and ACTIVE_YN changed to IS_ACTIVE
TST_ARTIFACT_FIELDStatic DataColumns ChangedAll of the existing _YN fields were changed to IS_ bit fields
TST_ARTIFACT_FIELD_TYPEStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE
TST_ARTIFACT_TYPEStatic DataColumns ChangedNOTIFY_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_TYPEStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE
TST_EXECUTION_STATUSStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE bit field
TST_GRAPHStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE
TST_GRAPH_TYPEStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE and new custom graph type added
TST_TEST_CASE_PRIORITYStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE bit field
TST_TEST_RUN_TYPEStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE bit field
TST_TEST_SET_STATUSStatic DataColumns ChangedACTIVE_YN changed to IS_ACTIVE bit field
TST_ARTIFACT_FIELDStatic DataData AddedRows added for the new 'Document/Attachment' artifact type
TST_ARTIFACT_FIELDStatic DataData AddedRelease ActiveYn, IterationYn fields disabled, new Status/Type/Owner fields added and workflow flag set to True on various Release fields
TST_ARTIFACT_FIELDStatic DataData AddedTest 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_FIELDStatic DataData AddedTest 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_FILETYPESStatic DataData AddedJSON type added
TST_GLOBAL_FILETYPESStatic DataData AddedFiletypes added for Rapise .sstest, .rest and .trp files
TST_REQUIREMENT_TYPEStatic DataData AddedDesign Element Added, also need to add to all workflows using
TST_USER_COLLECTIONStatic DataData AddedGuidedTours.State added
TST_REPORT_SECTION_ELEMENTStatic DataData AddedAdded test steps to the test set detailed report section
TST_NOTIFICATION_ARTIFACT_TEMPLATEStatic DataData Added/ChangedNotification templates changed and new template added for 'Documents'
TST_ARTIFACT_TYPEStatic DataData ChangedNew entry for 'Document' artifact type added
TST_PROJECT_COLLECTIONStatic DataData ChangedThe TestCaseSelectedRelease collection is set to ACTIVE_YN = 'N', new TestSetDetails.TestCases.Columns collection
TST_REPORT_SECTIONStatic DataData ChangedReport default section templates changed
TST_DASHBOARD_CUSTOM_TYPEStatic DataTable AddedFor future use
TST_PROJECT_SETTINGStatic DataTable AddedFor future use
TST_RELEASE_STATUSStatic DataTable Added 
TST_RELEASE_TYPEStatic DataTable Added 
TST_TEST_CASE_STATUSStatic DataTable Added 
TST_TEST_CASE_TYPEStatic DataTable Added