Module: kamailio Branch: master Commit: acd42263ea1e648f2f5789f993a63de1f05f8b1b URL: https://github.com/kamailio/kamailio/commit/acd42263ea1e648f2f5789f993a63de1...
Author: Charles Chance charles.chance@sipcentric.com Committer: Charles Chance charles.chance@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/acd42263ea1e648f2f5789f993a63de1... Patch: https://github.com/kamailio/kamailio/commit/acd42263ea1e648f2f5789f993a63de1...
---
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"/>