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 &lt;peter.dunkley(a)crocodile-rcs.com&gt; Committer: Peter Dunkley &lt;peter.dunkley(a)crocodile-rcs.com&gt; 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>