-- @tag: validity_tokens
-- @description: Gültigkeits-Tokens z.B. für HTML-Formulare
-- @depends: release_3_6_1
CREATE TABLE validity_tokens (
  id          SERIAL,
  scope       TEXT      NOT NULL,
  token       TEXT      NOT NULL,
  itime       TIMESTAMP NOT NULL DEFAULT now(),
  valid_until TIMESTAMP NOT NULL,

  PRIMARY KEY (id),
  UNIQUE (scope, token)
);

INSERT INTO background_jobs (type, package_name, cron_spec, next_run_at, active)
VALUES ('interval', 'ValidityTokenCleanup', '0 3 * * *', now(), true);