ratchet/20_sessions.up.sql at main - ratchet - Git Runcible

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

7 lines

149 B

SQL

Raw Permalink Blame History

 CREATE TABLE sessions (
 	token TEXT PRIMARY KEY,
 	data BLOB NOT NULL,
 	expiry REAL NOT NULL
 );
 CREATE INDEX sessions_expiry_idx ON sessions(expiry);