schema.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE users (
	id TEXT PRIMARY KEY NOT NULL,
	name TEXT,
	email TEXT
);
CREATE TABLE sessions (
	userid TEXT NOT NULL,
	cookie TEXT PRIMARY KEY NOT NULL,
	expr INTEGER NOT NULL,
	FOREIGN KEY(userid) REFERENCES users(id)
);