[sr-dev] git:master: lib/srdb1/schema: Updated indices for the pua table to make them correct for DB-only mode

[Peter Dunkley]

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

Author: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
Committer: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
Date:   Mon Mar 19 16:00:39 2012 +0000

lib/srdb1/schema: Updated indices for the pua table to make them correct for DB-only mode

---

 lib/srdb1/schema/pr_pua.xml |   38 +++++++++++++++++++++++++++++++-------
 1 files changed, 31 insertions(+), 7 deletions(-)

diff --git a/lib/srdb1/schema/pr_pua.xml b/lib/srdb1/schema/pr_pua.xml
index 6a3079c..5bd690b 100644
--- a/lib/srdb1/schema/pr_pua.xml
+++ b/lib/srdb1/schema/pr_pua.xml
@@ -49,7 +49,7 @@
         <natural/>
     </column>
 
-    <column>
+    <column id="expires">
         <name>expires</name>
         <type>int</type>
         <size>&expires_len;</size>
@@ -99,7 +99,7 @@
         <description>Call ID</description>
     </column>
 
-    <column>
+    <column id="to_tag">
         <name>to_tag</name>
         <type>string</type>
         <size>&domain_len;</size>
@@ -160,23 +160,47 @@
 	<unique/>
     </index>
 
-   <index>
-        <name>presid_idx</name>
-        <colref linkend="pres_id"/>
+    <index>
+        <name>expires_idx</name>
+        <colref linkend="expires"/>
+	<unique/>
     </index>
 
     <index>
-        <name>dialog_idx</name>
+        <name>dialog1_idx</name>
         <colref linkend="call_id"/>
         <colref linkend="from_tag"/>
         <colref linkend="to_tag"/>
     </index>
 
     <index>
-        <name>tmp_dlg_idx</name>
+        <name>dialog2_idx</name>
+        <colref linkend="pres_id"/>
+        <colref linkend="pres_uri"/>
+    </index>
+
+    <index>
+        <name>tmp_dlg1_idx</name>
+        <colref linkend="call_id"/>
+        <colref linkend="from_tag"/>
+    </index>
+
+    <index>
+        <name>tmp_dlg2_idx</name>
         <colref linkend="pres_id"/>
         <colref linkend="pres_uri"/>
         <colref linkend="call_id"/>
         <colref linkend="from_tag"/>
     </index>
+
+    <index>
+        <name>tmp_record1_idx</name>
+        <colref linkend="pres_id"/>
+    </index>
+
+    <index>
+        <name>tmp_record2_idx</name>
+        <colref linkend="pres_id"/>
+        <colref linkend="etag"/>
+    </index>
 </table>