kivitendo/sql/Pg-upgrade2/validity_tokens.sql @ 7b1da9c3
| 8b4dd266 | Moritz Bunkus | -- @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);
|