Re: [SR-Users] id column i tables

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