[sr-dev] git:master: srdb1: table_name set to unique constraint in version table

Module: sip-router Branch: master Commit: 886a0659449bc03bd7c5e852fe6ba29a17ad923d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=886a065… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: Sun Sep 2 13:08:53 2012 +0200 srdb1: table_name set to unique constraint in version table --- lib/srdb1/schema/version.xml | 9 +++++++-- 1 files changed, 7 insertions(+), 2 deletions(-) diff --git a/lib/srdb1/schema/version.xml b/lib/srdb1/schema/version.xml index ae3c615..298f32a 100644 --- a/lib/srdb1/schema/version.xml +++ b/lib/srdb1/schema/version.xml @@ -10,15 +10,20 @@ <name>version</name> <type db="mysql">&MYSQL_TABLE_TYPE;</type> - <column id="tn"> + <column id="table_name"> <name>table_name</name> <type>string</type> <size>32</size> <natural/> </column> - <column id="tv"> + <column id="table_version"> <name>table_version</name> <type>unsigned int</type> <default>0</default> </column> + <index> + <name>table_name_idx</name> + <colref linkend="table_name"/> + <unique/> + </index> </table>