Module: sip-router Branch: sr_3.0 Commit: f82dcdb10b1867989b5a2c85a951387a2ca4f85a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f82dcdb1...

Author: Juha Heinanen jh@tutpro.com Committer: Juha Heinanen jh@tutpro.com 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>