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

Module: sip-router Branch: jh/32plus Commit: 20b73cb697705de6c8d2a058fcee753015d6036e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=20b73cb… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; 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>