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 Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com