[sr-dev] git:master: srdb1: drop unique constrant on alias user+domain in dbaliases

Module: sip-router Branch: master Commit: ecc6e35b31d59e6e9995a03c6ab00f21a23b1be9 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ecc6e35… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: Tue Oct 29 11:07:03 2013 +0100 srdb1: drop unique constrant on alias user+domain in dbaliases - it doesn't work for multiple branches when use_domain is set, reported by Vassilis Radis --- lib/srdb1/schema/dbaliases.xml | 11 +++++++++-- 1 files changed, 9 insertions(+), 2 deletions(-) diff --git a/lib/srdb1/schema/dbaliases.xml b/lib/srdb1/schema/dbaliases.xml index 04c2c03..12078e3 100644 --- a/lib/srdb1/schema/dbaliases.xml +++ b/lib/srdb1/schema/dbaliases.xml @@ -12,7 +12,10 @@ <version>1</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> - <db:para>This table us used by the alias_db module as an alternative for user aliases via userloc. More information about the alias_db module can be found at: &KAMAILIO_MOD_DOC;alias_db.html + <db:para>This table us used by the alias_db module as an + alternative for user aliases via userloc. More information + about the alias_db module can be found at: + &KAMAILIO_MOD_DOC;alias_db.html </db:para> </description> @@ -61,10 +64,14 @@ </column> <index> + <name>alias_user_idx</name> + <colref linkend="alias_username"/> + </index> + + <index> <name>alias_idx</name> <colref linkend="alias_username"/> <colref linkend="alias_domain"/> - <unique/> </index> <index>