monorepo/file-service/migrations/20231003154201_initial_auth_db.sql

CREATE TABLE IF NOT EXISTS users (
    id          INTEGER PRIMARY KEY NOT NULL,
    username    TEXT NOT NULL,
    token       TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS sessions (
    token       TEXT NOT NULL,
    user_id     INTEGER,
    FOREIGN KEY(user_id) REFERENCES users(id)
);