• 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-7.1.0-x.postgresql.update.ddl.sql Maven / Gradle / Ivy

drop index idx_workflow_parent;
create index idx_workflow_parent on nflow_workflow(parent_workflow_id) where parent_workflow_id is not null;

drop index idx_workflow_archive_parent;
create index idx_workflow_archive_parent on nflow_archive_workflow(parent_workflow_id) where parent_workflow_id is not null;

alter table nflow_workflow set (fillfactor=95);

alter index nflow_workflow_action_pkey set (fillfactor=100);
alter index nflow_workflow_action_workflow set (fillfactor=100);

alter index nflow_workflow_state_pkey rename to pk_workflow_state;
alter index pk_workflow_state set (fillfactor=100);

alter table nflow_archive_workflow drop constraint nflow_archive_workflow_uniq;

alter index nflow_archive_workflow_pkey set (fillfactor=100);
alter index idx_workflow_archive_parent set (fillfactor=100);
alter index nflow_archive_workflow_action_pkey set (fillfactor=100);

alter index nflow_archive_workflow_state_pkey rename to pk_arch_workflow_state;
alter index pk_arch_workflow_state set (fillfactor=100);

alter table nflow_workflow rename constraint nflow_workflow_uniq to nflow_workflow_uniq_old;
alter table nflow_workflow add constraint nflow_workflow_uniq unique (external_id, type, executor_group);
alter table nflow_workflow drop constraint nflow_workflow_uniq_old;

create index idx_workflow_archive_type on nflow_archive_workflow(type) with (fillfactor=100);