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

[Daniel-Constantin Mierla]

Module: sip-router
Branch: master
Commit: fd911bbfdc82fc41312e2b4466e71ccd24bc5ee2
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=fd911bbfdc82fc41312e2b4466e71ccd24bc5ee2

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
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>