[sr-dev] git:master:5ad81a45: kamctl: regenerate db creation scripts

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2021-08-23T20:46:12+02:00

kamctl: regenerate db creation scripts

---

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/5ad81a45bb28ca419d9285cc59816db0fa1afefd.diff
Patch: https://github.com/kamailio/kamailio/commit/5ad81a45bb28ca419d9285cc59816db0fa1afefd.patch

---

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