1 files changed, 7 insertions, 0 deletions
diff --git a/src/database/users.rs b/src/database/users.rs
index 8045bc4..15565f1 100644
--- a/src/database/users.rs
+++ b/src/database/users.rs
@@ -21,6 +21,13 @@ pub fn init() -> Result<(), rusqlite::Error> {
     ";
     let conn = database::connect()?;
     conn.execute(sql, ())?;
+
+    let sql2 = "CREATE UNIQUE INDEX IF NOT EXISTS emails on users (email);";
+    conn.execute(sql2, ())?;
+
+    let sql3 = "CREATE UNIQUE INDEX IF NOT EXISTS passwords on users (password);";
+    conn.execute(sql3, ())?;
+
     Ok(())
 }