[sr-dev] git:master:5ce0020f: lib/srdb1: schema - defined entities for sizes of aname and avalue columns

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 5ce0020f25b4131e5b122df3d075eeb68626b470
URL: https://github.com/kamailio/kamailio/commit/5ce0020f25b4131e5b122df3d075eeb68626b470

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2018-11-19T12:49:13+01:00

lib/srdb1: schema - defined entities for sizes of aname and avalue columns

- avalue column size set to 512
- GH #1723

---

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

---

Diff:  https://github.com/kamailio/kamailio/commit/5ce0020f25b4131e5b122df3d075eeb68626b470.diff
Patch: https://github.com/kamailio/kamailio/commit/5ce0020f25b4131e5b122df3d075eeb68626b470.patch

---

diff --git a/src/lib/srdb1/schema/entities.xml b/src/lib/srdb1/schema/entities.xml
index 819fa74c3a..2bfe39540f 100644
--- a/src/lib/srdb1/schema/entities.xml
+++ b/src/lib/srdb1/schema/entities.xml
@@ -24,6 +24,8 @@
 <!ENTITY description_len "255">
 <!ENTITY event_len "64">
 <!ENTITY etag_len "128">
+<!ENTITY aname_len "64">
+<!ENTITY avalue_len "512">
 <!ENTITY MYSQL_TABLE_TYPE "">
 <!ENTITY USERCOL "username">
 <!ENTITY DEFAULT_ALIASES_EXPIRES "2030-05-28 21:32:15">
diff --git a/src/lib/srdb1/schema/location_attrs.xml b/src/lib/srdb1/schema/location_attrs.xml
index 9e62e39ce0..24bf14e2eb 100644
--- a/src/lib/srdb1/schema/location_attrs.xml
+++ b/src/lib/srdb1/schema/location_attrs.xml
@@ -63,7 +63,7 @@
     <column>
         <name>aname</name>
         <type>string</type>
-        <size>64</size>
+        <size>&aname_len;</size>
 		<default/>
         <description>Attribute name.</description>
     </column>
@@ -79,7 +79,7 @@
     <column>
         <name>avalue</name>
         <type>string</type>
-        <size>255</size>
+        <size>&avalue_len;</size>
         <default/>
         <description>Attribute value.</description>
     </column>