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

[Александър Йосифов]

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> wrote:

> Hello Alexsandar,
>
> the process is like this:
>
>
>    - extend the XML db source definition in src/lib/srdb1/schema
>    - you 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> im Auftrag von
> Александър Йосифов <alexyosifov at gmail.com>
> *Gesendet:* Freitag, 14. Juni 2019 15:56
> *An:* 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/20190617/b12cc793/attachment.html>