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

[Daniel-Constantin Mierla]

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

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