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

Module: sip-router Branch: master Commit: d9618529abfe7cea53eeda8f5d09cf76e7920a85 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d961852… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; 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>