[sr-dev] git:master: lib/srdb1/schema/lcr_gw.xml: updated table index

[Juha Heinanen]

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

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at tutpro.com>
Date:   Sat May 14 11:24:11 2011 +0300

lib/srdb1/schema/lcr_gw.xml:  updated table index
- lcr gw lcr_id, ip_addr, port, hostname do not need to be unique

---

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

diff --git a/lib/srdb1/schema/lcr_gw.xml b/lib/srdb1/schema/lcr_gw.xml
index b34cb5d..273d03a 100644
--- a/lib/srdb1/schema/lcr_gw.xml
+++ b/lib/srdb1/schema/lcr_gw.xml
@@ -129,12 +129,8 @@
     </column>
 
     <index>
-        <name>lcr_id_ip_addr_port_hostname_idx</name>
+        <name>lcr_id_idx</name>
         <colref linkend="lcr_id"/>
-        <colref linkend="ip_addr"/>
-        <colref linkend="port"/>
-        <colref linkend="hostname"/>
-        <unique/>
     </index>
 
 </table>