From: Alan Knowles Date: Wed, 1 Aug 2018 03:08:40 +0000 (+0800) Subject: sql/core_group_member.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=974c7d45337274e53046f6ec8c2c36765c7a8d1b sql/core_group_member.sql --- diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql index ea1ea039..25aefc84 100644 --- a/sql/core_group_member.sql +++ b/sql/core_group_member.sql @@ -9,4 +9,4 @@ ALTER TABLE core_group_member ALTER COLUMN group_id group_id int(11) NOT NULL ALTER TABLE core_group_member ADD COLUMN group_id int(11) NOT NULL default 0; ALTER TABLE core_group_member ADD COLUMN user_id int(11) NOT NULL default 0; -ALTER TABLE core_group_member ADD UNIQUE KEY `unique_group_user` (`group_id`,`user_id`); +ALTER TABLE core_group_member ADD UNIQUE KEY unique_group_user (group_id,user_id);