[SR-Users] id column i tables

[Daniel-Constantin Mierla]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170202/92572afb/attachment.html>