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=f2ffcfc6a74098b0df250771865c322c9502a643
Author: Marius Zbihlei<[email protected]>
Committer: Marius Zbihlei<[email protected]>
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
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla
http://www.asipto.com
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
