summaryrefslogtreecommitdiff
path: root/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--sql/schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql
index 51a455b..ee69906 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -13,7 +13,8 @@ CREATE TABLE users (
email TEXT NOT NULL,
department TEXT NOT NULL,
session TEXT,
- expr BIGINT -- seconds
+ expr BIGINT, -- seconds
+ confirmed BOOLEAN NOT NULL
);
CREATE TABLE choices (
PRIMARY KEY (userid, courseid),