From a819514e43f17d1d6a996048419b3505e47d6667 Mon Sep 17 00:00:00 2001 From: Evgeniy Khramtsov Date: Wed, 15 May 2013 21:57:53 +1000 Subject: Define primary key in sr_group table --- src/odbc/mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/odbc/mysql.sql') 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; -- cgit v1.2.3