19 Mar
2012
19 Mar
'12
12:12 p.m.
Module: sip-router
Branch: master
Commit: 676f44ae04bf858722733d86f937b7a1b0b44177
URL:
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=676f44a…
Author: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com>
Committer: Peter Dunkley <peter.dunkley(a)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>