diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index 099e79e..d6c81bf 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -15,7 +15,7 @@ CREATE TABLE users ( expr INTEGER ); CREATE TABLE choices ( - id INTEGER GENERATED ALWAYS AS IDENTITY, + PRIMARY KEY (userid, courseid), seltime BIGINT NOT NULL, -- microseconds userid TEXT NOT NULL, courseid INTEGER NOT NULL, |