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]> 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 <[email protected]> im Auftrag von > Александър Йосифов <[email protected]> > *Gesendet:* Freitag, 14. Juni 2019 15:56 > *An:* [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
