[sr-dev] git:master:4f9e0ffc: srdb1/schema: added connection_idx index to location table

[Juha Heinanen]

Module: kamailio
Branch: master
Commit: 4f9e0ffc7c320666de1d139658c6b645561e217d
URL: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b645561e217d

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at tutpro.com>
Date: 2016-03-01T09:46:52+02:00

srdb1/schema: added connection_idx index to location table

---

Modified: lib/srdb1/schema/location.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b645561e217d.diff
Patch: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b645561e217d.patch

---

diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml
index 698fcc0..07c8d58 100644
--- a/lib/srdb1/schema/location.xml
+++ b/lib/srdb1/schema/location.xml
@@ -179,7 +179,7 @@
         <description>The value of reg-id contact parameter</description>
     </column>
 
-    <column>
+    <column id="server_id">
         <name>server_id</name>
         <type>int</type>
         <size>11</size>
@@ -187,7 +187,7 @@
         <description>The value of server_id from configuration file</description>
     </column>
 
-    <column>
+    <column id="connection_id">
         <name>connection_id</name>
         <type>int</type>
         <size>11</size>
@@ -228,6 +228,12 @@
         <name>expires_idx</name>
         <colref linkend="expires"/>
     </index>
+    <index>
+        <name>connection_idx</name>
+        <colref linkend="server_id"/>
+        <colref linkend="connection_id"/>
+        <unique/>
+    </index>
 
 
 </table>