diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2013-05-15 21:57:53 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2013-05-15 21:57:53 +1000 |
| commit | a819514e43f17d1d6a996048419b3505e47d6667 (patch) | |
| tree | 0d8663198c34d4ca9f3709629a66a3e33c199496 | |
| parent | Do not make DB query on get_group_opt (part of TECH-220) (diff) | |
Define primary key in sr_group table
| -rw-r--r-- | src/odbc/mysql.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index afdf4f3d9..72f58dcd0 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/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; |