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

-- These must be run before nFlow is updated.

alter table nflow_workflow drop constraint fk_workflow_parent
/

alter table nflow_workflow drop constraint fk_workflow_root
/
  
create index idx_workflow_parent on nflow_workflow(parent_workflow_id)
/

create index nflow_workflow_action_workflow on nflow_workflow_action(workflow_id)
/

create index idx_workflow_archive_parent on nflow_archive_workflow(parent_workflow_id)
/

-- These must be run after nFlow is updated.

alter table nflow_workflow drop column root_workflow_id
/

alter table nflow_archive_workflow drop column root_workflow_id
/