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

alter table nflow_workflow add started timestamptz;
alter table nflow_archive_workflow add started timestamptz;

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

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