[SR-Users] id column i tables

[Kristian F. Høgh]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170202/9fa42e1b/attachment.html>