[sr-dev] Adding new fields in pcscf.location table

[Henning Westerholt]

Hello,

try to grep the table name in the XML. You should be able to find it.

Editing the generated SQL files will only work for your local deployment, as they will get overwritten by the next change in the repository.

Cheers,

Henning


--
Henning Westerholt - https://skalatan.de/blog/
Kamailio services - https://skalatan.de/services



Von: Александър Йосифов
Gesendet: Montag, 17. Juni, 15:38
Betreff: Re: [sr-dev] Adding new fields in pcscf.location table
An: Henning Westerholt
Cc: sr-dev at lists.kamailio.org


Hi,
Thank you for the quick response!
I couldn't find the xml file for ims p-cscf user location table in src/lib/srdb1/schema, but I found ims_usrloc_pcscf-create.sql file in utils/kamctl/mysql folder.
Is it enough and correct to edit this file with the new fields and incremented table version?


On Sat, 15 Jun 2019 at 11:37, Henning Westerholt <hw at skalatan.de<mailto:hw at skalatan.de>> wrote:
Hello Alexsandar,

the process is like this:

extend the XML db source definition in src/lib/srdb1/schemayou will find some general size/type definitions in the entities.xml file, please use them if possible
increment the version number for this particular table in the XML as well
you can create the DB specific files locally (needs xsltproc) with "make dbschema"check for the new table version number in the module coding
extend the module code to actually use the new fields
creating a pull request with the XML and coding changes to integrate it into git master
For bigger extensions it might also a good idea to contact the module author to receive some feedback before finishing the implementation. 🙂

Cheers,

Henning
Von: sr-dev <sr-dev-bounces at lists.kamailio.org<mailto:sr-dev-bounces at lists.kamailio.org>> im Auftrag von Александър Йосифов <alexyosifov at gmail.com<mailto:alexyosifov at gmail.com>>
Gesendet: Freitag, 14. Juni 2019 15:56
An: sr-dev at lists.kamailio.org<mailto:sr-dev at lists.kamailio.org>
Betreff: [sr-dev] Adding new fields in pcscf.location table

Hello,
What is the procedure for adding new fields in some DB table?
In particular, I am working under a feature for multiple tcp connections for IPSEC in P-CSCF and for this purpose new fields are needed to store pcscf client and server ports for each registered contact.
The new fields 'port_pc', 'port_ps', 't_port_pc' and 't_port_ps' should be added in pcscf.location table.

Thank you for your help!


--
Best Regards,
Aleksandar Yosifov


--
Best Regards,
Aleksandar Yosifov


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20190620/50922b16/attachment-0001.html>