df43bbbd241372f1ae8d20d32d9422aebb855c35

Author
Ayman Bagabas <ayman.bagabas@gmail.com>
Committer
Ayman Bagabas <ayman.bagabas@gmail.com>
Date

Message

fix(backend): make public key unique

Diff

 1diff --git a/server/backend/sqlite/sql.go b/server/backend/sqlite/sql.go
 2index 719c0707711133ded792eb02d6c1f807311cbbcd..34edd17f72485256186c2f7267e14da0661c437b 100644
 3--- a/server/backend/sqlite/sql.go
 4+++ b/server/backend/sqlite/sql.go
 5@@ -20,7 +20,7 @@ var (
 6 	sqlCreatePublicKeyTable = `CREATE TABLE IF NOT EXISTS public_key (
 7 		id INTEGER PRIMARY KEY AUTOINCREMENT,
 8 		user_id INTEGER NOT NULL,
 9-		public_key TEXT NOT NULL,
10+		public_key TEXT NOT NULL UNIQUE,
11 		created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 		updated_at DATETIME NOT NULL,
13 		UNIQUE (user_id, public_key),