[sr-dev] git:master:a4201bce: Merge pull request #1355 from sergey-vb/master

[GitHub]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: GitHub <noreply at github.com>
Date: 2017-12-08T08:17:49+01:00

Merge pull request #1355 from sergey-vb/master

schema: add indexes to topos Mysql tables

---

Modified: src/lib/srdb1/schema/topos_d.xml
Modified: src/lib/srdb1/schema/topos_t.xml

---

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

---

diff --git a/src/lib/srdb1/schema/topos_d.xml b/src/lib/srdb1/schema/topos_d.xml
index 85984faf9c..5b13333d62 100644
--- a/src/lib/srdb1/schema/topos_d.xml
+++ b/src/lib/srdb1/schema/topos_d.xml
@@ -225,4 +225,14 @@
         <colref linkend="a_callid"/>
     </index>
 
+    <index>
+        <name>a_uuid_idx</name>
+        <colref linkend="a_uuid"/>
+    </index>
+
+    <index>
+        <name>b_uuid_idx</name>
+        <colref linkend="b_uuid"/>
+    </index>
+
 </table>
diff --git a/src/lib/srdb1/schema/topos_t.xml b/src/lib/srdb1/schema/topos_t.xml
index 793fed4d1e..c6bc095aeb 100644
--- a/src/lib/srdb1/schema/topos_t.xml
+++ b/src/lib/srdb1/schema/topos_t.xml
@@ -232,4 +232,14 @@
         <colref linkend="a_callid"/>
     </index>
 
+    <index>
+        <name>x_vbranch_idx</name>
+        <colref linkend="x_vbranch"/>
+    </index>
+
+    <index>
+        <name>a_uuid_idx</name>
+        <colref linkend="a_uuid"/>
+    </index>
+
 </table>