[sr-dev] git:master:0eea31b4: lib/srdb1: schema - don't set default value for text/blob columns of topos

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 0eea31b4b934de45e8bc5091f7ba5a9d486dd16f
URL: https://github.com/kamailio/kamailio/commit/0eea31b4b934de45e8bc5091f7ba5a9d486dd16f

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2016-11-24T17:49:28+01:00

lib/srdb1: schema - don't set default value for text/blob columns of topos

- not allowed by newer versions of mysql

---

Modified: lib/srdb1/schema/topos_d.xml
Modified: lib/srdb1/schema/topos_t.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/0eea31b4b934de45e8bc5091f7ba5a9d486dd16f.diff
Patch: https://github.com/kamailio/kamailio/commit/0eea31b4b934de45e8bc5091f7ba5a9d486dd16f.patch

---

diff --git a/lib/srdb1/schema/topos_d.xml b/lib/srdb1/schema/topos_d.xml
index cf62889..1f7fd35 100644
--- a/lib/srdb1/schema/topos_d.xml
+++ b/lib/srdb1/schema/topos_d.xml
@@ -128,21 +128,21 @@
    <column id="a_rr">
         <name>a_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>Record route - A side</description>
 	</column>
 
     <column id="b_rr">
         <name>b_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>Record route - B side</description>
     </column>
 
     <column id="s_rr">
         <name>s_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>Record route - S side</description>
     </column>
 
diff --git a/lib/srdb1/schema/topos_t.xml b/lib/srdb1/schema/topos_t.xml
index 86fcb2f..e3978f0 100644
--- a/lib/srdb1/schema/topos_t.xml
+++ b/lib/srdb1/schema/topos_t.xml
@@ -88,7 +88,7 @@
     <column id="x_via">
         <name>x_via</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>Via stack - A or B side</description>
     </column>
 
@@ -104,21 +104,21 @@
     <column id="x_rr">
         <name>x_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>RR stack - incoming A or B side</description>
 	</column>
 
     <column id="y_rr">
         <name>y_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>RR stack - the other A or B side</description>
 	</column>
 
    <column id="s_rr">
         <name>s_rr</name>
         <type>largetext</type>
-        <default/>
+        <null/>
         <description>RR stack - the S side</description>
 	</column>