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) );