blob: 7e3886fcd3938a4ee49a36b7ee294b52d41f3189 (
plain) (
blame)
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,
expr INTEGER,
FOREIGN KEY(userid) REFERENCES users(id)
);
|