[sr-dev] git:master: Increase callid length to varchar(255) in acc table.

Jon Bonilla manwe at aholab.ehu.es
Thu Jun 30 18:38:26 CEST 2011


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

Author: Jon Bonilla <manwe at aholab.ehu.es>
Committer: Jon Bonilla <manwe at aholab.ehu.es>
Date:   Thu Jun 30 18:36:37 2011 +0200

Increase callid length to varchar(255) in acc table.

---

 lib/srdb1/schema/acc.xml                  |    2 +-
 utils/kamctl/db_berkeley/kamailio/version |    8 ++------
 utils/kamctl/db_sqlite/acc-create.sql     |    2 +-
 utils/kamctl/dbtext/kamailio/version      |    4 +---
 utils/kamctl/mysql/acc-create.sql         |    2 +-
 utils/kamctl/oracle/acc-create.sql        |    2 +-
 utils/kamctl/postgres/acc-create.sql      |    2 +-
 7 files changed, 8 insertions(+), 14 deletions(-)

diff --git a/lib/srdb1/schema/acc.xml b/lib/srdb1/schema/acc.xml
index 3d3d344..cabe9ba 100644
--- a/lib/srdb1/schema/acc.xml
+++ b/lib/srdb1/schema/acc.xml
@@ -54,7 +54,7 @@
         <name>callid</name>
         <type>string</type>
         <natural/>
-        <size>&domain_len;</size>
+        <size>&description_len;</size>
         <default/>
         <description>Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. </description>
     </column>
diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index c533ac2..6c2ac06 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -16,10 +16,10 @@ address|
 address|4
 aliases|
 aliases|1004
-carrier_name|
-carrier_name|1
 carrierfailureroute|
 carrierfailureroute|2
+carrier_name|
+carrier_name|1
 carrierroute|
 carrierroute|3
 cpl|
@@ -68,8 +68,6 @@ matrix|
 matrix|1
 missed_calls|
 missed_calls|3
-mtree|
-mtree|1
 pdt|
 pdt|1
 presentity|
@@ -94,8 +92,6 @@ subscriber|
 subscriber|6
 trusted|
 trusted|5
-uacreg|
-uacreg|1
 uri|
 uri|1
 userblacklist|
diff --git a/utils/kamctl/db_sqlite/acc-create.sql b/utils/kamctl/db_sqlite/acc-create.sql
index 4d23363..09b0da3 100644
--- a/utils/kamctl/db_sqlite/acc-create.sql
+++ b/utils/kamctl/db_sqlite/acc-create.sql
@@ -4,7 +4,7 @@ CREATE TABLE acc (
     method VARCHAR(16) DEFAULT '' NOT NULL,
     from_tag VARCHAR(64) DEFAULT '' NOT NULL,
     to_tag VARCHAR(64) DEFAULT '' NOT NULL,
-    callid VARCHAR(64) DEFAULT '' NOT NULL,
+    callid VARCHAR(255) DEFAULT '' NOT NULL,
     sip_code VARCHAR(3) DEFAULT '' NOT NULL,
     sip_reason VARCHAR(32) DEFAULT '' NOT NULL,
     time TIMESTAMP WITHOUT TIME ZONE NOT NULL
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 4410f97..1bd5e62 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -3,8 +3,8 @@ acc:4
 active_watchers:9
 address:4
 aliases:1004
-carrier_name:1
 carrierfailureroute:2
+carrier_name:1
 carrierroute:3
 cpl:1
 dbaliases:1
@@ -29,7 +29,6 @@ lcr_rule_target:1
 location:1004
 matrix:1
 missed_calls:3
-mtree:1
 pdt:1
 presentity:3
 pua:6
@@ -42,7 +41,6 @@ sip_trace:2
 speed_dial:2
 subscriber:6
 trusted:5
-uacreg:1
 uri:1
 userblacklist:1
 usr_preferences:2
diff --git a/utils/kamctl/mysql/acc-create.sql b/utils/kamctl/mysql/acc-create.sql
index 17f272c..7a2fafa 100644
--- a/utils/kamctl/mysql/acc-create.sql
+++ b/utils/kamctl/mysql/acc-create.sql
@@ -4,7 +4,7 @@ CREATE TABLE acc (
     method VARCHAR(16) DEFAULT '' NOT NULL,
     from_tag VARCHAR(64) DEFAULT '' NOT NULL,
     to_tag VARCHAR(64) DEFAULT '' NOT NULL,
-    callid VARCHAR(64) DEFAULT '' NOT NULL,
+    callid VARCHAR(255) DEFAULT '' NOT NULL,
     sip_code VARCHAR(3) DEFAULT '' NOT NULL,
     sip_reason VARCHAR(32) DEFAULT '' NOT NULL,
     time DATETIME NOT NULL
diff --git a/utils/kamctl/oracle/acc-create.sql b/utils/kamctl/oracle/acc-create.sql
index fbcb946..c9c4b75 100644
--- a/utils/kamctl/oracle/acc-create.sql
+++ b/utils/kamctl/oracle/acc-create.sql
@@ -4,7 +4,7 @@ CREATE TABLE acc (
     method VARCHAR2(16) DEFAULT '',
     from_tag VARCHAR2(64) DEFAULT '',
     to_tag VARCHAR2(64) DEFAULT '',
-    callid VARCHAR2(64) DEFAULT '',
+    callid VARCHAR2(255) DEFAULT '',
     sip_code VARCHAR2(3) DEFAULT '',
     sip_reason VARCHAR2(32) DEFAULT '',
     time DATE
diff --git a/utils/kamctl/postgres/acc-create.sql b/utils/kamctl/postgres/acc-create.sql
index b8e1f53..4e4c252 100644
--- a/utils/kamctl/postgres/acc-create.sql
+++ b/utils/kamctl/postgres/acc-create.sql
@@ -4,7 +4,7 @@ CREATE TABLE acc (
     method VARCHAR(16) DEFAULT '' NOT NULL,
     from_tag VARCHAR(64) DEFAULT '' NOT NULL,
     to_tag VARCHAR(64) DEFAULT '' NOT NULL,
-    callid VARCHAR(64) DEFAULT '' NOT NULL,
+    callid VARCHAR(255) DEFAULT '' NOT NULL,
     sip_code VARCHAR(3) DEFAULT '' NOT NULL,
     sip_reason VARCHAR(32) DEFAULT '' NOT NULL,
     time TIMESTAMP WITHOUT TIME ZONE NOT NULL




More information about the sr-dev mailing list