[SR-Users] id column i tables

[Kristian F. Høgh]

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


*Kristian Høgh*
 

 
Telefon: 4422 8822
support at uni-tel.dk[1]
 
Gydevang 19 | 3450 Allerød
www.uni-tel.dk [2]

--------
[1] mailto:support at uni-tel.dk
[2] http://www.uni-tel.dk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170202/0a39fa6f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mail-logo.png
Type: image/png
Size: 11620 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170202/0a39fa6f/attachment.png>