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

Module: sip-router Branch: master Commit: 3d9ea85fcce4a05b40a11928d087a4954f6451e1 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3d9ea85… Author: pd &lt;peter.dunkley(a)crocodile-rcs.com&gt; Committer: pd &lt;peter.dunkley(a)crocodile-rcs.com&gt; 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,