git:5.5:087167c0: kamctl: regenerate db creation scripts - sr-dev

24 Aug 2021

Module: kamailio
Branch: 5.5
Commit: 087167c034afff943c217b832b9689cb61133188
URL: https://github.com/kamailio/kamailio/commit/087167c034afff943c217b832b9689cb...
Author: Daniel-Constantin Mierla miconda@gmail.com
Committer: Daniel-Constantin Mierla miconda@gmail.com
Date: 2021-08-24T09:06:43+02:00
kamctl: regenerate db creation scripts
(cherry picked from commit 5ad81a45bb28ca419d9285cc59816db0fa1afefd)
---
Modified: utils/kamctl/db_sqlite/siptrace-create.sql
Modified: utils/kamctl/mysql/siptrace-create.sql
Modified: utils/kamctl/oracle/siptrace-create.sql
Modified: utils/kamctl/postgres/siptrace-create.sql
---
Diff:  https://github.com/kamailio/kamailio/commit/087167c034afff943c217b832b9689cb...
Patch: https://github.com/kamailio/kamailio/commit/087167c034afff943c217b832b9689cb...
---

diff --git a/utils/kamctl/db_sqlite/siptrace-create.sql b/utils/kamctl/db_sqlite/siptrace-create.sql
index 2860d0a4e2..7f847816fd 100644
--- a/utils/kamctl/db_sqlite/siptrace-create.sql
+++ b/utils/kamctl/db_sqlite/siptrace-create.sql
@@ -7,8 +7,8 @@ CREATE TABLE sip_trace (
     msg TEXT NOT NULL,
     method VARCHAR(50) DEFAULT '' NOT NULL,
     status VARCHAR(255) DEFAULT '' NOT NULL,
-    fromip VARCHAR(50) DEFAULT '' NOT NULL,
-    toip VARCHAR(50) DEFAULT '' NOT NULL,
+    fromip VARCHAR(64) DEFAULT '' NOT NULL,
+    toip VARCHAR(64) DEFAULT '' NOT NULL,
     fromtag VARCHAR(128) DEFAULT '' NOT NULL,
     totag VARCHAR(128) DEFAULT '' NOT NULL,
     direction VARCHAR(4) DEFAULT '' NOT NULL
diff --git a/utils/kamctl/mysql/siptrace-create.sql b/utils/kamctl/mysql/siptrace-create.sql
index bd08a8a49f..c74913c0e2 100644
--- a/utils/kamctl/mysql/siptrace-create.sql
+++ b/utils/kamctl/mysql/siptrace-create.sql
@@ -7,8 +7,8 @@ CREATE TABLE `sip_trace` (
     `msg` MEDIUMTEXT NOT NULL,
     `method` VARCHAR(50) DEFAULT '' NOT NULL,
     `status` VARCHAR(255) DEFAULT '' NOT NULL,
-    `fromip` VARCHAR(50) DEFAULT '' NOT NULL,
-    `toip` VARCHAR(50) DEFAULT '' NOT NULL,
+    `fromip` VARCHAR(64) DEFAULT '' NOT NULL,
+    `toip` VARCHAR(64) DEFAULT '' NOT NULL,
     `fromtag` VARCHAR(128) DEFAULT '' NOT NULL,
     `totag` VARCHAR(128) DEFAULT '' NOT NULL,
     `direction` VARCHAR(4) DEFAULT '' NOT NULL
diff --git a/utils/kamctl/oracle/siptrace-create.sql b/utils/kamctl/oracle/siptrace-create.sql
index 4b4dc62939..38f0681864 100644
--- a/utils/kamctl/oracle/siptrace-create.sql
+++ b/utils/kamctl/oracle/siptrace-create.sql
@@ -7,8 +7,8 @@ CREATE TABLE sip_trace (
     msg CLOB,
     method VARCHAR2(50) DEFAULT '',
     status VARCHAR2(255) DEFAULT '',
-    fromip VARCHAR2(50) DEFAULT '',
-    toip VARCHAR2(50) DEFAULT '',
+    fromip VARCHAR2(64) DEFAULT '',
+    toip VARCHAR2(64) DEFAULT '',
     fromtag VARCHAR2(128) DEFAULT '',
     totag VARCHAR2(128) DEFAULT '',
     direction VARCHAR2(4) DEFAULT ''
diff --git a/utils/kamctl/postgres/siptrace-create.sql b/utils/kamctl/postgres/siptrace-create.sql
index b3ea989ce8..3b7cd461b5 100644
--- a/utils/kamctl/postgres/siptrace-create.sql
+++ b/utils/kamctl/postgres/siptrace-create.sql
@@ -7,8 +7,8 @@ CREATE TABLE sip_trace (
     msg TEXT NOT NULL,
     method VARCHAR(50) DEFAULT '' NOT NULL,
     status VARCHAR(255) DEFAULT '' NOT NULL,
-    fromip VARCHAR(50) DEFAULT '' NOT NULL,
-    toip VARCHAR(50) DEFAULT '' NOT NULL,
+    fromip VARCHAR(64) DEFAULT '' NOT NULL,
+    toip VARCHAR(64) DEFAULT '' NOT NULL,
     fromtag VARCHAR(128) DEFAULT '' NOT NULL,
     totag VARCHAR(128) DEFAULT '' NOT NULL,
     direction VARCHAR(4) DEFAULT '' NOT NULL

    