blob: 7bfb9d0d91f8ee8f5faff8ed1f898dcd2417b31e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE courses (
id INTEGER PRIMARY KEY,
nmax INTEGER NOT NULL,
title TEXT,
ctype TEXT,
teacher TEXT,
location TEXT
);
CREATE TABLE users (
id TEXT PRIMARY KEY NOT NULL,
name TEXT,
email TEXT,
department TEXT
);
CREATE TABLE sessions (
cookie TEXT PRIMARY KEY NOT NULL,
userid TEXT NOT NULL,
expr INTEGER NOT NULL,
FOREIGN KEY(userid) REFERENCES users(id)
);
|
