[sr-dev] git:3.1: utils/kamctl/presence-create. sql Increased size of contact and callid in presence tables

Marius Zbihlei marius.zbihlei at 1and1.ro
Wed Apr 27 10:56:14 CEST 2011


Module: sip-router
Branch: 3.1
Commit: ac679cf5093f99931da6aeea4b40c1215e295a4b
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ac679cf5093f99931da6aeea4b40c1215e295a4b

Author: Marius Zbihlei <marius.zbihlei at 1and1.ro>
Committer: Marius Zbihlei <marius.zbihlei at 1and1.ro>
Date:   Wed Apr 27 11:48:46 2011 +0300

utils/kamctl/presence-create.sql Increased size of contact and callid in presence tables

Some CPE (e.g. FritzBox,Samsung) issue larger contacts that 64 chars, thus resulting in a truncation in the
DB backend

---

 utils/kamctl/mysql/presence-create.sql |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index 6af8d0a..b764976 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -24,10 +24,10 @@ CREATE TABLE active_watchers (
     event_id VARCHAR(64),
     to_tag VARCHAR(64) NOT NULL,
     from_tag VARCHAR(64) NOT NULL,
-    callid VARCHAR(64) NOT NULL,
+    callid VARCHAR(128) NOT NULL,
     local_cseq INT(11) NOT NULL,
     remote_cseq INT(11) NOT NULL,
-    contact VARCHAR(64) NOT NULL,
+    contact VARCHAR(128) NOT NULL,
     record_route TEXT,
     expires INT(11) NOT NULL,
     status INT(11) DEFAULT 2 NOT NULL,
@@ -79,7 +79,7 @@ CREATE TABLE pua (
     etag VARCHAR(64) NOT NULL,
     tuple_id VARCHAR(64),
     watcher_uri VARCHAR(128) NOT NULL,
-    call_id VARCHAR(64) NOT NULL,
+    call_id VARCHAR(128) NOT NULL,
     to_tag VARCHAR(64) NOT NULL,
     from_tag VARCHAR(64) NOT NULL,
     cseq INT(11) NOT NULL,




More information about the sr-dev mailing list