Module: kamailio Branch: master Commit: 4f9e0ffc7c320666de1d139658c6b645561e217d URL: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b645...
Author: Juha Heinanen jh@tutpro.com Committer: Juha Heinanen jh@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/4f9e0ffc7c320666de1d139658c6b645... Patch: https://github.com/kamailio/kamailio/commit/4f9e0ffc7c320666de1d139658c6b645...
---
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>