[sr-dev] git:master:117051c6: lib/srdb1: added entities to define the size for event and etag columns

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 117051c695c815ab40b34c21c852a34386022116
URL: https://github.com/kamailio/kamailio/commit/117051c695c815ab40b34c21c852a34386022116

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2018-11-15T09:34:26+01:00

lib/srdb1: added entities to define the size for event and etag columns

- etag column size set to 128 (it was 64, but some UAs generate a longer
one)

---

Modified: src/lib/srdb1/schema/entities.xml
Modified: src/lib/srdb1/schema/pr_presentity.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/117051c695c815ab40b34c21c852a34386022116.diff
Patch: https://github.com/kamailio/kamailio/commit/117051c695c815ab40b34c21c852a34386022116.patch

---

diff --git a/src/lib/srdb1/schema/entities.xml b/src/lib/srdb1/schema/entities.xml
index 506771361b..819fa74c3a 100644
--- a/src/lib/srdb1/schema/entities.xml
+++ b/src/lib/srdb1/schema/entities.xml
@@ -22,6 +22,8 @@
 <!ENTITY expires_len "11">
 <!ENTITY flag_len "11">
 <!ENTITY description_len "255">
+<!ENTITY event_len "64">
+<!ENTITY etag_len "128">
 <!ENTITY MYSQL_TABLE_TYPE "">
 <!ENTITY USERCOL "username">
 <!ENTITY DEFAULT_ALIASES_EXPIRES "2030-05-28 21:32:15">
diff --git a/src/lib/srdb1/schema/pr_presentity.xml b/src/lib/srdb1/schema/pr_presentity.xml
index d06a1361e4..56a8044c23 100644
--- a/src/lib/srdb1/schema/pr_presentity.xml
+++ b/src/lib/srdb1/schema/pr_presentity.xml
@@ -51,7 +51,7 @@
     <column id="event">
         <name>event</name>
         <type>string</type>
-        <size>&user_len;</size>
+        <size>&event_len;</size>
         <description>Event</description>
         <natural/>
     </column>
@@ -59,8 +59,8 @@
     <column id="etag">
         <name>etag</name>
         <type>string</type>
-        <size>&user_len;</size>
-        <description>User name</description>
+        <size>&etag_len;</size>
+        <description>Etag attribute</description>
     </column>
 
     <column id="expires">