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

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 740840ebe9538c1a3e6e3a49d82d437602b9d91a
URL: https://github.com/kamailio/kamailio/commit/740840ebe9538c1a3e6e3a49d82d437602b9d91a

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
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/740840ebe9538c1a3e6e3a49d82d437602b9d91a.diff
Patch: https://github.com/kamailio/kamailio/commit/740840ebe9538c1a3e6e3a49d82d437602b9d91a.patch

---

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>