[SR-Users] [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?

Iñaki Baz Castillo ibc at aliax.net
Sat May 8 22:19:42 CEST 2010


2010/5/8 Juha Heinanen <jh at tutpro.com>:
> Iñaki Baz Castillo writes:
>
>  > Why is it an UNIQUE key? It makes things complex when I want to create
>  > another gateway with same IP and port (but belonging to a different
>  > grp_id). I still want to name it with the same name (an internal
>  > domain for example).
>
> which version? in 3.0:
>
>  UNIQUE KEY `lcr_id_grp_id_gw_name_idx` (`lcr_id`,`grp_id`,`gw_name`),
>  UNIQUE KEY `lcr_id_grp_id_ip_addr_hostname_idx`
>  (`lcr_id`,`grp_id`,`ip_addr`,`hostname`)


Sorry, I mean kamailio 1.5.4:

  PRIMARY KEY  (`id`),
  UNIQUE KEY `gw_name_idx` (`gw_name`),
  KEY `grp_id_idx` (`grp_id`)




-- 
Iñaki Baz Castillo
<ibc at aliax.net>



More information about the sr-users mailing list