[sr-dev] git:master:56bc84cb: modules/ims_usrloc_scscf: modify sql creation script to extend some fields

Richard Good richard.good at smilecoms.com
Tue Oct 18 09:57:25 CEST 2016


Module: kamailio
Branch: master
Commit: 56bc84cb700bb90cfd0916839f81dcef064c16eb
URL: https://github.com/kamailio/kamailio/commit/56bc84cb700bb90cfd0916839f81dcef064c16eb

Author: Richard Good <richard.good at smilecoms.com>
Committer: Richard Good <richard.good at smilecoms.com>
Date: 2016-10-18T09:55:47+02:00

modules/ims_usrloc_scscf: modify sql creation script to extend some fields

watcher_uri, watcher_contact, presentity_uri extended from varchar(50) to varchar(100) as these can exceed 50

---

Modified: utils/kamctl/mysql/ims_usrloc_scscf-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/56bc84cb700bb90cfd0916839f81dcef064c16eb.diff
Patch: https://github.com/kamailio/kamailio/commit/56bc84cb700bb90cfd0916839f81dcef064c16eb.patch

---

diff --git a/utils/kamctl/mysql/ims_usrloc_scscf-create.sql b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
index 51cd30b..ae7bd93 100644
--- a/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
@@ -39,9 +39,9 @@ CREATE TABLE `impu_contact` (
 INSERT INTO version (table_name, table_version) values ('subscriber','6');
 CREATE TABLE `subscriber` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
-  `watcher_uri` varchar(50) NOT NULL,
-  `watcher_contact` varchar(50) NOT NULL,
-  `presentity_uri` varchar(50) NOT NULL,
+  `watcher_uri` varchar(100) NOT NULL,
+  `watcher_contact` varchar(100) NOT NULL,
+  `presentity_uri` varchar(100) NOT NULL,
   `event` int(11) NOT NULL,
   `expires` datetime NOT NULL,
   `version` int(11) NOT NULL,




More information about the sr-dev mailing list