From 3d71da490947aacc52a3b77efdc13d5f0458c57f Mon Sep 17 00:00:00 2001 From: Tyler Murphy Date: Sun, 12 Feb 2023 14:11:50 -0500 Subject: refactor --- src/database/users.rs | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'src/database/users.rs') 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(()) } -- cgit v1.2.3-freya