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

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Tue Sep 11 09:00:10 2012 +0200

lib/srdb1: added unique constraint on ruid for location table

---

 lib/srdb1/schema/location.xml |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml
index 91e421e..fc1c8e7 100644
--- a/lib/srdb1/schema/location.xml
+++ b/lib/srdb1/schema/location.xml
@@ -186,5 +186,11 @@
         <colref linkend="domain"/>
         <colref linkend="contact"/>
     </index>
+    <index>
+        <name>ruid_idx</name>
+        <colref linkend="ruid"/>
+        <unique/>
+    </index>
+
 
 </table>