[sr-dev] git:master:7dd380af: kamctl: added new fields in ims_usrloc_pcscf db

Aleksandar Yosifov alexyosifov at gmail.com
Mon Jul 15 18:41:42 CEST 2019


Module: kamailio
Branch: master
Commit: 7dd380afaa5bee73a5bed1d928be38b8bb76fd99
URL: https://github.com/kamailio/kamailio/commit/7dd380afaa5bee73a5bed1d928be38b8bb76fd99

Author: Aleksandar Yosifov <alexyosifov at gmail.com>
Committer: Aleksandar Yosifov <alexyosifov at gmail.com>
Date: 2019-07-04T10:41:48+03:00

kamctl: added new fields in ims_usrloc_pcscf db

- Added new fields in mysql ims_usrloc_pcscf location table.
  There is no related xml file for this table in srdb2/schema,
  because of that I added the new fields directly in the sql file.

---

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

---

Diff:  https://github.com/kamailio/kamailio/commit/7dd380afaa5bee73a5bed1d928be38b8bb76fd99.diff
Patch: https://github.com/kamailio/kamailio/commit/7dd380afaa5bee73a5bed1d928be38b8bb76fd99.patch

---

diff --git a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
index 1240afab50..cf978df1f5 100644
--- a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('location','6');
+INSERT INTO version (table_name, table_version) values ('location','7');
 CREATE TABLE `location` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `domain` varchar(64) NOT NULL,
@@ -23,6 +23,8 @@ CREATE TABLE `location` (
   `ik` varchar(100) DEFAULT NULL,
   `ealg` char(20) DEFAULT NULL,
   `ialg` char(20) DEFAULT NULL,
+  `port_pc` int(11) unsigned DEFAULT NULL,
+  `port_ps` int(11) unsigned DEFAULT NULL,
   `port_uc` int(11) unsigned DEFAULT NULL,
   `port_us` int(11) unsigned DEFAULT NULL,
   `spi_pc` int(11) unsigned DEFAULT NULL,
@@ -30,6 +32,8 @@ CREATE TABLE `location` (
   `spi_uc` int(11) unsigned DEFAULT NULL,
   `spi_us` int(11) unsigned DEFAULT NULL,
   `t_security_type` int(11) DEFAULT NULL,
+  `t_port_pc` int(11) unsigned DEFAULT NULL,
+  `t_port_ps` int(11) unsigned DEFAULT NULL,
   `t_port_uc` int(11) unsigned DEFAULT NULL,
   `t_port_us` int(11) unsigned DEFAULT NULL,
   `t_spi_pc` int(11) unsigned DEFAULT NULL,




More information about the sr-dev mailing list