1 files changed, 9 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql
index 06f4091..099e79e 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -1,5 +1,5 @@
 CREATE TABLE courses (
-	id INTEGER PRIMARY KEY,
+	id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
 	nmax INTEGER NOT NULL,
 	title TEXT,
 	ctype TEXT,
@@ -14,3 +14,11 @@ CREATE TABLE users (
 	session TEXT,
 	expr INTEGER
 );
+CREATE TABLE choices (
+	id INTEGER GENERATED ALWAYS AS IDENTITY,
+	seltime BIGINT NOT NULL, -- microseconds
+	userid TEXT NOT NULL,
+	courseid INTEGER NOT NULL,
+	FOREIGN KEY(userid) REFERENCES users(id),
+	FOREIGN KEY(courseid) REFERENCES courses(id)
+);