Module: sip-router Branch: 3.1 Commit: e3f8cf21c9bb601ad08e8069bc2f31ae3b6ccd20 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e3f8cf2… Author: Marius Zbihlei &lt;marius.zbihlei(a)1and1.ro&gt; Committer: Marius Zbihlei &lt;marius.zbihlei(a)1and1.ro&gt; Date: Wed Apr 27 13:26:13 2011 +0300 Fixed definitions for presence related tables. Size of callid and contact should be larger than 64. (cherry picked from commit 5af83d0a629cf51344b2ba01b7219c3a507bd225) --- lib/srdb1/schema/pr_active_watchers.xml | 4 ++-- lib/srdb1/schema/pr_pua.xml | 2 +- utils/kamctl/oracle/presence-create.sql | 6 +++--- utils/kamctl/postgres/presence-create.sql | 6 +++--- 4 files changed, 9 insertions(+), 9 deletions(-) diff --git a/lib/srdb1/schema/pr_active_watchers.xml b/lib/srdb1/schema/pr_active_watchers.xml index 2cfdcff..8c27d56 100644 --- a/lib/srdb1/schema/pr_active_watchers.xml +++ b/lib/srdb1/schema/pr_active_watchers.xml @@ -96,7 +96,7 @@ <column id="callid"> <name>callid</name> <type>string</type> - <size>&domain_len;</size> + <size>&uri_len;</size> <description>Call ID</description> </column> @@ -117,7 +117,7 @@ <column> <name>contact</name> <type>string</type> - <size>&domain_len;</size> + <size>&uri_len;</size> <description>Contact</description> </column> diff --git a/lib/srdb1/schema/pr_pua.xml b/lib/srdb1/schema/pr_pua.xml index 21930c4..e5a21fe 100644 --- a/lib/srdb1/schema/pr_pua.xml +++ b/lib/srdb1/schema/pr_pua.xml @@ -95,7 +95,7 @@ <column> <name>call_id</name> <type>string</type> - <size>&domain_len;</size> + <size>&uri_len;</size> <description>Call ID</description> </column> diff --git a/utils/kamctl/oracle/presence-create.sql b/utils/kamctl/oracle/presence-create.sql index 6e6daf2..b0ce5ee 100644 --- a/utils/kamctl/oracle/presence-create.sql +++ b/utils/kamctl/oracle/presence-create.sql @@ -32,10 +32,10 @@ CREATE TABLE active_watchers ( event_id VARCHAR2(64), to_tag VARCHAR2(64), from_tag VARCHAR2(64), - callid VARCHAR2(64), + callid VARCHAR2(128), local_cseq NUMBER(10), remote_cseq NUMBER(10), - contact VARCHAR2(64), + contact VARCHAR2(128), record_route CLOB, expires NUMBER(10), status NUMBER(10) DEFAULT 2 NOT NULL, @@ -111,7 +111,7 @@ CREATE TABLE pua ( etag VARCHAR2(64), tuple_id VARCHAR2(64), watcher_uri VARCHAR2(128), - call_id VARCHAR2(64), + call_id VARCHAR2(128), to_tag VARCHAR2(64), from_tag VARCHAR2(64), cseq NUMBER(10), diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql index 9da0eb2..37c8feb 100644 --- a/utils/kamctl/postgres/presence-create.sql +++ b/utils/kamctl/postgres/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 INTEGER NOT NULL, remote_cseq INTEGER NOT NULL, - contact VARCHAR(64) NOT NULL, + contact VARCHAR(128) NOT NULL, record_route TEXT, expires INTEGER NOT NULL, status INTEGER 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 INTEGER NOT NULL,