diff options
Diffstat (limited to 'sql/pg.sql')
| -rw-r--r-- | sql/pg.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index 079221c27..0e3d4c8b8 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -69,6 +69,8 @@ CREATE TABLE sr_group ( created_at TIMESTAMP NOT NULL DEFAULT now() ); +CREATE UNIQUE INDEX i_sr_group_name ON sr_group USING btree (name); + CREATE TABLE sr_user ( jid text NOT NULL, grp text NOT NULL, |