[sr-dev] git:master: lib/srdb1/schema: Updated xcap table indices

Module: sip-router Branch: master Commit: 639bda8df8ff3671e9ac14eb18f744df24f83adc URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=639bda8… Author: Peter Dunkley &lt;peter.dunkley(a)crocodile-rcs.com&gt; Committer: Peter Dunkley &lt;peter.dunkley(a)crocodile-rcs.com&gt; Date: Mon Mar 19 16:09:39 2012 +0000 lib/srdb1/schema: Updated xcap table indices - They now match the queries in the presence_xml, rls, and xcap_server modules. --- lib/srdb1/schema/pr_xcap.xml | 18 ++++++++++++++---- 1 files changed, 14 insertions(+), 4 deletions(-) diff --git a/lib/srdb1/schema/pr_xcap.xml b/lib/srdb1/schema/pr_xcap.xml index 76baa4d..ec6c126 100644 --- a/lib/srdb1/schema/pr_xcap.xml +++ b/lib/srdb1/schema/pr_xcap.xml @@ -21,7 +21,6 @@ <type>unsigned int</type> <size>&table_id_len;</size> <autoincrement/> - <primary/> <type db="dbtext">int,auto</type> <description>Unique ID</description> </column> @@ -74,6 +73,7 @@ <type>string</type> <size>&xcap_uri_len;</size> <description>Document uri</description> + <primary/> </column> <column id="port"> @@ -88,13 +88,23 @@ <colref linkend="username"/> <colref linkend="domain"/> <colref linkend="doc_type"/> - <colref linkend="doc_uri"/> <unique/> </index> <index> - <name>source_idx</name> - <colref linkend="source"/> + <name>account_doc_type_uri_idx</name> + <colref linkend="username"/> + <colref linkend="domain"/> + <colref linkend="doc_type"/> + <colref linkend="doc_uri"/> + <unique/> </index> + <index> + <name>account_doc_uri_idx</name> + <colref linkend="username"/> + <colref linkend="domain"/> + <colref linkend="doc_uri"/> + <unique/> + </index> </table>