8 lines
163 B
SQL
8 lines
163 B
SQL
CREATE TABLE sessions (
|
|
token CHAR(43) PRIMARY KEY,
|
|
data BLOB NOT NULL,
|
|
expiry TIMESTAMP(6) NOT NULL
|
|
);
|
|
|
|
CREATE INDEX sessions_expiry_idx ON sessions (expiry);
|