github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/004_sessions.sql (about)

     1  -- +goose Up
     2  CREATE TABLE sessions (
     3      "token"        TEXT        NOT NULL,
     4      "access_token" TEXT        NOT NULL,
     5      "email"        TEXT        NOT NULL,
     6      "name"         TEXT        NOT NULL,
     7      "created"      TIMESTAMPTZ NOT NULL DEFAULT NOW(),
     8      "expires"      TIMESTAMPTZ NOT NULL,
     9      PRIMARY KEY (token)
    10  );
    11  
    12  -- +goose Down
    13  DROP TABLE sessions;