diff options
| author | Paweł Chmielowski <pchmielowski@process-one.net> | 2021-05-18 18:29:32 +0200 |
|---|---|---|
| committer | Paweł Chmielowski <pchmielowski@process-one.net> | 2021-05-18 18:29:32 +0200 |
| commit | 95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a (patch) | |
| tree | 67b20230cac30258296cd4dc8bb1a08816c0d49a /sql/lite.sql | |
| parent | New simple webadmin pages to view mnesia tables information and content (diff) | |
Add missing indexes to sql sr_group tables
Diffstat (limited to '')
| -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, |