[sr-dev] git:master:acd42263: schema: add ruid column to presentity table

[Charles Chance]

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

Author: Charles Chance <charles.chance at sipcentric.com>
Committer: Charles Chance <charles.chance at sipcentric.com>
Date: 2018-01-24T14:19:20Z

schema: add ruid column to presentity table

---

Modified: src/lib/srdb1/schema/pr_presentity.xml

---

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

---

diff --git a/src/lib/srdb1/schema/pr_presentity.xml b/src/lib/srdb1/schema/pr_presentity.xml
index c994a62c9c..3d525f7f92 100644
--- a/src/lib/srdb1/schema/pr_presentity.xml
+++ b/src/lib/srdb1/schema/pr_presentity.xml
@@ -9,7 +9,7 @@
 
 <table id="presentity" xmlns:db="http://docbook.org/ns/docbook">
     <name>presentity</name>
-    <version>4</version>
+    <version>5</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
     <description>
 		<db:para>
@@ -98,6 +98,14 @@
         <description>Priority of the record</description>
 	</column>
 
+    <column id="ruid">
+        <name>ruid</name>
+        <type>string</type>
+        <size>64</size>
+        <null/>
+        <description>Record internal unique id</description>
+    </column>
+
     <index>
         <name>presentity_idx</name>
         <colref linkend="username"/>
@@ -107,6 +115,12 @@
         <unique/>
     </index>
 
+    <index>
+        <name>ruid_idx</name>
+        <colref linkend="ruid"/>
+        <unique/>
+    </index>
+
     <index>
         <name>presentity_expires</name>
         <colref linkend="expires"/>