All Downloads are FREE. Search and download functionalities are using the official Maven repository.

scripts.db.update-6.2.0-x.mysql.legacy.update.ddl.sql Maven / Gradle / Ivy

There is a newer version: 10.0.0
Show newest version
-- These must be run before nFlow is updated.

alter table nflow_workflow drop foreign key fk_workflow_parent;

alter table nflow_workflow drop foreign key 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;




© 2015 - 2024 Weber Informatics LLC | Privacy Policy