diff options
| author | YSA (OpenERP), Olivier Dony (OpenERP) <> | 2010-12-14 14:28:40 +0100 |
|---|---|---|
| committer | Olivier Dony <odo@openerp.com> | 2010-12-14 14:28:40 +0100 |
| commit | 6a3e52f41fd56f81a58919615e7dcc65e82bfa61 (patch) | |
| tree | e60ad380c1bcd0b6ccd52446dd018219f8c6f1fd /bin/addons/base/base.sql | |
| parent | b192bf4dd47c710725eb4b400da313c0612571bf (diff) | |
[FIX] orm,base: prevent useless duplication of m2m records via unique constraint + orm check
lp bug: https://launchpad.net/bugs/558658 fixed
bzr revid: odo@openerp.com-20101214132840-q7x2oodu6hez9d91
Diffstat (limited to 'bin/addons/base/base.sql')
| -rw-r--r-- | bin/addons/base/base.sql | 3 |
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); |