Module: kamailio Branch: master Commit: acd42263ea1e648f2f5789f993a63de1f05f8b1b URL: https://github.com/kamailio/kamailio/commit/acd42263ea1e648f2f5789f993a63de… Author: Charles Chance &lt;charles.chance(a)sipcentric.com&gt; Committer: Charles Chance &lt;charles.chance(a)sipcentric.com&gt; 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/acd42263ea1e648f2f5789f993a63de… Patch: https://github.com/kamailio/kamailio/commit/acd42263ea1e648f2f5789f993a63de… --- 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"/>