[sr-dev] git:master: lib/srdb1: added unique constraint on ruid for aliases table

Module: sip-router Branch: master Commit: fd911bbfdc82fc41312e2b4466e71ccd24bc5ee2 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=fd911bb… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: Tue Sep 11 09:02:34 2012 +0200 lib/srdb1: added unique constraint on ruid for aliases table --- lib/srdb1/schema/aliases.xml | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/lib/srdb1/schema/aliases.xml b/lib/srdb1/schema/aliases.xml index fe7df18..29975de 100644 --- a/lib/srdb1/schema/aliases.xml +++ b/lib/srdb1/schema/aliases.xml @@ -186,5 +186,10 @@ <colref linkend="domain"/> <colref linkend="contact"/> </index> + <index> + <name>ruid_idx</name> + <colref linkend="ruid"/> + <unique/> + </index> </table>