[sr-dev] git:master:b8e9d269: lib/srdb1: make (setid, url) unique key instead of primary

Module: kamailio Branch: master Commit: b8e9d2697a13c2cdb367aabf4966d6fa09a1319f URL: https://github.com/kamailio/kamailio/commit/b8e9d2697a13c2cdb367aabf4966d6f… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: 2017-07-11T12:35:27+02:00 lib/srdb1: make (setid,url) unique key instead of primary - conflicts with autoincrement in mysql --- Modified: src/lib/srdb1/schema/rtpengine.xml --- Diff: https://github.com/kamailio/kamailio/commit/b8e9d2697a13c2cdb367aabf4966d6f… Patch: https://github.com/kamailio/kamailio/commit/b8e9d2697a13c2cdb367aabf4966d6f… --- diff --git a/src/lib/srdb1/schema/rtpengine.xml b/src/lib/srdb1/schema/rtpengine.xml index 02ba2afcac..64444606aa 100644 --- a/src/lib/srdb1/schema/rtpengine.xml +++ b/src/lib/srdb1/schema/rtpengine.xml @@ -37,7 +37,7 @@ <column id="setid"> <name>setid</name> <type>unsigned int</type> - <size>10</size> + <size>10</size> <description>RTPEngine instance set ID</description> <default>0</default> <natural/> @@ -80,7 +80,7 @@ <name>rtpengine_nodes</name> <colref linkend="setid"/> <colref linkend="url"/> - <primary/> + <unique/> </index> </table>