[sr-dev] git:master:5409a604: lib/srdb1: schema - description fields and id column for version table

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 5409a60421a7d5cda281c0fd94cbc2bd038f0dbb
URL: https://github.com/kamailio/kamailio/commit/5409a60421a7d5cda281c0fd94cbc2bd038f0dbb

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2020-03-14T18:30:13+01:00

lib/srdb1: schema - description fields and id column for version table

- no change from perspective of kamailio internal usage, just coherence
across tables and easier format for management tools

---

Modified: src/lib/srdb1/schema/version.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/5409a60421a7d5cda281c0fd94cbc2bd038f0dbb.diff
Patch: https://github.com/kamailio/kamailio/commit/5409a60421a7d5cda281c0fd94cbc2bd038f0dbb.patch

---

diff --git a/src/lib/srdb1/schema/version.xml b/src/lib/srdb1/schema/version.xml
index c18ea3b0c3..42734bb2b9 100644
--- a/src/lib/srdb1/schema/version.xml
+++ b/src/lib/srdb1/schema/version.xml
@@ -10,17 +10,35 @@
     <name>version</name>
     <version>1</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
+    <description>
+		<db:para>
+			This table is used by Kamailio modules to check if the structure
+			of database tables has the expected number.
+        </db:para>
+    </description>
+
+    <column id="id">
+        <name>id</name>
+        <type>unsigned int</type>
+        <size>&table_id_len;</size>
+        <autoincrement/>
+        <primary/>
+        <type db="dbtext">int,auto</type>
+        <description>Unique ID</description>
+    </column>
 
     <column id="table_name">
         <name>table_name</name>
         <type>string</type>
         <size>32</size>
         <natural/>
+        <description>Table name</description>
     </column>
     <column id="table_version">
         <name>table_version</name>
         <type>unsigned int</type>
         <default>0</default>
+        <description>Version number</description>
     </column>
     <index>
         <name>table_name_idx</name>