CREATE EXTENSION IF NOT EXISTS "pgcrypto";

CREATE TABLE session (
    id TEXT PRIMARY KEY NOT NULL,
    hashed_secret TEXT NOT NULL,
    session TEXT NOT NULL,
    created TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
    modified TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
);
