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: [email protected] 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> im Auftrag von Александър Йосифов <[email protected]<mailto:[email protected]>> Gesendet: Freitag, 14. Juni 2019 15:56 An: [email protected]<mailto:[email protected]> 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
_______________________________________________ Kamailio (SER) - Development Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev
