005_sessions.sql RawHistoryFolder

1-- +goose Up
2CREATE TABLE sessions (
3    id TEXT PRIMARY KEY,
4    type TEXT NOT NULL CHECK (type IN ('browser', 'cli')),
5    started_at TIMESTAMP NOT NULL,
6    ended_at TIMESTAMP
7);
8
9CREATE INDEX idx_sessions_started_at ON sessions(started_at DESC);
10CREATE INDEX idx_sessions_active ON sessions(started_at DESC) WHERE ended_at IS NULL;
11
12-- +goose Down
13DROP TABLE sessions;