From a819514e43f17d1d6a996048419b3505e47d6667 Mon Sep 17 00:00:00 2001
From: Evgeniy Khramtsov <ekhramtsov@process-one.net>
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

