diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index ee69906..c888768 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -5,7 +5,9 @@ CREATE TABLE courses ( teacher TEXT NOT NULL, location TEXT NOT NULL, ctype TEXT NOT NULL, - cgroup TEXT NOT NULL + cgroup TEXT NOT NULL, + course_id TEXT NOT NULL, + section_id TEXT NOT NULL ); CREATE TABLE users ( id TEXT PRIMARY KEY NOT NULL, -- should be UUID |