Files

11 lines
429 B
SQL

-- Ported from the SQLite migration of the same number.
-- How long a key may live, at most: for the whole gateway (scope gateway,
-- written from server.yaml when the server starts) and for an organization,
-- team or project. A key is made within the shortest that applies to it.
CREATE TABLE key_ttl (
scope TEXT NOT NULL,
scope_id TEXT NOT NULL,
max_seconds BIGINT NOT NULL,
PRIMARY KEY (scope, scope_id)
);