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

Module: kamailio Branch: master Commit: 4f9e0ffc7c320666de1d139658c6b645561e217d URL: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b64… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; 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/4f9e0ffc7c320666de1d139658c6b64… Patch: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b64… --- 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>