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

-- These must be run before nFlow is updated.

if exists (select 1 from sys.indexes where name='fk_workflow_parent')
alter table nflow_workflow drop constraint fk_workflow_parent;

if exists (select 1 from sys.indexes where name='fk_workflow_root')
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;