Module: kamailio Branch: master Commit: aaabbc1adbd11724031c54137cd00ef01af3962a URL: https://github.com/kamailio/kamailio/commit/aaabbc1adbd11724031c54137cd00ef… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)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/aaabbc1adbd11724031c54137cd00ef… Patch: https://github.com/kamailio/kamailio/commit/aaabbc1adbd11724031c54137cd00ef… --- 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,