[sr-dev] git:3.1: Fixed definitions for presence related tables. Size of callid and contact should be larger than 64.

[Marius Zbihlei]

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

Author: Marius Zbihlei <marius.zbihlei at 1and1.ro>
Committer: Marius Zbihlei <marius.zbihlei at 1and1.ro>
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,