1 files changed, 2 insertions, 2 deletions
diff --git a/etc/setup.sql b/etc/setup.sql
index 5ca866f..697f2bd 100644
--- a/etc/setup.sql
+++ b/etc/setup.sql
@@ -1,9 +1,9 @@
 -- users table
 CREATE TABLE users (
 id SERIAL PRIMARY KEY,
-username varchar(50) NOT NULL,
+username varchar(50) NOT NULL UNIQUE,
 password varchar(255) NOT NULL,
-email varchar(50) NOT NULL,
+email varchar(50) NOT NULL UNIQUE,
 can_edit_bugs boolean DEFAULT true,
 can_edit_reports boolean DEFAULT true
 );