goddit/2_create_sessions_table.up.sql at master - goddit - Gitea: Git with a cup of tea

This repository has been archived on 2021-09-01. You can view files and clone it, but cannot push or open issues or pull requests.

7 lines

167 B

SQL

Raw Permalink Blame History

 CREATE TABLE sessions (
     token TEXT PRIMARY KEY,
     data BYTEA NOT NULL,
     expiry TIMESTAMPTZ NOT NULL
 );
 CREATE INDEX sessions_expiry_idx ON sessions (expiry);