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

Daniel-Constantin Mierla miconda at gmail.com
Tue Aug 24 09:21:47 CEST 2021


Module: kamailio
Branch: 5.5
Commit: 087167c034afff943c217b832b9689cb61133188
URL: https://github.com/kamailio/kamailio/commit/087167c034afff943c217b832b9689cb61133188

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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/087167c034afff943c217b832b9689cb61133188.diff
Patch: https://github.com/kamailio/kamailio/commit/087167c034afff943c217b832b9689cb61133188.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




More information about the sr-dev mailing list