conductor

CI task system
git clone git://git.finwo.net/app/conductor
Log | Files | Refs | README | LICENSE

005_refresh_tokens.sql (564B)

      1 -- 005_refresh_tokens.sql - revocable refresh tokens, built-in provider only
      2 
      3 CREATE TABLE refresh_tokens (
      4   id            TEXT   NOT NULL PRIMARY KEY,
      5   user_id       TEXT   NOT NULL REFERENCES users(id) ON DELETE CASCADE,
      6   token_hash    TEXT   NOT NULL UNIQUE,
      7   issued_at     BIGINT NOT NULL,
      8   expires_at    BIGINT NOT NULL,
      9   last_used_at  BIGINT,
     10   revoked_at    BIGINT,
     11   user_agent    TEXT,
     12   ip            TEXT
     13 );
     14 
     15 CREATE INDEX idx_refresh_tokens_user ON refresh_tokens (user_id);
     16 CREATE INDEX idx_refresh_tokens_expires ON refresh_tokens (expires_at);