From a8790631e50b32c8e9b10f38f382439052b04480 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 1 Aug 2018 11:04:29 +0800
Subject: [PATCH] sql/core_group_member.sql

---
 sql/core_group_member.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
index 820b27ed..8375324a 100644
--- a/sql/core_group_member.sql
+++ b/sql/core_group_member.sql
@@ -7,4 +7,4 @@ CREATE TABLE  core_group_member  (
 ALTER TABLE core_group_member ADD COLUMN  group_id int(11) default NULL;
 ALTER TABLE core_group_member ADD COLUMN   user_id int(11) NOT NULL default 0;
 
- 
\ No newline at end of file
+ALTER TABLE ADD UNIQUE KEY `unique_group_user` (`group_id`,`user_id`);
-- 
2.39.2