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