diff options
Diffstat (limited to 'sql/mysql.sql')
| -rw-r--r-- | sql/mysql.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 9583aeb2d..33ef98d30 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -68,6 +68,8 @@ CREATE TABLE sr_group ( created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +CREATE UNIQUE INDEX i_sr_group_name ON sr_group(name); + CREATE TABLE sr_user ( jid varchar(191) NOT NULL, grp varchar(191) NOT NULL, |