X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_group_member.sql;h=8375324ae15b0f84a64a18cef63624f1d40b3d95;hb=a8790631e50b32c8e9b10f38f382439052b04480;hp=820b27ed853332062a806e49567e43ec7dc51868;hpb=bf845868bfc3101051f40912f3b440431ba79d82;p=Pman.Core 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`);