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

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
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>