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

Module: kamailio Branch: master Commit: 5409a60421a7d5cda281c0fd94cbc2bd038f0dbb URL: https://github.com/kamailio/kamailio/commit/5409a60421a7d5cda281c0fd94cbc2b… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; 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/5409a60421a7d5cda281c0fd94cbc2b… Patch: https://github.com/kamailio/kamailio/commit/5409a60421a7d5cda281c0fd94cbc2b… --- 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>