conductor

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

005_refresh_tokens.sql (571B)

      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     INTEGER NOT NULL,
      8   expires_at    INTEGER NOT NULL,
      9   last_used_at  INTEGER,
     10   revoked_at    INTEGER,
     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);