Add UNIQUE constraint for `alias` on `servers` table

1 files changed, 2 insertions, 1 deletions

diff --git a/src/Database.py b/src/Database.py
index c498b4a8..f1563ac0 100644
--- a/src/Database.py
+++ b/src/Database.py
@@ -346,7 +346,8 @@ class Database(object):
             self.execute("""CREATE TABLE servers
                 (server_id INTEGER PRIMARY KEY, alias TEXT, hostname TEXT,
                 port INTEGER, password TEXT, ipv4 BOOLEAN, tls BOOLEAN,
-                bindhost TEXT, nickname TEXT, username TEXT, realname TEXT)""")
+                bindhost TEXT, nickname TEXT, username TEXT, realname TEXT,
+                UNIQUE (alias))""")
     def make_channels_table(self):
         if not self.has_table("channels"):
             self.execute("""CREATE TABLE channels