summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'Flow/db_patches/patch-add_workflow_type.sql')
-rw-r--r--Flow/db_patches/patch-add_workflow_type.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/Flow/db_patches/patch-add_workflow_type.sql b/Flow/db_patches/patch-add_workflow_type.sql
new file mode 100644
index 00000000..8b6192af
--- /dev/null
+++ b/Flow/db_patches/patch-add_workflow_type.sql
@@ -0,0 +1,6 @@
+
+ALTER TABLE /*_*/flow_workflow ADD workflow_type varbinary(16);
+
+UPDATE /*_*/flow_workflow, /*_*/flow_definition
+ SET workflow_type = definition_type
+ WHERE workflow_definition_id = definition_id;