2010/5/8 Juha Heinanen jh@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 writes:

Could I get into problems if I remove such UNIQUE key (gw_name column) in "gw" table and create two entries with same "gw_name"? (kamailio 1.5.4).

gw_name is not used by lcr module. it is for information only. you can change the index.

-- juha