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

Peter Dunkley peter.dunkley at crocodile-rcs.com
Mon Mar 19 17:12:40 CET 2012


Module: sip-router
Branch: master
Commit: 639bda8df8ff3671e9ac14eb18f744df24f83adc
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=639bda8df8ff3671e9ac14eb18f744df24f83adc

Author: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
Committer: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
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>




More information about the sr-dev mailing list