Hi Daniel,
Thanks a lot :-)
Regard,
/Kristian Høgh
On Thursday, February 2, 2017 1:46:12 PM CET Daniel-Constantin Mierla wrote:
Hello,
On 02/02/2017 13:00, Kristian F. Høgh wrote:
Hi list,
We provision our kamailio database from an external system.
In the future we would like to provision from two different systems.
To prevent the two systems from touching each others data, we would like to
create views from the two tables.
provision system 1 would write to table1
provision system 2 would write to table2
kamailio will read a view over the two tables.
The tables we will create views over are:
- address
- aliases
- dispatcher
- uri
- usr_preferences
Now to my question :-)
Does kamailio use the id field in any of the tables above?
The id's are auto-incremented, and we might get conflicts between table1 and
table2
In these tables, the id column is not used by kamailio. There are only
few modules using the id column, iirc, among them being those from lcr
module and msilo module. Cheers, Daniel
-- Daniel-Constantin Mierlawww.twitter.com/miconda[1] --
www.linkedin.com/in/miconda[2]Kamailio Advanced Training - Mar 6-8 (Europe) and
Mar 20-22 (USA) - www.asipto.com[3]Kamailio World Conference - May 8-10, 2017 -
www.kamailioworld.com[4]
--------
[1] http://www.twitter.com/miconda
[2] http://www.linkedin.com/in/miconda
[3] http://www.asipto.com
[4] http://www.kamailioworld.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
