[sr-dev] git:sr_3.0: lib/srdb1/schema/gw.xml: index changes

Module: sip-router Branch: sr_3.0 Commit: f82dcdb10b1867989b5a2c85a951387a2ca4f85a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f82dcdb… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; Date: Thu Oct 29 10:38:56 2009 +0200 lib/srdb1/schema/gw.xml: index changes - Added grp_id to existing gw_name index. - Added new ip_addr index. --- lib/srdb1/schema/gw.xml | 11 ++++++++++- 1 files changed, 10 insertions(+), 1 deletions(-) diff --git a/lib/srdb1/schema/gw.xml b/lib/srdb1/schema/gw.xml index 842c9c8..bb2c354 100644 --- a/lib/srdb1/schema/gw.xml +++ b/lib/srdb1/schema/gw.xml @@ -122,10 +122,19 @@ </column> <index> - <name>lcr_id_gw_name_idx</name> + <name>lcr_id_grp_id_gw_name_idx</name> <colref linkend="lcr_id"/> + <colref linkend="grp_id"/> <colref linkend="gw_name"/> <unique/> </index> + <index> + <name>lcr_id_grp_id_ip_addr_idx</name> + <colref linkend="lcr_id"/> + <colref linkend="grp_id"/> + <colref linkend="ip_addr"/> + <unique/> + </index> + </table>