From 95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Pawe=C5=82=20Chmielowski?= <pchmielowski@process-one.net>
Date: Tue, 18 May 2021 18:29:32 +0200
Subject: Add missing indexes to sql sr_group tables

---
 sql/lite.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'sql/lite.sql')

diff --git a/sql/lite.sql b/sql/lite.sql
index 445d29957..087035d7f 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -65,6 +65,8 @@ CREATE TABLE sr_group (
     created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
+CREATE UNIQUE INDEX i_sr_group_name ON sr_group (name);
+
 CREATE TABLE sr_user (
     jid text NOT NULL,
     grp text NOT NULL,
-- 
cgit v1.2.3

