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