[sr-dev] git:jh/32plus DELETED: lib/srdb1/schema/mtrees.xml: schema upgrade

[Juha Heinanen]

Module: sip-router
Branch: jh/32plus DELETED
Commit: 20b73cb697705de6c8d2a058fcee753015d6036e
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=20b73cb697705de6c8d2a058fcee753015d6036e

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at tutpro.com>
Date:   Fri Sep 30 11:37:11 2011 +0300

lib/srdb1/schema/mtrees.xml: schema upgrade

- Added tvalue to unique index, because each prefix can now be
  associated with more than one value.

---

 lib/srdb1/schema/mtrees.xml |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/lib/srdb1/schema/mtrees.xml b/lib/srdb1/schema/mtrees.xml
index fb3e3f9..eb3f1ab 100644
--- a/lib/srdb1/schema/mtrees.xml
+++ b/lib/srdb1/schema/mtrees.xml
@@ -9,7 +9,7 @@
 
 <table id="mtrees" xmlns:db="http://docbook.org/ns/docbook">
     <name>mtrees</name>
-    <version>1</version>
+    <version>2</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
     <description>
         <db:para>This table is used by the mtree module to load values in shared memory trees at start up. More information about the mtree module can be found at: &KAMAILIO_MOD_DOC;mtree.html
@@ -51,9 +51,10 @@
     </column>
 
     <index>
-        <name>tname_tprefix_idx</name>
+        <name>tname_tprefix_tvalue_idx</name>
         <colref linkend="tname"/>
         <colref linkend="tprefix"/>
+        <colref linkend="tvalue"/>
         <unique/>
     </index>