• Home
• io.nflow
• nflow-engine
• 7.1.0
• source code
• db2.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.db2.update.ddl.sql Maven / Gradle / Ivy

alter table nflow_workflow add started timestamp(3);
alter table nflow_archive_workflow add started timestamp(3);

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