blob: 06f409101160842bfdcb8956c73f1abf0c841c50 (
plain) (
blame)
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
);
|