1
0
Fork 0
forked from 2sys/shoutdotdev
shoutdotdev/migrations/2025-01-08-211839_sessions/up.sql

9 lines
263 B
MySQL
Raw Permalink Normal View History

2025-02-26 13:10:50 -08:00
CREATE TABLE browser_sessions (
id TEXT NOT NULL PRIMARY KEY,
2025-02-26 13:10:48 -08:00
serialized TEXT NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
2025-02-26 13:10:45 -08:00
expiry TIMESTAMPTZ
2025-02-26 13:10:50 -08:00
);
2025-02-26 13:10:45 -08:00
CREATE INDEX ON browser_sessions (expiry);
2025-02-26 13:10:48 -08:00
CREATE INDEX ON browser_sessions (created_at);