You should change first the xml files defining the tables located in lib/srdb1/schema/

Then run 'make dbschema' to regenerate the sql files.

Cheers, Daniel

On 4/27/11 11:07 AM, Marius Zbihlei wrote:

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

Author: Marius Zbihleimarius.zbihlei@1and1.ro Committer: Marius Zbihleimarius.zbihlei@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 (cherry picked from commit ac679cf5093f99931da6aeea4b40c1215e295a4b)

---

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,

---

sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev