[sr-dev] git:master:740840eb: lib/srdb1: schema - added id auto-increment column to matrix

Module: kamailio Branch: master Commit: 740840ebe9538c1a3e6e3a49d82d437602b9d91a URL: https://github.com/kamailio/kamailio/commit/740840ebe9538c1a3e6e3a49d82d437… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: 2020-05-25T11:01:52+02:00 lib/srdb1: schema - added id auto-increment column to matrix - coherence across all tables --- Modified: src/lib/srdb1/schema/matrix.xml --- Diff: https://github.com/kamailio/kamailio/commit/740840ebe9538c1a3e6e3a49d82d437… Patch: https://github.com/kamailio/kamailio/commit/740840ebe9538c1a3e6e3a49d82d437… --- diff --git a/src/lib/srdb1/schema/matrix.xml b/src/lib/srdb1/schema/matrix.xml index 748fd5cd8c..9eb58f01f2 100644 --- a/src/lib/srdb1/schema/matrix.xml +++ b/src/lib/srdb1/schema/matrix.xml @@ -21,6 +21,16 @@ </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="first"> <name>first</name> <type>int</type>