summaryrefslogtreecommitdiff
path: root/bin/addons/base/base.sql
diff options
context:
space:
mode:
Diffstat (limited to 'bin/addons/base/base.sql')
-rw-r--r--bin/addons/base/base.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql
index 90da118f475..802e71cfeb6 100644
--- a/bin/addons/base/base.sql
+++ b/bin/addons/base/base.sql
@@ -161,7 +161,8 @@ CREATE TABLE res_groups (
CREATE TABLE res_groups_users_rel (
uid integer NOT NULL references res_users on delete cascade,
- gid integer NOT NULL references res_groups on delete cascade
+ gid integer NOT NULL references res_groups on delete cascade,
+ UNIQUE("uid","gid")
);
create index res_groups_users_rel_uid_idx on res_groups_users_rel (uid);