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

Module: kamailio Branch: master Commit: 7dd380afaa5bee73a5bed1d928be38b8bb76fd99 URL: https://github.com/kamailio/kamailio/commit/7dd380afaa5bee73a5bed1d928be38b… Author: Aleksandar Yosifov <alexyosifov(a)gmail.com> Committer: Aleksandar Yosifov <alexyosifov(a)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/7dd380afaa5bee73a5bed1d928be38b… Patch: https://github.com/kamailio/kamailio/commit/7dd380afaa5bee73a5bed1d928be38b… --- 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,