Index: db-scripts/ddl.sql
===================================================================
--- db-scripts/ddl.sql	(revision c4c43f36be9f46e4a3e8aaf7198b6db598eb6d5d)
+++ db-scripts/ddl.sql	(revision 37307aadda57d1e5b86180b9b2b8a6318ec36095)
@@ -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
 );