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

[Juha Heinanen]

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

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