diff options
Diffstat (limited to 'sql/lite.sql')
| -rw-r--r-- | sql/lite.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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, |