sql/schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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,
	session TEXT,
	expr INTEGER
);