scripts.db.mysql.create.ddl.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of nflow-engine Show documentation

nFlow Engine

There is a newer version: 3.3.0

create table if not exists nflow_workflow (
  id int not null auto_increment primary key,
  type varchar(64) not null,
  business_key varchar(64),
  external_id varchar(64) not null,
  state varchar(64) not null,
  state_text varchar(128),
  next_activation timestamp(3) null,
  executor_id int,
  retries int not null default 0,
  created timestamp(3) not null default current_timestamp(3),
  modified timestamp(3) not null default current_timestamp(3) on update current_timestamp(3),
  executor_group varchar(64) not null,
  constraint nflow_workflow_uniq unique (type, external_id, executor_group),
  index nflow_workflow(next_activation)
);

create table if not exists nflow_workflow_action (
  id int not null auto_increment primary key,
  workflow_id int not null,
  executor_id int not null default -1,
  state varchar(64) not null,
  state_text varchar(128),
  retry_no int not null,
  execution_start timestamp(3) not null,
  execution_end timestamp(3) not null,
  foreign key (workflow_id) references nflow_workflow(id) on delete cascade
);

create table if not exists nflow_workflow_state (
  workflow_id int not null,
  action_id int not null,
  state_key varchar(64) not null,
  state_value varchar(10240) not null,
  primary key (workflow_id, action_id, state_key),
  foreign key (workflow_id) references nflow_workflow(id) on delete cascade
);

create table if not exists nflow_executor (
  id int not null auto_increment primary key,
  host varchar(64) not null,
  pid int not null,
  executor_group varchar(64),
  started timestamp(3) not null default current_timestamp(3),
  active timestamp(3),
  expires timestamp(3)
);

create table if not exists nflow_workflow_definition (
  type varchar(64) not null,
  definition text not null,
  created timestamp(3) not null default current_timestamp(3),
  modified timestamp(3) not null default current_timestamp(3) on update current_timestamp(3),
  modified_by int not null,
  executor_group varchar(64) not null,
  primary key (type, executor_group)
);