[sr-dev] git:master: pua(k): increased the size of pres_id in the database table

Peter Dunkley peter.dunkley at crocodile-rcs.com
Thu Jul 21 15:51:52 CEST 2011


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

Author: pd <peter.dunkley at crocodile-rcs.com>
Committer: pd <peter.dunkley at crocodile-rcs.com>
Date:   Thu Jul 21 14:48:10 2011 +0100

pua(k): increased the size of pres_id in the database table

- the pua pres_id table field is used as the subsid in rls.  The pres_id
  was originally a 64 character field, but an rls subsid (consisting of
  Call-ID, To tag, and From tag) can easily exceed this.

---

 lib/srdb1/schema/pr_pua.xml                |    2 +-
 utils/kamctl/db_sqlite/presence-create.sql |    2 +-
 utils/kamctl/mysql/presence-create.sql     |    2 +-
 utils/kamctl/oracle/presence-create.sql    |    2 +-
 utils/kamctl/postgres/presence-create.sql  |    2 +-
 5 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/lib/srdb1/schema/pr_pua.xml b/lib/srdb1/schema/pr_pua.xml
index e5a21fe..55b4767 100644
--- a/lib/srdb1/schema/pr_pua.xml
+++ b/lib/srdb1/schema/pr_pua.xml
@@ -37,7 +37,7 @@
     <column>
         <name>pres_id</name>
         <type>string</type>
-        <size>&domain_len;</size>
+        <size>255</size>
         <description>ID</description>
     </column>
 
diff --git a/utils/kamctl/db_sqlite/presence-create.sql b/utils/kamctl/db_sqlite/presence-create.sql
index 602c993..c2bedf4 100644
--- a/utils/kamctl/db_sqlite/presence-create.sql
+++ b/utils/kamctl/db_sqlite/presence-create.sql
@@ -71,7 +71,7 @@ INSERT INTO version (table_name, table_version) values ('pua','6');
 CREATE TABLE pua (
     id INTEGER PRIMARY KEY NOT NULL,
     pres_uri VARCHAR(128) NOT NULL,
-    pres_id VARCHAR(64) NOT NULL,
+    pres_id VARCHAR(255) NOT NULL,
     event INTEGER NOT NULL,
     expires INTEGER NOT NULL,
     desired_expires INTEGER NOT NULL,
diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index 40a4189..740149b 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -71,7 +71,7 @@ INSERT INTO version (table_name, table_version) values ('pua','6');
 CREATE TABLE pua (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     pres_uri VARCHAR(128) NOT NULL,
-    pres_id VARCHAR(64) NOT NULL,
+    pres_id VARCHAR(255) NOT NULL,
     event INT(11) NOT NULL,
     expires INT(11) NOT NULL,
     desired_expires INT(11) NOT NULL,
diff --git a/utils/kamctl/oracle/presence-create.sql b/utils/kamctl/oracle/presence-create.sql
index 2b5cc24..5c6e1f2 100644
--- a/utils/kamctl/oracle/presence-create.sql
+++ b/utils/kamctl/oracle/presence-create.sql
@@ -103,7 +103,7 @@ INSERT INTO version (table_name, table_version) values ('pua','6');
 CREATE TABLE pua (
     id NUMBER(10) PRIMARY KEY,
     pres_uri VARCHAR2(128),
-    pres_id VARCHAR2(64),
+    pres_id VARCHAR2(255),
     event NUMBER(10),
     expires NUMBER(10),
     desired_expires NUMBER(10),
diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql
index 00daa93..3b2608c 100644
--- a/utils/kamctl/postgres/presence-create.sql
+++ b/utils/kamctl/postgres/presence-create.sql
@@ -71,7 +71,7 @@ INSERT INTO version (table_name, table_version) values ('pua','6');
 CREATE TABLE pua (
     id SERIAL PRIMARY KEY NOT NULL,
     pres_uri VARCHAR(128) NOT NULL,
-    pres_id VARCHAR(64) NOT NULL,
+    pres_id VARCHAR(255) NOT NULL,
     event INTEGER NOT NULL,
     expires INTEGER NOT NULL,
     desired_expires INTEGER NOT NULL,




More information about the sr-dev mailing list