conductor

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

005_refresh_tokens.sql (655B)

      1 -- 005_refresh_tokens.sql - revocable refresh tokens, built-in provider only
      2 
      3 CREATE TABLE refresh_tokens (
      4   id            VARCHAR(64)  NOT NULL PRIMARY KEY,
      5   user_id       VARCHAR(64)  NOT NULL,
      6   token_hash    CHAR(64)     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    VARCHAR(255),
     12   ip            VARCHAR(64),
     13   KEY idx_refresh_tokens_user (user_id),
     14   KEY idx_refresh_tokens_expires (expires_at),
     15   CONSTRAINT fk_refresh_tokens_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
     16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;