[sr-dev] git:master:aaabbc1a: kamctl: new update to the sql creation scripts

Daniel-Constantin Mierla miconda at gmail.com
Thu Nov 15 09:37:55 CET 2018


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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2018-11-15T09:37:04+01:00

kamctl: new update to the sql creation scripts

---

Modified: utils/kamctl/db_sqlite/presence-create.sql
Modified: utils/kamctl/mysql/presence-create.sql
Modified: utils/kamctl/oracle/presence-create.sql
Modified: utils/kamctl/postgres/presence-create.sql

---

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

---

diff --git a/utils/kamctl/db_sqlite/presence-create.sql b/utils/kamctl/db_sqlite/presence-create.sql
index 3ee28edca6..97cac9d6d4 100644
--- a/utils/kamctl/db_sqlite/presence-create.sql
+++ b/utils/kamctl/db_sqlite/presence-create.sql
@@ -77,7 +77,7 @@ CREATE TABLE xcap (
     domain VARCHAR(64) NOT NULL,
     doc BLOB NOT NULL,
     doc_type INTEGER NOT NULL,
-    etag VARCHAR(64) NOT NULL,
+    etag VARCHAR(128) NOT NULL,
     source INTEGER NOT NULL,
     doc_uri VARCHAR(255) NOT NULL,
     port INTEGER NOT NULL,
@@ -98,7 +98,7 @@ CREATE TABLE pua (
     expires INTEGER NOT NULL,
     desired_expires INTEGER NOT NULL,
     flag INTEGER NOT NULL,
-    etag VARCHAR(64) NOT NULL,
+    etag VARCHAR(128) NOT NULL,
     tuple_id VARCHAR(64),
     watcher_uri VARCHAR(128) NOT NULL,
     call_id VARCHAR(255) NOT NULL,
diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index 9fe9f1c732..a0b4097523 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -77,7 +77,7 @@ CREATE TABLE `xcap` (
     `domain` VARCHAR(64) NOT NULL,
     `doc` MEDIUMBLOB NOT NULL,
     `doc_type` INT(11) NOT NULL,
-    `etag` VARCHAR(64) NOT NULL,
+    `etag` VARCHAR(128) NOT NULL,
     `source` INT(11) NOT NULL,
     `doc_uri` VARCHAR(255) NOT NULL,
     `port` INT(11) NOT NULL,
@@ -98,7 +98,7 @@ CREATE TABLE `pua` (
     `expires` INT(11) NOT NULL,
     `desired_expires` INT(11) NOT NULL,
     `flag` INT(11) NOT NULL,
-    `etag` VARCHAR(64) NOT NULL,
+    `etag` VARCHAR(128) NOT NULL,
     `tuple_id` VARCHAR(64),
     `watcher_uri` VARCHAR(128) NOT NULL,
     `call_id` VARCHAR(255) NOT NULL,
diff --git a/utils/kamctl/oracle/presence-create.sql b/utils/kamctl/oracle/presence-create.sql
index 46361da72e..35a6f062ea 100644
--- a/utils/kamctl/oracle/presence-create.sql
+++ b/utils/kamctl/oracle/presence-create.sql
@@ -101,7 +101,7 @@ CREATE TABLE xcap (
     domain VARCHAR2(64),
     doc BLOB,
     doc_type NUMBER(10),
-    etag VARCHAR2(64),
+    etag VARCHAR2(128),
     source NUMBER(10),
     doc_uri VARCHAR2(255),
     port NUMBER(10),
@@ -130,7 +130,7 @@ CREATE TABLE pua (
     expires NUMBER(10),
     desired_expires NUMBER(10),
     flag NUMBER(10),
-    etag VARCHAR2(64),
+    etag VARCHAR2(128),
     tuple_id VARCHAR2(64),
     watcher_uri VARCHAR2(128),
     call_id VARCHAR2(255),
diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql
index b0c7939868..729fb6a37e 100644
--- a/utils/kamctl/postgres/presence-create.sql
+++ b/utils/kamctl/postgres/presence-create.sql
@@ -77,7 +77,7 @@ CREATE TABLE xcap (
     domain VARCHAR(64) NOT NULL,
     doc BYTEA NOT NULL,
     doc_type INTEGER NOT NULL,
-    etag VARCHAR(64) NOT NULL,
+    etag VARCHAR(128) NOT NULL,
     source INTEGER NOT NULL,
     doc_uri VARCHAR(255) NOT NULL,
     port INTEGER NOT NULL,
@@ -98,7 +98,7 @@ CREATE TABLE pua (
     expires INTEGER NOT NULL,
     desired_expires INTEGER NOT NULL,
     flag INTEGER NOT NULL,
-    etag VARCHAR(64) NOT NULL,
+    etag VARCHAR(128) NOT NULL,
     tuple_id VARCHAR(64),
     watcher_uri VARCHAR(128) NOT NULL,
     call_id VARCHAR(255) NOT NULL,




More information about the sr-dev mailing list