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

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
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/b8e9d2697a13c2cdb367aabf4966d6fa09a1319f.diff
Patch: https://github.com/kamailio/kamailio/commit/b8e9d2697a13c2cdb367aabf4966d6fa09a1319f.patch

---

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>