Index: db-scripts/ddl.sql
===================================================================
--- db-scripts/ddl.sql	(revision c4c43f36be9f46e4a3e8aaf7198b6db598eb6d5d)
+++ db-scripts/ddl.sql	(revision 89156c1feb4b06a2d4ecb2bbac89f7c39f0df7e2)
@@ -21,6 +21,6 @@
 CREATE TABLE USERS (
     user_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
-    email TEXT NOT NULL,
-    username TEXT NOT NULL,
+    email TEXT NOT NULL UNIQUE,
+    username TEXT NOT NULL UNIQUE,
     password TEXT NOT NULL
 );