DpeCoreDb Change History
| Version | Change Description |
|---|---|
| 1.14 | Changed Workflows.Title from nvarchar(100) to nvarchar(1000) Changed Worfklows.ObjectId from nvarchar(40) to nvarchar(1000) Changed Jobs.Title from nvarchar(100) to nvarchar(1000) Enlarged fields are used from DPE 2.2.68.0 and newer. Older DPE versions support only previous field length. |
| 1.13 | Changed Workflows.Worker from nvarchar(50) to nvarchar(200) Changed Jobs.Worker from nvarchar(50) to nvarchar(200) Enlarged fields are used from DPE 2.1.85.0 and newer. Older DPE versions support only previous field length. |
| 1.12 | Added to table Workflows: Version, HasValidSignature, MinDependentVersion Added to table WorkflowTemplates: Version, HasValidSignature, MinDependentVersion Updated stored procedures DoCleanupLogItems, DoCleanupWorkflows, DoCleanupJobs with block delays Requires DPE 1.7.34.0 or newer |
| 1.11 | Dropped contraint FK_Workflows_Workflows in table Workflows Dropped contraint FK_Workflows_Jobs in table Jobs |
| 1.10 | Changed Workflows.CreatingComponent (and index) from nvarchar(50) to nvarchar(200) |
| 1.9 | Added to table Worfklows: CreatingComponent, ObjectId, ObjectIdH (and indices) |
| 1.8 | Dropped tables WorkflowExecutions and JobExecutions Changed tables Workflows and Jobs (to include execution info again) |
| 1.7 | Updated stored procedures DoCleanupLogItems, DoCleanupWorkflows, DoCleanupJobs |
| 1.6 | Changed contraint FK_WorkflowExecutions_Workflows with ON DELETE CASCADE |
| 1.5 | Added indices on Jobs.Created, Jobs.WorkerType for better performance when running jobs Added indices on JobExecutions.JobId, JobExecution.State for better performance when creating jobs Added indices on WorkflowExecutions.WorkflowId, WorkflowExecutions.State for better performance when creating workflows |
| 1.4 | Deleting tables WorkflowStates and JobStates because the states are hard-coded Adding indices on Workflows.Created, Workflows.WorkflowType for better performance |
| 1.3 | Splitting of table Workflows into Workflows and WorkflowExecutions |
| 1.2 | Changes in table Workflows: Renamed column Finished to Stopped Renamed column StatusLastChanged to Updated Renamed column Summary to StatusMessage Renamed column OutputResults to Results Dropped column QdJobIds Dropped column Retries Added column UserInfo Changed column Progress to real NOT NULL |
| 1.1 | Changed column WorkflowTemplates.Name to nvarchar(50) NOT NULL |
