• Home
• io.nflow
• nflow-engine
• 6.0.0
• source code
• h2.update.ddl.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

scripts.db.update-5.6.0-x.h2.update.ddl.sql Maven / Gradle / Ivy

alter table nflow_workflow add started timestamp;
alter table nflow_archive_workflow add started timestamp;

update nflow_workflow w set
  started=(select min(execution_start) from nflow_workflow_action a where a.workflow_id = w.id group by a.workflow_id),
  modified=w.modified;

update nflow_archive_workflow w set
  started=(select min(execution_start) from nflow_archive_workflow_action a where a.workflow_id = w.id group by a.workflow_id),
  modified=w.modified;