[sr-dev] git:master:a1afff1d: lib/srdb1: schema - create index on tcp connection for location

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2021-09-14T09:14:40+02:00

lib/srdb1: schema - create index on tcp connection for location

---

Modified: src/lib/srdb1/schema/location.xml

---

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

---

diff --git a/src/lib/srdb1/schema/location.xml b/src/lib/srdb1/schema/location.xml
index 7ca7d29af4..55ebb6f83c 100644
--- a/src/lib/srdb1/schema/location.xml
+++ b/src/lib/srdb1/schema/location.xml
@@ -236,6 +236,10 @@
         <name>expires_idx</name>
         <colref linkend="expires"/>
     </index>
+    <index>
+        <name>tcpcon_idx</name>
+        <colref linkend="connection_id"/>
+    </index>
     <index>
         <name>connection_idx</name>
         <colref linkend="server_id"/>