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

Module: sip-router Branch: master Commit: 2c1a857f08512e7008cbd15c23716e149204a06d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2c1a857… 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: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>