074-jobs-owner-foreign-key.sql

START TRANSACTION;

ALTER TABLE webknossos.jobs
  ADD CONSTRAINT owner_ref FOREIGN KEY(_owner) REFERENCES webknossos.users(_id) DEFERRABLE;

UPDATE webknossos.releaseInformation SET schemaVersion = 74;

COMMIT TRANSACTION;