|
From: SourceForge.net <no...@so...> - 2009-05-03 13:20:43
|
Feature Requests item #2786079, was opened at 2009-05-03 15:20 Message generated for change (Tracker Item Submitted) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2786079&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: add unique index on domain_admins(username, domain) Initial Comment: The domain_admins table should have an UNIQUE index on (username, domain). In theory adding this index shouldn't break anything because our program logic (hopefully) avoids duplicates already, but in practise I'd like to do this after the 2.3 release ;-) Query for MySQL: ALTER TABLE `domain_admins` ADD UNIQUE `username_domain` ( `username` , `domain` ) @GingerDog: What's the query for PgSQL? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2786079&group_id=191583 |
