-- Add migration script here
CREATE TABLE IF NOT EXISTS backend_process (
  id                            INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  settings_version              INTEGER,
  status                        TEXT NOT NULL CHECK( status IN ('waiting_for_start', 'running', 'waiting_for_stop', 'finished', 'failed') ),
  FOREIGN KEY(settings_version) REFERENCES settings(version)
);