migrations/002_create_users_sessions_table.up.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE users_sessions (
    session_id UUID PRIMARY KEY,
    user_id UUID,
    ip TEXT NOT NULL,
    ua TEXT NOT NULL,
    expires_at TIMESTAMP NOT NULL,
    created_at TIMESTAMP DEFAULT now(),
    last_updated TIMESTAMP DEFAULT now()
);