diff options
Diffstat (limited to 'sql/mysql.sql')
-rw-r--r-- | sql/mysql.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index afdf4f3d9..72f58dcd0 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -60,7 +60,7 @@ CREATE TABLE rostergroups ( CREATE INDEX pk_rosterg_user_jid ON rostergroups(username(75), jid(75)); CREATE TABLE sr_group ( - name varchar(250) NOT NULL, + name varchar(250) NOT NULL PRIMARY KEY, opts text NOT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) CHARACTER SET utf8; |